pixiReportOrderOverview

Report with an overview of orders with billing address information, totals and gross profit. Gross Profit is calculated from standard supplier price at the time of order - not comparable with other reports in pixi!

Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:


Request

POST https://apigateway.descartes.com/tms/pixi/pixiReportOrderOverview

Request body

Name Type Required Description
RowCount integer false

Nr of Rows to return

Type: int

Default value: 1000

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderDateTo string false

Filter order until orderdate.

Type: datetime

Default value:

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderNrStart integer false

Start Orders with OrderNr X or higher

Type: int

Default value:

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderDateFrom string false

Filter order from orderdate.

Type: datetime

Default value:

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Report Order Overview

Name Type Description
ZIP string

ZIP

Type: varchar (10)

Available from: 25.06 (25.6.0.58802)

City string

City

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

Name string

Name

Type: varchar (121)

Available from: 25.06 (25.6.0.58802)

eMail string

E-Mail address

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

Anrede string

Anrede

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

CareOf string

Care Of

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

ShopID string

Shop ID

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

Address string

Address

Type: varchar (110)

Available from: 25.06 (25.6.0.58802)

Country string

Country

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

OrderNR integer

Order number in pixi*

Type: int

Available from: 25.06 (25.6.0.58802)

Discount number

Discount

Type: money

Available from: 25.06 (25.6.0.58802)

ShipCost number

The total shipping costs of the whole order

Type: money

Available from: 25.06 (25.6.0.58802)

OrderDate string

Order Date

Type: datetime

Available from: 25.06 (25.6.0.58802)

Shop_Note string

Shop Note

Type: varchar (-1)

Available from: 25.06 (25.6.0.58802)

OrderTotal number

Order Total

Type: money

Available from: 25.06 (25.6.0.58802)

GiftMessage string

Gift Message

Type: varchar (8000)

Available from: 25.06 (25.6.0.58802)

OrderStatus string

Order Status

Type: varchar (10)

Available from: 25.06 (25.6.0.58802)

PaymentCode string

Payment Code

Type: varchar (1)

Available from: 25.06 (25.6.0.58802)

CurrencyCode string

Currency code

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

Address_Remarks string

Address Remarks

Type: varchar (255)

Available from: 25.06 (25.6.0.58802)

OrderLinesTotal number

Order Lines Total

Type: money

Available from: 25.06 (25.6.0.58802)

GrossProfit_Netto number

Gross Profit Netto

Type: money

Available from: 25.06 (25.6.0.58802)

OrderLinesDiscount number

Order Lines Discount

Type: money

Available from: 25.06 (25.6.0.58802)