-- Table: adempiere.I_CityJP

-- DROP TABLE adempiere.I_CityJP;

CREATE TABLE adempiere.I_CityJP
(
  i_errormsg character varying(2000),
  i_isimported character(1) DEFAULT 'N'::bpchar,
  processing character(1),

  processed character(1) DEFAULT 'N'::bpchar,
  C_City_ID numeric(10,0) ,
  I_CityJP_ID numeric(10,0) NOT NULL,
  AD_Client_ID numeric(10,0) DEFAULT 0,
  AD_Org_ID numeric(10,0) DEFAULT 0,
  IsActive character(1) NOT NULL DEFAULT 'Y'::bpchar,
  Created timestamp without time zone NOT NULL DEFAULT now(),
  CreatedBy numeric(10,0) NOT NULL,
  Updated timestamp without time zone NOT NULL DEFAULT now(),
  UpdatedBy numeric(10,0) NOT NULL,
  Name character varying(60) ,
  Locode character varying(10),
  Coordinates character varying(15),
  Postal character varying(10),
  AreaCode character varying(10),
  C_Country_ID numeric(10,0),
  CountryName character varying(60) ,
  C_Region_ID numeric(10,0),
  RegionName character varying(60) ,
  I_CityJP_UU character varying(36) DEFAULT NULL::character varying
)
