BUSINESS_UNITPICK_BATCH_IDCOMPONENT_IDTO_STORAGE_AREATO_STOR_LEVEL_1TO_STOR_LEVEL_2TO_STOR_LEVEL_3TO_STOR_LEVEL_4CONFIG_CODESF_PICKWIP_TMP(SQL Table) |
Index Back |
|---|---|
Picking WIP Qty Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PICK_BATCH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 3 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 4 | TO_STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 5 | TO_STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 6 | TO_STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 7 | TO_STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 8 | TO_STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 9 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 10 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |