iDempiere 全中文化開發

-- Table: adempiere."內外銷出口成品折合原料彙總表"

-- DROP TABLE adempiere."內外銷出口成品折合原料彙總表";

CREATE TABLE adempiere."內外銷出口成品折合原料彙總表"
(
  ad_pinstance_id numeric(10,0),
  "內外銷出口成品折合原料彙總表_ID" numeric(10,0),
  "內外銷出口成品折合原料彙總表_UU" character varying(36),
  "原料料號" character varying(40),
  "原料名稱/規格/型號" character varying(80),
  "原料單位" character varying(10),
  "清冊編號" character varying(40),
  "成品料號" character varying(40),
  "成品名稱/規格/型號" character varying(40),
  "成品單位" character varying(10),
  "成品折合數量" numeric(10,2),
  "使用量" numeric(10,4),
  "原料使用量" numeric(10,2),
  ad_client_id numeric(10,0),
  ad_org_id numeric(10,0),
  isactive character(1) NOT NULL DEFAULT 'Y'::bpchar,
  created timestamp without time zone NOT NULL DEFAULT now(),
  createdby numeric(10,0),
  updated timestamp without time zone NOT NULL DEFAULT now(),
  updatedby numeric(10,0) NOT NULL
)
WITH (
  OIDS=FALSE
);
ALTER TABLE adempiere."內外銷出口成品折合原料彙總表"
  OWNER TO postgres;