T_ENT

 

Name

Data Type

Allows Null

Description

ENTId

int

No

Auto-generated unique ID

EId

varchar (100)

No

32 digit unique GUID.

 

RehostAllowd

bit

No

Not in use

 

RehostTicketRequired

bit

No

Not in use

 

TimesRehostAllowed

int

Yes

Not in use

 

RelicenseAllowed

bit

No

Not in use

 

RevokeAllowed

bit

No

Not in use.

 

TimesRevokeAllowed

int

Yes

Not in use

 

StartDate

datetime

No

Date from which the Entitlement will be valid

 

EndDate

datetime

No

Date till which the Entitlement will be valid

 

Duration

int

Yes

Not in use

CONTId

int

Yes

ID of contact associated with this Entitlement. Relates to T_ENT_CONT.

 

Credit

int

Yes

Not in use

 

IsEnabled

bit

No

Flag to specify whether Entitlement is enabled or disabled

 

RegRequired

int

No

Specifies whether user registration is required. 1 - Mandatory, 2 - Desired, 3 - Not Required.

CSTMRId

int

Yes

ID of customer associated with this Entitlement. Relates to T_CSTMR.

 

RehostUnit

varchar (10)

Yes

Not in use

 

RevokeUnit

varchar (10)

Yes

Not in use

 

VendorString1

nvarchar (510)

Yes

Not in use

 

VendorString2

nvarchar (510)

Yes

Not in use

 

VendorString3

nvarchar (510)

Yes

Not in use

 

VendorString4

nvarchar (510)

Yes

Not in use

BatchId

int

Yes

Not in use

 

EntState

int

No

Entitlement state. 1 – Draft, 2 – Queued, 3 – Product Keys generated, 4 – Produced, 5 – Complete, 6 – Acknowledged.

 

RefId1

nvarchar (250)

Yes

Reference ID 1. Used to connect to an external CRM.

 

RefId2

nvarchar (250)

Yes

Reference ID 2. Used to connect to an external CRM.

 

isTest

bit

No

Not in use

PartnerId

int

Yes

Not in use

PartnerContId

int

Yes

Not in use

 

commitDate

datetime

Yes

Date and time when the Entitlement was committed

 

createDate

datetime

No

Date and time when the Entitlement was created

 

Descr

nvarchar (510)

Yes

Description of Entitlement

 

CreatedBy

nvarchar (50)

Yes

ID of the user who created the Entitlement

 

AutoCreated

bit

No

Not in use

  IdentityCount int No (DEPRECATED) Number of Identities allowed to be added in a Cloud Named Entitlement.
  TransactionCount int No Defines the number of the transaction, for example, 1st, 2nd, 3rd.