BUSINESS_UNIT_RECVRECEIVER_IDVCHR_RECV_HD_VW(SQL View) |
Index Back |
|---|---|
Voucher Recv Header View |
| select distinct a.business_unit, a.receiver_id, a.receipt_dt, b.business_unit_po, b.po_id, a.vendor_setid, a.vendor_id, c.currency_cd from ps_recv_hdr_fs a, ps_recv_ln_ship_fs b, PS_PO_HDR_FS c where a.business_unit = b.business_unit and a.receiver_id = b.receiver_id and b.business_unit_po = c.business_unit and b.po_id = c.po_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 4 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 5 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |