Home Functional information Filter columns
Documentation

Columns Customer

The columns for the context Customer.

These are auto generated.

Technical name Display Selectable Searchable Type Entity
CUST_ID Customer Id Yes No Number
CUST_EMAIL Email Yes No Text
CUST_POSTAL Postal Yes Yes Text
CUST_HOUSENUM House Number Yes Yes Number
CUST_HOUSENUMEXT House No Ext Yes Yes Text
CUST_ADDRESS1 Address Yes Yes Text
CUST_ADDRESS2 Address line 2 Yes Yes Text
CUST_ADDRESS3 Address line 3 Yes Yes Text
CUST_CITY City Yes Yes Text
CUST_COUNTRY Country Id Yes Yes Country
CUST_STATE State Yes Yes Text
CUST_TEL_HOME Home phone Yes Yes Text
CUST_TEL_MOB Cell phone Yes Yes Text
CUST_TEL_WORK Work phone Yes Yes Text
CUST_TEL_FAX Fax Yes Yes Text
CUST_FIRSTNAME Firstname Yes Yes Text
CUST_LASTNAME Lastname Yes No Text
CUST_INITIALS Initials Yes Yes Text
CUST_PREFIX Prefix Yes Yes Text
CUST_FULLNAME Customer name Yes No Text
CUST_SHORTNAME Customer Short Yes No Text
CUST_INFORMALNAME Customer informal Yes No Text
CUST_SEX Gender Yes Yes Sex
CUST_USERNAME Username Yes No Text
USER_EMAIL Email Yes Yes Text User
USER_CREATED User created Yes Yes Date User
USER_LASTLOGIN Last login Yes Yes Date User
USER_PASSWORD_UPDATED User updated Yes Yes Date User
PRF_NAME Profile Yes Yes Text
PRF_DESC Profile description Yes Yes Text
CUST_SIGNUPDATE Signupdate Yes Yes Date
CUST_EXPIREDATE Expiredate Yes Yes Date
CUST_BIRTHDATE Birthdate Yes Yes Date
CUST_LAST7DAYS Last 7 days Yes No Number
CUST_LAST3MONTHS Last 3 months Yes No Number
CUST_LAST12MONTHS Last 12 months Yes No Number
CUST_LABELS Customer Labels Yes Yes Text
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
UPDATED updated Yes Yes Datetime Customer
CREATED Created Yes Yes Datetime Customer
NEWS_LETTER Newsletter Yes No Text
CUST_FACT_STATE Invoice state Yes Yes Text
CUST_FACT_POSTAL Invoice postal Yes Yes Text
CUST_FACT_HOUSENUM Invoice house number Yes Yes Number
CUST_FACT_HOUSENUMEXT Invoice house number extension Yes Yes Text
CUST_FACT_ADDRESS1 Invoice address Yes Yes Text
CUST_FACT_ADDRESS2 Invoice address 2 Yes Yes Text
CUST_FACT_ADDRESS3 Invoice address 3 Yes Yes Text
CUST_FACT_CITY Invoice city Yes Yes Text
CUST_FACT_COUNTRY Invoice country Yes Yes Country
CUST_MEMBER_ID Member ID Yes Yes Text
CUST_ID_NUMBER ID Number Yes Yes Text
CUST_ID_TYPE ID type Yes Yes Text
CUST_STUDENT Student Yes Yes Text
CUST_BANKNAME Bank Yes Yes Text
CUST_BANKACCOUNT Bankaccount Yes Yes Bankaccount
CUST_IBAN IBAN Yes Yes Iban
CUST_BIC BIC Yes Yes Text
CUST_VATCODE VAT Code Yes Yes Text
CUST_PAYMENTMETHOD Payment customer method Yes Yes Text
CUST_PAYMENTMETHOD_DESC Payment method customer desc Yes No Text
CUST_INVOICESENDING Method invoice Yes Yes invoicesending
CUST_ANON Anonimised Yes Yes Text
CUST_ANONDATE Date anonimised Yes Yes Text
CUST_STATUS Status Yes Yes Text
CUST_STATUSCODE Status code Yes Yes Text
CUST_STATUSDESC Status (description) Yes No Text
CUST_STATUSNAME Status (name) Yes No Text
CUST_STATUSBGCOLOR CUST_STATUSBGCOLOR Yes No Text
CUST_STATUSTEXTCOLOR CUST_STATUSTEXTCOLOR Yes No Text
EXTERNAL_ID External ID Yes Yes Text Customer
CMP_NAME Company Yes Yes Text
CMP_TEL Company-Phone Yes Yes Text
CMP_FAX Company fax Yes Yes Text
CUST_COMP_ID Company # Yes Yes Number
CUST_COMP_NAME Company name Yes Yes Text Company
CUST_COMP_EMAIL CUST_COMP_EMAIL Yes Yes Text Company
COMP_STATUS_CODE COMP_STATUS_CODE Yes No Text
COMP_STATUS Status Yes No Text
CUST_COMP_ACTIVATION CUST_COMP_ACTIVATION Yes No Text Company
CUST_COMP_ACTIVE Active Yes Yes Text Company
CUST_COMP_COLLECTIVE Collective Yes Yes Text Company
CUST_COMP_COLLECTIVE_ENROLL Enroll Yes Yes Text 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
CUST_COMP_PHONE C-Phone Yes Yes Text Company
CUST_COMP_FAX C-Fax Yes Yes Text Company
CUST_COMP_POSTAL Postal Yes Yes Text Company
CUST_COMP_HOUSENUM House number Yes Yes Text Company
CUST_COMP_HOUSENUMEXT House number extension Yes Yes Text Company
CUST_COMP_ADDRESS1 Address Yes Yes Text Company
CUST_COMP_ADDRESS2 Address 2 Yes Yes Text Company
CUST_COMP_ADDRESS3 Address 3 Yes Yes Text Company
CUST_COMP_CITY City Yes Yes Text Company
CUST_COMP_COUNTRY Country Yes Yes Country Company
CUST_COMP_SIGNUPDATE Signup date Yes Yes Date Company
CUST_COMP_EXPIREDATE Expiry date Yes Yes Date Company
CUST_COMP_FACT_POSTAL Invoice postal Yes Yes Text Company
CUST_COMP_FACT_HOUSENUM Invoice house number Yes Yes Text Company
CUST_COMP_FACT_HOUSENUMEXT Invoice house number extension Yes Yes Text Company
CUST_COMP_FACT_ADDRESS1 Invoice address Yes Yes Text Company
CUST_COMP_FACT_ADDRESS2 Invoice address 2 Yes Yes Text Company
CUST_COMP_FACT_ADDRESS3 Invoice address 3 Yes Yes Text Company
CUST_COMP_FACT_CITY Invoice city Yes Yes Text Company
CUST_COMP_FACT_COUNTRY Invoice country Yes Yes Country Company
CUST_COMP_BANKNAME Bank name Yes Yes Text Company
CUST_COMP_BANKACCOUNT Bankaccount Yes Yes Text Company
CUST_COMP_IBAN IBAN Yes Yes Text Company
CUST_COMP_BIC BIC Yes Yes Text Company
CUST_COMP_VATCODE VAT Code Yes Yes Text Company
CUST_COMP_PAYMENTMETHOD Payment customer method Yes Yes Text Company
CUST_COMP_PAYMENTMETHOD_DESC Payment method customer desc Yes No Text Company
CUST_COMP_INVOICESENDING Method invoice Yes Yes Text Company
PARTNER_ID Partner ID Yes Yes Number
PARTNER_LASTNAME Partner last name Yes Yes Text
PARTNER_INITIALS Partner initials Yes Yes Text
PARTNER_PREFIX Partner prefix Yes Yes Text
PARTNER_SEX Partner gender Yes Yes Sex
PARTNER_FULLNAME Partner name Yes No Number
SUB_ID ID Yes Yes Number Subscription
CUST_SUB_FROMDATE Subscription from date Yes Yes Date Subscription
CUST_SUB_TILLDATE Subscription till date Yes Yes Date Subscription
CUST_SUB_STATUS Subscription status Yes Yes Text Subscription
CUST_SUB_OVERRIDE Subscription override Yes Yes Number Subscription
CUST_SUB_PRICE Subscription price Yes Yes Number Subscription
CUST_SUB_CURRENCY Subscription currency Yes Yes Text Subscription
CUST_SUB_SETUPPRICE Subscription setup price Yes Yes Number Subscription
CUST_SUB_SETUPCURRENCY Subscription setup currency Yes Yes Text Subscription
CUST_SUB_CNT_RUNS Subscription runs count Yes Yes Number Subscription
CUST_SUB_LASTFROM Last subscription from date Yes Yes Date Subscription
CUST_SUB_LASTTILL Last subscription till date Yes Yes Date Subscription
CUST_SUB_NEXTDATE Next subscription rundate Yes Yes Date Subscription
BATCH_ID Batch # Yes Yes Number Subscription
RUN_STATUS Subscription run status Yes Yes Text Subscription
RUN_OVERRIDE Subscription run override Yes Yes Number Subscription
RUN_DATEFROM Subscription run from date Yes Yes Date Subscription
RUN_DATETILL Subscription run till date Yes Yes Date Subscription
RUN_DESC Subscription run description Yes Yes Text Subscription
RUN_PRICE Subscription run price Yes Yes Number Subscription
RUN_CURRENCY Subscription run currency Yes Yes Text Subscription
RUN_SETUPPRICE Subscription run setup price Yes Yes Number Subscription
RUN_SETUPCURRENCY Subscription run setup currency Yes Yes Text Subscription
RUN_NBR_MONTHS Subscription run months Yes Yes Number Subscription
RUN_NBR_DAYS Subscription run days Yes Yes Number Subscription
SUB_PRICE Price Yes Yes Number Subscription
SUB_CURRENCY Currency Yes Yes Text Subscription
SUB_NAME Subscription Yes Yes Text Subscription
SUB_DESC Description Yes Yes Text Subscription
SUB_LONG_DESC Long description Yes Yes Text Subscription
SUB_LONG_MEMO Memo Yes Yes Text Subscription
ADDITIONAL_USAGE_ID Additional Usage ID Yes Yes Number Subscription
ADDITIONAL_USAGE_STATUS Additional usage status Yes Yes Text Subscription
ADDITIONAL_USAGE_INVOICE_ID Additional usage invoice ID Yes Yes Number Additional usage
ADDITIONAL_USAGE_DESCRIPTION Additional usage description Yes Yes Text Additional usage
ADDITIONAL_USAGE_AMOUNT Additional usage amount Yes Yes Number Additional usage
ADDITIONAL_USAGE_CURRENCY Additional usage currency Yes Yes Text Additional usage
ADDITIONAL_USAGE_DISCOUNT Additional usage discount Yes Yes Number Additional usage
ADDITIONAL_USAGE_VAT_ID Additional asage Vat ID Yes Yes Number Additional usage
ADDITIONAL_USAGE_VAT_DESC Additional usage vat description Yes Yes Text VAT
ADDITIONAL_USAGE_FEE_ID Additional Fee ID Yes Yes Number Additional usage
ADDITIONAL_USAGE_FEE_DESC Additional asage fee description Yes Yes Text Fee
ADDITIONAL_USAGE_ACCOUNT_CODE Additional usage account code Yes Yes Text Additional usage
ADDITIONAL_USAGE_ACCOUNT_SIGN Additional usage account sign Yes Yes Text Additional usage
ADDITIONAL_USAGE_FROM Additional usage from Yes Yes Date Additional usage
ADDITIONAL_USAGE_FROMTIME Additional usage fromtime Yes Yes Time Additional usage
ADDITIONAL_USAGE_TILL Additional usage till Yes Yes Date Additional usage
ADDITIONAL_USAGE_TILLTIME Additional usage tilltime Yes Yes Time Additional usage
ADDITIONAL_USAGE_MONTHS Additional usage months Yes Yes Number Additional usage
ADDITIONAL_USAGE_NIGHTS Additional usage nights Yes Yes Number Additional usage
CONTACT_TYPE Contact type Yes Yes Text Contacts
CONTACT_DETAIL Contact detail Yes Yes Text Contacts
CONTACT_DESC Contact description Yes Yes Text Contacts
CONTACT_WORKFLOW Contact workflow Yes Yes Text Contacts
CONTACT_INVOICE Contact invoice Yes Yes Text Contacts
CUSTOMER_ID Customer Id No Yes
LASTNAME Lastname No Yes
EMAIL E-mail No Yes
ADRES ADRES No Yes
CUST_ACTIVE CUST_ACTIVE No Yes
NEWSLETTER Newsletter No Yes
CUST_COMP_STATUS Status No Yes Text
COMMENT Comment No Yes
Dashboard
Template variables
Front-end variables
Front-end entries
Rights
Filters
Filter columns
Filter operators
Additional
Available API's
Frequently Asked Questions
i-Reserve User

User

Are you a user of I-Reserve and are you dealing with everyday matters concerning reservations? Then you will probably find the answers to your questions here.
i-Reserve Admin

Admin

Are you responsible for the configuration and implementation of i-Reserve? Then you will find the answers for your tasks in this category.
i-Reserve Developer

Developer

Are you a designer or programmer and are you dealing with the styling and/or development of the frontend? Then take a look around in this category.