Factset · Schema
TableField
FinancialFinancial DataInvestment AnalyticsMarket DataPortfolio AnalyticsResearch
Properties
| Name | Type | Description |
|---|---|---|
| id | string | Unique identifier for a combination of table and data field |
| dataItemId | string | Unique identifier for the data item |
| name | string | Name of the data field |
| dataType | string | Data type of the data field |
| position | integer | Column position of the data field within the table |
| isPrimaryKey | boolean | Flag indicating if the data field is a primary key. |
| nullable | boolean | Flag indicating if a data field is nullable |
| hasCodeDependency | boolean | Flag indicating if the field's value is determined by a code value in its row. The monetary, splitAffected and unitFactor fields for that value will also be inherited from the code. |
| monetary | boolean | Flag indicating if the data field contained in this TableField is monetary. If true, this field can have exchange rates applied to convert to other currencies |
| splitAffected | boolean | Flag indicating if the data field contained in this TableField can be affected by splits |
| unitFactor | string | Factor to indicate what units that the data field is displayed in. If null, the field does not need to have a factor applied to obtain the real value |
| description | string | A description of the data field within the context of its table |