TABLES -
List
(US VERSION)
NAME
CATEGORY
DESCRIPTION
TABLE RELATIONS
JUMPINS
TABLE DETAILS
Account
List
Chart of Accounts List Table
Relations
Jumpins
Detail
BillingRate
List
Billing Rate Header
Relations
Jumpins
Detail
BillingRateLine
List
Billing Rate Lines - Per item
Relations
Jumpins
Detail
Class
List
Class List Table
Relations
Jumpins
Detail
Customer
List
Customer List Table
Relations
Jumpins
Detail
CustomerMsg
List
Customer Messages List Table (on Invoices)
Relations
Jumpins
Detail
CustomerType
List
Customer Type List Table
Relations
Jumpins
Detail
DateDrivenTerms
List
Terms List Table (Date Driven Option)
Relations
Jumpins
Detail
Employee
List
Employee List Table
Relations
Jumpins
Detail
Entity
List
Combined list of all entities: customers, employees, othernames, vendors; minimum common fields
Relations
Jumpins
Detail
Item
List
Combined list of all Items with minimum common fields
Relations
Jumpins
Detail
ItemDiscount
List
Item Discount List Table
Relations
Jumpins
Detail
ItemFixedAsset
List
Fixed Asset List Table
Relations
Jumpins
Detail
ItemGroup
List
Main Item Group List Table
Relations
Jumpins
Detail
ItemGroupLine
List
Detailed Group information; directly tied to the Main Item Group List Table
Relations
Jumpins
Detail
ItemInventory
List
Inventory Items List Table
Relations
Jumpins
Detail
ItemInventoryAssembly
List
Main Inventory Assembly Table
Relations
Jumpins
Detail
ItemInventoryAssemblyLine
List
Provides detail assembly information; directly tied to the Main Inventory Assembly Table
Relations
Jumpins
Detail
ItemNonInventory
List
Non Inventory Items List Table
Relations
Jumpins
Detail
ItemOtherCharge
List
Other Charge Items List Table
Relations
Jumpins
Detail
ItemPayment
List
Payment Items List Table
Relations
Jumpins
Detail
ItemSalesTax
List
Sales Tax Items List Table
Relations
Jumpins
Detail
ItemSalesTaxGroup
List
Main Sales Tax Group Table
Relations
Jumpins
Detail
ItemSalesTaxGroupLine
List
Provides detail tax code information for a sales tax group; directly tied to the Main Sales Tax Group Table
Relations
Jumpins
Detail
ItemService
List
Service Items List Table
Relations
Jumpins
Detail
ItemSubtotal
List
Subtotal Items List Table
Relations
Jumpins
Detail
JobType
List
Job Type List Table
Relations
Jumpins
Detail
OtherName
List
Other Names List Table
Relations
Jumpins
Detail
PaymentMethod
List
Payment Methods List Table
Relations
Jumpins
Detail
PayrollItemNonWage
List
Payroll Non Wage Items List Table
Relations
Jumpins
Detail
PayrollItemWage
List
Payroll Wage Items List Table
Relations
Jumpins
Detail
PriceLevel
List
Main Price Levels List
Relations
Jumpins
Detail
PriceLevelPerItem
List
Price Levels List Item Details
Relations
Jumpins
Detail
SalesRep
List
Sales Rep List Table
Relations
Jumpins
Detail
SalesTaxCode
List
Sales Tax Codes List Table
Relations
Jumpins
Detail
ShipMethod
List
Shipping Methods List Table
Relations
Jumpins
Detail
StandardTerms
List
Terms List Table (Default Term Option)
Relations
Jumpins
Detail
Template
List
Template Information
Relations
Jumpins
Detail
Terms
List
Main Terms List
Relations
Jumpins
Detail
VehicleMileage
List
VehicleMileage Table
Relations
Jumpins
Detail
Vendor
List
Vendors List Table
Relations
Jumpins
Detail
VendorType
List
Vendor Types List Table
Relations
Jumpins
Detail