# VerloningsrunsPerVerloning: Payroll Runs per Payroll - Name: `VerloningsrunsPerVerloning` - Catalog: `LoketNL` - Schema: `Lists` - Label: Payroll Runs per Payroll ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `verloningId` | `string` | ☑ | | | ## Table Columns The columns of the table `VerloningsrunsPerVerloning` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CLIENTNR` | `int32` | Client Number | ☐ | | | `DATUMAANMAAKJOURNALISERING` | `datetime` | Journalising Creation Date | ☐ | | | `DATUMAFGEHANDELD` | `datetime` | Date Processed | ☐ | | | `DATUMBESCHIKBAARESS` | `datetime` | Date Available ESS | ☐ | | | `DATUMESSMAIL` | `datetime` | ESS Mail Date | ☐ | | | `DATUMOPDRACHT` | `datetime` | Assignment Date | ☐ | | | `DATUMVERLONING` | `datetime` | Payroll Date | ☐ | | | `DATUMVERWIJDERD` | `datetime` | Date Deleted | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `FOUTSIGNAALAANWEZIG` | `int32` | Has Error Signal | ☐ | | | `GEBRUIKERIDAFGEHANDELDDOOR` | `int32` | Handled By User ID | ☐ | | | `GEBRUIKERIDVERWIJDERDDOOR` | `int32` | Deleted By User ID | ☐ | | | `GEBRUIKERIDVERZOEK` | `int32` | Request User ID | ☐ | | | `PERIODE` | `int32` | Period | ☐ | | | `PERIODELOONAANGIFTE` | `string(60)` | Payroll Tax Return Period | ☐ | | | `STATUS` | `int32` | Status | ☐ | | | `TEKSTEXCASSO` | `string(240)` | Excasso Text | ☐ | | | `TEKSTSTROOK` | `string(240)` | Payslip Text | ☐ | | | `VOLGNUMMER` | `int32` | Sequence Number | ☐ | | | `VOLGNUMMERGOEDGEKEURD` | `int32` | Approval Sequence Number | ☐ | | | `WIJZEAANMAAK` | `int32` | Creation Method | ☐ | |