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 |