You are here: Business Rules > System Rules > ChartofAccountsSpecifications

Oracle® Insurance XML Configuration Guide Release 9.4.1.0 E23637_01

# ChartofAccountsSpecifications

## Description

A transaction can have more than one account and account entry details. Also, more than one suspense account can exist, which in turn can have multiple account entry details. ChartOfAccountsSpecifications business rule is used to filter or pinpoint the account/account entry details to which the accounting should be performed. Using this business rule, criteria information for each (dynamic) field on the ChartOfAccountsScreen business rule can be defined.

Note: This rule replaces the ChartOfAccountCriteria rule.

## ChartofAccountsSpecifications Element\Attribute Table

Element/Tag | Definition | Attribute | Element/Attribute Value and Description
--- | --- | --- | ---
<ChartOfAccountsSpecifications> | The opening and closing tag of the business rule. |  |
<TransactionAccounting> | Optional element; List of Criteria information for transaction accounts. |  |
| MARKETMAKER | Optional Element; Used to indicate the Accounting Detail amount that needs to be exchanged to Market Maker's base currency. Default value is 'No' if tag doesn't exist.
| EXCHANGEDATE | Optional Element; Last known rate as of this date should be used in exchange.
<Criteria> | Required / Repeatable element; Used to define the Criteria information for the (dynamic) fields on the ChartOfAccountsScreen business rule. |  |
| NAME | Required Attribute ="String" Name of COA (criteria) field to match criteria up to.
| CATEGORY | Required attribute; ="SQL / SUSPENSE" Source from where values will be obtained. Specifies how to get a value to match criteria. SUSPENSE: To retrieve the value from AsSuspense and AsSuspenseField. Any Field from the Suspense screen. SQL: To retrieve the value from the SQL statement. SQL attribute must be present for this.
| CATEGORYFIELD | Required attribute; ="String" Name of the Field or MathVariable to use as the values of the Accounting Field and the parts of Account Number Format Note: Required for all the CATEGORY values other than SQL. The SQL statement is mentioned in the SQL attribute
| WILDCARD | Optional attribute; ="String" Used to specify a value in the Criteria drop down according to which the results should be generated. Note: Usual practice is to set it with the Pre-defined value, "00". When set with this value, conditions are overridden (ignored)
<ExchangeToBaseCurrency> | Optional element; Indicates the system should convert the AccountingDetail amount from its original currency to the base currency of the MarketMaker at the time of record. System will not do exchange if element is absent. Default value of element is “No”. | MARKETMAKER EXCHANGEDATE | Yes: system will convert the AccountingDetail amount to the base currency of the MarketMaker at the time of record. No: system will NOT convert the AccountingDetail amount. Optional; Field/Variable value that is a MarketMakerGUID identifying the MarketMaker to use for currency exchange. Default will be the Activity Plan's MarketMaker. Optional; Field/Variable value that is a date. Identifies the last known rate as of this date to use for exchange.
<SuspenseAccounting> | Optional element; List of Criteria information for suspense accounts. |  |
<Criteria> | Required / Repeatable element; Used to define the Criteria information for the (dynamic) fields on the ChartOfAccountsScreen business rule. |  |
| NAME | Required Attribute ="String" Name of COA (criteria) field to match criteria up to.
| CATEGORY | Required attribute; ="SQL / SUSPENSE" Source from where values will be obtained. Specifies how to get a value to match criteria. SUSPENSE: To retrieve the value from AsSuspense and AsSuspenseField. Any Field from the Suspense screen SQL: To retrieve the value from the SQL statement. SQL attribute must be present for this.
| CATEGORYFIELD | Required attribute; ="String" Name of the Field or MathVariable to use as the values of the Accounting Field and the Parts of Account Number Format Note: Required for all the CATEGORY values other than SQL. The SQL statement is mentioned in the SQL attribute
| SQL | Required if CATEGORY is set to SQL; ="SQL statement" SQL statement from which the values should be retrieved
| WILDCARD | Optional attribute; ="String" Used to specify a value in the Criteria drop down according to which the results should be generated. Note: Usual practice is to set it with the Pre-defined value, "00". When set with this value, conditions are overridden (ignored)
<ExchangeToBaseCurrency> | Optional element; Indicates the system should convert the AccountingDetail amount from its original currency to the base currency of the MarketMaker at the time of record. System will not do exchange if element is absent. Default value of element is “No”. | MARKETMAKER EXCHANGEDATE | Yes: system will convert the AccountingDetail amount to the base currency of the MarketMaker at the time of record. No: system will NOT convert the AccountingDetail amount. Optional; Suspense Field value that is a MarketMakerGUID identifying the MarketMaker to use for currency exchange. Default will be the Suspense Company's MarketMaker. Optional; SuspenseField value that is a date. Identifies the last known rate as of this date to use for exchange.

## XML Example

    <ChartOfAccountsSpecifications>

    <TransactionAccounting>

    <Criteria NAME="PerformIntercompanyAccounting" WILDCARD="00" CATEGORY="MATH" CATEGORYFIELD="PerformIntercompanyAccounting"</Criteria>

    <ExchangeToBaseCurrency MARKETMAKER=" " EXCHANGEDATE=" ">Yes</ExchangeToBaseCurrency>

    <Criteria NAME="COARenewalPremiumIndicator" WILDCARD="00" CATEGORY="MATH" CATEGORYFIELD="COARenewalPremiumIndicator" </Criteria>

    <Criteria NAME="IssueState" WILDCARD="00" CATEGORY="POLICY" CATEGORYFIELD="IssueState" />

    </TransactionAccounting>

    <SuspenseAccounting>

    <Criteria NAME="NBCIndicator" WILDCARD="00" CATEGORY="SUSPENSE" CATEGORYFIELD="NBCIndicator" </Criteria>

    <Criteria NAME="SuspensePremium" WILDCARD="00" CATEGORY="SUSPENSE" CATEGORYFIELD="SuspensePremium" </Criteria>

    <ExchangeToBaseCurrency MARKETMAKER=" " EXCHANGEDATE=" ">Yes</ExchangeToBaseCurrency>

    </SuspenseAccounting>

    </ChartOfAccountsSpecifications>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents