pixi Developer & Integration Documentation

pixiGetInvoicesUnpaid

Description

This call returns relevant data for a file with open invoices and was created for a special customer. It's faster than using pixiGetInvoice and pixiGetAddress for every invoice, that's why there is an extra call.


Request Parameters

#

Name

Type

Required

Example

Description

1

PaidInvoices

boolean

0

0/1

If this is set to 1, all invoices that are paid already are exported (for an initial export with all already paid invoices). It should not be used often though, it takes quite some resources


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:pixiGetInvoicesUnpaid>
         <dem:PaidInvoices>0/1</dem:PaidInvoices>
      </dem:pixiGetInvoicesUnpaid>
   </soapenv:Body>
</soapenv:Envelope>


Response


Body 1: Invoice details

#

Name

Type

Description

1

InvoiceNr

string

pixi* invoice number

2

InvoiceDate

string

Date of the invoice

3

ShopID

string

Shop ID

4

PaymentAddressId

integer

Billing address ID

5

ShipmentAddressId

integer

Shipping address ID

6

CustKey

integer

Customer ID

7

total

number

Invoice total

8

PaymentCode

string

Payment code

9

PaymentText

string

Payment text / description

10

PaymentDate

string

Date of the payment

11

Paid

boolean

Flag if the invoice was paid already

12

TotalToPay

number

Total amount to pay

13

PaidSum

number

Actual paid amount

14

CcCardType

string

Type of credit card

15

CcCardNr

string

Number of the credit card used for payment

16

CcCardName

string

Name of the credit institute

17

CcCardExp

string

Expiry date of the credit card

18

Account

string

Account number

19

Blz

string

Bank Code

20

BankName

string

Name of the Bank

21

AccountName

string

Name of the owner of this bank account

22

TrackingID

string

Tracking ID of the shipment. Applies to the orders that have been shipped

23

ShipDate

string

Ship this order at this date only! Not before

24

UpdateDate

string

Last update date of the record

25

ReminderLevel

integer

Reminder level

26

Note

string

Invoice note

27

ShipVendor

string

Shipping vendor code

28

Currency

string

Order Currency Code

29

OrderCurrency

string

Order Currency Code

30

TotalToPay_OrderCurr

number

Invoice total

31

ReturnReason

string

Return Reason

32

InvoiceKey

integer

Invoice Key (Id)

33

RefToInvoiceNr

string

Reference to Invoice Number

34

RefToInvoiceKey

integer

Reference to Invoice Key (Id)

35

CustomerNrExternal

string

External Reference to the Customer (imported from Shop)

36

InvZIP

string

Postal code

37

InvCity

string

City

38

InvCountryCodeISO3

string

ISO3 Country Code

39

InvName

string

First and last name

40

InvName2

string

2nd name

41

InvFirstName

string

First Name

42

InvLastName

string

Last Name

43

InvCompany

string

Company name

44

InvStreet

string

Street

45

InvHouseNr

string

House Number

46

DueDate

string

Invoice due date

47

DatevUserAccount

string

DATEV Account Number


Additional Notes