| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| ITMCLSCD | Item Class Code |
String | 12 | View | |
| ITMCLSDC | Item Class Description |
String | 32 | View | |
| DEFLTCLS | Default Class |
Boolean | 2 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| ITEMTYPE | Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) |
Integer | 2 | View | |
| ITMTRKOP | Item Tracking Option 1. None |
Integer | 2 | View | |
| LOTTYPE | Lot Type |
String | 12 | View | |
| KPERHIST | Keep Period History |
Boolean | 2 | View | |
| KPTRXHST | Keep Trx History |
Boolean | 2 | View | |
| KPCALHST | Keep Calendar History |
Boolean | 2 | View | |
| KPDSTHST | Keep Distribution History |
Boolean | 2 | View | |
| ALWBKORD | Allow Back Orders |
Boolean | 2 | View | |
| ITMGEDSC | Item Generic Description |
String | 12 | View | |
| TAXOPTNS | Tax Options 1. Taxable |
Integer | 2 | View | |
| ITMTSHID | Item Tax Schedule ID |
String | 16 | View | |
| Purchase_Tax_Options | Purchase Tax Options 1 – Taxable |
Integer | 2 | View | |
| Purchase_Item_Tax_Schedu | Purchase Item Tax Schedule ID |
String | 16 | View | |
| UOMSCHDL | U Of M Schedule |
String | 12 | View | |
| VCTNMTHD | Valuation Method 1. FIFO Perpetual |
Integer | 2 | View | |
| USCATVLS_1 | User Category Values[1] |
String | 12 | View | |
| USCATVLS_2 | User Category Values[2] |
String | 12 | View | |
| USCATVLS_3 | User Category Values[3] |
String | 12 | View | |
| USCATVLS_4 | User Category Values[4] |
String | 12 | View | |
| USCATVLS_5 | User Category Values[5] |
String | 12 | View | |
| USCATVLS_6 | User Category Values[6] |
String | 12 | View | |
| DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
| IVIVINDX | IV IV Index |
Long Integer | 4 | View | |
| IVIVOFIX | IV IV Offset Index |
Long Integer | 4 | View | |
| IVCOGSIX | IV COGS Index |
Long Integer | 4 | View | |
| IVSLSIDX | IV Sales Index |
Long Integer | 4 | View | |
| IVSLDSIX | IV Sales Discounts Index |
Long Integer | 4 | View | |
| IVSLRNIX | IV Sales Returns Index |
Long Integer | 4 | View | |
| IVINUSIX | IV In Use Index |
Long Integer | 4 | View | |
| IVINSVIX | IV In Service Index |
Long Integer | 4 | View | |
| IVDMGIDX | IV Damaged Index |
Long Integer | 4 | View | |
| IVVARIDX | IV Variances Index |
Long Integer | 4 | View | |
| DPSHPIDX | Drop Ship Index |
Long Integer | 4 | View | |
| PURPVIDX | Purchase Price Variance Index |
Long Integer | 4 | View | |
| UPPVIDX | Unrealized Purchase Price Variance Index |
Long Integer | 4 | View | |
| IVRETIDX | Inventory Returns Index |
Long Integer | 4 | View | |
| ASMVRIDX | Assembly Variance Index |
Long Integer | 4 | View | |
| PRCLEVEL | PriceLevel |
String | 12 | View | |
| PriceGroup | Price Group |
String | 12 | View | |
| PRICMTHD | Price Method 1 – Currency Amount |
Integer | 2 | View | |
| TCC | Tax Commodity Code |
String | 32 | View | |
| Revalue_Inventory | Revalue Inventory |
Boolean | 2 | View | |
| Tolerance_Percentage | Tolerance Percentage |
Long Integer | 4 | View | |
| CNTRYORGN | Country Origin |
String | 8 | View | |
| STTSTCLVLPRCNTG | Statistical Value Percentage |
Integer | 2 | View | |
| INCLUDEINDP | Include in Demand Planning |
Boolean | 2 | View | |
| LOTEXPWARN | Lot Expire Warning |
Boolean | 2 | View | |
| LOTEXPWARNDAYS | Lot Expire Warning Days |
Integer | 2 | View | |
| UseQtyOverageTolerance | Use Qty Overage Tolerance |
Boolean | 2 | View | |
| UseQtyShortageTolerance | Use Qty Shortage Tolerance |
Boolean | 2 | View | |
| QtyOverTolerancePercent | Qty Overage Tolerance Percentage |
Long Integer | 4 | View | |
| QtyShortTolerancePercent | Qty Shortage Tolerance Percentage |
Long Integer | 4 | View | |
| IVSCRVIX | IV STD Cost Revaluation Index |
Long Integer | 4 | View |