The following data can be imported into HITS point-of-sale from other point-of-sale and billing systems. Download the template excel file to see fields to be imported. The second tab of the excel file will contain a schema of the columns to be imported.

---

 

HITS_Customer (download template .XLSX and schema)  Customer information including contact information and account information (such as A/R balance).  ‘CustomerID’ is unique identifier that is related in the following tables: HITS_Customer_AR; HITS_Vehicle; HITS_RepairOrderHeader; HITS_RepairOrderDetail.

HITS_Customer_AR (download template .XLSX and schema)  Accounts receivable transactions with an outstanding balance. Can be account total or individual transactions. ‘CustomerID’ relates this table to HITS_Customer.

HITS_Vehicle (download template .XLSX and schema) Vehicle information. ‘VehicleID’ is a unique identifier related in the following tables: HITS_RepairOrderHeader, and HITS_RepairOrderDetail.

HITS_Vendor (download template .XLSX and schema) Vendor information including contact information for businesses that user purchases from. Vendor data is not related any other tables for purposes of data import.

HITS_Inventory (download template .XLSX and schema)  Product information for both stocking inventory, non-stocking inventory, as well as service codes. This data is not directly related to any other tables as history imported into HITS is available as read-only information.

HITS_RepairOrderHeader (download template .XLSX and schema)  Invoice header information for unique transactions. Contains relational data from ‘HITS_Customer.CustomerID’ and ‘HITS_Vehicle.VehicleID’.

HITS_RepairOrderLineItems (download template .XLSX and schema)  Invoice detail information. Related by ‘HITS_RepairOrderHeader.RepairOrderID’. Line Items imported into HITS are imported as read only, so product information is not required to exist in ‘HITS_Inventory’.