Company
Stores company information, covering legal, operational, and contact-related metadata.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the company record. |
| Title | String | The title or designation of the company. |
| Name | String | The name of the company. |
| Country | String | The country in which the company operates. |
| Legalname | String | The legal name of the company. |
| Legalcountry | String | The legal country of registration for the company. |
| Federalid | String | The federal ID number for the company. |
| Contactname | String | The name of the primary contact for the company. |
| Contactphone | String | The phone number of the primary contact. |
| Contactemail | String | The email address of the primary contact. |
| Howheard | String | Information on how the company was referred or discovered. |
| Otherapps | String | Details of other applications or services used by the company. |
| Created | Datetime | The date and time when the company record was created. |
| Address1 | String | The primary address line of the company. |
| Address2 | String | The secondary address line of the company. |
| City | String | The city where the company is located. |
| State | String | The state or province where the company is located. |
| Legaladdress1 | String | The first line of the company's legal address. |
| Legaladdress2 | String | The second line of the company's legal address. |
| Legalcity | String | The city of the company's legal address. |
| Legalstate | String | The state or province of the company's legal address. |
| Zipcode | String | The postal code for the company's address. |
| Legalzipcode | String | The postal code for the company's legal address. |
| Logo | String | The logo associated with the company. |
| Type | String | The type or classification of the company. |
| Fax | String | The fax number for the company. |
| Status | String | The current status of the company. |
| Countrycode | String | The country code for the company's location. |
| Legalcountrycode | String | The country code for the company's legal registration. |
| Taxid | String | The tax identification number for the company. |
| Contractcustomerid | String | The contract customer ID associated with the company. |
| Ordercustomerid | String | The order customer ID associated with the company. |
| Record_url | String | A URL providing direct access to the company record. |