RE_CUST_ADBI_LG

(SQL View)
 Index Back

Customer Billing Addresses

Date Init. Issue # Description 09/18/01 JJM Rel Lang Tbls Created View as Rel Lang Vw

SELECT A.SETID , A.CUST_ID , A.ADDRESS_SEQ_NUM , B.LANGUAGE_CD , A.DESCR , B.ALT_NAME1 , B.ALT_NAME2 FROM PS_CUST_ADDR_SEQ A , PS_CUST_ADDRESS B WHERE A.SETID = B.SETID AND A.CUST_ID= B.CUST_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND A.BILL_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS, B, %CURRENTDATEIN) AND B.EFF_STATUS='A'

  • Related Language Record for RE_CUST_ADDR_BI RE_IUT_CST_ADDR

    • # 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 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Tenant ID
    3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    7 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2