PL_ITM_EARLY_VW

(SQL View)
Index Back

PL_ITM_EARLY_VW

PL_ITM_EARLY_VW

SELECT PROBINST , INV_ITEM_ID , BUSINESS_UNIT ,ITEM_EARLY_DATE ,PL_ITEM_PREC ,SALES_CONSUMP FROM PS_PL_BU_ITEMS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
4 ITEM_EARLY_DATE Date(10) DATE 08/16/01 EGS (CN#PL900-1.0): Added
5 PL_ITEM_PREC Number(3,0) SMALLINT NOT NULL 10/08/01 EGS (CN#PL900-1): Added.
6 SALES_CONSUMP Character(1) VARCHAR2(1) NOT NULL Sales Consumption