TABLES - Lists
(USA VERSION)
NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
---|---|---|---|---|---|
Account | Lists | Chart of Accounts List Table | Table Relation | Jumpins | Detail |
AccountTaxLineInfo | Lists | Account Tax Line Info | Table Relation | Jumpins | Detail |
BillingRate | Lists | Billing Rate Header | Table Relation | Jumpins | Detail |
BillingRateLine | Lists | Billing Rate Lines - Per item | Table Relation | Jumpins | Detail |
Class | Lists | Class List Table | Table Relation | Jumpins | Detail |
Currency | Lists | Currency | Table Relation | Jumpins | Detail |
Customer | Lists | Customer List Table | Table Relation | Jumpins | Detail |
CustomerAddtionalNote | Lists | Customer Addtional Notes Table | Table Relation | Jumpins | Detail |
CustomerContacts | Lists | Customer Contacts Table | Table Relation | Jumpins | Detail |
CustomerMsg | Lists | Customer Messages List Table (on Invoices) | Table Relation | Jumpins | Detail |
CustomerNoShippingAddr | Lists | Customer List Table | Table Relation | Jumpins | Detail |
CustomerShipToAddress | Lists | Customer Ship to Address | Table Relation | Jumpins | Detail |
CustomerType | Lists | Customer Type List Table | Table Relation | Jumpins | Detail |
DateDrivenTerms | Lists | Terms List Table (Date Driven Option) | Table Relation | Jumpins | Detail |
Employee | Lists | Employee List Table | Table Relation | Jumpins | Detail |
EmployeeAddtionalNote | Lists | Employee Addtional Notes Table | Table Relation | Jumpins | Detail |
EmployeeEarning | Lists | Employee Payroll Information | Table Relation | Jumpins | Detail |
Entity | Lists | Combined list of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
EntityAdditionalNote | Lists | Additional Notes of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
EntityContacts | Lists | Contacts of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
EntityShipToAddress | Lists | Ship-To-Address for all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
Estimate | Lists | Main Estimate Table | Table Relation | Jumpins | Detail |
EstimateLine | Lists | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
EstimateLinkedTxn | Lists | Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
Form1099 | Lists | Main Form 1099 Table | Table Relation | Jumpins | Detail |
Form1099CategoryAccountMapping | Lists | Provides detail information about Mapping between Category & Account; contains all the information included in the Mai | Table Relation | Jumpins | Detail |
Item | Lists | Combined list of all Items with minimum common fields | Table Relation | Jumpins | Detail |
ItemDiscount | Lists | Item Discount List Table | Table Relation | Jumpins | Detail |
ItemFixedAsset | Lists | Fixed Asset List Table | Table Relation | Jumpins | Detail |
ItemGroup | Lists | Main Item Group List Table | Table Relation | Jumpins | Detail |
ItemGroupLine | Lists | Detailed Group information; directly tied to the Main Item Group List Table | Table Relation | Jumpins | Detail |
ItemInventory | Lists | Inventory Items List Table | Table Relation | Jumpins | Detail |
ItemInventoryAssembly | Lists | Main Inventory Assembly Table | Table Relation | Jumpins | Detail |
ItemInventoryAssemblyLine | Lists | Provides detail assembly information; directly tied to the Main Inventory Assembly Table | Table Relation | Jumpins | Detail |
ItemNonInventory | Lists | Non Inventory Items List Table | Table Relation | Jumpins | Detail |
ItemOtherCharge | Lists | Other Charge Items List Table | Table Relation | Jumpins | Detail |
ItemPayment | Lists | Payment Items List Table | Table Relation | Jumpins | Detail |
ItemSalesTax | Lists | Sales Tax Items List Table | Table Relation | Jumpins | Detail |
ItemSalesTaxGroup | Lists | Main Sales Tax Group Table | Table Relation | Jumpins | Detail |
ItemSalesTaxGroupLine | Lists | Provides detail tax code information for a sales tax group; directly tied to the Main Sales Tax Group Table | Table Relation | Jumpins | Detail |
ItemService | Lists | Service Items List Table | Table Relation | Jumpins | Detail |
ItemSites | Lists | Items Site List Table | Table Relation | Jumpins | Detail |
ItemSubtotal | Lists | Subtotal Items List Table | Table Relation | Jumpins | Detail |
JobType | Lists | Job Type List Table | Table Relation | Jumpins | Detail |
OtherName | Lists | Other Names List Table | Table Relation | Jumpins | Detail |
PaymentMethod | Lists | Payment Methods List Table | Table Relation | Jumpins | Detail |
PayrollItemNonWage | Lists | Payroll Non Wage Items List Table | Table Relation | Jumpins | Detail |
PayrollItemWage | Lists | Payroll Wage Items List Table | Table Relation | Jumpins | Detail |
PriceLevel | Lists | Main Price Levels List | Table Relation | Jumpins | Detail |
PriceLevelPerItem | Lists | Price Levels List Item Details | Table Relation | Jumpins | Detail |
SalesRep | Lists | Sales Rep List Table | Table Relation | Jumpins | Detail |
SalesTaxCode | Lists | Sales Tax Codes List Table | Table Relation | Jumpins | Detail |
ShipMethod | Lists | Shipping Methods List Table | Table Relation | Jumpins | Detail |
SpecialAccount | Lists | Insert Only Special Account Table | Table Relation | Jumpins | Detail |
SpecialItem | Lists | Insert Only Special Item Table | Table Relation | Jumpins | Detail |
StandardTerms | Lists | Terms List Table (Default Term Option) | Table Relation | Jumpins | Detail |
TaxCode | Lists | Customer and Line Item Tax Codes; i.e. taxable, exempt | Table Relation | Jumpins | Detail |
Terms | Lists | Main Terms List | Table Relation | Jumpins | Detail |
ToDo | Lists | To Do Information Table | Table Relation | Jumpins | Detail |
UnitOfMeasureSet | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
UnitOfMeasureSetDefaultUnit | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
UnitOfMeasureSetRelatedUnit | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
Vehicle | Lists | Vehicle List Table | Table Relation | Jumpins | Detail |
Vendor | Lists | Vendors List Table | Table Relation | Jumpins | Detail |
VendorContacts | Lists | Vendor Contacts List Table | Table Relation | Jumpins | Detail |
VendorType | Lists | Vendor Types List Table | Table Relation | Jumpins | Detail |
WorkersCompCode | Lists | WorkersCompCodes List Table | Table Relation | Jumpins | Detail |
WorkersCompCodeRateHistory | Lists | WorkersCompCodes List Table | Table Relation | Jumpins | Detail |