SSIS Components for Sage 200

Build 20.0.7587

SalesPostedTransactions

Sales posted transactions are created when transactions, such as orders invoiced, receipts, refunds or credit notes, are posted against the Sales Ledger. It is not possible to use this API resource to create posted transactions. To post a transaction, the necessary API resource must be invoked. When making larger requests for customer information, the Sales Transactions Views resource can be a faster alternative to this resource.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process search criteria. All filters are processed server side except: NominalAnalysisItems,TaxAnalysisItems,BankItems,AllocationSessionItems,AllocationHistoryItems columns.

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

For example, the following queries are processed server side:

SELECT * FROM SalesPostedTransactions WHERE Id=29674
SELECT * FROM SalesPostedTransactions WHERE CustomerId=27849
SELECT * FROM SalesPostedTransactions WHERE TraderTransactionType='TradingAccountEntryTypeInvoice'
SELECT * FROM SalesPostedTransactions WHERE Reference='O/BAL'
SELECT * FROM SalesPostedTransactions WHERE SecondReference='Opening Balance'
SELECT * FROM SalesPostedTransactions WHERE Queried='abc'
SELECT * FROM SalesPostedTransactions WHERE TransactionDate='2017-12-31T01:00:00.000+01:00'
SELECT * FROM SalesPostedTransactions WHERE PostedDate='2018-09-13T02:00:00.000+02:00'
SELECT * FROM SalesPostedTransactions WHERE DueDate='2018-02-14T01:00:00.000+01:00'
SELECT * FROM SalesPostedTransactions WHERE FullSettlementDate='2019-04-15T02:00:00.000+02:00'
SELECT * FROM SalesPostedTransactions WHERE DocumentGoodsValue=150
SELECT * FROM SalesPostedTransactions WHERE DocumentGrossValue=150
SELECT * FROM SalesPostedTransactions WHERE DocumentTaxValue=0
SELECT * FROM SalesPostedTransactions WHERE DocumentDiscountValue=0
SELECT * FROM SalesPostedTransactions WHERE DiscountPercent=0
SELECT * FROM SalesPostedTransactions WHERE DocumentTaxDiscountValue=0
SELECT * FROM SalesPostedTransactions WHERE DocumentAllocatedValue=150
SELECT * FROM SalesPostedTransactions WHERE DocumentOutstandingValue=0
SELECT * FROM SalesPostedTransactions WHERE BaseGoodsValue=150
SELECT * FROM SalesPostedTransactions WHERE BaseGrossValue=150
SELECT * FROM SalesPostedTransactions WHERE BaseTaxValue=0
SELECT * FROM SalesPostedTransactions WHERE BaseDiscountValue=0
SELECT * FROM SalesPostedTransactions WHERE BaseTaxDiscountValue=0
SELECT * FROM SalesPostedTransactions WHERE BaseAllocatedValue=150
SELECT * FROM SalesPostedTransactions WHERE ControlValueInBaseCurrency=0
SELECT * FROM SalesPostedTransactions WHERE ExchangeRate=1
SELECT * FROM SalesPostedTransactions WHERE SettledImmediately=false
SELECT * FROM SalesPostedTransactions WHERE DiscountDays=0
SELECT * FROM SalesPostedTransactions WHERE Urn=1
SELECT * FROM SalesPostedTransactions WHERE UserName='Migration'
SELECT * FROM SalesPostedTransactions WHERE DateTimeUpdated='2018-02-28T15:23:46.330+01:00'

Columns

Name Type References Description
Id [KEY] Long Id.
CustomerId Long Customer Id. See customers
TraderTransactionType String Transaction type. See trader_transaction_types
Reference String Transaction reference.
SecondReference String Second reference.
Queried String Query flag.
TransactionDate Date Transaction date.
PostedDate Date Posted date.
DueDate Date Due date.
FullSettlementDate Date Full settlement date.
DocumentGoodsValue Decimal Value of the goods.
DocumentGrossValue Decimal Gross value.
DocumentTaxValue Decimal Tax value.
DocumentDiscountValue Decimal Document discount value.
DiscountPercent Decimal Percentage discount.
DocumentTaxDiscountValue Decimal Tax discount value.
DocumentAllocatedValue Decimal Allocated value.
DocumentOutstandingValue Decimal Outstanding value.
BaseGoodsValue Decimal Value of the goods in base currency.
BaseGrossValue Decimal Gross value in base currency.
BaseTaxValue Decimal Tax value in base currency.
BaseDiscountValue Decimal Discount value in base currency.
BaseTaxDiscountValue Decimal Tax discount value in base currency.
BaseAllocatedValue Decimal Allocated value in base currency.
ControlValueInBaseCurrency Decimal Control value in base currency.
ExchangeRate Decimal Exchange rate used for transaction.
SettledImmediately Bool Immediately settled.
DiscountDays Short Number of days discount valid.
Urn Long Unique reference number.
UserName String User who entered the transaction.
NominalAnalysisItems String Nominal analysis items. See sales_posted_transactions_nominal_analysis_items
TaxAnalysisItems String Tax analysis items. See sales_posted_transactions_tax_analysis_items
BankItems String Bank items. See sales_posted_transactions_bank_items
AllocationSessionItems String Allocation session items. See sales_posted_transactions_allocation_session_items
AllocationHistoryItems String Allocation history items. See sales_posted_transactions_allocation_history_items
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