SF_ISS_TRAN_HDR

(SQL Table)
Index Back

Picking Plan Header

01/06/99 MEG - CN#SF800-6.0: Added field STATUS_COMPLETE

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
3 PUSH_PULL Character(1) VARCHAR2(1) NOT NULL Locations Selected By
1=System (Push)
2=Picker (Pull)
4 PICK_SORT Character(1) VARCHAR2(1) NOT NULL Picking Report Sort
C=Component Sort
L=Location Sort
P=Production Sort
5 PICKING_DT_TYPE Character(3) VARCHAR2(3) NOT NULL Used to determine the Date selection criteria used when submitting jobs to the Picking Plan.
01=Date/Time Range
02=Lead Days/Minutes
03=Today/Until
6 PICKING_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Picking Lead Days
7 PICKING_DT_FROM Date(10) DATE Picking Selection From Date
8 PICK_SHIFT_FROM Number(1,0) SMALLINT NOT NULL Picking Shift From
9 PICKING_DT_TO Date(10) DATE Picking Selection To Date
10 PICK_SHIFT_TO Number(1,0) SMALLINT NOT NULL Picking Shift To
11 ISSUE_METHOD_OPT Character(4) VARCHAR2(4) NOT NULL Issue Method Option
BOTH=Both Issue and Kit
ISS=Issue
KIT=Kit
12 PID_PA_FROM Character(10) VARCHAR2(10) NOT NULL Production Area - From
13 PID_PA_TO Character(10) VARCHAR2(10) NOT NULL Production Area - To
14 PID_PID_FROM Character(10) VARCHAR2(10) NOT NULL Production Identifier - From
15 PID_PID_TO Character(10) VARCHAR2(10) NOT NULL Production Identifier - To
16 PID_ITEM_FROM Character(18) VARCHAR2(18) NOT NULL Item ID - From
17 PID_ITEM_TO Character(18) VARCHAR2(18) NOT NULL Item ID - To
18 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
19 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
20 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
21 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
22 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
23 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
24 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
25 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
26 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
27 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
28 PRINT_BAR_CODE Character(1) VARCHAR2(1) NOT NULL Print Bar Code
29 STATUS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Complete Status

Y/N Table Edit