Description

Exports POS Cash Payments.

Request Parameters

#	Name	Type	Required	Example	Description
1	DateFrom	string	1	YYYY-MM-DD hh:mm:ss	POS Invoice date filter - show newer records as set with this parameter.
2	DateTo	string	1	YYYY-MM-DD hh:mm:ss	POS Invoice date filter - show older records as set with this parameter.
3	ShopId	string	0	QA	Id (Short name) from table dbo.Shops .
4	ShowOnlySums	boolean	0	0	Show short or extender Resulset.
5	Country	string	0	SLO	Country Code from dbo.Addresses.
6	InvoiceNr	string	0	2019-Kasse1-1	POS Invoice Number.
7	OrderNrExternal	string	0	20190303145930	External Order Number connected with this POS Invoice.
8	BookKeepingAccount	string	0	99	Account number for selected Payment Type or default (DB Setting AccountNumberPOSPayment).

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiDatevExportPosInvoices>
         <dem:DateFrom>YYYY-MM-DD hh:mm:ss</dem:DateFrom>
         <dem:DateTo>YYYY-MM-DD hh:mm:ss</dem:DateTo>
         <dem:ShopId>QA</dem:ShopId>
         <dem:ShowOnlySums>0</dem:ShowOnlySums>
         <dem:Country>SLO</dem:Country>
         <dem:InvoiceNr>2019-Kasse1-1</dem:InvoiceNr>
         <dem:OrderNrExternal>20190303145930</dem:OrderNrExternal>
         <dem:BookKeepingAccount>99</dem:BookKeepingAccount>
      </dem:pixiDatevExportPosInvoices>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: DATEV POS Invoices

#	Name	Type	Description
1	Source	string	Source of record - POS Invoice or POS Payment
2	OrderCurrency	string	Database Home Currency
3	PHDate	string	Date (finish) of POS Invoice
4	Country	string	Country Code from dbo.Addresses
5	MwstSatz	integer	Item VAT (1 - High, 2 - Low, 3 - Zero)
6	Sign	string	Amount sign (positive or negative)
7	Price	number	(line) Item Price
8	PriceInCents	string	(line) Item Price in cents
9	VatCode	integer	VAT Code for Book Keeping
10	BookKeepingAccount	string	Account number for POS Invoices
11	AccountNrItems	string	Account number for POS Invoices
13	Empty1	string	Not Used
14	InvoiceNr	string	POS Invoice Number
15	InvoiceDate	string	Date (finish) of POS Invoice
16	CustomerNr	string	External Customer Number
17	Empty2	string	Not Used
18	Empty3	string	Not Used
19	Empty4	string	Not Used
20	Skonto	integer	Not Used
21	InvText	string	POS Invoice Number, External Order Number and Comment combined
22	OrderNrExternal	string	External Order Number
23	CustomerName	string	Customer Name from POS Invoice or Address
24	Firstname	string	Customer First Name from POS Invoice or Address
25	Lastname	string	Customer Last Name from POS Invoice or Address
26	VatID	string	Customer VAT Id
27	Gegenkonto	string	Gegenkonto from dbo.Shops for POS Payments), empty for POS Invoices
28	IsEU	boolean	Flag (set to 1 for EU Countries)
29	CntCodeISO2	string	ISO 2 Country code

Body 2: DATEV POS Invoices summary

#	Name	Type	Description
1	ReportName	string	Name of Report
2	SumQtyItems	integer	not used
3	Sum_VK	number	not used
4	Sum_VK_Netto	number	not used
5	Sum_ShipCost_Netto	number	not used
6	Sum_ShipCost	number	not used
7	Sum_VAT	number	not used
8	Sum_NettoBruttoControl	number	not used

Additional Notes