IN_PTWY_LOC_VW(SQL View) |
Index Back |
|---|---|
Directed Putaway ViewThis view is used on the secondary panel for directed putaway. |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.QTY , A.QTY_BASE , A.UNIT_OF_MEASURE , B.CUBIC_CHK_FLG , B.CUR_LOC_VOLUME , %Round(%DecMult(B.LOC_HEIGHT, %DECMULT(B.LOC_LENGTH, B.LOC_WIDTH)),4) , B.WEIGHT_CHK_FLG , B.CUR_LOC_WEIGHT , B.WT_CAPACITY , B.ITEM_SELECTION , B.INV_ITEM_ID FROM PS_PHYSICAL_INV A , PS_STOR_LOC_INV B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.STORAGE_AREA = B.STORAGE_AREA AND A.STOR_LEVEL_1 = B.STOR_LEVEL_1 AND A.STOR_LEVEL_2 = B.STOR_LEVEL_2 AND A.STOR_LEVEL_3 = B.STOR_LEVEL_3 AND A.STOR_LEVEL_4 = B.STOR_LEVEL_4 AND (A.QTY <> 0 OR A.QTY_RESERVED <> 0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: %EDITTABLE35 |
| 4 | STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: %EDITTABLE36 |
| 5 | STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: %EDITTABLE37 |
| 6 | STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: %EDITTABLE38 |
| 7 | STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: %EDITTABLE39 |
| 8 | CONTAINER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: %EDITTABLE40 |
| 9 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 10 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 12 | CUBIC_CHK_FLG | Character(1) | VARCHAR2(1) NOT NULL | 11/10/1999 whs - added |
| 13 | CUR_LOC_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 11/1/1999 whs - added |
| 14 | VOL_CAPACITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Maximum Volume Capacity |
| 15 | WEIGHT_CHK_FLG | Character(1) | VARCHAR2(1) NOT NULL | 11/10/1999 whs - added |
| 16 | CUR_LOC_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 11/10/1999 whs - added |
| 17 | WT_CAPACITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Maximum Weight Capacity |
| 18 | ITEM_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Item Selection
M=Multiple Items S=Single Item |
| 19 | INV_ITEM_ID_WRK | Character(18) | VARCHAR2(18) NOT NULL | Work Item ID |