BUSINESS_UNITPICK_BATCH_IDPICKLIST_LINE_NOSERIAL_IDCOMP_SERIAL_IDSTAGED_DATEINV_LOT_IDCONTAINER_IDSTORAGE_AREASTOR_LEVEL_1STOR_LEVEL_2STOR_LEVEL_3STOR_LEVEL_4UNIT_MEASURE_PICKLT=Lot Allocation
PR=Pre-allocation
SA=Standard Allocation
INV_SIT_VW(SQL View) |
Index Back |
|---|---|
Production Issue Transfer View |
| SELECT A.BUSINESS_UNIT , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.SERIAL_ID , A.COMP_SERIAL_ID , A.STAGED_DATE , A.INV_LOT_ID , A.CONTAINER_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.TO_STORAGE_AREA , A.TO_STOR_LEVEL_1 , A.TO_STOR_LEVEL_2 , A.TO_STOR_LEVEL_3 , A.TO_STOR_LEVEL_4 , A.UNIT_MEASURE_PICK , A.COMPONENT_ID , A.PRODUCTION_ID , A.QTY_PICKED_CONV , A.QTY_PICKED , A.QTY_PICK_ACTUAL , '2' , 'SA' FROM PS_SF_ISS_TRANSFER A |
| # | 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 | PICKLIST_LINE_NO |
Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |
| 4 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 5 | COMP_SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 6 | STAGED_DATE |
Date(10) | DATE | Staged Date |
| 7 | INV_LOT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 8 | CONTAINER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 9 | STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 10 | STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 11 | STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 12 | STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 13 | STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 14 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 15 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 16 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 17 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 18 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 19 | UNIT_MEASURE_PICK |
Character(3) | VARCHAR2(3) NOT NULL | Phys Location Unit of Measure |
| 20 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 21 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 22 | QTY_PICKED_CONV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Picked in Phys Loc UOM |
| 23 | QTY_PICKED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Picked |
| 24 | QTY_PICK_ACTUAL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Actual Qty Picked |
| 25 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 26 | ALLOCATE_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Allocation Source - Why was the allocation created
LT=Lot Allocation PR=Pre-allocation SA=Standard Allocation |