Create table emea_address_fabric 
(
PBKEY char (12),
PARENT char (12),
GOVID char (15),
GEOID char (15),
FORMATTEDADDRESS char (200),
ADDRLINE1 char (150),
ADDRLINE2 char (75),
ADDRLINE3 char (50),
ADDRLINE4 char (60),
ADDNUMBER char (50),
ADDNUMBER2 char (12),
STREETNAME char (100),
STREETPREDIR char (10),
STREET char (100),
STREETSUFFIX char (20),
STREETPOSTDIR char (10),
UNITTYPE char (20),
UNIT char (100),
LEVEL char (20),
BUILDINGNAME char (100),
CITY char (50),
POSTALCODE char (10),
POSTALCODEEXT char (4),
ADMIN2 char (50),
ADMIN1 char (30),
COUNTRY char (3),
LOCCODE char (3),
LATITUDE decimal (11,6),
LONGITUDE decimal (11,6),
PROPTYPE char (1),
LANGCODE char (3))