Populating the INTFC_BI_EXSD Table

This topic provides an overview of the GST Tax Detail table and discusses how to populate it for LINE transactions.

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.

For each bill line charge added as a bill line to the bill data structure, the Billing Interface table contains one row of data with a transaction type of LINE. The value of the TRANS_TYPE_BI column for the INTFC_BI_EXSD table must be EXSD. For each bill line charge row with a transaction type of LINE, the Billing interface can contain bill line excise tax detail entries (EXSD entries) in the INTFC_BI_EXSD table.

The following table demonstrates how to populate the INTFC_BI_EXSD table for LINE transactions:

Field Number	Field Name	EXSD
1	INTFC_ID	Required for India transactions populated by PeopleSoft Order. Used to group or batch a collection of Billing interface activity.
2	INTFC_LINE_NUM	Required for India transactions populated by PeopleSoft Order Management. Each unique interface line number for an interface ID represents a separate bill line charge.
3	TRANS_TYPE_BI	Required for India transactions populated by PeopleSoft Order Management. Value must be EXSD.
4	TRANS_TYPE_BI_SEQ	Required for India transactions populated by PeopleSoft Order Management. If more than one excise tax detail entry is populated for a particular EXSD transaction, the transaction type sequence must be used for uniqueness.
5	LOAD_STATUS_BI	Initialize to NEW or leave blank.
6	ERROR_STATUS_BI	Leave blank.

The following fields can contain values for GST. When EXS_TAX_TYPE equals G (GST), fields prefixed with EXS_ must be populated with GST-related data. EXS_ fields populate the BI_LINE_EXS_DTL table.


Field Number	Field Name	EXSD
7	EXS_TAX_TYPE	Required for India transactions populated by PeopleSoft Order Management. Values are: C: Custom Duty S: Sales Tax and VAT E: Excise Tax G: Goods and Services Tax
8	EXS_TAX_RATE_SEQ	Required for India transactions populated by PeopleSoft Order Management.
9	EXS_TAX_RATE_CD	Required for India transactions populated by PeopleSoft Order Management. Populate with a valid tax rate code.
10	EXS_TAX_CMPNT_CD	Required for India transactions populated by PeopleSoft Order Management.
11	EXS_TAX_DEP_CD	Required for India transactions populated by PeopleSoft Order Management.
12	EXS_CALC_SCHEME	Required for India transactions populated by PeopleSoft Order Management.
13	EXS_TAX_RATE_PCT	Required for India transactions populated by PeopleSoft Order Management.
14	EXS_TXRTAMT_TRC	Required for India transactions populated by PeopleSoft Order Management.
15	EXS_CURRENCY_TRC	Required for India transactions populated by PeopleSoft Order Management.
16	BI_CURRENCY_CD	Leave blank.
17	BASE_CURRENCY	Leave blank.
18	EXS_TAXRT_AMT	Required for India transactions populated by PeopleSoft Order Management.
19	EXS_TAXRT_AMT_BSE	Required for India transactions populated by PeopleSoft Order Management.
20	EXS_TAXRT_AMT_RPT	Required for India transactions populated by PeopleSoft Order Management.
21	EXS_TAX_RATE_UOM	Required for India transactions populated by PeopleSoft Order Management.
22	EXS_CURRENCY_RPTG	Leave blank.
23	EXS_TAX_AMT	Required if PeopleSoft Order Management calculates taxes for India transactions.
24	EXS_TAX_AMT_BSE	Required if PeopleSoft Order Management calculates taxes for India transactions.
25	EXS_TAX_AMT_RPT	Required if PeopleSoft Order Management calculates taxes for India transactions.
26	EXS_BASIS_AMT	Required if PeopleSoft Order Management calculates taxes for India transactions.
27	EXS_BASIS_AMT_BSE	Required if PeopleSoft Order Management calculates taxes for India transactions.
28	EXS_BASIS_AMT_RPT	Required if PeopleSoft Order Management calculates taxes for India transactions.
29	PROCESS_INSTANCE	Leave blank.
30	ADD_DTTM	Required for accurate reporting purposes and for Billing interface workflow functionality.
31	LAST_UPDATE_DTTM	Leave blank.

Populating the INTFC_BI_EXSD Table

Understanding the INTFC_BI_EXSD Table

Populating the INTFC_BI_EXSD Table for LINE Transactions