CData Excel Add-In for Reckon 2019 - Online Help
Questions / Feedback?

ItemReceiptLinkedTransactions

CData Excel Add-In for Reckon 2019 - Build 19.0.7354

Query Reckon Item Receipt Linked Transactions.

Table Specific Information

Linked transactions are transactions that have been associated with the ItemReceipts specified by the ItemReceiptId column.

Columns

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

ItemReceipts.ID

The item identifier for the item receipt. This is obtained from the ItemReceipts table.
VendorName String

Vendors.Name

The name of the vendor. Either VendorName or VendorId must be specified when inserting an item receipt.
VendorId String

Vendors.ID

The unique Id of the vendor. Either VendorName or VendorId must be specified when inserting an item receipt.
Date Date The transaction date.
ReferenceNumber String The transaction reference number.
AccountsPayable String

Accounts.FullName

A reference to the name of the account the item receipt is payable to.
AccountsPayableId String

Accounts.ID

A reference to the unique Id of the account the item receipt is payable to.
Memo String A memo regarding the item receipt.
Amount Double Total amount of the item receipt.
TxnNumber Integer The transaction number. An identifying number for the transaction, different from the Reckon-generated Id.
TransactionId# String

PurchaseOrders.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 item receipt and linked transaction.
CustomFields String Custom fields returned from Reckon and formatted into XML.
EditSequence String An identifier used for versioning for this copy of the object.
TimeModified Datetime When the item receipt was last modified.
TimeCreated Datetime When the item receipt 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.

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