Table CommercialInvoice

DDL

create sequence seqCommercialInvoice as bigint start with 1;

create table CommercialInvoice (
   ciID bigint not null default next value for seqCommercialInvoice,
   ciCreatedOn datetime not null default sysdatetime(),
   ciCreatedByFK bigint not null,
   ciChangedOn datetime not null default sysdatetime(),
   ciChangedByFK bigint not NULL,
   ciCode ShortName not null,
   ciOrdersList nvarchar(max) not null default '',
   ciInvoiceValue amount not null,
   ciInvoiceCurrency nvarchar(4) not null,
   ciInvoiceDate datetime not null,
   ciClientOrderJobFK pointer not null,
   ciCustomerFK pointer not null,
   ciPrintingDate datetime,
   ciBrWeight amount not null default 0,

   CONSTRAINT pkCommercialInvoice PRIMARY key (ciID)
);
create unique index udxCommercialInvoice on CommercialInvoice(ciCode,ciCustomerFK);

Default Data

None

Mapping

NRW_CI

Conversion ID: .cnv ID

New	Old
ID	ID
CreatedOn	RSystemDate
CreatedByFK
ChangedOn
ChangedByFK
ciCode	InvoiceNumber
ciOrdersList	OrdersList
ciInvoiceValue	InvoiceValue
ciInvoiceDate	InvoiceDate
ciFilename	Filename
ciPrintingDate	PrintingDate
ciBrWeight	BRWeight