CNTR_TYPE_INV(SQL Table) |
Index Back |
|---|---|
INV Operations Container Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CONTAINER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Container Type |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ITEM_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Item Selection
M=Multiple Items S=Single Item Default Value: M |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 8 | CONTAINER_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Container Length |
| 9 | CONTAINER_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Container Width |
| 10 | CONTAINER_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Container Height |
| 11 | CONTAINER_MATERIAL | Character(20) | VARCHAR2(20) NOT NULL | Container Material |
| 12 | STOCK_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Length |
| 13 | STOCK_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Width |
| 14 | STOCK_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Height |
| 15 | SHIP_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Length |
| 16 | SHIP_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Width |
| 17 | SHIP_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Height |
| 18 | MAX_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Weight Capacity |
| 19 | EMPTY_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Empty Weight |
| 20 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 21 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 22 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 23 | UCC_EAN_CD | Character(1) | VARCHAR2(1) NOT NULL |
UCC/EAN Packaging Type
0=Case/Carton 1=Pallet 2=Truckload 3=Undefined 4=Intra-Company |