TABLES - Vendors & Payables
(Online 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 |
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 |
BillPayment | Vendors & Payables | Main Bill Payment Table | Table Relation | Jumpins | Detail |
BillPaymentAppliedToTxn | Vendors & Payables | Paymnet Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Payment Bill; directly tied to the Main BillPayme | Table Relation | Jumpins | Detail |
BillPaymentLine | Vendors & Payables | Provides expense line detail for a bill payment expense; contains all the information included in the Main Bill Payment | Table Relation | Jumpins | Detail |
BillPaymentTaxLineDetail | Vendors & Payables | Provides expense line detail for a bill payment expense; contains all the information included in the Main Bill Payment | Table Relation | Jumpins | Detail |
Check | Vendors & Payables | Manual Checks NOT used to pay bills ONLY | 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 |
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 |
CreditCardPayment | Vendors & Payables | Main Credit Card Payment Table - Credit Card Payment Only | Table Relation | Jumpins | Detail |
Deposit | Vendors & Payables | Main Deposit Table | Table Relation | Jumpins | Detail |
DepositAppliedToTxn | Vendors & Payables | Provides Txn detail for a deposit; contains all the information included in the Main Deposit Table | Table Relation | Jumpins | Detail |
DepositAttachable | Vendors & Payables | Provides Attachable detail for a deposit; contains all the information included in the 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 |
DepositTaxLineDetail | Vendors & Payables | Provides line detail for a deposit; contains all the information included in the Main Deposit Table | 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 |
EstimateTaxLineDetail | Vendors & Payables | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
Purchase | Vendors & Payables | Main Purchase Table | Table Relation | Jumpins | Detail |
PurchaseExpenseLine | Vendors & Payables | Provides expense item detail for a Purchase expense; contains all the information included in the Main Purchase Expense | Table Relation | Jumpins | Detail |
PurchaseItemLine | Vendors & Payables | Provides line item detail for a Purchase expense; contains all the information included in the Main Purchase Expense Ta | Table Relation | Jumpins | Detail |
PurchaseLine | Vendors & Payables | Provides Expense and Item entry line detail information; contains all the information included in the Main Purchase Ent | Table Relation | Jumpins | Detail |
PurchaseOrder | Vendors & Payables | Main Purchase Order Table | Table Relation | Jumpins | Detail |
PurchaseOrderExpenseLine | Vendors & Payables | Shows Expense of Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
PurchaseOrderItemLine | Vendors & Payables | Shows Item of Purchase Order Receipts; does NOT include transfers from SO or Estimates | 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 |
PurchaseOrderTaxLineDetail | 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 |
PurchaseOrderTxnLineDetail | Vendors & Payables | Shows TxnTax Detail TaxLine Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
PurchaseTaxLineDetail | Vendors & Payables | Purchase Tax Line Details - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
PurchaseTxnLineDetail | Vendors & Payables | Purchase Txn Line Details - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
TransferTaxLineDetail | 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 |
Vendor | Vendors & Payables | Vendors 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 |
VendorCreditLine | Vendors & Payables | Provides Expense and Item entry line detail information; contains all the information included in the Main Vendor Credi | 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 |