Note: When the Include Data checkbox is checked, the template is created with the existing item data. Otherwise the system creates a blank template to enter new items.
Column Name | Required | Note |
ItemSK |
| This is never editable. |
ItemID | X | This is not editable when editing existing items. Must be unique when importing new items. |
ItemDescription | X |
|
SalesInvoiceDescription |
|
|
BarCodeLabelDescription |
|
|
ShippingDescription |
|
|
ItemType | X |
|
ItemClass | X |
|
ItemAttributeClass |
|
|
ProductionBatchClass |
|
|
QualityTestClass |
|
|
ManageItemsBy | X |
|
IsVariableWeight |
|
|
AllowVariableOrderedQty |
|
|
RequiresWholeUnits |
|
|
IsLotTracked |
|
|
IsInactive |
|
|
UOMSchedule | X |
|
UnitDecimals |
|
|
WeightDecimals |
|
|
PriceDecimals |
|
|
SalesOrderUnitUOM |
|
|
SalesOrderWeightUOM |
|
|
SalesOrderPriceUOM |
|
|
InventoryUnitUOM |
|
|
InventoryWeightUOM |
|
|
DefaultReportingUOM |
|
|
UnitTareWeight |
|
|
ShippingWeight |
|
|
PalletConfiguration |
|
|
CostUOM |
|
|
CostGroup |
|
|
ValuationMethod |
|
|
StandardCost |
|
|
ActualCost |
|
|
MarketCost |
|
|
IsTaxableForSales |
|
|
IsVisibleToWMS |
|
|
ExpirationDays |
|
|
HoldCodeNewLots |
|
|
HoldCodeSalesReturns |
|
|
UPC |
|
|
GTIN |
|
|
ItemAttributes |
| Each item attribute is displayed as a column. If the item attribute is a list type, users can import new values and these are added to the attribute list. |
BrokerageExpenseAccount |
|
|
BrokerageAccrualAccount |
|
|
BrokerageWriteOffAccount |
|
|
FreightExpenseAccount |
|
|
FreightAccrualAccount |
|
|
FreightRevenueAccount |
|
|
InventoryBalanceSheetAccount |
|
|
InventoryAdjustmentAccount |
|
|
DepreciationAccount |
|
|
CostOfGoodsSoldAccount |
|
|
SalesAccount |
|
|
MarkdownAccount |
|
|
SalesReturnsAccount |
|
|
InventoryReturnedAccount |
|
|
InventoryInUseAccount |
|
|
InventoryInServiceAccount |
|
|
InventoryDamagedAccount |
|
|
CycleCountVarianceAccount |
|
|
DropShipItemsAccount |
|
|
PurchasePriceVarianceAccount |
|
|
UnrealizedPurchasePriceVarianceAccount |
|
|
AssemblyVarianceAccount |
|
|
ItemCertificates |
| Each item certificate is displayed as a column. |