Understanding the Billing Interface Structure

This chapter discusses:

The bill entry data structure.
The Billing interface temporary tables.
The Billing interface process control table (INTFC_BI_PROC).
The Billing interface Application Engine state records (INTFC_BI_AET, INTFC1_BI_AET, VAT_DFLT_AET).
The Billing Interface process restart logic.
The Billing Interface process main processing logic (BIIF0001.MAINPROC section steps).

Understanding the Billing Interface Data Structure

PeopleSoft Billing enables you to import billing activity from external systems and a number of internal systems—including PeopleSoft Contracts, Project Costing, Inventory, Order Management, Promotions Management, Asset Management systems—through several tables referred to as the Billing interface staging area, which consists of the following six tables with all data attributes supported by the bill data structure: the INTFC_BI table, the INTFC_BI_AEDS table, the INTFC_BI2 table, the INTFC_BI_NOTE table, the INTFC_BI_EXSD table, the INTFC_BI_TAX and the INTFC_BI_HDR table.

The structure of the Billing interface tables differs from the structure of a bill in its final form. The Billing Interface process (BIIF0001) takes information from these tables, edits the data, provides defaults, and groups the data into bills. It's important to understand the types of transactions stored in these tables. This chapter provides detailed information about the data in each of the Billing interface tables, as well as how to populate each of the tables.

Understanding the Bill Data Structure

To understand the bill data structure, you must understand PeopleSoft Billing transactional data models and how the data is stored in the main PeopleSoft Billing tables. This table lists bill data structure details:

Table	Keys	Relationship
Bill Header table (BI_HDR)	BUSINESS_UNIT INVOICE	Parent table.
Bill Header AR Accounting Distribution (bill header accounts receivable accounting distribution) table (BI_HDR_AR)	BUSINESS_UNIT INVOICE SEQ_NUM	Bill header has one AR accounting distribution entry. SEQ_NUM always equals one.
Bill Header VAT (bill header value-added tax) table (BI_HDR_VAT)	BUSINESS_UNIT INVOICE	Bill header has zero or one VAT header entry.
Bill Header Credit Card table (BI_HDR_CRCARD)	BUSINESS_UNIT INVOICE SEQ_NUM	Bill header has zero or one Credit Card header entry.
Bill Header Note table (BI_HDR_NOTE)	BUSINESS_UNIT INVOICE NOTES_SEQ_NUM	Bill header has zero or more header notes.
Invoice Carbon (or Courtesy) Copy Address (BI_HDR_CC)	BUSINESS_UNIT INVOICE SEQ_NUM	Invoice has zero or more carbon copy address entries. The Billing interface does not support carbon copy functionality.
Bill Line table (BI_LINE)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM	Bill header has one or more bill lines.
Bill Line Tax table (BI_LINE_TAX)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM	Bill line has zero or one bill line tax entry.
Bill Line Tax Detail table (BI_LINE_TAX_DTL)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM TAX_AUTHORITY_CD SEQ_NBR_5	Bill line has zero or more tax detail entries. (These entries are not created by the Billing interface for full bill credit and bill line adjustments.)
Bill Line Excise and Sales Tax Detail table BI_LINE_EXS_DTL	BUSINESS_UNIT INVOICE LINE_SEQ_NUM EXS_TAX_TYPE EXS_TAX_RATE_SEQ	Bill line has zero or more tax detail entries.
Bill Line Note table (BI_LINE_NOTE)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM NOTES_SEQ_NUM	Bill line has zero or more bill line notes.
Bill Line Accounting Entries table (BI_LINE_DST)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or more accounting entries for regular revenue.
Bill Line Unbilled-AR Accounting Entries (bill line unbilled-accounts-receivable accounting entries) table (BI_LINE_DST_UAR)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or one accounts-unbilled-receivable entries.
Bill Line AR Accounting Entries (bill line accounts receivable accounting entries) table (BI_LINE_DST_AR)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or one accounts receivable offset entries.
Bill Line Deferred Accounting Entries table (BI_LINE_DST_DFR)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or more accounting entries for deferred revenue.
Bill Line Deferred Accounting Entries table (BI_LINE_DST_STA)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or more statistical accounting entries.
Bill Line InterUnit Payables table (BI_LINE_IU_PAY)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or one InterUnit payables entries.
Bill Line InterUnit Expenses table (BI_LINE_IU_EXP)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM	Bill line has zero or one InterUnit expense entries.
Bill Line Discount/Surcharge Level table (BI_LINE_DS_LVL )	BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL	Bill line has zero or more discount or surcharge levels.
Bill Line Discount/Surcharge Detail table (BI_LINE_DS_DTL)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL DISC_SUR_ID	Bill line discount or surcharge level has one or more discount or surcharge details, each related to one discount or surcharge level.
Bill Line Deferred Discount/Surcharge Detail table (BI_LINE_DS_DFR)	BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL DISC_SUR_ID	Bill line discount or surcharge level has one or more deferred discount or surcharge details, each related to one discount or surcharge detail.

Understanding the Billing Interface Temporary Tables

The Billing Interface process is an Application Engine process that takes advantage of features, including parallel processing and set processing, that utilize temporary tables to reduce risk of data contention and deadlocks. To utilize Billing interface temporary tables, you must understand how Application Engine employs temporary tables for parallel processing.

See PeopleTools 8.46 PeopleBook: PeopleSoft Application Engine, “Using Temporary Tables”

The Billing Interface process uses the following temporary tables. nn represents the temporary table instance number between 1 and 99.

INTFC_BI_TAOnn	Temporary table for INTFC_BI.
INTFC_BIE_TAOnn	Temporary table for INTFC_BI_EXSD
INTFC_BIA_TAOnn	Temporary table for INTFC_BI_AEDS.
INTFC_BI2_TAOnn	Temporary table for INTFC_BI2.
INTFC_BIN_TAOnn	Temporary table for INTFC_BI_NOTE.
INTFC_BIH_TAOnn	Temporary table for INTFC_BI_HDR.
INTFC_BIT_TAOnn	Temporary table for INTFC_BI_TAX.
INTFC_BI_ETMPnn	Error Processing temporary table. The interface process performs multiple data integrity edit checks. The system inserts temporary data into the INTFC_BI_ETMP table to assist with error checking.
INTFC_BI_ITMPnn	The INTFC_BI_ITMP table is used when generating accounting entries for Inter/Intra Unit transactions.
INTFC_BI_NTMPnn	Invoice Numbering temporary table. The interface process inserts a row of data into this table for each invoice number ID. The data in this table assists in assigning invoice numbers to new bill headers.
INTFC_BI_CTMPnn	Consolidated Bill Header temporary table. The interface process inserts a row of data into this table for every new consolidated bill header that it generates for insertion into the BI_HDR table.
INTFC_BI_DTMPnn	Discount/Surcharge Level temporary table. The interface process inserts a row of data into this table for every discount or surcharge level of each charge line, for insertion into the BI_LINE_DS_LVL table.
INTFC_BI_HTMPnn	Bill Header temporary table. The interface process inserts a row of data into this table for every new bill header that it generates for insertion into the BI_HDR table.
BI_IHAR_TAOnn	Bill Header AR accounting distribution temporary table. The interface process inserts a row of data into this table for every new bill header that it generates for insertion into the BI_HDR_AR table.
BI_IHVAT_TAOnn	Bill Header VAT temporary table. The interface process inserts a row of data into this table for every new bill header with VAT information. This temporary table is used only by the Billing Interface process.
BI_IHCRC_TAOnn	Bill Header Credit Card temporary table. The interface process inserts a row of data into this table for every new bill header with credit card information that it generates for insertion into the BI_HDR_CRCARD table.
BI_IHCC_TAOnn	Bill Header Courtesy Copy temporary table. The interface process inserts a row of data into this table for every piece of new bill header courtesy copy information that it generates for insertion into the BI_HDR_CC table. This table is currently not used.
BI_IHNOT_TAOnn	Bill Header Note temporary table. The interface process inserts a row of data into this table for every new bill header with note information that it generates for insertion into the BI_HDR_NOTE table.
BI_ILINE_TAOnn	Bill Line temporary table. The interface process inserts a row of data into this table for each charge line for insertion into the BI_LINE table.
BI_ITAX_TAOnn	Bill Line Tax temporary table. The interface process inserts a row of data into this table for each charge line with tax information for insertion into the BI_LINE_TAX table.
BI_ITXD_TAOnn	Bill Line Tax Detail temporary table. The interface process inserts a row of data into this table for full bill credit and bill line adjustments for insertion into the BI_LINE_TAX_DTL table.
BI_ILEXS_DTAOnn	Bill Line Excise and Sales Tax Detail temporary table. The Billing Interface process inserts a row of data into this table for full bill credit and bill line adjustments for insertion into the BI_LINE_EXS_DTL table. This table is used for India transactions only.
BI_ILNOT_TAOnn	Bill Line Note temporary table. The interface process inserts a row of data into this table for each charge line with note information for insertion into the BI_LINE_NOTE table.
BI_IDST_TAOnn	Bill Line Revenue Distribution temporary table. The interface process inserts a row of data into this table for each charge line with revenue distribution information for insertion into the BI_LINE_DST table.
BI_IAR_TAOnn	Bill Line AR Offset Distribution temporary table. The interface process inserts a row of data into this table for each charge line with AR distribution information for insertion into the BI_LINE_DST_AR table.
BI_IUAR_TAOnn	Bill Line Unbilled AR temporary table. The interface process inserts a row of data into this table for each charge line with unbilled AR distribution information for insertion into the BI_LINE_DST_UAR table.
BI_IDFR_TAOnn	Bill Line Deferred Revenue Accounting Entries temporary table. The interface process inserts a row of data into this table for each charge line with deferred revenue distribution information for insertion into the BI_LINE_DST_DFR table.
BI_ISTA_TAOnn	Bill Line Statistical Revenue Accounting Entries temporary table. The interface process inserts a row of data into this table for each charge line with statistical revenue distribution information for insertion into the BI_LINE_DST_STA table.
BI_IIUP_TAOnn	Bill Line InterUnit Payable temporary table. The interface process inserts a row of data into this table for each charge line with InterUnit payable distribution information for insertion into the BI_LINE_IU_PAY table.
BI_IIUE_TAOnn	Bill Line InterUnit Expense temporary table. The interface process inserts a row of data into this table for each charge line with InterUnit expense distribution information for insertion into the BI_LINE_IU_EXP table.
BI_IDSD_TAOnn	Bill Line Discount/Surcharge Detail temporary table. The interface process inserts a row of data into this table for each charge line with discount or surcharge and its distribution information for insertion into the BI_LINE_DS_DTL table.
BI_ILDDS_TAOnn	Bill Line Deferred Discount/Surcharge Detail temporary table. The interface process inserts a row of data into this table for each charge line with deferred discount or surcharge and its distribution information for insertion into the BI_LINE_DS_DFR table.
BI_IDSL_TAOnn	Bill Line Discount/Surcharge Level temporary table. The interface process inserts a row of data into this table for each charge line with discount or surcharge level information for insertion into the BI_LINE_DS_LVL table.

Understanding the Billing Interface Process Control Table (INTFC_BI_PROC)

Every time that you run the Billing Interface process, the system inserts a row of data into the INTFC_BI_PROC table. The Billing Interface process uses this secondary run control information to prevent running more than one Billing Interface process with the same interface IDs. The system tracks the following data:

PROCESS_INSTANCE	Process Instance.
INTFC_ID	From Interface ID.
TO_INTFC_ID	To Interface ID.
INTFC_RUN_OPT	Interface Run Option.
OPRID	Operator ID.
RUN_CNTL_ID	Run Control ID.

When a Billing Interface process completes successfully, it deletes its row from this record.

Understanding the Billing Interface Application Engine State Records (INTFC_BI_AET, INTFC1_BI_AET, VAT_DFLT_AET)

The State Record is a PeopleSoft record that must be created and maintained by an Application Engine developer. This record defines the fields that a program uses to pass values from one action to another. The fields of the Application Engine State Record can be considered a working storage for the Application Engine program.

An Application Engine State Record must have PROCESS_INSTANCE defined as the first field and the only key field. For the system to recognize the record as a State Record, all State Record names must end with the _AET identifier.

The Billing Interface process employs two state records:

INTFC_BI_AET (primary).
INTFC1_BI_AET (secondary).
VAT_DFLT_AET (secondary). Used only for transactions that are liable for value added tax (VAT)

Understanding the Billing Interface Process Restart Logic

The Billing Interface process uses Application Engine’s built-in restart feature. If the process terminates abnormally, restart the process to continue from the last commit point. The restarted Billing Interface Application Engine program locates the last checkpoint or the last successfully carried out and committed step, and continues with the processing from that point forward. When the interface is running for a range of interface IDs, you cannot select those interface IDs for another run simultaneously.

To restart a Billing Interface process:

Access the Process Monitor page and locate the Billing Interface process that you want to restart.
Click the Details link for the Billing Interface process that you want to restart.
Select the Restart Request option under the Update Process group, and then click OK to restart the process.

Understanding the Billing Interface Process Main Processing Logic

This section contains an overview of the Billing Interface program processing steps and their sequence. The headings are listed in the following format: AE_PROGRAM_NAME.SECTION.STEP.

BIIF0001.MAIN.INIT

This step performs initialization, including:

Retrieving run control parameters.
Checking for existing Billing Interface processes.
Inserting a record into the Billing interface process control table INTFC_BI_PROC.
Retrieving some PeopleSoft Billing installation options.
Selecting UPD as the processing status for the interface record.
Inserts, or updates if one already exists, the run control record for the Billing VAT Defaulting process (BIPVAT00) with the user's parameter settings.

BIIF0001.MAIN.DISTTEMP

This step copies Billing interface records from main staging tables to their respective temporary tables for processing:

Copies From	Copies To
INTFC_BI	INTFC_BI_TAOnn
INTFC_BI_AEDS	INTFC_BIA_TAOnn
INTFC_BI2	INTFC_BI2_TAOnn
INTFC_BI_NOTE	INTFC_BIN_TAOnn
INTFC_BI_HDR	INTFC_BIH_TAOnn
INTFC_EXSD	INTFC_BIE_TAO
INTFC_BI_TAX	INTFC_BIT_TAOnn

BIIF0001.MAIN.DEFAULTS

This step performs defaulting of some common definitional fields, such as general ledger (GL) business units, GL level options, base currency code, ChartFields, currency rate sources, VAT defaults (such as VAT reporting country, customer's VAT registration country, VAT treatment group), and bill-by IDs.

BIIF0001.MAIN.REQEDITS

This step performs target invoicing edits, including the bill status of a target invoice and no adjustments for target invoicing. This step also performs edit check for bill-by fields.

BIIF0001.MAIN.OPTEDIT

This step edits the data in the interface tables for billing business rule compliance and data integrity. This step also ensures that transactions are ready to be billed.

BIIF0001.MAIN.MAINPROC

This step performs bill creation. This is the main processing step of the Billing Interface program and is discussed in detail later in this section.

BIIF0001.MAIN.UPDINTFC

This step writes back critical field values from the Billing interface temporary tables to the Billing interface main staging tables and updates the Billing interface main staging tables with error statuses and error messages for interface records.

BIIF0001.MAIN.STATS

This step calculates processing statistics for the Billing Interface process, such as the number of lines in error, the number of new bill headers created, and the number of bill lines created; these statistics are then logged into a message log.

BIIF0001.MAIN.DELINTPR

This step deletes INTFC_BI_PROC, the Billing interface process control record.

BIIF0001.MAIN.MAINPROC

This step calls the MAINPROC section, which is the main processing step of the Billing Interface program.

BIIF0001.MAINPROC.NEWHDRS

This step:

Inserts one row of data into INTFC_BI_HTMPnn for every new bill header that the system needs to generate, as determined by the bill-by options.

The data populated in the interface table represents bill line level data that the system must add to a bill. The system uses the bill-by definition to establish whether it can add the line activity to an existing bill. If an appropriate bill does not already exist, the system generates a new bill header.

The interface process dynamically builds an INSERT/SELECT Structured Query Language (SQL) statement for each distinct bill-by identifier appearing by default in the interface table, and then runs the statement. For each bill-by identifier, the SQL statement inserts a row into INTFC_BI_HTMPnn for each new bill header that the system generates. The SQL generated has the following structure, with columns c1, c2, c3... representing the bill-by columns:
```
INSERT into PS_INTFC_BI_HTMPnn( .. , .. , .. , .. , ...)
SELECT .. , .. , .. , .. FROM PS_INTFC_BI  
WHERE INTFC_ID BETWEEN ... AND ...  
AND NOT EXISTS
SELECT INVOICE FROM PS_BI_HDR 
WHERE PS_BI_HDR.c1 = PS_INTFC_BI.c1 
 AND PS_BI_HDR.c2 = PS_INTFC_BI.c2 
 AND PS_BI_HDR.c3 = PS_INTFC_BI.c3 
GROUP BY PS_INTFC_BI.c1, PS_INTFC_BI.c2, PS_INTFC_BI.c3, . , 
```
Note. FUNCLIB_BIINTFC.BILL_BY_ID.FieldFormula PeopleCode contains all logic related to building the dynamic SQL.

The system treats the following fields as bill-by fields, even though they may not be part of the bill-by definition.

Note. If on the Installation Options - Billing - General Options page you define the invoice numbering at the bill source level, the system also adds BILL_SOURCE_ID as an implicit bill-by field.

BUSINESS_UNIT

BILL_TO_CUST_ID

BILL_TYPE_ID

BILL_SOURCE_ID (if invoice numbering is set to source)

BI_CURRENCY_CD

HDR_FIELDS_KEY

BUSINESS_UNIT_TO

The following fields are added to the implicit bill-by fields for those transactions subject VAT tax

COUNTRY_SHIP_FROM

COUNTRY_SHIP_TO

COUNTRY_VAT_BILLFR

COUNTRY_VAT_BILLTO

VAT_TREATMENT_GRP
Inserts one row of data into INTFC_BI_HTMPnn temporary table for every new bill header that is needed for a target invoice.

You can use a target invoice to specify the invoice number to which the lines should be added.

If the target invoice does not yet exist, the interface inserts a row into the header temporary table INTFC_BI_HTMPnn.
Inserts one row into the header temporary table for every rebill adjustment transaction line (AHDR/RBALL).

When creating a rebill adjustment of this nature, the only bill-by options that are used are bill status options.

BIIF0001.MAINPROC.HDRDFTS

This step updates new bill header information in INTFC_BI_HTMPnn temp table with default data from:

InterUnit setup defaults (InterUnit and IntraUnit bills only).
Customer defaults.
Bill source defaults.
Bill type defaults.
Business unit defaults.

When the system inserts new bill headers into the header temporary table, it enables data such as payment terms, payment method, and remit-to to appear by default into INTFC_BI_HTMPnn from customer, bill source, bill type, business unit, and system-wide billing installation options.

BIIF0001.MAINPROC.INSCRALL

This step inserts a row into the header temporary INTFC_BI_HTMPnn for every credit bill transaction (AHDR/CRALL). Header defaults are applied before the interface inserts the credit rows, which preserves the values of the credit bill and ensures that the credit bill is an exact reversal of the bill being adjusted. For credit adjustments of fully-paid invoices, the payment reference is set to unpaid and the paid at source is set to no.

See Processing Adjustments Through the Billing Interface.

BIIF0001.MAINPROC.HDRDFTS2

This step updates new bill header information in the INTFC_BI_HTMPnn temporary table with system level default data such as AR options, GL options, and current currency rate type. The invoice numbering default is also applied from either the system, bill source, bill type, or business unit level.

BIIF0001.MAINPROC.BILLSTAT

This step updates new bill headers with the appropriate bill status. The bill status is usually determined according to the Bill By Identifier page by the value that you select in the New Bill Status group box. The bill status can also be determined by direct invoicing, temporary bill flag, billing frequency, and line type.

See Using the Bill-By Identifier with the Billing Interface.

BIIF0001.MAINPROC.ASGN_IVC

This step:

Determines how many new invoice numbers need to be checked out for each invoice number ID.

The interface reserves the number needed by updating the BI_IVC_NUM table.
Assigns the new invoice numbers to regular bill headers in INTFC_BI_HTMPnn.

BIIF0001.MAINPROC.ADJHDPTR

This step selects adjustments of type CRALL and RBALL in INTFC_BI_HTMPnn. For these bills, this step assigns cross-reference invoice and line numbers.

BIIF0001.MAINPROC.ADJHDUPD

This step selects the headers from INTFC_BI_HTMPnn that have a full bill credit, and updates the ADJUSTED_FLAG and NEXT references.

BIIF0001.MAINPROC.INS_DTMP

This step inserts a row for every distinct discount or surcharge level, for each charge line, into temporary table INTFC_BI_DTMPnn.

For example, if the system is processing a charge line in the interface table with two related level one discounts and a level two discount, the system inserts two rows into INTFC_BI_DTMPnn, enabling it to keep track of discount or surcharge level subtotals. When it has calculated the discount or surcharge totals, the system populates BI_LINE_DS_LVL from INTFC_BI_DTMPnn, and populates BI_LINE_DS_DTL from INTFC_BIA_TAOnn.

BIIF0001.MAINPROC.INSBILLS

This step inserts bill headers into BI_HDR, selecting from INTFC_BI_HTMPnn. For rebill adjustments of fully-paid invoices, the payment reference field is set to unpaid and the paid at source field is set to no. The invoiced delivered field is initialized to no.

BIIF0001.MAINPROC.ASGNIVC5 and BIIF0001.MAINPROC.ASGNVIVC

This step assigns the invoice numbers to each LINE transaction in INTFC_BI_TAOnn. Once the system processes the bill headers (and consolidated bill headers), this step evaluates the line charge detail and evaluates the invoice to which the lines belong. At this point in the process, every line processed should have a bill to which it can belong.

BIIF0001.MAINPROC.UPSUMIVC

This step sets invoice summarization flag to Yes on the bill header for the new invoices that requires summarization

BIIF0001.MAINPROC.MAINCONS

This step:

Inserts a row into INTFC_BI_CTMPnn for each new consolidated bill header that it generates.

The interface process supports consolidated billing. The system automatically consolidates bills through the interface for bill-to customers who have consolidation data defined on the Customer Information, General Information, General Info page.

This step also determines how many new consolidated invoice numbers need to be checked out for each invoice number ID. The interface reserves the number needed by updating the BI_IVC_NUM table. For example, if 100 new invoice numbers are needed for a particular invoice number ID, this procedure increments the BI_IVC_NUM table by 100 to reserve the amount of new invoice numbers needed.
Updates new consolidated bill headers in INTFC_BI_CTMPnn with customer-level defaulting and invoice numbers, and inserts them into the bill header table.

By the time that the system inserts new consolidated bill headers into BI_HDR, there should exist at least one consolidated bill header to which the system can attach each new bill header in INTFC_BI_HTMPnn, if appropriate.

See Generating Consolidated Billing Through the Billing Interface.

See Adding General Customer Information.

BIIF0001.MAINPROC.CONS2HDR and BIIF0001.MAINPROC.CONSAHDR

This step associates regular bill headers with appropriate consolidated bill headers.

BIIF0001.MAINPROC.NEWSTAT

This step updates the bill status from RDY to NEW for installment invoices, recurring invoices, or invoices containing freight surcharge or miscellaneous charges and with no ship-to address number.

BIIF0001.MAINPROC.LINESEQ

This step evaluates the line charge detail and:

Assigns a line sequence number to the interface lines.
Assigns line distribution sequence numbers to the accounting entries for the interface lines.
Assigns note sequence numbers to header and line notes.
Calculates discounts and surcharges and updates discount or surcharge subtotals.

BIIF0001.MAINPROC.LSTIVCSQ

This step updates the last line sequence number on the bill header.

BIIF0001.MAINPROC.ADJ_IVC

This step evaluates the line charge detail and performs these tasks on adjustment invoices:

Determines the invoice to which the lines belong.

(At this point in the process, every line processed should have a bill to which it can belong.)
Assigns a line sequence number to the interface line.
Assigns line distribution sequence numbers to the accounting entries for the interface line.
Assigns note sequence numbers to header and line notes.
Calculates discounts and surcharges and updates discount or surcharge subtotals.

BIIF0001.MAINPROC.POPIUAES

This step populates accounting entries for InterUnit and IntraUnit bills, acquiring values from the central InterUnit and IntraUnit setup tables.

BIIF0001.MAINPROC.AFFLDFLT

This step defaults affiliate value on accounting distributions.

BIIF0001.MAINPROC.DAPP

This step consolidates all deposit applied lines (line type of DAPP), that have the same deposit ID and that will go into the same invoice, into one deposit applied line to be saved in BI_LINE.

BIIF0001.MAINPROC.NEWLINES

This step inserts line data into a temporary line so that default values may be applied.

BIIF0001.MAINPROC.LINEDFTS

This step updates bill line temporary tables to populate line default values and:

Applies customer default values to lines in the temporary table BI_ILINE_TAOnn.
Applies business unit default values to lines in the temporary table BI_ILINE_TAOnn.
Populates the temporary line table with adjustment lines that are bill reversals (CRALL), unchanged rebill lines (RBALL), and line reversals (CRLIN).
Populates the temporary line table with adjustment lines, and updates adjustment history references for bill lines.

BIIF0001.MAINPROC.INSLINES

This step inserts the interface table data into the bill data structure.

BIIF0001.MAINPROC.TOTHDRS

This step:

Selects all bills impacted by inserting new bill lines, and updates their totals to reflect the new activity added to them.
Updates consolidated invoice pretax invoice amount by summing all attached invoice pretax invoice amounts.
Calculates the TAX_AMT total.

BIIF0001.MAINPROC.TOTHDREX

This step accumulates excise and sales tax amounts from bill line and update the total excise and total sales tax amounts onto bill header.

BIIF0001.MAINPROC.UPBIPAID

This step updates the paid at source flag if there is at least one invoice line for the bill with a deposit applied line.

BIIF0001.MAINPROC.UPSUMFLG

This step sets invoice summarization flag to Yes on the bill header for the already existing invoices that requires summarization

BIIF0001.MAINPROC.UPDVATDF

This step sets the bill header VAT defaulting option to L indicate that new lines are appended to an existing VAT invoice. Setting bill header VAT defaulting option to L causes VAT defaults to be re-applied

BIIF0001.MAINPROC.UPPCSTAT

This step enables the PC_DISTRIB_STATUS value to appear by default in the BI_HDR table, based on bill lines of the invoice. The values that are assigned control processing that is related to the integration with PeopleSoft Contracts and Project Costing applications.

BIIF0001.MAINPROC.INV_TYPE

This step:

Updates the invoice type to RAD (regular with adjustments) for any bill headers that had line adjustments added to them.
Updates the invoice type to RAD (regular with adjustments) for any bill headers that originally contained only adjustment lines but have had regular lines added to them.

BIIF0001.MAINPROC.DRILBACK

This step:

Updates the IN_DEMAND_BI table with invoice number and invoice line sequence number for activity from PeopleSoft Order Management and Inventory.
Updates the CA_BP_XREF table with invoice number for activity from PeopleSoft Contracts.
Updates the BI_ADJ_GRP_LINE table with invoice number and invoice line sequence number for activity from the return material authorization features of PeopleSoft Order Management or PeopleSoft Inventory.

BIIF0001.MAINPROC.RESETPI

This step updates process instance with zero for newly inserted headers in the BI_HDR table.

BIIF0001.MAINPROC.MOVE2CMP

This step:

Moves the records from the temporary Billing interface staging tables—INTFC_BI_TAOnn, INTFC_BIA_TAOnn, INTFC_BI2_TAOnn, INTFC_BIN_TAOnn, and INTFC_BIH_TAOnn—to their respective archiving tables: INTFC_BI_CMP, INTFC_BI_AD_CMP, INTFC_BI2_CMP, INTFC_BI_NT_CMP, and INTFC_BI_HDRCMP.
After archiving is complete, deletes those records from the Billing interface tables that were moved to the archiving tables.