AR_CNDSYS_VW_LG

(SQL View)
 Index Back

Condition Definition

Condition Definition 2

SELECT A.SETID , A.CONDITION_ID , L.LANGUAGE_CD , L.DESCR50 FROM PS_AR_COND_DEF A ,PS_AR_COND_DEF_LNG L WHERE A.SETID = L.SETID AND A.CONDITION_ID = L.CONDITION_ID AND A.DEFINITION_TYPE = 'S'

  • Related Language Record for AR_CNDSYS_VW

    • # 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
    Set Control Field: SETID

    2 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

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50