| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /XFT/EPA_T0000 | Basic Settings | 4 | RMS_ID | RMS in which the personnel files are stored | nvarchar | 32 | 0 | | |
2 | /XFT/EPA_T0012 | Checklists | 4 | RMS_ID | RMS in which the personnel files are stored | nvarchar | 32 | 0 | | |
3 | /XFT/QMPPAPTCM00 | Master Customizing: Sampling | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
4 | /XFT/SRMDOCTC00 | Area for Template Management | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
5 | /XFT/SRMPSC000 | Customizing: Basic Settings | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
6 | /XFT/SRM_DEMOC0 | Customizing: General | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
7 | /XFT/SRM_DEMOC09 | Customizing: Basic Settings | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
8 | /XFT/SRM_RECU10 | User settings (RMS-dependent) | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
9 | /XFT/SSMMESSC00 | SSM: Meldungstyp | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
10 | SRMSPSBO | Relationship between Business Object ,SPS ID and RMS ID | 4 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
TOPCase Management |
11 | SCMGCASETYPE | Case: Case Type | 9 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
TOPCross-Application Components |
12 | /IXOS/RM_TCOLD | Customizing settings for batch import in the RM | 3 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
13 | /IXOS/RM_TDL1 | Livelink DesktopLink Customizing for Records Management (1) | 2 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
14 | /IXOS/RM_TDL2 | Livelink DesktopLink Customizing for Records Management (2) | 2 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
15 | /IXOS/RM_TPROT | Log table | 10 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
TOPRecords and Case Management |
16 | RMPSC_TRF_ENTITY | DoD: Transfer - export/import configuration - entities | 5 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
17 | RMPSE_SOA_DOC | Define Document Types for Services | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
18 | RMPSE_SOA_REC | Define Record Types for Services | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
19 | RMPSI_TRF_TPL_EN | DoD: Transfer - exp./imp. config - template entities | 5 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
20 | RMPS_A2RM_RM | BOR -> RMS/SPS | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
21 | RMPS_AI_SCEN | Scenario Definitions | 4 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
22 | RMPS_DISELEMS | Retention Elements (Data Record Descriptions) | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
23 | RMPS_DISPORTION | Disposal Portion | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
24 | RMPS_DISPOSALTY | Type of RMS-ID (disposal, fileplan, ...) | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
25 | RMPS_DISUNIT | Retention Unit, Record Segment | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
26 | RMPS_MENU_CUST | Menu and Toolbar Text Customization | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
27 | RMPS_MENU_CUSTT | Menu and Toolbar Text Customization Text Table | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
28 | RMPS_OI_SCENARIO | Scenarios for Upload | 4 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
29 | RMPS_RETDURPW | Residence Time of Storage Items in Years | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
30 | RMPS_STORDUR | Storage Catalog | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
31 | RMPS_STORDURT | Storage Catalog: Description | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
32 | RMPS_TOOLBAR | Toolbar Customizing Table | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
33 | RMPS_TOOLBART | Toolbar Customizing Text Table | 3 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
TOPSAP Records Management |
34 | RCM_ORG_OPENMODE | RCM Organizer: Configuration of Open Mode: Change, Display | 2 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
35 | RCM_ORG_QACT_PR | RCM Organizer: Quick Action: Profiles | 4 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
36 | SRMAISCN | Integration Scenario | 4 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
37 | SRMDOCSPSPS | Table for Assignment SPS-ID to ALINK Docspace | 4 | RMS_ID | RMS ID | nvarchar | 32 | 0 | | |
38 | SRMDPDISP | Circular | 9 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
39 | SRMORGREC | SRM Records Organizer : Recently Used Object Names | 4 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
40 | SRMRGCONTK | Context Counter: Element Keys | 3 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
41 | SRMRGOBJEC | Results of Program Runs in Record Character Generation | 3 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
42 | SRMRGRESER | Reservation | 2 | RMS_ID | RMS ID in SRM | nvarchar | 32 | 0 | | |
43 | SRM_ECM_CSO | Client Supplied Owners of Document Locks | 3 | RMS_ID | Key of RMS ID | nvarchar | 2 | 0 | | |
44 | SRM_ECM_HASH | HashValues of SRM/ECM optimistic locking (value comparision) | 3 | RMS_ID | Key of RMS ID | nvarchar | 2 | 0 | | |
45 | SRM_ECM_NNT | Lookup table for RM node names in ECM integration | 3 | RMS_ID | Key of RMS ID | nvarchar | 2 | 0 | | |
46 | SRM_ECM_NNT_RMS | Key of Records Management System ID | 2 | RMS_ID | Key of RMS ID | nvarchar | 2 | 0 | | |
47 | SRM_ECM_RNT | Lookup table for RM node names in ECM integration | 3 | RMS_ID | Key of RMS ID | nvarchar | 2 | 0 | | |