CNTR_ID_INV_VW(SQL View) |
Index Back |
|---|---|
INV Operations Container ID Vw |
| 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 |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | TEMP_CONTAINER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Default Value: NEXT Prompt Table: CNTR_ID_INV |
| 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
Prompt Table: BU_ITM_INV_VW |
| 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
Prompt Table: UNITS_TBL |
| 13 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 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 Default Value: F |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |