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.

BillDetailReconciliationSearchScreen: Elements and Attributes

Element/Tag	Attributes	Parent Element	Description	Element/Attribute Values
<BillDetailReconciliationSearchScreen>			The opening and closing elements of the BillDetailReconciliationSearchScreen Business Rule
<Search>		<BillDetailReconciliationSearchScreen>	Required element:    Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen
<Fields>		<Search>	Required element: Standard fields element configuration for Search Screens Available Results Groups: BillDetailReconciliation BillDetail BilldetailField GroupCustomer GroupCustomerField Client ClientField Policy PolicyField Segment SegmentField
<Results>			Required Attribute: Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen
<Table>		<BillDetailReconciliationSearchScreen>	Required Attribute: Standard Table element configuration for Search Screen results Available Results Groups: BillDetailReconciliation BillDetail BilldetailField GroupCustomer GroupCustomerField Client ClientField Policy PolicyField Segment SegmentField

 

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>

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>