FULFILLMENT_FACT
This section describes the various fulfillment facts that the producer can use in reports.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Fulfillment Fact record as defined in FlexNet Operations. |
|
PRODUCT_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Product Dimension record as defined in FlexNet Operations. PRODUCT_ID is a foreign key to the PRODUCT_DIMENSION table. |
|
LICENSE_MODEL_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the License Model Dimension record as defined in FlexNet Operations. LICENSE_MODEL_ID is a foreign key to the LICENSE_MODEL_DIMENSION table. |
|
SKU_ID |
numeric |
19 |
A 19-digit unique identifier for the fulfillment’s Part Number Dimension record. SKU_ID is a foreign key to the PART_NUMBER_DIMENSION table. |
|
LINE_ITEM_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Line Item Dimension record. LINE_ITEM_ID is a foreign key to the LINE_ITEM_DIMENSION table. |
|
ORG_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Organization Unit Dimension record. ORG_ID is a foreign key to the ORG_UNIT_DIMENSION table. Note:ORG_ID refers to the organization’s account ID in FlexNet Operations. |
|
RESELLER_ID |
numeric |
19 |
A unique ID for the reseller. This column is populated when an entitlement line item is created from a web register key and values identify the organization unit (account) of the parent bulk entitlement of the web register key. Reseller ID can be null. |
|
PARENT_PRODUCT_ID |
numeric |
19 |
A 19-digit unique identifier of the fulfillment’s parent product. |
|
STATE_ID |
numeric |
19 |
A 19-digit unique identifier of the fulfillment’s current state. |
|
ACTION_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the fulfillment’s Support Action Dimension record. ACTION_ID is a foreign key to the SUPPORT_ACTION_DIMENSION table. |
|
ACTIVATION_DATE_ID |
numeric |
19 |
A 19-digit unique identifier of the fulfillment’s Activation Date. ACTIVATION_DATE_ID is a foreign key to the TIME_DIMENSION table. |
|
LASTMODIFIED_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the fulfillment’s Last Modified Date. |
|
FULFILLMENT_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Fulfillment Dimension record. FULFILLMENT_ID is a foreign key to the FULFILLMENT_DIMENSION table. |
|
FULFILLMENT_COUNT |
integer |
10 |
Number of copies fulfilled for a given ordered product. |