CA_EMAIL_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	CA_COMP_NAME	Character(4)	VARCHAR2(4) NOT NULL	Component AMDT=Amendment AP=Revenue Recognition Plan BP=Billing Plan HDR=Contract LINE=Contract Line MS=Contract Milestone
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
6	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
7	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
8	MS_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Milestone Number
9	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
10	SEQUENCE_5	Number(5,0)	INTEGER NOT NULL	Sequnece Number of Length 5
11	STATUS_NEW	Character(3)	VARCHAR2(3) NOT NULL	New Status
12	STATUS_OLD	Character(3)	VARCHAR2(3) NOT NULL	Old Status
13	CA_STATUS_GENERIC	Character(24)	VARCHAR2(24) NOT NULL	Contract Status
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
16	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	DONE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Done Flag