Table ScanIn

DDL

create sequence seqScanIn as bigint start with 1;

create table ScanIn (
   siID pointer not null default next value for seqScanIn,
   siCreatedOn datetime not null default sysdatetime(),
   siCreatedByFK bigint not null,
   siChangedOn datetime not null default sysdatetime(),
   siChangedByFK bigint not NULL,
   siInvoiceFK pointer not null default 0,
   siArticleFK pointer not null default 0,
   siLocationFK pointer not null default 0,
   siStockCode nvarchar(2) not null default '',
   siColNo Name not null default '',
   siQuantity int not null default 0,
   siOperatorFK pointer not null default 0,
   siMoveOperatorFK pointer not null default 0,
   siMoveDate datetime,
   siLotNo Name not null default '',
   siExpiryDate datetime,
   CONSTRAINT pkScanIn PRIMARY key (siID)
);

Default Data

none

Mapping

ScanIn

Conversion ID: .cnv ID

New	Old
siID	newly generated (was ID)
siCreatedOn	CREATIONDATE + CREATIONTIME
siCreatedByFK
siChangedOn
siChangedByFK
siInvoiceFK	INVOICE
siArticleFK	ARTCODE
siLocationFK	LOCATION
siStockCode	STOCKCODE
siColNo	COLNO
siQuantity	QTY
siOperatorFK	MYOPERATOR
siMoveOperatorFK	MOVEOPERATOR
siMoveDate	MOVEDATE + MOVETIME
siLotNo	LOTNO
siExpireDate	EXPIRYDATE