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 |