CA_LMT_FEE_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	AWARDED_BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Awarded Base/Cost/T&M Amount
4	AWARDED_FEE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Awarded Fee Amount
5	LIMIT_AMT_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded/Billing Limit Amount
6	LIMIT_AMT_REV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Limit Amount
7	LIMIT_FEE_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Fee Limit Amount
8	FEE_PCT_BIL	Number(12,8)	DECIMAL(11,8) NOT NULL	Billing Fee Percent
9	FEE_OPT_AAWD	Character(1)	VARCHAR2(1) NOT NULL	Additional Award Option A=Amount P=Percent Default Value: P
10	FEE_PCT_AAWD	Number(12,8)	DECIMAL(11,8) NOT NULL	Additional Award Percent
11	FEE_AMT_AAWD_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Funded /Billing Award Amount
12	FEE_PCT_CST_U_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Cost Percent Underrun
13	FEE_PCT_CST_O_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Cost Share Percent Overrun
14	FEE_PCT_TARGET_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Target Fee Percent
15	FEE_PCT_MIN_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Minimum Fee Percent
16	FEE_PCT_MAX_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Maximum Fee Percent
17	FEE_AMT_OTH_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Other Billing Fee Amount
18	LMT_PROC_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Processed Amount
19	LMT_PROC_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Processed Amount
20	LMT_EXCESS_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Excess Amount
21	LMT_EXCESS_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Excess Amount
22	LMT_LAST_PROC_DT_B	Date(10)	DATE	Last Funded / Billing Processed Date
23	LMT_LAST_PROC_DT_R	Date(10)	DATE	Last Revenue Processed Date
24	LMT_LAST_TXN_DT_B	Date(10)	DATE	Last Funded / Billing Transaction Date
25	LMT_LAST_TXN_DT_R	Date(10)	DATE	Last Revenue Transaction Date
26	LIMIT_RCHD_DT_BIL	Date(10)	DATE	Date Funded / Billing Limit Reached Date
27	LIMIT_RCHD_DT_REV	Date(10)	DATE	Date Revenue Limit Reached
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_DETAIL.CURRENCY_CD
29	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
30	CHG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied. C=Complete P=Pending R=Ready X=Cancelled