AR_CNDSYS3_VW

(SQL View)
 Index Back

Condition Definition

Condition Definition 2

SELECT DISTINCT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'CONDITION_ID' AND A.FIELDVALUE IN ('COLL', 'ACLA', 'ECLA', 'ACLD','CCEX', 'ECLD', 'CHLD', 'CFLU', 'CPDR', 'CPDB', 'LACD', 'KSTE', 'ETRC', 'ONLN', 'DISP', 'DEDN', 'RISK', 'EBIL','CCHD','WCNC','WBDC')

  • Related Language Record: AR_CNDSYS3_VWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONDITION_ID Character(4) VARCHAR2(4) NOT NULL Condition ID
    ACLA=Approaching Credit Limit
    ACLD=Approaching Credit Limit Exp
    CCEX=Approaching CC expiration date
    CCHD=Cancel Credit Hold
    CFLU=Conversation Follow Up
    CHLD=Credit Hold Code Exists
    COLL=Collection
    CPDB=Customer Promise Date Broken
    CPDR=Customer Promise Date Review
    DEDN=Deduction Item
    DISP=Disputed Item
    EBIL=eBill selection by user
    ECLA=Exceeded Credit Limit
    ECLD=Exceed CR Limit Expiration Dt
    ETRC=Entry Type / Reason Code
    KSTE=Key Statistics Exceeded
    LACD=Large Amount Coming Due
    ONLN=Online selection by user
    RISK=Risk Score
    WBDC=Welcome Back Dormant Customer
    WCNC=Welcome New Customer

    Prompt Table: AR_CNDSYS3_VW

    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50