Transactions
Query Reckon transactions. You may search the Transactions using a number of values including Type, Entity, Account, ReferenceNumber, Item, Class, Date, and TimeModified.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier of the transaction. | |
| TxnLineId | String | The id of the individual line item. | |
| Type | String | The transaction type of the result.
The allowed values are All, 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. | |
| Date | Datetime | The date of the transaction. | |
| Entity | String | The name of the entity associated with the transaction. For example, the name of a customer, vendor, employee, or other name. | |
| EntityId | String | The Id of the entity associated with the transaction. For example, the name of a customer, vendor, employee, or other name. | |
| AccountName | String |
Accounts.Name | The name of the account associated with the transaction. |
| AccountId | String |
Accounts.ID | The Id of the account associated with the transaction. |
| ReferenceNumber | String | The reference number of the transaction, if applicable. | |
| Amount | Double | The amount of the transaction. | |
| Memo | String | The memo appearing on the transaction. | |
| TimeModified | Datetime | When the transaction was last modified. | |
| TimeCreated | Datetime | When the transaction was created. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| ItemName | String | The item name appearing in the transaction. | |
| ItemId | String | The item Id appearing in the transaction. | |
| ClassName | String | The class name applied to the transaction. | |
| ClassId | String | The class Id applied to the transaction. | |
| PostingStatus | String | The posting status of transactions to return.
The allowed values are Either, NonPosting, Posting. The default value is Either. | |
| IsPaid | String | The paid status of transactions to return. Enter either true or false. | |
| DetailLevel | String | The level of detail to use when filtering objects.
The allowed values are All, AllExceptSummary, SummaryOnly. The default value is SummaryOnly. |