ODBC Driver for Sage 200

Build 20.0.7587

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).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587