PO_SF_PRDN_HDR(SQL View) |
Index Back |
|---|---|
Operation/Purchasing Header |
| SELECT BUSINESS_UNIT, PRODUCTION_ID, INV_ITEM_ID, NEW_PRDN_QTY FROM PS_SF_PRDNID_HEADR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |