Table PickingParams

Warning

To be completed!

DDL

create sequence seqPickingParams as bigint start with 1;

create table PickingParams (
   ppID bigint not null default next value for seq__,
   ppChangedOn datetime not null default sysdatetime(),
   ppChangedByFK bigint not NULL,
   ppUnitVolume Amount not null,
   ppUnitWeight Amount not null,
   ppTotalVolume Amount not null,
   ppTotalWeight Amount not null,
   CONSTRAINT pkPickingParams PRIMARY key (ppID)
 );

Default Data

insert into PickingParams values (0, getdate(), 0, 50, 10, 1000000, 2000);

Mapping

___

Conversion ID: .cnv ID

New	Old
ID
CreatedOn
CreatedByFK
ChangedOn
ChangedByFK