Table OutOrderPacking

DDL

create sequence seqOutOrderPacking as bigint start with 1;

create table OutOrderPacking (
   opID pointer not null default next value for seqOutOrderPacking,
   opCreatedOn datetime not null default sysdatetime(),
   opCreatedByFK pointer not null,
   opChangedOn datetime not null default sysdatetime(),
   opChangedByFK pointer not NULL,
   opColliFK pointer not NULL,
   opOutOrderFK pointer not NULL,
   opArticleFK pointer not null,
   opImportRow NVARCHAR(750) NOT NULL default '',
   opUnitPrice FLOAT NOT NULL DEFAULT 0.0,
   opUnitListPrice FLOAT NOT NULL DEFAULT 0.0,
   opContactPerson dbo.Name NOT NULL default '',
   opPhone dbo.Name NOT NULL default '',
   opFax dbo.Name NOT NULL default '',
   opLanguage ShortName NOT NULL default '',
   opCurrency ShortName NOT NULL default '',
   CONSTRAINT pkOutOrderPacking PRIMARY key (opID)
 );

Mapping

Table OutdetailsPacking

Conversion ID: OutdetailsPacking.cnvOutOrderPackingID

New	Old
ID	ID
CreatedOn	CreationDate
CreatedByFK	UserName
ChangedOn	CreationDate
ChangedByFK	UserName
opOutOrderFK	AVIZNO
opArticleFK	ARTCODE
opImportRow	OriginalImpRow
opUnitPrice	UnitPrice
opUnitListPrice	UnitListPrice
opContactPerson	ContactPerson
opPhone	Phone
opFax	Fax
opLanguage	Language
opCurrency	Currency