| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TLRT_THM_RES_H | Threshold Result Header Data | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | TLRT_THM_RES_POS | Threshold Result Position Data | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
3 | TLRT_THM_RES_TIG | Threshold Result Instrument Group Data | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
4 | TREAT_FUT_DIFF | Treasury: TREA Differentiation for Deal Position | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPBasic Data and Tools |
5 | RMWBA_81 | RMS-WB: Object Key for Favorites | 4 | OID | Database Object Key for Favorites | nvarchar | 10 | 0 | | |
TOPBrowser-Based PI Sheet Cockpit |
6 | POC_DB_C_TRIGGER | Domain Model: Trigger Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
7 | POC_DB_PROTOCOL | Domain Model: Event Log for Process Steps | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
8 | POC_DB_TRIG_PROT | Logging: Trigger for Event in Domain Model | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPControlling |
9 | COAS_ATTR_VALUES | Attribute Values | 2 | OID | Object Identification | nvarchar | 22 | 0 | | |
10 | COAS_REFERENCES | References in Attribute Service | 2 | OID | Object Identification | nvarchar | 22 | 0 | | |
TOPMaster Recipe |
11 | CPC_CMX_DB_COR | Master Recipe: Context Table for Recipe Header | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
12 | CPC_CMX_DB_COS | Master Recipe: Context Table for Recipe Operations/Phases | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
13 | CPC_CMX_DB_LOG | XSteps: Change Log | 5 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
14 | CPC_CMX_DB_R_COR | Routing: Context Table for Plan Header | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
15 | CPC_CMX_DB_R_COS | Routing: Context Table for Operations | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
16 | CPC_CMX_DB_R_LOG | XSteps (Routing): Change Log | 5 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
TOPProcess Management |
17 | CMX_XSR_DB_CLOG | XSteps: Change Log | 5 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
18 | CMX_XS_DB_HOBJ | XSteps: Historical Objects (Status Table) | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
19 | CMX_XS_DB_HREL | XSteps: Links to Historical Objects (Relationships) | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
20 | CMX_XS_DB_INSTR | XSteps: Process Instructions Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
21 | CMX_XS_DB_INSTRT | XSteps: Texts for Process Instruction Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
22 | CMX_XS_DB_META | XSteps: Metadata | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
23 | CMX_XS_DB_METAT | XSteps: Texts for Metadata | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
24 | CMX_XS_DB_PRED | XSteps: Predecessor | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
25 | CMX_XS_DB_PREX | XSteps: Predecessor before the Generation | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
26 | CMX_XS_DB_PS | XSteps: Parameter, Definition in DB Format SMALL | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
27 | CMX_XS_DB_PSL | XSteps: Parameter, LIVE Data in DB Format SMALL | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
28 | CMX_XS_DB_PSLT | XSteps: Texts for Parameters, LIVE Data in DB Format SMALL | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
29 | CMX_XS_DB_PST | XSteps: Texts for Parameters in DB Format SMALL | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
30 | CMX_XS_DB_REF | XSteps: Step References Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
31 | CMX_XS_DB_REFT | XSteps: Texts for Step Reference Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
32 | CMX_XS_DB_ROOT | XSteps: Step Root | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
33 | CMX_XS_DB_ROOTT | XSteps: Texts for Step Root | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
34 | CMX_XS_DB_STEP | XSteps: Step Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
35 | CMX_XS_DB_STEPT | XSteps: Text for Step Table | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
36 | CMX_XS_DB_VS | XSteps: Values in DB Format SMALL | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
37 | CMX_XS_DB_VST | XSteps: Texts for Values in DB Format SMALL | 4 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
38 | POC_DB_COMMAND | Domain Model: Table for Step Commands | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
39 | POC_DB_C_COMMAND | Domain Model: Command Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
40 | POC_DB_C_COMMENT | Domain Model: Comment Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
41 | POC_DB_C_DEVIAT | Domain Model: Deviation Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
42 | POC_DB_C_DEVVAR | Domain model: Collection for variable setting (deviation) | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
43 | POC_DB_C_METADAT | Domain Model: Local Value Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
44 | POC_DB_C_PREDEC | Domain Model: Predecessor Table | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
45 | POC_DB_C_STEP | Domain Model: Step Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
46 | POC_DB_C_VALUE | Domain Model: Value Container Collection | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
47 | POC_DB_OPERATION | Domain Model: Table for Operations | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPProcess Order |
48 | COCR_CMX_DB_CR | Context Data for Root Node | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
49 | COCR_CMX_DB_CS | Context Data for XSteps | 2 | OID | XSteps: Object ID for Persistence Layer | nvarchar | 22 | 0 | | |
TOPRecords and Case Management |
50 | RMPSPRO_MAILMIME | Mime for E-Mail | 2 | OID | UUID in X form (binary) | varbinary | 16 | 0 | | |
TOPTreasury and Risk Management |
51 | TREAT_ASSIGNMENT | Treasury: TREA Assignment | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
52 | TREAT_FHA_DIFF | Treasury: TREA Differentiation for Deal Position | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
53 | TREAT_SUBTOTAL | TREA: Position Subtotal | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
54 | TREAT_SUBTOTAL_C | TREA: Subtotal Components | 2 | OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPWorkforce Management Core |
55 | /SAPAPO/LRPREQWD | Search/Requirements Profile for Work Descriptions | 2 | OID | GUID of WFM Search Profile for Work Descriptions (Internal) | nvarchar | 22 | 0 | | |
56 | /SAPAPO/LRPRQPRO | Qualifications Profile | 3 | OID | GUID of a Persistent Object | nvarchar | 22 | 0 | | |
57 | /SAPAPO/LRPSCPRO | Supplied WD Time Capacity Limits Profile Set | 3 | OID | GUID of a Persistent Object | nvarchar | 22 | 0 | | |
58 | /SAPAPO/LRPSOPRO | Supplied WD Time Overtime Profile Set | 3 | OID | GUID of a Persistent Object | nvarchar | 22 | 0 | | |
59 | /SAPAPO/LRPSQPRO | Qualifications Profile | 3 | OID | GUID of a Persistent Object | nvarchar | 22 | 0 | | |
60 | /SAPAPO/LRPSUBID | Table for Subscription of Concrete Subjects | 8 | OID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
61 | /SAPAPO/LRPSUPWD | WFM Capacity Profile for Work Descriptions (Internal) | 2 | OID | UID of WFM Offering Profile for Work Description (Internal) | nvarchar | 22 | 0 | | |