Item Table Fields
Item Table
{
"ID": integer,
"Link": "varchar",
"UpdateImportPricing": boolean,
"ShippingMethodCode": "varchar",
"PrintLabels": boolean,
"Weight": numeric,
"Height": numeric,
"Length": numeric,
"Width": numeric,
"UpdateMinMaxOnImport": boolean,
"WebFeatured": boolean,
"WebAccessory": boolean,
"WebMisc": boolean,
"SalePrice": numeric,
"SaleStartDate": YYYY-MM-DD,
"SaleEndDate": YYYY-MM-DD,
"ABCRating": "varchar",
"Active": boolean,
"AutoRecalcList": boolean,
"AverageCost": numeric,
"Barcode": "varchar",
"BinLocationCode": "varchar",
"BrandCode": "varchar",
"Code": "varchar",
"Color": "varchar",
"CommentCode": "varchar",
"DateCreated": string,
"DateModified": string,
"Description": "varchar",
"EOQ": integer,
"Equivalent": "varchar",
"Field1": "varchar",
"Field2": "varchar",
"Field3": "varchar",
"Field4": "varchar",
"Field5": "varchar",
"InventoryTypeCode": "varchar",
"LandedCost": numeric,
"LandingFactor": numeric,
"LastCost": numeric,
"LastDateOrdered": YYYY-MM-DD,
"LastDateReceived": YYYY-MM-DD,
"LastDateSold": YYYY-MM-DD,
"LastUpdateDateTime": "varchar",
"ListPrice": numeric,
"LocMax": integer,
"LocMin": integer,
"LocQOH": integer,
"LocYTD": integer,
"MainStockMax": integer,
"MainStockMin": integer,
"MainStockQOH": integer,
"MainStockYTD": integer,
"ManufacturersWarranty": integer,
"MarkupCode": "varchar",
"MfgReturned": integer,
"MiscCode": "varchar",
"Note": "varchar",
"Obsolete": boolean,
"OrderRatioInventory": integer,
"OrderRatioPurchasing": integer,
"OriginalCost": numeric,
"PicturePath": "varchar",
"PriceTag": "varchar",
"ProductCode": "varchar",
"ReplacementCost": numeric,
"ReplacementCostEffectiveDate": YYYY-MM-DD,
"ResizePicture": boolean,
"SKU": "varchar",
"Stock": boolean,
"Substituted": boolean,
"Supplier1Code": "varchar",
"Supplier1Cost": numeric,
"Supplier2Code": "varchar",
"Supplier2Cost": numeric,
"Supplier3Code": "varchar",
"Supplier3Cost": numeric,
"Tax1": boolean,
"Tax1CostList": "varchar",
"Tax1Included": boolean,
"Tax1Percentage": numeric,
"Tax2": boolean,
"Tax3": boolean,
"TotalLastYear": integer,
"TotalPrevLastYear": integer,
"TotalQOO": integer,
"TotalReserved": integer,
"UnitOfMeasureCode": "varchar",
"UserCreated": "varchar",
"UserModified": "varchar"
}
[<--Return to Item](/docs/item/)