Table InventoryList

DDL

create sequence seqInventoryList as bigint start with 1;

create table InventoryList (
   ivlID pointer not null default next value for seqInventoryList,
   ivlCreatedOn datetime not null default sysdatetime(),
   ivlCreatedByFK bigint not null,
   ivlChangedOn datetime not null default sysdatetime(),
   ivlChangedByFK bigint not NULL,
   ivlLocationFK bigint not null default 0,
   ivlArticleFK bigint not null default 0,
   ivlDescription Description not null default '',
   CONSTRAINT pkInventoryList PRIMARY KEY (ivlID)
);

Default Data

insert into InventoryList (ivlID, ivlCreatedByFK, ivlChangedByFK, ivlLocationFK, ivlArticleFK, ivlDescription) values (...)

Mapping

InventoryList

Conversion ID: .cnv ID

New	Old
ivlID	ID, but now newly generated
ivlCreatedOn
ivlCreatedByFK
ivlChangedOn
ivlChangedByFK
ivlLocationFK	LOCATION
ivlArticleFK	ARTCODE
ivlDescription	NAME2