Quick Aim Database Reference

Quick Aim

We have the set of books that will make the Sage 300 Construction and Real Estate database your database. This manual is essential for any serious understanding of how and where Sage 300 Construction and Real Estate 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 300 Construction and Real Estate.

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 300 Construction and Real Estate applications that are common to both the Property Management and the Construction industries. The Property Management and Construction volumes cover the Sage 300 Construction and Real Estate 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 300 Construction and Real Estate 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 300 Construction and Real Estate 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 300 Construction and Real Estate.

ODBC

The Sage 300 Construction and Real Estate ODBC driver is a component that can be licensed in conjunction with other Sage 300 Construction and Real Estate applications. The purpose of the Sage 300 Construction and Real Estate ODBC driver is to provide a standard method for accessing Sage 300 Construction and Real Estate data using non-Sage 300 Construction and Real Estate 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 300 Construction and Real Estate 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.