BillDetailReconciliationSearchScreen
BillDetailReconciliationSearchScreen BR is listed under the Screen Rule section in Rules Palette Global Rules Explorer -> Business Rules. This screen allows to configure a set of search criteria and results like all other OIPA search screens under a <Search> element and a <Results> element.
Element/Tag | Attribute | Definition | Element/Attribute Value and Description |
---|---|---|---|
<BillDetailReconciliationSearchScreen> |
|
The opening and closing elements of the BillDetailReconciliationSearchScreen Business Rule |
|
<Search> |
|
Required element: Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen |
. |
<Fields> |
Required element: Standard fields element configuration for Search Screens |
Available Results Groups:
|
|
<Results> |
|
Required Attribute: Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen |
|
<Table> |
Required Attribute: Standard Table element configuration for Search Screen results |
Available Results Groups::
|
XML Example:
<BillDetailReconciliationSearchScreen>
<Search>
<Fields>
<Field>
<Name>BillDetailReferenceID</Name>
<Group>BillDetailField</Group>
<Display>Bill Detail Reference Number</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>Amount</Name>
<Group>BillDetail</Group>
<Display>Bill Detail Reconciliation Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>SuspenseNumber</Name>
<Group>BillDetailReconciliation</Group>
<Display>SuspenseNumber</Display>
<DataType>Integer</DataType
</Field>
<Field>
<Name>StatusCode</Name>
<Group>Status</Group>
<Display>Combo</Display>
<Query TYPE="SQL">
<Oracle>SELECT '', '', 1 FROM DUAL UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName='AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</Oracle>
<SqlServer>SELECT '', '', 1 UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName = 'AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</SqlServer>DB2>SELECT '', '', 1 FROM SYSIBM.SYSDUMMY1 UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName = 'AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</DB2>
</Query>
<Group>BillDetailReconciliation</Group>
</Field>
</Fields>
<Results>
<Table>
<Column>
<Display>Bill Detail Reference Number</Display>
<Name>BillDetailReferenceID</Name>
<Group>BillDetailField</Group>
<DataType>Text</DataType>
</Column>
<Column>
<Name>PolicyNumber</Name>
<Group>Policy</Group>
<Group>Policy</Group>
<DataType>Text</DataType>
</Column>
<Column>
<Display>Suspense Number</Display>
<Name>SuspenseNumber</Name>
<Group>BillDetailReconciliation</Group>
<DataType>Integer</DataType>
</Column>
</Table>
</Results>
</BillDetailReconciliationSearchScreen>
XML Schema
<BillDetailReconciliationSearchScreen>
<Search>
<Fields>
<Field>
<Name>SearchCriteriaFieldName</Name>
<Group>BillDetailReconciliation|BillDetail|BillDetailField|GroupCustomer|GroupCustomerField|Client|ClientField|Policy|PolicyField|Segment|SegmentField</Group>
<Display>SearchFieldDisplayName</Display>
<DataType>SearchFieldDataType</DataType>
</Field>
........
</Fields>
</Search>
</Results>
<Table>
<Column>
<Display>ResultsFieldDisplayName</Display>
<Name>ResultsFieldName</Display>
<Group>BillDetailReconciliation|BillDetail|BillDetailField|GroupCustomer|GroupCustomerField|Client|ClientField|Policy|PolicyField|Segment|SegmentField</Group>
<DataType>ResultsFieldDataType</DataType>
</Column>
......
</Table>
</Results>
</BillDetailReconciliationSearchScreen>