AR_RISKSCR_DTL

(SQL Table)
 Index Back

Risk Score Rule Detail

Risk Score Rule Detail

  • Parent Record Of 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

    Prompt Table: %EDITTABLE

    8 AGING_ID Character(5) VARCHAR2(5) NOT NULL Aging ID

    Prompt Table: AGING_TBL

    9 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance
    10 RISK_SCORE_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Risk Scoring Weight
    11 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
    12 AR_AMOUNT_FLG Character(1) VARCHAR2(1) NOT NULL Amount
    N=No
    Y=Yes
    13 AR_YES_NO Character(1) VARCHAR2(1) NOT NULL Yes or No Flag
    N=No
    Y=Yes