TABLES - Sales
(Canada VERSION)
NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
InvoiceSalesMain Invoice TableTable Relation Jumpins Detail
InvoiceLineSalesProvides line item detail for a customer invoice; contains all the information included in the Main Invoice TableTable Relation Jumpins Detail
InvoiceLinkedTxnSalesPayments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or EstimatesTable Relation Jumpins Detail
ItemReceiptSalesMain Purchase Order Receipts TableTable Relation Jumpins Detail
ItemReceiptExpenseLineSalesProvides expense line detail for an item receipt; contains all the information included in the Main Item Receipt TableTable Relation Jumpins Detail
ItemReceiptItemLineSalesProvides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table Relation Jumpins Detail
ItemReceiptLinkedTxnSalesContains all receipts associated with a particular purchase orderTable Relation Jumpins Detail
ModifyInwardGroupLineSalesInsert/Modify Only table to create/update item in GroupTable Relation Jumpins Detail
ModifyOutwardGroupLineSalesInsert/Modify Only table to create/update item in GroupTable Relation Jumpins Detail
PriceLevelSalesMain Price Levels ListTable Relation Jumpins Detail
PriceLevelPerItemSalesPrice Levels List Item DetailsTable Relation Jumpins Detail
ReceivePaymentSalesMain Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineSalesProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineLinkedTxnSalesProvides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments Table Relation Jumpins Detail
SalesSalesCustom QODBC table that includes invoices, credit memos and sales receipts informationTable Relation Jumpins Detail
SalesLineSalesCustom QODBC table that includes invoice lines, credit memo lines and sales receipt line informationTable Relation Jumpins Detail
SalesOrderSalesMain Sales Order TableTable Relation Jumpins Detail
SalesOrderLineSalesProvides line item detail for a sales order; contains all the information included in the Main Sales Order TableTable Relation Jumpins Detail
SalesOrderLinkedTxnSalesSales Order Linked TransactionsTable Relation Jumpins Detail
SalesReceiptSalesMain Sales Receipts TableTable Relation Jumpins Detail
SalesReceiptLineSalesProvides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts TableTable Relation Jumpins Detail