Understanding the INTFC_BI_EXSD Table

The GST Tax Detail table (INTFC_BI_EXSD) contains EXSD (India GST detail) transactions only. The following four attributes comprise the INTFC_BI_EXSD key:

Note:

The GST Tax Detail table is populated only by PeopleSoft Order Management. For sources other than PeopleSoft Order Management, the table is populated in the Billing Interface Process after GST tax determination is done.

Term	Definition
INTFC_ID (interface ID)	Represents a group or batch of billing activity. PeopleSoft 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)	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. The only option is EXSD (bill line excise tax detail entry). For each interface line number associated with an interface ID, there should be only one row of transaction type LINE in the INTFC_BI table. There can be multiple rows with transaction type EXSD in the INTFC_BI_EXSD table.
TRANS_TYPE_BI_SEQ (transaction type billing sequence)	The transaction type sequence is part of the key, to provide uniqueness in the event that there are multiple EXSD for a bill line charge.