Table ScanHistory

DDL

create sequence seqScanHistory as bigint start with 1;

create table ScanHistory (
   shID bigint not null default next value for seqScanHistory,
   shCreatedOn datetime not null default sysdatetime(),
   shCreatedByFK pointer not null,
   shChangedOn datetime not null default sysdatetime(),
   shChangedByFK pointer not NULL,
   shOperation nvarchar(50) not NULL,
   shOrderFK pointer null default 0,
   shArticleFK pointer not null default 0,
   shQuantity int not null default 0,
   shLocationFK pointer not null default 0,
   shStockCode nvarchar(2) not null default '',
   shComments nvarChar(100) not null default '',
   shOriginalLocationFK pointer not null default 0,
   shOriginalStockCode nvarchar(2) not null default '',
   shOriginalArticleFK pointer not null default 0,
   shInvDetailFK pointer not null default 0,
   shScanDate DateTime not null default sysdatetime(),
   CONSTRAINT pkScanhistory PRIMARY key (shID)
 );

Default Data

None.

Mapping

ScanHistory

Conversion ID: scanHistory.cnvScanHistoryID

New	Old
shID	ID
shCreatedOn	creationDate+CreationTime
shCreatedByFK	UserName
shChangedOn	Now()
shChangedByFK	UserName
shOperation	Operation
shOrderFK	OrdNO
shArticleFK	ArtCode
shQuantity	QTY
shLocationFK	Location
shStockCode	StockCode
shComments	Comments
shOriginalLocationFK	OriginalLocation
shOriginalStockCode	OriginalStockCode
shOriginalArticleFK	OriginalArtCode
shInvDetailFK	IDNO
shScanDate	ScanStartDate