Table Inv

DDL

create sequence seqInv as bigint start with 1;

create table Inv (
   iID bigint not null default next value for seqInv,
   iCreatedOn datetime not null default sysdatetime(),
   iCreatedByFK pointer not null,
   iChangedOn datetime not null default sysdatetime(),
   iChangedByFK pointer not NULL,
   iCode nvarchar(50) not null,
   iCustomerFK pointer not null,
   iComments Description,
   iExternalInvoiceID pointer not null default 0,
   iConfirmFileDate datetime,
   iConfirmFileNeeded bit not null default 0,
   iConfirmFileName nvarchar(200) not null default '',
   CONSTRAINT pkInv PRIMARY key (iID)
 );
 create unique index udxInvoiceCode on Inv(iCode);

Default Data

insert into __ (_ID, _CreatedByFK, _ChangedByFK, ) values

Mapping

INV

Conversion ID: .cnv ID

New	Old
iID
iCreatedOn	FILLDATE
iCreatedByFK	PCNAME
iChangedOn
iChangedByFK
iCode
iCustomerFK	SUPPL via Supplier table
iComments	COMMENTS
iInvoiceFK	INVOICEID via Invoice table
iConfirmFileDate	CFGenFileDate
iConfirmFileNeeded	CFGEN
iConfirmFilename	CFGenFile