UPGCA_UAR_TAO

#	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	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
4	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number
5	EVENT_OCCURRENCE	Number(3,0)	SMALLINT NOT NULL	Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
6	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
7	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
10	CA_PERCENTAGE	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Percentage
11	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	EFFDT_USED	Date(10)	DATE	Effective Date
14	REV_RECOG_METHOD	Character(4)	VARCHAR2(4) NOT NULL	Revenue Recognition Method 1=As Incurred 2=Apportionment 3=Percent Complete 4=Milestone 5=Billing Manages Revenue