FO_CUSTBI_LNGVW

(SQL View)
 Index Back

Customer Billing Addresses


SELECT DISTINCT a.setid , a.cust_id , c.language_cd , C.name1 FROM ps_cust_addr_seq a , PS_CUST_ADDRESS b , ps_customer_lang c 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 b.effdt = ( SELECT MAX(effdt) FROM PS_CUST_ADDRESS WHERE setid=b.setid AND cust_id=b.cust_id AND address_seq_num=b.address_seq_num AND effdt <= %CurrentDateIn) AND b.eff_status='A' AND C.SETID = A.SETID AND C.CUST_ID = A.CUST_ID

  • Related Language Record for FO_CUST_BI_VW2

    • # 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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: CUSTOMER

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1