BUSINESS_UNIT_INCONTAINER_IDM=Multiple Items
S=Single Item
F=Finished
R=Raw Mtrl
W=WIP
CNTR_ID_PO_VW(SQL View) |
Index Back |
|---|---|
Container ID Prompting view1447672003/654891 'Container info to display on the putaway location tab' Jan 18, 06 CS |
| SELECT business_unit , container_id , descr , item_selection , inv_item_id , container_type , stock_length , stock_width , stock_height , container_material , max_weight , unit_measure_dim , unit_measure_wt , owner , stock_type , descrlong FROM PS_CNTR_ID_INV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 2 | CONTAINER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ITEM_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Item Selection
M=Multiple Items S=Single Item |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | CONTAINER_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Container Type |
| 7 | STOCK_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Length |
| 8 | STOCK_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Width |
| 9 | STOCK_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Height |
| 10 | CONTAINER_MATERIAL | Character(20) | VARCHAR2(20) NOT NULL | Container Material |
| 11 | MAX_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Weight Capacity |
| 12 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 13 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 14 | OWNER | Character(20) | VARCHAR2(20) NOT NULL | Asset Owner |
| 15 | STOCK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Stock Type
F=Finished R=Raw Mtrl W=WIP |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |