| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CIDEON/AUTHGRP | CIDEON Berechtigungsgruppen | 3 | AUTHGRP | CIDEON Berechtigungsgruppe | nvarchar | 20 | 0 | | |
2 | /CIDEON/AUTHGRPT | Texttabelle zu Berechtigungsgruppen | 4 | AUTHGRP | CIDEON Berechtigungsgruppe | nvarchar | 20 | 0 | | |
3 | /CIDEON/MOVE_SC | Umzugsmanagement: Umzugsszenarien | 12 | AUTHGRP | CIDEON Berechtigungsgruppe | nvarchar | 20 | 0 | | |
4 | /PLMB/RCP_BB_SPE | Default Specifications for Building Block Creation | 6 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
5 | /PLMB/RCP_SPECPO | Defaults for Primary Output Specification Creation | 5 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
6 | DMS_TBL_LOCKED | Maintain Lock Field Status | 9 | AUTHGRP | Authorization Group | nvarchar | 1 | 0 | | |
7 | EHPRCC_CDCSPC | Complince Data Category to Spec. Type | 6 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
8 | IWP_HDB_RP | ILM Reporting Package/Perspective | 10 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
9 | VIXCITCADAO | Temporary architectural object data | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
10 | VIXCITCADRO | Temporary rental object data | 20 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPAccounting - General |
11 | TFC_INST_HDR | Header Information on Status Admin for Fast Close | 15 | AUTHGRP | Authorization Group for Closing Cockpit | nvarchar | 12 | 0 | | |
12 | TFC_TEMPL_HDR | Header Information on Status Admin for Fast Close | 15 | AUTHGRP | Authorization Group for Closing Cockpit | nvarchar | 12 | 0 | | |
TOPBasic Data |
13 | VIBDAO | Architectural Object | 14 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
14 | VIBDBE | Business Entity | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
15 | VIBDBU | Building | 19 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
16 | VIBDPR | Land | 19 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
17 | VIBDRO | Rental Object | 19 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPBudgeting |
18 | FMCECVGRP | Cover Groups | 19 | AUTHGRP | Authorization Group for Cover Groups | nvarchar | 10 | 0 | | |
19 | FMHIEIDS | Hierarchy IDs | 9 | AUTHGRP | Authorization Group of the Hierarchy ID | nvarchar | 10 | 0 | | |
TOPClaims Management |
20 | ICLACTIVITY | Tasks in Claim | 36 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
21 | ICLEACTIVITY | Tasks in Claim Bundle | 36 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
22 | ICLNOTE | Claim Note | 21 | AUTHGRP | Authorization Group for Displaying/Changing a Note | nvarchar | 4 | 0 | | |
23 | ICSACTIVITY | Activity in the Claim | 36 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
24 | ICSEACTIVITY | Task in Claim Bundle Shadow Table | 36 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
25 | ICSNOTE | Note | 21 | AUTHGRP | Authorization Group for Displaying/Changing a Note | nvarchar | 4 | 0 | | |
26 | TICL110 | Amount Authorizations for Payments/Reserves | 3 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
27 | TICL110_RESTYP | Amount Authorizations Reserves (per Reserve Type) | 3 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
28 | TICL111 | Authorization Groups | 2 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
29 | TICL111T | User Groups for Authorizations | 3 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
TOPCompliance Check |
30 | EHSBT_RC_ESTRHSH | EHS: Table f. Storing Substs w. Constraints in Shared Memory | 23 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
31 | TXW_C_V0 | Data view: Header | 4 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
32 | TXX_C_V0 | View: Header Area | 4 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
TOPEnvironment, Health and Safety |
33 | /TDAG/CPC_SPTYPE | Import material type | 3 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
34 | TCG36 | EHS: Specification Authorization Object | 2 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
35 | TCGC3 | EHS: Exchange profile | 9 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
TOPFlexible Real Estate Management |
36 | TIVCAAUTHGRP | Authorization Group | 3 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
37 | TIVCAAUTHGRPT | Authorization Group (Text) | 4 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
38 | VIITTC | Correction Object | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
39 | VILUER | LUM: Baulastenverzeichnis | 9 | AUTHGRP | Berechtigungsgruppe | nvarchar | 40 | 0 | | |
TOPFunds Management |
40 | FMBUDGETPD | FM: Budget Period Master Data | 7 | AUTHGRP | FM: Budget Period authorization group | nvarchar | 10 | 0 | | |
TOPIncentive and Commission Management ICM |
41 | TCACS_REGINCL | Includes for Modified, Generated Maintenance Dialogs | 3 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
TOPIndustrial Hygiene and Safety |
42 | CCIHC_WA11 | EHS: Authorization Groups for Work Areas | 2 | AUTHGRP | Authorization Group for Work Area or Pattern | nvarchar | 10 | 0 | | |
43 | CCIHC_WA12 | EHS: Language-Dependent Name for Auth. Groups in Work Area | 3 | AUTHGRP | Authorization Group for Work Area or Pattern | nvarchar | 10 | 0 | | |
44 | CCIHT_WAH | EHS: Work Area - Header | 22 | AUTHGRP | Authorization Group for Work Area or Pattern | nvarchar | 10 | 0 | | |
TOPLand Use Management |
45 | VILMJL | Joint Liability | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
46 | VILMLR | Land Register | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
47 | VILMNA | Notice of Assessment | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
48 | VILMPE | Other Public Register | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
49 | VILMPL | Parcel of Land | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
50 | VILMRC | Parcel Update | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPMaster Data |
51 | FMMEASURE | FM Funded Program Master Data | 7 | AUTHGRP | FM: Funded Program Authorization Group | nvarchar | 10 | 0 | | |
TOPOffer and Rental Request |
52 | VIOROF | Contract Offer | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
53 | VIOROO | Offered Object | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
54 | VIORRR | Rental Request | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPOverhead Cost Controlling |
55 | TFKB | Functional areas | 3 | AUTHGRP | FM: Authorization Group of Functional Area | nvarchar | 10 | 0 | | |
TOPProduct Safety |
56 | ESTRH | EHS: Specification Header | 20 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
57 | TCG36OBJ | EHS: Authorization Group - Specification Category Assignment | 2 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
58 | TCG37 | EHS: Language-Dependent Desc. for Spec. Authorization Object | 3 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
59 | TCGHITPOS | EHS: Set of hit items | 5 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
TOPReal Estate Contract |
60 | VICNCN | Real Estate Contract | 18 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPReal Estate Management |
61 | VIAR02 | RE: REse@rch - RE Requests | 54 | AUTHGRP | Authorization group | nvarchar | 40 | 0 | | |
TOPRecipe Development |
62 | /PLMB/RCP_RECIPE | Recipes | 27 | AUTHGRP | Authorization Group for Recipes | nvarchar | 10 | 0 | | |
63 | /PLMB/RCP_SPEC | Defaults for Property Specification | 5 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
64 | /BEV3/CHAUTHGRP | Authorization Group Contract Handling | 2 | AUTHGRP | Authorization group | nvarchar | 10 | 0 | | |
65 | /BEV3/CHAUTHGRPT | Authorization Group Contract Handling Texts | 2 | AUTHGRP | Authorization group | nvarchar | 10 | 0 | | |
66 | /BEV3/CHBKOMTR | Agreement Communication | 37 | AUTHGRP | Authorization group | nvarchar | 10 | 0 | | |
67 | /BEV3/CHWD | Contract Handling Document | 6 | AUTHGRP | Authorization group | nvarchar | 10 | 0 | | |
TOPRent Adjustment |
68 | VIAJAT | Adjustment Measure | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
69 | VIAJCOMPGRP | Comparative Group of Apartments | 20 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPResourcen Management |
70 | RMSLA_HDH | Time-Dependent Header Data of Label Set | 15 | AUTHGRP | Authorization Group for Labels | nvarchar | 10 | 0 | | |
71 | RMXTT_TRIAL_HD | Trial: Header Data | 35 | AUTHGRP | Authorization Group for Trial | nvarchar | 10 | 0 | | |
TOPRetention Warehouse |
72 | IWP_WP | Audit Packages | 11 | AUTHGRP | Authorization Group | nvarchar | 4 | 0 | | |
TOPRoom Reservations and Seating Arrangements |
73 | VIORMP | Move Plan - Header Data | 25 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPService Charge Settlement |
74 | VISCPG | Participation Group | 12 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
75 | VISCSU | Settlement unit | 20 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |
TOPSpecification |
76 | /PLMI/SPC_DEFINI | Default Values for Specification and FES Initial Screens | 4 | AUTHGRP | Authorization Group | nvarchar | 10 | 0 | | |
TOPThird Party ManagementCOA |
77 | VIMMMN | Mandate | 16 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | | |