Quick Aim

Database Reference Manuals for Sage Timberline Office
For ESM+ Subscribers

We have the tool that will make the Sage Timberline Office database your database.  This manual is essential for any serious understanding of how and where Sage Timberline Office stores its information, how to retrieve it, and how to use it on a report, or in a Microsoft application.  Also, use it to teach other people in your company how to understand Sage Timberline Office.


Quick Aim Database Reference Manuals will assist you in designing inquiries, understanding what records can be created with ODBC, and which field names can be changed.

Available Manuals

The Quick Aim database reference is available in three volumes.  The Core Applications volume covers all of the Sage Timberline Office applications that are common to both the Property Management and the Construction industries.  The Property Management and Construction volumes cover the Sage Timberline Office applications that are specific to each of those industries.  Select the set of books that best meets your needs:

Core Applications
(309 Pages)

Construction Applications
(378 Pages)

Property Management Application
(185 Pages)
  • Address Book
  • Accounts Payable
  • Cash Management
  • General Ledger
  • Information Assistant
  • Payroll
  • Tax
  • Accounts Receivable
  • Billings
  • Contracts
  • Equipment
  • Job Cost
  • Project Management
  • Remote Time

  • Property Management


Contents

Feature

Description

Custom Descriptions

Customization can consist of changing the name of a field, its size, whether it is left or right justified, or whether it should force the use of upper-case text.  The Custom Descriptions section of the Quick Aim manuals is provided so that specific customizations for your company’s database may be documented.

Data Files

This section includes a description of how data is stored in files, records, and fields within a database.  In addition, information about the data folder structure used with the pervasive database can be found here.  Information is also provided that describes each file type.  This includes the possible file names and types of records that are contained in each file type.  Additional information about each record identifies whether records can be created via ODBC, contain note fields, and be associated issue records and custom fields.

Record Relationships

Based on feedback from Quick Aim users, this is one of the most popular sections in the book.  This section provides graphical diagrams that depict the relationships between different types of records in the Sage Timberline Office database.  While this section does not document all possible relationships, it does document the relationships that are commonly used.

Import Files

Many of the Sage Timberline Office applications provide the ability to import data from external sources.  This section documents each type of import that is possible.  This includes information about the file format, type, name, optional characteristics and layout.  Examples are also provided.

Functions

The function reference provides a quick-reference of the functions that can be used when building formulas for Sage Timberline Office.

ODBC

The Sage Timberline Office ODBC driver is a component that can be licensed in conjunction with other Sage Timberline Office applications.  The purpose of the Sage Timberline Office ODBC driver is to provide a standard method for accessing Sage Timberline Office data using non-Sage Timberline Office software applications such as Microsoft Excel, Access, Crystal Reports and others.  The purpose of this section is to provide an introduction to the concepts of ODBC as well as to provide some basic guidelines for its use.  Step-by-step instructions are provided for using ODBC with Microsoft Excel, Microsoft Word, and Microsoft Access.

Data Dictionary

This section documents each of the available fields for each record type in the applications covered.  Although much of this information can be obtained via the Sage Timberline Office Report Designer, many users have found that it is better to have it already printed to be used as a desk reference.  The formatting used in the Quick Aim manuals makes this information easy to read.