Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# ChartofAccountsCriteria

## 2BDescription

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. ChartOfAccountsCriteria business rule is used to filter or pinpoint the account/account entry details to which the accounting should be performed to. Using this business rule, Criteria information for each (dynamic) field on the ChartOfAccountsScreen business rule can be defined.

## ChartofAccountsCriteria Element\Attribute Table

Element/Tag | Definition | Attribute | Element/Attribute Value and Description
<ChartOfAccountsCriteria> | The opening and closing tag. |  |
<TransactionAccounting> | Optional element; List of Criteria information for transaction accounts |  |
<Criteria> | Required / Repeatable element; Used to define the Criteria information for the (dynamic) fields on the ChartOfAccountsScreen business rule. | NAME CATEGORY CATEGORYFIELD WILDCARD | Required attribute; ="String" Name of COA (Criteria) field to match criteria up to Required attribute; ="MATH / POLICY" Source from where values will be obtained. Specifies how to get a value to match criteria. This is of DataType, String. MATH - To retrieve the value from a MathVariable in the Transaction POLICY - To retrieve the value from AsPolicy and AsPolicyField Required attribute; ="String" Name of the Field or MathVariable whose values are used to match the Criteria value Optional attribute; ="String" Used to specify a value in the Criteria drop down according to which the results are to be generated. Note: Usual practice is to set it with the pre-defined value, "00". When set with this value, conditions are overriden(ignored).
<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 CATEGORY CATEGORYFIELD SQL WILDCARD | Required Attribute ="String" Name of COA (criteria) field to match criteria up to. 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. 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 Required if CATEGORY is set to SQL; ="SQL statement" SQL Statement from which the values should be retrieved SQL Statement from which the values should be retrieved. 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)

XML Example

<ChartOfAccountsCriteria>

<TransactionAccounting>

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

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

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

</TransactionAccounting>

<SuspenseAccounting>

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

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

</SuspenseAccounting>

</ChartOfAccountsCriteria>