ChartField Tables

This section contains information about ChartField tables:

Field or Control Description

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.