AR_RISKRNG_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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.
4	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	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
7	RISK_SCORE_ELEMENT	Character(18)	VARCHAR2(18) NOT NULL	Risk Scoring Element
8	RANGE_SEQ	Number(3,0)	SMALLINT NOT NULL	Per Diem Range
9	RISK_RNG_LO_CHAR	Character(30)	VARCHAR2(30) NOT NULL	Risk Score Range Low
10	RISK_RNG_HI_DT	Date(10)	DATE	Risk Score Range High
11	RISK_RNG_LO_DT	Date(10)	DATE	Risk Score Range High
12	RISK_RNG_LO_INT	Signed Number(27,0)	DECIMAL(26) NOT NULL	Risk Score Range Low
13	RISK_RNG_HI_INT	Signed Number(27,0)	DECIMAL(26) NOT NULL	Risk Score Range High
14	RISK_RNG_HI_CHAR	Character(30)	VARCHAR2(30) NOT NULL	Risk Score Range High
15	RISK_RNG_HI_DAY	Signed Number(6,0)	DECIMAL(5) NOT NULL	Risk Score Range Low
16	RISK_RNG_HI_PCT	Signed Number(4,0)	DECIMAL(3) NOT NULL	Risk Score Range Low
17	RISK_RNG_LO_DAY	Signed Number(6,0)	DECIMAL(5) NOT NULL	Risk Score Range Low
18	RISK_RNG_LO_PCT	Signed Number(4,0)	DECIMAL(3) NOT NULL	Risk Score Range Low
19	RISK_RNG_HI_DEC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Risk Score Range Low
20	RISK_RNG_LO_DEC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Risk Score Range Low
21	RISK_RANGE_VALUE	Number(3,0)	SMALLINT NOT NULL	Risk Score Range Value
22	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
23	MAX_LENGTH	Number(2,0)	SMALLINT NOT NULL	Maximum Length of Auto Number