Table InvDetail

DDL

create sequence seqInvDetail as bigint start with 1;

create table InvDetail (
   idID bigint not null default next value for seqInvDetail,
   idCreatedOn datetime not null default sysdatetime(),
   idCreatedByFK pointer not null,
   idChangedOn datetime not null default sysdatetime(),
   idChangedByFK pointer not NULL,
   idInvFK pointer not null,
   idArticleFK pointer not null,
   idLocationFK pointer not null,
   idCustomerFK pointer not null default 0,
   idQuantityIn int not null default 0,
   idQuantity int not null default 0,
   idComments nvarchar(100) not null default '',
   idStockCode nvarchar(2) not null default '',
   idFillDate DateTime not null default sysdatetime(),
   idPalletFK pointer not null default 0,
   idPallet1FK pointer not null default 0,
   idExpiryDate DateTime,
   idLotNo nvarchar(50) not null default '',
   idTransactionType nVarchar(10) not null default '',
   idCustomsCode nvarchar(2) not null default '',
   idRSystemDate DateTime,
   idSuggestedLocationRetFK pointer,
   idReturnFK pointer,
   idRecordClosed BIT not null default 0,
   CONSTRAINT pkInvDetail PRIMARY key (idID)
 );
  alter table InvDetail add constraint fkInvDetailInv foreign key (idInvFK) references Inv(iID) on update cascade on delete cascade;
  alter table InvDetail add constraint fkInvDetailArticle foreign key (idArticleFK) references Article(aID) on update cascade on delete cascade;
  alter table InvDetail add constraint fkInvDetailSupplier foreign key (idCustomerFK) references Supplier(sID) on update cascade on delete cascade;
  alter table InvDetail add constraint fkInvDetailLocation foreign key (idLocationFK) references Location(lID) on update cascade on delete cascade;
  alter table InvDetail add constraint fkInvDetailPallet foreign key (idPalletFK) references Pallet(pID) on update cascade on delete cascade;

Default Data

None

Mapping

INVDETAILS

Conversion ID: INVDETAILS.cnvInvDetailID

New	Old
idID	ID
idCreatedOn	sysdatetime()
idCreatedByFK	PCNAME
idChangedOn	FILLDATE
idChangedByFK	PCNAME
idInvFK	INVOICE
idArticleFK	ARTCODE
idQuantityIn	QTYIN
idQuantity	QTY
idLocationFK	LOCATION
idComments	COMENTS
idCustomerFK	SUPPLIER
idStockCode	STOCKCODE
idPaletteFk	COLNO
idPalette1Fk	COLNO1
idExpiryDate	EXPIRYDATE
idLotNo	LOTNO
idTransactionType	TransactionType
idCustomsCode	CustomsCode
idRSystemDate	RSystemDate
idSuggestedLocationRetFK	SugestedLocationRet
idReturnFK	RETURDETGR (TBD, maybe conversion record is needed) !
idRecordClosed	RecordClosed