# Custom Attributes in Database

The following tables list the custom attributes in the database.

- [Accounts](#accounts)
- [Entitlement](#entitlement)
- [Fulfillment](#fulfillment)
- [Line Item](#line-item)
- [License Model Attribute](#license-model-attribute)
- [License Model Custom Attribute](#license-model-custom-attribute)
- [Maintenance Line Item](#maintenance-line-item)
- [Product](#product)
- [User](#user)


## Account

| Field in Database | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **ORG_ID** | Unique identifier in the database of the account from the **Account** table. | Equivalent to:- ID in SEC_VW_ACCOUNT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## Entitlement

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **ENTITLEMENT_ID** | Unique identifier in the database of the entitlement from the **Entitlement** table. | Equivalent to:- ENTITLEMENT_ID_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## Fulfillment

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **FULFILLMENT_ID** | Unique identifier in the database of the fulfillment from the **Fulfillment** table. | Equivalent to:- ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## Line Item

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **ACTIVATION_ID** | Unique identifier in the database of the Activation Id from the **Entitlement** table. | Equivalent to:- LINEITEM_ID_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## License Model Attribute

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **LINE_ITEM_ID** | Unique identifier in the database of the Activation Id from the **Entitlement** table. | Equivalent to:- LINEITEM_ID_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## License Model Custom Attribute

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **LICENSE_MODEL_ID** | Unique identifier in the database of the License Model from the **Entitlement** table. | Equivalent to:- LICENSEMODEL_ID_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## Maintenance Line Item

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **ACTIVATION_ID** | Unique identifier in the database of the Activation Id from the **Entitlement** table. | Equivalent to:- MAINT_ID_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## Product

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **PRODUCT_ID** | Unique identifier in the database of the Activation Id from the **Entitlement** table. | Equivalent to:- PRODUCT_ID in SEC_VW_ENTITLEMENT view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |


## User

| **Field in Database** | Description | Equivalent To |
|  --- | --- | --- |
| **ID** | Unique identifier in the database. |  |
| **USER_ID** | Unique identifier in the database of the User Id from the **User** table. | Equivalent to:- ID in SEC_VW_USER view

 |
| **NAME** | Name of the custom attribute as defined in FlexNet Operations. |  |
| **VALUE** | Value of the custom attribute. |  |
| **DWH_LASTUPDATED_DATE** | The last date that the record was refreshed in the data warehouse. |  |
| **LASTMODIFIED** | Last timestamp the custom attribute was updated. |  |
| **REPORTING_ORDER** | Order in which the custom attribute was defined in FlexNet Operations. |  |
| **TYPE** | Data type of the custom attribute defined in FlexNet Operations. |  |