CA_PPD_UTLTAO2A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
3	TRANS_TYPE_BI	Character(4)	VARCHAR2(4) NOT NULL	Transaction Type AE=Accounting Entry AHDR=Adjustment Header DDS=Deferred Discount/Surcharge DS=Discount/Surcharge EXSD=Indian Excise/Sales Tax Detail LINE=Chargeable Line NOTE=Note/Comment TAX=Sales/Use Tax Detail
4	TRANS_TYPE_BI_SEQ	Number(3,0)	SMALLINT NOT NULL	Transaction Type Seq 010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0
5	PREPAID_USE_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Use Sequence
6	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
7	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
8	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
9	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
10	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code