Defining account detail codes

Define account detail codes for your general ledger accounts. The degree of detail included in your account detail definition is specific to the business practices of your organization. For example, your general ledger may include the following segments: segment 1-1400-000 identifies your Organization, 1-1300-100 identifies your Accounts Receivable for Future Payments, 1-3300-000 identifies your fixed assets, etc. Create account code segments for each of these codes. You can also associate Flex SQL query codes with account codes. Flex SQL codes identify SQL query statements that are used to manipulate and validate data related to the account code segment in the database. After defining account detail codes, the codes are associated with transactions in the system at the entity level (such as purchase orders, invoices, etc) and are used to link system transactions with external accounting systems.

See "Defining account details" in the Infor EAM System Administrator Guide.

To define account detail codes:

Select Administration > Databridge > Account Detail Setup.
Click New Record.
Specify this information:

Segment Column

Specify the segment column used to store an account segment value in the R5ACCOUNTDETAIL table.
Note: You can only create one record for each Segment Column.
By default, the 30 available segment columns have non-specific names, e.g., ACD_SEGMENT1. You can change the name of a segment column using screen designer on the Account Details page of the forms for which account details are accessible within the system.

Query Code

Specify the query code for the account detail code. Query codes are defined on the Queries form.
See "Defining Queries" in Infor EAM System Administrator Guide.

Note: The system enables you to reference another account segment within the SQL code list of values. To reference segment 2 inside the code you are defining, enter :2.

Default Value

Specify the default value for the segment column.

Required

Select to indicate that the entry of the segment column is required.
Click Save Record.