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.