CUST_BL_ALL_VW

(SQL View)
Index Back

All Bill-To Customers

All Bill-To Customers

SELECT A.SETID , A.CUST_ID , A.NAME1 , A.NAME2 FROM PS_CUSTOMER A WHERE BILL_TO_FLG = 'Y'

  • Related Language Record: CUST_BL_ALL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2