UPGCA_LN_EV_TAO

(SQL Table)
Index Back

Upgrade: Line-Event Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
4 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
5 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount