Table InvoiceDetailOperation

DDL

create sequence seqInvoiceDetailOperation as bigint start with 1;

create table InvoiceDetailOperation (
   idoID pointer not null default next value for seqInvoiceDetailOperation,
   idoCreatedOn datetime not null default sysdatetime(),
   idoCreatedByFK pointer not null,
   idoChangedOn datetime not null default sysdatetime(),
   idoChangedByFK pointer not NULL,
   idoInvFK pointer not null,
   idoArticleFK pointer not null default 0,
   idoQuantityIn int not null default 0,
   idoQuantity int not null default 0,
   idoLocationFK pointer not null default 0,
   idoComments Name not null default '',
   idoCustomerFK pointer not null default 0,
   idoStockCode nvarchar(2) not null default '',
   idoFillDate DateTime not null default sysdatetime(),
   idoColNo shortname not null default '',
   idoColNo1 shortname not null default '',
   idoInvoiceGroup name not null default '',
   idoExpiryDate datetime,
   idoLotNo name not null default '',
   constraint pkInvoiceDetailOperation primary key (idoID)
);

alter table InvoiceDetailOperation add constraint fkInvoiceDetailOperationArticle foreign key (idoArticleFK) references Article(aID) on update cascade on delete cascade;
alter table InvoiceDetailOperation add constraint fkInvoiceDetailOperationCustomer foreign key (idoCustomerFK) references Customer(cID) on update cascade on delete cascade;
alter table InvoiceDetailOperation add constraint fkInvoiceDetailOperationInv foreign key (idoInvFK) references Inv(iID) on update cascade on delete cascade;
alter table InvoiceDetailOperation add constraint fkInvoiceDetailOperationLocation foreign key (idoLocationFK) references Location(lID) on update cascade on delete cascade;

Default Data

none

Mapping

INVDETAILSOP

Conversion ID: ??

New	Old
idoID	newly generated
idoCreatedOn
idoCreatedByFK	PCNAME
idoChangedOn
idoChangedByFK	PCNAME
idoInvFK	INVOICE
idoArticleFK	ARTCODE
idoQuantityIn	QTYIN
idoQuantity	QTY
idoLocationFK	LOCATION
idoComments	COMMENTS
idoCustomerFK	SUPPLIER
idoStockCode	STOCKCODE
idoFillDate	FILLDATE
idoColNo	COLNO
idoColNo1	COLNO1
idoInvoiceGroup	INVOICEGROUP
idoExpiryDate	EXPIRYDATE
idoLotNo	LOTNO