Manual i-Reserve - Columns Gift voucher

Home Functional information Filter columns

Documentation

Difficulty level:

The columns for the context Gift voucher

These are auto generated.

Technical name	Display	Selectable	Searchable	Type	Entity
GIFT_ID	Gift Id	Yes	No	Number
GIFT_VOUCHER	Gift Voucher	Yes	No	Text
VOUCHER_NAME	Voucher Name	Yes	No	Text
VOUCHER_DESC	Voucher Description	Yes	No	Text
GIFT_VALIDFROM	Valid From	Yes	No	Date
GIFT_VALIDTILL	Valid Till	Yes	No	Date
VOUCHER_OWNER	Voucher Owner	Yes	No	Number
SUSPEND	Suspend	Yes	No	Text
GIFT_PERCENTAGE	Percentage	Yes	No	Number
GIFT_PRICE	Price	Yes	No	Number
GIFT_CURRENCY	Currency	Yes	No	Text
GIFT_DATEUSED	Used Date	Yes	No	Date
GIFT_CUST_ID	Customer Number	Yes	Yes	Number
GIFT_RES_ID	Booking Id	Yes	No	Number
GIFT_OBJ_ID	product_singleucfirst id	Yes	No	Number
CREATED	Created	Yes	No	Datetime
UPDATED	Updated	Yes	No	Datetime
OBJ_DESC	product_singleucfirst	Yes	Yes	Text	Object
CUST_ID	Customer ID	Yes	Yes	Number	Customer
CUST_FULLNAME	Customer name	Yes	Yes	Text	Customer
CUST_EMAIL	Email	Yes	Yes	Text	Customer
CUST_POSTAL	Postal	Yes	Yes	Text	Customer
CUST_HOUSENUM	House Number	Yes	Yes	Number	Customer
CUST_HOUSENUMEXT	House No Ext	Yes	Yes	Text	Customer
CUST_ADDRESS1	Address	Yes	Yes	Text	Customer
CUST_ADDRESS2	Address line 2	Yes	Yes	Text	Customer
CUST_ADDRESS3	Address line 3	Yes	Yes	Text	Customer
CUST_CITY	City	Yes	Yes	Text	Customer
CUST_COUNTRY	Country Id	Yes	Yes	Country	Customer
CUST_STATE	State	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_SEX	Gender	Yes	Yes	Sex	Customer
CUST_USERNAME	Username	Yes	No	Text	Customer
CUST_SIGNUPDATE	Signupdate	Yes	Yes	Date	Customer
CUST_EXPIREDATE	Expiredate	Yes	Yes	Date	Customer
CUST_BIRTHDATE	Birthdate	Yes	Yes	Date	Customer
CUST_CUSTOM01	Customer custom 01	Yes	No	Custom	Customer
CUST_CUSTOM02	Customer custom 02	Yes	No	Custom	Customer
CUST_CUSTOM03	Customer custom 03	Yes	No	Custom	Customer
CUST_CUSTOM04	Customer custom 04	Yes	No	Custom	Customer
CUST_CUSTOM05	Customer custom 05	Yes	No	Custom	Customer
CUST_CUSTOM06	Customer custom 06	Yes	No	Custom	Customer
CUST_CUSTOM07	Customer custom 07	Yes	No	Custom	Customer
CUST_CUSTOM08	Customer custom 08	Yes	No	Custom	Customer
CUST_CUSTOM09	Customer custom 09	Yes	No	Custom	Customer
CUST_CUSTOM10	Customer custom 10	Yes	No	Custom	Customer
NEWS_LETTER	Newsletter	Yes	Yes	Text
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	Bankaccount	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	Yes	Text	Customer
CUST_INVOICESENDING	Method invoice	Yes	Yes	invoicesending	Customer

Frequently Asked Questions

Columns Gift voucher

User

Admin

Developer