# Expansion of Activity Accounting To Show Accounting Dynamic Field Data

Accounting tab of Activity detail screen displays accounting records of the activity suspense and displays the Market Maker details in static columns when expanded. Currently Accounting tab on the Activity Result screen is not configurable and only displays static columns and their respective data. Also, with the current design COA and COA result fields are stored in AsAccountingDetailField table as per ChartOfAccountsResults rule configuration. With this enhancement a new configurable section is added to ActivityResultsScreen business rule for accounting which can display fixed and dynamic fields from AsAccounting, AsAccountingDetail and AsAccountingDetailExchange tables.

The Accounting tab will display the configured fields in <Accounting> element of the ActivityResultsScreen business rule. If no Field is configured in the Accounting section, then a default view will be presented with a set of fields i.e 'AccountNumber','Description', Debit/Credit' and 'Amount' in the Accounting tab of the Activity. If any field is configured in the Accounting section of ActivityResultsScreen business rules only those fields in the configuration will be displayed and default view will not get displayed. On reversing the Accounting activity the shadowed activity will display the reversed data.

Accounting tab will not display the expanded Exchange table. Accounting tab UI will have a single table with the configured fields or a single table with default view. The column header for fixed fields is pre- decided. <Display> name for the dynamic field can be configured as per customer requirement and the <Name> should be a fieldname in AsAccountingDetailField table.

## ActivityResultsScreen business rules

    <ActivityResultsScreen>

    <Allocations SHOWORIGINAL="[Yes|No|variable]"></Allocations>

    <FundDisplay>

    <DisplayChildFunds>[Yes|No]</DisplayChildFunds>

    </FundDisplay>

    <Valuation>

    <NegativeCashValue>[label]</NegativeCashValue>

    <PositiveCashValue>[label]</PositiveCashValue>

    </Valuation>

    <Accounting>

    <Table>

    <Column ALIGN="[LEFT|CENTER|RIGHT]">

    <Display>[header for the table column]</Display>

    <Group>[database table]</Group>

    <Name>[fixed field | dynamic field]</Name>

    <DataType>[Text|Integer|Float|TextArea|Money|Radio|Check]</DataType>

    </Column>

    <Column>...</Column>

    </Table>

    </Accounting>

    </ActivityResultsScreen>

The list of column names that can be configured to derive value from its respective table:

AccountNumber | Value of column ACCOUNTNUMBER from AsAccountingDetail table | AccountingDetail
--- | --- | ---
Amount | Value of column AMOUNT from AsAccountingDetail table. Comes in conjunction with CURRENCYCODE column value. | AccountingDetail
DebitCredit | Value of short description column from AsCode table where codename is AsCodeDebitCredit and codevalue is the value of column DEBITCREDITCODE from AsAccountingDetail table. | AccountingDetail
Description | Value of column ENTRYDESCRIPTION from AsAccountingDetail table | AccountingDetail
[fieldname] | Value of dynamic fields from AsAccountingDetailTable | AccountingDetailField
ExchangeDate | Value of column EXCHANGEDATE from AsAccountingExchangeDetail table. | AccountingDetailExchange
ExchangeRate | Value of column EXCHANGERATE from AsAccountingExchangeDetail table. | AccountingDetailExchange
FundName | Value of FUNDNAME column from AsFund table where FundGuid is the value of column FUNDGUID from AsAccountingDetail table. | AccountingDetail
MarketMaker | Value of MARKETMAKERNAME column from AsMarketMaker table where MarketMakerGuid is the value of column MARKETMAKERGUID from AsAccountingExchangeDetail table. | AccountingDetailExchange
OriginalAmount | Value of column ORIGINALAMOUNT from AsAccountingDetailExchange table. Comes in conjunction with ORIGINAL CURRENCYCODE column value. | AccountingDetailExchange
SuspenseNumber | Value of SUSPENSENUMBER column from AsSuspense table where SuspenseGuid is the value of column SUSPENSEGUID from AsAccountingDetail table. | AccountingDetail

## Required Manual Configuration Updates

### Presentation of Accounting information resulting from Activity processing

With the 12.1.0.0 release, the Accounting data table and its exchange data presented in an Activity’s Accounting tab becomes configurable. This requires configuration in the ActivityResultsScreen business rule that is attached to the transaction’s definition. The existence of the Accounting configuration in the rule triggers the new behavior. Without this configuration, past behavior continues.

| Copyright © 2025, Oracle and/or its affiliates. All rights reserved. | About Oracle Insurance | Customer Support