Table: adempiere.z_productionplan

-- Table: adempiere.z_productionplan

-- DROP TABLE adempiere.z_productionplan;

CREATE TABLE adempiere.z_productionplan
(
  z_productionplan_id numeric(10,0) NOT NULL,
  ad_client_id numeric(10,0) NOT NULL,
  ad_org_id numeric(10,0) NOT NULL,
  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,
  value character varying(40) NOT NULL,
  name character varying(60) NOT NULL,
  description character varying(255),
  help character varying(2000),
  z_item_id numeric(10,0) NOT NULL,
  qty numeric,
  startdate numeric,
  completedate numeric,
  z_uom_id numeric(10,0) NOT NULL,
  z_productionplan_uu character varying(36) DEFAULT NULL::character varying,
  CONSTRAINT z_productionplan_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (
  OIDS=FALSE
);
ALTER TABLE adempiere.z_productionplan
  OWNER TO postgres;