The Service Manager (TSM) V6

The Service Manager (TSM) v6.8

Database Structures

This document is intended for consultants who wish to gain a better understanding of the main database files that make the TSM program

This chapter describes the file organization and structures of TSM’s databases in an Xbase format. The following pages describe the database structures of most TSM .DBF files. This chapter does not include a discussion of every database file.

Most of TSM’s files are stored in the TSM directory. These files include most database and index files.

Each database file is listed separately, and includes its associated index files, database structure, and special notes.

Use the database viewing utility Eye supplied with your TSM application to view and update TSM tables.

Table Structure:

All TSM data is stored in tables. A table consists of up to 3 sepearate files with the following extensions:

DBF –DataBase File – a fixed format file containing all the records in the table

FPT – Floating Point Table – Contains a pointer to each record in the DBF file and holds variable length memo field information.

CDX – Compound Index - A .cdx (compound) index consists of one physical file containing many index tags. Each index tag is an index order reference for the associated table.

FTT, FTX, FTTX, FTTW, FTWX, FTWT- Fast Text Search-related index files.

Main TSM Tables

Assignment / Assignment file—contains a record for each scheduled activity in the Visual Assignment Scheduler
Audit / This table contains the TSM audit trail
BO / Committed stock table containing the item’s product id, quantity, required date and links to servcard or stage (if requisitioned for a stage on a contract).
Cash / Cash payment file detail—contains a record for each invoice a cash payment is disbursed against
Code / 1 record for each code field in TSM
Contacts / Customer Contacts - one record for each additional contact assigned to a customer record
Customer / Customer master table - one record for each customer, supplier etc
Datadict / Contains field labels and captions in various English modes as well as other languages
Employ / Employee master table - one record for each employee
Invoices / Invoice master header table - one record for each invoice
Invdet / Invoice detail file – one record for each disbursement of an invoice. Usually used for Contract Job invoices.
Lasterror / A log of error messages TSM has last encountered
Maindetl / Maintenance Contract Item master table - one record for each item attached to a site under a maintenance contract
Mainsite / Maintenance Contract Site table - one record for each site under a maintenance contract
Maintain / Maintenance Contract master table - one record for each maintenance contract
Orders / Purchase Order master table - one record for each purchase order
Ordet / Purchase Order item table - one record for each item added to an order
Payment / Cash payment file header —contains a single record for each cash receipt
Prodloc / Product location table - one record per location assigned to a product
Product / Product master table - one record per product
Reports / Report table - contains one record per report file available
Schedule / Schedule table - contains one record per scheduled maintenance
Schitems / One record for each piece of equipment linked to a schedule
Servcard / The job card table
Servrep / Base table used for many detailed job card/invoice reports. Not all fields are used for each reports
Sevdetl / Job card parts used table - one record for each part used on a job card
Sevitems / Job card equipment table – one record for each piece of equipment linked to the job
Stagecc / Stage Cost Centre table - one record for each cost centre
Stages / Stage table - one record for each stage linked to a contract job
Suppinv / Supplier Invoice file
Sysvar / System variable file - stores system wide variables
Time / Time table - one record per time sheet entry
Variatio / Variation table - one record for each variation linked to a stage on a contract job
Xfer / Inventory transfer audit trail
Rev 2.0, 4/11/2018 / Page 1 of 4 / Copyright © 2016The Service Manager Pty. Ltd.