pixiDatevExportPosWires
Exports POS Cash Payments.
Since pixi version: 19.07 (9.0.5.40719) Additional notes:
Request
Request body
Name | Type | Required | Description |
---|---|---|---|
DateTo | string | true | POS Invoice date filter - show older records as set with this parameter. Type: datetime Default value: Example: Available from: 19.07 (9.0.5.40719) |
ShopId | string | false | Id (Short name) from table dbo.Shops . Type: varchar(3) Default value: NULL Example: QA Available from: 19.07 (9.0.5.40719) |
AmoutTo | number | false | POS Payment Amount filter - amount smaller than. Type: money Default value: NULL Example: 99 Available from: 19.07 (9.0.5.40719) |
Country | string | false | Country Code from dbo.Addresses. Type: varchar(3) Default value: NULL Example: SLO Available from: 19.07 (9.0.5.40719) |
DateFrom | string | true | POS Invoice date filter - show newer records as set with this parameter. Type: datetime Default value: Example: Available from: 19.07 (9.0.5.40719) |
AmoutFrom | number | false | POS Payment Amount filter - amount greater than. Type: money Default value: NULL Example: 10 Available from: 19.07 (9.0.5.40719) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiDatevExportPosWires>
<DateFrom>string</DateFrom>
<DateTo>string</DateTo>
<ShopId>string</ShopId>
<Country>string</Country>
<AmoutFrom>0</AmoutFrom>
<AmoutTo>0</AmoutTo>
</pixiDatevExportPosWires>
</Body>
</Envelope>
Response
1. DATEV POS Cash Payments
Name | Type | Description |
---|---|---|
Sign | string | Amount sign (positive or negative) Type: varchar (1) Available from: 25.06 (25.6.0.58802) |
Amount | number | Amount Type: money Available from: 25.06 (25.6.0.58802) |
Empty1 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
Empty2 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
Empty3 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
Empty4 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
Empty5 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
Empty6 | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
BankDate | string | Date (finish) of POS Invoice Type: datetime Available from: 25.06 (25.6.0.58802) |
Currency | string | Amount Currency (EUR) Type: varchar (3) Available from: 25.06 (25.6.0.58802) |
WireText | string | Not Used Type: varchar (100) Available from: 25.06 (25.6.0.58802) |
InvoiceNr | string | POS Invoice Number Type: varchar (30) Available from: 25.06 (25.6.0.58802) |
CustomerNr | string | External Customer Number Type: varchar (255) Available from: 25.06 (25.6.0.58802) |
BankAccountNr | string | Bank Account for POS Payments Type: varchar (255) Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiDatevExportPosWiresPost200TextXmlResponse>
<Currency>string</Currency>
<Sign>string</Sign>
<Amount>0</Amount>
<Empty1>string</Empty1>
<CustomerNr>string</CustomerNr>
<InvoiceNr>string</InvoiceNr>
<Empty2>string</Empty2>
<BankDate>string</BankDate>
<BankAccountNr>string</BankAccountNr>
<Empty3>string</Empty3>
<Empty4>string</Empty4>
<Empty5>string</Empty5>
<Empty6>string</Empty6>
<WireText>string</WireText>
</PixiDatevExportPosWiresPost200TextXmlResponse>
HTTP Example
POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
# echo -n '{{username}}:{{password}}' | base64 | pbcopy
Authorization: Basic {{token}}
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns1="https://apigateway.descartes.com/tms/pixi/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<ns1:pixiDatevExportPosWires>
<DateTo xsi:type="xsd:string"></DateTo> <!-- required -->
<ShopId xsi:type="xsd:string">QA</ShopId>
<AmoutTo xsi:type="xsd:number">99</AmoutTo>
<Country xsi:type="xsd:string">SLO</Country>
<DateFrom xsi:type="xsd:string"></DateFrom> <!-- required -->
<AmoutFrom xsi:type="xsd:number">10</AmoutFrom>
</ns1:pixiDatevExportPosWires>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
PHP Example
<?php
getPixiSoapClientResponse('pixiDatevExportPosWires', [
'DateTo' => '', // string (required)
'ShopId' => 'QA', // string
'AmoutTo' => '99', // number
'Country' => 'SLO', // string
'DateFrom' => '', // string (required)
'AmoutFrom' => '10', // number
]);
function getPixiSoapClientResponse(string $method, array $arguments = [])
{
$soapArguments = [];
foreach ($arguments as $key => $value) {
$soapArguments[] = new SoapVar($value, null, '', '', $key);
}
$soapClient = new SoapClient(null, [
'login' => '...',
'password' => '...',
'uri' => 'https://apigateway.descartes.com/tms/pixi/',
'location' => 'https://apigateway.descartes.com/tms/pixi/',
]);
return $soapClient->__call($method, $soapArguments);
}