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.

Accounting tab

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:

Column Name  Column Value Group Name
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