CUSTCPY_CRED_VW

(SQL View)
 Index Back

Customer Copy VW-Credit Info

View of Credit Profile on the customer record for copy function.

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.CR_CHK_ALG_PROFILE , A.CR_SUM_PROFILE , 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 , AR_1099C_BU , PERSONALLY_LIABLE , A.DESCRLONG FROM PS_CUST_CREDIT A WHERE %EffdtCheck(cust_credit,A,%CurrentDateIn)

  • Related Language Record: CUSTCPY_CRD_LVW

  • 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_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
    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 CR_CHK_ALG_PROFILE Character(1) VARCHAR2(1) NOT NULL Corporate Cr. Check Algorithm
    A=Advanced
    B=Basic
    I=Installation Default
    12 CR_SUM_PROFILE Character(1) VARCHAR2(1) NOT NULL Use Corporate Summary Table
    I=Installation Default
    N=No
    Y=Yes
    13 RISK_CODE Character(2) VARCHAR2(2) NOT NULL Risk Code
    H=High
    L=Low
    M=Medium

    Default Value: M

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

    Default Value: A

    15 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

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

    Default Value: CUSTOMER.CURRENCY_CD

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

    Prompt Table: AGING_CATEG_TBL

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

    Prompt Table: AGING_TBL

    23 BACKLOG_DAYS Number(4,0) SMALLINT NOT NULL Backlog Days
    24 AR_1099C Character(1) VARCHAR2(1) NOT NULL 1099-c Reporting
    25 BANKRUPT_FLG Character(1) VARCHAR2(1) NOT NULL Bankrupt
    26 MARKET_VALUE Number(27,3) DECIMAL(26,3) NOT NULL Market Value
    27 AR_1099C_BU Character(5) VARCHAR2(5) NOT NULL AR Business Unit - ICE 2013730000
    28 PERSONALLY_LIABLE Character(1) VARCHAR2(1) NOT NULL ICE 2013730000
    29 DESCRLONG Long Character CLOB Long Description