pixiReadOrderHeader

API Call to retrieve all relevant orders

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


Request

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

Request body

Name Type Required Description
OrderNr integer false

pixi* OrderNr

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

RowCount integer false

Number of rows returned. (The maximum allowed value is set to 100 000)

Type: int

Default value: 1000

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderHeaderKey integer false

pixi* Orderheader Key

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Result set

Name Type Description
DFType integer

DFType

Type: int

Available from: / (25.8.0.59841)

Extras string

Extras

Type: varchar

Available from: / (25.8.0.59841)

AddrRef integer

AddrRef

Type: int

Available from: / (25.8.0.59841)

CustRef integer

CustRef

Type: int

Available from: / (25.8.0.59841)

OhGosF1 string

OhGosF1

Type: varchar

Available from: / (25.8.0.59841)

OhGosF2 string

OhGosF2

Type: varchar

Available from: / (25.8.0.59841)

OrderNr integer

OrderNr

Type: int

Available from: / (25.8.0.59841)

Product string

Product

Type: varchar

Available from: / (25.8.0.59841)

rowguid integer

rowguid

Type: int

Available from: / (25.8.0.59841)

Discount string

Discount

Type: varchar

Available from: / (25.8.0.59841)

OhShipID string

OhShipID

Type: varchar

Available from: / (25.8.0.59841)

Referrer string

Referrer

Type: varchar

Available from: / (25.8.0.59841)

ShipCost string

ShipCost

Type: varchar

Available from: / (25.8.0.59841)

Shipdate string

Shipdate

Type: datetime

Available from: / (25.8.0.59841)

ccpPayID string

ccpPayID

Type: varchar

Available from: / (25.8.0.59841)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.8.0.59841)

IPAddress string

IPAddress

Type: varchar

Available from: / (25.8.0.59841)

OhSLocked string

OhSLocked

Type: varchar

Available from: / (25.8.0.59841)

Shop_Note string

Shop_Note

Type: varchar

Available from: / (25.8.0.59841)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.8.0.59841)

Verfahren string

Verfahren

Type: varchar

Available from: / (25.8.0.59841)

ChangeDate string

ChangeDate

Type: datetime

Available from: / (25.8.0.59841)

ChannelRef integer

ChannelRef

Type: int

Available from: / (25.8.0.59841)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.8.0.59841)

CurrencyId integer

CurrencyId

Type: int

Available from: / (25.8.0.59841)

ExchRateId integer

ExchRateId

Type: int

Available from: / (25.8.0.59841)

OhWaitDays integer

OhWaitDays

Type: int

Available from: / (25.8.0.59841)

OhWrapType string

OhWrapType

Type: varchar

Available from: / (25.8.0.59841)

OrderTotal string

OrderTotal

Type: varchar

Available from: / (25.8.0.59841)

ShipAdrRef integer

ShipAdrRef

Type: int

Available from: / (25.8.0.59841)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.8.0.59841)

GiftMessage string

GiftMessage

Type: varchar

Available from: / (25.8.0.59841)

OhShipImmed string

OhShipImmed

Type: varchar

Available from: / (25.8.0.59841)

OrderStatus string

OrderStatus

Type: varchar

Available from: / (25.8.0.59841)

SubShopLogo string

SubShopLogo

Type: varchar

Available from: / (25.8.0.59841)

SubShopName string

SubShopName

Type: varchar

Available from: / (25.8.0.59841)

ResOnLocDate string

ResOnLocDate

Type: datetime

Available from: / (25.8.0.59841)

ShipInstruct string

ShipInstruct

Type: varchar

Available from: / (25.8.0.59841)

CCPNumOfTries integer

CCPNumOfTries

Type: int

Available from: / (25.8.0.59841)

ManualResDate string

ManualResDate

Type: datetime

Available from: / (25.8.0.59841)

OhWrapMessage string

OhWrapMessage

Type: varchar

Available from: / (25.8.0.59841)

ChangeReported string

ChangeReported

Type: varchar

Available from: / (25.8.0.59841)

ChangeSequence integer

ChangeSequence

Type: int

Available from: / (25.8.0.59841)

OhSCostCharged string

OhSCostCharged

Type: varchar

Available from: / (25.8.0.59841)

OhShippingNote string

OhShippingNote

Type: varchar

Available from: / (25.8.0.59841)

OrderHeaderKey integer

OrderHeaderKey

Type: int

Available from: / (25.8.0.59841)

PaidByCustomer string

PaidByCustomer

Type: varchar

Available from: / (25.8.0.59841)

PaidBySwiftRef string

PaidBySwiftRef

Type: varchar

Available from: / (25.8.0.59841)

ShipVendorCode string

ShipVendorCode

Type: varchar

Available from: / (25.8.0.59841)

Address_Remarks string

Address_Remarks

Type: varchar

Available from: / (25.8.0.59841)

CCPLastAuthCode string

CCPLastAuthCode

Type: varchar

Available from: / (25.8.0.59841)

OhCCPmerchantID string

OhCCPmerchantID

Type: varchar

Available from: / (25.8.0.59841)

OrderLinesTotal string

OrderLinesTotal

Type: varchar

Available from: / (25.8.0.59841)

OrderNrExternal string

OrderNrExternal

Type: varchar

Available from: / (25.8.0.59841)

ccpSetFailTries integer

ccpSetFailTries

Type: int

Available from: / (25.8.0.59841)

CCPPaymentInfoOK string

CCPPaymentInfoOK

Type: varchar

Available from: / (25.8.0.59841)

CCPReauthorizeYN string

CCPReauthorizeYN

Type: varchar

Available from: / (25.8.0.59841)

OhChargeShipCost string

OhChargeShipCost

Type: varchar

Available from: / (25.8.0.59841)

OhSCostChargeType integer

OhSCostChargeType

Type: int

Available from: / (25.8.0.59841)

AutoPaymentCreated boolean

AutoPaymentCreated

Type: bit

Available from: / (25.8.0.59841)

OrderLinesDiscount string

OrderLinesDiscount

Type: varchar

Available from: / (25.8.0.59841)

ccpSetFailLastTime string

ccpSetFailLastTime

Type: datetime

Available from: / (25.8.0.59841)

AutoReservationDone boolean

AutoReservationDone

Type: bit

Available from: / (25.8.0.59841)

ExtraShippingCharged string

ExtraShippingCharged

Type: varchar

Available from: / (25.8.0.59841)

OHMultiForceToPicklist boolean

OHMultiForceToPicklist

Type: bit

Available from: / (25.8.0.59841)

OhSCostFirstItemCharged string

OhSCostFirstItemCharged

Type: varchar

Available from: / (25.8.0.59841)

ForceToPicklistIfNotFULL boolean

ForceToPicklistIfNotFULL

Type: bit

Available from: / (25.8.0.59841)

OHCancelAfterForcedShipOut boolean

OHCancelAfterForcedShipOut

Type: bit

Available from: / (25.8.0.59841)