# ArticleSettings: Twinfield Item settings - Catalog: `Twinfield` - Schema: `Views` - Label: Item settings This is a read-only view. The Twinfield API may not support changing the data or the Invantive UniversalSQL driver for Twinfield does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Twinfield API. ## View Columns The columns of the view `ArticleSettings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ALLOWCHANGEPERFORMANCETYPE` | `char` | Allow change performance type | ☐ | | | `ALLOWCHANGEUNITSPRICE` | `char` | Allow change units price | ☐ | | | `ALLOWCHANGEVATCODE` | `char` | Allow change VAT code | ☐ | | | `ALLOWDECIMALQUANTITY` | `char` | Allow decimal quantity | ☐ | | | `ALLOWDISCOUNTORPREMIUM` | `char` | Allow discount or premium | ☐ | | | `CODE` | `varchar2` | Code | ☑ | | | `COMPANY_CODE` | `varchar2` | Company ID | ☑ | | | `COMPANY_NAME` | `varchar2` | Company Name | ☑ | | | `NAME` | `varchar2` | Name | ☐ | | | `OFFICE` | `varchar2` | Office | ☐ | Company the item belongs to. | | `PERCENTAGE` | `double` | Percentage | ☐ | | | `PERFORMANCETYPE` | `varchar2` | Performance type | ☐ | Either services or goods. | | `SHORTNAME` | `varchar2` | Short Name | ☐ | | | `STATUS` | `varchar2` | Status | ☐ | One of active, deleted or hide. | | `TYPE` | `varchar2` | Type | ☐ | One of normal, discount or premium. | | `UNITNAMEPLURAL` | `varchar2` | Unit name plural | ☐ | | | `UNITNAMESINGULAR` | `varchar2` | Unit name singular | ☐ | | | `VATCODE` | `varchar2` | VAT code | ☐ | |