Understanding the INTFC_BI_NOTE Table

The Billing Interface Note/Comment table (INTFC_BI_NOTE) contains the text of nonstandard notes and comments. Each record corresponds to a record on the INTFC_BI table having a transaction type of NOTE. The following four attributes comprise the key to the INTFC_BI_NOTE 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)	With INTFC_ID, identifies the NOTE record on the INTFC_BI table to which this note entry applies.
TRANS_TYPE_BI (transaction type billing)	Characterizes the type of data being stored. NOTE (custom note or comment) is the only valid option.
TRANS_TYPE_BI_SEQ (transaction type billing sequence)	Part of the key that provides uniqueness in the event that there are multiple notes or comments for a bill line charge.