TABLES - Customers & Receivables
(Online VERSION)
| NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
|---|---|---|---|---|---|
| CreditMemo | Customers & Receivables | Main Customer Credit Memo Table | Table Relation | Jumpins | Detail |
| CreditMemoLine | Customers & Receivables | Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Credit | Table Relation | Jumpins | Detail |
| CreditMemoLinkedTxn | Customers & Receivables | Credit Memo apply, etc. | Table Relation | Jumpins | Detail |
| CreditMemoTaxLineDetail | Customers & Receivables | Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Credit | Table Relation | Jumpins | Detail |
| Customer | Customers & Receivables | Customer List Table | Table Relation | Jumpins | Detail |
| CustomerType | Customers & Receivables | Customer List Table | Table Relation | Jumpins | Detail |
| Estimate | Customers & Receivables | Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLine | Customers & Receivables | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLinkedTxn | Customers & Receivables | Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
| EstimateTaxLineDetail | Customers & Receivables | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
| Invoice | Customers & Receivables | Main Invoice Table | Table Relation | Jumpins | Detail |
| InvoiceLine | Customers & Receivables | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | Table Relation | Jumpins | Detail |
| InvoiceLinkedTxn | Customers & Receivables | Payments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or Estimates | Table Relation | Jumpins | Detail |
| InvoiceTaxLineDetail | Customers & Receivables | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | Table Relation | Jumpins | Detail |
| ModifyInwardGroupLine | Customers & Receivables | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
| ModifyOutwardGroupLine | Customers & Receivables | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
| Purchase | Customers & Receivables | Main Purchase Table | Table Relation | Jumpins | Detail |
| PurchaseExpenseLine | Customers & Receivables | Provides expense item detail for a Purchase expense; contains all the information included in the Main Purchase Expense | Table Relation | Jumpins | Detail |
| PurchaseItemLine | Customers & Receivables | Provides line item detail for a Purchase expense; contains all the information included in the Main Purchase Expense Ta | Table Relation | Jumpins | Detail |
| PurchaseLine | Customers & Receivables | Provides Expense and Item entry line detail information; contains all the information included in the Main Purchase Ent | Table Relation | Jumpins | Detail |
| PurchaseTaxLineDetail | Customers & Receivables | Purchase Tax Line Details - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
| PurchaseTxnLineDetail | Customers & Receivables | Purchase Txn Line Details - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
| ReceivePayment | Customers & Receivables | Main Receive Payments Table | Table Relation | Jumpins | Detail |
| ReceivePaymentLine | Customers & Receivables | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
| RefundReceipt | Customers & Receivables | Main Refund Receipt Order Table | Table Relation | Jumpins | Detail |
| RefundReceiptLine | Customers & Receivables | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
| RefundReceiptTaxLineDetail | Customers & Receivables | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
| SalesReceipt | Customers & Receivables | Main Sales Receipts Table | Table Relation | Jumpins | Detail |
| SalesReceiptLine | Customers & Receivables | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | Table Relation | Jumpins | Detail |
| SalesReceiptLinkedTxn | Customers & Receivables | Provides Linked Transactions for a sales receipt, contains all the information included in the Main Sales Receipts Tabl | Table Relation | Jumpins | Detail |
| SalesReceiptTaxLineDetail | Customers & Receivables | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | Table Relation | Jumpins | Detail |