...
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 |
|
| ||
(X) | This is required if attribute values are being imported. Attribute values cannot be imported without the Attribute Class property. | |||
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. Note that the Attribute Class must be provided when importing attribute values. | ||
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. |
...