ASI_Order_By

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

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

ASI_Favorite_Sequence

ABC Code

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

COGS Inflation Index

COGS Monetary Correction Index

Inventory Inflation Index

Inventory Monetary Correction Index

Item Code

Kit COGS Account Source

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

Last Generated Serial Number

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

Purch Inflation Index

Purch Monetary Correction Index

Purchasing U Of M

Selling U Of M

Tax Commodity Code

Unrealized Purchase Price Variance Index

Location Code

Revalue Inventory

Tolerance Percentage

Purchase Item Tax Schedule ID

Purchase Tax Options

 1 – Taxable
 2 – Nontaxable
 3 – Base on Vendor

Country Origin

Order Fulfillment Shortage Default

Customer Priority

Manufacturer

Manufacture Item Number

ASI_Item_Description

Primary Item