| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FAGL_011QT_XBRL | Fin. Statement Structure: Text for Fin. Statement Items | 5 | TXTYP | Text type | nvarchar | 1 | 0 | | |
2 | FAGL_GCDQT_VER | GCD Revision: Text of GCD table | 7 | TXTYP | Text type | nvarchar | 1 | 0 | | |
3 | FAGL_GCDQT_XBRL | GCD-Structure: Text of GCD table | 5 | TXTYP | Text type | nvarchar | 1 | 0 | | |
4 | P2RL_TAX | Payroll result: Tax (Malaysia) | 8 | TXTYP | Tax type for Malaysia | nvarchar | 4 | 0 | | |
5 | T011Q | Table no longer in use | 5 | TXTYP | Text type | nvarchar | 1 | 0 | | |
6 | T090W | Short Texts for Depreciation Trace | 2 | TXTYP | Text type for depreciation trace | nvarchar | 1 | 0 | | |
TOPAustralia |
7 | T5QTP | Payroll Tax and Workers Compensation | 3 | TXTYP | Tax Type | nvarchar | 2 | 0 | | |
TOPBasic Functions |
8 | T854T | Financial statement item texts | 3 | TXTYP | Text type for financial statement items | nvarchar | 1 | 0 | | |
9 | T855T | Reasons for inclusion in consolidation | 4 | TXTYP | Text type for reason for exclusion | nvarchar | 1 | 0 | | |
TOPCompany Pension Scheme Germany |
10 | T5DWT | Text Modules for Pension Calculation | 2 | TXTYP | Type of Text Module | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
11 | DFKKOPUSTAXOUT00 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
12 | DFKKOPUSTAXOUT01 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
13 | DFKKOPUSTAXOUT02 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
14 | DFKKOPUSTAXOUT03 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
15 | DFKKOPUSTAXOUT04 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
16 | DFKKOPUSTAXOUT05 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
17 | DFKKOPUSTAXOUT06 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
18 | DFKKOPUSTAXOUT07 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
19 | DFKKOPUSTAXOUT08 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
20 | DFKKOPUSTAXOUT09 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
21 | DFKKOPUSTAXOUT10 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
22 | DFKKOPUSTAXOUT11 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
23 | DFKKOPUSTAXOUT12 | Tax Details - Telecommunications Tax (U.S.A.) | 7 | TXTYP | Tax Type | nvarchar | 6 | 0 | | |
24 | TFK059BRTX | Assign Tax Calculation Method to Tax codes | 6 | TXTYP | Type of Tax | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
25 | FAGL_011QT | Fin. Statement Structure: Text for Fin. Statement Items | 5 | TXTYP | Text type | nvarchar | 1 | 0 | | |
TOPJapan |
26 | T5J86 | HR-J: Taxation Type Indicator JPN | 2 | TXTYP | Taxation type indicator | nvarchar | 1 | 0 | | |
27 | T5J87 | HR-J: Taxation type text | 3 | TXTYP | Taxation type indicator | nvarchar | 1 | 0 | | |
TOPMalaysia |
28 | PA0198 | Sheduled Tax Deductuion Malaysia | 24 | TXTYP | Tax subtype for Malaysia | nvarchar | 4 | 0 | | |
29 | PA0199 | Tax deduction CP38 / Additional amt / Bonus - Malaysia | 24 | TXTYP | Tax type for Malaysia | nvarchar | 4 | 0 | | |
30 | T5LTA | Additional tax table - Malaysia | 2 | TXTYP | Tax type for Malaysia | nvarchar | 4 | 0 | | |
31 | T5LTD | Additional tax - text table (Malaysia) | 3 | TXTYP | Tax type for Malaysia | nvarchar | 4 | 0 | | |
TOPPayroll |
32 | T5T1L | Bank accounts of authorities (tax,insurance) | 2 | TXTYP | Output options | nvarchar | 4 | 0 | | |
33 | T5T2G | Configuration of tax calculation CZ | 6 | TXTYP | Sequence Number | nvarchar | 2 | 0 | | |
34 | T5TPS1L | Bank accounts of authorities (tax,insurance) | 2 | TXTYP | Output options | nvarchar | 4 | 0 | | |
35 | T7SI1L | Bank accounts of authorities (tax,insurance) | 2 | TXTYP | Output options | nvarchar | 4 | 0 | | |
36 | T7SI2G | Configuration of tax calculation SI | 6 | TXTYP | Sequence Number | nvarchar | 2 | 0 | | |
37 | T7SIBT | Virman configuration (WT->Accounts) | 3 | TXTYP | Typ of external transfer area (WT group or wage type) | nvarchar | 4 | 0 | | |
38 | T7SK1L | Bank accounts of authorities (tax,insurance) | 2 | TXTYP | Output options | nvarchar | 4 | 0 | | |
39 | T7SK2G | Configuration of tax calculation SK | 6 | TXTYP | Sort sequence | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
40 | T799L2Y | Texts Retroactive Accounting Types | 5 | TXTYP | Text Field of Length 60 | nvarchar | 60 | 0 | | |