# PaymentInformationNonSepaBypaymentInformationNonSepaId Get the details of a payment information non-SEPA __Activity name :__ GetPaymentInformationNonSepaByPaymentInformationNonSepaId Get the detail of a payment information non-SEPA record. For a specific payroll component, the record indicates to which IBAN account number it should be related for the purpose of outgoing payments. This includes, but is not limited to, the payment of wages for an employment. For each payroll component there can only be one outgoing payment 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: `PaymentInformationNon-SEPA` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `paymentInformationNonSepaId` | `guid` | ☑ | | The unique identifier of the SEPA payment record | ## Columns The columns of the table `PaymentInformationNonSepaBypaymentInformationNonSepaId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `bank_address` | `string(35)` | Bank Address | ☐ | Address of beneficiary bank | | `bank_bankIdentifierCode` | `string(11)` | Bank Identifier Code | ☐ | BIC /SWIFT code for the bank | | `bank_city` | `string(35)` | Bank City | ☐ | City name of beneficiary bank | | `bank_country_isoCode` | `string(2)` | Bank Country ISO Code | ☐ | The ISO 3166-1 alpha-2 value for the country | | `bank_country_key` | `int32` | Bank Country Code | ☐ | The key for the country. Possible values can be aquired via the metadata endpoint | | `bank_country_value` | `string(50)` | Bank Country Value | ☐ | The name of the country | | `bank_name` | `string(35)` | Bank Name | ☐ | Name of benificiary bank | | `bankAccountNumber` | `string(34)` | Bank Account Number | ☐ | The bank account number | | `beneficiary_address` | `string(35)` | | ☐ | Address of beneficiary | | `beneficiary_city` | `string(35)` | Beneficiary City | ☐ | City name of beneficiary | | `beneficiary_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `beneficiary_country_key` | `int32` | | ☐ | The key for the country. Possible values can be aquired via the metadata endpoint | | `beneficiary_country_value` | `string(50)` | | ☐ | The name of the country | | `beneficiary_name` | `string(35)` | Beneficiary Name | ☐ | Name of the beneficiary | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollComponent_key` | `int32` | Payroll Component Key | ☐ | The number for the payroll component | | `payrollComponent_value` | `string(14)` | | ☐ | The description of the payroll component |