The
billing process’ ultimate goal is to create an invoice in which header and
detail information is contained in the following two tables:
BI_BILL_HEADER
BI_BILLING_LINE
In doing
this, the process will use dynamic SQL statements in the cobol job to first
delete all data from, and then populate temporary tables prior to the
population of the header and detail tables.
These tables include:
BI_EMPLID_TEMP
BI_ACCT_TEMP
BI_ACCT_ITM_TMP
The raw
data for billing comes from:
ITEM_LINE_SF
…and the
determination as to whether a line has been previously billed is made from
ITEM_LINE_SF.ACTUAL_BILLING_DT
If the
above field is populated, then the associated row will never be billed.
For Global
Invoice processing, it is necessary to associate item lines with a specific
invoice ID and to also maintain data on the amount of a given item that has
been invoiced (as a single item can consist of multiple, independantly invoiced
lines). This is accomplished through the
population of these tables:
SSF_BILL_LNCR
SSF_ITEM_INV
