RDM_FINCOMPARE_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 GL_ACTIVITY_CODE NATIONAL CHARACTER VARYING(250) 250
11 GL_ACTIVITY_NAME NATIONAL CHARACTER VARYING(250) 250
12 GL_ACTIVITY_ID INTEGER 4
13 GL_PRODUCT_CODE NATIONAL CHARACTER VARYING(250) 250
14 GL_PRODUCT_NAME NATIONAL CHARACTER VARYING(250) 250
15 GL_PRODUCT_ID INTEGER 4
16 GL_CLASS_CODE NATIONAL CHARACTER VARYING(250) 250
17 GL_CLASS_NAME NATIONAL CHARACTER VARYING(250) 250
18 GL_CLASS_ID INTEGER 4
19 GL_STATE_CODE NATIONAL CHARACTER VARYING(250) 250
20 GL_STATE_NAME NATIONAL CHARACTER VARYING(250) 250
21 GL_STATE_ID INTEGER 4
22 GL_CHANNEL_CODE NATIONAL CHARACTER VARYING(250) 250
23 GL_CHANNEL_NAME NATIONAL CHARACTER VARYING(250) 250
24 GL_CHANNEL_ID INTEGER 4
25 A_SOURCE_KEY1_CODE NATIONAL CHARACTER VARYING(250) 250
26 A_SOURCE_KEY1_NAME NATIONAL CHARACTER VARYING(250) 250
27 A_SOURCE_KEY1_ID INTEGER 4
28 A_SOURCE_KEY2_CODE NATIONAL CHARACTER VARYING(250) 250
29 A_SOURCE_KEY2_NAME NATIONAL CHARACTER VARYING(250) 250
30 A_SOURCE_KEY2_ID INTEGER 4
31 INSFIN05_L2_CODE NATIONAL CHARACTER VARYING(250) 250
32 INSFIN05_L2_NAME NATIONAL CHARACTER VARYING(250) 250
33 INSFIN05_L2_ID INTEGER 4
34 TM1_CODE NATIONAL CHARACTER VARYING(250) 250
35 TM1_NAME NATIONAL CHARACTER VARYING(250) 250
36 TM1_ID INTEGER 4
37 PROD_STRUCT1 NATIONAL CHARACTER VARYING(100) 100
38 PROD_STRUCT2 NATIONAL CHARACTER VARYING(100) 100
39 PROD_STRUCT3_CODE NATIONAL CHARACTER VARYING(250) 250
40 PROD_STRUCT3_NAME NATIONAL CHARACTER VARYING(250) 250
41 PROD_STRUCT3_ID INTEGER 4
42 PROD_STRUCT4_CODE NATIONAL CHARACTER VARYING(250) 250
43 PROD_STRUCT4_NAME NATIONAL CHARACTER VARYING(250) 250
44 PROD_STRUCT4_ID INTEGER 4
45 PROD_STRUCT5_CODE NATIONAL CHARACTER VARYING(250) 250
46 PROD_STRUCT5_NAME NATIONAL CHARACTER VARYING(250) 250
47 PROD_STRUCT5_ID INTEGER 4
48 PROD_STRUCT6_CODE NATIONAL CHARACTER VARYING(250) 250
49 PROD_STRUCT6_NAME NATIONAL CHARACTER VARYING(250) 250
50 PROD_STRUCT6_ID INTEGER 4
51 PROD_LVLBAL_CODE NATIONAL CHARACTER VARYING(250) 250
52 PROD_LVLBAL_NAME NATIONAL CHARACTER VARYING(250) 250
53 PROD_LVLBAL_ID INTEGER 4
54 PROD_LEVBALDESC NATIONAL CHARACTER VARYING(100) 100
55 CCPP_L5_CODE NATIONAL CHARACTER VARYING(250) 250
56 CCPP_L5_NAME NATIONAL CHARACTER VARYING(250) 250
57 CCPP_L5_ID INTEGER 4
58 CCPP_L4 NATIONAL CHARACTER VARYING(40) 40
59 CCPP_L3 NATIONAL CHARACTER VARYING(100) 100
60 CCPP_L2 NATIONAL CHARACTER VARYING(100) 100
61 CCPP_L1 NATIONAL CHARACTER VARYING(100) 100
62 PCODE_CODE NATIONAL CHARACTER VARYING(250) 250
63 PCODE_NAME NATIONAL CHARACTER VARYING(250) 250
64 PCODE_ID INTEGER 4
65 PCODE_DESC NATIONAL CHARACTER VARYING(100) 100
66 VALUATION_CLASS NATIONAL CHARACTER VARYING(100) 100
67 COMMENTS NATIONAL CHARACTER VARYING(100) 100
68 VALIDATION_FILE_CODE NATIONAL CHARACTER VARYING(250) 250
69 VALIDATION_FILE_NAME NATIONAL CHARACTER VARYING(250) 250
70 VALIDATION_FILE_ID INTEGER 4
71 BV_CCPP_L3 NATIONAL CHARACTER VARYING(50) 50
72 BV_CCPP_L1 NATIONAL CHARACTER VARYING(50) 50
73 BV_CCPP_L4 NATIONAL CHARACTER VARYING(50) 50
74 BV_CCPP_L5_CODE NATIONAL CHARACTER VARYING(250) 250
75 BV_CCPP_L5_NAME NATIONAL CHARACTER VARYING(250) 250
76 BV_CCPP_L5_ID INTEGER 4
77 BV_CCPP_L2 NATIONAL CHARACTER VARYING(50) 50
78 POLICY_PREFIX_CODE NATIONAL CHARACTER VARYING(3) 3
79 ENTERDATETIME TIMESTAMP 8
80 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
81 ENTERVERSIONNUMBER INTEGER 4
82 LASTCHGDATETIME TIMESTAMP 8
83 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
84 LASTCHGVERSIONNUMBER INTEGER 4
85 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
86 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
87 CDC_RECORD_TYPE CHARACTER(14) 14
88 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
89 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8