CA_BILL_TO_LNG

(SQL View)
 Index Back

Customer Header Information

9/26/97 -- Carina B.: Made changes for related language display.

SELECT DISTINCT C.SETID , C.cust_id , lang.language_cd , C.name1 FROM ps_customer C , ps_customer_lang lang , PS_CUST_OPTION opt WHERE %Join(COMMON_KEYS, customer c, customer_lang lang) AND %Join(COMMON_KEYS, customer c, cust_option opt) AND C.cust_status = 'A' AND C.bill_to_flg = 'Y' AND C.cust_level <> 'P'

  • Related Language Record for CA_BILL_TO_ALL

    • # 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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1