IN_PEG_PTWY_TMP(SQL Table) |
Index Back |
|---|---|
Prdn pegging temp record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | DEMAND_HASH | Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created. |
| 4 | SUP_ORDER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Used by Pegging Maintenance/Inquiry
010=Purchase 020=Production 035=Transfer Supply 100=Requisition |
| 5 | SUPPLY_HASH | Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created. |
| 6 | QTY_COMPLETE | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Complete |
| 7 | QTY_RECEIVED | Number(16,4) | DECIMAL(15,4) NOT NULL | Received Qty |
| 8 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Reserved |
| 9 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 10 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 11 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | IN_PEG_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Pegging action
001=Peg Update 002=Peg Create 003=Peg Receipt 004=Peg Complete 005=Requisition Sourcing 006=Peg Cancel 007=PegBackOrderCreate/PO Rollover 008=PO Rollover 009=PegPushPOToReq 010=Peg Reopen |