JDBC Driver for Sage 50 UK

Build 22.0.8462

Commodities

Create, Update and Query Commodities (Products and Services) within Sage UK 50 Accounts.

Table Specific Information

The Commodities table allows you to select, insert, and update Commodities (Products and Services) within a Sage 50 UK company dataset.

Select

The Commodities table returns the products and services for a Sage 50 UK company dataset.

SELECT * FROM Commodities WHERE ProductCode LIKE 'ABC%'

Insert

To create a new Commodity record, the Description field is required.


INSERT INTO Commodities (ProductCode, Description, SupplierReference, CatalogueNumber, WebDescription, Cost)
VALUES ('MNP', 'MyNewProduct', 'UNI001', 'U143', 'My Web Description', 5.49)

Update

Any field that is not read-only can be updated.


UPDATE Commodities SET Description ='My New Description' WHERE CommodityUUID='8c47b43a-7115-7419-9679-7c72586e67d1'

Columns

Name Type ReadOnly Description
CommodityUUID [KEY] String True

Commodity UUID

CommodityIdentifierType String False

Commodity CommodityIdentifier Type

ProductCode String False

Commodity Product Code

Reference2 String False

Commodity Reference2

Status String False

Commodity Status

Description String False

Commodity Description

WebDescription String False

Commodity Web Description

AlternativeDescription2 String False

Commodity Alternative Description 2

Type String True

Commodity Type (Category)

BuyingAllowedFlag Boolean False

Commodity Buying Allowed Flag

SellingAllowedFlag Boolean False

Commodity Selling Allowed Flag

CatalogueNumber String False

Commodity Catalogue (Part) Number

SupplierReference String False

Commodity Supplier reference

ManufacturerCompany String False

Commodity Manufacturer Company

Weight Decimal False

Commodity Weight

Classification String False

Commodity Classification

Cost Decimal False

Commodity Cost

InStock Decimal True

Commodity Amount in Stock

Allocated Decimal True

Commodity Amount Allocated

FreeStock Decimal True

Commodity Free Stock

OnOrder Decimal True

Commodity Amount on Order

SalesPrice Decimal True

Commodity Sales Price in base currency

UnitDescription String True

Commodity UnitOfMeasure Description

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Updated Datetime

An input used internally to filter records updated at a specific datetime.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462