Table ShippingMethod

DDL

create sequence seqShippingMethod as bigint start with 1;

create table ShippingMethod (
   smID bigint not null default next value for seqShippingMethod,
   smCreatedOn datetime not null default sysdatetime(),
   smCreatedByFK pointer not null,
   smChangedOn datetime not null default sysdatetime(),
   smChangedByFK pointer not NULL,
   smCode shortName not null,
   CONSTRAINT pkShippingMethod PRIMARY key (smID)
 );
 create unique index udxShortName on ShippingMethod(smCode);

Default Data

insert into ShippingMethod (smID, smCreatedByFK, smChangedByFK, smCode) values
  (0,0,0,'Unknown');

Mapping

OUT

Conversion ID: OUT.cnvShippingMethodID

New	Old
smID	Sequence
smCreatedOn	SysDateTime()
smCreatedByFK	0
smChangedOn	SysDateTime()
smChangedByFK	0
smCode	distinct shipmethod from out