Overview

Intacct 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.


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 IGC 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 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 Intacct keeps versions of contact information, Intacct 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, Intacct pre-computes account balances and tracks them by reporting periods marked for budgeting.

Notes

  1. 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

  1. 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.
  2. 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 Comments
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 dimension combinations configured and against which transactions have posted. Balances are tracked by fiscal reporting period. Fiscal reporting periods are identified by the BUDGETING field in the REPORTINGPERIOD table.

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

  1. This object has many fields related to implemented dimensions. All of these fields indicate how 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.
  2. 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 Intacct Quickstart Templates
    • Statistical Category: members are pre-defined Statistical Categories defined in 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 Comments
RECORDNO PK Internal key  
PARENTKEY FK of GLACCTGRP Account Group  
SORTORD   Sort order within the account group  

Notes

  1. 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


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:

  1. 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.
  2. 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  
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 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

  1. ARRECORD records were defined in 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.
  2. 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 Intacct system. 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 Intacct system. 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.
  1. Refer to the entity relationship diagram for Accounts Receivable Detail.

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.
SUPERVISORKEY FK of EMPLOYEE Department manager key Foreign key to the EMPLOYEE.RECORDNO.
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.

Task

Timesheet

Timesheet Entry


Contracts and Revenue Management

Contract

Contract Line

Contract Revenue Schedule 1

Contract Revenue Schedule 2

Contract Revenue Schedule Entry

Contract Billing Schedule

Contract Billing Schedule Entry

Contract Expense

Contract Expense Schedule 1

Contract Expense Schedule Entry

Contract Usage Data

MEA Price List

MEA Price List Entry

MEA Price List Entry Detail

Billing Price List

Billing Price List Entry

Billing Price List Entry Detail

Contract Usage Billing

Contract Expense Schedule 2

Billing Price List Entry Detail Tier

Contract Compliance Task Item

Contract Compliance Checklist

Contract Compliance Note

Contract MEA bundle

Contract MEA Bundle Entry

Contract MEA Allocation Details


Platform Services

All custom objects are available to DDS jobs.


Provide feedback