Model Table Fields

<-Return to Model

Model Table

{
    "ID": integer,
    "MfgBarcode": string,
    "UPCBarcode": string,
    "RootModelCode": string,
    "PackageCode": string,
    "Link": string,
    "Identifier": string,
    "BarcodeSchema": string,
    "AllowSpecialOrder": boolean,
    "UpdateImportPricing": boolean,
    "WarrantyTypeCode": string,
    "AllowPackageWty": boolean,
    "ShippingMethodCode": string,
    "Volume": integer.integer,
    "UnloadTime": integer.integer,
    "AutoNumber": boolean,
    "ShipAnySerial": boolean,
    "SalePrice": integer.integer,
    "SaleStartDate": YYYY-MM-DD,
    "SaleEndDate": YYYY-MM-DD,
    "Feature1": string,
    "Feature2": string,
    "Feature3": string,
    "Feature4": string,
    "Feature5": string,
    "Feature6": string,
    "Feature7": string,
    "Feature8": string,
    "Feature9": string,
    "Feature1integer": string,
    "Dimension1": string,
    "Dimension2": string,
    "Warranty1": string,
    "Warranty2": string,
    "PTDesc": string,
    "InstallationEstimate": integer.integer,
    "UpdateImportCost": boolean,
    "Dimension3": string,
    "Misc2Code": string,
    "Misc3Code": string,
    "Misc4Code": string,
    "Misc5Code": string,
    "MiscPrompt": boolean,
    "Misc2Prompt": boolean,
    "Misc3Prompt": boolean,
    "Misc4Prompt": boolean,
    "Misc5Prompt": boolean,
    "ExtWarrantyPrompt": boolean,
    "ExtWarranty2Prompt": boolean,
    "ExtWarranty3Prompt": boolean,
    "ExtWarranty4Prompt": boolean,
    "ExtWarranty5Prompt": boolean,
    "ExtWarranty2Code": string,
    "ExtWarranty3Code": string,
    "ExtWarranty4Code": string,
    "ExtWarranty5Code": string,
    "Item1Prompt": boolean,
    "Item2Prompt": boolean,
    "Item3Prompt": boolean,
    "Item4Prompt": boolean,
    "Item5Prompt": boolean,
    "Item1Code": string,
    "Item2Code": string,
    "Item3Code": string,
    "Item4Code": string,
    "Item5Code": string,
    "Model1Prompt": boolean,
    "Model2Prompt": boolean,
    "Model3Prompt": boolean,
    "Model4Prompt": boolean,
    "Model5Prompt": boolean,
    "Model1Code": string,
    "Model2Code": string,
    "Model3Code": string,
    "Model4Code": string,
    "Model5Code": string,
    "ImmediateReservedDays": integer,
    "Spiff2": integer.integer,
    "Spiff2EndDate": YYYY-MM-DD,
    "Spiff2StartDate": YYYY-MM-DD,
    "CommentPrompt": boolean,
    "Comment2Prompt": boolean,
    "Comment3Prompt": boolean,
    "Comment4Prompt": boolean,
    "Comment5Prompt": boolean,
    "Comment2Code": string,
    "Comment3Code": string,
    "Comment4Code": string,
    "Comment5Code": string,
    "Discount1": integer.integer,
    "Discount2": integer.integer,
    "Discount3": integer.integer,
    "Discount4": integer.integer,
    "Discount5": integer.integer,
    "Discount6": integer.integer,
    "Discount7": integer.integer,
    "Discount8": integer.integer,
    "Discount9": integer.integer,
    "Discount1integer": integer.integer,
    "NotUMRP": boolean,
    "Flooring": boolean,
    "MasterPackQty": integer,
    "ABCRating": string,
    "ActualSpiff": integer.integer,
    "SalePrice2": integer.integer,
    "SaleStartDate2": YYYY-MM-DD,
    "SaleEndDate2": YYYY-MM-DD,
    "Weight": integer.integer,
    "LinqProductId": string,
    "BeingDiscontinued": boolean,
    "FeaturesCode": string,
    "Active": boolean,
    "AverageCost": integer.integer,
    "Barcode": string,
    "BeginYearQty": integer,
    "BinLocationCode": string,
    "BrandCode": string,
    "Code": string,
    "Color": string,
    "CommentCode": string,
    "DateCreated": YYYY-MM-DD,
    "DateModified": YYYY-MM-DD,
    "Description": string,
    "EOQ": integer,
    "Equivalent": string,
    "ExtWarrantyCode": string,
    "Field1": string,
    "Field2": string,
    "Field3": string,
    "Field4": string,
    "Field5": string,
    "InventoryTypeCode": string,
    "LandedCost": integer.integer,
    "LandingFactor": integer.integer,
    "LastCost": integer.integer,
    "LastDateOrdered": YYYY-MM-DD,
    "LastDateReceived": YYYY-MM-DD,
    "LastDateSold": YYYY-MM-DD,
    "ListPrice": integer.integer,
    "LocQOH": integer,
    "LocYTD": integer,
    "MainStockQOH": integer,
    "MainStockYTD": integer,
    "ManufacturersWarranty": integer,
    "MfgReturned": integer,
    "MiscCode": string,
    "NewUsed": string,
    "Note": string,
    "Obsolete": boolean,
    "OriginalCost": integer.integer,
    "PicturePath": string,
    "Points": integer.integer,
    "PriceTag": string,
    "ProductCode": string,
    "ReplacementCost": integer.integer,
    "ReplacementCostEffectiveDate": YYYY-MM-DD,
    "ResizePicture": boolean,
    "SKU": string,
    "Spiff": integer.integer,
    "SpiffEndDate": YYYY-MM-DD,
    "SpiffStartDate": YYYY-MM-DD,
    "StandardCost": integer.integer,
    "Stock": boolean,
    "Substituted": boolean,
    "SupplierCode": string,
    "Tax1": boolean,
    "Tax1CostList": string,
    "Tax1Included": boolean,
    "Tax1Percentage": integer.integer,
    "Tax2": boolean,
    "Tax3": boolean,
    "TotalBooked": integer,
    "TotalLastYear": integer,
    "TotalMax": integer,
    "TotalMin": integer,
    "TotalNotAvailable": integer,
    "TotalPrevLastYear": integer,
    "TotalQOO": integer,
    "TotalReserved": integer,
    "UserCreated": string,
    "UserModified": string,
    "Ats": integer
}
<-Return to Model