Assets have Assets groups as simple extends, could be possible adding new atributes, as characteristics, characteristic values, rates, other transactional values etc, this is simple way how can be extend assets from adempiere version 3.1.0. Whith newly version this can be easy (need creating classes from GenerateModel.java file Adempiere version 354a).
CREATE TABLE "XX_CHARACTERISTICS"
( "AD_CLIENT_ID" NUMBER(10,0) DEFAULT NULL,
"AD_ORG_ID" NUMBER(10,0),
"ISACTIVE" CHAR(1),
"CREATED" DATE,
"CREATEDBY" NUMBER(10,0),
"UPDATED" DATE,
"UPDATEDBY" NUMBER(10,0),
"A_ASSET_ID" NUMBER(10,0),
"XX_CHARACTERISTIC_ID" NUMBER(10,0) DEFAULT NULL,
"ASSETGROUP_ID" NUMBER(10,0) DEFAULT NULL,
"NAME" VARCHAR2(100),
"CREATED_BY" VARCHAR2(100),
"CREATED_DATE" DATE,
"UPDATED_BY" VARCHAR2(100),
"UPDATED_DATE" DATE,
CONSTRAINT "XX_CHARACTERISTIC_PK" PRIMARY KEY ("XX_CHARACTERISTIC_ID") ENABLE
)
/
Fig 1 Creating form from table
fig 2 Steps for calling and creating forms from tables
Fig 3 Functional Form for insert/update new created table characteristics
Нема коментара:
Постави коментар