1C:Enterprise Platform data saving structure in the DBMS

Question: In which DBMS tables what kind of 1C:Enterprise data is actually stored? I need this information for data export to third party software, I plan the read data directly from the DBMS.

Answer: Below, widely used metadata objects are listed to which the specific tables may correspond. Please note that you must not try to change 1C:Enterprise Platform info base data by modifying the DBMS tables, this is prohibited. You should not try to read and process data directly form the DBMS either. Below data is provided for reference only.

Constants
- _Constscontains the current values of all constants defined in the configuration.
- _ConstsChangeRec- table to record the changes of constants. Created if at least one constant participates at least in one exchange plan.

Exchange plans
- _Node<n>- table of exchange plan.
- _Node<n>_VT<k>- tabular section of exchange plan, created for each tabular section.

Catalogs
- _Reference<n>- catalog table.
- _Reference<n>_VT<k>- tabular section of catalog - for each tabular section.
- _ReferenceChangeRec<n>- table to record the catalog changes. Created it catalog participates at least in one exchange plan.

Documents
- _Document<n>- table of documents for each metadata object “document”.
- _Document<n>_VT<k>- tabular section of document - for each tabular section of each document.
- _DocumentChangeRec<n>- table to record the changes of metadata object with type “document”. Created for each metadata object with type “document”, if it participates at least in one exchange plan.

Document sequences
- _Sequence<n>- table of document registration - for each sequence.
- _SequenceBoundary<n>- table of sequence bounds - for each sequence.
- _SequenceChangeRec<n>- table to record the sequence changes. Created for each sequence which participates at least in one exchange plan.

Document journals.
- _DocumentJournal<n>- table of document journal, created for each document journal.

Enumerations
- _Enum<n>- enumeration table - one for each enumeration.

Charts of characteristic types
- _Chrc<n>- basic table of the chart of characteristic types.
- _Chrc<n>_VT<k>- tabular section of the chart of characteristic types - for each tabular section.
- _ChrcChangeRec<n>- table to record the changes of the chart of characteristic types. Created if the chart of characteristic types participates at least in one exchange plan.

Chart of accounts
- _Acc<n>- basic table of the chart of accounts.
- _Acc<n>_ExtDim<k>- table of subcount types of the chart of accounts, created for the chart of accounts in case if the maximal number of subcount is more than zero.
- _Acc<n>_VT<k>- tabular section of the chart of accounts, created for each tabular section of the chart of accounts.
- _AccChangeRec<n>- table to record the changes of the chart of accounts. Created if the chart of accounts participates at least in one exchange plan.

Chart of calculation types
- _CalcKind<n>- basic table of the chart of calculation types.
- _CalcKind<n>_BaseCK- table of the basic calculation types, created for the chart of calculation types if it property “Dependence from base” has the value different from “Doesn’t depend”.
- _CalcKind<n>_DisplacedCK- table of displaced calculation types, created for the chart of calculation types in case if it has an enabled flag “Uses validity period”.
- _CalcKind<n>_LeadingCK- table of leading calculation types - for each chart of calculation types.
- _CalcKindDN<n>- auxiliary table for displacement order, created if the chart of calculation types has an enabled flag “Uses validity period”.
- _CalcKind<n>_VT<k>- tabular section of the chart of calculation types, created for each tabular section.
- _CalcKindChangeRec<n>- table to record the changes of the chart of calculation types. Created if the chart of calculation types participates at least in one exchange plan.

Information registers
- _InfoReg<n>- table of the information register records.
- _InfoRegChangeRec<n>- table to record the changes of information register. Created if the information register participates at least in one exchange plan.

Accumulation registers
- _AccumReg<n>- table of accumulation register records.
- _AccumRegTotals<n>- table of accumulation register totals, if the register supports the remains.
- _AccumRegTurnovers<n>- table of accumulation register turnovers, if the register supports the turnovers.
- _AccumRegChangeRec<n>- table to record the accumulation register changes. Created it the accumulation register participates at least in one exchange plan.
- _AccumRegOptions- table of options for storing the totals of accumulation registers, one for all accumulation registers.

Accounting registers
- _AccntReg<n>- table of accounting register records.
- _AccntRegED<n>- table of subcount values of accounting register, created if it refers to the chart of accounts whose maximal number of subcount is more than zero.
- _AccTtl0<n>- table of totals on the account.
- _AccTtl<i><n>- where i is from 1 to maximal number of subcount. Table of totals on the account with the number of subcount types equal to i.
- _AccTtlC<n>- table of totals of the turnovers between the accounts, only for accounting register which supports the correspondence.
- _AccntRegChangeRec<n>- table to register the accounting register changes. Created if the accounting register participates at least in one exchange plan.
- _AccntRegOptions- table of options to store the totals, one for all accounting registers.

Calculation registers
- _CalcReg<n>- table of calculation register records.
- _CalcRegActPer<n>- table of actual validity periods for calculation register, created if the calculation register has an enabled flag “Validity period”.
- _CalcRegChangeRec<n>- table to record the changes of calculation register. Created for each calculation register that participates at least in one exchange plan.
- _CalcRegRecalc<n>- recalculation table of calculation register, created for each recalculation.
- _CalcRegRecalcChangeRec<n>- table to record the recalculation changes. Created if recalculation participates at least in one exchange plan.

Business processes
- _BPRoutePoint<n>- table of business process rout points for each business process.
- _BusinessProcess<n>- basic table of business process.
- _BusinessProcess<n>_VT<k>- tabular section of business process for each tabular section.
- _BusinessProcessChangeRec<n>- table to record the changes of business process. Created for each business process which participates at least in one exchange plan.

Tasks
- _Task<n>- basic table of task.
- _Task<n>_VT<k>- tabular section of task for each tabular section.
- _TaskChangeRec<n>- table to record the changes in the tasks. Created for each metadata object with type “task” which participates at least in one exchange plan.

If configuration defines at least on exchange plan with enabled flag “Distributed database”, then the following tables will be created:

_ConfigChangeRec- table to record the changes of configuration objects.
_ConfigChangeRec_ExtProps- table for the names of files of the changed external properties of configuration objects.

*Please note that if the IBM DB2 DBMS is used, the prefixes start without the underline