Item Number

Item Description

Note Index

Item Short Name

Item Type

1. Sales Inventory (For SBM, this type is Stock Item.)
2. Discontinued 
3. Kit 
4. Misc Charges
5. Services
6. Flat Fee (For SBM, this type is Labor.)

Item Generic Description

Standard Cost

Current Cost

Item Shipping Weight

Decimal Places QTYS

Decimal Places Currency

Item Tax Schedule ID

Tax Options

1.  Taxable
2.  Nontaxable
3.  Base on customers

IV IV Index

IV IV Offset Index

IV COGS Index

IV Sales Index

IV Sales Discounts Index

IV Sales Returns Index

IV In Use Index

IV In Service Index

IV Damaged Index

IV Variances Index

Drop Ship Index

Purchase Price Variance Index

Unrealized Purchase Price Variance Index

Inventory Returns Index

Assembly Variance Index

Item Class Code

Item Tracking Option

1. None
2. Serial Numbers
3. Lot Numbers

Lot Type

Keep Period History

Keep Trx History

Keep Calendar History

Keep Distribution History

Allow Back Orders

Valuation Method

1. FIFO Perpetual
2. LIFO Perpetual
3. Average Perpetual
4. FIFO Periodic (This value is not available for SBM.)
5. LIFO Periodic (This value is not available for SBM.)

U Of M Schedule

Alternate Item 1

Alternate Item 2

User Category Values[1]

User Category Values[2]

User Category Values[3]

User Category Values[4]

User Category Values[5]

User Category Values[6]

Master Record Type

Modified Date

Created Date

Warranty Days

PriceLevel

Location Code

Purch Inflation Index

Purch Monetary Correction Index

Inventory Inflation Index

Inventory Monetary Correction Index

COGS Inflation Index

COGS Monetary Correction Index

Item Code

Tax Commodity Code

Price Group

Price Method

 1 – Currency Amount
 2 – % of List Price
 3 – % Markup – Current Cost
 4 – % Markup – Standard Cost
 5 – % Margin – Current Cost
 6 – % Margin – Standard Cost

Purchasing U Of M

Selling U Of M

Kit COGS Account Source

 0 – COGS accounts from the components
 1 – COGS account from the kit

Last Generated Serial Number

ABC Code

 1 – (None)
 2 – A
 3 – B
 4 – C

Revalue Inventory

Tolerance Percentage

Purchase Item Tax Schedule ID

Purchase Tax Options

 1 – Taxable
 2 – Nontaxable
 3 – Base on Vendor

Item Planning Type

1 – Normal
 2 – Master Scheduled

Statistical Value Percentage

Country Origin

Inactive

MinShelfLife1

MinShelfLife2

Include in Demand Planning

Lot Expire Warning

Lot Expire Warning Days

Last Generated Lot Number

Lot Split Quantity

Use Qty Overage Tolerance

Use Qty Shortage Tolerance

Qty Overage Tolerance Percentage

Qty Shortage Tolerance Percentage

IV STD Cost Revaluation Index