# ActualPaymentInformationNonSepaByEmployerId List of actual payment information non sepa for an employer __Activity name:__ GetActualPaymentInformationNonSepaByEmployerId Get the list of actual payment information non sepa records 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 `ActualPaymentInformationNonSepaByEmployerId` 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) | | `paymentInformationNonSepa_bank_address` | `string(35)` | | ☐ | Address of beneficiary bank | | `paymentInformationNonSepa_bank_bankIdentifierCode` | `string(11)` | | ☐ | BIC /SWIFT code for the bank | | `paymentInformationNonSepa_bank_city` | `string(35)` | | ☐ | City name of beneficiary bank | | `paymentInformationNonSepa_bank_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `paymentInformationNonSepa_bank_country_key` | `int32` | | ☐ | The key for the country. Possible values can be aquired via the metadata endpoint | | `paymentInformationNonSepa_bank_country_value` | `string(50)` | | ☐ | The name of the country | | `paymentInformationNonSepa_bank_name` | `string(35)` | | ☐ | Name of benificiary bank | | `paymentInformationNonSepa_bankAccountNumber` | `string(34)` | | ☐ | The bank account number | | `paymentInformationNonSepa_beneficiary_address` | `string(35)` | | ☐ | Address of beneficiary | | `paymentInformationNonSepa_beneficiary_city` | `string(35)` | | ☐ | City name of beneficiary | | `paymentInformationNonSepa_beneficiary_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `paymentInformationNonSepa_beneficiary_country_key` | `int32` | | ☐ | The key for the country. Possible values can be aquired via the metadata endpoint | | `paymentInformationNonSepa_beneficiary_country_value` | `string(50)` | | ☐ | The name of the country | | `paymentInformationNonSepa_beneficiary_name` | `string(35)` | | ☐ | Name of the beneficiary | | `paymentInformationNonSepa_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `paymentInformationNonSepa_payrollComponent_key` | `int32` | | ☐ | The number for the payroll component | | `paymentInformationNonSepa_payrollComponent_value` | `string(14)` | | ☐ | The description of the payroll component |