ChartofAccountsSpecifications

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. 

This rule replaces the ChartOfAccountCriteria rule.

ChartofAccountsSpecifications Elements\Attributes
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 AsChartOfAccountsCriteria value to match to the CATEGORYFIELD value.

 

CATEGORY Required attribute:

="MATH / POLICY"

Source where values will be obtained. Specifies how to get a value to match the criteria. This is a string data type.

MATH: To retrieve the value from a math variable in the transaction.

POLICY: To retrieve the value from AsPolicy and AsPolicyField.

 

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 

<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 AsChartOfAccountsCriteria value to match to the CATEGORYFIELD value.

 

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

<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" CATEGORY="MATH" CATEGORYFIELD="PerformIntercompanyAccounting"</Criteria> 
<ExchangeToBaseCurrency MARKETMAKER=" " EXCHANGEDATE=" ">Yes</ExchangeToBaseCurrency>
<Criteria NAME="COARenewalPremiumIndicator" CATEGORY="MATH" CATEGORYFIELD="COARenewalPremiumIndicator" </Criteria> 
<Criteria NAME="IssueState" CATEGORY="POLICY" CATEGORYFIELD="IssueState" />  
</TransactionAccounting> 
<SuspenseAccounting> 
<Criteria NAME="NBCIndicator" CATEGORY="SUSPENSE" CATEGORYFIELD="NBCIndicator" </Criteria> 
<Criteria NAME="SuspensePremium" CATEGORY="SUSPENSE" CATEGORYFIELD="SuspensePremium" </Criteria>  
<ExchangeToBaseCurrency MARKETMAKER=" " EXCHANGEDATE=" ">Yes</ExchangeToBaseCurrency>
</SuspenseAccounting> 
</ChartOfAccountsSpecifications>
 

 

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us