| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Functions |
1 | TPACHECKASSIGN | Checking Module Assignments in SD Partner Processing | 2 | ROLETYPE | Function types in SD partner processing | nvarchar | 4 | 0 | | |
TOPEnergy Data Management |
2 | EPROFASSROLE | Roles for Profile Allocation | 4 | ROLETYPE | Role category for profile allocation | nvarchar | 2 | 0 | | |
TOPEnvironment, Health and Safety |
3 | /TDAG/RCSC_SROLE | Stakeholder Role | 2 | ROLETYPE | Type of Role | nvarchar | 2 | 0 | | |
4 | /TDAG/RCSC_SROLT | Text Table for Stakeholder Role | 2 | ROLETYPE | Type of Role | nvarchar | 2 | 0 | | |
TOPGeneral Object Relations |
5 | MDOBLRO | Model Data: Permitted Object Roles | 1 | ROLETYPE | Role That an Object Takes in the Relationship | nvarchar | 10 | 0 | | |
6 | MDOBLROL | Model Data: Role Types | 1 | ROLETYPE | Role That an Object Takes in the Relationship | nvarchar | 10 | 0 | | |
7 | MTOBLROL | Model Data: Texts for Role Types | 1 | ROLETYPE | Role That an Object Takes in the Relationship | nvarchar | 10 | 0 | | |
8 | OROBJROLES | Object relationship : valid role types of an object type | 2 | ROLETYPE | Role in Which the Object Occurs | nvarchar | 10 | 0 | | |
9 | ORROLETYP | Object Relationship Service object role types | 1 | ROLETYPE | Role in Which the Object Occurs | nvarchar | 10 | 0 | | |
10 | ORTROLETYP | Object relationship: role types text | 1 | ROLETYPE | Role in Which the Object Occurs | nvarchar | 10 | 0 | | |
11 | SROBLROLB | Persistent Roles of BOR Objects | 5 | ROLETYPE | Role That an Object Takes in the Relationship | nvarchar | 10 | 0 | | |
12 | SROBLROLC | Persistent Roles of Business Classes | 5 | ROLETYPE | Role That an Object Takes in the Relationship | nvarchar | 10 | 0 | | |
13 | SRRELROLES | Object Relationship Service: Roles | 5 | ROLETYPE | Role in Which the Object Occurs | nvarchar | 10 | 0 | | |
TOPIncentive and Commission Management ICM |
14 | CACS00_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
15 | CACS00_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
16 | CACS00_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
17 | CACS_CTRTPAR | Individual Contract Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
18 | TCACS_BUSCLAIM | Valid Entitlement Categories for Each Bus. Obj. Type/ Trans. | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
19 | TCACS_INVREL | Participant Determination for Commission Calculation | 3 | ROLETYPE | Entitlement Category (Target) | nvarchar | 1 | 0 | | |
20 | TCACS_PCINV | Participation Construction: Participants Template | 13 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
21 | TCACS_ROLE | Possible Roles of Commission Contract Partner in Comn Case | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
22 | YCRM01_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
23 | YCRM01_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
24 | YCRM01_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
25 | YHITEC_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
26 | YHITEC_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
27 | YHITEC_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
28 | YSVMA_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
29 | YSVMA_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
30 | YSVMA_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
31 | YTEL01_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
32 | YTEL01_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
33 | YTEL01_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
34 | YTEL05_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
35 | YTEL05_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
36 | YTEL05_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
37 | ZICMAG_B_VAR_REL | Variants for Participant Relations | 10 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
38 | ZICMAG_DOCREL | Commission Document: Relationships Between Participants | 5 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
39 | ZICMAG_REL | Participant Relations in a Commission Participation | 6 | ROLETYPE | Entitlement Category | nvarchar | 1 | 0 | | |
TOPTransaction Management |
40 | VTB_RULESET_PA | FTR Rule Management: Business Partner Rules | 5 | ROLETYPE | BP Role Category | nvarchar | 6 | 0 | | |