# FiscaleBedragenPerDienstverband: Fiscal per Employment - Name: `FiscaleBedragenPerDienstverband` - Catalog: `LoketNL` - Schema: `Lists` - Label: Fiscal per Employment ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `string` | ☑ | | | ## Table Columns The columns of the table `FiscaleBedragenPerDienstverband` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AFDRACHTVERMINDERINGONDERWIJS` | `int32` | Education Payroll Tax Reduction | ☐ | | | `AFWIJKENDBIJZONDEREKOSTENVERGOEDINGPERCENTAGE` | `decimal` | Deviating Special Expense Allowance Percentage | ☐ | | | `AFWIJKENDEKLEURLBTABEL` | `int32` | Deviating Colour Payroll Tax Table | ☐ | | | `AFWIJKENDLOONBELASTINGPERCENTAGE` | `decimal` | Deviating Payroll Tax Percentage | ☐ | | | `AFWIJKENDPERCENTAGETOEPASSEN` | `int32` | Apply Deviating Percentage | ☐ | | | `ARBEIDSKORTINGTOEPASSEN` | `int32` | Apply Labour Tax Credit | ☐ | | | `BIJZONDEREKOSTENVERGOEDING` | `int32` | Special Expense Allowance | ☐ | | | `CODELOONBELASTINGTABEL` | `int32` | Payroll Tax Table Code | ☐ | | | `DAGTABELTOEPASSEN` | `int32` | Apply Day Table | ☐ | | | `DATUMEINDE` | `datetime` | End Date | ☐ | | | `DATUMINGANG` | `datetime` | Start Date | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `JAARLOON` | `decimal` | Annual Salary | ☐ | | | `KLEINEBANENREGELING` | `int32` | Small Jobs Scheme | ☐ | | | `LOONINCLUSIEFAOWUITKERING` | `int32` | Salary Including AOW Benefit | ☐ | | | `LOONINCLUSIEFWAJONGUITKERING` | `int32` | Salary Including Wajong Benefit | ☐ | | | `PERCENTAGEBUITENLANDSINKOMEN` | `decimal` | Foreign Income Percentage | ☐ | | | `PERCENTAGEVERWERVINGSKOSTEN` | `decimal` | Acquisition Costs Percentage | ☐ | | | `PERSONEELSLENING` | `int32` | Employee Loan | ☐ | | | `SALARYSPLIT` | `int32` | Salary Split | ☐ | | | `SCHOLIERENREGELING` | `int32` | Student Scheme | ☐ | | | `SPECIALEAANDUIDING1` | `int32` | Special Designation 1 | ☐ | | | `SPECIALEAANDUIDING2` | `int32` | Special Designation 2 | ☐ | | | `SPECIALEAANDUIDING3` | `int32` | Special Designation 3 | ☐ | | | `SPECIALEAANDUIDING4` | `int32` | Special Designation 4 | ☐ | | | `UITZONDERING` | `int32` | Exception | ☐ | | | `VERVOERVANWEGEINHOUDINGSPLICHTIGE` | `int32` | Transport by Withholding Agent | ☐ | | | `WAARDEDAGZEGEL` | `decimal` | Day Stamp Value | ☐ | |