StatementChargeLinkedTransactions

Query Reckon Statement Charge Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the StatementCharge specified by the StatementChargeId column.

Name	Type	References	Description
ID [KEY]	String		The unique identifier in the format StatementChargeId\|TransactionLineId.
StatementChargeId	String	StatementCharges.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		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 statement charge and linked transaction.
TimeModified	Datetime		When the statement charge was last modified.
TimeCreated	Datetime		When the statement charge was created.