TABLES - Transactions
(USA VERSION)
NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
ARRefundCreditCardTransactionsAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
ARRefundCreditCardRefundAppliedToTransactionsAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
BillTransactionsMain Bill Table; used to pay bills, or write checks that do not apply to existing billsTable Relation Jumpins Detail
BillExpenseLineTransactionsProvides expense line detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillItemLineTransactionsProvides line item detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillLinkedTxnTransactionsBills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill TableTable Relation Jumpins Detail
BillPaymentCheckTransactionsMain table of Bill Payments paid by ChecksTable Relation Jumpins Detail
BillPaymentCheckLineTransactionsProvides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check Table Relation Jumpins Detail
BillPaymentCheckLineLinkedTxnTransactionsProvides Linked Txn line detail for a bill payment by check; contains all the information included in the Main Bill PayTable Relation Jumpins Detail
BillPaymentCreditCardTransactionsMain table of Bill Payments paid by Credit CardTable Relation Jumpins Detail
BillPaymentCreditCardLineTransactionsProvides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment Table Relation Jumpins Detail
BillPaymentCreditCardLineLinkedTxnTransactionsProvides Linked Txnline detail for a bill payment by credit card; contains all the information included in the Main BilTable Relation Jumpins Detail
ChargeTransactionsStatement Charges TableTable Relation Jumpins Detail
ChargeLinkedTxnTransactionsStatement Charge Linked TransactionsTable Relation Jumpins Detail
CheckTransactionsManual Checks NOT used to pay bills ONLYTable Relation Jumpins Detail
CheckApplyCheckToTxnTransactionsInsert Only table to create a check to pay off a credit memoTable Relation Jumpins Detail
CheckExpenseLineTransactionsProvides expense line detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
CheckItemLineTransactionsProvides line item detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
ClearedStatusTransactionsInsert Only Cleared Status TableTable Relation Jumpins Detail
CreditCardChargeTransactionsMain Credit Card Table - Charges OnlyTable Relation Jumpins Detail
CreditCardChargeExpenseLineTransactionsProvides expense line detail for a credit card charge; contains all the information included in the Main Credit Card ChTable Relation Jumpins Detail
CreditCardChargeItemLineTransactionsProvides line item detail for a credit card charge; contains all the information included in the Main Credit Card ChargTable Relation Jumpins Detail
CreditCardCreditTransactionsMain Credit Card Table - Credits OnlyTable Relation Jumpins Detail
CreditCardCreditExpenseLineTransactionsProvides expense line detail for a credit card credit; contains all the information included in the Main Credit Card CrTable Relation Jumpins Detail
CreditCardCreditItemLineTransactionsProvides line item detail for a credit card credit; contains all the information included in the Main Credit Card CrediTable Relation Jumpins Detail
CreditMemoTransactionsMain Customer Credit Memo TableTable Relation Jumpins Detail
CreditMemoLineTransactionsProvides line item detail for a customer credit memo; contains all the information included in the Main Customer CreditTable Relation Jumpins Detail
CreditMemoLinkedTxnTransactionsCredit Memo apply, etc.Table Relation Jumpins Detail
DepositTransactionsMain Deposit TableTable Relation Jumpins Detail
DepositLineTransactionsProvides line detail for a deposit; contains all the information included in the Main Deposit TableTable Relation Jumpins Detail
InvoiceTransactionsMain Invoice TableTable Relation Jumpins Detail
InvoiceLineTransactionsProvides line item detail for a customer invoice; contains all the information included in the Main Invoice TableTable Relation Jumpins Detail
InvoiceLinkedTxnTransactionsPayments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or EstimatesTable Relation Jumpins Detail
ItemReceiptTransactionsMain Purchase Order Receipts TableTable Relation Jumpins Detail
ItemReceiptExpenseLineTransactionsProvides expense line detail for an item receipt; contains all the information included in the Main Item Receipt TableTable Relation Jumpins Detail
ItemReceiptItemLineTransactionsProvides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table Relation Jumpins Detail
ItemReceiptLinkedTxnTransactionsContains all receipts associated with a particular purchase orderTable Relation Jumpins Detail
JournalEntryTransactionsMain Journal Entry TableTable Relation Jumpins Detail
JournalEntryCreditLineTransactionsProvides credit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryDebitLineTransactionsProvides debit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryLineTransactionsProvides credit and debit entry line detail information; contains all the information included in the Main Journal EntrTable Relation Jumpins Detail
PurchaseOrderTransactionsMain Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLineTransactionsProvides line item detail for a purchase order; contains all the information included in the Main Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLinkedTxnTransactionsShows Linked Purchase Order Receipts; does NOT include transfers from SO or EstimatesTable Relation Jumpins Detail
ReceivePaymentTransactionsMain Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineTransactionsProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineLinkedTxnTransactionsProvides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments Table Relation Jumpins Detail
ReceivePaymentToDepositTransactionsList of Payments Received to Undeposited Funds; ready for DepositTable Relation Jumpins Detail
SalesTransactionsCustom QODBC table that includes invoices, credit memos and sales receipts informationTable Relation Jumpins Detail
SalesLineTransactionsCustom QODBC table that includes invoice lines, credit memo lines and sales receipt line informationTable Relation Jumpins Detail
SalesOrderTransactionsMain Sales Order TableTable Relation Jumpins Detail
SalesOrderLineTransactionsProvides line item detail for a sales order; contains all the information included in the Main Sales Order TableTable Relation Jumpins Detail
SalesOrderLinkedTxnTransactionsSales Order Linked TransactionsTable Relation Jumpins Detail
SalesReceiptTransactionsMain Sales Receipts TableTable Relation Jumpins Detail
SalesReceiptLineTransactionsProvides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts TableTable Relation Jumpins Detail
SalesTaxPaymentCheckTransactionsMain Sales Tax Payments TableTable Relation Jumpins Detail
SalesTaxPaymentCheckLineTransactionsProvides line detail for a sales tax payment check; contains all the information included in the Main Sales Tax PaymentTable Relation Jumpins Detail
TimeTrackingTransactionsTime Tracking TableTable Relation Jumpins Detail
TransactionTransactionsTransaction List TableTable Relation Jumpins Detail
VehicleMileageTransactionsVehicleMileage TableTable Relation Jumpins Detail
VendorCreditTransactionsMain Vendor Credit TableTable Relation Jumpins Detail
VendorCreditExpenseLineTransactionsProvides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit TableTable Relation Jumpins Detail
VendorCreditItemLineTransactionsProvides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit TableTable Relation Jumpins Detail
VendorCreditLinkedTxnTransactionsCredits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit TableTable Relation Jumpins Detail