Understanding the INTFC_BI2 Table

The Billing Interface Extension table (INTFC_BI2) (used for extended tax information, such as prepaid taxes, ship-to address overrides, and India transactions) contains LINE transactions only. India related fields are populated only by PeopleSoft Order Management. For sources other than PeopleSoft Order Management, the GST tax determination is done first and then the India related fields are populated. The following four attributes comprise the key to the INTFC_BI2 table:

Note:

India tax functionality is supported only for PeopleSoft Order Management and only for net line adjustments (adjustment transaction type = NTLIN).

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.