| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BST_MDG_CC | Cleansing Case Change Requests | 2 | CASE_GUID | Data Cleansing Case: Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | GRFNCASEIS | Case table of Issue | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
3 | GRRMANALYSIS_TS | Analysis Table | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
4 | GRRMANASSMNT | Assessment Table | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
5 | GRRMANDATA | Analysis Data | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
6 | GRRMPROPRESPONSE | Table for Response Proposal | 2 | CASE_GUID | Response Proposal - GUID | nvarchar | 32 | 0 | | |
7 | ZCASE_ADD_ATTR | Zusätzliche Case-Attribute | 2 | CASE_GUID | Technischer Schlüssel des Falles (Fall-GUID) | nvarchar | 32 | 0 | | |
8 | ZPHDEMO_ATTRTAB2 | Case Attributes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
9 | FDM_BUFFER | Cluster for Decoupling in 1-System Scenario | 3 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
10 | FDM_CDISCONFLICT | FSCM-DM: Conflicts in Automatic Assignment of Items to Cases | 2 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
11 | FDM_CDISPROPOSAL | FSCM-DM: Proposal for Assignment of OIs to Cust.-Init. Disp. | 7 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
12 | FDM_COLL_TROBJ | FSCM-COL: Trigger Table for Collections Management | 7 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
13 | FDM_LDDB | FSCM-DM: Log And Delay Database | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
14 | FDM_P2P_ATTR | Attributes of Promise to Pay; Required for Process Integratn | 2 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
15 | FDM_P2P_INSTMNT | Installments in Promise to Pay with Installment | 2 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
TOPBasic Functions |
16 | BIW_EMMA_CASE | Delta Queue for Process Statistics for Clarification Cases | 3 | CASE_GUID | GUID of Clarification Case | varbinary | 16 | 0 | | |
17 | EMMA_CASE | Clarification Case | 3 | CASE_GUID | GUID of Clarification Case | varbinary | 16 | 0 | | |
18 | UDMCASEATTR00 | Dispute Case Attributes | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
19 | UDMCASEATTR10 | Dispute Case Attribute for Account Balance (FI-CA) | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
20 | UDMCASEATTR20 | Collection Case Attributes | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
21 | UDM_P2P_ATTR | Promise to Pay | 2 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
22 | UDM_T_CORRCONT | FSCM-DM: Container (Dialog Correspondence) | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
23 | UKMCASEATTR00 | Attribute of Credit Case | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
24 | UKM_DCD_ATTR | Attributes of a Documented Credit Decision | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
TOPCase Management |
25 | SCMG_T_CASE | Case: Entity Table for Case | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
26 | SCMG_T_CASE_ATTR | Case Attributes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPCollections Management |
27 | UDM_COLL_ITEMCAS | Open Items with Dispute Case | 5 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | | |
TOPContract Accounts Receivable and Payable |
28 | DFKKCASEITEMS | Item List in Cases, Lines | 2 | CASE_GUID | GUID for Item List | nvarchar | 32 | 0 | | |
29 | DFKKCASEITEMSH | Item List in Cases, Header Data | 2 | CASE_GUID | GUID for Item List | nvarchar | 32 | 0 | | |
30 | DFKKCCUPDATE | Item Lists to Which Changes Were Made | 2 | CASE_GUID | GUID for Item List | nvarchar | 32 | 0 | | |
TOPEmployee Interaction Center |
31 | THREIC_ACTIVITY | EIC Activity | 2 | CASE_GUID | EIC: GUID | nvarchar | 32 | 0 | | |
32 | THREIC_KS_ATTR | Specific Attributes for Knowledge Search in EIC | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
33 | THREIC_PER_ALRTS | EIC: Personal Alerts | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
34 | THREIC_SLA_ALRT | Activities Selected by SLA Alert Program | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
35 | THREIC_SLA_ALRTS | Activities Selected by SLA Alert Program | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPEngineering Change Record |
36 | /PLMI/ECR_HDR | Engineering Change Record Header data | 2 | CASE_GUID | Engineering Record GUID (Technical Key) | nvarchar | 32 | 0 | | |
TOPGlobal Trade Services |
37 | /SAPSLL/CMLBP | Case Management Audit Business Partners | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
38 | /SAPSLL/CMLCD | Case Management Audit Customs Document | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
39 | /SAPSLL/CMLPR | Case Management Audit Customs Product | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
40 | /SAPSLL/CMPAR | Attributes of a Case for Case Management Integration | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPGrantor Management |
41 | CRMD_GRM_CASE | Case Relation | 3 | CASE_GUID | | nvarchar | 32 | 0 | | |
TOPGRC Risk Management |
42 | GRRMANALASSMNT | Assessment Table | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
43 | GRRMANALYSIS | Analysis Table | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
44 | GRRMANALYSISDATA | Analysis Data | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
45 | GRRMPROPOSERISK | Propose risk | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
46 | GRRMRESPONSE | Table for Response | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
47 | GRRMVALIDATION | Analysis Table | 2 | CASE_GUID | Case GUID | nvarchar | 32 | 0 | | |
TOPHR Administrative Services |
48 | T5ASRARCHINDEX | ASR: Archiving Index Table | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
49 | T5ASRCONTCASELNK | Assignment of Data Container to Case | 2 | CASE_GUID | Key for Process, Scenario, or Process Step | nvarchar | 32 | 0 | | |
50 | T5ASRDOCCASELNK | Assignment of Attachments to Case | 5 | CASE_GUID | Key for Process, Scenario, or Process Step | nvarchar | 32 | 0 | | |
51 | T5ASRPROCESSES | HR Administrative Services: Processes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
52 | T5ASRSCENARIOS | HR Administrative Services: Scenarios | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
53 | T5ASRSTEPS | HR Administrative Services: Process Steps (Work Items) | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
54 | T5SSCXSSSERVICES | XSS Self-Service Instances | 2 | CASE_GUID | Key for Self-Service | nvarchar | 32 | 0 | | |
TOPInternal Collection Procedure |
55 | UHCCASEATTR20 | Collection Case Attributes | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
56 | UHC_CASE_ALIST | Actions in Collection Case | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
TOPLegal Case Management for ILM |
57 | LHM_CASE_ATTR | Table with Additional Attributes for Legal Hold Cases | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
58 | LHM_LEGAL_HOLDS | OBSOLETE | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
59 | LHM_LH_ARCHIVED | Legal Holds in Archive Files | 5 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
60 | LHM_PROPAGATE | Stores Legal Holds for Archive Files | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
61 | SLCM_COMMENTS | ILM: Legal Case Management - Comments | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
62 | SLCM_EDIS_RUN | ILM: Legal Case Management- Executed E-Discovery Reports | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
63 | SLCM_HIS_AL_DEL | ILM: Legal Case Management - History Deleted AL Docs | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
64 | SLCM_HIS_BOR_DEL | ILM: Legal Case Management - History Deleted BOR Objects | 4 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
65 | SLCM_LH_AL | ILM: Legal Case Management - Legal Hold Table for AL Doc. | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
66 | SLCM_LH_BOR | ILM: Legal Case Management - Legal Hold Table for BOR Obj. | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
67 | SLHM_CASE_HEAD | Legal Hold Management - Cases (Header Data) | 2 | CASE_GUID | Legal Case ID | nvarchar | 32 | 0 | | |
TOPManagement of Internal Controls |
68 | FOPCCASEAS | Assessment | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
69 | FOPCCASECLONE | Case Copy Information | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
70 | FOPCCASEIS | Issue | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
71 | FOPCCASEPL | Remediation Plan | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
72 | FOPCCASETE | Attributes: Testing | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
73 | FOPCCASETL | Test log | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
74 | FOPCCASEUPGRADE | MIC Case: Information of Upgrade | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
75 | FOPCDEFICANA | MIC: Deficiency Analysis | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
76 | FOPCRPLCINFO2 | Replacement Information: Case | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPOrganizational Flexibility |
77 | /ISDFPS/ORGM | Organizational Measure Attributes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
78 | /ISDFPS/ORGMAREA | Measure Area Attributes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPPayment Transactions |
79 | FPCL_DETECT_CO | Garnishments for a Payment Document | 6 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
80 | FPCR_CESS | Garnishment Register Attributes | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
81 | FPCR_LINK_OBJ | Linked Objects for Garnishment | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
82 | FPCR_REDUCTION | Reduction Data for Garnishment | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPPersonnel Administration |
83 | PA3246 | HR Master Record for Infotype 3246 (Legal Hold) | 25 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPProcess Controls |
84 | GRPCCASEAS | Assessment | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
85 | GRPCCASECLONE | Case Copy Information | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
86 | GRPCCASECP | CAPA Plan | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
87 | GRPCCASEIS | Issue | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
88 | GRPCCASEPL | Remediation Plan | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
89 | GRPCCASETE | Attributes: Testing | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
90 | GRPCCASETL | Test log | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
91 | GRPCCASEUPGRADE | Obsolete : PC Case: Information of Upgrade | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
92 | GRPCDEFICANA | PC: Deficiency Analysis | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
93 | GRPCRPLCINFO2 | Replacement Information: Case | 3 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
94 | DFMCA_FORMS | Data Table for Tax Forms | 5 | CASE_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
95 | DFMCA_FORM_CONTS | Data Table for Data Container Key | 2 | CASE_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
96 | DFMCA_FPF_HIS | FPF: Form Processing History | 2 | CASE_GUID | Technical Key of Carrying Object | nvarchar | 32 | 0 | | |
97 | DFMCA_RETURN | Data Table for Tax Returns | 2 | CASE_GUID | Technical Key of Carrying Object | nvarchar | 32 | 0 | | |
98 | DFMCA_RETURN_M | Data Table for Additional Accounting Data in Return | 2 | CASE_GUID | Technical Key of Carrying Object | nvarchar | 32 | 0 | | |
99 | DFMCA_RETURN_O | Data Table for Tax Returns | 5 | CASE_GUID | Technical Key of Carrying Object | nvarchar | 32 | 0 | | |
100 | DFMCA_TAX_CASE | Data Table for Tax Cases | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
101 | DFMCA_TC_PERS | Data Table for Periods of Tax Case | 2 | CASE_GUID | UUID in character form | nvarchar | 32 | 0 | | |
TOPQuality Management |
102 | ZPH_ATTR_CASE1 | Pharman: Medical Engineering Case Attributes | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
TOPRecords and Case Management |
103 | RMPS_CASE_KYWORD | Case: Key Words | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
104 | RMPS_DOD_T_CATTR | DoD Attributes for Folder (Case) | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
105 | RMPS_PRO_T_CATTR | PRO Attributes for Folder (Case) | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
106 | RMPS_T_CASE_ATTR | DOMEA Attributes for Cases | 2 | CASE_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |