IN_PRDPEG_TAO(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 | 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 |
| 3 | SUP_ORDER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Used by Pegging Maintenance/Inquiry
010=Purchase 020=Production 035=Transfer Supply 100=Requisition |
| 4 | SUPPLY_HASH |
Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created. |
| 5 | 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 |
| 6 | DEMAND_HASH |
Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created. |
| 7 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 8 | QTY_RECEIVED | Number(16,4) | DECIMAL(15,4) NOT NULL | Received Qty |
| 9 | ORIG_EXPECTED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 12/12/2007 JAA 9.1 Apply Planning Updates. Field used to store original PID end quantity |
| 10 | ORIG_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Original Quantity |
| 11 | ORIG_DUE_DTTM | DateTime(26) | TIMESTAMP | Original Due Date/Time |
| 12 | DUE_DTTM | DateTime(26) | TIMESTAMP | Due Datetime |
| 13 | UPDATE_MY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Update Status
Y/N Table Edit Default Value: N |