Bill Print in BI Publisher and Crystal - CI_BILLPR
Note: Bill Print in batch for BI Publisher is not supported yet.
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 and Crystal Reports to display all the information that appears on the customer's printed bill for the bill ID or range of bills entered in the input parameter. For a report submitted in batch, the parameters batch code, batch number and extract algorithm are also used to limit the bills selected. 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.