# WerknemerVerloningsruns - Name: `WerknemerVerloningsruns` - Catalog: `LoketNL` - Schema: `Views` ## Table Columns The columns of the table `WerknemerVerloningsruns` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `wgr_ADMINISTRATIEKANTOORID` | `int32` | Administration Office ID | ☐ | | | `wgr_ADMINISTRATIENUMMER` | `string(30)` | Administration Number | ☐ | | | `wgr_AKTIEVEDIENSTVERBANDEN` | `int32` | Active Employments | ☐ | | | `wgr_BRANCHE` | `int32` | Industry | ☐ | | | `wgr_CONTACTPERSOONFUNCTIE` | `string(60)` | Contact Person Title | ☐ | | | `wgr_CONTACTPERSOONNAAM` | `string(240)` | Contact Person Name | ☐ | | | `wgr_CONTACTPERSOONTELEFOON` | `string(60)` | Contact Person Phone | ☐ | | | `wgr_EMAIL` | `string(60)` | Email | ☐ | | | `wgr_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `wgr_ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `wgr_EXTERNID` | `guid` | External ID | ☐ | | | `wgr_FAX` | `string(60)` | Fax Number | ☐ | | | `wgr_GROEPCODE` | `int32` | Group Code | ☐ | | | `wgr_HUISNUMMER` | `int32` | House Number | ☐ | | | `wgr_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `wgr_HUISNUMMERTOEVOEGING` | `string(30)` | House Number Addition | ☐ | | | `wgr_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `wgr_JAARFILTER` | `int32` | Year Filter | ☐ | | | `wgr_KVKNUMMER` | `string(60)` | CoC Number | ☐ | | | `wgr_LAND` | `int32` | Country | ☐ | | | `wgr_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `wgr_LOCATIE` | `string(120)` | Location | ☐ | | | `wgr_LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `wgr_NAAM` | `string(120)` | Name | ☐ | | | `wgr_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `wgr_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `wgr_ONDERDEELVANWERKGEVERID` | `int32` | Part of Employer ID | ☐ | | | `wgr_PLAATSNAAM` | `string(60)` | City | ☐ | | | `wgr_PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `wgr_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `wgr_POSTCODE` | `string(30)` | ZIP Code | ☐ | | | `wgr_POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `wgr_PRODUCTSETID` | `int32` | Product Set ID | ☐ | | | `wgr_PROVINCIE` | `int32` | State | ☐ | | | `wgr_RECHTSVORM` | `int32` | Legal Form | ☐ | | | `wgr_SBI` | `int32` | SBI | ☐ | | | `wgr_STRAATNAAM` | `string(60)` | Street Name | ☐ | | | `wgr_STRAATNAAMAFWIJKEND` | `string(60)` | Deviating Street Name | ☐ | | | `wgr_TELEFOON` | `string(60)` | Phone | ☐ | | | `wgr_UPLOADLIMIET` | `int32` | Upload Limit | ☐ | | | `wgr_UPLOADVERBRUIK` | `decimal` | Upload Usage | ☐ | | | `wgr_URL` | `string(120)` | URL | ☐ | | | `wgr_WEBSITELOGOID` | `int32` | Website Logo ID | ☐ | | | `wgr_WERKGEVERAFBEELDINGID` | `int32` | Employer Image ID | ☐ | | | `wgr_WERKGEVERID` | `int32` | Employer ID | ☐ | | | `wgr_WIJZEVERZENDEN` | `int32` | Dispatch Method | ☐ | | | `wvn_AANTAL` | `int32` | Quantity | ☐ | | | `wvn_CLIENTNUMMER` | `int32` | Client Number | ☐ | | | `wvn_DATUMAFGEHANDELD` | `datetime` | Date Processed | ☐ | | | `wvn_EIGENLOGODATA` | `byte[]` | Own Logo Data | ☐ | | | `wvn_EIGENLOGOLOCATIE` | `string(240)` | Own Logo Location | ☐ | | | `wvn_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `wvn_LOONSTROOKADRESLOCATIE` | `int32` | Payslip Address Location | ☐ | | | `wvn_LOONSTROOKBESTANDSNAAM` | `string(480)` | Payslip File Name | ☐ | | | `wvn_PERIODEOMSCHRIJVING` | `string(120)` | Period Description | ☐ | | | `wvn_VERLONINGID` | `int32` | Payroll ID | ☐ | |