Table KitDetail

DDL

create sequence seqKitDetail as bigint start with 1;

create table KitDetail (
   kdID bigint not null default next value for seqKitDetail,
   kdCreatedOn datetime not null default sysdatetime(),
   kdCreatedByFK bigint not null,
   kdChangedOn datetime not null default sysdatetime(),
   kdChangedByFK bigint not NULL,
   kdKitFK pointer not null,
   kdArticleFK pointer not null,
   kdUnitQuantity integer not null default 0,
   kdStockCode nvarchar(3) not null default '',

   CONSTRAINT pkKitDetail PRIMARY key (kdID)
);

alter table KitDetail add constraint fkKitDetailArticle foreign key (kdArticleFK) references Article(aID);
alter table KitDetail add constraint fkKitDetailKit foreign key (kdKitFK) references Kit(kID);

Default Data

insert into KitDetail (kdID, kdCreatedByFK, kdChangedByFK, ...) values (...)

Mapping

CGROUPDET

Conversion ID: CGROUPDET.cnvKitDetailID

New	Old
kdID	newly generated
kdCreatedOn	sysdatetime()
kdCreatedByFK	PCNAME
kdChangedOn	sysdatetime()
kdChangedByFK	PCNAME
kdkitFK	IDNO
kdArticleFK	ARTCODE
kdUnitQuantity	UNITQTY
kdStockCode	StockCode