Name Type MSSql Type Oracle Type DB2 Nullable Description
ZDU_PK int NUMBER(38,0) int false Primary Key
ZDU_MQSet char (1) CHAR (1 CHAR) char(1) true 1 for new MQ1* and 2 for new MQ2*
ZDU_Version varchar (255) VARCHAR2 (255 CHAR) varchar(255) true AE System Version
ZDU_Active smallint NUMBER(38,0) smallint true boolean = TRUE if the Version is active
ZDU_Base smallint NUMBER(38,0) smallint true boolean = TRUE if Its the base Version
ZDU_UcsjChngeList varchar (50) VARCHAR2 (50 CHAR) varchar(50) true the last changeList number of UCSJ
ZDU_CpChngeList varchar (50) VARCHAR2 (50 CHAR) varchar(50) true the last changeList number of CP
ZDU_JwpChngeList varchar (50) VARCHAR2 (50 CHAR) varchar(50) true the last changeList number of JWP
ZDU_WpChngeList varchar (50) VARCHAR2 (50 CHAR) varchar(50) true the last changeList number of WP

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ZDU ZDU_PK true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File