Bill Print in BI Publisher - CI_​BILLPR

Parameters

Parameter

Parameter Code

Description

CC&B user

P_​USER_​ID

No default value. Required. Returns an error message if user ID is null, empty or does not exist in database.

Batch Switch

P_​BATCH_​SW

For a single bill print, Batch Switch is 'No' and for multiple bill print, Batch Switch is 'Yes'.

First Bill

P_​FROM_​BILL_​ID

First Bill Id to print for the Bill Range.

Last Bill

P_​TO_​BILL_​ID

Last Bill Id to print for the Bill Range.

Batch Code

P_​BATCH_​CD

Passed in by the system the report is submitted in batch. Only bills with a Bill Routing that references this batch code are selected.

Batch Number

P_​BATCH_​NBR

Passed in by the system the report is submitted in batch. Only bills with a Bill Routing that references this batch number are selected.

Extract Algorithm

P_​EXTRACT_​ALG

Passed in by the system the report is submitted in batch. Only bills with a Bill Routing whose bill route type references this extract algorithm are selected.

Report Description

This report is used with BI Publisher to display all the information that appears on the customer's printed bill for the bill ID entered in the input parameters. Refer to the description of the parameters above. The bill is only displayed if the bill is complete.

See below for details of the information extracted for the report. In addition, the sample report layout provided for the base product includes:

  • Payment coupon.
  • Form for change of address.
  • A graph of consumption for current charges.

The following sections highlight the data that is extracted for this report.