Table ArticleCategory

DDL

create sequence seqArticleCategory as bigint start with 1;

create table ArticleCategory (
   acID bigint not null default next value for seqArticleCategory,
   acCreatedOn datetime not null default sysdatetime(),
   acCreatedByFK pointer not null,
   acChangedOn datetime not null default sysdatetime(),
   acChangedByFK pointer not null,
   acCategoryID dbo.name not null default '',
   acCategory dbo.name not null default '',
   acWeightMin amount not null,
   acWeightMax amount not null,
   acVolMin amount not null,
   acVolMax amount not null,
   acCustomerFK pointer not null,
   CONSTRAINT pkArticleCategory PRIMARY key (acID)
 );
 create unique index udxArticleCategory on ArticleCategory (acCustomerFK, acCategoryID, acCategory);

Default Data

insert into __ (_ID, _CreatedByFK, _ChangedByFK, ) values

Mapping

___

Conversion ID: .cnv ID

New	Old
ID
CreatedOn
CreatedByFK
ChangedOn
ChangedByFK