Item Table Fields

<–Return to Item

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/)