CA_RECON_SUM

#	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	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	BILLED_AMT_CA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed Amount
10	BILLABLE_AMT_CA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbilled Billable Amount
11	BILLED_ADJ_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed adjustment amount
12	BI_DFR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billing Contract Liability Amt
13	BI_OLT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billing Over the Limit Amount
14	REV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reveune Amount
15	REV_UNREC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unrecognized Revenue Amount
16	REV_OLT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Over the Limit Amount
17	RETAINAGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Retainage Amount
18	RET_RELEASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Retainage Release Amount
19	RET_WRITEOFF_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Retainage Written Off Amount
20	WTHD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Amount
21	WTHD_RELEASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Release Amount
22	WTHD_WRITEOFF_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Written Off Amount
23	BI_FEE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billing Fee Amount
24	BI_FEE_ACCRUED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billing Fee Accrued Amount
25	REV_FEE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Fee Amount
26	REV_FEE_ACCRUED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Fee Accrued Amount
27	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
28	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
29	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
30	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
31	CONTRACT_ADMIN	Character(40)	VARCHAR2(40) NOT NULL	Contract Administrator defined on CABU.
32	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
33	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager
34	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID
35	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.