Table Kit

DDL

create sequence seqKit as bigint start with 1;

create table Kit (
   kID bigint not null default next value for seqKit,
   kCreatedOn datetime not null default sysdatetime(),
   kCreatedByFK bigint not null,
   kChangedOn datetime not null default sysdatetime(),
   kChangedByFK bigint not NULL,
   kOutOrderFK pointer not null,
   kArticleFK pointer not null,
   kQuantity amount not null,
   kStockCode nvarchar(3) not null default '',
   kCustomerFK pointer not null default 0,
   kComments dbo.name,
   kStockOperated boolean not null default 0,
   kReadyQuantity integer,
   kLotNo dbo.name not null default '',
   kExpiryDate datetime,

   CONSTRAINT pkKit PRIMARY key (kID)
);

alter table Kit add constraint fkKitArticle foreign key (kArticleFK) references Article(aID);
alter table Kit add constraint fkKitCustomer foreign key (kCustomerFK) references Customer(cID);
alter table Kit add constraint fkKitOutOrder foreign key (kOutOrderFK) references OutOrder(oID);

Default Data

insert into Kit (kID, kCreatedByFK, kChangedByFK, ...) values (...)

Mapping

CGROUP

Conversion ID: .cnv ID

New	Old
kID	ID
kCreatedByFK	PCNAME
kChangedOn
kChangedByFK	PCNAME
kOutOrderFK	'KG'+ID
kArticleFK	ARTCODE
kQuantity	QTY
kStockCode	STOCKCODE
kCustomerFK	SUPPLIER
kComments	COMMENTS
kStockOperated	StockOperated
kReadyQuantity	ReadyQTY
kLotNo	MLotNo
kExpiryDate	MExpiryDate