DDS Objects

Overview
Aggregate Objects
- ARRECORD
- ARDETAIL
- APRECORD
- APDETAIL
- EERECORD
- EEDETAIL
- CMRECORD
- CMDETAIL
Company and Console
General Ledger
Cash Management
- CM Record
- CM Detail
Accounts Payable
Accounts Receivable
Employee Expenses
Purchasing
Order Entry
Inventory Control
Project and Resource Management
Contracts and Revenue Management
Platform Services

Overview

DDS includes several different types of tables: Dimensions, Lists, Transactions, Relationships, De-normalized, and Summary.

Note that not all fields are documented—documentation focuses on key fields. Additionally, the list of fields is dynamic based on configuration and custom extensions. DDS includes all custom fields and custom objects extending the standard data model. Also note this document does not list data types. The full list of fields and data types are available within Platform Services > Objects. Finally, some fields are excluded from DDS for security reasons.

The Entity Relationship Diagrams can also be useful.

Aggregate Objects

ARRECORD

List of searchable fields from the union of all Accounts Receivable PRRECORD-based records.

AUWHENCREATED
BASECURR
BILLTOPAYTOKEY
CREATEDBY
CURRENCY
DESCRIPTION
DOCNUMBER
LOCATIONKEY
MEGAENTITYID
MEGAENTITYKEY
MEGAENTITYNAME
MODIFIEDBY
MODULEKEY
PRBATCH
PRBATCHKEY
RAWSTATE

RECORDID
RECORDNO
RECORDTYPE
STATE
TOTALDUE
TOTALENTERED
TOTALPAID
TOTALSELECTED
TRX_TOTALDUE
TRX_TOTALENTERED
TRX_TOTALPAID
TRX_TOTALSELECTED
WHENCREATED
WHENMODIFIED
WHENPAID
WHENPOSTED

ARDETAIL

List of searchable fields from the union of all Accounts Receivable PRENTRY-based records.

ACCOUNTKEY
ACCOUNTLABEL
ACCOUNTLABELKEY
ACCOUNTNO
ACCOUNTTITLE
AMOUNT
BASELOCATION
CREATEDBY
CURRENCY
DEPARTMENTID
DEPARTMENTNAME
DEPT#
ENTRY_DATE
ENTRYDESCRIPTION
EXCH_RATE_DATE
EXCH_RATE_TYPE_ID
EXCHANGE_RATE
GLOFFSET

LINE_NO
LINEITEM
LOCATION#
LOCATIONID
LOCATIONNAME
MODIFIEDBY
PARENTENTRY
RECORDKEY
RECORDNO
RECORDTYPE
STATE
TOTALPAID
TOTALSELECTED
TRX_AMOUNT
TRX_TOTALPAID
TRX_TOTALSELECTED
WHENCREATED
WHENMODIFIED

APRECORD

List of searchable fields from the union of all Accounts Payable PRRECORD-based records.

AUWHENCREATED
BASECURR
BILLTOPAYTOKEY
CREATEDBY
CURRENCY
DESCRIPTION
DOCNUMBER
EXCH_RATE_DATE
EXCH_RATE_TYPE_ID
EXCHANGE_RATE
LOCATIONKEY
MEGAENTITYID
MEGAENTITYKEY
MEGAENTITYNAME
MODIFIEDBY
MODULEKEY
PRBATCH
PRBATCHKEY

RAWSTATE
RECORDID
RECORDNO
RECORDTYPE
STATE
TOTALDUE
TOTALENTERED
TOTALPAID
TOTALSELECTED
TRX_TOTALDUE
TRX_TOTALENTERED
TRX_TOTALPAID
TRX_TOTALSELECTED
WHENCREATED
WHENMODIFIED
WHENPAID
WHENPOSTED

APDETAIL

List of searchable fields from the union of all Accounts Payable PRENTRY-based records.

EERECORD

List of searchable fields from the union of all Employee Expense PRRECORD-based records.

AUWHENCREATED
BASECURR
CREATEDBY
CURRENCY
DESCRIPTION
DOCNUMBER
MEGAENTITYID
MEGAENTITYKEY
MEGAENTITYNAME
MODIFIEDBY
NR_TOTALENTERED
NR_TRX_TOTALENTERED
PRBATCH
PRBATCHKEY
RAWSTATE
RECORDID
RECORDNO

RECORDTYPE
STATE
STATUS
SYSTEMGENERATED
TOTALDUE
TOTALENTERED
TOTALPAID
TOTALSELECTED
TRX_TOTALDUE
TRX_TOTALENTERED
TRX_TOTALPAID
TRX_TOTALSELECTED
USERKEY
WHENCREATED
WHENMODIFIED
WHENPAID
WHENPOSTED

EEDETAIL

List of searchable fields from the union of all Employee Expense PRENTRY-based records.

ACCOUNTKEY
ACCOUNTLABEL
ACCOUNTLABELKEY
ACCOUNTNO
AMOUNT
BILLABLE
BILLED
DEPARTMENTID
DEPARTMENTNAME
DEPT#
ENTRY_DATE
EXCH_RATE_DATE
EXCH_RATE_TYPE_ID
EXCHANGE_RATE
FORM1099
GLACCOUNTNO

GLACCOUNTTITLE
LINE_NO
LINEITEM
LOCATION#
LOCATIONID
LOCATIONNAME
RECORDKEY
RECORDNO
STATE
TOTALPAID
TOTALSELECTED
TRX_AMOUNT
TRX_TOTALPAID
TRX_TOTALSELECTED
WHENCREATED
WHENMODIFIED

CMRECORD

List of searchable fields from the union of all Cash Management PRRECORD-based records.

AUWHENCREATED
BASECURR
CLEARED
CREATEDBY
CURRENCY
DESCRIPTION
MEGAENTITYID
MEGAENTITYKEY
MEGAENTITYNAME

MODIFIEDBY
RAWSTATE
RECORDNO
RECORDTYPE
STATE
TOTALENTERED
TRX_TOTALENTERED
WHENCREATED
WHENMODIFIED

CMDETAIL

List of searchable fields from the union of all Cash Management PRENTRY-based records.

ACCOUNTKEY
ACCOUNTNO
ACCOUNTTITLE
AMOUNT
CREATEDBY
CURRENCY
DEPARTMENTID
DEPARTMENTNAME
DEPT#
EXCH_RATE_TYPE_ID
LINEITEM

LOCATION#
LOCATIONID
LOCATIONKEY
LOCATIONNAME
MODIFIEDBY
RECORDKEY
RECORDNO
RECORDTYPE
TRX_AMOUNT
WHENCREATED
WHENMODIFIED

Company and Console

Class

Field	Attributes	Description	Comments
CLASSID	Not null, UQ	Class ID
DESCRIPTION		Class description
NAME	Not null	Class name
PARENTKEY	FK of CLASS	Class parent	Foreign key to the `CLASS.RECORDNO` of the parent class
RECORDNO	PK	Internal key

Department

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
DEPARTMENTID	Not null, UQ	Department ID
TITLE	Not null, UQ	Department Name
CUSTTITLE		Department Title
PARENTKEY	FK of DEPARTMENT	Parent department	Foreign key to the `DEPARTMENT.RECORDNO` of the parent department.
SUPERVISORKEY	FK of EMPLOYEE	Department manager key	Foreign key to the `EMPLOYEE.RECORDNO`.

Exchange Rate

Exchange Rate Entry

Location

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
LOCATIONID	Not Null, UQ	Location ID
NAME	Not Null	Location Name
CURRENCY		Currency	For Global Consolidation companies, the base currency. Only applies to Entity locations
PARENTKEY	FK of LOCATION	Parent location	Foreign key to the `LOCATION.RECORDNO` of the parent location.
CONTACTKEY	FK of CONTACT	Location contact information	Foreign key to the `CONTACT.RECORDNO`.
SUPERVISORKEY	FK of EMPLOYEE	Location supervisor	Foreign key to the `EMPLOYEE.RECORDNO` field for the location’s manager.
VENDENTITY	FK of VENDOR	Vendor for “bill-back”	Foreign key to the `VENDOR.ENTITY` field. Used for the “Bill-back” feature.
CUSTENTITY	FK of CUSTOMER	Customer for “bill-back”	Foreign key to the `CUSTOMER.ENTITY` field. Used for the “Bill-back” feature.

User

Contact

Contact is a centralized list of all contact information used across Sage Intacct. This table will contain contact information for customers, vendors, employees, users, etc. Note, there are usually multiple relationships to the contact table for different contact relationships. For example, the customer object has a primary, a billing, and a shipping relationship with the contact table. Also note that while Sage Intacct keeps versions of contact information, DDS always uses the most recent version of a contact.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
CONTACTNAME	Not Null, UQ	Unique contact name
PRINTAS	Not Null	Print As	How the contact name appears on invoices, checks, etc.

Entity

Reporting Period

Field	Attributes	Description	Comments
NAME	Not null, UQ	Reporting period name
RECORDNO	PK	Internal key
HEADER1	Not null	Header 1
HEADER2	Not null	Header 2
START_DATE	Not null	Start date	Starting date for the period
END_DATE	Not null	End date	Ending date for the period
BUDGETING		Budgeting	The label of this field is misleading. Marking a reporting period for budgeting does signify the reporting period can be used in budgeting, but this field is also used to identify the non-overlapping fiscal accounting periods. Internally, Sage Intacct pre-computes account balances and tracks them by reporting periods marked for budgeting.

Notes

It is critical to understand the BUDGETING field.

Roles

User Group

Role Policy Assignment

Member User Groups

Custom Role Policy Assignment

Role assignments

General Ledger

Refer to the entity relationship diagram for General Ledger and General Ledger Detail for a more in-depth understanding of how the General Ledger works.

GL Account

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
ACCOUNTNO	Not null, UQ	Account number
TITLE	Not null	Account title
ACCOUNTTYPE	Not null	Account type	`incomestatement`, `balancesheet`
NORMALBALANCE	Not null	Normal balance	`debit`, `credit`
CLOSINGTYPE	Not null	Closing type	`closed to account`, `closing account`, `non-closing account`
REQUIREDEPT	Require department	Boolean. Signifies whether or not the transactions must specify a department
REQUIRELOC	Require location	Boolean. Signifies whether or not the transactions must specify a location
TAXABLE			Boolean
CATEGORY			GL Category Name for financials library reports
CATEGORYKEY			GL Category Key for financials. Note the `GLCATEGORY` table is not implemented.
TAXCODE			Tax code for external tax compliance products
MRCCODE			Tax code for external tax compliance products
CLOSETOACCTKEY	FK of GLACCOUNT	Closing account	Foreign key to the `GLACCOUNT` to which this `GLACCOUNT` closes. Refers to `GLACCOUNT.RECORDNO`

Notes

This table will have additional fields for each dimension enabled. For each dimension, the table will add foreign keys to the dimension table (both RECORDNO and NAME) and a REQUIRES field determining when the dimension is required in transactions.
Depending on the dimensions enabled, this table will include additional fields indicating which dimensions are required when this GLACCOUNT record is referenced in a transaction. The naming convention is REQUIRE* in the case of standard dimensions and REQUIREGLDIM* in the case of user-defined dimensions.

GL Batch (Journal Entry)

GLBATCH is the core table for all General Ledger transactions. Note these records may represent statistical as well as financial transactions. Also note that in a multi-book company, filtering these records for the right book or set of books is critical.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
BATCHNO	Not Null	Batch Number	Unique within a journal.
BATCH_TITLE	Not Null	Batch Title
JOURNAL	Not Null, FK	GL Journal	Foreign key to `JOURNAL.SYMBOL`.

GL Entry

General Ledger transaction details are stored in the GLENTRY object. These are your traditional debit and credit values. GLENTRY objects are related to the GLBATCH object, which represents a single general ledger transaction that contains at least two GLENTRY records with balanced debit and credit totals.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
TR_TYPE	Not Null	Debit or Credit	1 for Debit, -1 for Credit. Multiply by amount to get value for financial reporting
ACCOUNTKEY	Not Null, FK	GL Account	Foreign key to `GLACCOUNT.RECORDNO`.
BATCHNO	Not Null, FK	GLBATCH	Foreign key to `GLBATCH.RECORDNO`.
TR_TYPE	Not Null	Indicates whether this is a debit (1) or credit (-1)	Multiply this value by AMOUNT to get the appropriate value for reporting

GL Journal

GL Journal is used to group GL transactions. Companies will often configure specific uses and review processes by journal.

Field	Attributes	Description
RECORDNO	PK	Internal key
SYMBOL	Not Null, UQ	Unique Journal Symbol
TITLE	Not Null	Journal Name
ADJ	Boolean	Whether this is an adjustment journal
BOOKID		The book to which this journal belongs

Statistical Account

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
ACCOUNTNO	Not null, UQ	Account number
TITLE	Not null	Account title
ACCOUNTTYPE	Not null	Account type	`forperiod`, `cumulative`
REQUIREDEPT		Require department	Boolean. Signifies whether or not the transactions must specify a department
REQUIRELOC		Require location	Boolean. Signifies whether or not the transactions must specify a location
TAXABLE			Boolean
CATEGORY			GL Category Name for financials library reports

GL Account Balance

GLACCOUNTBALANCE contains balance information across all configured dimension combinations against which transactions have posted. By default, balances are tracked by fiscal reporting period, identified by the BUDGETING field in the REPORTINGPERIOD table. Alternatively, you can filter by periods and dates using additional parameters on runDdsJobs.

GL Account Group

GL Account Group records identify a set of GL Account numbers that collectively represent reportable balances. Note that DDS only includes Account Groups with GL Account members and hierarchical account groups. Computational account groups are not included. Also note that the GL Account Group Members object flattens membership for hierarchical account groups.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
NAME	Not Null, UQ	Unique name
TITLE	Not Null	Title as used on reports
ASOF	CHAR(1)	Measure type	Set of values is `P`, `E`, or `B` signifying “For Period”, “End of Period”, or “Beginning of Period”. Note, this only signifies the intended measure for the account group.
MEMBERTYPE		Decode to determine what type of children belong to this account group	See notes

Notes

This object has many fields related to implemented dimensions. All of these fields indicate how Sage Intacct uses the account group internally and have no impact on the records exported via DDS, though they could be used to replicate internal reporting behavior.
MEMBERTYPE is critical to determining the type of children to join via GLACCTGRPMEMBER. Values follow the pattern:
- Accounts: members are standard GL Accounts
- Statistical Accounts: members are Statistical Accounts
- Groups: members are other GL Account Groups
- Category: members are pre-defined Categories defined in Sage Intacct Quickstart Templates
- Statistical Category: members are pre-defined Statistical Categories defined in Sage Intacct Quickstart Templates.
- Dimension Name: members are either standard or user defined dimension records.
- Group of Dimension Name: members are groups containing standard or user defined dimension records.

GL Account Group Member

Simple membership table for GL Account Groups

Field	Attributes	Description
RECORDNO	PK	Internal key
PARENTKEY	FK of GLACCTGRP	Account Group
SORTORD		Sort order within the account group

Notes

Refer to the entity relationship diagram for GL Account Group Membership.

GL Entry Resolve

Cash Management

CM Record

CM Detail

Accounts Payable

Vendor

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
VENDORID	Not Null, UQ	Vendor ID
NAME	Not Null	Vendor Name
PARENTKEY	FK of VENDOR	Parent vendor	Foreign key to the PROJECT.RECORDNO of the parent project.
CUSTOMERKEY	FK of CUSTOMER	Project customer	Foreign key to the CUSTOMER.RECORDNO field.
MANAGERKEY	FK of EMPLOYEE	Project manager	Foreign key to the EMPLOYEE.RECORDNO field for the project manager.
PROJECTDEPTKEY	FK of DEPARTMENT	Project department	Foreign key to the PROJECT.RECORDNO field.
PROJECTLOCATIONKEY	FK of LOCATION	Project location	Foreign key to the LOCATION.RECORDNO field.
CLASSKEY	FK of CLASS	Project class	Foreign key to the CLASS.RECORDNO field.
CONTACTKEY	FK of CONTACT	Project contact	Foreign key to the CONTACT.RECORDNO field.

AP Record

AP Detail

AP Bill Payment

Accounts Receivable

Accounts Receivable (AR) transactions are denormalized into two tables. The ARRECORD table lists the AR transactions as the rows, while the ARDETAIL table lists the line items of transactions as rows.

Combining all transaction types into a single table simplifies creating ledger activity reports. The RECORDTYPE indicates the specific transaction type, such as ARINVOICE or ARPAYMENT.

When looking at these tables, keep the following points in mind:

Amounts reflect whether a transaction increases or decreases the customer balance. Therefore, ARINVOICE transactions are typically positive amounts and ARPAYMENT transactions are typically negative amounts.
ARRECORD will contain the set of custom fields unique to the total set of transaction types. For example, assume ARINVOICE has custom fields a and b, and ARPAYMENT has custom fields b and c. If the two b fields are of the same data type, they are treated as an intersection field—the ARRECORD table will include columns for a, b, and c. If the b fields are different types, they are ignored by DDS.

Customer

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
NAME	Not null	Customer name
CUSTOMERID	Not null, UQ	Customer ID
ENTITY	Not null, UQ	Customer ID
CURRENCY		Default currency for transactions	One of the ISO valid currency codes.
PARENTKEY	FK of CUSTOMER	Parent customer	Foreign key to the CUSTOMER.RECORDNO of the parent customer.
OEPRCLSTKEY	FK of PRICELIST	Default price list	Note the PRICELIST object is not yet implemented in DDS.
OEPRICESCHEDKEY	FK of PRICESCHEDULE	Price schedule	Note the PRICESCHEDULE object is not yet implemented in DDS.
VSOEPRCLSTKEY	FK of VSOEPRICELIST	Default VSOE Price List	Note the VSOEPRICELIST object is not yet implemented in DDS.
OBJECTRESTRICTION			Privacy setting for the customer
DISPLAYCONTACTKEY	FK of CONTACT	Company contact information	The address and contact information for the company as found on the first tab of the customer record.
CONTACTKEY	FK of CONTACT	Primary contact
SHIPTOKEY	FK of CONTACT	Ship-to contact
BILLTOKEY	FK of CONTACT	Bill-to contact
CUSTREPKEY	FK of EMPLOYEE	Customer rep key
ENTITY	Not null, UQ	Unique ID across the CUSTOMER, VENDOR, and EMPLOYEE object

Customer Type

AR Record

The ARRECORD table contains all Accounts Receivable transactions.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
RECORDID	UQ, Not Null	User-visible document number
MODULEKEY	Not Null	Source application	Indicates which application originated this transaction. `8.SO` indicates the transaction was posted from Order Entry
PRBATCHKEY	FK, Not Null	AR Summary Batch	Foreign key to `PRBATCH`. Note that `PRBATCH` is not implemented in DDS. `ARRECORDs` with a common `PRBATCHKEY` are summarized and posted to the GL as a group.
WHENPOSTED		Transaction date	The date value on journal entries created from this transaction. Several factors affect this value.
RECORDTYPE	Not Null	Transaction type	Indicates the AR transaction type. This value determines whether the transaction increases or decreases the customer balance and indicates whether the standard GL posting for line items is a debit or credit.
CUSTOMERID	FK, Not Null	Customer ID	Foreign key to `CUSTOMER.CUSTOMERID`
CUSTENTITY	FK, Not Null	Globally unique entity key	Sage Intacct generates unique keys across customers, vendors, and employees that can be used in joins to transaction tables. Foreign key to `CUSTOMER.ENTITY`.
TRX_*	Not Null	Amounts in transaction currency	Transactions store amounts in the local (base reporting) currency as well as the transaction currency amount. Refer to the `CURRENCY` field and the `EXCH`* fields for currency and exchange rate information.
CONTACT_CONTACTNAME	FK, Not Null	Customer Contact Name	Foreign key to `CONTACT.CONTACTNAME`. This contact defaults to the “Bill To” and “Ship To” values unless the user explicitly selects contacts for these values. Note that the contact information is heavily de-normalized—most values from the related contacts are copied into this table. This is critical, as contact information may change over time, but transaction values should not.
BILLTOPAYTOKEY	FK	Billing contact	Foreign key to `CONTACT.RECORDNO`.
SHIPTORETURNTOKEY	FK	Shipping contact	Foreign key to `CONTACT.RECORDNO`.

NOTES

ARRECORD records were defined in Sage Intacct before auditing was implemented. To avoid backwards compatibility issues and collisions with existing fields, WHENCREATED has a different meaning in this record— it is the transaction date as entered by the user. The AUWHENCREATED field was added to track the date and time the user created the record.
Two factors contribute to the actual date on posted journal entries created from AR transactions:
- If configured, organizations may allow a user to choose an effective GL Posting Date value. If this value is provided, the system uses it instead of the transaction date (WHENCREATED) to determine the posting date.
- Next, the system uses the summary posting settings. For example, if the system is configured for monthly posting, the provided GL Posting Date is used to compute the month in which to post.

AR Detail

The ARDETAIL object contains all the line items in all AR transactions.

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
RECORDKEY	FK, Not Null	AR Transaction	Foreign key to `ARRECORD.RECORDNO`.
RECORDTYPE	Not Null	Transaction type	Indicates the AR transaction type. This value determines whether the transaction increases or decreases the customer balance and indicates whether the standard GL posting for line items is a debit or credit.
ACCOUNTKEY	FK, Not Null	GL Account	Foreign key to `GLACCOUNT.RECORDNO`. In some configurations, the GL Account is not selected by the user and may not be visible in the Sage Intacct UI. Note that the account number and title are copied into this table to minimize joins.
OFFSETACCOUNTNO	FK, Not Null	Accounts Receivable account number	Every line item typically has a revenue (credit) value and an Accounts Receivable (debit) value, which is not displayed in the Sage Intacct UI. This value is the GL Account to which the system posts the debit value.
ACCOUNTLABELKEY	FK	Account Label	Foreign key to `ACCOUNTLABEL`, which is not implemented in DDS. However, several values from the `ACCOUNTLABEL` record are joined into the `ARDETAIL` record.
ALLOCATIONKEY	FK	Allocation	Foreign key to `ALLOCATION`, which is not implemented in DDS. However, several values from the `ALLOCATION` record are joined into the `ARDETAIL` record.
DEFERREDREVACCTKEY	FK	Deferred revenue GL Account	Foreign key to `GLACCOUNT.RECORDNO`. This is uncommon. Most organizations that implement revenue recognition do so through the Order Entry application. Note that the deferred revenue account number and title are copied into this table to minimize joins.
REVRECTEMPLATEKEY	FK	Revenue recognition template	Foreign key to `REVRECTEMPLATE.RECORDNO`. Note that the template name and ID are copied into the table to avoid unnecessary joins.
*DIMKEY	FK	Dimension	Other than Department and Location, all standard and user-defined dimensions join via one of these fields. Department and Location join via `DEPARTMENTID` -> `DEPARTMENT.DEPARTMENTID` and `LOCATIONID` -> `LOCATION.LOCATIONID`, respectively. IDs and Names from standard dimensions are copied into this table to avoid unnecessary joins.
SUBTOTAL	Boolean	Indicates subtotal line items	Null is equivalent to false.
TRX_*	Not Null	Amounts in transaction currency	Transactions store amounts in the local (base reporting) currency as well as the transaction currency amount. Refer to the `CURRENCY` field and the `EXCH`* field for currency and exchange rate information.

Refer to the entity relationship diagram for Accounts Receivable Detail.

AR Invoice Payment

Employee Expenses

Employee

Field	Attributes	Description	Comments
EMPLOYEEID	Not Null, UQ	Employee ID
TITLE		Employee Title
EMPLOYEETYPE		Employee Type
ENTITY		Entity to which this employee defaults	Value is the Location ID and can be joined to LOCATION.LOCATIONID.
PARENTKEY	FK of EMPLOYEE	Manager	Foreign key to the EMPLOYEE.RECORDNO of the parent employee.
DEPARTMENTKEY	FK of DEPARTMENT	Default department	Foreign key to the DEPARTMENT.RECORDNO field for the employee’s home department.
CLASSKEY	FK of CLASS	Default class	Foreign key to the CLASS.RECORDNO for the employee’s default class.
LOCATIONKEY	FK of LOCATION	Default location	Foreign key to the LOCATION.RECORDNO for the employee’s home location.
CONTACTKEY	Not Null, FK of CONTACT	Employee contact information	Foreign key to CONTACT.RECORDNO for the employee’s contact information.

EE Record

EE Detail

Purchasing

Purchasing Document

Purchasing Document Detail

Purchasing Document Subtotals

Order Entry

Revenue Recognition Template

Revenue Recognition Schedule

Revenue Recognition Schedule Entry

Revenue Recognition Change History

Sales document

Sales Document Detail

Sales Document Subtotals

Inventory Control

Item

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
ITEMID	Not Null, UQ	Item ID
NAME	Not Null	Item Name
ITEMTYPE	Not Null	Item Type	One of `Inventory`, `Non-Inventory`, `Non-Inventory (Purchase only)`, `Non-Inventory (Sales only)`, `Kit`, `Stockable Kit`.

Inventory Document

Inventory Document Detail

Inventory Document Sub Totals

Warehouse

Product Line

Item GL Group

Project and Resource Management

Project

Field	Attributes	Description	Comments
RECORDNO	PK	Internal key
PROJECTID	Not Null, UQ	Project ID
NAME	Not Null	Project Name
PARENTKEY	FK of PROJECT	Parent project	Foreign key to the PROJECT.RECORDNO of the parent project.
CUSTOMERKEY	FK of CUSTOMER	Project customer	Foreign key to the CUSTOMER.RECORDNO field
MANAGERKEY	FK of EMPLOYEE	Project manager	Foreign key to the EMPLOYEE.RECORDNO field for the project manager.
PROJECTDEPTKEY	FK of DEPARTMENT	Project department	Foreign key to the PROJECT.RECORDNO field.
PROJECTLOCATIONKEY	FK of LOCATION	Project location	Foreign key to the LOCATION.RECORDNO field.
CLASSKEY	FK of CLASS	Project class	Foreign key to the CLASS.RECORDNO field.
CONTACTKEY	FK of CONTACT	Project contact	Foreign key to the CONTACT.RECORDNO field.