CUST_CONSOL_LNG

(SQL View)
Index Back

Consolidation Cust Vw - RLR

Consolidation Cust Vw - RLR

SELECT A.SETID ,A.CUST_ID ,L.LANGUAGE_CD ,L.NAME1 FROM PS_CUSTOMER A , PS_CUSTOMER_LANG L WHERE A.SETID = L.SETID AND A.CUST_ID = L.CUST_ID AND A.CONSOL_BUS_UNIT <> ' ' AND A.CUST_STATUS IN ('A','I')

  • Related Language Record for CUST_CONSOL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONSOL_SETID Character(5) VARCHAR2(5) NOT NULL Consolidation Customer SetID
    2 CONSOL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Consolidation Customer ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1