-- Table: adempiere.I_BPartnerJP;

-- DROP TABLE adempiere.I_BPartnerJP;

CREATE TABLE adempiere.I_BPartnerJP
(
  I_BPartnerJP_ID numeric(10,0) NOT NULL,
  ad_client_id numeric(10,0),
  ad_org_id numeric(10,0),
  isactive character(1) DEFAULT 'Y'::bpchar,
  created timestamp without time zone NOT NULL DEFAULT statement_timestamp(),
  createdby numeric(10,0),
  updated timestamp without time zone NOT NULL DEFAULT statement_timestamp(),
  updatedby numeric(10,0),
  i_isimported character(1) NOT NULL DEFAULT 'N'::bpchar,
  i_errormsg character varying(2000),
  c_bpartner_id numeric(10,0),
  value character varying(40),
  name character varying(60),
  name2 character varying(60),
  description character varying(255),
  duns character(11),
  taxid character varying(20),
  naics character(6),
  groupvalue character varying(40),
  c_bp_group_id numeric(10,0),
  c_bpartner_location_id numeric(10,0),
  address1 character varying(60),
  address2 character varying(60),
  postal character varying(10),
  postal_add character varying(10),
  city character varying(60),
  c_region_id numeric(10,0),
  regionname character varying(60),
  c_country_id numeric(10,0),
  countrycode character(2),
  title character varying(40),
  contactname character varying(60),
  contactdescription character varying(255),
  comments character varying(2000),
  phone character varying(40),
  phone2 character varying(40),
  fax character varying(40),
  email character varying(60),
  password character varying(20),
  birthday timestamp without time zone,
  c_greeting_id numeric(10,0),
  bpcontactgreeting character varying(60),
  processing character(1),
  processed character(1) DEFAULT 'N'::bpchar,
  ad_user_id numeric(10,0),
  r_interestarea_id numeric(10,0),
  interestareaname character varying(40),
  iscustomer character(1) DEFAULT NULL::bpchar,
  isemployee character(1) DEFAULT NULL::bpchar,
  isvendor character(1) DEFAULT NULL::bpchar,
  I_BPartnerJP_uu character varying(36) DEFAULT NULL::character varying,
  CONSTRAINT I_BPartnerJP_PKey PRIMARY KEY (I_BPartnerJP_ID)
)
