Documentation
Difficulty level:
Columns Invoice
The columns for the context invoice.
These are auto generated.
| Technical name | Display | Selectable | Searchable | Type | Entity |
|---|---|---|---|---|---|
| INVOICE_ID | Invoice Id | Yes | Yes | Number | |
| BOOKING_ID | Booking Id | Yes | Yes | Number | |
| CUSTOMER_ID | Customer Id | Yes | Yes | Number | |
| CUST_FULLNAME | Customer name | Yes | No | Text | Customer |
| INV_NUMBER | Invoice number | Yes | Yes | Text | |
| INV_OWNERID | INV_OWNERID | Yes | Yes | Text | |
| INV_STATUS | Status | Yes | Yes | Text | |
| INV_PRICE | Price | Yes | Yes | Currency | |
| INV_CURRENCY | Currency | Yes | Yes | Text | |
| INV_PEND_PRICE | Pending | Yes | Yes | Currency | |
| INV_PEND_CURRENCY | Pending currency | Yes | Yes | Text | |
| INV_PAY_PRICE | Paid | Yes | No | Currency | |
| INV_PAY_CURRENCY | Pay currency | Yes | No | Text | |
| INV_TO_PAY | To be paid | Yes | Yes | Currency | |
| CREATED | Created | Yes | Yes | Datetime | |
| UPDATED | updated | Yes | Yes | Datetime | |
| INVOICEDATE | Invoice date | Yes | Yes | Date | |
| DRAFTDATE | Draft date | Yes | Yes | Date | |
| FINALDATE | Final date | Yes | Yes | Date | |
| COLLECTION | Collection | Yes | Yes | Text | Payment |
| INV_LABELS | Invoice Labels | Yes | Yes | Text | |
| CUST_LABELS | Customer Labels | Yes | Yes | Text | Customer |
| RES_LABELS | Booking Labels | Yes | Yes | Text | Reservation |
| COMP_LABELS | Company Labels | Yes | Yes | Text | Company |
| INVOICE_DESC | Description | Yes | No | 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 |
| RES_OBJ_ID | coursetype ID | Yes | No | Text | Reservation |
| RES_COM_ID | Arrangement | Yes | No | Text | Reservation |
| RES_FROM | From date | Yes | No | Date | Reservation |
| RES_TILL | Till date | Yes | No | Date | Reservation |
| RES_FROMTIME | From time | Yes | No | Time | Reservation |
| RES_TILTIME | Till time | Yes | No | Time | Reservation |
| RES_REMARKS | Remarks | Yes | No | Text | Reservation |
| RES_STATUSCODE | Status code | Yes | No | Text | Reservation |
| RES_STATUSDESC | Status (desc) | Yes | No | Text | Reservation |
| RES_STATUSNAME | Status (name) | Yes | No | Text | Reservation |
| INV_CUSTOM01 | Invoice custom 01 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM02 | Invoice custom 02 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM03 | Invoice custom 03 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM04 | Invoice custom 04 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM05 | Invoice custom 05 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM06 | Invoice custom 06 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM07 | Invoice custom 07 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM08 | Invoice custom 08 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM09 | Invoice custom 09 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM10 | Invoice custom 10 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM11 | Invoice custom 11 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM12 | Invoice custom 12 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM13 | Invoice custom 13 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM14 | Invoice custom 14 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM15 | Invoice custom 15 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM16 | Invoice custom 16 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM17 | Invoice custom 17 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM18 | Invoice custom 18 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM19 | Invoice custom 19 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM20 | Invoice custom 20 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM21 | Invoice custom 21 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM22 | Invoice custom 22 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM23 | Invoice custom 23 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM24 | Invoice custom 24 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM25 | Invoice custom 25 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM26 | Invoice custom 26 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM27 | Invoice custom 27 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM28 | Invoice custom 28 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM29 | Invoice custom 29 | Yes | Yes | Custom | Invoice |
| INV_CUSTOM30 | Invoice custom 30 | Yes | Yes | Custom | Invoice |
| RES_CUSTOM01 | Booking Custom 01 | Yes | Yes | Custom | Booking |
| RES_CUSTOM02 | Booking Custom 02 | Yes | Yes | Custom | Booking |
| RES_CUSTOM03 | Booking Custom 03 | Yes | Yes | Custom | Booking |
| RES_CUSTOM04 | Booking Custom 04 | Yes | Yes | Custom | Booking |
| RES_CUSTOM05 | Booking Custom 05 | Yes | Yes | Custom | Booking |
| RES_CUSTOM06 | Booking Custom 06 | Yes | Yes | Custom | Booking |
| RES_CUSTOM07 | Booking Custom 07 | Yes | Yes | Custom | Booking |
| RES_CUSTOM08 | Booking Custom 08 | Yes | Yes | Custom | Booking |
| RES_CUSTOM09 | Booking Custom 09 | Yes | Yes | Custom | Booking |
| RES_CUSTOM10 | Booking Custom 10 | Yes | Yes | Custom | Booking |
| RES_CUSTOM11 | Booking Custom 11 | Yes | Yes | Custom | Booking |
| RES_CUSTOM12 | Booking Custom 12 | Yes | Yes | Custom | Booking |
| RES_CUSTOM13 | Booking Custom 13 | Yes | Yes | Custom | Booking |
| RES_CUSTOM14 | Booking Custom 14 | Yes | Yes | Custom | Booking |
| RES_CUSTOM15 | Booking Custom 15 | Yes | Yes | Custom | Booking |
| RES_CUSTOM16 | Booking Custom 16 | Yes | Yes | Custom | Booking |
| RES_CUSTOM17 | Booking Custom 17 | Yes | Yes | Custom | Booking |
| RES_CUSTOM18 | Booking Custom 18 | Yes | Yes | Custom | Booking |
| RES_CUSTOM19 | Booking Custom 19 | Yes | Yes | Custom | Booking |
| RES_CUSTOM20 | Booking Custom 20 | Yes | Yes | Custom | Booking |
| RES_CUSTOM21 | Booking Custom 21 | Yes | Yes | Custom | Booking |
| RES_CUSTOM22 | Booking Custom 22 | Yes | Yes | Custom | Booking |
| RES_CUSTOM23 | Booking Custom 23 | Yes | Yes | Custom | Booking |
| RES_CUSTOM24 | Booking Custom 24 | Yes | Yes | Custom | Booking |
| RES_CUSTOM25 | Booking Custom 25 | Yes | Yes | Custom | Booking |
| RES_CUSTOM26 | Booking Custom 26 | Yes | Yes | Custom | Booking |
| RES_CUSTOM27 | Booking Custom 27 | Yes | Yes | Custom | Booking |
| RES_CUSTOM28 | Booking Custom 28 | Yes | Yes | Custom | Booking |
| RES_CUSTOM29 | Booking Custom 29 | Yes | Yes | Custom | Booking |
| RES_CUSTOM30 | Booking Custom 30 | Yes | Yes | Custom | Booking |
| NEWS_LETTER | Newsletter | Yes | No | Text | Customer |
| 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 | Text | 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_INITIALS | Initials | Yes | Yes | Text | Customer |
| CUST_PREFIX | Prefix | Yes | Yes | Text | Customer |
| CUST_LASTNAME | Lastname | Yes | Yes | Text | Customer |
| CUST_EMAIL | Yes | No | 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 | 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 | No | Text | Customer |
| CUST_INVOICESENDING | Method invoice | Yes | Yes | invoicesending | Customer |
| INV_PAYMENTMETHOD | Payment method | Yes | Yes | Text | |
| INV_PAYMENTMETHOD_DESC | Payment method description | Yes | No | Text | |
| DETAIL_ID | Detail-ID | Yes | Yes | Number | Details |
| DETAIL_BOOKING_ID | Detail-Booking | Yes | Yes | Number | Details |
| DETAIL_CUSTOMER_ID | Detail-Customer | Yes | Yes | Number | Details |
| DETAIL_TYPE | Detail-Type | Yes | Yes | Text | Details |
| DETAIL_DESC | Detail-Description | Yes | Yes | Text | Details |
| DETAIL_FROMDATE | Detail-Fromdate | Yes | Yes | Date | Details |
| DETAIL_FROMTIME | Detail-Fromtime | Yes | Yes | Time | Details |
| DETAIL_TILLTIME | Detail-Tilltime | Yes | Yes | Time | Details |
| DETAIL_TILLDATE | Detail-Tilldate | Yes | Yes | Date | Details |
| DETAIL_CURRENCY | Detail-Currency | Yes | Yes | Text | Details |
| DETAIL_NUMBER | Detail-Number | Yes | Yes | Text | Details |
| DETAIL_PARTICIPANTS | Detail-Participant | Yes | Yes | Text | Details |
| DETAIL_SUBTOTAL | Detail-Subtotal | Yes | Yes | Currency | Details |
| DETAIL_DISCOUNT | Detail-Discount desc | Yes | Yes | Text | Details |
| DETAIL_DISCOUNT_TOTAL | Detail-Discount | Yes | Yes | Text | Details |
| DETAIL_PRICE | Detail-Price | Yes | Yes | Currency | Details |
| DETAIL_VAT_ID | Detail-VAT ID | Yes | Yes | Text | Details |
| DETAIL_VAT | Detail-VAT | Yes | Yes | Currency | Details |
| DETAIL_VAT_EXCL | Detail-VAT excl | Yes | Yes | Currency | Details |
| DETAIL_VAT_DESC | Detail-VAT desc | Yes | Yes | Text | Details |
| DETAIL_NBR_NIGHTS | Detail-Nights | Yes | Yes | Number | Details |
| DETAIL_NBR_DAYS | Detail-Days | Yes | Yes | Number | Details |
| DETAIL_OBJ_DESC | Detail-Product desc. | Yes | Yes | Text | Details |
| DETAIL_PRT_DESC | Detail-Participant desc. | Yes | Yes | Text | Details |
| INV_COMP_ID | Company | Yes | Yes | Number | |
| INV_PYM_ID | Payment method | Yes | No | Number | |
| BATCH_ID | Batch # | Yes | Yes | Number | Custom |
| CMP_ID | Company# | Yes | Yes | Number | Company |
| CMP_ACTIVE | Company active | Yes | Yes | Text | Company |
| CMP_LANG | Company language | Yes | Yes | Text | Company |
| CMP_STATUS | Company status | Yes | Yes | Text | Company |
| CMP_COLLECTIEF | Company collective | Yes | Yes | Text | Company |
| CMP_COLLECTIEF_ENROLL | Company enroll | Yes | Yes | Text | Company |
| CMP_EMAIL | Company email | Yes | Yes | Text | Company |
| CMP_EMAILLIST | Company newletter | Yes | Yes | Text | Company |
| CMP_NAME | Company | Yes | Yes | Text | Company |
| CMP_TEL | Company-Phone | Yes | Yes | Text | Company |
| CMP_FAX | Company fax | Yes | Yes | Text | Company |
| CMP_POSTAL | Company postal | Yes | Yes | Text | Company |
| CMP_HOUSENUM | Company house number | Yes | Yes | Text | Company |
| CMP_HOUSENUMEXT | Company house number extension | Yes | Yes | Text | Company |
| CMP_ADDRESS1 | Company address | Yes | Yes | Text | Company |
| CMP_ADDRESS2 | Company address2 | Yes | Yes | Text | Company |
| CMP_ADDRESS3 | Company address3 | Yes | Yes | Text | Company |
| CMP_CITY | Company city | Yes | Yes | Text | Company |
| CMP_COUNTRY | Company country | Yes | Yes | Country | Company |
| CMP_VATNUMBER | Company vat number | Yes | Yes | Text | Company |
| CMP_FACT_POSTAL | Company invoice postal | Yes | Yes | Text | Company |
| CMP_FACT_HOUSENUM | Company invoice house number | Yes | Yes | Text | Company |
| CMP_FACT_HOUSENUMEXT | Company invoice house number extension | Yes | Yes | Text | Company |
| CMP_FACT_ADDRESS1 | Company invoice address | Yes | Yes | Text | Company |
| CMP_FACT_ADDRESS2 | Company invoice address2 | Yes | Yes | Text | Company |
| CMP_FACT_ADDRESS3 | Company invoice address3 | Yes | Yes | Text | Company |
| CMP_FACT_CITY | Company invoice city | Yes | Yes | Text | Company |
| CMP_FACT_COUNTRY | Company invoice country | Yes | Yes | Country | Company |
| CMP_SIGNUPDATE | Company signup date | Yes | Yes | Date | Company |
| CMP_EXPIREDATE | Company expiry date | Yes | Yes | Date | Company |
| CMP_STAFFEL | Company staffel | Yes | Yes | Number | 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 |
| CMP_LONGCUSTOM01 | Company long custom 1 | Yes | Yes | Text | Company |
| CMP_LONGCUSTOM02 | Company long custom 2 | Yes | Yes | Text | Company |
| CMP_LONGCUSTOM03 | Company long custom 3 | Yes | Yes | Text | Company |
| CMP_LONGCUSTOM04 | Company long custom 4 | Yes | Yes | Text | Company |
| CMP_LONGCUSTOM05 | Company long custom 5 | Yes | Yes | Text | Company |
| CMP_PAYMENTMETHOD | Company payment method | Yes | No | Text | Company |
| CMP_PAYMENTMETHOD_DESC | Company payment method description | Yes | No | Text | Company |
| CMP_BANKNAME | Company bankname | Yes | Yes | Text | Company |
| CMP_BANKACCOUNT | Company bankaccount | Yes | Yes | Text | Company |
| CMP_IBAN | Company IBAN | Yes | Yes | Text | Company |
| CMP_BIC | Company BIC | Yes | Yes | Text | Company |
| CMP_VATCODE | Company VAT Code | Yes | Yes | Text | Company |
| CMP_INVOICESENDING | Company method invoice | Yes | Yes | invoicesending | Company |
| CMP_MANDATEREF | Company mandateref | Yes | Yes | Text | Company |
| CMP_MANDATEDATE | Company mandatedate | Yes | Yes | Date | Company |
| CMP_ID_HIS | Company id his | Yes | Yes | Number | Company |
| CMP_CUST_ID | Company customer id | Yes | Yes | Number | Company |
| CMP_USER_ID | Company user id | Yes | Yes | Number | Company |
| CMP_FRAME_ID | Company frame id | Yes | Yes | Number | Company |
| GOTO_INVOICE | Invoicenumber | Yes | No | Text | Invoice |
| GOTO_BOOKING | Booking Id | Yes | No | Text | Invoice |
| DOWNLOAD_PDF | download | Yes | No | Text | Invoice |
| DETAIL_ACCOUNT_CODE | Detail-Account code | Yes | Yes | Text | Details |
| DETAIL_ACCOUNT_SIGN | Detail-Account sign | Yes | Yes | Text | Details |
| INV_PAID | INV_PAID | No | Yes | ||
| INV_PAYCURRENCY | INV_PAYCURRENCY | No | Yes | ||
| NEWSLETTER | Newsletter | No | Yes | ||
| DETAIL_FEE_ID | Detail-Fee ID | No | Yes | Text | |
| DETAIL_FEE_DESC | Detail-Fee | No | Yes | Text | |
| DETAIL_FEE_VAT | Detail-Fee VAT | No | Yes | Currency | |
| DETAIL_FEE_AMOUNT | Detail-Fee amount | No | Yes | Currency | |
| DETAIL_FEE_SUB | Detail-Fee sub | No | Yes | Currency | |
| DETAIL_FEE_VAT_EXCLUSIVE | Detail-VAT Excl. | No | Yes | Text | |
| INV_SUB_ID | INV_SUB_ID | No | Yes | ||
| CMP_PYM_ID | CMP_PYM_ID | No | Yes | ||
| COMMENT | Comment | No | Yes |
