SELECT sales_country.country_id, sales_country."valid$from", sales_country."valid$to", sales_country.country_name, sales_country.region_name, sales_country.iso_3166_2_code, sales_country.iso_3166_3_code, sales_country.centercoordinate, sales_country.source_system, sales_country.owner_id, sales_country.country_id_expereo, sales_country.currency FROM ods.sales_country WHERE (sales_country."valid$to" IS NULL);


SELECT proc_seller.seller_id, proc_seller.country_id, proc_seller."valid$from", proc_seller."valid$to", proc_seller.name, proc_seller.parent_name, proc_seller.legal_name, proc_seller.industry, proc_seller.website, proc_seller.linkedin, proc_seller.twitter, proc_seller.facebook, proc_seller.comments, proc_seller.source_system, proc_seller.seller_stage, proc_seller.billing_group_id, proc_seller.seller_msa_id, proc_seller.owner_id, proc_seller.seller_id_expereo FROM ods.proc_seller WHERE (proc_seller."valid$to" IS NULL);




CREATE TABLE ods.proc_seller (
	seller_id varchar(4000) NOT NULL,
	country_id varchar(4000) NOT NULL,
	"valid$from" timestamp,
	"valid$to" timestamp,
	name varchar(4000),
	parent_name varchar(4000),
	legal_name varchar(4000),
	industry varchar(4000),
	website varchar(4000),
	linkedin varchar(4000),
	twitter varchar(4000),
	facebook varchar(4000),
	comments varchar(4000),
	source_system varchar(4000),
	seller_stage varchar(4000),
	billing_group_id int8,
	seller_msa_id int8,
	owner_id int8,
	seller_id_expereo varchar(4000)
) ;


CREATE TABLE ods.sales_country (
	country_id varchar(4000) NOT NULL,
	"valid$from" timestamp NOT NULL,
	"valid$to" timestamp,
	country_name varchar(4000),
	region_name varchar(4000),
	iso_3166_2_code varchar(4000),
	iso_3166_3_code varchar(4000),
	centercoordinate varchar(4000),
	source_system varchar(4000),
	owner_id varchar(4000),
	country_id_expereo varchar(4000),
	currency varchar(4000)
) ;