data-delivery-service/objects.md

---
title: DDS Objects | Sage Intacct Developer
url: https://developer.intacct.com/data-delivery-service/objects/
---

# DDS Objects | Sage Intacct Developer

* Overview
* Aggregate Objects
  + ARRECORD
  + ARDETAIL
  + APRECORD
  + APDETAIL
  + EERECORD
  + EEDETAIL
  + CMRECORD
  + CMDETAIL
* Company and Console
  + Class
  + Department
  + Exchange Rate
  + Exchange Rate Entry
  + Location
  + User
  + Contact
  + Entity
  + Reporting Period
  + Roles
  + User Group
  + Role Policy Assignment
  + Member User Groups
  + Custom Role Policy Assignment
  + Role assignments
* General Ledger
  + GL Account
  + GL Batch (Journal Entry)
  + GL Entry
  + GL Journal
  + Statistical Account
  + GL Account Balance
  + GL Account Group
  + GL Account Group Member
  + GL Entry Resolve
* Cash Management
  + CM Record
  + CM Detail
* Accounts Payable
  + Vendor
  + AP Record
  + AP Detail
  + AP Bill Payment
* Accounts Receivable
  + Customer
  + Customer Type
  + AR Record
  + AR Detail
  + AR Invoice Payment
* Employee Expenses
  + Employee
  + 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
  + Inventory Document
  + Inventory Document Detail
  + Inventory Document Sub Totals
  + Warehouse
  + Product Line
  + Item GL Group
* Project and Resource Management
  + Project
  + 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
  + Contract MRR links
* 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.

|  |  |
| --- | --- |
| ACCOUNTKEY  ACCOUNTLABEL  ACCOUNTLABELKEY  ACCOUNTNO  ACCOUNTTITLE  AMOUNT  BASELOCATION  CREATEDBY  CURRENCY  DEPARTMENTID  DEPARTMENTNAME  DEPT#  ENTRY\_DATE  ENTRYDESCRIPTION  EXCH\_RATE\_DATE  EXCH\_RATE\_TYPE\_ID  EXCHANGE\_RATE  FORM1099   GLOFFSET | LINE\_NO  LINEITEM  LOCATION#  LOCATIONID  LOCATIONNAME  MODIFIEDBY  PARENTENTRY  RECORDKEY  RECORDNO  RECORDTYPE  STATE  TOTALPAID  TOTALSELECTED  TRX\_AMOUNT  TRX\_TOTALPAID  TRX\_TOTALSELECTED  WHENCREATED  WHENMODIFIED |

### 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

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

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

### 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:

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

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

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

### 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

### Contract MRR links

---

## Platform Services

All custom objects are available to DDS jobs.

---

Provide feedback