| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DMC_IU_T000 | MWB: Backup Copy of Table T000 | 2 | MTEXT | Client name | nvarchar | 25 | 0 | | |
2 | DRP_SMTC_TYPET | DEV Reporting (SE28): Metric List (Text) | 4 | MTEXT | DEV Reporting (SE28): Unit of Metric | nvarchar | 10 | 0 | | |
3 | OA2_SD_CLT | OAuth2 Client Texts | 4 | MTEXT | OAuth 2.0 Client Description | nvarchar | 40 | 0 | | |
4 | P2RG_CARCO2 | Payroll Results: GB Company Cars (CO2 based calculation) | 14 | MTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
5 | T059T | Texts for Minority Indicators | 4 | MTEXT | Text | nvarchar | 30 | 0 | | |
6 | T7RU_STAT_VFLD_T | Names of View Variant Fields | 10 | MTEXT | Medium Field Label | nvarchar | 20 | 0 | | |
7 | ZLANGIE | Clients in IDES | 3 | MTEXT | Client name | nvarchar | 25 | 0 | | |
8 | ZSK_T000 | t000 | 3 | MTEXT | Bezeichnung des Mandanten | nvarchar | 25 | 0 | | |
TOPAssortment Maintenance |
9 | TMETT | Description for unit of measure categories | 4 | MTEXT | Description | nvarchar | 20 | 0 | | |
TOPBasic Data |
10 | TN16T | IS-H: Type of Insurance Coverage - Text Table | 5 | MTEXT | IS-H: Text for Type of Coverage | nvarchar | 20 | 0 | | |
TOPBasic Settings |
11 | T8APP_HRKFTT | Texts for values of field HRFKT in profit center planning | 6 | MTEXT | Medium Field Label | nvarchar | 20 | 0 | | |
TOPClient Copy |
12 | CCC_CHECK | Client dummy | 6 | MTEXT | Client name | nvarchar | 25 | 0 | | |
13 | T000 | Clients | 2 | MTEXT | Client name | nvarchar | 25 | 0 | | |
TOPCollectionsDisbursements |
14 | TKKVAKTIV | Activities and/or Notes for the Clerk | 4 | MTEXT | Mail Text | nvarchar | 80 | 0 | | |
15 | VVKKDRKO | Dunning Printout:Header Items | 15 | MTEXT | Name of Dunning Level | nvarchar | 50 | 0 | | |
TOPContract Accounts Receivable and Payable |
16 | TFK047AT | Dunning procedure texts | 4 | MTEXT | Dunning procedure text | nvarchar | 50 | 0 | | |
17 | TFK047BT | Dunning level texts | 5 | MTEXT | Name of Dunning Level | nvarchar | 50 | 0 | | |
18 | TFK047FT | Dunning grouping texts | 4 | MTEXT | Name of Dunning Grouping | nvarchar | 50 | 0 | | |
19 | TFKBA_GRIDT | Description of Balances Grid | 5 | MTEXT | Medium Field Label | nvarchar | 20 | 0 | | |
TOPCost Object |
20 | TKKAF | Text Table for Results Analysis Methods | 3 | MTEXT | Designation of Results Analysis Method | nvarchar | 80 | 0 | | |
TOPFinland |
21 | T7FIAWT_TM | Main groups for annual working time report | 4 | MTEXT | Main group texts for annual working time report | nvarchar | 80 | 0 | | |
TOPFunds Management |
22 | TBUDVGT | IS-PS Budget Types: Texts | 4 | MTEXT | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPInformation System |
23 | TCNET | Texts: Object Table for Reporting Structures in PS System | 4 | MTEXT | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPLease Accounting |
24 | TFILA_GF_000MT | Method Texts | 3 | MTEXT | Method Description | nvarchar | 74 | 0 | | |
TOPOrganizational Management |
25 | T77MT | Cross-Module Texts | 4 | MTEXT | Module Pool-Independent Text | nvarchar | 50 | 0 | | |
TOPPayroll |
26 | T5H1ZT | K32 urlap: magánpénztári tagság értékeinek szövegei | 3 | MTEXT | magánnyugdíjpénztári tag-e: szövegek | nvarchar | 40 | 0 | | |
27 | T7UA_STAT_VFLD_T | Names of View Variant Fields | 10 | MTEXT | Medium Field Label | nvarchar | 20 | 0 | | |
TOPPension fund General Parts |
28 | T5CA7 | PC Method Type Names | 6 | MTEXT | HR-CH: PC method type name | nvarchar | 15 | 0 | | |
TOPPersonnel Administration |
29 | T513F | Appraisal Criteria Texts | 4 | MTEXT | Text for Appraisal Criterion | nvarchar | 25 | 0 | | |
30 | T51C4 | Car model text table | 5 | MTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
31 | T7CO26 | Employee grouping for calculation types | 3 | MTEXT | Employee type description | nvarchar | 40 | 0 | | |
TOPProcess Management |
32 | CMX_XSR_DB_FOLD | Standard Execution Step Repository: Folder | 8 | MTEXT | XSteps: Text of Medium Length | nvarchar | 255 | 0 | | |
33 | CMX_XSR_DB_FOLDT | Standard Execution Step Repository: Texts for Folder | 5 | MTEXT | XSteps: Text of Medium Length | nvarchar | 255 | 0 | | |
34 | CMX_XSR_DB_ITEM | Standard Execution Step Repository: Items | 8 | MTEXT | XSteps: Text of Medium Length | nvarchar | 255 | 0 | | |
35 | CMX_XSR_DB_ITEMT | Standard Execution Step Repository: Texts for Items | 5 | MTEXT | XSteps: Text of Medium Length | nvarchar | 255 | 0 | | |
TOPPublic Sector |
36 | T5D5D | Supplementary Pension Public Sector: Notification Fields | 7 | MTEXT | Description of Notification Field | nvarchar | 38 | 0 | | |
TOPSales Plan |
37 | T445G | Texts of LIS Planning Macros | 4 | MTEXT | Macro Description | nvarchar | 40 | 0 | | |
TOPSAP Business Workflow |
38 | TOJMT | Objects in the SAP System: method descriptions | 3 | MTEXT | Objects in SAP System: method name | nvarchar | 20 | 0 | | |
TOPService Data Download |
39 | /SDF/CMO_T_53 | CMO Service: Clients of DEV system | 2 | MTEXT | | nvarchar | 25 | 0 | | |
40 | /SDF/CMO_T_54 | CMO Service: Clients of QAS system | 2 | MTEXT | | nvarchar | 25 | 0 | | |
41 | /SDF/SWCM_T000_P | Clients of PRD | 2 | MTEXT | | nvarchar | 25 | 0 | | |
TOPTraders and Schedulers Workbench |
42 | OIJIMEXT | OIL-TSW: Flag for importer/exporter or others texts | 5 | MTEXT | Medium Text | nvarchar | 25 | 0 | | |
43 | OIJRRTT | OIL-TSW: Partner role type texts | 5 | MTEXT | Medium Text | nvarchar | 25 | 0 | | |
44 | OIJ_SPTYPEST | Stock Projection Type Texts | 4 | MTEXT | Descriptive text of medium length (30) | nvarchar | 30 | 0 | | |
45 | OIJ_TIMEBUCKETST | OIL-TSW : Time Bucket Text | 4 | MTEXT | Character field length 20 with upper/lower case | nvarchar | 20 | 0 | | |
TOPUser and Authorization Management |
46 | TUL_CLIENTS | System Measurement: Client Handling | 3 | MTEXT | Client name | nvarchar | 25 | 0 | | |