ProductTransactions

A product transaction is created each time a product is moved in, or out of stock. Product transactions are created from various sources such as purchase orders, sales orders, transfers between warehouses etc.. This resource returns the details of product transactions. The default sort (orderby) field is by 'id' descending.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM ProductTransactionViews WHERE Id = 36511
SELECT * FROM ProductTransactionViews WHERE ProductId = 34751
SELECT * FROM ProductTransactionViews WHERE ProductCode = 'BOARD001'
SELECT * FROM ProductTransactionViews WHERE ProductGroupId = 34640
SELECT * FROM ProductTransactionViews WHERE ProductGroupCode = '0006'
SELECT * FROM ProductTransactionViews WHERE TransactionType = 'EnumSecondaryActivityTypeStockTakeAdjustmentIn'
SELECT * FROM ProductTransactionViews WHERE TransactionDate = '2015-12-31T01:00:00.000+01:00'
SELECT * FROM ProductTransactionViews WHERE SourceAreaReference = 'abc'
SELECT * FROM ProductTransactionViews WHERE SourceAreaName = 'Internal'
SELECT * FROM ProductTransactionViews WHERE Reference = 'abc'
SELECT * FROM ProductTransactionViews WHERE SecondReference = 'STK TAKE'
SELECT * FROM ProductTransactionViews WHERE WarehouseName = 'Warehouse'
SELECT * FROM ProductTransactionViews WHERE BinName = 'Unspecified'
SELECT * FROM ProductTransactionViews WHERE Quantity = 2
SELECT * FROM ProductTransactionViews WHERE UnitCostPrice = 15
SELECT * FROM ProductTransactionViews WHERE UnitIssuePrice = 0
SELECT * FROM ProductTransactionViews WHERE UnitDiscountValue = 0
SELECT * FROM ProductTransactionViews WHERE TotalOrderDiscount = 0
SELECT * FROM ProductTransactionViews WHERE CostValue = 30
SELECT * FROM ProductTransactionViews WHERE IssueValue = 0
SELECT * FROM ProductTransactionViews WHERE Memo = 'abc'
SELECT * FROM ProductTransactionViews WHERE UserName = 'Migration'
SELECT * FROM ProductTransactionViews WHERE AnalysisCode1 = 'abc'
SELECT * FROM ProductTransactionViews WHERE AnalysisCode2 = 'abc'
SELECT * FROM ProductTransactionViews WHERE AnalysisCode3 = 'abc'
SELECT * FROM ProductTransactionViews WHERE AnalysisCode4 = 'abc'
SELECT * FROM ProductTransactionViews WHERE AnalysisCode5 = 'abc'
SELECT * FROM ProductTransactionViews WHERE DateTimeUpdated = '2018-02-28T15:23:46.123+01:00'

Columns


Name	Type	References	Description
Id [KEY]	Long		Product transaction Id.
ProductId	Long		Product record Id. See products
ProductCode	String		Product code.
ProductGroupId	Long		Product group record Id. See product_groups
ProductGroupCode	String		Product group code. See product_groups
TransactionType	String		Enum value that describes the transaction that created the product movement. See product_transaction_types
TransactionDate	Date		The date of the transaction.
SourceAreaReference	String		The code of the source of the transaction.
SourceAreaName	String		The name of the source of the transaction.
Reference	String		This can be an optional reference added to the transaction by the user, or an automatically generated reference such as the order number.
SecondReference	String		This can be an additional optional reference added to the transaction by the user, or an automatically generated reference such as the despatch note number.
WarehouseName	String		The warehouse the product was moved from or to. See warehouses
BinName	String		The name of the bin to which the transaction relates to.
Quantity	Decimal		The quantity on the transaction.
UnitCostPrice	Decimal		The cost price per unit for this transaction.
UnitIssuePrice	Decimal		The price used when products are moved out of stock.
UnitDiscountValue	Decimal		The discount amount per unit used for this transaction.
TotalOrderDiscount	Decimal		The total discount value of the transaction.
CostValue	Decimal		The total cost value.
IssueValue	Decimal		The total issue or sales price of the transaction.
Memo	String		Any memo note that was applied to the product transaction.
UserName	String		The name of the Sage 200 user that created the transaction.
AnalysisCode1	String		Analysis Code 1.
AnalysisCode2	String		Analysis Code 2.
AnalysisCode3	String		Analysis Code 3.
AnalysisCode4	String		Analysis Code 4.
AnalysisCode5	String		Analysis Code 5.
AnalysisCode6	String		Analysis code 6.
AnalysisCode7	String		Analysis code 7.
AnalysisCode8	String		Analysis code 8.
AnalysisCode9	String		Analysis code 9.
AnalysisCode10	String		Analysis code 10.
AnalysisCode11	String		Analysis code 11.
AnalysisCode12	String		Analysis code 12.
AnalysisCode13	String		Analysis code 13.
AnalysisCode14	String		Analysis code 14.
AnalysisCode15	String		Analysis code 15.
AnalysisCode16	String		Analysis code 16.
AnalysisCode17	String		Analysis code 17.
AnalysisCode18	String		Analysis code 18.
AnalysisCode19	String		Analysis code 19.
AnalysisCode20	String		Analysis code 20.
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

JDBC Driver for Sage 200

ProductTransactions

Table Specific Information

Select

Columns