# Activities: Twinfield Activities - Catalog: `Twinfield` - Schema: `Dimensions` - Label: Activities 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 `Activities` 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 | ☐ | | | `INUSE` | `char` | In Use | ☑ | Have financial transactions been posted to this dimension. | | `MODIFIED` | `datetime` | Modified | ☑ | | | `NAME` | `varchar2` | Name | ☐ | | | `PROJECTS_AUTHORISER_INHERIT` | `char` | | ☐ | | | `PROJECTS_AUTHORISER_LOCKED` | `char` | | ☐ | | | `PROJECTS_AUTHORISER` | `varchar2` | Authoriser | ☐ | | | `PROJECTS_BILLABLE_FORRATIO` | `char` | Billable for Ratio | ☐ | | | `PROJECTS_BILLABLE_INHERIT` | `char` | | ☐ | | | `PROJECTS_BILLABLE_LOCKED` | `char` | | ☐ | | | `PROJECTS_BILLABLE` | `char` | Billable | ☐ | | | `PROJECTS_CUSTOMER_INHERIT` | `char` | | ☐ | | | `PROJECTS_CUSTOMER_LOCKED` | `char` | | ☐ | | | `PROJECTS_CUSTOMER` | `varchar2` | Customer | ☐ | | | `PROJECTS_INVOICEDESCRIPTION` | `varchar2` | Invoice Description | ☐ | | | `PROJECTS_RATE_INHERIT` | `char` | | ☐ | | | `PROJECTS_RATE_LOCKED` | `char` | | ☐ | | | `PROJECTS_RATE` | `varchar2` | Rate | ☐ | The project (quantity) rate code. | | `PROJECTS_VALIDFROM` | `datetime` | Valid from | ☐ | | | `PROJECTS_VALIDTILL` | `varchar2` | Valid till | ☐ | | | `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 | ☐ | |