Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | UKMDB_AGCADDR0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
2 | UKMDB_AGCPROD0 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
3 | UKMDB_KEYADDR0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
4 | UKMDB_KEYPROD0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
Business Partner | ||||||||||
5 | RATCE_AGENCY | Rating Agencies | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
6 | RATCE_AGENCY_TXT | Description of Rating Agency | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
7 | RATCE_PROCEDURES | Rating Procedure | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
8 | RATCE_PROC_TXT | Description of Rating Procedure | 4 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
9 | RATCE_RATING | Rating Procedure | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
10 | RATCE_RATING_TXT | Texts for Ratings | 4 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
11 | RATINGS | Ratings | 5 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
Key Mapping | ||||||||||
12 | UKMDB_AGCBNSS0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
13 | UKMDB_AGCCCGH0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
14 | UKMDB_AGCCHRT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
15 | UKMDB_AGCCMPN0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
16 | UKMDB_AGCCSTC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
17 | UKMDB_AGCENGN0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
18 | UKMDB_AGCFINA0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
19 | UKMDB_AGCFNCL0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
20 | UKMDB_AGCFNNC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
21 | UKMDB_AGCGLAM0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
22 | UKMDB_AGCINDV0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
23 | UKMDB_AGCINST0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
24 | UKMDB_AGCLGST0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
25 | UKMDB_AGCMATE0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
26 | UKMDB_AGCORGC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
27 | UKMDB_AGCPCGH0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
28 | UKMDB_AGCPLNT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
29 | UKMDB_AGCPRFT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
30 | UKMDB_AGCSLSF0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
31 | UKMDB_KEYBNSS0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
32 | UKMDB_KEYCCGH0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
33 | UKMDB_KEYCHRT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
34 | UKMDB_KEYCMPN0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
35 | UKMDB_KEYCSTC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
36 | UKMDB_KEYENGN0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
37 | UKMDB_KEYFINA0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
38 | UKMDB_KEYFNCL0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
39 | UKMDB_KEYFNNC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
40 | UKMDB_KEYGLAM0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
41 | UKMDB_KEYINDV0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
42 | UKMDB_KEYINST0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
43 | UKMDB_KEYLGST0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
44 | UKMDB_KEYMATE0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
45 | UKMDB_KEYORGC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
46 | UKMDB_KEYPCGH0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
47 | UKMDB_KEYPLNT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
48 | UKMDB_KEYPRFT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
49 | UKMDB_KEYSLSF0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
Master Data Framework | ||||||||||
50 | DML_OWNERTYPE | MDF Owners | 6 | AGENCY_ID | Scheme ID | nvarchar | 60 | 0 | ||
Production and Revenue Accounting | ||||||||||
51 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 12 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 | ||
Standardized Key Mapping | ||||||||||
52 | UKMDB_AGC00000 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
53 | UKMDB_AGCUNIT0 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
54 | UKMDB_KEY00000 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
55 | UKMDB_KEYUNIT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
56 | UKM_AGENCY | UKM: Key agency | 1 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
Tax Reporting | ||||||||||
57 | OIUX1_RPT_SGB | Report Submission Group base table | 8 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 | ||
58 | OIUX1_RPT_SGRP | Report Submission Group | 6 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 |