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 HxGN EAM System Administrator Guide.
-
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.
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 HxGN EAM System Administrator Guide.
-
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.