NominalTransactionAnalysisCodes
Nominal transaction analysis codes are used to group nominal analysis items on various transaction types
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 NominalTransactionAnalysisCodes WHERE Code = 'Promo0715' SELECT * FROM NominalTransactionAnalysisCodes WHERE Description = 'Promotion July 2015' SELECT * FROM NominalTransactionAnalysisCodes WHERE Active = true SELECT * FROM NominalTransactionAnalysisCodes WHERE DateTimeUpdated = '2018-02-28T15:23:46.413+01:00'
Columns
Name | Type | References | Description |
Code [KEY] | String | Nominal transaction analysis code. | |
Description | String | Nominal transaction analysis code description. | |
Active | Bool | Boolean indicating whether the transaction analysis code is active. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |