LINE_ITEM_DIMENSION

This dimension contains the details of entitlement line items. Only non-draft and non-test line items are copied to the reporting database. Web register keys are not copied to the reporting database.

In addition to the columns documented here, the LINE_ITEM_DIMENSION table includes a column for each entitlement-time custom attribute you load in to the reporting database. Columns for custom attributes can be added to this dimension in the administrative console. Click Configure Reporting Server > Add Custom Attributes.

The following attributes are available for each entity in this dimension and can be used in reports.

Line Item Dimension Columns

Attribute

Type

Length

Description

ID

numeric

19

A 19-digit (non-nullable) unique identifier of the device record as defined in FlexNet Operations. The ID is the primary key for the Line Item dimension.

ENTITLEMENT_ID

string

255

A non-nullable, unique identifier of the entitlement as defined in FlexNet Operations.

ACTIVATION_ID

string

255

A non-nullable, unique identifier of the entitlement line item as defined in FlexNet Operations.

ORDER_ID

string

255

Order ID defined for the entitlement line item. This field is typically used to correlate the data back to an ERP system. ORDER_ID can be null.

ORDER_LINE_NUMBER

string

255

Order line number defined for the entitlement line item. This field is also typically used to correlate the data back to an ERP system. ORDER_LINE_NUMBER can be null.

PARENT_BULK_ENTITLEMENT_ID

string

255

If this entitlement line item is created by activating a web register key, this field will track the parent bulk entitlement of the web register key.

STATE

string

64

State of the entitlement line item: deployed, inactive or obsolete.

ORDER_TYPE

string

64

Indicates how and why the line item was created; that is, whether it is part of a new order, or it an upgrade from another line item and so on. The choices are:

• Seat Changed
• Upgraded To
• Upgraded From
• Renewed To
• Renewed From
• Upsold To
• Upsold From
• Obsolete
• Inactive
• State Changed
• Deployed

DESCRIPTION

string

3000

Optional description of the line item from FlexNet Operations.

ISUPGRADED

boolean

 

Indicates that this line item has been upgraded. The value for ISUPGRADED is 0 (false) or 1 (true).

ISRENEWED

boolean

 

Indicates that this line item has been renewed. The value for ISRENEWED is 0 (false) or 1 (true).

ISUPSOLD

boolean

 

Indicates that this line item has been upsold. The value for ISUPSOLD is 0 (false) or 1 (true).

ISMAINTENANCE

boolean

 

Indicates that this line item has maintenance. The value for ISMAINTENANCE is 0 (false) or 1 (true).

Maintenance items are not transformed. But this column indicates whether or not a maintenance item is associated with the line item. Maintenance item start and end dates are transformed in to the reporting database.

ENT_DESCRIPTION

string

2000

Optional description of the parent entitlement from FlexNet Operations.