Understanding the Billing Data Structure

This chapter discusses PeopleSoft Billing tables, key structures, and relationships among tables. There are three main categories of PeopleSoft Billing tables:

Note. In the following sections, the child tables are indented below their parent table. Each table's key follows the table name in parentheses.

Click to jump to parent topicControl Tables

Control tables contain information and options that enable you to adapt PeopleSoft Billing to the unique requirements of your business environment.

This section provides information about:

Click to jump to top of pageClick to jump to parent topicTable Keys

Most of these tables are keyed by setID, although a limited number are keyed by business unit. The setID tables may share table data with multiple business units.

For the tables keyed by business unit, you must enter information for each business unit. This information cannot be shared with other business units.

Tables that have EFFDT as part of their key may contain multiple records with the same key made unique by the effective date.

See Also

Preparing to Implement

Click to jump to top of pageClick to jump to parent topicBusiness Unit Tables

This section contains information about business unit tables:

BUS_UNIT_TBL_FS (BUSINESS_UNIT)

Contains one record for each business unit established for the PeopleSoft Financials applications.

BUS_UNIT_TBL_GL (BUSINESS_UNIT)

Parent table that contains one record for each business unit authorized as a PeopleSoft General Ledger business unit.

BU_LED_TBL (BUSINESS_UNIT, LEDGER): Child table that contains one record for each ledger assigned to a PeopleSoft General Ledger business unit.

BU_LED_CUR_TBL (BUSINESS_UNIT, LEDGER_GROUP, CURRENCY_CD): Child table that contains one record for each ledger in each currency code.

BUS_UNIT_TBL_BI (BUSINESS_UNIT)

Contains one record for each business unit authorized as a PeopleSoft Billing business unit.

BUS_UNIT_OPT_BI (SETID)

Contains one record for a setID, which may correspond to a single business unit or to a group of business units, depending on the use of setID features. Contains PeopleSoft Billing processing options.

BUS_UNIT_TBL_AR (BUSINESS_UNIT)

Contains one record for each business unit authorized as a PeopleSoft Receivables business unit.

BUS_UNIT_OPT_AR (SETID)

Contains one record for a setID, which may correspond to a single business unit or to a group of business units, depending on the use of setID features. Contains PeopleSoft Receivables processing options.

Click to jump to top of pageClick to jump to parent topicBill Structure Tables

This section contains information about bill structure tables:

BI_BILL_BY (BILL_BY_ID)

Parent table that contains one record for each bill by identifier.

BI_BILL_BY_FLD (BILL_BY_ID, FIELDNAME): Child table that contains one record for each field associated with a bill by identifier.

BI_INQPHONE_TBL (SETID, BILL_INQUIRY_PHONE, EFFDT)

Contains one record for each bill inquiry phone.

BI_SRC (SETID, BILL_SOURCE_ID, EFFDT)

Contains one record for each bill source.

BI_TYPE (SETID, BILL_TYPE_ID, EFFDT)

Contains one record for each bill type.

BI_INSTALL_PLAN (SETID, INSTALL_PLAN_ID, EFFDT)

Contains one record for each installment bill plan ID used by the installment billing feature.

BI_INSTALL_PCT (SETID, INSTALL_PLAN_ID, EFFDT, INSTALL_NBR)

Contains one record for each installment bill plan ID percentage used by the installment billing feature.

BI_CYCLE (BILL_CYCLE_ID)

Contains one record for each bill cycle.

BI_CYCLE_PARM (BILL_CYCLE_ID, CYCLE_PARM_TYPE)

Contains one record for each recurring bill and installment bill under the bill cycle identifier.

BI_SPECIALIST (SETID, BILLING_SPECIALIST, EFFDT)

Contains one record for each billing specialist.

BI_CHARGE (SETID, BI_CURRENCY_CD, CHARGE_ID, EFFDT)

Contains one record for each charge code identifier.

BI_CF_TMPLT_HDR (TEMPLATE_ID)

Contains ChartField configuration templates.

BI_CF_TMPLT_LN (TEMPLATE_ID, FIELDNAME): Child table that contains the ChartFields for each template ID.

COLLECTOR_TBL (SETID, COLLECTOR, EFFDT)

Contains one record for each collector.

CR_ANALYST_TBL (SETID, CR_ANALYST, EFFDT)

Contains one record for each credit analyst.

BI_DISC_SUR (SETID, BI_CURRENCY_CD, DISC_SUR_ID, EFFDT)

Contains one record for each discount or surcharge and currency code combination.

DST_CODE_TBL (SETID, DST_ID, EFFDT)

Contains one record for each distribution code.

BI_IVC_FORM (INVOICE_FORM_ID)

Contains one record for each combination of invoice formatting options.

BI_IVC_LAYOUT (INVOICE_LAYOUT_ID)

Contains one record for each invoice layout.

BI_IVC_NUM (IVC_NUM_ID)

Contains one record for each invoice number definition.

NOTE_TYPE (SETID, NOTE_TYPE, EFFDT)

Contains one record for each note type.

BI_PNLSERIESHDR (BI_PNLSERIES_ID)

Contains one record for each Standard Billing, Bill Entry page series definition.

BI_PNLSERIESDTL (BI_PNLSERIES_ID, SEQ_NUM)

Contains one record for each page and sequence in a page series definition.

PAY_TRMS_TIME (SETID, PAY_TRMS_TIME_ID)

Contains one record for each timing ID.

PAY_TRMS_TBL (SETID, PYMNT_TERMS_CD, EFFDT)

Parent table that contains one record for each payment terms code.

PAY_TRMS_NET (SETID, PYMNT_TERMS_CD, EFFDT, BASIS_FROM_DAY): Child table that contains one record for each net term within a date range.

PAY_TRMS_DSCNT (SETID, PYMNT_TERMS_CD, EFFDT, BASIS_FROM_DAY, DS_PY_TRMS_TIME_ID): Child table that contains one record for each discount term within a date range.

SALES_PERSN_TBL (SETID, SALES_PERSON, EFFDT)

Contains one record for each salesperson.

TAX_AUTH_HDR (SETID, TAX_AUTHORITY_CD)

Parent table that contains one record for each tax authority.

TAX_AUTHORITY (SETID, TAX_AUTHORITY_CD, EFFDT): Child table that contains one record for each effective date of a tax authority.

TAX_HEADER_TBL (SETID, TAX_CD)

Parent table that contains one record for each tax code established for a setID.

TAX_CD (SETID, TAX_CD, TAX_AUTHORITY_CD): Child table that contains one record for each tax authority related to a tax code.

BI_SORT_BY (INVOICE_SORT_BY_ID)

Contains one record for each sort by identifier.

BI_SORT_BY_FLD (INVOICE_SORT_BY_ID, IVC_LINE_ORDER_SEQ)

Contains one record for each field and its sequence for each sort by identifier.

BI_SORT_BY_LIN (LIN_TYP_SORT_BY_ID)

Contains one record for each sort by line type identifier.

BI_SORT_LIN_TYP (LIN_TYP_SORT_BY_ID, LIN_TYP_ORDER_SEQ, LINE_TYPE)

Contains one record for each line type and its sequence for each line type sort by identifier.

STD_NOTE (SETID, STD_NOTE_CD, EFFDT)

Contains one record for each standard note.

BI_TAX_GROUP (TAX_GROUP)

Contains one record for each tax group.

BI_VAT_GROUP (SETID, VAT_GROUP)

Contains one record for each value-added tax (VAT) group.

BI_ACCUM_ID (BAL_ACCUM_ID)

Contains one record for each balance accumulation ID where each ID represents a set of accumulation rules (for example, accumulate by contract).

BANK_CD_TBL (SETID, BANK_CD)

Contains one record for each bank.

BANK_ACCT_TBL (SETID, BANK_CD, BANK_ACCT_KEY)

Contains one record for each bank account or remit to address that is not a bank.

BI_SUM_ID_CFG (SUM_CFG_ID)

Contains one record for each Summarization ID. Parent table to BI_SUM_FLD_CFG.

BI_SUM_FLD_CFG (SUM_CFG_ID, FIELDNAME)

Contains records for the fields that make up a Summarization ID. Child table to BI_SUM_ID_CFG.

BI_SUM_TEMPLATE (SUM_TEMPLATE_ID, DESC)

Contains one record for each Summarization Template.

BI_SUM_TMPL_DTL (SUM_TEMPLATE_ID, FIELDNAME)

Contains details for the Summarization Templates defined in BI_SUM_TEMPLATE.

BI_SGRP_TYP_TBL (SUM_GROUP_TYPE, DESC)

Contains one record for each Summarization Group Type.

BI_SGRP_ID_TBL (SUM_GROUP_TYPE, SUM_GROUP_ID, DESC)

Contains one record for each member of each group defined in BI_SGRP_TYP_TBL.

Click to jump to top of pageClick to jump to parent topicGeneral Tables

This section contains information about general data tables:

ACCT_TYPE_TBL (SETID, ACCOUNT_TYPE)

Contains one record for each account type established for a setID (identifier). An account type is used to classify accounts as income, expense, and so on.

JRNLGEN_DEFN (SETID, ACCTG_DEF_NAME)

Parent table that contains one record for each journal generator account definition for a setID. You need not set this up if you do not plan to create general ledger accounting entries.

JRNLGEN_DEFNV (SETID, ACCTG_DEF_NAME, FIELD_SEQUENCE): Child table that contains one record for each accounting entry that maps to a ChartField.

AUTO_NUMFLD_TBL (SETID, NUM_TYPE)

Contains one record for each type of field in a setID that uses automatic number sequencing. For PeopleSoft Billing, set up a record for customer ID. Handle invoice numbering in a separate function.

AUTO_NUM_TBL (SETID, NUM_TYPE, BEG_SEQ)

Contains one record for each type of autonumbering scheme that you want to set up. You can specify only one as the default scheme.

COUNTRY_TBL (COUNTRY)

Parent table that contains one record for each country code established. The installation database contains most values that you need.

STATE_TBL (COUNTRY, STATE): Child table that contains one record for each state that is valid for a country. The installation database contains most values that you need.

CURRENCY_CD_TBL (CURRENCY_CD, EFFDT)

Contains one record for each effective-dated currency code. The installation database contains most values that you need.

CURRENCY_EURO (CURRENCY_CD)

Contains one record for each currency code that is migrating to the euro currency.

CUR_RT_TYPE_TBL (CUR_RT_TYPE, EFFDT)

Contains one record for each effective-dated currency rate type.

CUR_RT_TBL (FROM_CUR, TO_CUR, CUR_RT_TYPE, EFFDT)

Contains one record for effective-dated currency rate type exchange rate.

CAL_DEFN_TBL (SETID, CALENDAR_ID)

Contains one record for each detail calendar for a setID.

CAL_DETP_TBL (SETID, CALENDAR_ID, FISCAL_YEAR, ACCOUNTING_PERIOD)

Contains one record for each period in a detail calendar.

INSTALLATION

Contains PeopleSoft installation options and defaults.

INSTALLATION_FS (NO KEY)

Contains PeopleSoft Financials installation options.

INSTALLATION_BI (NO KEY)

Contains PeopleSoft Billing installation options.

TAX_PROV_INFO (NO KEY)

Contains tax provider installation options.

JRNLGEN_APPL_ID (SETID, APPL_JRNL_ID, EFFDT)

Contains one record for each journal generator template for each application by setID. This is required only if you plan to generate journals for PeopleSoft Billing.

JRNLGEN_SUMV (SETID, APPL_JRNL_ID, EFFDT, SELECT_VALUE)

Contains one record for each summarization option for the journal generator.

SOURCE_TBL (SETID, SOURCE, EFFDT)

Contains one record for each effective-dated journal source for a setID. This is required only if you plan to generate journals for PeopleSoft Billing.

LOCATION_TBL (SETID, LOCATION, EFFDT)

Contains one record for each location (address) for a setID. You might set up separate locations for each business unit, office location, warehouse, sales office, and so forth.

OPR_DEF_TBL_FS (OPRID)

Contains one record for each PeopleSoft Financials user.

OPR_DEF_TBL_BI (OPRID)

Contains one record for each PeopleSoft Billing user.

RT_DFLT_VW (FROM_CUR, TO_CUR, RT_TYPE, EFFDT)

Contains one record for each effective-dated currency rate type exchange rate. This table replaces references to CUR_RT_TBL in older releases of PeopleSoft applications.

RT_TYPE_TBL (RT_TYPE)

Contains one record for each rate type.

UNITS_TBL (UNIT_OF_MEASURE)

Parent table that contains one record for each unit of measurement established.

UNITS_CVT_TBL (UNIT_OF_MEASURE, UNIT_OF_MEASURE_TO): Child table that contains a record for each unit of measurement and its conversion unit.

FREIGHT_TERMS (SETID, FREIGHT_TERMS)

Contains one record for each freight terms entry.

Click to jump to top of pageClick to jump to parent topicLedger Tables

This section contains information about ledger tables:

LED_DEFN_TBL (SETID, LEDGER)

Contains one record for each ledger established for a setID. This is required if you plan to generate accounting entries for PeopleSoft Billing.

LED_FLDS_TBL (SETID, LEDGER, FIELD_SEQUENCE, CHARTFIELD)

Contains one record for each ChartField mapped in a ledger.

Click to jump to top of pageClick to jump to parent topicChartField Tables

This section contains information about ChartField tables:

GL_ACCOUNT_TBL (SETID, ACCOUNT, EFFDT)

Contains one record for each general ledger account established for a setID.

ALTACCT_TBL (SETID, ALTACCT, EFFDT)

Contains one record for each general ledger alternate account established for a setID.

DEPT_TBL (SETID, DEPTID, EFFDT)

Contains one record for each department established for a setID.

OPER_UNIT_TBL (SETID, OPERATING_UNIT, EFFDT)

Contains one record for each operating unit established for a setID.

PRODUCT_TBL (SETID, PRODUCT, EFFDT)

Contains one record for each product established for a setID.

PROJECT (BUSINESS_UNIT, PROJECT_ID)

Contains one record for each project established for a setID.

STAT_TBL (SETID, STATISTICS_CODE, EFFDT)

Contains one record for each statistics code established.

Click to jump to top of pageClick to jump to parent topicMiscellaneous Tables

This section contains information about miscellaneous tables:

BI_IVC_NUM_PRE (BUSINESS_UNIT, INVOICE)

Contains one record for each invoice number that has been preassigned in a batch process, such as bill copy group or bill interface, to avoid a duplicate key assignment.

SETID_TBL (SETID)

Contains one record for each setID created in PeopleSoft.

SET_CNTRL_TBL (SETCNTRLVALUE)

Contains one record for each set control value and its default setID.

SET_CNTRL_GROUP (SETCNTRLVALUE, REC_GROUP_ID)

Contains one record for each record group and the pointers between a set control value and a setID.

SET_CNTRL_REC (SETCNTRLVALUE, REC_GROUP_ID, RECNAME)

Contains one record for each record and the record group to which it belongs. The table also contains the pointers between a set control value and a setID.

Click to jump to parent topicBilling and Accounting Tables

The following tables store billing and accounting data. The business unit is the primary key of all tables in this group. These tables are not effective-dated; only control tables have this feature.

BI_HDR (BUSINESS_UNIT, INVOICE)

Parent table that contains one record for each bill header.

BI_HDR_CC (BUSINESS_UNIT, INVOICE, SEQ_NUM): Child table that contains one record for each courtesy copy address for a bill header.

BI_HDR_CRCARD (BUSINESS_UNIT, INVOICE, SEQ_NUM): Child table that may contain one record per invoice that contains credit card payment information.

BI_HDR_VAT (BUSINESS_UNIT, INVOICE): Child table that contains header VAT information for the bill.

BI_LINE (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM)

Parent table that contains one record for each bill line for a bill header.

BI_LINE_NOTE (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, NOTES_SEQ_NUM): Child table that contains one record for each note or comment for a bill line.

BI_LINE_DST (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM): Child table that contains one record for each distribution or accounting entry for a bill line.

BI_HDR_AR

May contain one record for each bill that contains receivables accounting information

BI_LINE_TAX

May contain one record for each line that contains sales and use tax.

BI_LINE_TAX_DTL

May contain one record for each sales and use tax authority for a bill line.

BI_LINE_DS_LVL

May contain one record for each discount or surcharge for a bill line.

BI_LINE_DS_DTL

May contain one record for each calculation of a discount or surcharge.

BI_LINE_EXS_DTL

May contain one record for each India excise tax, sales tax, and VAT calculation for a bill line.

BI_LINE_DST_AR (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each line that contains receivables accounting information.

BI_LINE_DST_UAR (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each line that contains unbilled-receivables accounting information.

BI_LINE_DST_DFR (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each deferred distribution or accounting entry for the line that contains receivables accounting information.

BI_LINE_DST_STA (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line statistical accounting distribution that is used to create the accounting entry for the line.

BI_LINE_IU_EXP (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line InterUnit expense distribution that is used to create the accounting entry for the line. This is only for InterUnit bills. However, InterUnit bill lines that take default accounting distribution information from the InterUnit Control Definitions table do not have this distribution line.

BI_LINE_IU_PAY (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line InterUnit payables distribution that is used to create the accounting entry for the line. This is only for InterUnit bills. However, InterUnit bill lines that take default accounting distribution information from the InterUnit Control table do not have this distribution line. Also, InterUnit bills that have PeopleSoft Payables generate vouchers have accounting entries generated from PeopleSoft Payables; therefore, these bills do not have an InterUnit payables distribution line.

BI_LINE_DS_LVL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, DISC_SUR_LVL)

Parent table that contains one record for each discount or surcharge level for a bill line.

BI_LINE_DS_DTL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, DISC_SUR_LVL, DISC_SUR_ID): Child table that contains one record for each discount or surcharge for a discount or surcharge level.

BI_LINE_ADJ_AUX (BUSINESS_UNIT, INVOICE, ADJ_AUX_LINE_SEQ)

Parent table that contains one record for every bill line adjustment that does not have a reference pointer to an original bill line.

BI_LINE_TAX (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM): Child table that contains one record for each bill line that has AVP or VERTEX tax fields.

BI_LINE_TAX_DTL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, TAX_AUTHORITY_CD): Child table that contains one record for each tax authority for a bill line.

BI_HDR_NOTE (BUSINESS_UNIT, INVOICE, NOTES_SEQ_NUM)

Contains one record for each note or comment for a bill header.

BI_BILL_CPY_HDR (BILL_CPY_GRP_ID)

Parent table that contains one record for each bill copy group.

BI_BILL_CPY_GRP (BILL_CPY_GRP_ID, SEQ_NUM): Child table that contains one record for each invoice copy template in a bill copy group.

BI_ACCUM_KEY (BAL_ACCUM_ID, BI_CURRENCY_CD, BASE_CURRENCY, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL, ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL, CURRENCY_CD_XEU)

Contains one record for each key value of each balance accumulation ID, bill currency, and base currency (for example, when accumulating by contract, one record for each contract value).

BI_ACCUM_TYPE (BAL_ACCUM_ID, BALANCE_TYPE, BI_CURRENCY_CD, BASE_CURRENCY, CURRENCY_CD_XEU, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL)

Contains from one to five records for each combination of accumulation key, accumulation ID, and currency combination. The five possible types include beginning, ceiling, invoiced, uninvoiced, and total.

BI_ACCUM_BAL (BAL_ACCUM_ID, BALANCE_TYPE, EFFDT, BI_CURRENCY_CD, BASE_CURRENCY, CURRENCY_CD_XEU, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL, ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL)

Contains one record for each accumulation type of each accumulation key and currency combination.

BI_HDR_EC (ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE)

Contains one record for each bill that has been invoiced with electronic data interchange.

BI_SCHEDULE (BUSINESS_UNIT, INVOICE, EVENT_OCCURENCE)

Contains one record for each scheduled event of a recurring invoice template.

BI_INSTALL_SCHE (BUSINESS_UNIT, INVOICE, EVENT_OCCURENCE)

Contains one record for each scheduled event of an installment invoice template.

BI_INSTALL_TRMS (BUSINESS_UNIT, INVOICE)

Contains one record for each installment bill plan and a schedule for an installment invoice template.

BI_HDR_ATTACH (BUSINESS_UNIT, INVOICE, SCM_ATTACH_ID)

May contain one or more records for linking supporting documentation to invoice headers.

BI_LINE_ATTACH (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, SCM_ATTACH_ID)

May contain one or more records for linking supporting documentation to invoice lines.

Click to jump to parent topicBilling Interface Tables

This section contains information about the Billing Interface tables, organized by the primary process that accesses each table:

Click to jump to top of pageClick to jump to parent topicBilling Interface Process

The Billing Interface process creates bills from the following tables:

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.

Click to jump to top of pageClick to jump to parent topicBilling Load AR Pending Items Process

The Load AR Pending Items process transfers data from the Billing tables to the following Receivables interface tables:

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.

Click to jump to top of pageClick to jump to parent topicBilling Load GL Accounting Entries Process

The Load GL Accounting Entries process transfers data from the following tables to the General Ledger interface

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.

Click to jump to top of pageClick to jump to parent topicRMA Adjustments Process

The RMA Adjustments process uses the data in the following table to process adjustments for returned materials entered in the Order Management application.

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.

Click to jump to top of pageClick to jump to parent topicBilling Generate AP Voucher Process

The Generate AP Voucher process transfers data from the following tables to the Accounts Payables interface

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.