Documentation
Difficulty level:
Columns Event
The columns for the context event.
These are auto generated.
| Technical name | Display | Selectable | Searchable | Type | Entity |
|---|---|---|---|---|---|
| EVENT_ID | Course id | Yes | Yes | Text | |
| OBJ_ID | Coursetype id | Yes | No | Number | Coursetype |
| OBJ_DESC | Coursetype | Yes | No | Text | Coursetype |
| OBJ_LONG_DESC | Coursetype long description | Yes | No | Text | Coursetype |
| OBJ_OWNERID | Coursetype ownerid | Yes | Yes | Number | |
| EVENT_DATE | Date | Yes | Yes | Date | |
| EVENT_FROMTIME | from | Yes | Yes | Time | |
| EVENT_TILLTIME | till | Yes | Yes | Time | |
| REX_ID | Location id | Yes | No | Number | |
| EVENT_NAME | Course name | Yes | Yes | Text | |
| EVENT_DESC | Course description | Yes | Yes | Text | |
| EVENT_LONG_DESC | Long description | Yes | Yes | Text | |
| EVENT_LONG_MEMO | Course memo | Yes | Yes | Text | |
| REX_DESC | Location description | Yes | No | Text | Resource |
| REX_EXTERNAL_ID | REX_EXTERNAL_ID | Yes | No | Text | Resource |
| NUMBER_OF_PLACES | Number of places | Yes | Yes | Number | |
| NUMBER_OF_FREE | Number of free places | Yes | Yes | Number | |
| NUMBER_OF_WAITING | Waiting list | Yes | Yes | Number | |
| NUMBER_OF_WAITINGFREE | free places on waitinglist | Yes | Yes | Number | |
| EVENT_LABELS | Course Labels | Yes | Yes | Text | |
| OBJ_LABELS | Coursetype Labels | Yes | Yes | Text | Coursetype |
| EVENT_CUSTOM01 | Course Custom 01 | Yes | Yes | Custom | |
| EVENT_CUSTOM02 | Course Custom 02 | Yes | Yes | Custom | |
| EVENT_CUSTOM03 | Course Custom 03 | Yes | Yes | Custom | |
| EVENT_CUSTOM04 | Course Custom 04 | Yes | Yes | Custom | |
| EVENT_CUSTOM05 | Course Custom 05 | Yes | Yes | Custom | |
| EVENT_CUSTOM06 | Course Custom 06 | Yes | Yes | Custom | |
| EVENT_CUSTOM07 | Course Custom 07 | Yes | Yes | Custom | |
| EVENT_CUSTOM08 | Course Custom 08 | Yes | Yes | Custom | |
| EVENT_CUSTOM09 | Course Custom 09 | Yes | Yes | Custom | |
| EVENT_CUSTOM10 | Course Custom 10 | Yes | Yes | Custom | |
| EVENT_CUSTOM11 | Course Custom 11 | Yes | Yes | Custom | |
| EVENT_CUSTOM12 | Course Custom 12 | Yes | Yes | Custom | |
| EVENT_CUSTOM13 | Course Custom 13 | Yes | Yes | Custom | |
| EVENT_CUSTOM14 | Course Custom 14 | Yes | Yes | Custom | |
| EVENT_CUSTOM15 | Course Custom 15 | Yes | Yes | Custom | |
| EVENT_CUSTOM16 | Course Custom 16 | Yes | Yes | Custom | |
| EVENT_CUSTOM17 | Course Custom 17 | Yes | Yes | Custom | |
| EVENT_CUSTOM18 | Course Custom 18 | Yes | Yes | Custom | |
| EVENT_CUSTOM19 | Course Custom 19 | Yes | Yes | Custom | |
| EVENT_CUSTOM20 | Course Custom 20 | Yes | Yes | Custom | |
| EVENT_CUSTOM21 | Course Custom 21 | Yes | Yes | Custom | |
| EVENT_CUSTOM22 | Course Custom 22 | Yes | Yes | Custom | |
| EVENT_CUSTOM23 | Course Custom 23 | Yes | Yes | Custom | |
| EVENT_CUSTOM24 | Course Custom 24 | Yes | Yes | Custom | |
| EVENT_CUSTOM25 | Course Custom 25 | Yes | Yes | Custom | |
| EVENT_CUSTOM26 | Course Custom 26 | Yes | Yes | Custom | |
| EVENT_CUSTOM27 | Course Custom 27 | Yes | Yes | Custom | |
| EVENT_CUSTOM28 | Course Custom 28 | Yes | Yes | Custom | |
| EVENT_CUSTOM29 | Course Custom 29 | Yes | Yes | Custom | |
| EVENT_CUSTOM30 | Course Custom 30 | Yes | Yes | Custom | |
| OBJ_TXT_CUSTOM01 | Coursetype Custom 01 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM02 | Coursetype Custom 02 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM03 | Coursetype Custom 03 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM04 | Coursetype Custom 04 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM05 | Coursetype Custom 05 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM06 | Coursetype Custom 06 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM07 | Coursetype Custom 07 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM08 | Coursetype Custom 08 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM09 | Coursetype Custom 09 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM10 | Coursetype Custom 10 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM11 | Coursetype Custom 11 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM12 | Coursetype Custom 12 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM13 | Coursetype Custom 13 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM14 | Coursetype Custom 14 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM15 | Coursetype Custom 15 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM16 | Coursetype Custom 16 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM17 | Coursetype Custom 17 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM18 | Coursetype Custom 18 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM19 | Coursetype Custom 19 | Yes | Yes | Custom | Coursetype |
| OBJ_TXT_CUSTOM20 | Coursetype Custom 20 | Yes | Yes | Custom | Coursetype |
| BOOK_EVENT | BOOK EVENT | Yes | No | Text | |
| OBJ_NONBOOKABLE | Coursetype nonbookable | Yes | No | Text | |
| CREATED | Created | Yes | Yes | Datetime | |
| UPDATED | updated | Yes | Yes | Datetime | |
| EVENT_STATUSCODE | Event status code | Yes | No | Text | |
| EVENT_STATUSDESC | Event status | Yes | No | Text | |
| EVENT_STATUSNAME | Event status (name) | Yes | No | Text | |
| DEFAULT_IMAGE | Default image | Yes | No | Text | |
| OBJECT_IMAGE | OBJECT_IMAGE | Yes | No | Text | |
| SERIES_ID | Series # | Yes | Yes | Number | Series |
| SERIES_START | Series start date | Yes | Yes | Date | Series |
| SERIES_END | Series end date | Yes | Yes | Date | Series |
| SERIES_DESCRIPTION | Series description | Yes | Yes | Text | Series |
| SERIES_PRICE | Series price | Yes | Yes | Currency | Series |
| SERIES_CURRENCY | Series currency | Yes | Yes | Text | Series |
| SERIES_TYPE | Series type | Yes | Yes | Text | Series |
| SERIES_FIRST | Series first | Yes | Yes | Text | Series |
| GROUP_ID | Group ID | Yes | Yes | Number | Group |
| GROUP_NAME | Group name | Yes | Yes | Text | Group |
| GROUP_DESC | Group | Yes | Yes | Text | Group |
| GROUP_LONG_DESC | Group extended | Yes | Yes | Text | Group |
| FRANCHISE_ID | Franchise # | Yes | Yes | Number | franchise |
| FRANCHISE_NAME | Franchise | Yes | Yes | Text | franchise |
| FRANCHISE_DESC | Franchise description | Yes | Yes | Text | franchise |
| FRANCHISE_LONG_DESC | Franchise long description | Yes | Yes | Text | franchise |
| FRANCHISE_EMAIL | Franchise email | Yes | Yes | Text | franchise |
| FRANCHISE_TEL | Franchise phone | Yes | Yes | Text | franchise |
| FRANCHISE_FAX | Franchise fax | Yes | Yes | Text | franchise |
| FRANCHISE_POSTAL | Franchise postal | Yes | Yes | Text | franchise |
| FRANCHISE_HOUSENUM | Franchise house number | Yes | Yes | Text | franchise |
| FRANCHISE_HOUSENUMEXT | Franchise house number | Yes | Yes | Text | franchise |
| FRANCHISE_ADDRESS1 | Franchise address | Yes | Yes | Text | franchise |
| FRANCHISE_ADDRESS2 | Franchise address 2 | Yes | Yes | Text | franchise |
| FRANCHISE_ADDRESS3 | Franchise address 3 | Yes | Yes | Text | franchise |
| FRANCHISE_CITY | Franchise city | Yes | Yes | Text | franchise |
| FRANCHISE_COUNTRY | Franchise country | Yes | Yes | Text | franchise |
| PEOPLE_REMARK | Remark | Yes | Yes | Text | People |
| PEOPLE_USER | Username | Yes | Yes | Text | People |
| PEOPLE_ID | # | Yes | Yes | Number | People |
| PEOPLE_INITIALS | Initials | Yes | Yes | Text | People |
| PEOPLE_PREFIX | Prefix | Yes | Yes | Text | People |
| PEOPLE_LASTNAME | Last name | Yes | Yes | Text | People |
| PEOPLE_SEX | Gender | Yes | Yes | Text | People |
| PEOPLE_NUMBER | Number | Yes | Yes | Text | People |
| PEOPLE_NOTES | Notes | Yes | Yes | Text | People |
| PEOPLE_EXPERIENCE | Experience | Yes | Yes | Text | People |
| PEOPLE_EDUCATION | Education | Yes | Yes | Text | People |
| PEOPLE_IBAN | IBAN | Yes | Yes | Iban | People |
| PEOPLE_FULLNAME | Name | Yes | No | Text | People |
| PRODUCT | Coursetype | No | Yes | ||
| PRODUCT_DESC | PRODUCT_DESC | No | Yes | ||
| LOCATION | Location | No | Yes | ||
| LOCATION_DESC | Location description of the booking | No | Yes | Text | |
| STATUS | Status# | No | Yes | ||
| COMMENT | Comment | No | Yes |
