INV_ITEM_DEFLT(SQL Table) |
Index Back |
|---|---|
Inventory Item Default Table |
| # | 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_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Item Type
Prompt Table: TYPE_ITEM_INV |
| 3 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y Y/N Table Edit Default Value: N |
| 4 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y Y/N Table Edit Default Value: N |
| 5 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
Shipping Serial Control
Y/N Table Edit Default Value: N |
| 6 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes Y/N Table Edit Default Value: N |
| 7 | CREATE_PROD_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Create Product
Y/N Table Edit Default Value: N |
| 8 | CM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table: CM_GROUP_DEFN |
| 9 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL |
Category Code
Prompt Table: PV_ITEM_CAT_VW |
| 10 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_MATL_ELE_VW |
| 11 | GTIN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Universal Product Number Type Code to be used as a Global Trade Item Number
Prompt Table: UPN_TYPE_FS |