Manual i-Reserve - Columns Punch card

Home Functional information Filter columns

Documentation

Difficulty level:

The columns for the context Punch card

These are auto generated.

Technical name	Display	Selectable	Searchable	Type	Entity
KNIPKAART_ID	Punchcard id	Yes	No	Number
KNIPKAART_NAME	Punchcard name	Yes	Yes	Text
KNIPKAART_DESC	Description	Yes	No	Text
KNIPKAART_VALIDFROM	Valid from	Yes	No	Date
KNIPKAART_VALIDTILL	Valid till	Yes	No	Date
CREDIT	Punchcard credit	Yes	No	Text
KNIPKAART_CREDIT_PRICE	Credit price	Yes	No	Number
KNIPKAART_CREDIT_PERIOD	Credit period	Yes	No	Number
KNIPKAART_CREDIT_BOOKINGS	Credit Booking	Yes	No	Number
KNIPKAART_SUSPEND	Suspend	Yes	No	Number
CREATED	Created	Yes	Yes	Datetime
UPDATED	Updated	Yes	Yes	Datetime
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 Punch card

User

Admin

Developer