# VerloningenPerWerkgever: Payrolls per Employer - Name: `VerloningenPerWerkgever` - Catalog: `LoketNL` - Schema: `Lists` - Label: Payrolls per Employer ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `string` | ☑ | | | ## Table Columns The columns of the table `VerloningenPerWerkgever` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AANTALDAGENBESCHIKBAARESS` | `int32` | Number of Days Available ESS | ☐ | | | `AFGENOMENPRODUCTID` | `int32` | Purchased Product ID | ☐ | | | `AFWIJKENDEDAGENURENVIAROOSTER` | `int32` | Deviating Days Hours via Schedule | ☐ | | | `BASISDIENSTVERBAND` | `int32` | Base Employment | ☐ | | | `BASISLOONEENHEID` | `int32` | Base Salary Unit | ☐ | | | `BEREKENENURENGEBROKENPERIODEVIAROOSTER` | `int32` | Calculate Hours Broken Period via Schedule | ☐ | | | `BEREKENENURENPERIODEVIAROOSTER` | `int32` | Calculate Hours Period via Schedule | ☐ | | | `BRANCHELOKET` | `int32` | Industry Desk | ☐ | | | `CAO` | `int32` | CAO | ☐ | | | `CLIENTNR` | `int32` | Client Number | ☐ | | | `CONTACTINFORMATIESYNCHRONISEREN` | `int32` | Synchronise Contact Information | ☐ | | | `DAGENDAGVERGOEDINGVIAROOSTER` | `int32` | Days Daily Allowance via Schedule | ☐ | | | `DATUMEINDE` | `datetime` | End Date | ☐ | | | `DATUMINGANG` | `datetime` | Start Date | ☐ | | | `EERSTEDAGSMELDING` | `int32` | First Day Notification | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `FULLTIMEUREN` | `decimal` | Hours in Full Time | ☐ | | | `GRONDSLAGEINDEJAARSUITKERING` | `int32` | Year-End Bonus Basis | ☐ | | | `GRONDSLAGVAKANTIETOESLAG` | `int32` | Holiday Allowance Basis | ☐ | | | `NAWSYNCHRONISEREN` | `int32` | Synchronise Name and Address | ☐ | | | `NETTOLOONEENHEID` | `int32` | Net Salary Unit | ☐ | | | `OMSCHRIJVING` | `string(240)` | Description | ☐ | | | `PERCENTAGEEINDEJAARSUITKERING` | `decimal` | Year-End Bonus Percentage | ☐ | | | `PERCENTAGEVAKANTIETOESLAG` | `decimal` | Holiday Allowance Percentage | ☐ | | | `PERIODE` | `int32` | Period | ☐ | | | `SOORTDIENSTVERBAND` | `int32` | Employment Type | ☐ | | | `SOORTWERKNEMER` | `int32` | Employee Type | ☐ | | | `STANDAARDCATEGORIECODEBROWSERVARGEG` | `int32` | Default Category Code Browser Variable Data | ☐ | | | `STANDAARDEXPORTSETCODEBROWSERVARGEG` | `int32` | Default Export Set Code Browser Variable Data | ☐ | | | `STANDAARDEXPORTSETCODEVARGEGINDIVIDUEEL` | `int32` | Default Export Set Code Variable Data Individual | ☐ | | | `STANDAARDEXPORTSETWERKKOSTENREGELING` | `int32` | Default Export Set Work Cost Scheme | ☐ | | | `VERLONINGID` | `int32` | Payroll ID | ☐ | |