Table user

DDL

create sequence seqUser as bigint start with 1;

create table dbo.[user] (
   uID bigint not null default next value for seqUser,
   uCreatedOn datetime not null default sysdatetime(),
   uCreatedByFK pointer not null,
   uChangedOn datetime not null default sysdatetime(),
   uChangedByFK pointer not NULL,
   uLogin LongName not null,
   uPassword Name not null default '',
   uName LongName not null default '',
   uEmail LongName not null default '',
   uAllowScannerReceptions Boolean default 0,
   uAllowScannerDeliveries Boolean default 0,
   uAllowScannerStockArticle Boolean default 0,
   uAllowScannerBarCodes Boolean default 0,
   uAllowScannerInventory Boolean default 0,
   uAllowScannerMoves Boolean default 0,
   uAllowScannerKits Boolean default 0,
   uAllowScannerStockLocation Boolean default 0,
   uAllowScannerCheckPickings Boolean default 0,
   uAllowScannerReturns Boolean default 0,
   uAllowOfficeUsers  Boolean default 0,
   uAllowOfficeReceptions  Boolean default 0,
   uAllowOfficeSettings  Boolean default 0,
   uAllowOfficeDeliveries Boolean default 0,
   uAllowOfficeSuppliers Boolean default 0,
   uAllowOfficeClients Boolean default 0,
   uAllowOfficeStock Boolean default 0,
   uAllowOfficeImportFiles Boolean default 0,
   uAllowOfficeOther Boolean default 0,
   uAllowOfficeKitting Boolean default 0,
   uAllowOfficeLabels Boolean default 0,
   uAllowOfficeExportFiles Boolean default 0,
   uIsAdministrator Boolean default 0,
   uPrinterName LongName Not null default '',
   uLabelPrinterName LongName Not null default '',
   uDefaultCustomerFK Pointer,
   CONSTRAINT pkUser PRIMARY key (uID)
);
create unique index udxUserLogin on dbo.[user] (uLogin);

Default Data

insert into dbo.[user] (uID, uCreatedByFK, uChangedByFK, uLogin) values
  (0, 0, 0, 'Unknown'),
  (1, 0, 0, 'Conversion'),
  (2, 0, 0, 'C-Quel');

Mapping

ADM

Conversion ID: ADM.cnvUserID

New	Old
uID	UserID
uCreatedOn
uCreatedByFK
uChangedOn
uChangedByFK
uLogin	PCNAME
uPassword
uName	NAME
uEmail	EMAIL
uAllowScannerReceptions	X1
uAllowScannerDeliveries	X2
uAllowScannerStockArticle	X3
uAllowScannerBarCodes	X4
uAllowScannerInventory	X5
uAllowScannerMoves	X6
uAllowScannerKits	X7
uAllowScannerStockLocation	X8
uAllowScannerCheckPickings	X9
uAllowScannerReturns	X10
uAllowOfficeUsers	O1
uAllowOfficeReceptions	O2
uAllowOfficeSettings	O3
uAllowOfficeDeliveries	O4
uAllowOfficeSuppliers	O5
uAllowOfficeClients	O6
uAllowOfficeStock	O7
uAllowOfficeImportFiles	O8
uAllowOfficeOther	O9
uAllowOfficeKitting	O10
uAllowOfficeLabels	O11
uAllowOfficeExportFiles	O12
uIsAdministrator	Admin
uDefaultPrinterName	UserPrinter
uDefaultLabelPrinterName	UserLabelPrinter
uDefaultCustomerFK	MSUPPLIER