Your browser does not support JavaScript!
You are here: Configuration Overview > Business Rules > Screen Rules > BillDetailReconciliationSearchScreen

BillDetailReconciliationSearchScreen

Description

 

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 Element/Attribute Table
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:

  • 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>

 

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 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>

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