Table StockCompare

DDL

create sequence seqStockCompare as bigint start with 1;

create table StockCompare (
   stID pointer not null default next value for seqStockCompare,
   stCreatedOn datetime not null default sysdatetime(),
   stCreatedByFK bigint not null,
   stChangedOn datetime not null default sysdatetime(),
   stChangedByFK bigint not NULL,
   stArticleFK pointer not null,
   stQuantity Int not null,
   stClientOrderJobFK pointer not null,
   CONSTRAINT pkStockCompare PRIMARY KEY (stID)
);
create udxStockCompare on StockCompare(stArticleFK,stClientOrderJobFK);

Default Data

none

Mapping

Not needed, temp table.