AR_RISK_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RISK_SCORE_ELEMENT	Character(18)	VARCHAR2(18) NOT NULL	Risk Scoring Element
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
5	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.
6	RISK_SCORE_ID	Character(5)	VARCHAR2(5) NOT NULL	Risk Score ID
7	RISK_SCORE_GRP	Character(1)	VARCHAR2(1) NOT NULL	Risk Scoring Group 2=System Defined History 3=User-defined History 4=Aging Information 5=Item Information 6=Customer Activity 7=Customer Table 8=Customer D&B Table
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
10	ANCHOR_DATE	Date(10)	DATE	Anchor Date
11	ANCHOR_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.
12	DATE_PROCESSED	DateTime(26)	TIMESTAMP	Date Processed
13	RISK_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Risk Scoring date option for history elements 1=Use Run Date 2=Specify Date
14	SETID_CALENDAR	Character(5)	VARCHAR2(5) NOT NULL	Calendar Setid
15	SETID_CUST	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
16	SETID_CUST_GRP	Character(5)	VARCHAR2(5) NOT NULL	Customer Group SetID
17	SETID_RULE	Character(5)	VARCHAR2(5) NOT NULL	Setid for Rule
18	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
19	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
20	RISK_SCORE	Number(3,0)	SMALLINT NOT NULL	Risk Score used in Receivables Collections Workbench
21	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
22	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
23	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
24	AGING_ID	Character(5)	VARCHAR2(5) NOT NULL	Aging ID
25	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
26	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount