ORDENT_CRED_VW

(SQL View)
 Index Back

OrdEnt Cust Credit Information

Order entry customer credit information.

SELECT setid , cust_id , effdt , eff_status , cr_limit , cr_limit_range , cr_limit_dt , cr_limit_corp , cr_lim_corp_range , cr_limit_corp_dt , cr_limit_rev_dt , dispute_status , dispute_dt , dispute_amount , collection_status , collection_dt , risk_code , credit_class , credit_check , max_order_amt , custcr_pct_ovr , corpcr_pct_ovr , currency_cd , currency_cd , rt_type , aging_category , aging_id , backlog_days FROM PS_CUST_CREDIT

  • Parent record: CUSTOMER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 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.
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit
    6 CR_LIMIT_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %
    7 CR_LIMIT_DT Date(10) DATE Credit Limit Date
    8 CR_LIMIT_CORP Signed Number(28,3) DECIMAL(26,3) NOT NULL Corporate Credit Limit
    9 CR_LIM_CORP_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %
    10 CR_LIMIT_CORP_DT Date(10) DATE Corporate Credit Limit Date
    11 CR_LIMIT_REV_DT Date(10) DATE Credit Limit Review Date
    12 DISPUTE_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
    13 DISPUTE_DT Date(10) DATE Specifies the date that an item was placed in dispute status.
    14 DISPUTE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.
    15 COLLECTION_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
    16 COLLECTION_DT Date(10) DATE Specifies the date that a customer or invoice was put in collection status. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
    17 RISK_CODE Character(2) VARCHAR2(2) NOT NULL Risk Code
    H=High
    L=Low
    M=Medium
    18 CREDIT_CLASS Character(2) VARCHAR2(2) NOT NULL Credit Class
    A=Class A
    B=Class B
    C=Class C
    19 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
    N=Credit Check No
    Y=Credit Check Yes

    Y/N Table Edit

    20 MAX_ORDER_AMT Number(27,3) DECIMAL(26,3) NOT NULL Maximum Order Amount
    21 CUSTCR_PCT_OVR Number(3,0) SMALLINT NOT NULL % Over Limit
    22 CORPCR_PCT_OVR Number(3,0) SMALLINT NOT NULL % Over Limit
    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    24 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
    25 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.
    26 AGING_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category
    27 AGING_ID Character(5) VARCHAR2(5) NOT NULL Aging ID
    28 BACKLOG_DAYS Number(4,0) SMALLINT NOT NULL Backlog Days