Field Service

This topic includes links to documents intended to assist developers that are working with Field Service modules. Links to the documents are included at the bottom of the topic.

FS900g01Table Additions.doc   This document lists the new tables that were added to the 9.0 release of Field Service.

FS900g01Table Changes.doc   This document lists the changes that were made within existing tables when a system is upgraded to the 9.0 release of Field Service. The list includes details related to the addition of new data columns, changes to existing data columns and the removal of data columns from the Microsoft SQL Server® table structure. The document is designed to assist developers who are upgrading their own applications, which may interface with the Field Service product, to Release 9.0.

FSDexRegTriggers.doc   This document contains a list of all Dexterity registered triggers found within the Field Service applications.

Contract Administration

FSCASDK.doc   This document contains detailed descriptions for each SQL table within the Contract Administration data structure. Information contained within the document includes primary and secondary keys on each table, column names, data types and lengths, as well as a description of the values stored within each column. This document is helpful for those attempting to import data into or export data from a Contract Administration table. It may also assist those writing customizations by describing the data elements currently used by the Contract Administration module.

FSCATableRelationships.xls   This document contains a visual representation of how the various Contract Administration data tables can be linked together, based upon the common fields within each table. This diagram is designed to assist those writing custom reports with tools such as Crystal Decisions Crystal Reports.

FSContractTransactionFlowchart.doc   This document contains both a description and a diagram of the transaction flow within the Contract Administration module. This document is designed to assist those developers wishing to integrate within the transaction workflow of the Contract Administration module.

Preventive Maintenance

FSPMSDK.doc   This document contains detailed descriptions for each SQL table within the Preventive Maintenance data structure. Information contained within the document includes primary and secondary keys on each table, column names, data types and lengths, as well as a description of the values stored within each column. This document is helpful for those attempting to import data into or export data from a Preventive Maintenance table. It may also assist those writing customizations by describing the data elements currently used by the Preventive Maintenance module.

FSPVTableRelationships.xls   This document contains a visual representation of how the various Preventive Maintenance data tables can be linked together, based upon the common fields within each table. This diagram is designed to assist those writing custom reports with tools such as Crystal Decisions Crystal Reports.

Service Call Management

FSCLSDK.doc   This document contains detailed descriptions for each SQL table within the Service Call Management data structure. Information contained within the document includes primary and secondary keys on each table, column names, data types and lengths, as well as a description of the values stored within each column. This document is helpful for those attempting to import data into or export data from a Service Call Management table. It may also assist those writing customizations by describing the data elements currently used by the Service Call Management module.

FSCLTableRelationships.xls   This document contains a visual representation of how the various Service Call Management data tables can be linked together, based upon the common fields within each table. This diagram is designed to assist those writing custom reports with tools such as Crystal Reports.

FSServiceCallTransactionFlowchart.doc   This document contains both a description and a diagram of the transaction flow within the Service Call Management module. This document is designed to assist those developers wishing to integrate within the transaction workflow of the Service Call Management module.

Microsoft Visio® diagrams

Some Microsoft Visio documents have been provided that contain diagrams of Field Service table structures. You must have Visio installed to view these documents.

FSContractsTableStructure.vsd   This is a Microsoft Visio diagram of the Contract Administration table structure and the links between these tables. This diagram is designed to provide a closer look at the database structure for system administrators and developers attempting to work with Contract Administration at the database level.

FSPreventiveMaintenanceTableStructure.vsd   This is a Microsoft Visio diagram of the Preventive Maintenance table structure and the links between these tables. This diagram is designed to provide a closer look at the database structure for system administrators and developers attempting to work with Preventive Maintenance at the database level.

FSServiceCallTableStructure.vsd   This is a Microsoft Visio diagram of the Service Call Management table structure and the links between these tables. This diagram is designed to provide a closer look at the database structure for system administrators and developers attempting to work with Service Call Management at the database level.