CA_AP_EVENT_DTL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

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 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER

7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

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

10 MOVEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal

11 RVSL_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Reversing Entry
0=Not Reversed (Reversible)
0=Not Reversed (Reversible)
1=Reversed Line
1=Reversed Line
2=Reversing Line (Not Rvsible)
2=Reversing Line (Not Rvsible)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
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	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
7	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
8	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
11	RVSL_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Reversing Entry 0=Not Reversed (Reversible) 0=Not Reversed (Reversible) 1=Reversed Line 1=Reversed Line 2=Reversing Line (Not Rvsible) 2=Reversing Line (Not Rvsible)