TABLES - Sales
(Online VERSION)
NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
---|---|---|---|---|---|
Invoice | Sales | Main Invoice Table | Table Relation | Jumpins | Detail |
InvoiceLine | Sales | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | Table Relation | Jumpins | Detail |
InvoiceLinkedTxn | Sales | Payments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or Estimates | Table Relation | Jumpins | Detail |
InvoiceTaxLineDetail | Sales | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | Table Relation | Jumpins | Detail |
ModifyInwardGroupLine | Sales | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
ModifyOutwardGroupLine | Sales | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
ReceivePayment | Sales | Main Receive Payments Table | Table Relation | Jumpins | Detail |
ReceivePaymentLine | Sales | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
RecurringBill | Sales | Main RecurringTransaction Bill Table | Table Relation | Jumpins | Detail |
RecurringBillExpenseLine | Sales | Provides expense line detail for a bill expense; contains all the information included in the Main RecurringTransaction | Table Relation | Jumpins | Detail |
RecurringBillItemLine | Sales | Provides line item detail for a bill expense; contains all the information included in the Main RecurringTransaction Bi | Table Relation | Jumpins | Detail |
RecurringCreditMemo | Sales | Main RecurringTransaction CreditMemo Table | Table Relation | Jumpins | Detail |
RecurringCreditMemoLine | Sales | Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Recurr | Table Relation | Jumpins | Detail |
RecurringDeposit | Sales | Main RecurringTransaction Deposit Table | Table Relation | Jumpins | Detail |
RecurringDepositLine | Sales | Provides line detail for a deposit; contains all the information included in the Main RecurringTransaction Deposit Tabl | Table Relation | Jumpins | Detail |
RecurringEstimate | Sales | Main RecurringTransaction Estimate Table | Table Relation | Jumpins | Detail |
RecurringEstimateLine | Sales | Provides line item detail for an estimate; contains all the information included in the Main RecurringTransaction Estim | Table Relation | Jumpins | Detail |
RecurringInvoice | Sales | Main RecurringTransaction InvoiceTable | Table Relation | Jumpins | Detail |
RecurringInvoiceLine | Sales | Provides line item detail for a customer invoice; contains all the information included in the Main RecurringTransactio | Table Relation | Jumpins | Detail |
RecurringJournalEntry | Sales | Main RecurringTransaction Journal Entry Table | Table Relation | Jumpins | Detail |
RecurringJournalEntryCreditLine | Sales | Provides credit entry line detail information; contains all the information included in the Main RecurringTransaction J | Table Relation | Jumpins | Detail |
RecurringJournalEntryDebitLine | Sales | Provides debit entry line detail information; contains all the information included in the Main RecurringTransaction Jo | Table Relation | Jumpins | Detail |
RecurringPurchase | Sales | Main RecurringTransaction Purchase Table | Table Relation | Jumpins | Detail |
RecurringPurchaseExpenseLine | Sales | Provides expense item detail for a Purchase expense; contains all the information included in the Main RecurringTransac | Table Relation | Jumpins | Detail |
RecurringPurchaseItemLine | Sales | Provides line item detail for a Purchase expense; contains all the information included in the Main RecurringTransactio | Table Relation | Jumpins | Detail |
RecurringPurchaseOrder | Sales | Main RecurringTransaction Purchase Order Table | Table Relation | Jumpins | Detail |
RecurringPurchaseOrderExpenseLine | Sales | Shows Expense of RecurringTransaction Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
RecurringPurchaseOrderItemLine | Sales | Shows Item of RecurringTransaction Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
RecurringRefundReceipt | Sales | Main RecurringTransaction Refund Receipt Order Table | Table Relation | Jumpins | Detail |
RecurringRefundReceiptLine | Sales | Provides line item detail for a payment; contains all the information included in the Main RecurringTransaction Receive | Table Relation | Jumpins | Detail |
RecurringSalesReceipt | Sales | Main RecurringTransaction Sales Receipts Table | Table Relation | Jumpins | Detail |
RecurringSalesReceiptLine | Sales | Provides line item detail for a sales receipt, contains all the information included in the Main RecurringTransaction S | Table Relation | Jumpins | Detail |
RecurringTransfer | Sales | RecurringTransaction Transfer Table | Table Relation | Jumpins | Detail |
RecurringVendorCredit | Sales | Main RecurringTransaction Vendor Credit Table | Table Relation | Jumpins | Detail |
RecurringVendorCreditExpenseLine | Sales | Provides expense line detail for a vendor credit; contains all the information included in the Main RecurringTransactio | Table Relation | Jumpins | Detail |
RecurringVendorCreditItemLine | Sales | Provides line item detail for a vendor credit; contains all the information included in the Main RecurringTransaction V | Table Relation | Jumpins | Detail |
RefundReceipt | Sales | Main Refund Receipt Order Table | Table Relation | Jumpins | Detail |
RefundReceiptLine | Sales | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
RefundReceiptTaxLineDetail | Sales | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
SalesReceipt | Sales | Main Sales Receipts Table | Table Relation | Jumpins | Detail |
SalesReceiptLine | Sales | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | Table Relation | Jumpins | Detail |
SalesReceiptLinkedTxn | Sales | Provides Linked Transactions for a sales receipt, contains all the information included in the Main Sales Receipts Tabl | Table Relation | Jumpins | Detail |
SalesReceiptTaxLineDetail | Sales | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | Table Relation | Jumpins | Detail |