Understanding the INTFC_BI Table

The following four attributes comprise the key to the Billing Interface table (INTFC_BI):

Term Definition

INTFC_ID (interface ID)

Represents a batch of billing activity, that is, a collection of billing activity that may be produced by a billing source system. Some systems may generate a batch each night. Other systems may produce a batch for a certain kind of billing activity.

When assigning a new INTFC_ID for a batch of data, the Last BI Interface ID field (INSTALLATION_BI.LAST_INTFC_ID) on the Installation Options – Billing General page can be used to ensure that a unique number is assigned. The source system can increase this number by one and use that number for the new batch of data.

INTFC_LINE_NUM (interface line number)

Represents a bill line charge. For each interface ID (batch of billing activity), there may be multiple interface line numbers, one for each bill line charge in the group.

TRANS_TYPE_BI (transaction type billing)

Transaction type. Characterizes the type of data being stored. Options are LINE, NOTE, and AHDR:

  • Each LINE within an interface ID should be assigned a unique interface line number.

  • Each LINE may have multiple NOTE transactions.

  • When providing AHDR transactions, there should be only one AHDR row for each interface line number.

    In this scenario, you may only associate NOTE transaction types with the same interface line number and interface ID as this AHDR row.

TRANS_TYPE_BI_SEQ (transaction type billing sequence)

Transaction type sequence. Part of the key used to provide uniqueness in the event that there are multiple notes or comments for a bill line charge. For a LINE transaction, set this attribute to 0 (zero).

Populate the INTFC_BI table for LINE, NOTE, and AHDR transactions only. For each bill line charge added as a bill line to the bill data structure, the Billing Interface table contains one row of data with a transaction type of LINE. For each bill line charge row with a transaction type of LINE, the Billing Interface table can contain one or more notes or comments (NOTES).

Note:

To ensure VAT data integrity, you must run the VAT Defaulting process after the Billing Interface process when importing bills with VAT data.