Table Carrier

DDL

create sequence seqCarrier as bigint start with 1;

create table Carrier (
   caID bigint not null default next value for seqCarrier,
   caCreatedOn datetime not null default sysdatetime(),
   caCreatedByFK pointer not null,
   caChangedOn datetime not null default sysdatetime(),
   caChangedByFK pointer not NULL,
   caCode name not null,
   CONSTRAINT pkCarrier PRIMARY key (caID)
 );
 create unique index udxCarried on Carrier (caCode);

Default Data

insert into Carrier (caID, caCreatedByFK, caChangedByFK, code)
 values (0,0,0,'None');

Mapping

OUT

Conversion ID: OUT.cnvCarrierID

New	Old
caID
caCreatedOn	SysDateTime()
caCreatedByFK	0
caChangedOn	SysDateTime()
caChangedByFK	0
caCode	Select distinct Carrier from out