AR_RISKDT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	RISK_SCORE_ID	Character(5)	VARCHAR2(5) NOT NULL	Risk Score ID
3	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. Prompt Table: CUSTOMER
4	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
5	RISK_SCORE_ELEMENT	Character(18)	VARCHAR2(18) NOT NULL	Risk Scoring Element
6	RISK_RANGE_VALUE	Number(3,0)	SMALLINT NOT NULL	Risk Score Range Value
7	RISK_SCORE_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Risk Scoring Weight
8	RISK_SCORE	Number(3,0)	SMALLINT NOT NULL	Risk Score used in Receivables Collections Workbench
9	CHAR_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Old Edit Value
10	DATE1	Date(10)	DATE	Date
11	DAYSTO	Signed Number(5,0)	DECIMAL(4) NOT NULL	Days To
12	CUSTCR_PCT_OVR	Number(3,0)	SMALLINT NOT NULL	% Over Limit
13	AR_RISK_VALUE	Signed Number(27,0)	DECIMAL(26) NOT NULL	Risk Score Range Low
14	RISK_RNG_HI_DEC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Risk Score Range Low
15	AR_YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Yes or No Flag N=No Y=Yes
16	AR_RISK_ERROR	Character(3)	VARCHAR2(3) NOT NULL	Error code used for risk scoring. 1=No History Data Exists 2=No Aging Data Exists 3=No Data Found to Compute Score 4=No Data Found in Range.
17	BU_COUNT	Number(5,0)	INTEGER NOT NULL	Count of business units Default Value: 0
18	AR_FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	AR field types 0=Character 2=Number 3=Signed Number 4=Date 6=Days 7=Percent 8=Decimal