| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/BT_ACTIV | Activate Configurations of the Business Transactions | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
2 | /EACC/BT_CNF_A | All Configurations by the Business Transactions | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
3 | /EACC/CONF_DELEG | Delegation of Line Item Processing | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
4 | /EACC/DERIVCHARS | Target Characteristics in Derivation Steps | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
5 | /EACC/DERIV_COND | Conditions for Derivation Steps | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
6 | /EACC/DERIV_EXIT | Methods for Derviation Exits | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
7 | /EACC/JOURNALS | Journals in E-Accounting | 3 | JOURNAL | Journals in the ACC Document | nvarchar | 8 | 0 | | |
8 | /EACC/JRNL_ACTIV | Active Journal Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
9 | /EACC/JRNL_CNF_A | All Journal Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
10 | /EACC/JRNL_CURTP | All Journal Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
11 | /EACC/JRNL_DERIV | Derivation Configuration for the Journal | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
12 | /EACC/JRNL_QNTTP | All Journal Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
13 | /EACC/JRNL_TOTLS | Journal Totals | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
14 | /EACC/LASTPSTDAT | Lest Posting Date Posted to | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
15 | /EACC/TOT_DELEG | Delegation of Totals Administration | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
16 | /EACC/VIEWDCHARS | Source Characteristics in Derivation Steps | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
17 | /EACC/VIEW_ACTIV | Active View Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
18 | /EACC/VIEW_CNF_A | All View Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
19 | /EACC/VIEW_CURTP | All View Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
20 | /EACC/VIEW_DERIV | Derivation Configuration Requirements in a View | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
21 | /EACC/VIEW_QNTTP | Quantity Types | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
22 | /EACC/VIEW_TOT_A | All View Configurations | 3 | JOURNAL | Home Class of an Accounting Component | nvarchar | 30 | 0 | | |
23 | /EACC/V_COND | Derivation Steps Condition | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
24 | /EACC/V_CUR | Currency Types | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
25 | /EACC/V_CUR_SUB | Names of Views for Currency Types | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
26 | /EACC/V_DERIV | Derivation Steps | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
27 | /EACC/V_DER_NAME | Derivation Steps - Name | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
28 | /EACC/V_JOURN_C | Journals | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
29 | /EACC/V_JOURN_N | Journals | 4 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
30 | /EACC/V_QUANT_N | Quantity Types | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
31 | /EACC/V_QUANT_T | Quantity Types | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
32 | /EACC/V_TABLES_I | Journal Tables - Indexes | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
33 | /EACC/V_TABLES_J | Journal Tables | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
34 | /EACC/V_TABLES_T | Journal Tables - Tables | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
35 | /EACC/V_TAB_I_I | Journal Tables - Indexes - Index | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
36 | /EACC/V_TOTALS_F | Journal Totals - Field List | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
37 | /EACC/V_TOTALS_I | Journal Totals - Database Indexes | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
38 | /EACC/V_TOTALS_J | Journal Totals | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
39 | /EACC/V_TOTALS_T | Journal Totals - Texts | 4 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
40 | /EACC/V_TOTAL_II | Journal Totals - Database Indexes - Index | 3 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
41 | /EACC/V_TOTAL_IT | Journal Totals - Database Indexes - Texts | 4 | JOURNAL | Journal | nvarchar | 8 | 0 | | |
TOPGeneral Ledger |
42 | /EACA/TGLBWINFO | Information for BW Objects | 3 | JOURNAL | Name of the Journal | nvarchar | 8 | 0 | | |