PL_MM_PLXF_CONS

(SQL Table)
Index Back

Mass Maint Plan Transfer Cons

01/15/03 NRA (CN#PL880-1.0): - Contains suggested consolidated planned transfer orders to be enacted by the plug-in

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
6 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
7 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
8 TARGET_DATE DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
9 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
10 PRIORITY_RANK Number(3,0) SMALLINT NOT NULL Priority rank value of demand prioritization rule
11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Y/N Table Edit

Default Value: N

12 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference