None.
api/InventoryItems/RetrieveSchema
Returns the success/error status along with requested table schema.
The status of the request, namely Success or Error.
The response message containing either message or requested data.
[{ "Status":1, "Message": "[ {"CompanyID":"Int Mandatory"}, {"BrandID":"Int Mandatory"}, {"ItemID":"String(36) Mandatory"}, {"IsActive":"Bool Optional"}, {"TypeID":"String(36) Optional"}, {"Name":"String(255) Optional"}, {"Description":"String(255) Optional"}, {"LongDescription":"String(1000) Optional"}, {"CategoryID":"String(36) Optional"}, {"FamilyID":"String(36) Optional"}, {"SalesDescription":"String(50) Optional"}, {"PurchaseDescription":"String(50) Optional"}, {"PictureURL":"String(150) Optional"}, {"LargePictureURL":"String(150) Optional"}, {"Weight":"Double(53,0) Optional"}, {"WeightMetric":"Double(53,0) Optional"}, {"ShipWeight":"Int Optional"}, {"UPCCode":"String(20) Optional"}, {"EPCCode":"String(12) Optional"}, {"RFID":"String(80) Optional"}, {"Size":"String(50) Optional"}, {"SizeCmm":"String(50) Optional"}, {"Dimentions":"String(10) Optional"}, {"DimentionsCmm":"String(50) Optional"}, {"Color":"String(50) Optional"}, {"NRFColor":"String(50) Optional"}, {"Style":"String(50) Optional"}, {"NRFStyle":"String(50) Optional"}, {"CareInstructions":"String(255) Optional"}, {"DefaultWarehouse":"String(36) Optional"}, {"DefaultWarehouseBin":"String(36) Optional"}, {"LocationX":"String(10) Optional"}, {"LocationY":"String(10) Optional"}, {"LocationZ":"String(10) Optional"}, {"DownloadLocation":"String(120) Optional"}, {"DownloadPassword":"String(20) Optional"}, {"UOM":"String(15) Optional"}, {"GLItemSalesAccount":"String(36) Optional"}, {"GLItemCOGSAccount":"String(36) Optional"}, {"GLItemInventoryAccount":"String(36) Optional"}, {"CurrencyID":"String(3) Mandatory"}, {"CurrencyExchangeRate":"Double(53,0) Optional"}, {"Price":"Decimal(19,4) Optional"}, {"PricingCode":"String(36) Optional"}, {"PricingMethods":"String(36) Optional"}, {"Taxable":"Bool Optional"}, {"VendorID":"String(50) Optional"}, {"LeadTime":"String(50) Optional"}, {"LeadTimeUnit":"String(10) Optional"}, {"ReOrderLevel":"Int Optional"}, {"ReOrderQty":"Int Optional"}, {"BuildTime":"Int Optional"}, {"BuildTimeUnit":"String(10) Optional"}, {"UseageRate":"Int Optional"}, {"UseageRateUnit":"String(10) Optional"}, {"SalesForecast":"Int Optional"}, {"SalesForecastUnit":"String(10) Optional"}, {"CalculatedCover":"Int Optional"}, {"CalculatedCoverUnits":"String(10) Optional"}, {"IsAssembly":"Bool Optional"}, {"Assembly":"String(36) Optional"}, {"LIFO":"Decimal(19,4) Optional"}, {"LIFOValue":"Decimal(19,4) Optional"}, {"LIFOCost":"Decimal(19,4) Optional"}, {"Average":"Decimal(19,4) Optional"}, {"AverageValue":"Decimal(19,4) Optional"}, {"AverageCost":"Decimal(19,4) Optional"}, {"FIFO":"Decimal(19,4) Optional"}, {"FIFOValue":"Decimal(19,4) Optional"}, {"FIFOCost":"Decimal(19,4) Optional"}, {"Expected":"Decimal(19,4) Optional"}, {"ExpectedValue":"Decimal(19,4) Optional"}, {"ExpectedCost":"Decimal(19,4) Optional"}, {"Landed":"Decimal(19,4) Optional"}, {"LandedValue":"Decimal(19,4) Optional"}, {"LandedCost":"String(10) Optional"}, {"Other":"Decimal(19,4) Optional"}, {"OtherValue":"Decimal(19,4) Optional"}, {"OtherCost":"Decimal(19,4) Optional"}, {"Commissionable":"Bool Optional"}, {"CommissionType":"Short Optional"}, {"CommissionPerc":"Double(53,0) Optional"}, {"Approved":"Bool Optional"}, {"ApprovedBy":"String(36) Optional"}, {"ApprovedDate":"DateTime Optional"}, {"EnteredBy":"String(36) Optional"}, {"TaxGroupID":"String(36) Optional"}, {"TaxPercent":"Double(53,0) Optional"}, {"PageURL":"String(80) Optional"}, {"CategoryID2":"String(36) Optional"}, {"FamilyID2":"String(36) Optional"}, {"ObsoletePartNumber":"String(32) Optional"}, {"ProductModel":"String(16) Optional"}, {"Series":"String(16) Optional"}, {"ProductUnitSize":"String(32) Optional"}, {"SearchKeywords":"String(255) Optional"}, {"DrawingNo":"String(16) Optional"}, {"FactoryNotes":"String(255) Optional"}, {"Notes":"String(255) Optional"}, {"AssociatedPartNumber":"String(32) Optional"}, {"InfoURL1":"String(255) Optional"}, {"InfoURL2":"String(255) Optional"}, {"InfoURL3":"String(255) Optional"}, {"LeadTimeQtyCutoff":"String(8) Optional"}, {"LeadTime2":"String(8) Optional"}, {"MinOrderQty":"Int Optional"}, {"Department":"String(50) Optional"}, {"RepPart":"Bool Optional"}, {"DisplayOrder":"Int Mandatory"}, {"Discontinued":"Bool Optional"}, {"DiscountPerc":"Double(53,0) Optional"} ]" }]