Table SuggestedStockList

DDL

create sequence seqSuggestedStockList as BIGINT start with 1;

create table SuggestedStockList (
   sslID BIGINT NOT NULL DEFAULT next value for seqSuggestedStockList,
   sslCreatedOn DATETIME NOT NULL DEFAULT sysdatetime(),
   sslCreatedByFK BIGINT NOT NULL,
   sslChangedOn DATETIME NOT NULL DEFAULT sysdatetime(),
   sslChangedByFK BIGINT NOT NULL,
   sslInvoiceFK POINTER NOT NULL DEFAULT 0,
   sslArticleFK POINTER NOT NULL DEFAULT 0,
   sslQuantity INT NOT NULL DEFAULT 0,
   sslLocationFK POINTER NOT NULL DEFAULT 0,
   sslStockCode NVARCHAR(2) NOT NULL DEFAULT '',
   sslFillDate DATETIME,
   sslMyPriority INT NOT NULL DEFAULT 0,
   sslExpiryDate DATETIME,
   sslLotPriority NCHAR(1) NOT NULL DEFAULT '',
   sslHighPrioOrderBy INT NOT NULL DEFAULT 0,
   sslLocationLevelPriority INT NOT NULL DEFAULT 0,
   sslExpiryOrderBy INT NOT NULL DEFAULT 0,
   sslSessionID Name NOT NULL DEFAULT '',
   sslRSystemDate DATETIME,
   sslUserName LongName NOT NULL DEFAULT '',
   CONSTRAINT pkSuggestedStockList PRIMARY key (sslID)
);

DEFAULT Data

insert INTo SuggestedStockList (sslID, sslCreatedByFK, sslChangedByFK, ...) values (...)

Mapping

Suggested_Stock_List

Conversion ID:

New	Old
sslID	ID (now newly generated)
sslCreatedOn
sslCreatedByFK
sslChangedOn
sslChangedByFK
sslInvoiceFK	INVOICE
sslArticleFK	ARTCODE
sslQuantity	QTY
sslLocationFK	LOCATION
(not used)	COLOR
(not used)	AMBALAJ
sslStockCode	STOCKCODE
sslFillDate	FILLDATE
sslMyPriority	MYPRIORITY
sslExpiryDate	EXPIRYDATE
sslLotPriority	LOTPRIORITY
sslHighPrOrderBy	HIGHPRSQ
sslLocationLevelPriority	LOCATIONLEVELPRIORITY
sslExpiryOrderBy	EXPIRYSQ
sslSessionId	SESSIONID
sslRSystemDate	RSYSTEMDATE
sslUserName	USERNAME