pixiGetOrderTotals

Recommended

Get totals equal to what the invoice would produce from the order in order currency.

Since pixi version: LOU Official (6.3.0.4452) Additional notes:


Request

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

Request body

Name Type Required Description
CustKey integer false

Customer ID. References CustKey in table Customers.

Type: int

Default value: NULL

Example: 123

Available from: LOU Official (6.3.0.4452)

OrderNr integer false

pixi* order number

Type: int

Default value: 0

Example: 123

Available from: LOU Official (6.3.0.4452)

OrderNrExternal string false

Shop order number

Type: varchar(50)

Default value:

Example: abcdefg

Available from: LOU Official (6.3.0.4452)


Response

1. Result set

Name Type Description
Qty integer

Quantity of items in this order

Type: int

Available from: 25.06 (25.6.0.58802)

Price integer

Price of one item

Type: int

Available from: 25.06 (25.6.0.58802)

EanUpc string

EAN of the item in this order

Type: varchar

Available from: 25.06 (25.6.0.58802)

VATLow number

The total VAT amount of the whole order, if it has VAT rate low

Type: numeric

Available from: 25.06 (25.6.0.58802)

ArtName string

Itemname

Type: varchar

Available from: 25.06 (25.6.0.58802)

OrderNr integer

The ordernumber for the given OrderNrExternal

Type: int

Available from: 25.06 (25.6.0.58802)

VATHigh number

The total VAT amount of the whole order, if it has VAT rate high

Type: numeric

Available from: 25.06 (25.6.0.58802)

Discount number

Discount of the order

Type: numeric

Available from: 25.06 (25.6.0.58802)

ItemNote string

ItemNote

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShipCost number

The total shipping costs of the whole order

Type: numeric

Available from: 25.06 (25.6.0.58802)

Subtotal integer

Totalprice these items in this order

Type: int

Available from: 25.06 (25.6.0.58802)

VATTotal number

The total VAT amount of the whole order

Type: numeric

Available from: 25.06 (25.6.0.58802)

NettoTotal number

The total sales amount of the whole order excluding VAT

Type: numeric

Available from: 25.06 (25.6.0.58802)

OrderTotal number

The total sales amount of the whole order

Type: numeric

Available from: 25.06 (25.6.0.58802)

TaxRateLow number

TaxRateLow

Type: numeric

Available from: 25.06 (25.6.0.58802)

ItemNrSuppl string

Supplier item number of the item in this order

Type: varchar

Available from: 25.06 (25.6.0.58802)

TaxRateHigh number

TaxRateHigh

Type: numeric

Available from: 25.06 (25.6.0.58802)

ShipCostNoVAT number

The total shipping costs of the whole order excluding VAT

Type: numeric

Available from: 25.06 (25.6.0.58802)

ItemPriceNoVat number

Item price excluding VAT

Type: numeric

Available from: 25.06 (25.6.0.58802)

ItemAmountNoVat number

Total item price of items excluding VAT

Type: numeric

Available from: 25.06 (25.6.0.58802)

OrderNrExternal string

The external ordernumber for the given OrderNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

OrderCurrencyCode string

OrderCurrencyCode

Type: varchar

Available from: 25.06 (25.6.0.58802)