# Werkgevers: Employers - Name: `Werkgevers` - Catalog: `LoketNL` - Schema: `Lists` - Label: Employers ## Table Columns The columns of the table `Werkgevers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADMINISTRATIEKANTOORID` | `int32` | Administration Office ID | ☐ | | | `ADMINISTRATIENUMMER` | `string(30)` | Administration Number | ☐ | | | `AKTIEVEDIENSTVERBANDEN` | `int32` | Active Employments | ☐ | | | `BRANCHE` | `int32` | Industry | ☐ | | | `CONTACTPERSOONFUNCTIE` | `string(60)` | Contact Person Title | ☐ | | | `CONTACTPERSOONNAAM` | `string(240)` | Contact Person Name | ☐ | | | `CONTACTPERSOONTELEFOON` | `string(60)` | Contact Person Phone | ☐ | | | `EMAIL` | `string(60)` | Email | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `EXTERNID` | `guid` | External ID | ☐ | | | `FAX` | `string(60)` | Fax Number | ☐ | | | `GROEPCODE` | `int32` | Group Code | ☐ | | | `HUISNUMMER` | `int32` | House Number | ☐ | | | `HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `HUISNUMMERTOEVOEGING` | `string(30)` | House Number Addition | ☐ | | | `HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `JAARFILTER` | `int32` | Year Filter | ☐ | | | `KVKNUMMER` | `string(60)` | CoC Number | ☐ | | | `LAND` | `int32` | Country | ☐ | | | `LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `LOCATIE` | `string(120)` | Location | ☐ | | | `LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `NAAM` | `string(120)` | Name | ☐ | | | `NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `ONDERDEELVANWERKGEVERID` | `int32` | Part of Employer ID | ☐ | | | `PLAATSNAAM` | `string(60)` | City | ☐ | | | `PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `POSTCODE` | `string(30)` | ZIP Code | ☐ | | | `POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `PRODUCTSETID` | `int32` | Product Set ID | ☐ | | | `PROVINCIE` | `int32` | State | ☐ | | | `RECHTSVORM` | `int32` | Legal Form | ☐ | | | `SBI` | `int32` | SBI | ☐ | | | `STRAATNAAM` | `string(60)` | Street Name | ☐ | | | `STRAATNAAMAFWIJKEND` | `string(60)` | Deviating Street Name | ☐ | | | `TELEFOON` | `string(60)` | Phone | ☐ | | | `UPLOADLIMIET` | `int32` | Upload Limit | ☐ | | | `UPLOADVERBRUIK` | `decimal` | Upload Usage | ☐ | | | `URL` | `string(120)` | URL | ☐ | | | `WEBSITELOGOID` | `int32` | Website Logo ID | ☐ | | | `WERKGEVERAFBEELDINGID` | `int32` | Employer Image ID | ☐ | | | `WERKGEVERID` | `int32` | Employer ID | ☐ | | | `WIJZEVERZENDEN` | `int32` | Dispatch Method | ☐ | |