CREATE MULTISET TABLE DWHFRT.STAMP_EVT_CNT ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      COD_EVT CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Event Code UPU' NOT NULL COMPRESS '001',
      IDT_CNT_RCU CHAR(35) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Rec. -ID or Container ID' NOT NULL,
      IDT_TYP CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Id-Type' NOT NULL COMPRESS '0',
      DAT_EVT_UTC TIMESTAMP(0) TITLE 'Event timestamp in UTC' NOT NULL,
      DAT_CRN_ODS TIMESTAMP(0) TITLE 'Timestamp when row was imported to ODS' NOT NULL,
      DAT_LOC_EVT TIMESTAMP(0) TITLE 'Event timestamp in Local' COMPRESS ,
      COD_EVT_MSG CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Event Code from the message' COMPRESS ,
      NOM_SRC CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Source' COMPRESS ,
      IDT_COD_CNT VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Container Instance ID' COMPRESS ,
      STT_LVL_SCA CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Scan Level' COMPRESS ,
      PDS_BRT DECIMAL(6,1) TITLE 'Gross Weight (Kg)' COMPRESS ,
      COD_RSN CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Reason Code' COMPRESS ,
      COD_CIE_HDL VARCHAR(35) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Handling Transport Company' COMPRESS ,
      LCT_SCA VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Scan Location' COMPRESS ,
      ESC_ORI CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Origin Station' COMPRESS ,
      ESC_DST CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Dest. Station' COMPRESS ,
      NOM_PRN_ORI VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Partner at Origin' COMPRESS ,
      NOM_PRN_DST VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Partner at Dest.' COMPRESS ,
      NUM_VOL_DEP VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Dep. Flight No.' COMPRESS ,
      NUM_VOL_ARV VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Arrv. Flight No.' COMPRESS ,
      DAT_DEP TIMESTAMP(0) TITLE 'Departure Date/Time' COMPRESS ,
      DAT_VOL TIMESTAMP(0) TITLE 'Arrival Date/Time' COMPRESS ,
      DAT_CRN_EVT TIMESTAMP(0) TITLE 'Event Timestamp written to disk' COMPRESS ,
      DAT_MDF TIMESTAMP(0) TITLE 'Last modified Time Stamp' COMPRESS ,
      UTI_MDF VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Changed By' COMPRESS ,
      IDT_VOL VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Flight ID' COMPRESS ,
      DAT_CRN_DWH DATE FORMAT 'YYYYMMDD' TITLE 'DWH creation date' NOT NULL)
PRIMARY INDEX PI_STAMP_EVT_CNT ( IDT_CNT_RCU ,DAT_EVT_UTC );