SF_ISS_TRAN_HDR(SQL Table) |
Index Back |
---|---|
Picking Plan Header01/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 |