INV_ITEM_TEMPL(SQL Table) |
Index Back |
|---|---|
Inventory Item Templates |
| # | 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 | INV_ITEM_TEMPLATE |
Character(5) | VARCHAR2(5) NOT NULL | Template ID |
| 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 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table: STOCK_TYPE_INV |
| 6 | PACKING_CD | Character(4) | VARCHAR2(4) NOT NULL |
Packing Code
Prompt Table: PACK_CODE_INV |
| 7 | STOR_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL |
Storage Rule ID
Prompt Table: STOR_RULES_INV |
| 8 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 9 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 10 | INV_PROD_GRADE | Character(4) | VARCHAR2(4) NOT NULL |
Grade
Prompt Table: INV_ITEM_GRADE |
| 11 | HAZ_CLASS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Hazard Code
Prompt Table: HAZ_TBL_INV |
| 12 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 13 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 14 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 15 | INV_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 16 | INV_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Volume |
| 17 | INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 18 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 19 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 20 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 21 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |