Table Pallet

DDL

create sequence seqPallet as bigint start with 1;

create table Pallet (
   pID bigint not null default next value for seqPallet,
   pCreatedOn datetime not null default sysdatetime(),
   pCreatedByFK pointer not null,
   pChangedOn datetime not null default sysdatetime(),
   pChangedByFK pointer not NULL,
   CONSTRAINT pkPallet PRIMARY key (pID)
 );
 -- create unique index udx

Default Data

insert into Pallet(pID, pCreatedByFK, pChangedByFK) values (0,0,0);

Mapping

PALCOUNTER

Conversion ID: PALCOUNTER.cnvPallet ID

New	Old
pID	ID
pCreatedOn
pCreatedByFK
pChangedOn
pChangedByFK