IN_AR_PEG_TAO

(SQL Table)
Index Back

Pegging Archive Temp Table

# 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 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
7 QTY_RECEIVED Number(16,4) DECIMAL(15,4) NOT NULL Received Qty
8 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
9 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 10

10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
12 HARD_PEG Character(1) VARCHAR2(1) NOT NULL 09/01/04 EGS: Created

Y/N Table Edit

Default Value: N

13 DMD_DTTM DateTime(26) TIMESTAMP 10/04/04 EGS: Created
14 SUP_DTTM DateTime(26) TIMESTAMP 10/04/04 EGS: Created
15 DMD_OPEN_QTY Number(16,4) DECIMAL(15,4) NOT NULL 10/04/04 EGS: Created
16 SUP_OPEN_QTY Number(16,4) DECIMAL(15,4) NOT NULL 10/04/04 EGS: Created
17 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
18 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.