Documentation
Difficulty level:
Columns Object
The columns for the context Object
These are auto generated.
Technical name | Display | Selectable | Searchable | Type | Entity |
---|---|---|---|---|---|
OBJ_ID | Meetingroom id | Yes | Yes | Number | |
OBJ_NAME | Meetingroom name | Yes | Yes | Text | |
OBJ_DESC | Meetingroom | Yes | Yes | Text | |
GROUP_NAME | Group name | Yes | Yes | Text | Group |
GROUP_DESC | Group | Yes | Yes | Text | Group |
GROUP_LONG_DESC | Group extended | Yes | Yes | Text | Group |
GROUP_LONG_MEMO | Group extended memo | Yes | Yes | Text | Group |
CREATED | Created | Yes | Yes | Datetime | |
UPDATED | updated | Yes | Yes | Datetime | |
OBJ_ACTIVE | Active | Yes | Yes | Text | |
OBJ_ACTIVEADMIN | Active admin | Yes | Yes | Text | |
OBJ_GRP_ID | Group # | Yes | Yes | Number | |
OBJ_PRIO | Meetingroom order | Yes | Yes | Number | |
OBJ_DEFAULT | Meetingroom default | Yes | Yes | Text | |
OBJ_RENTALMODE | Meetingroom mode | Yes | Yes | Text | |
OBJ_ISMAINOBJ | Meetingroom ismainobj | Yes | Yes | Text | |
OBJ_MAINOBJID | Meetingroom mainobj# | Yes | Yes | Number | |
OBJ_MAINOBJNAME | Meetingroom mainobj | Yes | Yes | Text | |
OBJ_MAINOBJDESC | Meetingroom mainobj description | Yes | Yes | Text | |
OBJ_MAINMETHOD | Meetingroom mainmethod | Yes | Yes | Text | |
OBJ_OWNERID | Meetingroom ownerid | Yes | Yes | Number | |
OBJ_OWNERNAME | Meetingroom owner name | Yes | No | Text | User |
OBJ_AMOUNT | Meetingroom amount | Yes | Yes | Number | |
OBJ_AMOUNT_MIN_OVERALL | Meetingroom amount min overall | Yes | Yes | Number | |
OBJ_AMOUNT_MINIMUM | Meetingroom amount minimum | Yes | Yes | Number | |
OBJ_AMOUNT_MAXIMUM | Meetingroom amount maximum | Yes | Yes | Number | |
OBJ_PART_MINIMUM | Meetingroom participant minimum | Yes | Yes | Number | |
OBJ_PART_MAXIMUM | Meetingroom participant maximum | Yes | Yes | Number | |
OBJ_SAVEUSER_MANDATORY | Meetingroom saveuser mandatory | Yes | Yes | Text | |
OBJ_THRESHOLD | Meetingroom threshold | Yes | Yes | Number | |
OBJ_TIMEBEFORE | Meetingroom timebefore | Yes | Yes | Number | |
OBJ_TIMEBETWEEN | Meetingroom timebetween | Yes | Yes | Number | |
OBJ_TIMEAFTER | Meetingroom timeafter | Yes | Yes | Number | |
OBJ_PER_CONTINUOUS | Meetingroom per continuous | Yes | Yes | Text | |
OBJ_MULTIPLE | Meetingroom multiple | Yes | Yes | Number | |
OBJ_MULTIPLE_MINIMUM | Meetingroom multiple minimum | Yes | Yes | Number | |
OBJ_MULTIPLEADMIN | Meetingroom multipleadmin | Yes | Yes | Number | |
OBJ_COMBINEPERIODS | Meetingroom combineperiods | Yes | Yes | Text | |
OBJ_MIN | Meetingroom min | Yes | Yes | Number | |
OBJ_MAX | Meetingroom max | Yes | Yes | Number | |
OBJ_MAXPERIOD | Meetingroom maximum periods | Yes | Yes | Number | |
OBJ_PRICING | Meetingroom pricing | Yes | Yes | Text | |
OBJ_EVENT | Meetingroom event | Yes | Yes | Text | |
OBJ_EVENT_SESSIONS | Meetingroom event sessions | Yes | Yes | Number | |
OBJ_EVENT_PRESENT | Meetingroom event present | Yes | Yes | Text | |
OBJ_TRANSLATEPARTS | Meetingroom translateparts | Yes | Yes | Text | |
OBJ_EVENTDSPTIME | Meetingroom event display time | Yes | Yes | Text | |
OBJ_GROUPBY | Meetingroom groupby | Yes | Yes | Text | |
OBJ_OVERFLOW | Meetingroom overflow | Yes | Yes | Text | |
OBJ_CANCELPERIOD | Meetingroom cancelperiod | Yes | Yes | Number | |
OBJ_DAYS_INCLUDED | Meetingroom days included | Yes | Yes | Text | |
OBJ_DAYS_CALC_TIME | Meetingroom days calc time | Yes | Yes | Text | |
OBJ_DAYS_IN_ADVANCE_MIN | Meetingroom days in advance min | Yes | Yes | Number | |
OBJ_DAYS_IN_ADVANCE_MAX | Meetingroom days in advance max | Yes | Yes | Number | |
OBJ_MINS_IN_ADVANCE_MIN | Meetingroom mins in advance min | Yes | Yes | Number | |
OBJ_MINS_IN_ADVANCE_MAX | Meetingroom mins in advance max | Yes | Yes | Number | |
OBJ_IN_ADVANCE | Meetingroom in advance | Yes | Yes | Number | |
OBJ_INDEXPAGE | Meetingroom indexpage | Yes | Yes | Number | |
OBJ_PLAYER_MIN | Meetingroom player min | Yes | Yes | Number | |
OBJ_PLAYER_MAX | Meetingroom player max | Yes | Yes | Number | |
OBJ_NONBOOKABLE | Meetingroom nonbookable | Yes | Yes | Text | |
OBJ_CUST_MAXIMUM | Meetingroom customer maximum | Yes | Yes | Number | |
OBJ_CUST_MAXIMUM_SLOT | Meetingroom customer maximum slot | Yes | Yes | Number | |
OBJ_BAIL | Meetingroom deposit | Yes | Yes | Number | |
OBJ_BAILTYPE | Meetingroom deposit type | Yes | Yes | Number | |
OBJ_ACCOUNT_CODE | Meetingroom ledger | Yes | Yes | Text | |
OBJ_ACCOUNT_SIGN | Meetingroom account sign | Yes | Yes | Text | |
OBJ_EMAIL_ACTIVE | Meetingroom email active | Yes | Yes | Text | |
OBJ_EMAIL_FROM | Meetingroom email from | Yes | Yes | Number | |
OBJ_EMAIL_BCC | Meetingroom email bcc | Yes | Yes | Number | |
OBJ_SMS_ACTIVE | Meetingroom sms active | Yes | Yes | Text | |
OBJ_SMS_FROM | Meetingroom sms from | Yes | Yes | Number | |
OBJ_SMS_BCC | Meetingroom sms bcc | Yes | Yes | Number | |
OBJ_SMS_COUNTRY | Meetingroom sms country | Yes | Yes | Number | |
OBJ_LABELS | Meetingroom Labels | Yes | Yes | Text | |
OBJ_SHORT_DESC | Meetingroom short description | Yes | Yes | Text | |
OBJ_LONG_DESC | Meetingroom long description | Yes | Yes | Text | |
OBJ_LONG_MEMO | Meetingroom long memo | Yes | Yes | Text | |
OBJ_PLACES_SINGLE | Description number of places single | Yes | Yes | Text | |
OBJ_PLACES_PLURAL | Description number of places plural | Yes | Yes | Text | |
OBJ_EMAIL_WELCOME | The text to be used for outgoing mail | Yes | Yes | Text | |
OBJ_EMAIL_SIGNATURE | The signature to be added to the outgoing mail | Yes | Yes | Text | |
STAT_FROM | Status from | Yes | Yes | Text | |
STAT_TILL | Status till | Yes | Yes | Text | |
STAT_ENTITY | Status entity | Yes | Yes | Number | |
STAT_USERTEMPLATE | Status usertemplate | Yes | Yes | Text | |
STAT_TEMPLATE | Status template | Yes | Yes | Text | |
STAT_TEMPLATESMS | Status template sms | Yes | Yes | Text | |
STAT_CLIENT | Status customer | Yes | Yes | Text | |
STAT_BCC | Status bcc | Yes | Yes | Text | |
STAT_EMAILTO | Status emailto | Yes | Yes | Text | |
ORE_ID | Meetingroom resource# | Yes | Yes | Number | |
ORE_DEFAULT | Resources default | Yes | Yes | Text | |
ORE_REX_ID | Resource# | Yes | Yes | Number | |
ORE_REX_DESC | Meetingroom resource desccription | Yes | No | Text | |
REX_NAME | Combi # | Yes | No | Text | |
REX_TYPE | Type | Yes | Yes | Text | |
REX_DESC | Location description | Yes | No | Text | |
REX_LONG_DESC | Extended description | Yes | No | Text | |
REX_BEFORE | Time before needed | Yes | No | Text | |
REX_AFTER | Time after needed | Yes | No | Text | |
REX_AMOUNT | Number | Yes | No | Text | |
REX_PART_MINIMUM | Participant minimum | Yes | No | Text | |
REX_PART_MAXIMUM | Participant maximum | Yes | No | Text | |
ORE_METHOD | Resources method | Yes | Yes | Text | |
ORE_METHOD_AMOUNT | Resources method amount | Yes | Yes | Number | |
QUE_ID | Question# | Yes | Yes | Number | |
QUE_ORDER | Question order | Yes | Yes | Number | |
QUE_DESC | Question description | Yes | Yes | Text | |
QUE_QUESTION | Question | Yes | Yes | Text | |
DSP_TYPE | Question type | Yes | No | Text | |
QUE_REQUIRED | Question required | Yes | Yes | Text | |
DSP_SETTINGS | Question settings | Yes | No | Text | Question |
PER_ID | Period# | Yes | Yes | Number | |
PER_DEFAULT | Period default | Yes | Yes | Text | |
PER_TIMESPAN | Period timespan | Yes | Yes | Number | |
PER_TIMESPANUNIT | Period timespanunit | Yes | Yes | Text | |
PER_STARTDAY | Period startday | Yes | Yes | Text | |
PER_PRICE | Period price | Yes | Yes | Number | |
PER_CURRENCY | Period currency | Yes | Yes | Text | |
PER_DESC | Period description | Yes | Yes | Text | |
EXT_ID | EXT_ID | Yes | Yes | Number | |
EXT_PRIO | Extra-Priority | Yes | Yes | Number | |
EXT_TYPE | EXT_TYPE | Yes | Yes | Text | |
EXT_NUMBER | Extra-Number | Yes | Yes | Number | |
EXT_PRICE | Extra-Price | Yes | Yes | Text | |
EXT_CURRENCY | Extra-Currency | Yes | Yes | Text | |
EXT_NAME | Extra-Name | Yes | Yes | Text | |
EXT_GROUP | EXT_GROUP | Yes | Yes | Text | |
EXT_DESC | Extra-description | Yes | Yes | Text | |
EXT_DSPPRICE | Extra-Display price | Yes | Yes | Text | |
EXT_REMARK | Extra-Remarks | Yes | Yes | Text | |
EXT_LONG_MEMO | Extra-Memo | Yes | Yes | Text | |
PRT_ID | Participant# | Yes | Yes | Number | |
PRT_AMOUNT | Participant number | Yes | Yes | Number | |
PRT_MIN | Participant min | Yes | Yes | Number | |
PRT_MAX | Participant max | Yes | Yes | Number | |
PRT_DATAENTRY | Participant dataentry | Yes | Yes | Number | |
PRT_CALCTOTAL | Participant calctotal | Yes | Yes | Text | |
PRT_CALCCONVERSION | Participant calcconversion | Yes | Yes | Text | |
PRT_NAME | Participant name | Yes | Yes | Text | |
PRT_DESC | Participant description | Yes | Yes | Text | |
OBJ_POSTAL | Meetingroom postal | Yes | Yes | Text | |
OBJ_HOUSENUM | Meetingroom housenum | Yes | Yes | Number | |
OBJ_HOUSENUMEXT | Meetingroom extension | Yes | Yes | Text | |
OBJ_ADDRESS1 | Meetingroom address | Yes | Yes | Text | |
OBJ_ADDRESS2 | Meetingroom address 2 | Yes | Yes | Text | |
OBJ_ADDRESS3 | Meetingroom address 3 | Yes | Yes | Text | |
OBJ_CITY | Meetingroom city | Yes | Yes | Text | |
OBJ_STATE | Meetingroom state | Yes | Yes | Text | |
OBJ_REGION | Meetingroom region | Yes | Yes | Text | |
OBJ_COUNTRY | Meetingroom country | Yes | Yes | Country | |
OBJ_TEL_WORK | Meetingroom phone | Yes | Yes | Text | |
OBJ_LAT | Meetingroom lat | Yes | Yes | Number | |
OBJ_LNG | Meetingroom lng | Yes | Yes | Number | |
OBJ_WEBSITE | Meetingroom website | Yes | Yes | Text | |
OBJ_EMAIL | Meetingroom email | Yes | Yes | Text | |
OBJ_LONG_CUSTOM01 | Meetingroom custom memo field | Yes | Yes | Custom | |
OBJ_LONG_CUSTOM02 | Meetingroom custom memo field | Yes | Yes | Custom | |
OBJ_LONG_CUSTOM03 | Meetingroom custom memo field | Yes | Yes | Custom | |
OBJ_LONG_CUSTOM04 | Meetingroom custom memo field | Yes | Yes | Custom | |
OBJ_LONG_CUSTOM05 | Meetingroom custom memo field | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM01 | Meetingroom Custom 01 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM02 | Meetingroom Custom 02 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM03 | Meetingroom Custom 03 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM04 | Meetingroom Custom 04 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM05 | Meetingroom Custom 05 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM06 | Meetingroom Custom 06 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM07 | Meetingroom Custom 07 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM08 | Meetingroom Custom 08 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM09 | Meetingroom Custom 09 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM10 | Meetingroom Custom 10 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM11 | Meetingroom Custom 11 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM12 | Meetingroom Custom 12 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM13 | Meetingroom Custom 13 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM14 | Meetingroom Custom 14 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM15 | Meetingroom Custom 15 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM16 | Meetingroom Custom 16 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM17 | Meetingroom Custom 17 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM18 | Meetingroom Custom 18 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM19 | Meetingroom Custom 19 | Yes | Yes | Custom | |
OBJ_TXT_CUSTOM20 | Meetingroom Custom 20 | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM01 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM02 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM03 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM04 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM05 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM06 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM07 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM08 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM09 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM10 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM11 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM12 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM13 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM14 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM15 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM16 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM17 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM18 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM19 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM20 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM21 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM22 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM23 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM24 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM25 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM26 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM27 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM28 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM29 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
OBJ_CHK_CUSTOM30 | Meetingroom custom yes/no field | Yes | Yes | Custom | |
CAL_ID | Calendar# | Yes | Yes | Number | Calendar |
CAL_SCHEMA | Calendar schema | Yes | Yes | Text | Calendar |
CAL_DATEFROM | Calendar date from | Yes | Yes | Date | Calendar |
CAL_DATETILL | Calendar date till | Yes | Yes | Date | Calendar |
CAL_OPEN | Calendar open | Yes | Yes | Text | Calendar |
CAL_DISCOUNT | Calendar discount | Yes | Yes | Text | Calendar |
CAL_DESC | Calendar description | Yes | Yes | Text | Calendar |
CAL_PRICE | Calendar price | Yes | Yes | Number | Calendar |
CAL_CURRENCY | Calendar currency | Yes | Yes | Text | Calendar |
OPEN_ID | Open# | Yes | Yes | Number | |
OPEN_GROUP | Open group | Yes | Yes | Text | |
OPEN_DEFAULT | Open default | Yes | Yes | Text | |
OPEN_DESC | Open description | Yes | Yes | Text | |
OPEN_REX_DESC | Open resource desccription | Yes | No | Text | |
OPEN_DAY | Open day | Yes | Yes | Text | |
OPEN_STARTTIME | Open start time | Yes | Yes | Time | |
OPEN_ENDTIME | Open end time | Yes | Yes | Time | |
OPEN_REQUEST | Open request | Yes | Yes | Text | |
OPEN_REX_ID | Open location | Yes | Yes | Number | |
DISC_ID | Discount# | Yes | Yes | Number | Discount |
DISC_OWNERID | Discount ownerid | Yes | Yes | Number | Discount |
DISC_OWNERNAME | Owner | Yes | No | Text | Discount |
DISC_GROUP | Group | Yes | Yes | Text | Discount |
DISC_DESC | Description | Yes | Yes | Text | Discount |
DISC_TYPE | DISC_TYPE | Yes | Yes | Text | Discount |
DISC_LINETYPE | Linetype | Yes | Yes | Text | Discount |
DISC_COMBI | Combine | Yes | Yes | Text | Discount |
DISC_PRIO | Prio | Yes | Yes | Number | Discount |
DISC_DAY | Day | Yes | Yes | Text | Discount |
DISC_PRT_NAME | Participant | Yes | Yes | Text | Discount |
DISC_COMP | Comparison | Yes | Yes | Number | Discount |
DISC_MIN | Minimum | Yes | Yes | Number | Discount |
DISC_MAX | Maximum | Yes | Yes | Number | Discount |
DISC_CALC_FIXED | Fixed | Yes | Yes | Text | Discount |
DISC_CALC_AMOUNT | Calculate amount | Yes | Yes | Text | Discount |
DISC_CALC_MULTIPLY | Calculate multiply | Yes | Yes | Text | Discount |
DISC_FIXED | DISC_FIXED | Yes | Yes | Number | Discount |
DISC_AMOUNT | Amount | Yes | Yes | Number | Discount |
DISC_CURRENCY | Currency | Yes | Yes | Text | Discount |
DISC_VAT_ID | DISC_VAT_ID | Yes | Yes | Number | Discount |
DISC_FEE_ID | DISC_FEE_ID | Yes | Yes | Number | Discount |
DISC_FROM | From | Yes | Yes | Number | Discount |
DISC_TILL | Till | Yes | Yes | Number | Discount |
DISC_LASTMINUTE_FROM | Lastminute from | Yes | Yes | Number | Discount |
DISC_LASTMINUTE_TILL | Lastminute till | Yes | Yes | Number | Discount |
DISC_VALIDFROM | Valid from | Yes | Yes | date | Discount |
DISC_VALIDTILL | Valid till | Yes | Yes | date | Discount |
DISC_OUTPUTNEWLINE | New line | Yes | Yes | Text | Discount |
DISC_OUTPUTDESC | Description line | Yes | Yes | Text | Discount |
DISC_ACCOUNT_CODE | Ledger | Yes | Yes | Text | Discount |
DISC_ACCOUNT_SIGN | Account sign | Yes | Yes | Text | Discount |
SCHEMA_ID | Schema # | Yes | Yes | Number | Price scheme |
SCHEMA_GROUP | Schema group | Yes | Yes | Text | Price scheme |
SCHEMA_DESC | Schema description | Yes | Yes | Text | Price scheme |
SCHEMA_PER_ID | Schema period # | Yes | Yes | Number | Price scheme |
SCHEMA_DAY | Schema day | Yes | Yes | Text | Price scheme |
SCHEMA_PRICEMETHOD | Schema price method | Yes | Yes | Number | Price scheme |
SCHEMA_PRICE | Schema price | Yes | Yes | Number | Price scheme |
SCHEMA_DEFAULT | Schema default | Yes | Yes | Text | Price scheme |
SCHEMA_CURRENCY | Schema currency | Yes | Yes | Text | Price scheme |
SCHEMA_PRICEDESC | SCHEMA_PRICEDESC | Yes | Yes | Text | Price scheme |
SCHEMA_VAT_ID | Schema vat # | Yes | Yes | Number | Price scheme |
SCHEMA_FEE_ID | Schema fee # | Yes | Yes | Number | Price scheme |
SCHEMA_ACCOUNT_CODE | Schema ledger code | Yes | Yes | Text | Price scheme |
SCHEMA_ACCOUNT_SIGN | Schema ledger sign | Yes | Yes | Text | Price scheme |
CONFIG_DASHBOARD | Config | Yes | No | Text | Meetingroom |
SCHEMA_DASHBOARD | Schema | Yes | No | Text | Meetingroom |
EXTRA_DASHBOARD | Extra | Yes | No | Text | Meetingroom |
WORKFLOW_DASHBOARD | Workflow | Yes | No | Text | Meetingroom |
DEFAULT_IMAGE | Default image | Yes | No | Text | |
GROUP_ID | Group ID | Yes | No | 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 |
QUE_TYPE | Question-Type | No | Yes |