TABLES - Customers & Receivables
(USA VERSION)
NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
ARRefundCreditCardCustomers & ReceivablesAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
ARRefundCreditCardRefundAppliedToCustomers & ReceivablesAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
CreditMemoCustomers & ReceivablesMain Customer Credit Memo TableTable Relation Jumpins Detail
CreditMemoLineCustomers & ReceivablesProvides line item detail for a customer credit memo; contains all the information included in the Main Customer CreditTable Relation Jumpins Detail
CreditMemoLinkedTxnCustomers & ReceivablesCredit Memo apply, etc.Table Relation Jumpins Detail
CustomerCustomers & ReceivablesCustomer List TableTable Relation Jumpins Detail
CustomerNoShippingAddrCustomers & ReceivablesCustomer List TableTable Relation Jumpins Detail
CustomerShipToAddressCustomers & ReceivablesCustomer Ship to AddressTable Relation Jumpins Detail
EntityCustomers & ReceivablesCombined list of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityAdditionalNoteCustomers & ReceivablesAdditional Notes of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityContactsCustomers & ReceivablesContacts of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityShipToAddressCustomers & ReceivablesShip-To-Address for all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EstimateCustomers & ReceivablesMain Estimate TableTable Relation Jumpins Detail
EstimateLineCustomers & ReceivablesProvides line item detail for an estimate; contains all the information included in the Main Estimate TableTable Relation Jumpins Detail
EstimateLinkedTxnCustomers & ReceivablesEstimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to POTable Relation Jumpins Detail
InvoiceCustomers & ReceivablesMain Invoice TableTable Relation Jumpins Detail
InvoiceLineCustomers & ReceivablesProvides line item detail for a customer invoice; contains all the information included in the Main Invoice TableTable Relation Jumpins Detail
InvoiceLinkedTxnCustomers & ReceivablesPayments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or EstimatesTable Relation Jumpins Detail
ItemReceiptCustomers & ReceivablesMain Purchase Order Receipts TableTable Relation Jumpins Detail
ItemReceiptExpenseLineCustomers & ReceivablesProvides expense line detail for an item receipt; contains all the information included in the Main Item Receipt TableTable Relation Jumpins Detail
ItemReceiptItemLineCustomers & ReceivablesProvides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table Relation Jumpins Detail
ItemReceiptLinkedTxnCustomers & ReceivablesContains all receipts associated with a particular purchase orderTable Relation Jumpins Detail
ModifyInwardGroupLineCustomers & ReceivablesInsert/Modify Only table to create/update item in GroupTable Relation Jumpins Detail
ModifyOutwardGroupLineCustomers & ReceivablesInsert/Modify Only table to create/update item in GroupTable Relation Jumpins Detail
OtherNameCustomers & ReceivablesOther Names List TableTable Relation Jumpins Detail
PriceLevelCustomers & ReceivablesMain Price Levels ListTable Relation Jumpins Detail
PriceLevelPerItemCustomers & ReceivablesPrice Levels List Item DetailsTable Relation Jumpins Detail
ReceivePaymentCustomers & ReceivablesMain Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineCustomers & ReceivablesProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineLinkedTxnCustomers & ReceivablesProvides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments Table Relation Jumpins Detail
SalesCustomers & ReceivablesCustom QODBC table that includes invoices, credit memos and sales receipts informationTable Relation Jumpins Detail
SalesLineCustomers & ReceivablesCustom QODBC table that includes invoice lines, credit memo lines and sales receipt line informationTable Relation Jumpins Detail
SalesOrderCustomers & ReceivablesMain Sales Order TableTable Relation Jumpins Detail
SalesOrderLineCustomers & ReceivablesProvides line item detail for a sales order; contains all the information included in the Main Sales Order TableTable Relation Jumpins Detail
SalesOrderLinkedTxnCustomers & ReceivablesSales Order Linked TransactionsTable Relation Jumpins Detail
SalesReceiptCustomers & ReceivablesMain Sales Receipts TableTable Relation Jumpins Detail
SalesReceiptLineCustomers & ReceivablesProvides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts TableTable Relation Jumpins Detail