Model Table Fields
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
}