Bill Structure Tables

This section contains information about bill structure tables:

Field or Control Description

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.