Table Location

DDL

create sequence seqLocation as bigint start with 1;

create table Location (
   lID bigint not null default next value for seqLocation,
   lCreatedOn datetime not null default sysdatetime(),
   lCreatedByFK pointer not null,
   lChangedOn datetime not null default sysdatetime(),
   lChangedByFK pointer not NULL,
   lName dbo.Name not null,
   lDisplayOrder Int not null default 0,
   lPickOrder dbo.Name not null default 0,
   lMinUserLevel Int not null default 0,
   lArea dbo.Name not null default '',
   lAreaFK pointer not null default '',
   lRow nvarchar(5) not null default '0',
   lPlace nvarchar(5) not null default '0',
   lLevel nvarchar(5) not null default '0',
   lNotForInventory BIT not null default 0,   
   lNotForPicking BIT not null default 0,   
   lHighPriorityForPick BIT not null default 0,
   lInventoryFK pointer,
   CONSTRAINT pkLocation PRIMARY key (lID)
 );
 --create unique index udx

Default Data

insert into Location (lID, lCreatedByFK, ChangedByFK, lName) values
(0,0,0,'Unknown');  

Mapping

LOCATION

Conversion ID: LOCATION.cnvLocationID

New	Old
lID	(none)
lCreatedOn	(none)
lCreatedByFK	(none)
lChangedOn	(none)
lChangedByFK	(none)
lName	LOCATION
lDisplayOrder	SQ
lPickOrder	SQWPK
lMinUserLevel	WAREHPLACE
lArea	LAREA
lRow	LROW
lPlace	LPLACE
lLevel	LLEVEL
lAreaFK	AreaID
lNotForInventory	NotForInventory
lNotForPicking	NotForPicking
lHighPriorityForPick	HighPriorityForPick
lInventoryFk	InventoryID