PL_REP_ITEM_TMP

(SQL Table)
Index Back

PL Inconsistency Items Temp

07/02/02 EGS (CN#PL880-1): Added

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
7 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
8 PURCHASE_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Purchase Yield
9 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
10 TRANSFER_ORD_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier