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