# PaymentInformationSepaSeparatePaymentByEmploymentId Get a list of payment information SEPA separate payment records __Activity name :__ GetPaymentInformationSepaSeparatePaymentByEmploymentId Get a list of records that indicate, if applicable, the bank account(s) (i.e. IBAN's) where a given amount of the net salary for this employment will be paid to. 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: `PaymentInformationSeparatePayments` ## 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 `PaymentInformationSepaSeparatePaymentByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `double` | Amount | ☐ | The amount to be split from the net salary | | `cityBeneficiary` | `string(24)` | Beneficiary's City | ☐ | City name of beneficiary | | `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. | | `endDate` | `datetime` | End Date | ☐ | The end date of the record | | `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) | | `nameBeneficiary` | `string(70)` | Beneficiary's Name | ☐ | Name of beneficiary | | `startDate` | `datetime` | Start Date | ☐ | Start date of this record __NOTE :__ at the moment of performing a payroll run it will be checked what record is applicable for splitting from net salary at that date (based on the start- and enddate). |