TABLES -
(US VERSION)
| NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
|---|---|---|---|---|---|
| ARRefundCreditCard | Transaction | Accounts Receivable Refund CreditCard | |||
| ARRefundCreditCardRefundAppliedTo | Transaction | Accounts Receivable Refund CreditCard | |||
| Bill | Transaction | Main Bill Table; used to pay bills, or write checks that do not apply to existing bills | |||
| BillExpenseLine | Transaction | Provides expense line detail for a bill expense; contains all the information included in the Main Bill Expense Table | |||
| BillItemLine | Transaction | Provides line item detail for a bill expense; contains all the information included in the Main Bill Expense Table | |||
| BillLinkedTxn | Transaction | Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill Table | |||
| BillPaymentCheck | Transaction | Main table of Bill Payments paid by Checks | |||
| BillPaymentCheckLine | Transaction | Provides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check Table | |||
| BillPaymentCreditCard | Transaction | Main table of Bill Payments paid by Credit Card | |||
| BillPaymentCreditCardLine | Transaction | Provides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment Credit Card Table | |||
| BillToPay | Transaction | List of Bills to Pay | |||
| BuildAssembly | Transaction | BuildAssembly | |||
| BuildAssemblyComponentItemLine | Transaction | Build Assembly Component | |||
| Charge | Transaction | Statement Charges Table | |||
| ChargeLinkedTxn | Transaction | Statement Charge Linked Transactions | |||
| Check | Transaction | Manual Checks NOT used to pay bills ONLY | |||
| CheckExpenseLine | Transaction | Provides expense line detail for a check; contains all the information included in the Main Check Table | |||
| CheckItemLine | Transaction | Provides line item detail for a check; contains all the information included in the Main Check Table | |||
| ClearedStatus | Transaction | Insert Only Cleared Status Table | |||
| CreditCardCharge | Transaction | Main Credit Card Table - Charges Only | |||
| CreditCardChargeExpenseLine | Transaction | Provides expense line detail for a credit card charge; contains all the information included in the Main Credit Card Charge Table | |||
| CreditCardChargeItemLine | Transaction | Provides line item detail for a credit card charge; contains all the information included in the Main Credit Card Charge Table | |||
| CreditCardCredit | Transaction | Main Credit Card Table - Credits Only | |||
| CreditCardCreditExpenseLine | Transaction | Provides expense line detail for a credit card credit; contains all the information included in the Main Credit Card Credit Table | |||
| CreditCardCreditItemLine | Transaction | Provides line item detail for a credit card credit; contains all the information included in the Main Credit Card Credit Table | |||
| CreditMemo | Transaction | Main Customer Credit Memo Table | |||
| CreditMemoLine | Transaction | Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Credit Memo Table | |||
| CreditMemoLinkedTxn | Transaction | Credit Memo apply, etc. | |||
| Deposit | Transaction | Main Deposit Table | |||
| DepositLine | Transaction | Provides line detail for a deposit; contains all the information included in the Main Deposit Table | |||
| EmployeeEarning | Transaction | Employee Payroll Information | |||
| Estimate | Transaction | Main Estimate Table | |||
| EstimateLine | Transaction | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | |||
| EstimateLinkedTxn | Transaction | Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | |||
| InventoryAdjustment | Transaction | Main Inventory Adjustment Table | |||
| InventoryAdjustmentLine | Transaction | Provides line item detail for an inventory adjustment; contains all the information included in the Main Inventory Adjustment Table | |||
| Invoice | Transaction | Main Invoice Table | |||
| InvoiceLine | Transaction | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | |||
| InvoiceLinkedTxn | Transaction | Payments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or Estimates | |||
| ItemAssembliesCanBuild | Transaction | List of assemblies that can be built | |||
| ItemReceipt | Transaction | Main Purchase Order Receipts Table | |||
| ItemReceiptExpenseLine | Transaction | Provides expense line detail for an item receipt; contains all the information included in the Main Item Receipt Table | |||
| ItemReceiptItemLine | Transaction | Provides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table | |||
| ItemReceiptLinkedTxn | Transaction | Contains all receipts associated with a particular purchase order | |||
| JournalEntry | Transaction | Main Journal Entry Table | |||
| JournalEntryCreditLine | Transaction | Provides credit entry line detail information; contains all the information included in the Main Journal Entry Table | |||
| JournalEntryDebitLine | Transaction | Provides debit entry line detail information; contains all the information included in the Main Journal Entry Table | |||
| JournalEntryLine | Transaction | Provides credit and debit entry line detail information; contains all the information included in the Main Journal Entry Table | |||
| ListDeleted | Transaction | List of Items that have been Deleted | |||
| PurchaseOrder | Transaction | Main Purchase Order Table | |||
| PurchaseOrderLine | Transaction | Provides line item detail for a purchase order; contains all the information included in the Main Purchase Order Table | |||
| PurchaseOrderLinkedTxn | Transaction | Shows Linked Purchase Order Receipts; does NOT include transfers from SO or Estimates | |||
| ReceivePayment | Transaction | Main Receive Payments Table | |||
| ReceivePaymentLine | Transaction | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | |||
| ReceivePaymentToDeposit | Transaction | List of Payments Received to Undeposited Funds; ready for Deposit | |||
| SalesOrder | Transaction | Main Sales Order Table | |||
| SalesOrderLine | Transaction | Provides line item detail for a sales order; contains all the information included in the Main Sales Order Table | |||
| SalesOrderLinkedTxn | Transaction | Sales Order Linked Transactions | |||
| SalesReceipt | Transaction | Main Sales Receipts Table | |||
| SalesReceiptLine | Transaction | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | |||
| SalesTaxPaymentCheck | Transaction | Main Sales Tax Payments Table | |||
| SalesTaxPaymentCheckLine | Transaction | Provides line detail for a sales tax payment check; contains all the information included in the Main Sales Tax Payments Table | |||
| SpecialAccount | Transaction | Insert Only Special Account Table | |||
| SpecialItem | Transaction | Insert Only Special Item Table | |||
| TimeTracking | Transaction | Time Tracking Table | |||
| ToDo | Transaction | To Do Information Table | |||
| Transaction | Transaction | Transaction List Table | |||
| VendorCredit | Transaction | Main Vendor Credit Table | |||
| VendorCreditExpenseLine | Transaction | Provides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | |||
| VendorCreditItemLine | Transaction | Provides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | |||
| VendorCreditLinkedTxn | Transaction | Credits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit Table |