TABLES - Purchases
(USA VERSION)
NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
---|---|---|---|---|---|
Bill | Purchases | Main Bill Table; used to pay bills, or write checks that do not apply to existing bills | Table Relation | Jumpins | Detail |
BillExpenseLine | Purchases | Provides expense line detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
BillItemLine | Purchases | Provides line item detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
BillLinkedTxn | Purchases | 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 | Purchases | Main table of Bill Payments paid by Checks | Table Relation | Jumpins | Detail |
BillPaymentCheckLine | Purchases | 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 | Purchases | 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 | Purchases | Main table of Bill Payments paid by Credit Card | Table Relation | Jumpins | Detail |
BillPaymentCreditCardLine | Purchases | 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 | Purchases | 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 | Purchases | List of Bills to Pay | Table Relation | Jumpins | Detail |
Charge | Purchases | Statement Charges Table | Table Relation | Jumpins | Detail |
ChargeLinkedTxn | Purchases | Statement Charge Linked Transactions | Table Relation | Jumpins | Detail |
Check | Purchases | Manual Checks NOT used to pay bills ONLY | Table Relation | Jumpins | Detail |
CheckApplyCheckToTxn | Purchases | Insert Only table to create a check to pay off a credit memo | Table Relation | Jumpins | Detail |
CheckExpenseLine | Purchases | Provides expense line detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
CheckItemLine | Purchases | Provides line item detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
ClearedStatus | Purchases | Insert Only Cleared Status Table | Table Relation | Jumpins | Detail |
CreditCardCharge | Purchases | Main Credit Card Table - Charges Only | Table Relation | Jumpins | Detail |
CreditCardChargeExpenseLine | Purchases | 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 | Purchases | 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 | Purchases | Main Credit Card Table - Credits Only | Table Relation | Jumpins | Detail |
CreditCardCreditExpenseLine | Purchases | 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 | Purchases | 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 | Purchases | Main Deposit Table | Table Relation | Jumpins | Detail |
DepositLine | Purchases | Provides line detail for a deposit; contains all the information included in the Main Deposit Table | Table Relation | Jumpins | Detail |
PurchaseOrder | Purchases | Main Purchase Order Table | Table Relation | Jumpins | Detail |
PurchaseOrderLine | Purchases | Provides line item detail for a purchase order; contains all the information included in the Main Purchase Order Table | Table Relation | Jumpins | Detail |
PurchaseOrderLinkedTxn | Purchases | Shows Linked Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
VendorCredit | Purchases | Main Vendor Credit Table | Table Relation | Jumpins | Detail |
VendorCreditExpenseLine | Purchases | Provides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
VendorCreditItemLine | Purchases | Provides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
VendorCreditLinkedTxn | Purchases | Credits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit Table | Table Relation | Jumpins | Detail |