3.7.1.2 Attribute Definitions

The General Ledger interface uses two types of segments:
  • Header segment types
  • Detail segment types
The Attributes Definitions screen records the Header and Detail segments. Both are recorded on the Attribute Definitions screen in the Segment Type field.

Note:

The Header and Detail segment attributes that you configure should be part of accounts or transactions table as configured in the following views - TXN_ACC_EVW and TXN_TXN_ EVW.

Header segment types

The header segment types are the account attributes used as selection criteria to map a transaction to GL segments. The system supports 10 configurable header segments. For each header segment, you can defined specific Account and Transaction attributes which are used as the criteria to categorize the transactions to GL segment. However, note that a header segment must be an account attribute.

By default, the first five header segments (1 to 5) are updated with sample data provided as part of seed data during the base installation / upgrade.

The first five sample segments are:

Table 3-55 Sample segments

Segment # Attribute Name Description
01 ACC_PRODUCT_TYPE_CD Product Type
02 TXN_BACKDATE_IND Backdated Transaction
03 ACC_PRD_PRODUCT Product Code
04 ACC_STATUS_CD Account Status
05 ACC_NON_PERFORM_TYPE_CD Account Non-performing Indicator

This means that the system will allow the account attributes listed above to be used as criteria for categorizing the transactions. Here header segment name defined can be either from Accounts/Transactions table (TXN_ACC_EVW/TXN_TXN_EVW). Segment selections depend on the values in the header segment fields. You can define all the 10 header segments.

Detail segment types

Detail segment types allow you to set up components of the GL account number. A GL account number can be composed of multiple segments that are combined to create the composite GL account number. The detail segments can be configured to direct values (like the natural account) or derived values. Natural account here can be a constant value which is not part of any existing Account or Transaction table.

By default, the first four detail segments (1 to 4) are updated with sample data provided as part of seed data during the base installation / upgrade. Following are the sample detail segments provided in the system:

Table 3-56 Detail segment types

Segment # Attribute Name Description
01 ACC_CONSTANT_ GL_ATTR The natural account number in the GL for the transaction
02 ACC_PCB_BRANCH Customer Branch
03 ACC_POO_POOL Account Pool
04 ACC_SUBUNIT_CD Account Sub Unit
All the 10 available detail segments can be defined. One of the segments can be the natural account. (A natural account is an account from the client’s master listing of all general ledger accounts, or chart of accounts) The Details segment Attribute name defined can be either from Accounts/Transactions table or a constant value (ACC_CONSTANT_GL_ATTR).

Note:

Ensure to have careful consideration while adding a header or detail segment. For any additional programming support, consult Oracle Financial Services Software.
To setup the Attribute Definitions
  1. Click Setup > Setup > Administration > User > General Ledger > Attribute Definitions.
  2. In the Attribute Definitions section, perform any of the Basic Operations mentioned in Navigation chapter.
    A brief description of the fields is given below:

    Table 3-57 Attribute Definitions

    Field Do this
    Segment Type Select the segment type from the drop-down list.
    Segment # Select the required segment out of 10 segments from the drop-down list.
    Attribute Name

    Select the attribute name from the drop-down list to indicate the value is to be populated in attributes.

    The list is populated with only ‘Enabled’ attributes and based on account parameters maintained in User Defined Table GL ATTRIBUTES available in Setup > Administration > System > User Defined Tables screen. The same is configurable and you add/update account parameters.

    Description View the attribute description maintained in GL ATTRIBUTES User Defined Table.
  3. Perform any of the Basic Actions mentioned in Navigation chapter.