Understanding the INTFC_BI_HDR Table

The Billing Interface Bill Header table (INTFC_BI_HDR) contains only LINE transactions. The following six attributes comprise the key to the INTFC_BI_HDR table:

Term	Definition
INTFC_ID (interface ID)	Represents a group or batch of billing activity, that is, a collection of billing activity that may be produced by a billing source system. For example, a system may generate a group or batch each night, while another may produce a group or batch for a certain kind of billing activity.
INTFC_LINE_NUM (interface line number)	Represents a bill line charge. For each interface ID (group or 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)	Characterizes the type of data being stored. LINE (bill line charge) is the only valid option. For each interface line number associated with an interface ID, there should be only one row of transaction type LINE.
TRANS_TYPE_BI_SEQ (transaction type billing sequence)	Zero for LINE transactions.
HDR_FIELDS_KEY (header fields key)	Represents subheader information, including VAT, credit card, header level AR distribution, and miscellaneous header information. This field also exists in the INTFC_BI table and is used as a foreign key to the INTFC_BI_HDR table. Source systems populate and maintain this key based on grouping of billing activity. PeopleSoft Billing maintains this field in the Billing Interface History record (INTFC_BI_CMP) as well as in the BI_HDR record. Bill header-related overrides for credit card, VAT, AR, and miscellaneous data records in the INTFC_BI_HDR table are tied to the main Billing Interface table (INTFC_BI) through this field.
HDR_TRANS_TYPE (header transaction type)	Options are: VAT: Bill header VAT data. CRC: Bill header credit card data. MSC: Bill header miscellaneous data. HAR: Bill header AR data.