TABLES - Vendors & Payables
(USA VERSION)
| NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
|---|---|---|---|---|---|
| Bill | Vendors & Payables | Main Bill Table; used to pay bills, or write checks that do not apply to existing bills | Table Relation | Jumpins | Detail |
| BillExpenseLine | Vendors & Payables | Provides expense line detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
| BillingRate | Vendors & Payables | Billing Rate Header | Table Relation | Jumpins | Detail |
| BillingRateLine | Vendors & Payables | Billing Rate Lines - Per item | Table Relation | Jumpins | Detail |
| BillItemLine | Vendors & Payables | Provides line item detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
| BillLinkedTxn | Vendors & Payables | Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill Table | Table Relation | Jumpins | Detail |
| BillPaymentCheck | Vendors & Payables | Main table of Bill Payments paid by Checks | Table Relation | Jumpins | Detail |
| BillPaymentCheckLine | Vendors & Payables | Provides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check | Table Relation | Jumpins | Detail |
| BillPaymentCheckLineLinkedTxn | Vendors & Payables | Provides Linked Txn line detail for a bill payment by check; contains all the information included in the Main Bill Pay | Table Relation | Jumpins | Detail |
| BillPaymentCreditCard | Vendors & Payables | Main table of Bill Payments paid by Credit Card | Table Relation | Jumpins | Detail |
| BillPaymentCreditCardLine | Vendors & Payables | Provides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment | Table Relation | Jumpins | Detail |
| BillPaymentCreditCardLineLinkedTxn | Vendors & Payables | Provides Linked Txnline detail for a bill payment by credit card; contains all the information included in the Main Bil | Table Relation | Jumpins | Detail |
| BillToPay | Vendors & Payables | List of Bills to Pay | Table Relation | Jumpins | Detail |
| Charge | Vendors & Payables | Statement Charges Table | Table Relation | Jumpins | Detail |
| ChargeLinkedTxn | Vendors & Payables | Statement Charge Linked Transactions | Table Relation | Jumpins | Detail |
| Check | Vendors & Payables | Manual Checks NOT used to pay bills ONLY | Table Relation | Jumpins | Detail |
| CheckApplyCheckToTxn | Vendors & Payables | Insert Only table to create a check to pay off a credit memo | Table Relation | Jumpins | Detail |
| CheckExpenseLine | Vendors & Payables | Provides expense line detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
| CheckItemLine | Vendors & Payables | Provides line item detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
| ClearedStatus | Vendors & Payables | Insert Only Cleared Status Table | Table Relation | Jumpins | Detail |
| CreditCardCharge | Vendors & Payables | Main Credit Card Table - Charges Only | Table Relation | Jumpins | Detail |
| CreditCardChargeExpenseLine | Vendors & Payables | Provides expense line detail for a credit card charge; contains all the information included in the Main Credit Card Ch | Table Relation | Jumpins | Detail |
| CreditCardChargeItemLine | Vendors & Payables | Provides line item detail for a credit card charge; contains all the information included in the Main Credit Card Charg | Table Relation | Jumpins | Detail |
| CreditCardCredit | Vendors & Payables | Main Credit Card Table - Credits Only | Table Relation | Jumpins | Detail |
| CreditCardCreditExpenseLine | Vendors & Payables | Provides expense line detail for a credit card credit; contains all the information included in the Main Credit Card Cr | Table Relation | Jumpins | Detail |
| CreditCardCreditItemLine | Vendors & Payables | Provides line item detail for a credit card credit; contains all the information included in the Main Credit Card Credi | Table Relation | Jumpins | Detail |
| Deposit | Vendors & Payables | Main Deposit Table | Table Relation | Jumpins | Detail |
| DepositLine | Vendors & Payables | Provides line detail for a deposit; contains all the information included in the Main Deposit Table | Table Relation | Jumpins | Detail |
| Entity | Vendors & Payables | Combined list of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityAdditionalNote | Vendors & Payables | Additional Notes of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityContacts | Vendors & Payables | Contacts of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityShipToAddress | Vendors & Payables | Ship-To-Address for all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| Estimate | Vendors & Payables | Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLine | Vendors & Payables | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLinkedTxn | Vendors & Payables | Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
| PurchaseOrder | Vendors & Payables | Main Purchase Order Table | Table Relation | Jumpins | Detail |
| PurchaseOrderLine | Vendors & Payables | Provides line item detail for a purchase order; contains all the information included in the Main Purchase Order Table | Table Relation | Jumpins | Detail |
| PurchaseOrderLinkedTxn | Vendors & Payables | Shows Linked Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
| Vendor | Vendors & Payables | Vendors List Table | Table Relation | Jumpins | Detail |
| VendorContacts | Vendors & Payables | Vendor Contacts List Table | Table Relation | Jumpins | Detail |
| VendorCredit | Vendors & Payables | Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditExpenseLine | Vendors & Payables | Provides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditItemLine | Vendors & Payables | Provides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditLinkedTxn | Vendors & Payables | Credits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit Table | Table Relation | Jumpins | Detail |