# ExtraFieldDefinitions: Exact Online Extra Field Definitions ## Documentation: List of additional fields defined on Items. Also known as "Extra fields" or "Free fields". The actual values for the additional fields are available in the ExactOnlineXML table "Items". They are not made available by Invantive through the REST API, since the REST API "ItemExtraField" requires one call for each Item which would quickly deplete the allowance of API requests. The REST API "Items" has no values for the free fields currently.chr(13) || chr(10) || chr(13) || chr(10)chr(13) || chr(10) || chr(13) || chr(10)Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- division - Catalog: `ExactOnlineXML` - Schema: `XML` - Label: Extra Field Definitions The data in this table is partitioned per value of the `Division` column. - Retrieve: True - Insert: True - Update: True - Delete: False - Filters on API Server: division ## Table Columns The columns of the table `ExtraFieldDefinitions` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DIVISION_CODE` | `varchar2` | Administration ID | ☑ | Internal unique number of the Exact Online administration. | | `DIVISION_HID` | `int64` | Administration | ☑ | Number of the Exact Online administration. Not guaranteed to be unique. | | `DIVISION_NAME` | `varchar2`(240) | Administration Name | ☑ | Name of the Exact Online administration. Not guaranteed to be unique. | | `ENTITYTYPE_ATTR` | `varchar2` | Entity Type | | 1=Item | | `FIELDNUMBER1_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER1_DESCRIPTION` | `varchar2`(255) | Field #1 Description | | | | `FIELDNUMBER1_TYPE_ATTR` | `varchar2` | Field #1 Type | | 4=Text 7=List | | `FIELDNUMBER1_USEINSEARCH` | `boolean` | Field #1 Use in Search | | | | `FIELDNUMBER1_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER10_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER10_DESCRIPTION` | `varchar2`(255) | Field #10 Description | | | | `FIELDNUMBER10_TYPE_ATTR` | `varchar2` | Field #10 Type | | 4=Text 7=List | | `FIELDNUMBER10_USEINSEARCH` | `boolean` | Field #10 Use in Search | | | | `FIELDNUMBER10_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER2_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER2_DESCRIPTION` | `varchar2`(255) | Field #2 Description | | | | `FIELDNUMBER2_TYPE_ATTR` | `varchar2` | Field #2 Type | | 4=Text 7=List | | `FIELDNUMBER2_USEINSEARCH` | `boolean` | Field #2 Use in Search | | | | `FIELDNUMBER2_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER3_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER3_DESCRIPTION` | `varchar2`(255) | Field #3 Description | | | | `FIELDNUMBER3_TYPE_ATTR` | `varchar2` | Field #3 Type | | 4=Text 7=List | | `FIELDNUMBER3_USEINSEARCH` | `boolean` | Field #3 Use in Search | | | | `FIELDNUMBER3_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER4_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER4_DESCRIPTION` | `varchar2`(255) | Field #4 Description | | | | `FIELDNUMBER4_TYPE_ATTR` | `varchar2` | Field #4 Type | | 4=Text 7=List | | `FIELDNUMBER4_USEINSEARCH` | `boolean` | Field #4 Use in Search | | | | `FIELDNUMBER4_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER5_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER5_DESCRIPTION` | `varchar2`(255) | Field #5 Description | | | | `FIELDNUMBER5_TYPE_ATTR` | `varchar2` | Field #5 Type | | 4=Text 7=List | | `FIELDNUMBER5_USEINSEARCH` | `boolean` | Field #5 Use in Search | | | | `FIELDNUMBER5_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER6_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER6_DESCRIPTION` | `varchar2`(255) | Field #6 Description | | | | `FIELDNUMBER6_TYPE_ATTR` | `varchar2` | Field #6 Type | | 4=Text 7=List | | `FIELDNUMBER6_USEINSEARCH` | `boolean` | Field #6 Use in Search | | | | `FIELDNUMBER6_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER7_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER7_DESCRIPTION` | `varchar2`(255) | Field #7 Description | | | | `FIELDNUMBER7_TYPE_ATTR` | `varchar2` | Field #7 Type | | 4=Text 7=List | | `FIELDNUMBER7_USEINSEARCH` | `boolean` | Field #7 Use in Search | | | | `FIELDNUMBER7_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER8_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER8_DESCRIPTION` | `varchar2`(255) | Field #8 Description | | | | `FIELDNUMBER8_TYPE_ATTR` | `varchar2` | Field #8 Type | | 4=Text 7=List | | `FIELDNUMBER8_USEINSEARCH` | `boolean` | Field #8 Use in Search | | | | `FIELDNUMBER8_USETRANSLATIONS` | `boolean` | | | | | `FIELDNUMBER9_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `FIELDNUMBER9_DESCRIPTION` | `varchar2`(255) | Field #9 Description | | | | `FIELDNUMBER9_TYPE_ATTR` | `varchar2` | Field #9 Type | | 4=Text 7=List | | `FIELDNUMBER9_USEINSEARCH` | `boolean` | Field #9 Use in Search | | | | `FIELDNUMBER9_USETRANSLATIONS` | `boolean` | | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. |