-- Table: adempiere.I_WarehouseJP

-- DROP TABLE adempiere.I_WarehouseJP;

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

  processed character(1) DEFAULT 'N'::bpchar,

  I_WarehouseJP_ID numeric(10,0) NOT NULL,
  I_WarehouseJP_UU character varying(36) DEFAULT NULL::character varying,
  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,

  JP_Org_Value character varying(40) DEFAULT NULL::character varying,
  Value character varying(40) ,
  M_Warehouse_ID numeric(10,0),
  Name character varying(60),
  Description character varying(255) ,
  Separator character(1) ,
  ReplenishmentClass character varying(60) ,
  IsIntransit character(1)  DEFAULT 'N'::bpchar,
  IsDisallowNegativeInv character(1) NOT NULL DEFAULT 'N'::bpchar,
  
  JP_AcctSchema_Name character varying(60),
  C_AcctSchema_ID numeric(10,0),
  JP_W_Differences_Value character varying(40),
  W_Differences_Acct numeric(10,0),

  C_Location_ID numeric(10,0) ,
  JP_Location_Label character varying(255),
  JP_LocationOrg_Value character varying(40) DEFAULT NULL::character varying,
  CountryCode character varying(2),
  C_Country_ID numeric(10,0) DEFAULT NULL::numeric,
  Postal character varying(10)  DEFAULT NULL::character varying,
  Postal_add character varying(10) DEFAULT NULL::character varying,
  RegionName character varying(40) DEFAULT NULL::character varying,
  C_Region_ID numeric(10,0) DEFAULT NULL::numeric,
  City character varying(60) DEFAULT NULL::character varying,
  C_City_ID numeric(10,0) DEFAULT NULL::numeric,
  Address1 character varying(60) DEFAULT NULL::character varying,
  Address2 character varying(60) DEFAULT NULL::character varying,
  Address3 character varying(60) DEFAULT NULL::character varying,
  Address4 character varying(60) DEFAULT NULL::character varying,
  Address5 character varying(60) DEFAULT NULL::character varying,
  Comments character varying(2000) DEFAULT NULL::character varying,
  JP_LocationOrg_ID numeric(10,0) DEFAULT NULL::numeric,
 I_IsActiveJP character(1) NOT NULL DEFAULT 'Y'::bpchar,

  CONSTRAINT I_WarehouseJP_pkey PRIMARY KEY (I_WarehouseJP_ID)
)
