AR_CFOLOAD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency
3	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
4	CONTROL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8	CORPORATE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Corporate Customer
9	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
10	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
11	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
12	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
13	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
14	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
15	FROM_DATE	Date(10)	DATE	From Date
16	TO_DATE	Date(10)	DATE	To Date
17	REQUIRE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Require Reason
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days
20	CUTOFF_DT	Date(10)	DATE	The settlement cutoff date for a given bank/counterparty.
21	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
22	AGING_ID	Character(5)	VARCHAR2(5) NOT NULL	Aging ID
23	AR_COMP_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	AR Comparison Period: used for pagelets to describe comparison periods. P=Prior Period Y=Prior Year
24	AE_WHERE	Character(254)	VARCHAR2(254) NOT NULL	AE Generic Where Clause
25	SQL_STMT_254	Character(254)	VARCHAR2(254) NOT NULL	An internal work field that contains SQL text that is to be utilized in treasury application p
26	AE_WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Dynamic where clause
27	AE_WHERE_CF	Long Character(1024)	VARCHAR2(1024)	AE CF Where Clause
28	FIELD_LIST	Long Character(4000)	CLOB	Field List
29	AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
30	AGING_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Aging Category
31	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
32	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
33	COUNT_2	Number(3,0)	SMALLINT NOT NULL	Count Work Field
34	AMT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount1
35	AMT_2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount2
36	TOTAL_INVOICED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Invoiced
37	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
38	DAYS_LATE	Signed Number(7,0)	DECIMAL(6) NOT NULL	Days Late
39	PERIOD_COUNTER	Number(7,0)	INTEGER NOT NULL	PERIOD COUNTER
40	DEDUCTION_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Deduction Status C=Closed I=In Process O=Created/Opened W=On Worksheet