# ACTION: Activities - Name: `ACTION` - Catalog: `AccountView` - Label: Activities - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ACTION` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACT_ABS` | `string(80)` | Short description | ☐ | | | `ACT_ADDR` | `string(4)` | Address in country-dependent format (memo) | ☐ | | | `ACT_AGEND` | `boolean` | Calendar activity | ☐ | | | `ACT_CNG` | `boolean` | Updated by client | ☐ | | | `ACT_CODE` | `string(10)` | Activity number | ☐ | | | `ACT_DESC` | `string(4)` | Activity note | ☐ | | | `ACT_FINISH` | `datetime` | End date/time | ☐ | | | `ACT_OWN` | `string(10)` | Task performer | ☐ | | | `ACT_PRIOR` | `string(10)` | Priority | ☐ | | | `ACT_RESP` | `decimal` | Person responsible | ☐ | | | `ACT_SRC` | `decimal` | Original responsible person | ☐ | | | `ACT_START` | `datetime` | Start date/time | ☐ | | | `ACT_STAT` | `int32` | Activity status | ☐ | | | `AREA_MAIN` | `string(10)` | Act. main area | ☐ | | | `AREA_SUB` | `string(10)` | Act. sub-area | ☐ | | | `CALL_SRC` | `string(1)` | Source | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMPL_PERC` | `decimal` | Percentage completed | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CRS_NUM` | `string(10)` | Activity number | ☐ | | | `DEF_NR` | `string(5)` | Issue code | ☐ | | | `DUE_DATE` | `datetime` | Target date for task completion | ☐ | | | `EMP_NR` | `string(10)` | Employee | ☐ | | | `END_DATE` | `datetime` | End Date | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `MAIL_BUS` | `string(50)` | Business email | ☐ | | | `MSG_DATA` | `string(4)` | Processed messages | ☐ | | | `OPP_CODE` | `string(10)` | Opportunity | ☐ | | | `OTLK_KEY` | `string(32)` | Unique key of message in Outlook | ☐ | | | `OTLK_MSG` | `string(4)` | Outlook message (XML) | ☐ | | | `PAR_XML` | `string(4)` | Parameters | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PP_CODE` | `string(10)` | Contact Person | ☐ | | | `PP_GENDER` | `string(10)` | Contact person gender | ☐ | | | `PREV_ACTID` | `string(10)` | Previous activity | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `REP_INTERV` | `decimal` | Interval | ☐ | | | `REP_TYPE` | `decimal` | Activity recurrence | ☐ | | | `REPR_TY` | `decimal` | Repeatability | ☐ | | | `RET_CALL` | `string(20)` | Call-back number | ☐ | | | `START_DATE` | `datetime` | Start date | ☐ | | | `SUB_NR` | `string(10)` | Company | ☐ | | | `TIM_ID` | `string(10)` | Time registration line identification | ☐ | | | `TIM_POST` | `boolean` | Post to time registration | ☐ | | | `TRAV_FIN` | `int32` | Travel time end | ☐ | | | `TRAV_START` | `int32` | Travel time start | ☐ | | | `VIS_ADDRES` | `string(4)` | Visiting address in country-dependent format (memo) | ☐ | |