General Tables

This section contains information about general data tables:

Field or Control	Description
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.