Class ModuleOwnerTableInfo
Table 'ModuleOwner': Unique owner of a set of licensed modules
Implements
Inherited Members
Namespace: SuperOffice .CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ModuleOwner")]
public class ModuleOwnerTableInfo : TableInfo, ICloneable
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Fields
DictionaryTableName
Conceptual name of table ModuleOwner in the database dictionary: ModuleOwner
Declaration
public const string DictionaryTableName = "ModuleOwner"
Field Value
Type | Description |
---|---|
string |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Properties
AdminWarningDate
Field 'adminWarningDate' in table 'ModuleOwner': Dictionary type DateTime, .NET type: Date
Declaration
public DateTimeFieldInfo AdminWarningDate { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
So |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
DeploymentType
Field 'deploymentType' in table 'ModuleOwner': Dictionary type Id, .NET type: int
Type of deploymentDeclaration
public Int32FieldInfo DeploymentType { get; }
Property Value
Type | Description |
---|---|
Int32Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
DictionaryTableNumber
Table number for table ModuleOwner in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
Type | Description |
---|---|
int |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
EncryptedCheck
Field 'encryptedCheck' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Encrypted checksum that stops tampering and copying between databasesDeclaration
public StringFieldInfo EncryptedCheck { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Expiration
Field 'expiration' in table 'ModuleOwner': Dictionary type DateTime, .NET type: Date
Declaration
public DateTimeFieldInfo Expiration { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
ExtraFlags
Field 'extraFlags' in table 'ModuleOwner': Dictionary type UInt, .NET type: uint
Unspecified extra flags of license, part of checksumDeclaration
public FieldInfo ExtraFlags { get; }
Property Value
Type | Description |
---|---|
Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
ExtraInfo
Field 'extraInfo' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Free field, can be used by the module owner (example: host domain, for eJournal)Declaration
public StringFieldInfo ExtraInfo { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
GraceTo
Field 'graceTo' in table 'ModuleOwner': Dictionary type DateTime, .NET type: Date
Declaration
public DateTimeFieldInfo GraceTo { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
LeftOuterJoin_ModuleLicense_ModuleOwnerId
Generated left outer join from the primary key ModuleOwnerId on this table, to ModuleLicense.Module
Declaration
public TargetedLeftOuterJoin<ModuleLicenseTableInfo> LeftOuterJoin_ModuleLicense_ModuleOwnerId { get; }
Property Value
Type | Description |
---|---|
Targeted |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
LicenseUrl
Field 'licenseUrl' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
The url that will provide keycodes for all modules owned by this ownerDeclaration
public StringFieldInfo LicenseUrl { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
LicenseVersion
Field 'licenseVersion' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
The url that will provide keycodes for all modules owned by this ownerDeclaration
public StringFieldInfo LicenseVersion { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
MaintenanceTo
Field 'maintenanceTo' in table 'ModuleOwner': Dictionary type DateTime, .NET type: Date
Declaration
public DateTimeFieldInfo MaintenanceTo { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
ModuleOwnerId
Field 'ModuleOwner_id' in table 'ModuleOwner': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo ModuleOwnerId { get; }
Property Value
Type | Description |
---|---|
Int32Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
NextCheckDate
Field 'nextCheckDate' in table 'ModuleOwner': Dictionary type DateTime, .NET type: Date
Declaration
public DateTimeFieldInfo NextCheckDate { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
OwnerDescription
Field 'ownerDescription' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Human-readable description of owner, shown in GUI, default language. Additional languages can be added to LocaleText, resource type 26Declaration
public StringFieldInfo OwnerDescription { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
OwnerName
Field 'ownerName' in table 'ModuleOwner': Dictionary type String[240], .NET type: string
The name of the module owner, not visible in GUI but used in the code. OwnerName SUPEROFFICE is reserved and may NEVER be used by partners. This must be in UPPER CASE and only contain A-Z and 0-9. NO EXTENDED CHARACTERS please.Declaration
public StringFieldInfo OwnerName { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
ProductType
Field 'productType' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Type of productDeclaration
public StringFieldInfo ProductType { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
ProductTypeDescription
Field 'productTypeDescription' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Description of type of productDeclaration
public StringFieldInfo ProductTypeDescription { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Registered
Field 'registered' in table 'ModuleOwner': Dictionary type UtcDateTime, .NET type: Date
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
RegisteredAssociateId
Field 'registered_associate_id' in table 'ModuleOwner': Dictionary type FK, target: Associate, .NET type: int
Registered by whomDeclaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
RegisteredAssociateId_InnerJoin_Associate
Generated join from the foreign key RegisteredAssociateId in this table, to its target table Associate
Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
Targeted |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
So |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Signature
Field 'signature' in table 'ModuleOwner': Dictionary type String[255], .NET type: string
Signature of all non-zero-amount moduleLicense rows referring to this ownerDeclaration
public StringFieldInfo Signature { get; }
Property Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
SignedPublicKey
Field 'signedPublicKey' in table 'ModuleOwner': Dictionary type Blob, .NET type: Stream
The public key used to verify licenses owned by this ownerDeclaration
public FieldInfo SignedPublicKey { get; }
Property Value
Type | Description |
---|---|
Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
Updated
Field 'updated' in table 'ModuleOwner': Dictionary type UtcDateTime, .NET type: Date
Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
Date |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
UpdatedAssociateId
Field 'updated_associate_id' in table 'ModuleOwner': Dictionary type FK, target: Associate, .NET type: int
Last updated by whomDeclaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
UpdatedAssociateId_InnerJoin_Associate
Generated join from the foreign key UpdatedAssociateId in this table, to its target table Associate
Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
Targeted |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().
UpdatedCount
Field 'updatedCount' in table 'ModuleOwner': Dictionary type UShort, .NET type: short
Number of updates made to this recordDeclaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16Field |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetModuleOwnerInfo().