CNTRCT_MGR_WS1

(SQL Table)
Index Back

Contract Manager Workscroll

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
6 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
8 INVOICE_DT Date(10) DATE Invoice Date
9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 XFER_SELECT Character(1) VARCHAR2(1) NOT NULL Transfer Select

Y/N Table Edit

Default Value: N

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code