CData Python Connector for Sage 200

Build 20.0.7587

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

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