enhancements:sage100:modules:sde:api:tables:ci

Sage Data Exchange CI Item Table

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