CUST_CREDIT_VW1

(SQL View)
 Index Back

Customer Copy VW-Credit Info


SELECT A.SETID , A.CUST_ID , A.EFFDT , A.CR_LIMIT , A.CR_LIMIT_RANGE , A.CR_LIMIT_DT , A.CR_LIMIT_CORP , A.CR_LIM_CORP_RANGE , A.CR_LIMIT_CORP_DT , A.CR_LIMIT_REV_DT , A.RISK_CODE , A.CREDIT_CLASS , A.CREDIT_CHECK , A.MAX_ORDER_AMT , A.CUSTCR_PCT_OVR , A.CORPCR_PCT_OVR , A.CURRENCY_CD , A.RT_TYPE , A.AGING_CATEGORY , A.AGING_ID , A.BACKLOG_DAYS , A.AR_1099C , A.BANKRUPT_FLG , A.MARKET_VALUE , A.DESCRLONG , A.COLLECTION_STATUS , A.COLLECTION_DT , A.DISPUTE_STATUS , A.DISPUTE_DT FROM PS_CUST_CREDIT A WHERE %EffdtCheck(cust_credit,A,%CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Parent record: CUSTOMER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    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 ADD_DT Date(10) DATE Customer Added On
    4 CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit
    5 CR_LIMIT_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %
    6 CR_LIMIT_DT Date(10) DATE Credit Limit Date
    7 CR_LIMIT_CORP Signed Number(28,3) DECIMAL(26,3) NOT NULL Corporate Credit Limit
    8 CR_LIM_CORP_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %
    9 CR_LIMIT_CORP_DT Date(10) DATE Corporate Credit Limit Date
    10 CR_LIMIT_REV_DT Date(10) DATE Credit Limit Review Date
    11 RISK_CODE Character(2) VARCHAR2(2) NOT NULL Risk Code
    H=High
    L=Low
    M=Medium

    Default Value: M

    12 CREDIT_CLASS Character(2) VARCHAR2(2) NOT NULL Credit Class
    A=Class A
    B=Class B
    C=Class C

    Default Value: A

    13 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
    N=Credit Check No
    Y=Credit Check Yes

    Y/N Table Edit

    Default Value: Y

    14 MAX_ORDER_AMT Number(27,3) DECIMAL(26,3) NOT NULL Maximum Order Amount
    15 CUSTCR_PCT_OVR Number(3,0) SMALLINT NOT NULL % Over Limit
    16 CORPCR_PCT_OVR Number(3,0) SMALLINT NOT NULL % Over Limit
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CUSTOMER.CURRENCY_CD

    18 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.
    19 AGING_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category

    Prompt Table: AGING_CATEG_TBL

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

    Prompt Table: AGING_TBL

    21 BACKLOG_DAYS Number(4,0) SMALLINT NOT NULL Backlog Days
    22 AR_1099C Character(1) VARCHAR2(1) NOT NULL 1099-c Reporting
    23 BANKRUPT_FLG Character(1) VARCHAR2(1) NOT NULL Bankrupt
    24 MARKET_VALUE Number(27,3) DECIMAL(26,3) NOT NULL Market Value
    25 DESCRLONG Long Character CLOB Long Description
    26 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.
    27 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.
    28 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.
    29 DISPUTE_DT Date(10) DATE Specifies the date that an item was placed in dispute status.