CA_LIMITS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	RETAINAGE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Reduce by retainage first
5	RETAINAGE_OPT2	Character(1)	VARCHAR2(1) NOT NULL	Apply retainage upon release
6	BUS_UNIT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Business Unit Name
7	SOURCE_TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Source Table Name
8	CA_PRC_BILLING	Character(1)	VARCHAR2(1) NOT NULL	Process Billing - Checkbox Used in Contracts Limits Run Control page.
9	CA_PRC_REVENUE	Character(1)	VARCHAR2(1) NOT NULL	Process Revenue - Checkbox Used in Contracts Limits Run Control page.
10	CA_RECALC_TOT	Character(1)	VARCHAR2(1) NOT NULL	Recalculate Totals Only - Checkbox Used in Contracts Limits Run Control page.
11	CA_LMT_CALL	Character(1)	VARCHAR2(1) NOT NULL	Limits Process Calling Program O=Online P=PC Pricing R=Billing Interface - Retainage S=Standalone
12	CURR_TRANS_DATE	Character(3)	VARCHAR2(3) NOT NULL	Date Type ACT=Accounting Date TRN=Transaction Date
13	CA_TMP_TBL	Character(1)	VARCHAR2(1) NOT NULL	Temporary Tables ? Y/N Table Edit
14	GVC	Character(1)	VARCHAR2(1) NOT NULL	Government Contracts
15	SPLIT_LINE	Character(1)	VARCHAR2(1) NOT NULL	Split Line
16	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
17	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
18	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
19	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
20	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
21	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
22	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer
23	CONTRACT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
24	LIMIT_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Limit Amount
25	LMT_PRCS1_WRK	Character(1)	VARCHAR2(1) NOT NULL	Limit Process Work Field It shows the status of a transaction inserted into an output table. C=Changed N=New S=Same
26	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
27	CA_INS_PRROWS	Character(1)	VARCHAR2(1) NOT NULL	Work field - Contracts - Limits
28	CA_DEL_PRROWS	Character(1)	VARCHAR2(1) NOT NULL	Work field - Contracts - Limits
29	CA_LMT_PRJRSRC	Character(1)	VARCHAR2(1) NOT NULL	Upd Project Resource/Summary
30	CA_USE_RUNCNTRL	Character(1)	VARCHAR2(1) NOT NULL	Used by the Limits Process To use Run Control or run process based on the State Table fields ?
31	RATE_DEF_BIL	Character(1)	VARCHAR2(1) NOT NULL	Rate Definition to track billing rates.
32	RATE_DEF_REV	Character(1)	VARCHAR2(1) NOT NULL	Rate Definition to track revenue rates.
33	PC_SWITCH_1	Character(1)	VARCHAR2(1) NOT NULL	Reprice Rows?
34	RETAINAGE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Retainage Percentage
35	DISCOUNT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Discount Percentage
36	RETAINAGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Retainage Amount
37	DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
38	CONTRACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
39	WHERE_CLAUSE_PC1	Long Character(4000)	CLOB	Field to save a dynamic WHERE CLAUSE used in Projects batch processes.
40	ENABLE_SUMM_LIMITS	Character(1)	VARCHAR2(1) NOT NULL	Field to Specify to enable Summary Limits for Government Contracts. N=No Y=Yes
41	SEPARATE_BIL_REV	Character(1)	VARCHAR2(1) NOT NULL	Flag used by Governement Contracts to separate Billing and Revenue transactions
42	PRC_ORD_TMPL_ID	Character(25)	VARCHAR2(25) NOT NULL	Processsing Order Template ID
43	PRC_ORD_TMPL_SQLNM	Character(30)	VARCHAR2(30) NOT NULL	Processing Order Template SQL Name. TMPL$