| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIKZ_FILE_TBL | Files for invoice journal record | 9 | VERS | XML format version | nvarchar | 7 | 0 | | |
2 | J_1UFDI_FILE_TBL | Files for tax document register record | 9 | VERS | XML format version | nvarchar | 8 | 0 | | |
3 | J_3RFDI_ARC | Table for archiving and logging digital invoices | 15 | VERS | XML format version | nvarchar | 7 | 0 | | |
4 | J_3RF_RGTORG_IFS | Index Electronic Documents File Storage | 12 | VERS | XML format version | nvarchar | 7 | 0 | | |
5 | T5C55 | Conversion Denomination Key | 3 | VERS | Version | nvarchar | 4 | 0 | | |
6 | T5TPENSAV | Data for pension savings | 14 | VERS | Version | nvarchar | 2 | 0 | | |
7 | T5TPENSAV_YS | Pension savings - annual reporting | 14 | VERS | Version | nvarchar | 2 | 0 | | |
8 | T5TS0 | Central storage of XML documents | 3 | VERS | Version | nvarchar | 2 | 0 | | |
9 | T5VF1 | Altinn Communication Framework - Document storage | 3 | VERS | ACF - Version | nvarchar | 2 | 0 | | |
TOPAustria |
10 | T5AB0 | Sick Leave Certificate: ELDA Opening and Closing Record | 16 | VERS | ELDA: External Version Number | nvarchar | 2 | 0 | | |
TOPB2A Business to Administration |
11 | T50C_XML | XML-Convesion routines | 6 | VERS | XML-Schema version | nvarchar | 4 | 0 | | |
12 | T50G_XML | XML-Global Schema | 6 | VERS | XML-Schema version | nvarchar | 4 | 0 | | |
13 | T50V_XML | XML-Versions | 8 | VERS | XML-Schema version | nvarchar | 4 | 0 | | |
TOPBank |
14 | BNKA | Bank master record | 19 | VERS | Format of File with Bank Data | nvarchar | 3 | 0 | | |
15 | T005BU | Table for Transferring Bank Data | 2 | VERS | Format of File with Bank Data | nvarchar | 3 | 0 | | |
16 | T005BUT | Table for Transferring Bank Data | 3 | VERS | Format of File with Bank Data | nvarchar | 3 | 0 | | |
TOPConsolidation |
17 | TFIN000 | Independent Characteristic Values for Consolidation Type | 5 | VERS | Consolidation (end-result) version | nvarchar | 3 | 0 | | |
18 | TFIN005 | Ledger Selection | 2 | VERS | Consolidation (end-result) version | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DFKKPTSAFTDEF | Obsolete! DO NOT USE | 1 | VERS | Portugal: SAF-T Version | nvarchar | 10 | 0 | | |
TOPFlexible Real Estate Management |
20 | TIVHOHBKIDIR | WEG-Verwaltung Instandhaltungsrücklage Kontenvorschlag | 4 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
21 | TIVHOIR | Mandatsverw.: Instandhaltungsrücklage Konten/Vorschlagsw | 4 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
22 | TIVPRHSB | Zuordnung Gitterpositionen zu Bewegungen | 2 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
23 | TIVPRHSP | Gitterpositionen | 2 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
24 | TIVPRHSPT | Gitterpositionstexte | 3 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
25 | TIVPRHSV | Gitterversionen | 2 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
26 | TIVPRHSVT | Gitterpositionstexte | 3 | VERS | Gitterversion Instandhaltungsrücklagen und Geldanlagen WEG | nvarchar | 2 | 0 | | |
TOPIntegration Engine |
27 | SXMSCLUP | XMB: Property Cluster | 5 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
28 | SXMSCLUP2 | XMB: Property Cluster (Switch Table) | 5 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
29 | SXMSCLUR | XMB: Resources Cluster | 5 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
30 | SXMSCLUR2 | XMB: Resources Cluster (Switch Table) | 5 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
31 | SXMSPMAST | Integration Engine: Message Queue (Master) | 37 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
32 | SXMSPMAST2 | XML Message Broker: Message Queue (Master) (Switch Table) | 37 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
33 | SXMSPVERS | Integration Engine: Message Version | 4 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
34 | SXMSPVERS2 | Integration Engine: Message Version (Switch Table) | 4 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
TOPLoans Management |
35 | VDDD_HEADER | Loans: Header Data - Lines Layout | 2 | VERS | Layout Version | nvarchar | 1 | 0 | | |
36 | VDDD_HEADER_COL | Loans: Header Data - Columns Layout | 2 | VERS | Layout Version | nvarchar | 1 | 0 | | |
37 | VDDD_HEADER_VER | Loans: Header Data - Version Layout | 2 | VERS | Layout Version | nvarchar | 1 | 0 | | |
TOPMaintenance Notifications |
38 | TQ80 | Notification Types | 68 | VERS | Variants for Determining Existence of Notifications | nvarchar | 1 | 0 | | |
TOPMapping |
39 | SMPPBIND | Mapping Parameterization: Binding | 5 | VERS | XI Runtime: GUID | varbinary | 16 | 0 | | |
40 | SMPPCONT | Test for Mapping Parameterization | 8 | VERS | XI Runtime: GUID | varbinary | 16 | 0 | | |
41 | SMPPSTEP | Mapping Runtime: Mapping Step | 7 | VERS | XI Runtime: GUID | varbinary | 16 | 0 | | |
TOPNorway |
42 | PA0173 | Tax card information | 43 | VERS | Tax Card version | nvarchar | 1 | 0 | | |
TOPPayroll |
43 | T5HVC | Érvényes nyomtatványkódok (havi bevallás) | 7 | VERS | Havi bevallás 2 - XML verziója | nvarchar | 16 | 0 | | |
TOPPayroll General Parts |
44 | T50FD | HR: Time Dependency of Message Type Versions | 7 | VERS | HR: Version of Notification Type | nvarchar | 2 | 0 | | |
45 | T50FE | HR: Mapping Internal and External Structure | 5 | VERS | HR: Version of Notification Type | nvarchar | 2 | 0 | | |
TOPPerformance Assessment Workbench |
46 | SLS_ITEM | PAW - Item Description | 13 | VERS | PAW test version | nvarchar | 10 | 0 | | |
47 | SLS_PU | PAW - Performance Unit | 13 | VERS | PAW test version | nvarchar | 10 | 0 | | |
TOPRuntime WorkbenchMonitoring |
48 | SXMSMSGINDLOG | SAP XI: Indexing Log of Messages | 4 | VERS | Sequence Number for a Message Log ID | nvarchar | 3 | 0 | | |
TOPSwitzerland |
49 | T5C50 | Uniform Wage Notification Procedure: Control Data Extraction | 2 | VERS | Version | nvarchar | 4 | 0 | | |
50 | T5C53 | Conversion Table Marital Status | 3 | VERS | Version | nvarchar | 4 | 0 | | |
51 | T5C54 | Conversion Table Residence Status | 3 | VERS | Version | nvarchar | 4 | 0 | | |