Populating the INTFC_BI2 Table

This topic provides an overview of the INTFC_BI2 table and discusses how to populate 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.

The INTFC_BI2 table has the same key structure as the INTFC_BI table; consider it an extension of the INTFC_BI table. Currently, it is used only for certain tax transactions, including prepaid taxes, ship-to address overrides (for tax provider tax calculation purposes) and India transactions

For every row in INTFC_BI2, there must exist a row in the INTFC_BI table with the same key values. However, you do not need a row in the INTFC_BI2 table for every row in INTFC_BI.

The following table contains all columns in the INTFC_BI2 table and how they should be populated for LINE transactions:

Note: For Third-party tax transactions with a ship-to address override, you must at least populate the following fields: to insert a row into BI_LINE_TAX table: CITY, STATE, POSTAL, and COUNTRY.

Field Number	Field Name	LINE
1	INTFC_ID (interface ID)	Required. Used to group or batch a collection of Billing interface activity.
2	INTFC_LINE_NUM (interface line number)	Required. Each unique interface line number for an interface ID represents a separate bill line charge.
3	TRANS_TYPE_BI (transaction type)	Required. Value must be LINE.
4	TRANS_TYPE_BI_SEQ	Required. Set it to 0 (zero).
5	PROCESS_INSTANCE	Leave blank.
6	ADDRESS1 (address line1)	Optional.
7	ADDRESS2 (address line2)	Optional.
8	ADDRESS3 (address line3)	Optional.
9	ADDRESS4 (address line4)	Optional.
10	IN_CITY_LIMIT	Optional. Used by third-party tax provider products to determine additional city taxes, where applicable.
11	GEO_CODE (geographic code)	Optional. Used by the third-party tax provider products to determine what taxing jurisdictions and tax rates to use.
12	CITY	Optional.
13	HOUSE_TYPE	Optional.
14	ADDR_FIELD1 (address field1)	Optional.
15	ADDR_FIELD2 (address field2)	Optional.
16	ADDR_FIELD3 (address field3)	Optional.
17	NUM1	Optional. Related to an address in countries, such as the Netherlands.
18	NUM2	Optional. Related to an address in countries, such as the Netherlands.
19	COUNTY	Optional.
20	STATE	Optional. Select from the values in the STATE_TBL.
21	POSTAL	Leave blank.
22	COUNTRY	Optional. Select from the values in the COUNTRY_TBL.
23	TAX_AMT	Required if sales and use taxes were prepaid. Report the amount of prepaid sales and use tax. Should equal the sum of the TAX_AMT fields of records on the INTFC_BI_TAX table correlating to the same line transaction.
24	TAX_PCT	Required if sales and use taxes were prepaid. Report the percentage tax rate of prepaid sales and use taxes.
25	MAX_TAX_FLG	Set to Y if prepaid sales and use taxes were calculated taking advantage of maximum tax rules.
26	TAX_JUR_IND	Required if VAT was prepaid. Set to the VAT tax journal to which the VAT payment should be recorded.
27	VAT_BASIS_AMT	Required if VAT was prepaid. Report the VAT basis used to calculate value-added taxes.
28	VAT_AMT	Required if VAT was prepaid. Report the prepaid VAT amount.
29	VAT_TRANS_AMT	Required if VAT was prepaid. Report the VAT transaction amount used to calculate value-added taxes.
30	TAX_CD_VAT_PCT	Required if VAT was prepaid. Report the VAT percentage used to calculate value-added taxes.
31	EXD_INVOICE_NO	Populated by PeopleSoft Order Management if excise tax is applicable. Not applicable for GST.
32	EXD_INVOICE_LINE	Populated by PeopleSoft Order Management if excise tax is applicable. Not applicable for GST.
33	EXD_APPL_FLG	Populated by PeopleSoft Order Management. Not applicable for GST. Values are: Y if excise tax is applicable. N if excise tax is not applicable.
34	STX_APPL_FLG	Required for India transactions populated by PeopleSoft Order Management. Populated during tax determination for sources other than PeopleSoft Order Management. Values are: Y if GST is applicable. N if GST is not applicable.
35	STX_TAX_AUTH_CD	Required for India transactions populated by PeopleSoft Order Management. Populate with a valid sales tax authority code. Populated during tax determination for sources other than PeopleSoft Order Management.
36	EXD_TAX_RATE_CD	Populated by PeopleSoft Order Management. Populate with a valid excise tax rate code if excise tax is applicable. Not applicable for GST.
37	STX_TAX_RATE_CD	Required for India transactions populated by PeopleSoft Order Management. Populated during tax determination for sources other than PeopleSoft Order Management. Populate with a valid GST tax rate code if GST is applicable.
38	INV_ITEM_ID	Required for India transactions populated by PeopleSoft Order Management.
39	ORG_SETID	Required for India transactions populated by PeopleSoft Order Management.
40	ORG_CODE	Required for India transactions populated by PeopleSoft Order Management.
41	ORG_TAX_LOC_CD	Required for India transactions populated by PeopleSoft Order Management.
42	EXD_CONVERSION_RT	Populated by PeopleSoft Order Management. Not applicable for GST.
43	QTY_BASE	Required for India transactions populated by PeopleSoft Order Management. Populate with QTY_SHIP_BASE field.
44	EXS_TAX_TXN_TYPE	Required for India transactions populated by PeopleSoft Order Management.
45	EXD_CUST_CATG_CD	Populated by PeopleSoft Order Management. Not applicable for GST.
46	STX_CUST_CATG_CD	Required for India transactions populated by PeopleSoft Order Management.
47	EXD_ITM_CATG_CD	Populated by PeopleSoft Order Management. Not applicable for GST.
48	STX_ITM_CATG_CD	Required for India transactions populated by PeopleSoft Order Management.
49	EXS_SERV_TAX_FLG	Required for India transactions populated by PeopleSoft Order Management.
50	EXD_ASSESS_VALUE	Populated by PeopleSoft Order Management. Not applicable for GST.
51	EXD_UOM	Populated by PeopleSoft Order Management. Not applicable for GST.
52	EXD_USE_AV_FLG	Populated by PeopleSoft Order Management. Not applicable for GST.
53	BI_CURRENCY_CD	Leave blank.
54	BASE_CURRENCY	Leave blank.
55	EXS_CURRENCY_RPTG	Required for India transactions populated by PeopleSoft Order Management.
56	EXD_TAX_AMT	Populated by PeopleSoft Order Management. Not applicable for GST.
57	EXD_TAX_AMT_BSE	Populated by PeopleSoft Order Management. Not applicable for GST.
58	EXD_TAX_AMT_RPT	Populated by PeopleSoft Order Management. Not applicable for GST.
59	STX_TAX_AMT	Required if taxes are calculated in PeopleSoft Order Management for India transactions.
60	STX_TAX_AMT_BSE	Required if taxes are calculated in PeopleSoft Order Management for India transactions.
61	STX_TAX_AMT_RPT	Required if taxes are calculated in PeopleSoft Order Management for India transactions.
62	STX_FORM_CD	Populated by PeopleSoft Order Management. Not applicable for GST.
63	LOAD_STATUS_BI	Initialize to NEW or leave blank.
64	ERROR_STATUS_BI	Leave blank.
65	USETAX_AMT	Leave blank.
66	USETAX_BASIS_AMT	Leave blank.
67	USETAX_BASIS_AMT	Leave blank.
68	USETAX_BASIS_AMT_B	Leave blank.
69	TAX_AMT_BSE	Leave blank.
70	TAX_CD_VAT_RVC_PCT	Leave blank.
71	VAT_AMT_RVC	Leave blank.
72	ADD_DTTM	Required for accurate reporting purposes and for taking advantage of interface workflow function.
73	LAST_UPDATE_DTTM	Leave blank.

Populating the INTFC_BI2 Table

Understanding the INTFC_BI2 Table

Populating the INTFC_BI2 Table for Line Transactions