IN_WO_ISS_CTX

(SQL Table)
Index Back

Inv WO Issues CI Context Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 IN_WO_TRANS_CODE Character(2) VARCHAR2(2) NOT NULL Transaction Code
10=Issue Scheduled Part
15=Issue Unscheduled Part
20=Return Part to Inventory
40=Issue Pick Line
50=Pick Line as Planned
55=Pick Batch as Planned
60=Cancel Pick Line
65=Cancel Pick Batch
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
7 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
8 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
9 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
12 FR_PICKLST_LINE_NO Number(7,0) INTEGER NOT NULL From Picklist Line Number
13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
14 DESCRLONG Long Character CLOB Long Description