Control 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.

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.

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.

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.

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.

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.