Table StockCode

DDL

create sequence seqStockCode as bigint start with 1;

create table StockCode (
   scID pointer not null default next value for seqStockCode,
   scCreatedOn datetime not null default sysdatetime(),
   scCreatedByFK pointer not null,
   scChangedOn datetime not null default sysdatetime(),
   scChangedByFK pointer not NULL,
   scCode NVARCHAR(2) not NULL,
   scOrder Int,
   scDescription dbo.Name,
   CONSTRAINT pkStockCode PRIMARY key (scID)
 );

 create unique index udxStockCodeName on StockCode(scCode);

Default Data

insert into StockCode (scID, scCreatedByFK, scChangedByFK, ) values (...);

Mapping

StockCode

Conversion ID: .cnv ID

New	Old
scID	none
scCreatedOn	SystemDate
scCreatedByFK	0
scChangedOn	SystemDate
scChangedByFK	0
scCode	NAME
scDescription	DESCRIPTION
scOrder	ORDID