SPL_PEGGING_DRV

(SQL Table)
Index Back

SPL_PEGGING_DRV

SPL_PEGGING_DRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
3 PL_MRP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by the MRP Detail Report/Online Inquiry
010=Purchase
011=Completed Purchase
020=Production
030=Transfer
040=Planned Purchase
050=Planned Production
060=Planned Transfer
070=Stock Request
080=Quote
090=Sales Order
100=Buying Agreement
110=Extra Demand
120=Net Forecast
130=Starting Balance
4 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
8 SPL_ORDER_STR Character(25) VARCHAR2(25) NOT NULL Generic Order ID Field - String
9 SPL_LINE_KEY1 Number(5,0) INTEGER NOT NULL Generic Line Key 1
10 SPL_LINE_KEY2 Number(9,2) DECIMAL(8,2) NOT NULL Generic Line Key 1
11 SPL_LINE_KEY3 Number(5,0) INTEGER NOT NULL Generic Line Key 3
12 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
13 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
14 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
15 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
16 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
17 BUS_UNIT_SOURCE Character(5) VARCHAR2(5) NOT NULL Source Business Unit