Understanding the INTFC_BI_TAX Table

The Tax Detail table (INTFC_BI_TAX) is used to report the details of sales and use taxes paid for fully-paid invoices. Report taxes by line, using separate transactions to reflect the amount levied by each tax authority. The following four attributes comprise the INTFC_BI_TAX key::

Term	Definition
INTFC_ID (interface ID)	Represents a group or batch of billing activity. This PeopleSoft application uses the term group or batch to mean a collection of billing activity that may be produced by a billing source system. Some systems may generate a group or batch each night. Other systems may produce a group or batch for a certain kind of billing activity.
INTFC_LINE_NUM (interface line number)	With INTFC_ID, identifies the bill line charge on the INTFC_BI table to which this tax detail entry applies.
TRANS_TYPE_BI (transaction type billing)	Characterizes the type of data being stored. The only option is TAX. For each interface line number associated with an interface ID, only one row of transaction type LINE should appear in the INTFC_BI table. Multiple rows can have transaction type TAX in the INTFC_BI_TAX table.
TRANS_TYPE_BI_SEQ (transaction type billing sequence)	The transaction type sequence is part of the key. It provides uniqueness in the event that a bill line charge has multiple tax detail records.

Note:

Billing ignores any INTFC_BI_TAX entries unless the invoice is fully-paid.

Billing does not validate whether taxes should be levied on fully-paid invoices.