BUSINESS_UNIT_POPO_IDDefault Value: NEXT
Default Value: %date
Prompt Table: VENDOR_PO_VW
OM_PO_HDR_VW(SQL View) |
Index Back |
|---|---|
Purchase Order Header |
| select business_unit, po_id, po_dt, po_ref, vendor_id from PS_PO_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Default Value: NEXT |
| 3 | PO_DT | Date(10) | DATE NOT NULL |
Date
Default Value: %date |
| 4 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_PO_VW |