Documentation
Difficulty level:
Columns Booking
The columns for the context Booking.
These are auto generated.
| Technical name | Display | Selectable | Searchable | Type | Entity |
|---|---|---|---|---|---|
| RES_ID | Booking Id | Yes | No | Number | |
| RES_CUST_ID | Customer number | Yes | No | Number | |
| RES_OBJ_ID | coursetype ID | Yes | No | Text | |
| RES_COM_ID | Arrangement | Yes | No | Text | |
| OBJ_DESC | Coursetype | Yes | Yes | Text | |
| OBJ_NAME | Coursetype name | Yes | Yes | Text | |
| OBJ_SHORT_DESC | Coursetype short description | Yes | Yes | Text | |
| OBJ_LONG_DESC | Coursetype long description | Yes | Yes | Text | |
| OBJ_LONG_MEMO | Coursetype long memo | Yes | Yes | Text | |
| OBJ_ISMAINOBJ | Coursetype ismainobj | Yes | Yes | Text | |
| OBJ_MAINOBJID | Coursetype mainobj# | Yes | Yes | Text | |
| OBJ_OWNERID | Coursetype ownerid | Yes | Yes | Text | |
| COM_DESC | Description | Yes | Yes | Text | Arrangement |
| COM_NAME | Name | Yes | Yes | Text | Arrangement |
| COM_SHORT_DESC | Short | Yes | Yes | Text | Arrangement |
| COM_LONG_DESC | Long desc | Yes | Yes | Text | Arrangement |
| COM_LONG_MEMO | Memo | Yes | Yes | Text | Arrangement |
| COM_OWNERID | Ownerid | Yes | Yes | Text | |
| RES_FROMDATE | From date | Yes | No | Date | |
| RES_TILLDATE | Till date | Yes | No | Date | |
| RES_FROMTIME | From time | Yes | No | Time | |
| RES_TILTIME | Till time | Yes | No | Time | |
| RES_STATUS | Status | Yes | No | Text | |
| RES_STATUSBGCOLOR | Status background color | Yes | No | Text | |
| RES_STATUSTEXTCOLOR | Status text color | Yes | No | Text | |
| RES_STATUSCODE | Status code | Yes | No | Text | |
| RES_STATUSDESC | Status (desc) | Yes | No | Text | |
| RES_STATUSNAME | Status (name) | Yes | No | Text | |
| RES_LABELS | Booking Labels | Yes | Yes | Text | |
| CUST_LABELS | Customer Labels | Yes | Yes | Text | Customer |
| COMP_LABELS | Company Labels | Yes | Yes | Text | Company |
| RES_CUSTOM01 | Booking Custom 01 | Yes | Yes | Custom | |
| RES_CUSTOM02 | Booking Custom 02 | Yes | Yes | Custom | |
| RES_CUSTOM03 | Booking Custom 03 | Yes | Yes | Custom | |
| RES_CUSTOM04 | Booking Custom 04 | Yes | Yes | Custom | |
| RES_CUSTOM05 | Booking Custom 05 | Yes | Yes | Custom | |
| RES_CUSTOM06 | Booking Custom 06 | Yes | Yes | Custom | |
| RES_CUSTOM07 | Booking Custom 07 | Yes | Yes | Custom | |
| RES_CUSTOM08 | Booking Custom 08 | Yes | Yes | Custom | |
| RES_CUSTOM09 | Booking Custom 09 | Yes | Yes | Custom | |
| RES_CUSTOM10 | Booking Custom 10 | Yes | Yes | Custom | |
| RES_CUSTOM11 | Booking Custom 11 | Yes | Yes | Custom | |
| RES_CUSTOM12 | Booking Custom 12 | Yes | Yes | Custom | |
| RES_CUSTOM13 | Booking Custom 13 | Yes | Yes | Custom | |
| RES_CUSTOM14 | Booking Custom 14 | Yes | Yes | Custom | |
| RES_CUSTOM15 | Booking Custom 15 | Yes | Yes | Custom | |
| RES_CUSTOM16 | Booking Custom 16 | Yes | Yes | Custom | |
| RES_CUSTOM17 | Booking Custom 17 | Yes | Yes | Custom | |
| RES_CUSTOM18 | Booking Custom 18 | Yes | Yes | Custom | |
| RES_CUSTOM19 | Booking Custom 19 | Yes | Yes | Custom | |
| RES_CUSTOM20 | Booking Custom 20 | Yes | Yes | Custom | |
| RES_CUSTOM21 | Booking Custom 21 | Yes | Yes | Custom | |
| RES_CUSTOM22 | Booking Custom 22 | Yes | Yes | Custom | |
| RES_CUSTOM23 | Booking Custom 23 | Yes | Yes | Custom | |
| RES_CUSTOM24 | Booking Custom 24 | Yes | Yes | Custom | |
| RES_CUSTOM25 | Booking Custom 25 | Yes | Yes | Custom | |
| RES_CUSTOM26 | Booking Custom 26 | Yes | Yes | Custom | |
| RES_CUSTOM27 | Booking Custom 27 | Yes | Yes | Custom | |
| RES_CUSTOM28 | Booking Custom 28 | Yes | Yes | Custom | |
| RES_CUSTOM29 | Booking Custom 29 | Yes | Yes | Custom | |
| RES_CUSTOM30 | Booking Custom 30 | Yes | Yes | Custom | |
| DEFAULT_IMAGE | Default image | Yes | No | Text | |
| RES_ANON | Anonimised (booking) | Yes | Yes | Text | Booking |
| RES_ANONDATE | Date anonimised (booking) | Yes | Yes | Text | Booking |
| CUST_ANON | Anonimised | Yes | Yes | Text | Customer |
| CUST_ANONDATE | Date anonimised | Yes | Yes | Text | Customer |
| CUST_CUSTOM01 | Customer custom 01 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM02 | Customer custom 02 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM03 | Customer custom 03 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM04 | Customer custom 04 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM05 | Customer custom 05 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM06 | Customer custom 06 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM07 | Customer custom 07 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM08 | Customer custom 08 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM09 | Customer custom 09 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM10 | Customer custom 10 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM11 | Customer custom 11 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM12 | Customer custom 12 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM13 | Customer custom 13 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM14 | Customer custom 14 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM15 | Customer custom 15 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM16 | Customer custom 16 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM17 | Customer custom 17 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM18 | Customer custom 18 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM19 | Customer custom 19 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM20 | Customer custom 20 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM21 | Customer custom 21 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM22 | Customer custom 22 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM23 | Customer custom 23 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM24 | Customer custom 24 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM25 | Customer custom 25 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM26 | Customer custom 26 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM27 | Customer custom 27 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM28 | Customer custom 28 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM29 | Customer custom 29 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM30 | Customer custom 30 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM31 | Customer custom 31 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM32 | Customer custom 32 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM33 | Customer custom 33 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM34 | Customer custom 34 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM35 | Customer custom 35 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM36 | Customer custom 36 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM37 | Customer custom 37 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM38 | Customer custom 38 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM39 | Customer custom 39 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM40 | Customer custom 40 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM41 | Customer custom 41 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM42 | Customer custom 42 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM43 | Customer custom 43 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM44 | Customer custom 44 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM45 | Customer custom 45 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM46 | Customer custom 46 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM47 | Customer custom 47 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM48 | Customer custom 48 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM49 | Customer custom 49 | Yes | Yes | Custom | Customer |
| CUST_CUSTOM50 | Customer custom 50 | Yes | Yes | Custom | Customer |
| CUST_FULLNAME | Customer name | Yes | No | Text | Customer |
| CUST_SHORTNAME | Customer Short | Yes | No | Text | Customer |
| CUST_INFORMALNAME | Customer informal | Yes | No | Text | Customer |
| LOC_DESC | Location | Yes | No | Text | Resource |
| LOCATION_DESC | Location description of the booking | Yes | Yes | Text | Resource |
| LOCATION_LONG_DESC | Location extended | Yes | No | Text | Resource |
| SETUP_DESC | Room setup | Yes | Yes | Text | Resource |
| SETUP_LONG_DESC | Room setup * | Yes | No | Text | Resource |
| CREATED | Created | Yes | Yes | Datetime | Reservation |
| UPDATED | updated | Yes | Yes | Datetime | Reservation |
| STRUCTURE | Structure | Yes | Yes | Text | Reservation |
| RES_COMBI | Combi booking | Yes | No | Number | Reservation |
| RES_ADD | Additional booking | Yes | No | Number | Reservation |
| RES_MAIN | Main booking | Yes | No | Number | Reservation |
| RES_SERIES | Serie booking | Yes | No | Number | Reservation |
| NEWS_LETTER | Newsletter | Yes | No | Text | Customer |
| EXPORT | EXPORT | Yes | Yes | Text | |
| NUMBER | Number | Yes | Yes | Number | Reservation |
| TOTAL_PRICE | Total price | Yes | Yes | Currency | Reservation |
| CURRENCY | Currency | Yes | Yes | Text | Reservation |
| FEE | Fee | Yes | Yes | Currency | Reservation |
| TOTAL_PRICE_WITHOUT_OPTIONS | Price without options | Yes | Yes | Currency | Reservation |
| SUM_VAT | Sum VAT | Yes | Yes | Currency | Reservation |
| SUM_FEE | Sum FEE | Yes | Yes | Currency | Reservation |
| SUM_OPT | Sum options | Yes | Yes | Currency | Reservation |
| SUM_MAN | Sum row | Yes | Yes | Currency | Reservation |
| SUM_DSC | Sum discount | Yes | Yes | Currency | Reservation |
| BAIL | Guarantee | Yes | Yes | Currency | Reservation |
| PAID | Paid | Yes | Yes | Currency | Reservation |
| TO_PAY | To be Paid | Yes | Yes | Currency | Reservation |
| PAYCURRENCY | Pay currency | Yes | Yes | Text | Reservation |
| REFERENCE | Reference | Yes | Yes | Text | Reservation |
| COMP_REMARKS | Internal remarks | Yes | Yes | Text | Reservation |
| REMARKS | Remarks | Yes | Yes | Text | Reservation |
| EXTERNAL_ID | External ID | Yes | Yes | Text | Reservation |
| CHANNEL | Channel | Yes | Yes | Text | Reservation |
| SUBCHANNEL | Subchannel | Yes | Yes | Text | Reservation |
| CNT_DETAILS | # Details | Yes | Yes | Number | Reservation |
| CNT_OPTIONS | # Options | Yes | Yes | Number | Reservation |
| CNT_PARTICIPANTS | # Participant | Yes | Yes | Number | Reservation |
| CNT_PLAYERS | # Players | Yes | Yes | Number | Reservation |
| CREDITS | Credits | Yes | Yes | Number | Reservation |
| HOURS | Hours | Yes | Yes | Number | Reservation |
| MINUTES | Minutes | Yes | Yes | Number | Reservation |
| DAYS | Days | Yes | Yes | Number | Reservation |
| EVENT_CUSTOM01 | Course Custom 01 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM02 | Course Custom 02 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM03 | Course Custom 03 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM04 | Course Custom 04 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM05 | Course Custom 05 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM06 | Course Custom 06 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM07 | Course Custom 07 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM08 | Course Custom 08 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM09 | Course Custom 09 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM10 | Course Custom 10 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM11 | Course Custom 11 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM12 | Course Custom 12 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM13 | Course Custom 13 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM14 | Course Custom 14 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM15 | Course Custom 15 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM16 | Course Custom 16 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM17 | Course Custom 17 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM18 | Course Custom 18 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM19 | Course Custom 19 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM20 | Course Custom 20 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM21 | Course Custom 21 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM22 | Course Custom 22 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM23 | Course Custom 23 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM24 | Course Custom 24 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM25 | Course Custom 25 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM26 | Course Custom 26 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM27 | Course Custom 27 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM28 | Course Custom 28 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM29 | Course Custom 29 | Yes | Yes | Custom | Course |
| EVENT_CUSTOM30 | Course Custom 30 | Yes | Yes | Custom | Course |
| 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 |
| OPTION_ID | Option ID | Yes | Yes | Text | Option |
| OPTION_NUMBER | Option number | Yes | Yes | Number | Option |
| OPTION_MAX_NUMBER | Option max number | Yes | Yes | Number | Option |
| OPTION_NAME | Option name | Yes | Yes | Text | Option |
| OPTION_DESC | Option desc | Yes | Yes | Text | Option |
| OPTION_GROUP | Option group | Yes | Yes | Text | Option |
| OPTION_PRICE | Option price | Yes | Yes | Currency | Option |
| OPTION_CURRENCY | Option currency | Yes | Yes | Text | Option |
| OPTION_CHANGED | Option changed | Yes | Yes | Datetime | Option |
| PARTICIPANT_ID | Participant # | Yes | Yes | Text | Participant |
| PARTICIPANT_NAME | Name | Yes | Yes | Text | Participant |
| PARTICIPANT_DESC | Description | Yes | Yes | Text | Participant |
| PARTICIPANT_PRESENT | Present | Yes | Yes | Text | Participant |
| PARTICIPANT_INITIALS | Initials | Yes | Yes | Text | Participant |
| PARTICIPANT_FIRSTNAME | First name | Yes | Yes | Text | Participant |
| PARTICIPANT_PREFIX | Prefix | Yes | Yes | Text | Participant |
| PARTICIPANT_LASTNAME | Lastname | Yes | Yes | Text | Participant |
| PARTICIPANT_EMAIL | Yes | Yes | Text | Participant | |
| PARTICIPANT_TEL_MOB | Phone | Yes | Yes | Text | Participant |
| PARTICIPANT_SEX | Gender | Yes | Yes | Sex | Participant |
| PARTICIPANT_BIRTHDATE | Birthdate | Yes | Yes | Text | Participant |
| PARTICIPANT_MEMBERNUMBER | Membernumber | Yes | Yes | Text | Participant |
| PARTICIPANT_ID_NUMBER | ID number | Yes | Yes | Text | Participant |
| PARTICIPANT_ID_TYPE | ID type | Yes | Yes | Text | Participant |
| PARTICIPANT_CUSTOM01 | Custom 01 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM02 | Custom 02 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM03 | Custom 03 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM04 | Custom 04 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM05 | Custom 05 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM06 | Custom 06 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM07 | Custom 07 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM08 | Custom 08 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM09 | Custom 09 | Yes | Yes | Custom | Participant |
| PARTICIPANT_CUSTOM10 | Custom 10 | Yes | Yes | Custom | Participant |
| PS_ID | schema # | Yes | Yes | Text | Payment schedule |
| PS_STATUS | status | Yes | Yes | Text | Payment schedule |
| PS_NAME | name | Yes | Yes | Text | Payment schedule |
| PS_DESC | description | Yes | Yes | Text | Payment schedule |
| PS_DAY | day | Yes | Yes | Date | Payment schedule |
| PS_TIME | time | Yes | Yes | Time | Payment schedule |
| PS_PRICE | price | Yes | Yes | Text | Payment schedule |
| PS_CURRENCY | currency | Yes | Yes | Text | Payment schedule |
| PS_PAID | paid | Yes | Yes | Text | Payment schedule |
| PS_PAYMENT_METHOD | payment method | Yes | Yes | Text | Payment schedule |
| PS_REMARKS | remarks | Yes | Yes | Text | Payment schedule |
| PLAYER_CUST_ID | Customer # | Yes | Yes | Text | Player |
| PLAYER_GUEST | Guest | Yes | No | Text | Player |
| PLAYER_LASTNAME | Lastname | Yes | Yes | Text | Player |
| PLAYER_FULLNAME | Player | Yes | No | Text | Player |
| PLAYER_CONFIRMED | Confirmed | Yes | Yes | Text | Player |
| QUESTION_ID | Question ID | Yes | Yes | Text | Question |
| QUESTION_DESC | Question description | Yes | Yes | Text | Question |
| QUESTION | Question | Yes | Yes | Text | Question |
| DSP_TYPE | Question type | Yes | No | Text | Question |
| DSP_SETTINGS | Question settings | Yes | No | Text | Question |
| ANSWER | Answer | Yes | Yes | Text | Question |
| PAY_ID | Pay ID | Yes | Yes | Text | Payment |
| PAY_STATUS | Pay status | Yes | Yes | Text | Payment |
| PAY_TRANSACTION | Pay transaction | Yes | Yes | Text | Payment |
| PAY_AMOUNT | Pay amount | Yes | Yes | Currency | Payment |
| PAY_CURRENCY | Pay currency | Yes | Yes | Text | Payment |
| PAY_REMARKS | Pay remarks | Yes | Yes | Text | Payment |
| PAY_METHOD | Pay method | Yes | Yes | Text | Payment |
| PAY_DATE | Pay date | Yes | Yes | Date | |
| STATUS_FROM | Status from | Yes | Yes | Text | Status# |
| STATUS_FROMDESC | Status from (Description) | Yes | No | Text | Status# |
| STATUS_TO | Status to | Yes | Yes | Text | Status# |
| STATUS_TODESC | Status to (Description) | Yes | No | Text | Status# |
| STATUS_LANG | Status language | Yes | Yes | Text | Status# |
| STATUS_EMAILTEMPLATE | Status email template | Yes | Yes | Text | Status# |
| STATUS_EMAILTO | Status email to | Yes | Yes | Text | Status# |
| STATUS_EMAILSENT | Status email sent | Yes | Yes | Text | Status# |
| STATUS_SMSTEMPLATE | Status SMS template | Yes | Yes | Text | Status# |
| STATUS_SMSTO | Status SMS to | Yes | Yes | Text | Status# |
| STATUS_SMSSENT | Status SMS sent | Yes | Yes | Text | Status# |
| STATUS_REMARKS | Status remarks | Yes | Yes | Text | Status# |
| STATUS_SEND | Status executed | Yes | Yes | Datetime | Status# |
| GROUP_ID | Group ID | Yes | Yes | Text | 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 | Text | 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 | Country | franchise |
| CUST_SEX | Gender | Yes | Yes | Sex | Customer |
| CUST_SIGNUPDATE | Signupdate | Yes | Yes | Date | Customer |
| CUST_EXPIREDATE | Expiredate | Yes | Yes | Date | Customer |
| CUST_BIRTHDATE | Birthdate | Yes | Yes | Date | Customer |
| CUST_CITY | City | Yes | Yes | Text | Customer |
| CUST_COUNTRY | Country Id | Yes | Yes | Country | Customer |
| CUST_STATE | State | Yes | Yes | Text | Customer |
| CUST_POSTAL | Postal | Yes | Yes | Text | Customer |
| CUST_HOUSENUM | House Number | Yes | Yes | Text | Customer |
| CUST_HOUSENUMEXT | House No Ext | Yes | Yes | Text | Customer |
| CUST_ADDRESS1 | Address | Yes | No | Text | Customer |
| CUST_ADDRESS2 | Address line 2 | Yes | Yes | Text | Customer |
| CUST_ADDRESS3 | Address line 3 | Yes | Yes | Text | Customer |
| CUST_FIRSTNAME | Firstname | Yes | Yes | Text | Customer |
| CUST_INITIALS | Initials | Yes | Yes | Text | Customer |
| CUST_PREFIX | Prefix | Yes | Yes | Text | Customer |
| CUST_LASTNAME | Lastname | Yes | No | Text | Customer |
| CUST_EMAIL | Yes | Yes | Text | Customer | |
| CUST_TEL_HOME | Home phone | Yes | Yes | Text | Customer |
| CUST_TEL_MOB | Cell phone | Yes | Yes | Text | Customer |
| CUST_TEL_WORK | Work phone | Yes | Yes | Text | Customer |
| CUST_TEL_FAX | Fax | Yes | Yes | Text | Customer |
| CUST_FACT_STATE | Invoice state | Yes | Yes | Text | Customer |
| CUST_FACT_POSTAL | Invoice postal | Yes | Yes | Text | Customer |
| CUST_FACT_HOUSENUM | Invoice house number | Yes | Yes | Number | Customer |
| CUST_FACT_HOUSENUMEXT | Invoice house number extension | Yes | Yes | Text | Customer |
| CUST_FACT_ADDRESS1 | Invoice address | Yes | Yes | Text | Customer |
| CUST_FACT_ADDRESS2 | Invoice address 2 | Yes | Yes | Text | Customer |
| CUST_FACT_ADDRESS3 | Invoice address 3 | Yes | Yes | Text | Customer |
| CUST_FACT_CITY | Invoice city | Yes | Yes | Text | Customer |
| CUST_FACT_COUNTRY | Invoice country | Yes | Yes | Country | Customer |
| CUST_COMP_NAME | Company name | Yes | Yes | Text | Customer |
| CUST_COMP_TEL | Company phone | Yes | Yes | Text | Customer |
| CUST_COMP_FAX | C-Fax | Yes | Yes | Text | Customer |
| CUST_MEMBER_ID | Member ID | Yes | Yes | Text | Customer |
| CUST_ID_NUMBER | ID Number | Yes | Yes | Text | Customer |
| CUST_ID_TYPE | ID type | Yes | Yes | Text | Customer |
| CUST_STUDENT | Student | Yes | Yes | Text | Customer |
| CUST_BANKNAME | Bank | Yes | Yes | Text | Customer |
| CUST_BANKACCOUNT | Bankaccount | Yes | Yes | Text | Customer |
| CUST_IBAN | IBAN | Yes | Yes | Iban | Customer |
| CUST_BIC | BIC | Yes | Yes | Text | Customer |
| CUST_VATCODE | VAT Code | Yes | Yes | Text | Customer |
| CUST_PAYMENTMETHOD | Payment customer method | Yes | Yes | Text | Customer |
| CUST_PAYMENTMETHOD_DESC | Payment method customer desc | Yes | No | Text | Customer |
| CUST_INVOICESENDING | Method invoice | Yes | Yes | invoicesending | Customer |
| EVENT_ID | Course id | Yes | Yes | Number | Course |
| EVENT_NAME | Course name | Yes | Yes | Text | Course |
| EVENT_DESC | Course description | Yes | Yes | Text | Course |
| EVENT_LONG_DESC | Long description | Yes | Yes | Text | Course |
| EVENT_LONG_MEMO | Course memo | Yes | Yes | Text | Course |
| EVENT_NUMBER_OF_PLACES | Course number of places | Yes | Yes | Number | Course |
| EVENT_NUMBER_OF_FREE | Course free places | Yes | Yes | Number | Course |
| EVENT_NUMBER_OF_WAITING | Course number of waiting | Yes | Yes | Number | Course |
| EVENT_NUMBER_OF_WAITINGFREE | Course number of waiting free | Yes | Yes | Number | Course |
| EVENT_STATUSCODE | Event status code | Yes | No | Text | Course |
| EVENT_STATUSDESC | Event status | Yes | No | Text | Course |
| EVENT_STATUSNAME | Event status (name) | Yes | No | Text | Course |
| ETICKET_TIMESTAMP | E-Ticket validated | Yes | Yes | Datetime | Reservation |
| ETICKET_CODE | E-Ticket code | Yes | Yes | Text | Reservation |
| INVOICE_ID | Invoice Id | Yes | Yes | Number | Invoice |
| INVOICE_NUMBER | Invoice number | Yes | Yes | Text | Invoice |
| INVOICE_STATUS | Invoice status | Yes | Yes | Text | Invoice |
| INVOICE_DATE | Invoice date | Yes | Yes | Date | Invoice |
| INVOICE_PRICE | Invoice price | Yes | Yes | Currency | Invoice |
| INVOICE_CURRENCY | Invoice currency | Yes | Yes | Text | Invoice |
| CREATED_DAY | CREATED_DAY | Yes | No | Text | |
| THEME_ID | Theme # | Yes | Yes | Text | Theme |
| THEME_NAME | Theme name | Yes | Yes | Text | Theme |
| THEME_DESC | Theme description | Yes | Yes | Text | Theme |
| GIFT_ID | Gift Id | Yes | Yes | Text | Gift |
| GIFT_PRICE | Price | Yes | Yes | Text | Gift |
| GIFT_CURRENCY | Currency | Yes | Yes | Text | Gift |
| GIFT_ONLYNEWBOOKING | Gift only new | Yes | Yes | Text | Gift |
| VOUCHER_NAME | Voucher Name | Yes | Yes | Text | Gift |
| VOUCHER_DESC | Voucher Description | Yes | Yes | Text | Gift |
| CREATE_PDF | Create PDF | Yes | No | Text | Booking |
| GOTO_BOOKING | Booking Id | Yes | No | Text | Booking |
| COMP_ID | Company # | Yes | Yes | Number | Company |
| COMP_ACTIVE | Active | Yes | Yes | Text | Company |
| COMP_STATUS | Status | Yes | Yes | Text | |
| COMP_EMAIL | Yes | Yes | Text | Company | |
| COMP_EMAILLIST | E-mail list | Yes | Yes | Text | Company |
| COMP_NAME | Companyname | Yes | Yes | Text | Company |
| COMP_TEL | Company phone | Yes | Yes | Text | Company |
| COMP_FAX | C-Fax | Yes | Yes | Text | Company |
| COMP_POSTAL | Postal | Yes | Yes | Text | Company |
| COMP_HOUSENUM | House number | Yes | Yes | Text | Company |
| COMP_HOUSENUMEXT | House number extension | Yes | Yes | Text | Company |
| COMP_ADDRESS1 | Address | Yes | Yes | Text | Company |
| COMP_ADDRESS2 | Address 2 | Yes | Yes | Text | Company |
| COMP_ADDRESS3 | Address 3 | Yes | Yes | Text | Company |
| COMP_CITY | City | Yes | Yes | Text | Company |
| COMP_COUNTRY | Country | Yes | Yes | Country | Company |
| COMP_VATNUMBER | Company vat number | Yes | Yes | Text | Company |
| COMP_FACT_POSTAL | Invoice postal | Yes | Yes | Text | Company |
| COMP_FACT_HOUSENUM | Invoice house number | Yes | Yes | Text | Company |
| COMP_FACT_HOUSENUMEXT | Invoice house number extension | Yes | Yes | Text | Company |
| COMP_FACT_ADDRESS1 | Invoice address | Yes | Yes | Text | Company |
| COMP_FACT_ADDRESS2 | Invoice address 2 | Yes | Yes | Text | Company |
| COMP_FACT_ADDRESS3 | Invoice address 3 | Yes | Yes | Text | Company |
| COMP_FACT_CITY | Invoice city | Yes | Yes | Text | Company |
| COMP_FACT_COUNTRY | Invoice country | Yes | Yes | Country | Company |
| COMP_SIGNUPDATE | Signup date | Yes | Yes | Date | Company |
| COMP_EXPIREDATE | Expiry date | Yes | Yes | Date | Company |
| COMP_CUSTOM01 | Custom 1 | Yes | Yes | Custom | Company |
| COMP_CUSTOM02 | Custom 2 | Yes | Yes | Custom | Company |
| COMP_CUSTOM03 | Custom 3 | Yes | Yes | Custom | Company |
| COMP_CUSTOM04 | Custom 4 | Yes | Yes | Custom | Company |
| COMP_CUSTOM05 | Custom 5 | Yes | Yes | Custom | Company |
| COMP_CUSTOM06 | Custom 6 | Yes | Yes | Custom | Company |
| COMP_CUSTOM07 | Custom 7 | Yes | Yes | Custom | Company |
| COMP_CUSTOM08 | Custom 8 | Yes | Yes | Custom | Company |
| COMP_CUSTOM09 | Custom 9 | Yes | Yes | Custom | Company |
| COMP_CUSTOM10 | Custom 10 | Yes | Yes | Custom | Company |
| COMP_CUSTOM11 | Custom 11 | Yes | Yes | Custom | Company |
| COMP_CUSTOM12 | Custom 12 | Yes | Yes | Custom | Company |
| COMP_CUSTOM13 | Custom 13 | Yes | Yes | Custom | Company |
| COMP_CUSTOM14 | Custom 14 | Yes | Yes | Custom | Company |
| COMP_CUSTOM15 | Custom 15 | Yes | Yes | Custom | Company |
| COMP_CUSTOM16 | Custom 16 | Yes | Yes | Custom | Company |
| COMP_CUSTOM17 | Custom 17 | Yes | Yes | Custom | Company |
| COMP_CUSTOM18 | Custom 18 | Yes | Yes | Custom | Company |
| COMP_CUSTOM19 | Custom 19 | Yes | Yes | Custom | Company |
| COMP_CUSTOM20 | Custom 20 | Yes | Yes | Custom | Company |
| COMP_CUSTOM21 | Custom 21 | Yes | Yes | Custom | Company |
| COMP_CUSTOM22 | Custom 22 | Yes | Yes | Custom | Company |
| COMP_CUSTOM23 | Custom 23 | Yes | Yes | Custom | Company |
| COMP_CUSTOM24 | Custom 24 | Yes | Yes | Custom | Company |
| COMP_CUSTOM25 | Custom 25 | Yes | Yes | Custom | Company |
| COMP_CUSTOM26 | Custom 26 | Yes | Yes | Custom | Company |
| COMP_CUSTOM27 | Custom 27 | Yes | Yes | Custom | Company |
| COMP_CUSTOM28 | Custom 28 | Yes | Yes | Custom | Company |
| COMP_CUSTOM29 | Custom 29 | Yes | Yes | Custom | Company |
| COMP_CUSTOM30 | Custom 30 | Yes | Yes | Custom | Company |
| COMP_CUSTOM31 | Custom 31 | Yes | Yes | Custom | Company |
| COMP_CUSTOM32 | Custom 32 | Yes | Yes | Custom | Company |
| COMP_CUSTOM33 | Custom 33 | Yes | Yes | Custom | Company |
| COMP_CUSTOM34 | Custom 34 | Yes | Yes | Custom | Company |
| COMP_CUSTOM35 | Custom 35 | Yes | Yes | Custom | Company |
| COMP_CUSTOM36 | Custom 36 | Yes | Yes | Custom | Company |
| COMP_CUSTOM37 | Custom 37 | Yes | Yes | Custom | Company |
| COMP_CUSTOM38 | Custom 38 | Yes | Yes | Custom | Company |
| COMP_CUSTOM39 | Custom 39 | Yes | Yes | Custom | Company |
| COMP_CUSTOM40 | Custom 40 | Yes | Yes | Custom | Company |
| COMP_CUSTOM41 | Custom 41 | Yes | Yes | Custom | Company |
| COMP_CUSTOM42 | Custom 42 | Yes | Yes | Custom | Company |
| COMP_CUSTOM43 | Custom 43 | Yes | Yes | Custom | Company |
| COMP_CUSTOM44 | Custom 44 | Yes | Yes | Custom | Company |
| COMP_CUSTOM45 | Custom 45 | Yes | Yes | Custom | Company |
| COMP_CUSTOM46 | Custom 46 | Yes | Yes | Custom | Company |
| COMP_CUSTOM47 | Custom 47 | Yes | Yes | Custom | Company |
| COMP_CUSTOM48 | Custom 48 | Yes | Yes | Custom | Company |
| COMP_CUSTOM49 | Custom 49 | Yes | Yes | Custom | Company |
| COMP_CUSTOM50 | Custom 50 | Yes | Yes | Custom | Company |
| COMP_LONGCUSTOM01 | COMP_LONGCUSTOM01 | Yes | Yes | Text | Company |
| COMP_LONGCUSTOM02 | COMP_LONGCUSTOM02 | Yes | Yes | Text | Company |
| COMP_LONGCUSTOM03 | COMP_LONGCUSTOM03 | Yes | Yes | Text | Company |
| COMP_LONGCUSTOM04 | COMP_LONGCUSTOM04 | Yes | Yes | Text | Company |
| COMP_LONGCUSTOM05 | COMP_LONGCUSTOM05 | Yes | Yes | Text | Company |
| COMP_PAYMENTMETHOD | Payment customer method | Yes | No | Text | Company |
| COMP_PAYMENTMETHOD_DESC | Payment method customer description | Yes | No | Text | Company |
| COMP_BANKNAME | Bank name | Yes | Yes | Text | Company |
| COMP_BANKACCOUNT | Bankaccount | Yes | Yes | Text | Company |
| COMP_IBAN | IBAN | Yes | Yes | Text | Company |
| COMP_BIC | BIC | Yes | Yes | Text | Company |
| COMP_VATCODE | VAT Code | Yes | Yes | Text | Company |
| COMP_INVOICESENDING | Method invoice | Yes | Yes | invoicesending | Company |
| COMP_MANDATEREF | COMP_MANDATEREF | Yes | Yes | Text | Company |
| COMP_MANDATEDATE | COMP_MANDATEDATE | Yes | Yes | Date | Company |
| COMP_ID_HIS | COMP_ID_HIS | Yes | Yes | Number | Company |
| COMP_CUST_ID | COMP_CUST_ID | Yes | Yes | Number | Company |
| COMP_USER_ID | COMP_USER_ID | Yes | Yes | Number | Company |
| COMP_FRAME_ID | COMP_FRAME_ID | Yes | Yes | Number | Company |
| STATUS | Status# | No | Yes | ||
| PRODUCT | Coursetype | No | Yes | ||
| STARTED | Started | No | Yes | ||
| ENDED | Ended | No | Yes | ||
| STARTTIME | From time | No | Yes | ||
| ENDTIME | Till time | No | Yes | ||
| CUSTOMER | Customer | No | Yes | ||
| BOOKING_ID | Booking Id | No | Yes | ||
| USER_ID | User # | No | Yes | ||
| CUST_ID | Customer Id | No | Yes | ||
| FROM_TIME | From time | No | Yes | ||
| TILL_TIME | Till time | No | Yes | ||
| RESOURCE | Resource | No | Yes | ||
| LOCATION | Location | No | Yes | Text | |
| SETUP | Room setup | No | Yes | Text | |
| NEWSLETTER | Newsletter | No | Yes | ||
| QUE_TYPE | Question-Type | No | Yes | ||
| QUE_SETTINGS | Question-Settings | No | Yes | ||
| EVENT_STATUS | EVENT_STATUS | No | Yes | ||
| COMP_PYM_ID | COMP_PYM_ID | No | Yes | ||
| COMMENT | Comment | No | Yes | ||
| CNT_RES | Number of bookings | Yes | Yes | Number | Booking |
| CUST_LANG | Language | Yes | Yes | Language | Customer |
| FROMDATE_DAY | From date-Day | Yes | Yes | Text | Booking |
| FROMDATE_MONTH | From date-Month | Yes | Yes | Text | Booking |
| FROMDATE_WEEK | From date-Week | Yes | Yes | Text | Booking |
| FROMDATE_YEAR | From date-Year | Yes | Yes | Text | Booking |
| TILLDATE_DAY | Till date-Day | Yes | Yes | Text | Booking |
| TILLDATE_MONTH | Till date-Month | Yes | Yes | Text | Booking |
| TILLDATE_WEEK | Till date-Week | Yes | Yes | Text | Booking |
| TILLDATE_YEAR | Till date-Year | Yes | Yes | Text | Booking |
| OVERNIGHT_STAYS | Overnight stays | Yes | Yes | Number | Booking |
| PARTICIPANT_ETICKET_CODE | E-Ticket (P) code | Yes | Yes | Text | Participant |
| PARTICIPANT_ETICKET_TIMESTAMP | E-Ticket (P) validated | Yes | Yes | Datetime | Participant |
| RES_FROM | From date | Yes | Yes | Date | Booking |
| RES_PART | Number of participants | Yes | No | Number | Booking |
| RES_TILL | Till date | Yes | No | Date | Booking |
