Resource: salespaymentlist.nv
HTTP-method: GET
Resource for retrieving the sales transaction list.
Querystring parameters:
| Parameter | Occurs | Description | Example |
| --- | --- | --- | --- |
| abovenetvisorkey | 0...1 | Returns only payments with id greater than the given value | |
| begindate | 0...1 | Start of the date range | 2021-10-23 |
| enddate | 0...1 | End of the date range | 2021-10-24 |
| searchbyname | 0...1 | Searches by payment name | |
| limitlinkedpayments | 0...1 | Limits based on linked invoices
0 - payment does not have an invoice linked to it
1 - payment must have an invoice linked to it | 0 |
| limitbytype | 0...1 | Limits based on payment type
onlycreditloss - lists only credit losses
excludecreditloss - lists all others, except credit losses | excludecreditloss |
| lastmodifiedstart | 0...1 | Returns sales transactions that have been modified after the given date. Given as yyyy-MM-ddTHH:mm:ss | 2019-12-10T12:00:00 |
| lastmodifiedend | 0...1 | Returns sales transactions that have been modified before the given date. Given as yyyy-MM-ddTHH:mm:ss | 2019-12-20T12:00:00 |
| invoicenetvisorkey | 0...1 | Returns payments related to a specific sales invoice by the given sales invoice's NetvisorKey | 123 |
| invoicenumber | 0...1 | Returns payments related to a specific sales invoice by the given sales invoice's invoice number | 54684 |
| replyoption | 0...1 | Returns the reference payment archive identifier, raw record, or both inside the Bank aggregate.
Value 1: returns the reference payment archive identifier (ArchiveIdentifier)
Value 2: returns the reference payment raw record (TransactionRecord)
Value 3: returns both | 2 |
Response:
| Level | Element | Type | Occurs | Description | Example |
| --- | --- | --- | --- | --- | --- |
| root | Root | Aggregate | 1 | | |
| 1 | SalespaymentList | Aggregate | 1 | | |
| 2 | SalesPayment | Aggregate | 0...n | | |
| 3 | NetvisorKey | Numeric | 1 | Payment Netvisor identifier | |
| 3 | Name | String | 1 | Name of the payer | |
| 3 | Date | Date | 1 | Date of the payment | |
| 3 | Sum | Numeric | 1 | Sum of the payment | |
| 3 | ReferenceNumber | String | 1 | Reference number of the payment | |
| 3 | ForeignCurrencyAmount | Numeric | 1 | Foreign currency amount of the payment | |
| 3 | InvoiceNumber | Numeric | 1 | Invoice number | |
| 3 | PaymentAccountName | String | 1 | Name of the bank/payment method | cash |
| 3 | VoucherID | Numeric | 1 | Voucher NetvisorKey for the payment | 44 |
| 3 | LastModifiedTimestamp | Numeric | 1 | Latest modification time of the voucher | 7.10.2021 14:24:42 |
| 3 | PaymentAccountNumber | String | 1 | Account number of the payee. Biller's account number. | FI12 3456 xxx |
| 3 | PaymentSource | Numeric | 1 | Source of the payment
(1 = reference payment
2 = credit note
3 = financing service
99 = other) | 1 |
| 3 | BankStatus | String | 1 | Bank status of the payment. Always OK | OK |
| 3 | Bank | Aggregate | 0..1 | Returned if replyoption parameter is used | |
| 4 | ArchiveIdentifier | String | 0..1 | Reference payment archive identifier | 1104232 |
| 4 | TransactionRecord | String | 0..1 | Reference payment raw record | 325049230 |
This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.