LINE_ITEM_DATES

The Line Item Dates table ties key dates to line items.

Line Item Dates Columns

Columns

Type

Length

Description

LINE_ITEM_ID

numeric

19

A 19-digit unique identifier of the line item record as defined in FlexNet Operations.

VERSION_DATE_ID

numeric

19

A 19-digit unique identifier for the line item’s version date.

EXPIRATION_DATE_ID

numeric

19

A 19-digit unique identifier of the expiration date for a line item.

A value of -1 means the line item is not permanent (existing functionality). A value of -2 means the expiration date cannot be definitively determined and depends on when the activation was performed.

START_DATE_ID

numeric

19

A 19-digit unique identifier of the start date for a line item.

MAINT_START_DATE_ID

numeric

19

A 19-digit unique identifier of the start date for a maintenance item.

MAINT_END_DATE_ID

numeric

19

A 19-digit unique identifier of the end date for a maintenance item.

START_DATE_OPTION

string

40

This field has the following options:

• SPECIFY_AT_EACH_ACTIVATION
• USE_FIRST_ACTIVATION_DATE
• SPECIFY_AT_FIRST_ACTIVATION
• USE_EACH_ACTIVATION_DATE
• SPECIFY_VALUE_NOW

Note:This column is null for maintenance line items.

DURATION

string

10

Specifies the duration unit type.

Note:This column is null for maintenance line items.

DURATION_UNITS

numeric

10

Represents the number of YEAR, MONTH, WEEK, and DAY

Note:This column is null for maintenance line items.