This API call returns all open orders for a specific supplier.

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


Request

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

Request body

Name Type Required Description
Secret string false

Customer ID, references table customers

Type: varchar(20)

Default value: NULL

Example: abcdefg

Available from: LOU Official - Update 46 (6.9.46.27927)

SupplNr string false

Supplier number

Type: varchar(4)

Default value: NULL

Example: abcdefg

Available from: LOU Official - Update 46 (6.9.46.27927)

AllOrders boolean false

0 = not confirmed orders are returned; 1 = all orders of the supplier are returned

Type: bit

Default value: 0

Example: 0 or 1

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Direct fulfilment orders

Name Type Description
Fax string

Fax

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

ZIP string

Postal number

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)

Phone string

Phone

Type: varchar (60)

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

Salutation

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

CareOf string

Customer of

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

Street string

Street

Type: varchar (100)

Available from: 25.06 (25.6.0.58802)

Country string

Country

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

HouseNr string

House Number

Type: varchar (12)

Available from: 25.06 (25.6.0.58802)

OrderNr integer

Order number in pixi*

Type: int

Available from: 25.06 (25.6.0.58802)

APayment string

Payment code

Type: varchar (1)

Available from: 25.06 (25.6.0.58802)

Discount number

Discount

Type: money

Available from: 25.06 (25.6.0.58802)

LastName string

Last Name

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

Referrer string

Referrer

Type: varchar (50)

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)

Shipdate string

Ship this order at this date only! not before

Type: datetime

Available from: 25.06 (25.6.0.58802)

FirstName string

First Name

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

AddrShopID string

Shop Id

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

CntCodeISO2 string

Country code (ISO 2)

Type: char

Available from: 25.06 (25.6.0.58802)

CntCodeISO3 string

Country code (ISO 3)

Type: char

Available from: 25.06 (25.6.0.58802)

SubShopName string

Shop name

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

ShipInstruct string

Transport remark

Type: varchar (255)

Available from: 25.06 (25.6.0.58802)

ShipVendorCode string

Shipping vendor code

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

AddrNoChargeVAT boolean

Charge VAT flag

Type: bit

Available from: 25.06 (25.6.0.58802)

Address_Remarks string

Address remark

Type: varchar (255)

Available from: 25.06 (25.6.0.58802)

OrderCurrencyCode string

Currency

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

PartialDeliveryActive boolean

Partial delivery enabled

Type: bit

Available from: 25.06 (25.6.0.58802)

PartialDeliveryMultiple boolean

Enable multiple partial deliveries

Type: bit

Available from: 25.06 (25.6.0.58802)

PartialDeliveryForceCancelAfterShipout boolean

Cancel the rest of order after partial delivery

Type: bit

Available from: 25.06 (25.6.0.58802)