CA_AP_EVT_CHG

(SQL Table)

# 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 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number

4 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.

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

6 AP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=Pending
PRG=In Progress
RDY=Ready
RIN=Reversal Initiated
RIP=Reversal In Progress
RVS=Reversed
Default Value: RDY

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

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

#	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	EVENT_NUM	Number(3,0)	SMALLINT NOT NULL	Event Number
4	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	AP_EVENT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Event Status CAN=Cancelled DON=Completed HLD=Hold Event NEW=Pending PRG=In Progress RDY=Ready RIN=Reversal Initiated RIP=Reversal In Progress RVS=Reversed Default Value: RDY
7	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code