MARISupportProductCustomerLicenses

View Name:	MARISupportProductCustomerLicenses
Based on table:	MPHotlineProduktKundeLizenz
Group:	Group: SupportProduct
Description:	Support Module: Support Product: License files by customer

Field	Table(Germ.field)/Type	Related
CustomerLicenseID	KundeLizenzID INT Primary
CustomerCompany	KundeMandant SMALLINT Index	MARISysConnections.CustomerCompany (WHERE ConnectionType=6)
KundeCardCode	KundeCardCode NVARCHAR (20) Index	OCRD.CardCode
EndUserCompany	EndUserMandant INT Index	MARISysConnections.EndUserCompany (WHERE ConnectionType=6)
EndUserCardCode	EndUserCardCode NVARCHAR (20) Index	OCRD.CardCode
ProductID	ProduktID INT Index	MARISupportProduct.ProductID
Matchcode	Matchcode NVARCHAR (100) Index
LicenseActive	LizenzAktuell SMALLINT (0=false,-1=true)
LicenseDate	LizenzDatum Datetime
LicenseKey	LizenzKey NTEXT
LicenseInfo	LizenzInfo NTEXT
LicenseMode	LizenzMode INT
LicenseVersion	LizenzVersion INT
LimitDate	LimitDate Datetime
NamedUserCount	NamedUserCount INT
ClientsCount	ClientsCount INT
ServerCount	ServerCount INT
RAMCount	RAMCount INT
HardwareKey	HardwareKey NVARCHAR (255)
Modul1Count	Modul1Count INT
Modul2Count	Modul2Count INT
Modul3Count	Modul3Count INT
Modul4Count	Modul4Count INT
Modul5Count	Modul5Count INT
ServerName	ServerName NVARCHAR (255)
DomainName	DomainName NVARCHAR (255)
LizenseFileName	LizenzFileName NVARCHAR (255)
CustomerReference	CustomerReference NVARCHAR (255)
LizenseMemo	LizenzMemo NTEXT
CreateDate	Erstanlage Datetime
CreateUser	ErstanlageID NVARCHAR (4)	MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate	Aenderung Datetime
ChangeUser	AenderungID NVARCHAR (4)	MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

MARIProject Database Structure