JDBC Driver for Reckon Accounts Hosted

Build 22.0.8462

SalesOrderLinkedTransactions

Query Reckon Sales Order Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the SalesOrder specified by the SalesOrderId column.

Columns

Name Type References Description
ID [KEY] String The unique identifier in the format SalesOrderId|ItemLineId.
SalesOrderId String

SalesOrders.ID

The item identifier.
ReferenceNumber String Transaction reference number.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the Reckon-generated Id.
CustomerName String

Customers.FullName

Customer name this transaction is recorded under.
CustomerId String

Customers.ID

Customer Id this transaction is recorded under.
Date Date Transaction date.
TransactionId String

Invoices.ID

The Id of the linked transaction.
TransactionAmount Double The amount of the linked transaction.
TransactionDate Date The date of the linked transaction.
TransactionReferenceNumber String The reference number of the linked transaction.
TransactionType String The type of linked transaction.
TransactionLinkType String The link type between the sales order and linked transaction.
TimeModified Datetime When the sales order was last modified.
TimeCreated Datetime When the sales order was created.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartTxnDate String This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for.
EndTxnDate String This pseudo column is deprecated and should no longer be used. Latest transaction date to search for.
StartModifiedDate String This pseudo column is deprecated and should no longer be used. Earliest modified date to search for.
EndModifiedDate String This pseudo column is deprecated and should no longer be used. Latest modified date to search for.
ItemPriceLevel String Item price level name. Reckon will not return the price level.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462