Products Resource

The Products Resource allows read access to the Sage 100 Products table.

Resource Method List
ActionHTTPURIAdmin?Description
getGET/products?itemCode=<itemCode>Retrieve product data for one product
listGET/products
/products?offset=<offset>&limit=<limit>
/products?itemType=<1|2|3|4|5>
OnlyRetrieve a list of products

Resource Table List
Click on the table to view detail.

Category

Element NameDescriptionTypeLength
categoryCategoryString64
categoryRIDCategory Reference IDString8
categoryDescriptionCategory DescriptionString64
categoryImageCategory ImageString64
categoryShortDescriptionCategory Short DescriptionString2048
categoryLongDescriptionCategory Long DescriptionString4096
mainNavigationMain NavigationNumeric1
categoryEnabledCategory EnabledNumeric1
parentCategoryParent CategoryString64

CI Item

Element NameDescriptionTypeLength
ItemCodeItem CodeString30
ItemTypeItem TypeString1
ItemCodeDescItem Code DescriptionString30
ExtendedDescriptionKeyExtended Description KeyString10
UseInARUse In ARString1
UseInSOUse In SOString1
UseInPOUse In POString1
UseInBMUse In BMString1
CalculateCommissionCalculate CommissionString1
DropShipDrop ShipString1
EBMEnabledeBusiness Manager EnabledString1
AllowBackOrdersAllow Back OrdersString1
AllowReturnsAllow ReturnsString1
PriceCodePrice CodeString4
AllowTradeDiscountAllow Trade DiscountString1
PrintReceiptLabelsPrint Receipt LabelsString1
AllocateLandedCostAllocate Landed CostString1
InactiveItemInactive ItemString1
ConfirmCostIncrInRcptOfGoodsConfirm Cost Increase in Receipt Of GoodsString1
WarrantyCodeWarranty CodeString10
SalesUnitOfMeasureSales Unit of MeasureString4
PurchaseUnitOfMeasurePurchase Unit of MeasureString4
StandardUnitOfMeasureStandard Unit of MeasureString4
PostToGLByDivisionPost to G/L By DivisionString1
SalesAcctKeySales Account KeyString9
CostOfGoodsSoldAcctKeyCost Of Goods Sold Account KeyString9
InventoryAcctKeyInventory Account KeyString9
PurchaseAcctKeyPurchase Account KeyString9
ManufacturingCostAcctKeyManufacturing Cost Account KeyString9
TaxClassTax ClassString2
PurchasesTaxClassPurchases Tax ClassString2
ProductLineProduct LineString4
ProductTypeProduct TypeString1
ValuationValuationString1
DefaultWarehouseCodeDefault Warehouse CodeString3
PrimaryAPDivisionNoPrimary AP Division NumberString2
PrimaryVendorNoPrimary Vendor NumberString7
ImageFileImage FileString30
LastSoldDateLast Sold DateString8
LastReceiptDateLast Receipt DateString8
Category1Category 1String10
Category2Category 2String10
Category3Category 3String10
Category4Category 4String10
SalesPromotionCodeSales Promotion CodeString10
SaleStartingDateSale Starting DateString8
SaleEndingDateSale Ending DateString8
SaleMethodSale MethodString1
ExplodeKitItemsExplode Kit ItemsString1
ShipWeightShip WeightString10
CommentTextComment TextString2048
RestockingMethodRestocking MethodString1
NextLotSerialNoNext Lot/Serial NumberString15
InventoryCycleInventory CycleString1
RoutingNoRouting NumberString20
ProcurementTypeProcurement TypeString1
PlannerCodePlanner CodeString3
BuyerCodeBuyer CodeString3
LowLevelCodeLow Level CodeString2
PlannedByMRPPlanned By MrpString1
VendorItemCodeVendor Item CodeString30
SetupChargeSetup ChargeString1
AttachmentFileNameAttachment File NameString30
ItemImageWidthInPixelsItem Image Width In PixelsNumeric4
ItemImageHeightInPixelsItem Image Height In PixelsNumeric4
StandardUnitCostStandard Unit CostNumeric16.6
StandardUnitPriceStandard Unit PriceNumeric16.6
LastTotalUnitCostLast Total Unit CostNumeric16.6
AverageUnitCostAverage Unit CostNumeric16.6
SalesPromotionPriceSales Promotion PriceNumeric16.6
SuggestedRetailPriceSuggested Retail PriceNumeric16.6
SalesPromotionDiscountPercentSales Promotion Discount PercentageNumeric12.3
TotalQuantityOnHandTotal Quantity On HandNumeric16.6
AverageBackOrderFillDaysAverage Back Order Fill DaysNumeric5
LastAllocatedUnitCostLast Allocated Unit CostNumeric16.6
CommissionRateCommission RateNumeric9.3
BaseCommAmtBase Commission AmountNumeric12.2
PurchaseUMConvFctrPurchase Unit of Measure Conversion FactorNumeric12.4
SalesUMConvFctrSales Unit of Measure Conversion FactorNumeric12.4
VolumeVolumeNumeric11.4
RestockingChargeRestocking ChargeNumeric11.3
TotalInventoryValueTotal Inventory ValueNumeric15.2
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

CI Extended Description

Element NameDescriptionTypeLength
ExtendedDescriptionKeyExtended Description KeyString10
ExtendedDescriptionTextExtended Description TextString4096
CreationModuleCodeCreation Module CodeString3
UpdatedModuleCodeUpdated Module CodeString3
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Warehouse

Element NameDescriptionTypeLength
WarehouseCodeWarehouse CodeString3
WarehouseDescWarehouse DescriptionString30
WarehouseNameWarehouse NameString30
WarehouseAddress1Warehouse Address Line 1String30
WarehouseAddress2Warehouse Address Line 2String30
WarehouseAddress3Warehouse Address Line 3String30
WarehouseCityWarehouse CityString20
WarehouseStateWarehouse StateString2
WarehouseZipCodeWarehouse Zip CodeString10
WarehouseCountryCodeWarehouse Country CodeString3
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
EmailAddressEmail AddressString50
ContactNameContact NameString30
PostToGLSubAcctPost To G/L Sub AccountString15
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AP Vendor Contact

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
ContactCodeContact CodeString10
ContactNameContact NameString30
AddressLine1Contact Address Line 1String30
AddressLine2Contact Address Line 2String30
AddressLine3Contact Address Line 3String30
CityContact CityString20
StateContact StateString2
ZipCodeContact Zip CodeString10
CountryCodeContact Country CodeString3
SalutationContact SalutationString10
ContactTitleContact TitleString15
TelephoneNo1Contact Telephone Number 1String17
TelephoneExt1Contact Telephone Extension 1String5
TelephoneNo2Contact Telephone Number 2String17
TelephoneExt2Contact Telephone Extension 2String5
FaxNoFax NumberString17
EmailAddressContact Email AddressString50
ContactNotesContact NotesString256
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AP Division

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
APDivisionDescAP Division DescriptionString30
AccountsPayableAcctKeyAccounts Payable Account KeyString9
DiscountsEarnedOrTakenAcctKeyDiscounts Earned Or Taken Account KeyString9
CashAcctKeyCash Account KeyString9
DiscountsLostAcctKeyDiscounts Lost Account KeyString9
RetentionPayableAcctKeyRetention Payable Account KeyString9
FreightAcctKeyFreight Account KeyString9
SalesTaxAcctKeySales Tax Account KeyString9
NonRecoverableTaxAcctKeyNon-Recoverable Tax Account KeyString9
UseTaxAcctKeyUse Tax Account KeyString9
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Warranty Code

Element NameDescriptionTypeLength
WarrantyCodeWarranty CodeString10
WarrantyCodeDescWarranty Code DescriptionString30
WarrantyDaysWarranty DaysNumeric4
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Product Line

Element NameDescriptionTypeLength
ProductLineProduct LineString4
ProductLineDescProduct Line DescriptionString25
ProductTypeProduct TypeString1
ValuationValuationString1
PriceCodePrice CodeString4
AllowBackOrdersAllow Back OrdersString1
ExplodeKitItemsExplode Kit ItemsString1
CalculateCommissionCalculate CommissionString1
StandardUnitOfMeasureStandard Unit Of MeasureString4
PurchaseUnitOfMeasurePurchase Unit Of MeasureString4
SalesUnitOfMeasureSales Unit Of MeasureString4
ProcurementTypeProcurement TypeString1
InventoryCycleInventory CycleString1
AllowTradeDiscountAllow Trade DiscountString1
InactiveItemInactive ItemString1
AllocateLandedCostAllocate Landed CostString1
TaxClassTax ClassString2
PurchasesTaxClassPurchasesTax ClassString2
PrintReceiptLabelsPrint Receipt LabelsString1
ConfirmCostIncrInRcptOfGoodsConfirm Cost Increase In Receipt Of GoodsString1
PostInventoryByWhsePost Inventory By WarehouseString1
PostCostOfGoodsSoldByWhsePost Cost Of Goods Sold By WarehouseString1
PostSalesIncomeByWhsePost Sales/Income By WarehouseString1
PostReturnsByWhsePost Returns By WarehouseString1
PostAdjustmentByWhsePost Adjustment By WarehouseString1
PostPurchaseByWhsePost Purchases By WarehouseString1
PostPOVarianceByWhsePost Po Variance By WarehouseString1
PostMFGVarianceByWhsePost Manufacturing Variance By WarehouseString1
InventoryAcctKeyInventory Account KeyString9
CostOfGoodsSoldAcctKeyCost Of Goods Sold Account KeyString9
SalesIncomeAcctKeySales Income Account KeyString9
ReturnsAcctKeyReturns Account KeyString9
AdjustmentAcctKeyAdjustment Account KeyString9
PurchaseAcctKeyPurchase Account KeyString9
PurchaseOrderVarianceAcctKeyPurchase Order Variance Account KeyString9
ManufacturingVarianceAcctKeyManufacturing Variance Account KeyString9
WarrantyCodeWarranty CodeString10
AllowReturnsAllow ReturnsString1
RestockingMethodRestocking MethodString1
ScrapAcctKeyScrap Account KeyString9
RepairsInProcessAcctKeyRepairs In Process Account KeyString9
RepairsClearingAcctKeyRepairs Clearing Account KeyString9
PostScrapByWhsePost Scrap by WarehouseString1
PostRepairsInProcessByWhsePost Repairs In Process by WarehouseString1
PostRepairsClearingByWhsePost Repairs Clearing by WarehouseString1
CommissionRateCommission RateNumeric9.3
BaseCommAmtBase Commission AmountNumeric12.2
PurchaseUMConvFctrPurchase Unit Of Measure Conversion FactorNumeric12.4
SalesUMConvFctrSales Unit Of Measure Conversion FactorNumeric12.4
RestockingChargeRestocking ChargeNumeric11.3
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Price Code

Element NameDescriptionTypeLength
PriceCodeRecordPrice Code RecordString1
PriceCodePrice CodeString4
ItemCodeItem CodeString30
CustomerPriceLevelCustomer Price LevelString1
ARDivisionNoAR Division NumberString2
CustomerNoCustomer NumberString20
PriceCodeDescPrice Code DescriptionString25
PricingMethodPricing MethodString1
BreakQuantity1Break Quantity 1Numeric8
BreakQuantity2Break Quantity 2Numeric8
BreakQuantity3Break Quantity 3Numeric8
BreakQuantity4Break Quantity 4Numeric8
BreakQuantity5Break Quantity 5Numeric8
DiscountMarkup1Discount Markup 1Numeric16.6
DiscountMarkup2Discount Markup 2Numeric16.6
DiscountMarkup3Discount Markup 3Numeric16.6
DiscountMarkup4Discount Markup 4Numeric16.6
DiscountMarkup5Discount Markup 5Numeric16.6
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Buyer Planner Code

Element NameDescriptionTypeLength
BuyerPlannerCodeBuyer Planner CodeString3
LastNameLast NameString30
FirstNameFirst NameString20
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Sales Promotion

Element NameDescriptionTypeLength
SalesPromotionCodeSales Promotion CodeString10
SaleStartingDateSale Starting DateString8
SaleEndingDateSale Ending DateString8
SaleMethodSale MethodString1
SalePriceSale PriceNumeric16.6
DiscountPercentageDiscount PercentageNumeric11.3
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

IM Item Vendor

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
VendorNameVendor NameString30
AddressLine1Address Line 1String30
AddressLine2Address Line 2String30
AddressLine3Address Line 3String30
CityCityString20
StateStateString2
ZipCodeZip CodeString10
CountryCodeCountry CodeString3
PrimaryContactPrimary Contact CodeString10
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
EmailAddressEmail AddressString250
URLAddressURL AddressString50
TermsCodeTerms CodeString2
ReferenceVendor Reference NumberString15
TemporaryVendorObsolete 5.00String1
VendorStatusVendor StatusString1
InactiveReasonCodeInactive Reason CodeString5
CreditCardVendorCredit Card VendorString1
HoldPaymentHold PaymentString1
ElectronicPaymentElectronic Payment VendorString1
StandardEntryClassStandard Entry Class CodeString3
ExemptionNoOnFileExemption Number On FileString1
TaxScheduleTax ScheduleString9
TaxClassTax ClassString2
AccountKeyAccount KeyString9
SeparateCheckSeparate CheckString1
CommentVendor CommentString30
SortSort FieldString10
BatchFaxBatch FaxString1
UsePOReceiptOfInvForVendorUse PO Receipt Of Inv For VendorString1
PrimaryPurchaseAddressCodePurchase Address CodeString4
VendorTypeVendor TypeString1
Form1099Default 1099 FormString1
TaxpayerIDSocialSecurityNoTaxpayer ID/Social Security NumberString9
Box1099Default 1099 BoxString3
MiscBox9Mark Misc Box 9String1
LastPurchaseDateLast Purchase DateString8
LastPaymentDateLast Payment DateString8
LastCheckNoLast AP Check NumberString10
LastCheckAmtLast Check AmountNumeric15.2
RetentionRateRetention RateNumeric7.2
AverageDaysToPayAverage Days To PayNumeric3
AverageDaysOverDueAverage Days Over DueNumeric3
BalanceDueBalance DueNumeric16.2
NumberOfInvToUseInCalcNumber Of Invoices To Use In CalculationNumeric7
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

GL Account

AP Division

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
APDivisionDescAP Division DescriptionString30
AccountsPayableAcctKeyAccounts Payable Account KeyString9
DiscountsEarnedOrTakenAcctKeyDiscounts Earned Or Taken Account KeyString9
CashAcctKeyCash Account KeyString9
DiscountsLostAcctKeyDiscounts Lost Account KeyString9
RetentionPayableAcctKeyRetention Payable Account KeyString9
FreightAcctKeyFreight Account KeyString9
SalesTaxAcctKeySales Tax Account KeyString9
NonRecoverableTaxAcctKeyNon-Recoverable Tax Account KeyString9
UseTaxAcctKeyUse Tax Account KeyString9
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AP Vendor

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
VendorNameVendor NameString30
AddressLine1Address Line 1String30
AddressLine2Address Line 2String30
AddressLine3Address Line 3String30
CityCityString20
StateStateString2
ZipCodeZip CodeString10
CountryCodeCountry CodeString3
PrimaryContactPrimary Contact CodeString10
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
EmailAddressEmail AddressString250
URLAddressURL AddressString50
TermsCodeTerms CodeString2
ReferenceVendor Reference NumberString15
TemporaryVendorObsolete 5.00String1
VendorStatusVendor StatusString1
InactiveReasonCodeInactive Reason CodeString5
CreditCardVendorCredit Card VendorString1
HoldPaymentHold PaymentString1
ElectronicPaymentElectronic Payment VendorString1
StandardEntryClassStandard Entry Class CodeString3
ExemptionNoOnFileExemption Number On FileString1
TaxScheduleTax ScheduleString9
TaxClassTax ClassString2
AccountKeyAccount KeyString9
SeparateCheckSeparate CheckString1
CommentVendor CommentString30
SortSort FieldString10
BatchFaxBatch FaxString1
UsePOReceiptOfInvForVendorUse PO Receipt Of Inv For VendorString1
PrimaryPurchaseAddressCodePurchase Address CodeString4
VendorTypeVendor TypeString1
Form1099Default 1099 FormString1
TaxpayerIDSocialSecurityNoTaxpayer ID/Social Security NumberString9
Box1099Default 1099 BoxString3
MiscBox9Mark Misc Box 9String1
LastPurchaseDateLast Purchase DateString8
LastPaymentDateLast Payment DateString8
LastCheckNoLast AP Check NumberString10
LastCheckAmtLast Check AmountNumeric15.2
RetentionRateRetention RateNumeric7.2
AverageDaysToPayAverage Days To PayNumeric3
AverageDaysOverDueAverage Days Over DueNumeric3
BalanceDueBalance DueNumeric16.2
NumberOfInvToUseInCalcNumber Of Invoices To Use In CalculationNumeric7
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8

SY Sales Tax Class

Element NameDescriptionTypeLength
TaxClassTax ClassString2
TaxClassDescTax Class DescriptionString30
TaxClassTypeTax Class TypeString1


Get

Users and Administrators can retrieve data for a single Product. This can include data from any of the tables associated with the resource.

List

Users and Administrators can retrieve all product data from the Products Resource. The return can be limited to a number of products by specifying the Limit and Offset. The return can also be limited by passing any non-key column to the resource.