DMD_ORDER_TYPE030=Transfer Demand
070=Stock Request
090=Sales Order
110=Work Order Inventory
115=WO Non-Inventory
900=Work Order
DEMAND_HASHPO_PEGINFO_VW(SQL View) |
Index Back |
|---|---|
Pegging Information ViewUsed in porc200.sqr, planned receipt report. |
| SELECT DMD_ORDER_TYPE , DEMAND_HASH , SUM(QTY_PEGGED) - SUM(QTY_RECEIVED) FROM PS_IN_PEGGING GROUP BY DMD_ORDER_TYPE , DEMAND_HASH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DMD_ORDER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Used by Pegging Maintenance/Inquiry
030=Transfer Demand 070=Stock Request 090=Sales Order 110=Work Order Inventory 115=WO Non-Inventory 900=Work Order |
| 2 | DEMAND_HASH |
Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created. |
| 3 | QTY_PEGGED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 06/16/04 EGS: Created. |