廠商委外進出_id

import groovy.sql.Sql
import java.sql.Timestamp
import org.compiere.util.DB

StringBuffer sql = new StringBuffer("CREATE TABLE 廠商委外進出(")
.append("廠商委外進出_id      numeric(10,0) NOT NULL,")
.append("廠商委外進出_uu      character varying(36) DEFAULT NULL::character varying,")
.append("ad_client_id    numeric(10,0) NOT NULL,")
.append("ad_org_id       numeric(10,0) NOT NULL,")
.append("isactive        character(1) NOT NULL,")
.append("created         timestamp without time zone NOT NULL,")
.append("createdby      numeric(10,0) NOT NULL,")
.append("updated         timestamp without time zone NOT NULL,")
.append("updatedby     numeric(10,0) NOT NULL,")
.append("廠商_id         numeric(10,0),")
.append("產品_id         numeric(10,0),")
.append("訂單_id         numeric(10,0),")
.append("訂單製程_id     numeric(10,0),")
.append("委外加工單_id   numeric(10,0),")
.append("委外入貨單_id   numeric(10,0),")
.append("日期          timestamp without time zone NOT NULL,")
.append("序號            numeric(10,0),")
.append("重量kg         numeric(10,2),")
.append("單重g         numeric(10,3),")
.append("數量pcs        numeric(10,0),")
.append("桶型_id        numeric(10,0),")
.append("桶號            character varying(10),")
.append("桶數           numeric(10,0),")
.append("批號          character varying(20),")
.append("備註           character varying(40))");
   
 int no = DB.executeUpdate(sql.toString(), null);

result=""