| Table Name |
Column Count |
Description |
| Area |
11 |
This table contains Description of the Site Areas. |
| Attribute |
7 |
This table contains the information about all Attributes in Settings > Library > Attributes. |
| AssetAttribute |
7 |
This table contains information of Asset Attribute Assets > All Assets > choose your asset > Edit |
| Asset |
51 |
This contains the Asset Register; so all assets against sites. |
| Asset_TapsAndBrands |
10 |
This contains the tap numbers against each asset in Asset Details page. |
| AssetClass |
12 |
This table contains the Description of Equipment Class that can be selected on the Asset Details page. |
| AssetCondition |
10 |
This table contains the different conditions for the assets. |
| AuditJobStatus |
13 |
This table contains all the job status changes against each job. |
| BaseInvoice |
34 |
This is the main invoice table containing all standard, customer grouped and PPM invoices. |
| Company |
231 |
This is information specific to the whole company. |
| Contact |
16 |
This table contains information about all the contacts added against the customers and sites. |
| Customer |
81 |
This table contains the information about the customers. |
| CustomerAttribute |
7 |
This table contains the information about CustomerAttribute in Customers > All Customers > Attributes. |
| CustomerGrouped_Invoice |
8 |
This table contains all the Customer Grouped Invoices only. |
| CustomerGrouped_InvoiceLine |
22 |
This is customer grouped invoice lines with information like invoice line value, tax etc. |
| CustomerGrouped_InvoicePayment |
18 |
This table contains information about the payments against customer grouped invoices. |
| CustomerTypes |
7 |
This contains customer types (housing, landlord, commercial, etc). |
| Engineer |
35 |
This table contains the details of all the engineers . |
| EquipmentAttribute |
7 |
This table contains information of EquipmentAttribute Settings > Library > Equipment > choose your Equipment > Edit |
| EngineerOnCallDate |
6 |
This table tells if the Engineer is On Call on a specific Day as per the Planner. |
| EngineerClass |
11 |
This table contains the information about the Engineer Class in the Engineer Detail Page for an engineer. |
| EngineerPayBands |
9 |
This table contains the LabourCostRate, TravelCostRate and MileageCostRate for the engineers. |
| EngineerTrades |
6 |
This table contains the engineer trades (skills) like electrical, mechanical, etc. |
| Expenses |
8 |
This table contains the information about the Expenses Description added in the cost section. |
| FGasAdditionRemovalReason |
9 |
This table shows the Addition, Removal and Correction reasons in the refcom section. |
| FileLink |
16 |
This table contains all the attachments against notes, tags etc. |
| GasCylinder |
20 |
This contains the information about the Gas Cylinders from the Refcom section of the system. |
| GasCylinderTransaction |
19 |
This table records all the transactions on the gas cylinders like quantity added or removed, etc. |
| Incoming_Orders |
17 |
This shows the status of all the quotes and there details |
| Invoice |
18 |
This is standard invoices raised against one job, this can be joined with BaseInvoice. |
| InvoicePayments |
19 |
This table contains the payments for the standard invoices stored in the Invoice table. |
| Job |
70 |
This table contains all the jobs. |
| JobAsset |
33 |
This table shows the job assets. |
| JobAsset_Task |
18 |
This table shows the tasks against the job assets. |
| JobCategory |
12 |
This table contains the job categories. |
| JobCost |
100 |
This table contains the costs for all the jobs. |
| JobNote |
3 |
This table shows the notes against the jobs. |
| JobAttribute |
7 |
This table contains the information about JobAttribute in Job> All Job> Attributes. |
| JobPart |
39 |
This table contains the parts description used and parts required against engineer visits |
| JobQuickFilter |
10 |
This table contains the information about the quick filters that are used in the jobs page in the search section. |
| JobStatus |
11 |
This table shows the job status. |
| JobType |
19 |
This table shows the job type. |
| JobVisit |
53 |
This table shows the visits against the jobs. |
| JobVisitExpense |
17 |
This table shows the expenses on the visits. |
| JobVisitNote |
3 |
This table shows the notes against the job visits. |
| LeakCheck |
12 |
This table contains asset leak check follow up actions. |
| MobileFormHeader |
24 |
This table contains the forms logbook data. |
| NominalCodes |
9 |
This table contains the description of the nominal codes. |
| NonProductiveTime |
15 |
This table contains the non productive times shown in the timesheets module |
| NonProductiveTime_Types |
10 |
This table contains the different types of Non Productive Times. |
| Notes |
12 |
This table contains all notes (including notes linked to attachments). |
| Part |
58 |
This contains both Parts and Equipment. |
| PartAttribute |
7 |
This table contains the information about Part Attribute. |
| PPMContractAttribute |
7 |
This table contains the information about PPMContractAttribute in PPMContract> All PPMContract> Attributes. |
| ProjectAttribute |
7 |
This table contains the information about Project Attribute. |
| PartCategory |
11 |
This table contains the categories of the parts. |
| PayBands |
13 |
This is where the library of paybands is stored in Settings>System Setup>Financial |
| PayBandTimes |
14 |
This contains the time bands (start day, hour and minute), (End day, hour, minute). |
| PPMContract |
26 |
This table contains the overall PPM Contract Information. |
| PPMContract_FixedPriceInvoices |
10 |
This table contains the fixed billing type PPM Invoices. |
| PPMContract_InvoiceHeaders |
28 |
This table contains the Invoicing information for all PPM contracts. |
| PPMContract_InvoiceLines |
18 |
This table contains PPM Contract Invoice lines for invoice billing type only. |
| PPMContract_InvoicePayments |
18 |
This table contains payments for PPM Contract Invoices for invoice billing type only. |
| PPMContract_Invoices |
9 |
This table contains PPM Contract Invoices for invoice billing type only. |
| PPMContract_Visits |
12 |
This table contains the visit information of visits added via the PPM Contracts>Visits section. |
| Priority |
20 |
This table contains all Priorities that can be assigned to Jobs. |
| PurchaseOrder |
36 |
This table contains Supplier Purchase Orders |
| PurchaseOrder_Lines |
28 |
This table contains the lines against Supplier purchase orders |
| PurchaseOrder_Resolved |
12 |
This table contains the information of Purchase Orders that are manually resolved. |
| PurchaseOrder_SupplierInvoice |
15 |
This table contains Supplier Invoices against Supplier Purchase Orders |
| PurchaseOrder_SupplierInvoice_Lines |
15 |
This table contains the line items against Supplier Invoices against Supplier Purchase Orders |
| Quote |
60 |
This table contains all the quotes. |
| QuoteAttribute |
7 |
This table contains the information about Quote Attribute in Quote > All Quote > Attributes. |
| QuoteCost |
83 |
This table shows the cost against the quotes. |
| QuoteNote |
3 |
This table shows the notes against the quotes. |
| QuotePayment |
11 |
This table contains the quote payment details along with the user id who did the payment. |
| QuoteRejectReason |
8 |
This table contains the Quote Reject Reasons. |
| QuoteSection |
11 |
This table contains the information about the quote multi sections. |
| QuoteSectionLine |
7 |
This table contains the items that are included in the quote multi section. |
| QuoteSources |
8 |
This table gives the description of Quote Sources. |
| QuoteTemplate |
18 |
This table gives information of Quote Templates found in Settings>Library>Quote Templates. |
| QuoteTemplateLine |
32 |
This table gives information of Prices of Quote Templates found in Settings>Library>Quote Templates>Prices. |
| QuoteTemplatePayment |
11 |
This table gives deposit information of Quote Templates found in Settings>Library>Quote Templates. |
| RefrigerantType |
12 |
This table contains the codes for different refrigerant types in the refcom section. |
| ReportTemplates |
15 |
This table contains the templates that can be setup against reports. |
| RevisitReasons |
15 |
This table contains the revisit reasons that an engineer selects when completing the visit with revisit required selected. |
| RolePermissions |
10 |
This table contains the user permissions assigned to the users. |
| Roles |
8 |
This table contains the different type of user roles like administrator, engineer etc. |
| Route |
9 |
This table contains information of the route to be taken by Engineers on the Engineers>Route Schedule tab in JSON format. |
| SellingRates |
27 |
This shows the selling rates. |
| SiteAttribute |
7 |
This table contains the information about Site Attribute in Sites > All Sites > Attributes. |
| SellingRatesGrid |
12 |
This is the break down of what is in each grid for the selling rates in the system. |
| SellingRateLink |
5 |
This table stores information about the Selling Rates assigned to the Customer/Site in Base Configuration. |
| ServiceType |
11 |
This table contains the service types in Jobs>Assets for PPM Jobs. |
| ServiceTypeLine |
12 |
This is the Service Type Task Lists in Jobs>Assets for PPM Jobs. |
| Site |
110 |
This table shows all the sites. |
| StockLocation |
16 |
This table contains all the stock locations. |
| StockRackShelf |
11 |
This is the "Racks/Shelves Lists" against each stock location. |
| StockRecord |
9 |
This table contains all the stocks present at a location. |
| StockRecordAudit |
19 |
This is the audit of stock records, you can see this in the audits tab against any any stock |
| StockRecordLocation |
12 |
This is each location that each piece of stock is currently located at. |
| StockVehicle |
19 |
This is the record of each vehicle in the system. |
| StockVehicleAudit |
12 |
This table contains the audit information about the stock vehicles. |
| Subcontractor |
16 |
This contains the details of all the subcontractors. |
| Supplier |
22 |
This table contains all the Suppliers information. |
| SupplierBranches |
20 |
This table contains supplier branches. |
| SupplierParts |
10 |
This table contains the equipment that are assigned to a specific supplier. |
| SecondaryJobTrade |
5 |
This table contains all Secondary Job Trade(s) assigned against Jobs. |
| ScheduleOfRateCustomerLink |
11 |
This table gives the SOR assigned against the customers in Customers>Configuration>Selling Rate. |
| ScheduleOfRateItem |
14 |
This table contains the items present against each SOR Library Settings>Library>Schedule of Rates Libraries > Items. |
| ScheduleOfRateSplit |
14 |
This table fetches information of SOR Rate Split from Settings > Library > SOR Rate Splits.
|
| ScheduleOfRateItemSplit |
13 |
This table fetches information about the SOR Rate Split assigned to the Items of the SOR in Settings > Library > Schedule of rates > SOR > Items. |
| ScheduleOfRateCustomerContractLink |
12 |
This table gives the SOR assigned against the Customer Contract in Customer > Contracts > Contract Detail >Schedule of Rates. |
| ScheduleOfRateLibrary |
10 |
This table gives the information about the SOR librarys in Settings>Library>Schedule of Rates Libraries. |
| ServiceJobs |
12 |
This table contains information about the Service Jobs defined in the Settings > Library > Service Jobs. |
| ServiceJobs_ServiceLetter |
15 |
This table contains information about the data shown in the listing page of the Jobs > Service Job Letters. |
| ServiceJobs_CustomerLink |
14 |
This table contains information about the data shown in the Customer > Base Configuration > Service Job Library. |
| ServiceJobs_SiteLink |
12 |
This table contains information about the data shown in the All Sites > Site > Service Job. |
| ServiceJobs_SiteAssetLink |
3 |
This table contains information about data shown in the All Sites > Site > Service Job > Service List. |
| SubFaultCode |
9 |
This table contains the further classification and prioritization of various fault types. |
| SubContractor_Contact |
10 |
This table contains the subcontractor contact person details. |
| SupplierContact |
10 |
This table contains the contact details of the supplier. |
| Tag |
7 |
This table contains the library of tags. |
| TagAssociation |
8 |
This table links Tag Ids with Entity Types. |
| TagLevel |
9 |
This table is used to link tags with the relevant entity type like jobs, invoices etc. |
| Task |
10 |
This is each task found in Settings>Library>Tasks |
| TaskLine |
10 |
This contains the sub tasks against each task found in Settings>Library>Tasks |
| TaxCodes |
14 |
This is the library of tax codes. |
| TimeAndMileage |
28 |
This is the breakdown of engineer times, this is shown on timesheets. |
| Trades |
8 |
This is where the library of trades are stored. |
| ToDo |
17 |
This table contains To Do tasks in the system. |
| ToDoAssignToUser |
8 |
This table contains the User ID to which the To Do is assigned. |
| ToDoReadByUser |
10 |
This table contains the User ID by whom the To Do is read. |
| TradeCategory |
9 |
This table contains the SOR Trade Categories in Settings>Library>Schedule of Rate>Items |
| Users |
45 |
This table contains all the user details in the system. |