# PaymentInformationSepaByEmployerId List of payment information for an employer __Activity name:__ GetPaymentInformationSepaByEmployerId Get the list of sepa paymentinformation for all employments of an employer. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `Actuals` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `PaymentInformationSepaByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `paymentInformationSepa_bic` | `string(11)` | | ☐ | BIC /SWIFT code. Only applicable for a non-Dutch IBAN | | `paymentInformationSepa_cityBeneficiary` | `string(24)` | | ☐ | City name of beneficiary. | | `paymentInformationSepa_description1` | `string(32)` | | ☐ | Description 1. Both description field values will be a line in the (unstructured) description of the SEPA file. | | `paymentInformationSepa_description2` | `string(32)` | | ☐ | Description 2. Both description field values will be a line in the (unstructured) description of the SEPA file. | | `paymentInformationSepa_iban` | `string(35)` | | ☐ | International Bank Account Number (IBAN). Only IBAN without spaces are accepted. | | `paymentInformationSepa_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `paymentInformationSepa_nameBeneficiary` | `string(70)` | | ☐ | Name of beneficiary. | | `paymentInformationSepa_payrollComponent_key` | `int32` | | ☐ | | | `paymentInformationSepa_payrollComponent_value` | `string(50)` | | ☐ | | | `paymentInformationSepa_visibleOnPayslip` | `boolean` | | ☐ | Indicates whether the payment-component is visible on a payslip. |