CA_AP_FEE_WS_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
4	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
5	LIMIT_FEE_REV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Fee Limit Amount
6	FEE_PCT_REV	Number(12,8)	DECIMAL(11,8) NOT NULL	Revenue Fee Percent
7	FEE_AMT_AAWD_REV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Revenue Award Amount
8	FEE_PCT_AAWD	Number(12,8)	DECIMAL(11,8) NOT NULL	Additional Award Percent
9	CA_FEE_AMT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Amount source option field used in Billing/Revenue Fee Worksheet pages. O=Override P=Proposed Default Value: P
10	FEE_AMT_OVRD	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fee Amount Override.
11	ACCOUNTING_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Accounting Date Option P=Processing Date U=User Define Default Value: P
12	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %date
13	AUTO_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Auto Process field used in Billing/Revenue Fee Worksheet pages. Y/N Table Edit Default Value: Y
14	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	REQ_AMEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Require Amendment Flag Default Value: N