CNTR_ID_INV(SQL Table) |
Index Back |
|---|---|
INV Operations Container ID |
| # | 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 | 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
Prompt Table: CNTR_TYPE_INV |
| 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 |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |