ItemReceiptLinkedTransactions
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 | 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.
The allowed values are ARRefundCreditCard, Bill, BillPaymentCheck, BillPaymentCreditCard, BuildAssembly, Charge, Check, CreditCardCharge, CreditCardCredit, CreditMemo, Deposit, Estimate, InventoryAdjustment, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, PurchaseOrder, ReceivePayment, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, VendorCredit, YTDAdjustment. | |
| TransactionLinkType | String | The link type between the item receipt and linked transaction.
The allowed values are AMTTYPE, QUANTYPE. | |
| 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. |