IN_KXPL_MSG_VW

(SQL View)
 Index Back

Inventory Kit Explosion Change

Record of changes made to kit definitions using the kit re-explosion process

SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_PARM1 , A.MESSAGE_PARM2 , A.MESSAGE_PARM3 , A.MESSAGE_PARM4 , A.MESSAGE_PARM5 , A.MESSAGE_PARM6 , ' ' , ' ' , ' ' , ' ' , ' ' FROM %Table(IN_KIT_EXPL_MSG) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 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
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
13 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
14 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
15 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
16 MESSAGE_PARM5 Character(30) VARCHAR2(30) NOT NULL Message Parameter 5
17 MESSAGE_PARM6 Character(30) VARCHAR2(30) NOT NULL Message Parameter
18 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
19 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
20 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
21 ORIG_QTY_CODE Character(3) VARCHAR2(3) NOT NULL Original Quantity Code
ASY=Assembly
ORD=Order
22 PSYESNO Character(4) VARCHAR2(4) NOT NULL Placeholder for XLATTABLE's PSYESNO which is used for XTM_YESNONAME in PDM_YESNO usage.
N=No
Y=Yes