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 |