（1）在Adempiere的db中创建一个TABLE

CREATE TABLE adempiere.XX_Material (

AD_CLIENT_ID NUMERIC(10) NOT NULL,

AD_ORG_ID NUMERIC(10) NOT NULL,

ISACTIVE CHAR(1) DEFAULT 'Y' NOT NULL,

CREATED DATE DEFAULT NOW() NOT NULL,

CREATEDBY NUMERIC(10) NOT NULL,

UPDATED DATE DEFAULT NOW() NOT NULL,

UPDATEDBY NUMERIC(10) NOT NULL,

XX_MATERIAL_ID NUMERIC(10,0) NOT NULL,

MATNR SMALLINT NOT NULL,

COLORNR SMALLINT NOT NULL,

NAME VARCHAR(100) NOT NULL,

NAMESHORT VARCHAR(100) NOT NULL

);

ALTER TABLE XX_Material ADD PRIMARY KEY (XX_MATERIAL_ID );

（2）以SystemAdmin登陆Adempiere，创建Table&Column

指定

[@more@]

ITPub博客

Adempiere 三步创建窗口入门