===== Sage Data Exchange CI Item Table =====
<datatables paging="false" searching="false" ordering="false" info="false">
^Element Name^Description^Type^Length^
|ItemCode|Item Code|String|30|
|ItemType|Item Type|String|1|
|ItemCodeDesc|Item Code Description|String|30|
|ExtendedDescriptionKey|Extended Description Key|String|10|
|UseInAR|Use In AR|String|1|
|UseInSO|Use In SO|String|1|
|UseInPO|Use In PO|String|1|
|UseInBM|Use In BM|String|1|
|CalculateCommission|Calculate Commission|String|1|
|DropShip|Drop Ship|String|1|
|EBMEnabled|eBusiness Manager Enabled|String|1|
|AllowBackOrders|Allow Back Orders|String|1|
|AllowReturns|Allow Returns|String|1|
|PriceCode|Price Code|String|4|
|AllowTradeDiscount|Allow Trade Discount|String|1|
|PrintReceiptLabels|Print Receipt Labels|String|1|
|AllocateLandedCost|Allocate Landed Cost|String|1|
|InactiveItem|Inactive Item|String|1|
|ConfirmCostIncrInRcptOfGoods|Confirm Cost Increase in Receipt Of Goods|String|1|
|WarrantyCode|Warranty Code|String|10|
|SalesUnitOfMeasure|Sales Unit of Measure|String|4|
|PurchaseUnitOfMeasure|Purchase Unit of Measure|String|4|
|StandardUnitOfMeasure|Standard Unit of Measure|String|4|
|PostToGLByDivision|Post to G/L By Division|String|1|
|SalesAcctKey|Sales Account Key|String|9|
|CostOfGoodsSoldAcctKey|Cost Of Goods Sold Account Key|String|9|
|InventoryAcctKey|Inventory Account Key|String|9|
|PurchaseAcctKey|Purchase Account Key|String|9|
|ManufacturingCostAcctKey|Manufacturing Cost Account Key|String|9|
|TaxClass|Tax Class|String|2|
|PurchasesTaxClass|Purchases Tax Class|String|2|
|ProductLine|Product Line|String|4|
|ProductType|Product Type|String|1|
|Valuation|Valuation|String|1|
|DefaultWarehouseCode|Default Warehouse Code|String|3|
|PrimaryAPDivisionNo|Primary AP Division Number|String|2|
|PrimaryVendorNo|Primary Vendor Number|String|7|
|ImageFile|Image File|String|30|
|LastSoldDate|Last Sold Date|String|8|
|LastReceiptDate|Last Receipt Date|String|8|
|Category1|Category 1|String|10|
|Category2|Category 2|String|10|
|Category3|Category 3|String|10|
|Category4|Category 4|String|10|
|SalesPromotionCode|Sales Promotion Code|String|10|
|SaleStartingDate|Sale Starting Date|String|8|
|SaleEndingDate|Sale Ending Date|String|8|
|SaleMethod|Sale Method|String|1|
|ExplodeKitItems|Explode Kit Items|String|1|
|ShipWeight|Ship Weight|String|10|
|CommentText|Comment Text|String|2048|
|RestockingMethod|Restocking Method|String|1|
|NextLotSerialNo|Next Lot/Serial Number|String|15|
|InventoryCycle|Inventory Cycle|String|1|
|RoutingNo|Routing Number|String|20|
|ProcurementType|Procurement Type|String|1|
|PlannerCode|Planner Code|String|3|
|BuyerCode|Buyer Code|String|3|
|LowLevelCode|Low Level Code|String|2|
|PlannedByMRP|Planned By Mrp|String|1|
|VendorItemCode|Vendor Item Code|String|30|
|SetupCharge|Setup Charge|String|1|
|AttachmentFileName|Attachment File Name|String|30|
|ItemImageWidthInPixels|Item Image Width In Pixels|Numeric|4|
|ItemImageHeightInPixels|Item Image Height In Pixels|Numeric|4|
|StandardUnitCost|Standard Unit Cost|Numeric|16.6|
|StandardUnitPrice|Standard Unit Price|Numeric|16.6|
|LastTotalUnitCost|Last Total Unit Cost|Numeric|16.6|
|AverageUnitCost|Average Unit Cost|Numeric|16.6|
|SalesPromotionPrice|Sales Promotion Price|Numeric|16.6|
|SuggestedRetailPrice|Suggested Retail Price|Numeric|16.6|
|SalesPromotionDiscountPercent|Sales Promotion Discount Percentage|Numeric|12.3|
|TotalQuantityOnHand|Total Quantity On Hand|Numeric|16.6|
|AverageBackOrderFillDays|Average Back Order Fill Days|Numeric|5|
|LastAllocatedUnitCost|Last Allocated Unit Cost|Numeric|16.6|
|CommissionRate|Commission Rate|Numeric|9.3|
|BaseCommAmt|Base Commission Amount|Numeric|12.2|
|PurchaseUMConvFctr|Purchase Unit of Measure Conversion Factor|Numeric|12.4|
|SalesUMConvFctr|Sales Unit of Measure Conversion Factor|Numeric|12.4|
|Volume|Volume|Numeric|11.4|
|RestockingCharge|Restocking Charge|Numeric|11.3|
|TotalInventoryValue|Total Inventory Value|Numeric|15.2|
|DateCreated|Creation Date|String|8|
|TimeCreated|Creation Time|String|8|
|UserCreatedKey|Creation User ID|String|10|
|DateUpdated|Last Update Date|String|8|
|TimeUpdated|Last Update Time|String|8|
|UserUpdatedKey|Last Update User ID|String|10|
</datatables>