About This Guide

This book is intended for system administrators and programmers doing software conversions and custom programming.

Database tables are grouped by module and listed alphabetically, with the following information.


Field Name	Label	Col-Label	Format	Dec
ad_addr	Address		x(8)
ad_address_id	Business Relation Address		9999999999
ad_alt_um	Alternate UM	UM	x(2)

• Field Name. The name of the field.

• Label. The field label as it appears on screens.

• Col-Label. The column label that appears on reports.

• Format. How, and what kind of, data can be displayed.

• Dec. The maximum number of decimal places that can be stored.

Some fields in the database are not currently used. These fields are either:

• User definable for custom programming

• Reserved for future use by QAD

• Obsolete (only used in earlier versions)

Each database table has at least one index. By default, Progress sorts and retrieves records using the primary index, which is indicated by an asterisk (*). Indexes have the following attributes.


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ad_addr	yes	ad_domain	yes	no
			ad_addr	yes	no
	ad_address_id	no	ad_address_id	yes	no
	ad_edi_tpid	no	ad_domain	yes	no
			ad_edi_tpid	yes	no

• Primary Index. Indicated with an asterisk. The most frequently used index. Each table has one and only one primary index. Progress uses the primary index when retrieving records or ordering records for a list (like a report) if you don’t specify another index. The primary index reflects the most common order, or the most natural order, by which records are sorted.

• Index Name. The name of the index.

• Uni (Unique). Yes indicates only one record in the table can have a particular index value.

• Field Name. Each index has one or more field components.

• Asc (Asc). Yes indicates that records are ordered and accessed by ascending field values.

• Abbr (Abbreviated). For character data fields, a sort option that examines partial records. Tables with abbreviated indexes sort faster but require more disk space.


Symbol	Meaning
∗	Primary Index
!	Shows where a column label wraps to next line


Convention for Designating Fields	Meaning
[x]	Extent of array field
<prefix>__user<number>	User field (ac__user1)
<prefix>__dec<number>	User decimal data field (ac__dec01)
<prefix>__chr<number>	User character field (ac__chr01)
<prefix>__qad<number>	QAD reserved field (ac__qad01)
<prefix>_x<number>	Obsolete field (ac_xctr)