IV40400 - Item Class Setup
Defines item class settings used as templates when creating new items.
SQL Query Builder
57 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ITMCLSCD | Item Class Code | String | 12 | ||
| ITMCLSDC | Item Class Description | String | 32 | ||
| DEFLTCLS | Default Class | Boolean | 2 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| ITEMTYPE | Item Type1. Sales Inventory (For SBM, this type is Stock Item.)2. Discontinued3. Kit4. Misc Charges5. Services6. Flat Fee (For SBM, this type is Labor.) | Integer | 2 | ||
Item Type values (6) 1 = Sales Inventory2 = Discontinued3 = Kit4 = Misc Charges5 = Services6 = Flat Fee | |||||
| ITMTRKOP | Item Tracking Option1. None2. Serial Numbers3. Lot Numbers | Integer | 2 | ||
Item Tracking Option values (3) 1 = None2 = Serial Numbers3 = Lot Numbers | |||||
| LOTTYPE | Lot Type | String | 12 | ||
| KPERHIST | Keep Period History | Boolean | 2 | ||
| KPTRXHST | Keep Trx History | Boolean | 2 | ||
| KPCALHST | Keep Calendar History | Boolean | 2 | ||
| KPDSTHST | Keep Distribution History | Boolean | 2 | ||
| ALWBKORD | Allow Back Orders | Boolean | 2 | ||
| ITMGEDSC | Item Generic Description | String | 12 | ||
| TAXOPTNS | Tax Options1. Â Taxable2. Â Nontaxable3. Â Base on customers | Integer | 2 | ||
Tax Options values (3) 1 = Taxable2 = Nontaxable3 = Base on customer/vendor | |||||
| ITMTSHID | Item Tax Schedule ID | String | 16 | ||
| Purchase_Tax_Options | Purchase Tax Options1 – Taxable2 – Nontaxable3 – Base on Vendor | Integer | 2 | ||
| Purchase_Item_Tax_Schedu | Purchase Item Tax Schedule ID | String | 16 | ||
| UOMSCHDL | U Of M Schedule | String | 12 | ||
| VCTNMTHD | Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) | Integer | 2 | ||
Valuation Method values (5) 1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic | |||||
| USCATVLS_1 | User Category Values[1] | String | 12 | ||
| USCATVLS_2 | User Category Values[2] | String | 12 | ||
| USCATVLS_3 | User Category Values[3] | String | 12 | ||
| USCATVLS_4 | User Category Values[4] | String | 12 | ||
| USCATVLS_5 | User Category Values[5] | String | 12 | ||
| USCATVLS_6 | User Category Values[6] | String | 12 | ||
| DECPLQTY | Decimal Places QTYS | Integer | 2 | ||
| IVIVINDX | IV IV Index | Long Integer | 4 | ||
| IVIVOFIX | IV IV Offset Index | Long Integer | 4 | ||
| IVCOGSIX | IV COGS Index | Long Integer | 4 | ||
| IVSLSIDX | IV Sales Index | Long Integer | 4 | ||
| IVSLDSIX | IV Sales Discounts Index | Long Integer | 4 | ||
| IVSLRNIX | IV Sales Returns Index | Long Integer | 4 | ||
| IVINUSIX | IV In Use Index | Long Integer | 4 | ||
| IVINSVIX | IV In Service Index | Long Integer | 4 | ||
| IVDMGIDX | IV Damaged Index | Long Integer | 4 | ||
| IVVARIDX | IV Variances Index | Long Integer | 4 | ||
| DPSHPIDX | Drop Ship Index | Long Integer | 4 | ||
| PURPVIDX | Purchase Price Variance Index | Long Integer | 4 | ||
| UPPVIDX | Unrealized Purchase Price Variance Index | Long Integer | 4 | ||
| IVRETIDX | Inventory Returns Index | Long Integer | 4 | ||
| ASMVRIDX | Assembly Variance Index | Long Integer | 4 | ||
| PRCLEVEL | PriceLevel | String | 12 | ||
| PriceGroup | Price Group | String | 12 | ||
| PRICMTHD | Price Method1 – Currency Amount2 – % of List Price3 – % Markup – Current Cost4 – % Markup – Standard Cost5 – % Margin – Current Cost6 – % Margin – Standard Cost | Integer | 2 | ||
Price Method values (6) 1 = Currency Amount2 = % of List Price3 = % Markup - Current Cost4 = % Markup - Standard Cost5 = % Margin - Current Cost6 = % Margin - Standard Cost | |||||
| TCC | Tax Commodity Code | String | 32 | ||
| Revalue_Inventory | Revalue Inventory | Boolean | 2 | ||
| Tolerance_Percentage | Tolerance Percentage | Long Integer | 4 | ||
| CNTRYORGN | Country Origin | String | 8 | ||
| STTSTCLVLPRCNTG | Statistical Value Percentage | Integer | 2 | ||
| INCLUDEINDP | Include in Demand Planning | Boolean | 2 | ||
| LOTEXPWARN | Lot Expire Warning | Boolean | 2 | ||
| LOTEXPWARNDAYS | Lot Expire Warning Days | Integer | 2 | ||
| UseQtyOverageTolerance | Use Qty Overage Tolerance | Boolean | 2 | ||
| UseQtyShortageTolerance | Use Qty Shortage Tolerance | Boolean | 2 | ||
| QtyOverTolerancePercent | Qty Overage Tolerance Percentage | Long Integer | 4 | ||
| QtyShortTolerancePercent | Qty Shortage Tolerance Percentage | Long Integer | 4 | ||
| IVSCRVIX | IV STD Cost Revaluation Index | Long Integer | 4 | ||
Related Tables
Tables that share columns with IV40400. Click "Join" to add to your query.