# PaymentInformationSepaByEmploymentId Get a list of payment information sepa __Activity name :__ GetPaymentInformationSepaByEmploymentId Get a list of payment information for SEPA bank accounts (IBAN's) for an employment. For a specific payroll component, the record indicates to which IBAN payments will be made. This includes, but is not limited to, the payment of wages for an employment. For each payroll component there can only be one payment information record per employment. 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: `PaymentInformation` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns The columns of the table `PaymentInformationSepaByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `beneficiary_city` | `string(24)` | Beneficiary City | ☐ | City name of beneficiary. | | `beneficiary_name` | `string(70)` | Beneficiary Name | ☐ | Name of beneficiary. | | `bic` | `string(11)` | BIC | ☐ | BIC /SWIFT code. Only applicable for a non-Dutch IBAN | | `description1` | `string(32)` | Description 1 | ☐ | Description 1. Both description field values will be a line in the (unstructured) description of the SEPA file. | | `description2` | `string(32)` | Description 2 | ☐ | Description 2. Both description field values will be a line in the (unstructured) description of the SEPA file. | | `iban` | `string(35)` | IBAN | ☐ | International Bank Account Number (IBAN). Only IBAN without spaces are accepted. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollComponent_description` | `string(50)` | Payroll Component Description | ☐ | | | `payrollComponent_key` | `int32` | Payroll Component Key | ☐ | | | `visibleOnPayslip` | `boolean` | Visible on Payslip | ☐ | Indicates whether the payment-component is visible on a payslip. |