Stored procedures for bill runs

To give you as much flexibility in the bill generation process as possible, the Infor Public Sector database includes two stored procedures that you can use to run custom code.

BILLING.USP_BILLRUN_START adds custom code to run before a bill run starts, and BILLING.USP_BILLRUN_END adds custom code to run after a bill run ends.

These stored procedures are added to the database during installation, but initially they're just placeholders. For example, the USP_BILLRUN_START procedure, as installed in a SQL Server database, is shown below. To implement the procedure you must add your own code to be run before a bill run starts.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [BILLING].[USP_BILLRUN_START]
    (
    @p_billrunkey INT
         -- BILLING.BILLRUN.BILLRUNKEY
    @p_numaccounts INT
         -- total number of accounts considered
    for the run
    )
    AS
         PRINT
         'This procedure has not been implemented'
         /* Add your own custom code to run before a bill run starts */