Complete list of companies defined in Clock PMS+. The companies are shared across the different accounts of the subscription and are used as companies and agents.
Fields
Field name | Type | Description/Notes |
id | INTEGER | Unique identifier of the company across the entire Clock PMS+ ecosystem* |
name | STRING | Name* |
branch | STRING | Identifier of the branch (London, New York,... East, west, etc) |
created_at | TIMESTAMP | Time created (Date and time in UTC)* |
updated_at | TIMESTAMP | Time lastly updated (Date and time in UTC)* |
archived_at | TIMESTAMP | Time archived (Date and time in UTC) |
notes | STRING | Company notes |
links | STRING | Company links |
accept_charge_transfers | BOOLEAN | true/false specifies if the company may accept additional charges for Clock POS or other system* |
payment_terms_days | INTEGER | Days for delayed payments. Used for calculation of the payment due date of the invoice and affecting the aging in AR |
credit_limit_cents | INTEGER | Credit limit amount agreed with this company in cents (10 EUR = 1000 cents) |
currency | STRING | Credit limit currency |
vat | STRING | VAT number. Shown on the invoice |
iata | STRING | IATA number of the company |
channel_manager_search_code | STRING | Code of the company for the channel manager. Used for company recognition |
wbe_access_code | STRING | WRS access code for this company |
wbe_role | STRING | How the WRS should treat the profile - as ‘Agent’ in the booking or as ‘Company’ |
commission_rate | NUMERIC | Commission % payable to this company profile |
commission_revenue_groups | STRING | Revenue groups based on which the commission amount will be calculated. Array |
report_segment_id | INTEGER | Relation to report_segments table which is holding the segment |
contact_persons_ids | INTEGER | ID/s of guests associated with the company profile. The IDs are relations to guests table. Array |
second_identification | STRING | Second ID number of the company (if available). Shown on the invoice |
billing_name | STRING | Billing name. Shown on the invoice* |
billing_person_name | STRING | Name of a person from the company. Will be shown on the invoice |
billing_country | STRING | Country of the company ALPHA-2 (ISO 3166). Shown on the invoice |
billing_address | STRING | Billing address of the company. Shown on the invoice |
billing_city | STRING | Billing city of the company. Shown on the invoice |
billing_state | STRING | Billing state of the company. Shown on the invoice |
billing_zip_code | STRING | Billing ZIP code of the company. Shown on the invoice |
additional_billing_info | STRING | Additional billing info. Shown on the invoice |
contact_first_name | STRING | First name of the main contact for the company |
contact_middle_name | STRING | Middle name of the main contact for the company |
contact_last_name | STRING | Last name of the main contact for the company |
contact_country | STRING | Country of the main contact for the company ALPHA-2 (ISO 3166). |
contact_city | STRING | City of the main contact for the company |
contact_address | STRING | Address of the main contact for the company |
contact_zip_code | STRING | ZIP code of the main contact for the company |
contact_phone_number | STRING | Phone number of the main contact for the company |
contact_e_mail | STRING | e-mail of the main contact for the company |
contact_fax_number | STRING | FAX number of the main contact for the company |
contact_state | STRING | State of the main contact for the company |
custom_field_xxx** | STRING |
* Field will have value for every record
** All fields after contact_state filed depend on the Clock PMS+ account configuration and would differ for he different customers!