INV_PICKING_WL

(SQL Table)
Index Back

Replen Notification Temp Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
5 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
11 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
12 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
13 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
14 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
15 QTY_OPTIMAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Optimal Qty
16 TRANSF_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Transfer Qty
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
18 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
19 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
20 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
21 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
22 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
23 FPB_ROLENAME Character(30) VARCHAR2(30) NOT NULL Fixed Picking Bin Role Name
24 FPB_RTE_CNTL_TYPE Character(30) VARCHAR2(30) NOT NULL Route Control Type
25 FPB_RTE_FROM_VALUE Character(30) VARCHAR2(30) NOT NULL From Value
26 FPB_RTE_TO_VALUE Character(30) VARCHAR2(30) NOT NULL To Value