# Assets: Twinfield Assets - Catalog: `Twinfield` - Schema: `Dimensions` - Label: Assets The data in this table is partitioned per value of the `COMPANY_CODE` column. This is a read-only table. 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. ## Table Columns The columns of the table `Assets` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BEGINPERIOD` | `int16` | Begin Period | ☑ | | | `BEGINYEAR` | `int16` | Begin Year | ☑ | | | `BEHAVIOUR` | `varchar2` | Behaviour | ☑ | | | `COCNUMBER` | `varchar2` | CoC Number | ☐ | | | `CODE` | `varchar2` | Code | ☑ | | | `COMPANY_CODE` | `varchar2` | Company ID | ☑ | | | `COMPANY_NAME` | `varchar2` | Company Name | ☑ | | | `EDITDIMENSIONNAME` | `char` | Edit Dimension Name | ☑ | | | `ENDPERIOD` | `int16` | End Period | ☑ | | | `ENDYEAR` | `int16` | End Year | ☑ | | | `FINANCIALS_ACCOUNTTYPE` | `varchar2` | Account Type | ☑ | | | `FINANCIALS_COLLECTIONSCHEMA` | `varchar2` | Collection Schema | ☑ | | | `FINANCIALS_COLLECTMANDATE_ID` | `varchar2` | Collect Mandate ID | ☐ | | | `FINANCIALS_COLLECTMANDATE_SIGNATUREDATE` | `datetime` | Collect Mandate Signature Date | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_BASECREDITLIMIT` | `decimal` | Base Credit Limit | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_BLOCKED_LOCKED` | `char` | Blocked/Locked | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_BLOCKED_MODIFIED` | `varchar2` | Blocked Modified | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_BLOCKED` | `char` | Blocked | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_COMMENT` | `varchar2` | Comment | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_FREETEXT1` | `varchar2` | Free Text 1 | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_FREETEXT2` | `varchar2` | Free Text 2 | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_FREETEXT3` | `varchar2` | Free Text 3 | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_REMINDEREMAIL` | `varchar2` | Reminder Email | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER_NAME` | `varchar2` | Responsible User Name | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER_SHORTNAME` | `varchar2` | Responsible User Short Name | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER` | `varchar2` | Responsible User | ☐ | | | `FINANCIALS_CREDITMANAGEMENT_SENDREMINDER` | `char` | Send Reminder | ☐ | | | `FINANCIALS_DUEDAYS` | `int32` | Due Days | ☑ | | | `FINANCIALS_EBILLING` | `char` | Ebilling | ☑ | | | `FINANCIALS_EBILLMAIL` | `varchar2` | Ebill Mail | ☐ | Email address to send the invoice to. | | `FINANCIALS_LEVEL` | `int16` | Level | ☑ | | | `FINANCIALS_MATCHTYPE` | `varchar2` | Match Type | ☑ | | | `FINANCIALS_MEANSOFPAYMENT` | `varchar2` | Means of Payment | ☑ | | | `FINANCIALS_PAYAVAILABLE` | `char` | Pay Available | ☑ | | | `FINANCIALS_PAYCODE_NAME` | `varchar2` | Pay Code Name | ☐ | | | `FINANCIALS_PAYCODE_SHORTNAME` | `varchar2` | Pay Code Short Name | ☐ | | | `FINANCIALS_PAYCODE` | `varchar2` | Pay Code | ☐ | | | `FINANCIALS_RELATIONSREFERENCE` | `varchar2` | Relations Reference | ☐ | Customer reference, your customer number by the supplier. | | `FINANCIALS_SUBANALYSE` | `varchar2` | Sub-analyse | ☑ | | | `FINANCIALS_SUBSTITUTEWITH_DIMENSIONTYPE` | `varchar2` | Substitute with Dimension Type | ☐ | | | `FINANCIALS_SUBSTITUTEWITH_ID` | `guid` | Substitute with ID | ☐ | | | `FINANCIALS_SUBSTITUTEWITH_NAME` | `varchar2` | Substitute with Name | ☐ | | | `FINANCIALS_SUBSTITUTEWITH_SHORTNAME` | `varchar2` | Substitute with Short Name | ☐ | | | `FINANCIALS_SUBSTITUTEWITH` | `varchar2` | Substitute with | ☐ | | | `FINANCIALS_SUBSTITUTIONLEVEL` | `int16` | Substitution Level | ☑ | | | `FINANCIALS_VATCODE_FIXED` | `varchar2` | | ☐ | | | `FINANCIALS_VATCODE_NAME` | `varchar2` | | ☐ | | | `FINANCIALS_VATCODE_SHORTNAME` | `varchar2` | | ☐ | | | `FINANCIALS_VATCODE_TYPE` | `varchar2` | | ☐ | | | `FINANCIALS_VATCODE` | `varchar2` | VAT Code | ☐ | | | `FINANCIALS_VATOBLIGATORY` | `char` | VAT Obligatory | ☑ | | | `FINANCIALS_VATTYPE_NAME` | `varchar2` | VAT Type Name | ☐ | | | `FINANCIALS_VATTYPE_SHORTNAME` | `varchar2` | VAT Type Short Name | ☐ | | | `FINANCIALS_VATTYPE` | `varchar2` | VAT Type | ☐ | | | `FIXEDASSETS_BEGINPERIOD_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_BEGINPERIOD` | `varchar2` | Begin Period | ☐ | | | `FIXEDASSETS_FREETEXT1_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_FREETEXT1` | `varchar2` | Free Text 1 | ☐ | | | `FIXEDASSETS_FREETEXT2_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_FREETEXT2` | `varchar2` | Free Text 2 | ☐ | | | `FIXEDASSETS_FREETEXT3_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_FREETEXT3` | `varchar2` | Free Text 3 | ☐ | | | `FIXEDASSETS_FREETEXT4_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_FREETEXT4` | `varchar2` | Free Text 4 | ☐ | | | `FIXEDASSETS_FREETEXT5_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_FREETEXT5` | `varchar2` | Free Text 5 | ☐ | | | `FIXEDASSETS_METHOD_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_METHOD_NAME` | `varchar2` | Method Name | ☐ | | | `FIXEDASSETS_METHOD_SHORTNAME` | `varchar2` | Method Short Name | ☐ | | | `FIXEDASSETS_METHOD` | `varchar2` | Method | ☐ | | | `FIXEDASSETS_PURCHASEDATE_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_PURCHASEDATE` | `datetime` | Purchase Date | ☐ | | | `FIXEDASSETS_RESIDUALVALUE_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_RESIDUALVALUE` | `decimal` | Residual Value | ☑ | | | `FIXEDASSETS_SELLDATE_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_SELLDATE` | `datetime` | Sell Date | ☐ | | | `FIXEDASSETS_STATUS_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_STATUS` | `varchar2` | Status | ☑ | | | `FIXEDASSETS_STOPVALUE_LOCKED` | `char` | | ☑ | | | `FIXEDASSETS_STOPVALUE` | `decimal` | Stop Value | ☑ | | | `INUSE` | `char` | In Use | ☑ | Have financial transactions been posted to this dimension. | | `MODIFIED` | `datetime` | Modified | ☑ | | | `NAME` | `varchar2` | Name | ☐ | | | `REMITTANCEADVICE_SENDMAIL` | `varchar2` | Send Mail | ☐ | | | `REMITTANCEADVICE_SENDTYPE` | `varchar2` | Send Type | ☐ | | | `SHORTNAME` | `varchar2` | Short Name | ☐ | | | `STATUS` | `varchar2` | Status | ☑ | | | `TOUCHED` | `int16` | Touched | ☑ | | | `UID` | `guid` | UID | ☑ | | | `VATNUMBER` | `varchar2` | VAT Number | ☐ | | | `WEBSITE` | `varchar2` | Website | ☐ | |