CREATE TABLE aggregated_accounting
(
   accounting_month                 datetime encode lzo,
   accounting_quarter               varchar(100) encode lzo,
   accounting_quarter_integer       integer encode lzo,
   activity_month                   datetime encode lzo,
   activity_quarter                 varchar(10) encode lzo,
   activity_quarter_integer         integer encode lzo,
   dim_isrcid                       integer encode lzo,
   dim_catalogid                    integer encode lzo,
   dim_imprintid                    integer encode lzo,
   dim_subaccountid                 integer encode lzo,
   gross                            numeric(18,6) encode lzo,
   units                            numeric(18,6) encode lzo,
   actual_net                       numeric(18,6) encode lzo,
   adjusted_gross                   numeric(18,6) encode lzo,
   distribution_fees                numeric(18,6) encode lzo,
   dpd_publishing                   numeric(18,6) encode lzo,
   net_receipt                      numeric(18,6) encode lzo,
   ringtone_publishing              numeric(18,6) encode lzo,
   retail_price                     numeric(18,6) encode lzo,
   store_is_in_analytics            boolean,
   trackid                          bigint encode lzo,
   track_name                       varchar(1000) encode lzo,
   music_vs_video_by_tracktype      varchar(1000) encode lzo,
   country_name                     varchar(255) encode lzo,
   country_code                     varchar(2) encode lzo,
   continent                        varchar(32) encode lzo,
   continent_group                  varchar(12) encode lzo,
   continent_ordered                varchar(18) encode lzo,
   storeid                          integer encode lzo,
   store_name                       varchar(64) encode lzo,
   store_name_short                 varchar(64) encode lzo,
   store_group                      varchar(32) encode lzo,
   store_group_less                 varchar(32) encode lzo,
   store_musicbucket                varchar(32) encode lzo,
   store_videobucket                varchar(32) encode lzo,
   is_store_itunesusa               boolean,
   releaseid                        bigint encode lzo,
   release_name                     varchar(1000) encode lzo,
   release_releasedate              date encode lzo,
   release_sale_start_date          date encode lzo,
   release_sale_preorder_date       date encode lzo,
   release_sale_physical_date       date encode lzo,
   release_theatrical_release_date  date encode lzo,
   release_vod_sale_start_date      date encode lzo,
   release_priority                 varchar(10) encode lzo,
   release_version                  varchar(1000) encode lzo,
   release_new_or_catalog           varchar(16) encode lzo,
   release_is_itunes_previewable    boolean,
   release_is_compilation           boolean,
   release_is_deleted               boolean,
   release_is_digital_only          boolean,
   release_video_is_vod             boolean,
   release_video_channel            varchar(18) encode lzo,
   release_product_type             varchar(32) encode lzo,
   music_vs_video_by_product        varchar(32) encode lzo,
   release_genre                    varchar(32) encode lzo,
   release_genre_group              varchar(40) encode lzo,
   release_genre_group_less         varchar(40) encode lzo,
   labelid                          integer encode lzo,
   label_name                       varchar(100) encode lzo,
   label_priority                   integer encode lzo,
   label_ownerid                    integer encode lzo,
   label_owner                      varchar(10) encode lzo,
   label_is_distributor             varchar(3) encode lzo,
   label_is_red                     boolean,
   label_is_supplychain             boolean,
   label_sc_group                   varchar(10) encode lzo,
   label_is_ioda                    boolean,
   label_country                    varchar(255) encode lzo,
   label_continent                  varchar(32) encode lzo,
   artistid                         bigint,
   artist_name                      varchar(1000) encode lzo,
   artist_country                   varchar(255) encode lzo,
   transac_typeid                   integer,
   transac_type_abbr                varchar(4) encode lzo,
   transac_type                     varchar(255) encode lzo,
   transac_type_group               varchar(32) encode lzo,
   music_vs_video_by_transac        varchar(32) encode lzo,
   stream_vs_download               varchar(32) encode lzo,
   album_vs_track                   varchar(32) encode lzo,
   music_vs_video                   varchar(32) encode lzo
) sortkey(accounting_month);