# Companies: Gripp CRM Companies - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Companies - Retrieve: True ## Table Columns The columns of the table `Companies` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountmanager_discr` | `varchar2` | | ☐ | | | `accountmanager_id` | `int32` | Accountmanager ID | ☐ | | | `accountmanager_searchname` | `varchar2` | Accountmanager Search Name | ☐ | | | `active` | `char` | Active | ☐ | | | `additionaltermofpayment` | `int32` | Additional Term of Payment | ☐ | | | `bankaccount` | `varchar2` | Bank Account | ☐ | | | `bankascription` | `varchar2` | | ☐ | | | `bankcity` | `varchar2` | Bank City | ☐ | | | `bic` | `varchar2` | BIC | ☐ | | | `cocnumber` | `varchar2` | CoC Number | ☐ | | | `companyname` | `varchar2` | Company Name | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `customernumber` | `int32` | Customer Number | ☐ | | | `dateofbirth_date` | `datetime` | Date of Birth (Date) | ☐ | | | `dateofbirth_timezone_type` | `int32` | Date of Birth (Timezone Type) | ☐ | | | `dateofbirth_timezone` | `varchar2` | Date of Birth (Timezone) | ☐ | | | `email` | `varchar2` | Email | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `externalreference` | `varchar2` | External Reference | ☐ | | | `firstname` | `varchar2` | First Name | ☐ | | | `foundationdate_date` | `datetime` | Foundation Date (Date) | ☐ | | | `foundationdate_timezone_type` | `int32` | Foundation Date (Timezone Type) | ☐ | | | `foundationdate_timezone` | `varchar2` | Foundation Date (Timezone) | ☐ | | | `id` | `int32` | ID | ☐ | | | `identity_discr` | `varchar2` | | ☐ | | | `identity_id` | `int32` | Identity ID | ☐ | | | `identity_searchname` | `varchar2` | Identity Search Name | ☐ | | | `infix` | `varchar2` | Infix | ☐ | | | `initials` | `varchar2` | Initials | ☐ | | | `invoiceaddress_addressline2` | `varchar2` | Invoice Address Address Line 2 | ☐ | | | `invoiceaddress_attn` | `varchar2` | Invoice Address Attention | ☐ | | | `invoiceaddress_city` | `varchar2` | Invoice Address City | ☐ | | | `invoiceaddress_companyname` | `varchar2` | Invoice Address Company Name | ☐ | | | `invoiceaddress_country` | `varchar2` | Invoice Address Country | ☐ | | | `invoiceaddress_street` | `varchar2` | Invoice Address Street | ☐ | | | `invoiceaddress_streetnumber` | `varchar2` | Invoice Address Street Number | ☐ | | | `invoiceaddress_zipcode` | `varchar2` | Invoice Address ZIP Code | ☐ | | | `invoiceemail` | `varchar2` | Invoice Email | ☐ | | | `invoicesendby_discr` | `varchar2` | | ☐ | | | `invoicesendby_id` | `int32` | Invoice Send by ID | ☐ | | | `invoicesendby_searchname` | `varchar2` | Invoice Send by Search Name | ☐ | | | `invoicesendto_discr` | `varchar2` | | ☐ | | | `invoicesendto_id` | `int32` | Invoice Send to ID | ☐ | | | `invoicesendto_searchname` | `varchar2` | Invoice Send to Search Name | ☐ | | | `lastname` | `varchar2` | Last Name | ☐ | | | `legalname` | `varchar2` | | ☐ | | | `mobile` | `varchar2` | Mobile | ☐ | | | `notes` | `varchar2` | Notes | ☐ | | | `paymentmethod_discr` | `varchar2` | | ☐ | | | `paymentmethod_id` | `int32` | Payment Method ID | ☐ | | | `paymentmethod_purchaseinvoice_discr` | `varchar2` | | ☐ | | | `paymentmethod_purchaseinvoice_id` | `int32` | Payment Method Purchase Invoice ID | ☐ | | | `paymentmethod_purchaseinvoice_searchname` | `varchar2` | Payment Method Purchase Invoice Search Name | ☐ | | | `paymentmethod_searchname` | `varchar2` | Payment Method Search Name | ☐ | | | `phone` | `varchar2` | Phone | ☐ | | | `postaddress_addressline2` | `varchar2` | Post Address Address Line 2 | ☐ | | | `postaddress_city` | `varchar2` | Post Address City | ☐ | | | `postaddress_country` | `varchar2` | Post Address Country | ☐ | | | `postaddress_discr` | `varchar2` | | ☐ | | | `postaddress_id` | `int32` | Post Address ID | ☐ | | | `postaddress_searchname` | `varchar2` | Post Address Search Name | ☐ | | | `postaddress_street` | `varchar2` | Post Address Street | ☐ | | | `postaddress_streetnumber` | `varchar2` | Post Address Street Number | ☐ | | | `postaddress_zipcode` | `varchar2` | Post Address ZIP Code | ☐ | | | `relationtype_discr` | `varchar2` | | ☐ | | | `relationtype_id` | `int32` | Relation Type ID | ☑ | | | `relationtype_searchname` | `varchar2` | Relation Type Search Name | ☑ | | | `salutation_discr` | `varchar2` | | ☐ | | | `salutation_id` | `int32` | Salutation ID | ☐ | | | `salutation_searchname` | `varchar2` | Salutation Search Name | ☐ | | | `screenname` | `varchar2` | Screen Name | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `termofpayment_purchaseinvoice` | `int32` | Term of Payment Purchase Invoice | ☐ | | | `termofpayment` | `int32` | Term of Payment | ☐ | | | `title` | `varchar2` | Title | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | | | `vat_discr` | `varchar2` | | ☐ | | | `vat_id` | `int32` | VAT ID | ☐ | | | `vat_searchname` | `varchar2` | VAT Search Name | ☐ | | | `vatnumber` | `varchar2` | VAT Number | ☐ | | | `vatshifted` | `char` | VAT Shifted | ☐ | | | `visitingaddress_addressline2` | `varchar2` | Visit Address Address Line 2 | ☐ | | | `visitingaddress_city` | `varchar2` | Visit Address City | ☐ | | | `visitingaddress_country` | `varchar2` | Visit Address Country | ☐ | | | `visitingaddress_lat` | `varchar2` | Visit Address Latitude | ☐ | | | `visitingaddress_lng` | `varchar2` | Visit Address Longitude | ☐ | | | `visitingaddress_street` | `varchar2` | Visit Address Street | ☐ | | | `visitingaddress_streetnumber` | `varchar2` | Visit Address Street Number | ☐ | | | `visitingaddress_zipcode` | `varchar2` | Visit Address ZIP Code | ☐ | | | `website` | `varchar2` | Website | ☐ | |