Populating the INTFC_BI_EXSD Table for LINE Transactions

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.