Documentation
Difficulty level:
Columns Company
The columns for the context company.
These are auto generated.
| Technical name | Display | Selectable | Searchable | Type | Entity |
|---|---|---|---|---|---|
| CREATED | Created | Yes | Yes | Datetime | |
| UPDATED | updated | Yes | Yes | Datetime | |
| COMP_ID | Company # | Yes | Yes | Number | |
| COMP_NAME | Companyname | Yes | Yes | Text | |
| COMP_EMAIL | Yes | Yes | Text | ||
| COMP_STATUS_CODE | COMP_STATUS_CODE | Yes | No | Text | |
| COMP_STATUS | Status | Yes | Yes | Text | |
| COMP_ACTIVATION | Activation | Yes | Yes | Text | |
| COMP_ACTIVE | Active | Yes | Yes | Text | |
| COMP_COLLECTIVE | Collective | Yes | Yes | Text | |
| COMP_COLLECTIVE_ENROLL | Enroll | Yes | Yes | Text | |
| NEWSLETTER | Newsletter | Yes | Yes | Text | |
| COMP_LABELS | Company Labels | Yes | Yes | Text | |
| 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 |
| COMP_PHONE | C-Phone | Yes | Yes | Text | |
| COMP_FAX | C-Fax | Yes | Yes | Text | |
| COMP_POSTAL | Postal | Yes | Yes | Text | |
| COMP_HOUSENUM | House number | Yes | Yes | Text | |
| COMP_HOUSENUMEXT | House number extension | Yes | Yes | Text | |
| COMP_ADDRESS1 | Address | Yes | Yes | Text | |
| COMP_ADDRESS2 | Address 2 | Yes | Yes | Text | |
| COMP_ADDRESS3 | Address 3 | Yes | Yes | Text | |
| COMP_CITY | City | Yes | Yes | Text | |
| COMP_COUNTRY | Country | Yes | Yes | Country | |
| COMP_SIGNUPDATE | Signup date | Yes | Yes | Date | |
| COMP_EXPIREDATE | Expiry date | Yes | Yes | Date | |
| COMP_FACT_POSTAL | Invoice postal | Yes | Yes | Text | |
| COMP_FACT_HOUSENUM | Invoice house number | Yes | Yes | Text | |
| COMP_FACT_HOUSENUMEXT | Invoice house number extension | Yes | Yes | Text | |
| COMP_FACT_ADDRESS1 | Invoice address | Yes | Yes | Text | |
| COMP_FACT_ADDRESS2 | Invoice address 2 | Yes | Yes | Text | |
| COMP_FACT_ADDRESS3 | Invoice address 3 | Yes | Yes | Text | |
| COMP_FACT_CITY | Invoice city | Yes | Yes | Text | |
| COMP_FACT_COUNTRY | Invoice country | Yes | Yes | Country | |
| COMP_BANKNAME | Bank name | Yes | Yes | Text | |
| COMP_BANKACCOUNT | Bankaccount | Yes | Yes | Text | |
| COMP_IBAN | IBAN | Yes | Yes | Text | |
| COMP_BIC | BIC | Yes | Yes | Text | |
| COMP_VATCODE | VAT Code | Yes | Yes | Text | |
| COMP_PAYMENTMETHOD | Payment customer method | Yes | Yes | Text | |
| COMP_PAYMENTMETHOD_DESC | Payment method customer description | Yes | No | Text | |
| COMP_INVOICESENDING | Method invoice | Yes | Yes | invoicesending | |
| USERID | User # | Yes | Yes | Text | User |
| USERNAME | Username | Yes | Yes | Text | User |
| CONTACT_ID | Contact # | Yes | Yes | Text | Customer |
| CONTACT_LASTNAME | Contact lastname | Yes | Yes | Text | Customer |
| CONTACT_EMAIL | Contact email | Yes | Yes | Text | Customer |
| CONTACT_INITIALS | Contact initials | Yes | Yes | Text | Customer |
| CONTACT_PREFIX | Contact prefix | Yes | Yes | Text | Customer |
| CONTACT_SEX | Contact gender | Yes | Yes | Sex | Customer |
| CUST_STATUS_NEW | Active# | Yes | No | Number | Customer |
| CUST_STATUS_ACTIVE | Cancelled, active# | Yes | No | Number | Customer |
| CUST_STATUS_CANCELLED | Cancelled# | Yes | No | Number | Customer |
| CONTACT_TYPE | Contact type | Yes | Yes | Text | Contacts |
| CONTACT_DETAIL | Contact detail | Yes | Yes | Text | Contacts |
| CONTACT_DESC | Contact description | Yes | Yes | Text | Contacts |
| COMMENT | Comment | No | Yes |
