MPHotlineProduktKundeLizenz

Table Name:	MPHotlineProduktKundeLizenz
View Name:	MARISupportProductCustomerLicenses
Group:	Group: SupportProduct
Description:	Support Module: Support Product: License files by customer

Field	View(engl.field)/Type	Related
KundeLizenzID	CustomerLicenseID INT Primary
KundeMandant	CustomerCompany SMALLINT Index	MPSysConnections.CompanyID (WHERE ConnectionType=6)
KundeCardCode	KundeCardCode NVARCHAR (20) Index	OCRD.CardCode
EndUserMandant	EndUserCompany INT Index	MPSysConnections.CompanyID (WHERE ConnectionType=6)
EndUserCardCode	EndUserCardCode NVARCHAR (20) Index	OCRD.CardCode
ProduktID	ProductID INT Index	MPHotlineProdukt.ProduktID
Matchcode	Matchcode NVARCHAR (100) Index
LizenzAktuell	LicenseActive SMALLINT (0=false,-1=true)
LizenzDatum	LicenseDate Datetime
LizenzKey	LicenseKey NTEXT
LizenzInfo	LicenseInfo NTEXT
LizenzMode	LicenseMode INT
LizenzVersion	LicenseVersion 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)
LizenzFileName	LizenseFileName NVARCHAR (255)
CustomerReference	CustomerReference NVARCHAR (255)
LizenzMemo	LizenseMemo NTEXT
Erstanlage	CreateDate Datetime
ErstanlageID	CreateUser NVARCHAR (4)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung	ChangeDate Datetime
AenderungID	ChangeUser NVARCHAR (4)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

MARIProject Database Structure