CA_CHG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
3	CHG_EDIT	Character(3)	VARCHAR2(3) NOT NULL	This field is to indicate how the record in the mirror table is to be applied back to the base record. Translate values include INS, UPD, and BSE DEL=Delete Record INS=Insert Record UPD=Update Record
4	DBRECNM	Character(15)	VARCHAR2(15) NOT NULL	Record Name
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
7	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	CA_PGP_SEQ	Number(3,0)	SMALLINT NOT NULL	Progress Payment Sequence
10	OLDVALUE	Character(65)	VARCHAR2(65) NOT NULL	Old Value
11	NEWVALUE	Character(65)	VARCHAR2(65) NOT NULL	New Value
12	GROSS_CHANGE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Negotiated Amount
13	REDUCT_CHANGE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Change
14	CA_AP_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Plan Template
15	CA_BP_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Plan Template
16	BP_DTL_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Plan Detail Template ID
17	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer
18	CHG_BIL_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Adjust Billing Retroactively
19	CHG_REV_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Adjust Revenue Retroactively
20	CHG_REVERSE_AMT	Character(1)	VARCHAR2(1) NOT NULL	Reverse Amounts
21	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence