Billing Interface Tables
This topic contains information about the Billing Interface tables, organized by the primary process that accesses each table:
The Billing Interface process creates bills from the following tables:
Field or Control |
Description |
---|---|
INTFC_BI (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ) |
Contains billable data being sent to PeopleSoft Billing from external sources. |
INTFC_BI2 (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ) |
Contains billable data being sent to PeopleSoft Billing from external sources. This table can be considered an expansion table for the INTFC_BI table. |
INTFC_BI_NOTE (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ) |
Contains a nonstandard bill header or line note for billable data being sent to PeopleSoft Billing from external sources. This table can be considered an expansion table for the INTFC_BI table. |
INTFC_BI_HDR (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ, HDR_FIELDS_KEY, HDR_TRANS_TYPE) |
Contains override-credit card, VAT, and miscellaneous bill-header-related data being sent to PeopleSoft Billing from an external source. This table can be considered an expansion table for the INTFC_BI table. |
INTFC_BI_AEDS (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ) |
Contains accounting, discount, and surcharge data sent to PeopleSoft Billing from external sources. |
INTFC_BI_TAX (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI, TRANS_TYPE_BI_SEQ) |
Contains the tax details for transactions which already have taxes calculated. |
The Load AR Pending Items process transfers data from the Billing tables to the following Receivables interface tables:
Field or Control |
Description |
---|---|
GROUP_CONTROL (GROUP_BU, GROUP_ID) |
Contains one record for every group of pending items generated through the Load AR Pending Items (load accounts receivable pending items) process. |
PENDING_ITEM_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM) |
Parent table that contains one record for every pending item generated through the Load AR Pending Items process. |
PENDING_DST_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, DST_SEQ_NUM, LEDGER_GROUP, LEDGER): |
Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process. |
PENDING_VAT_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, VAT_APPLICABILITY, VAT_TXN_TYPE_CD, TAX_CD_VAT, VAT_DST_ACCT_TYPE, VAT_SEQ_NUM): |
Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process. |
PENDING_TAX_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, TAX_RATE_SEQ |
Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process. |
PENDING_TAX_DTL_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, TAX_RATE_SEQ, EXS_TAX_RATE_CD, EXS_TAX_RATE_SEQ): |
Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process. |
The Load GL Accounting Entries process transfers data from the following tables to the General Ledger interface
Field or Control |
Description |
---|---|
BI_ACCT_ENTRY (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, DISC_SUR_LVL, DISC_SUR_ID, LINE_DST_SEQ_NUM, TAX_AUTHORITY_CD, ACCOUNTING_DT, ACCT_ENTRY_TYPE) |
Contains one record for each accounting entry generated through the Load GL Accounting Entries process or the Unbilled Accrual process. |
The RMA Adjustments process uses the data in the following table to process adjustments for returned materials entered in the Order Management application.
Field or Control |
Description |
---|---|
BI_ADJ_GRP_LINE (BUSINESS_UNIT_OM, RMA_ID, RMA_LINE_NBR, LINE_TYPE, SEQ_NUM) |
Contains one record for every return material authorization (RMA) line or restocking fee generated through the RMA Adjustment interface. |
The Generate AP Voucher process transfers data from the following tables to the Accounts Payables interface
Field or Control |
Description |
---|---|
VCHR_HDR_STG (BUSINESS_UNIT, VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2, VOUCHER_ID) |
Parent table that contains one record for every voucher generated through the Generate AP Voucher Entries process. VCHR_LINE_STG (BUSINESS_UNIT, VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2, VOUCHER_ID, VOUCHER_LINE_NUM): Child table that may contain none, one, or more than one record for each pending item generated through the Generate AP Voucher Entries process. VCHR_DIST_STG (BUSINESS_UNIT, VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2, VOUCHER_ID, VOUCHER_LINE_NUM, DISTRIB_LINE_NUM): Child table that may contain none, one, or more than one record for each pending item generated through the Generate AP Voucher Entries process. |