AR_WC_CDBCUFVW

(SQL View)
Index Back

Cash Drawer Receipts Cust ID


SELECT C.cust_id , C.name1 FROM PS_CUSTOMER C WHERE C.cust_status = 'A' AND C.bill_to_flg = 'Y' AND C.cust_level <> 'P'

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