BI_CUSTC_VW_LNG

(SQL View)
 Index Back

Bill Activity by Cust Vw RLR


SELECT DISTINCT A.BILL_TO_CUST_ID , B.LANGUAGE_CD , B.NAME1 FROM PS_BI_HDR A , PS_CUSTOMER_LANG B WHERE A.BILL_TO_CUST_ID = B.CUST_ID AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'CUSTOMER' AND SETCNTRLVALUE = A.BUSINESS_UNIT)

  • Related Language Record for BI_CUST_C_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1