Table Colli

DDL

create sequence seqColli as bigint start with 1;

create table Colli (
   clID bigint not null default next value for seqColli,
   clCreatedOn datetime not null default sysdatetime(),
   clCreatedByFK pointer not null,
   clChangedOn datetime not null default sysdatetime(),
   clChangedByFK pointer not null,
   clOutOrderFK  pointer not null,
   CONSTRAINT pkColli PRIMARY key (clID)
 );

alter table colli add constraint ColliOutOrderFK foreign key (clOutOrderFK) references outorder(oID);

Default Data

None

Mapping

OutdetailsPackingColCounter

Conversion ID: Colli.OutdetailsPackingColCounterID

New	Old
clID	colno
clCreatedOn	new
clCreatedByFK	creationdate
clChangedOn	creationdate
clChangedByFK	creationdate
clOutOrder	AVIZNO