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.11.0.62283)

Extras string

Extras

Type: varchar

Available from: / (25.11.0.62283)

AddrRef integer

AddrRef

Type: int

Available from: / (25.11.0.62283)

CustRef integer

CustRef

Type: int

Available from: / (25.11.0.62283)

OhGosF1 string

OhGosF1

Type: varchar

Available from: / (25.11.0.62283)

OhGosF2 string

OhGosF2

Type: varchar

Available from: / (25.11.0.62283)

OrderNr integer

OrderNr

Type: int

Available from: / (25.11.0.62283)

Product string

Product

Type: varchar

Available from: / (25.11.0.62283)

rowguid integer

rowguid

Type: int

Available from: / (25.11.0.62283)

Discount string

Discount

Type: varchar

Available from: / (25.11.0.62283)

OhShipID string

OhShipID

Type: varchar

Available from: / (25.11.0.62283)

Referrer string

Referrer

Type: varchar

Available from: / (25.11.0.62283)

ShipCost string

ShipCost

Type: varchar

Available from: / (25.11.0.62283)

Shipdate string

Shipdate

Type: datetime

Available from: / (25.11.0.62283)

ccpPayID string

ccpPayID

Type: varchar

Available from: / (25.11.0.62283)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.11.0.62283)

IPAddress string

IPAddress

Type: varchar

Available from: / (25.11.0.62283)

OhSLocked string

OhSLocked

Type: varchar

Available from: / (25.11.0.62283)

Shop_Note string

Shop_Note

Type: varchar

Available from: / (25.11.0.62283)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.11.0.62283)

Verfahren string

Verfahren

Type: varchar

Available from: / (25.11.0.62283)

ChangeDate string

ChangeDate

Type: datetime

Available from: / (25.11.0.62283)

ChannelRef integer

ChannelRef

Type: int

Available from: / (25.11.0.62283)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.11.0.62283)

CurrencyId integer

CurrencyId

Type: int

Available from: / (25.11.0.62283)

ExchRateId integer

ExchRateId

Type: int

Available from: / (25.11.0.62283)

OhWaitDays integer

OhWaitDays

Type: int

Available from: / (25.11.0.62283)

OhWrapType string

OhWrapType

Type: varchar

Available from: / (25.11.0.62283)

OrderTotal string

OrderTotal

Type: varchar

Available from: / (25.11.0.62283)

ShipAdrRef integer

ShipAdrRef

Type: int

Available from: / (25.11.0.62283)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.11.0.62283)

GiftMessage string

GiftMessage

Type: varchar

Available from: / (25.11.0.62283)

OhShipImmed string

OhShipImmed

Type: varchar

Available from: / (25.11.0.62283)

OrderStatus string

OrderStatus

Type: varchar

Available from: / (25.11.0.62283)

SubShopLogo string

SubShopLogo

Type: varchar

Available from: / (25.11.0.62283)

SubShopName string

SubShopName

Type: varchar

Available from: / (25.11.0.62283)

ResOnLocDate string

ResOnLocDate

Type: datetime

Available from: / (25.11.0.62283)

ShipInstruct string

ShipInstruct

Type: varchar

Available from: / (25.11.0.62283)

CCPNumOfTries integer

CCPNumOfTries

Type: int

Available from: / (25.11.0.62283)

ManualResDate string

ManualResDate

Type: datetime

Available from: / (25.11.0.62283)

OhWrapMessage string

OhWrapMessage

Type: varchar

Available from: / (25.11.0.62283)

ChangeReported string

ChangeReported

Type: varchar

Available from: / (25.11.0.62283)

ChangeSequence integer

ChangeSequence

Type: int

Available from: / (25.11.0.62283)

OhSCostCharged string

OhSCostCharged

Type: varchar

Available from: / (25.11.0.62283)

OhShippingNote string

OhShippingNote

Type: varchar

Available from: / (25.11.0.62283)

OrderHeaderKey integer

OrderHeaderKey

Type: int

Available from: / (25.11.0.62283)

PaidByCustomer string

PaidByCustomer

Type: varchar

Available from: / (25.11.0.62283)

PaidBySwiftRef string

PaidBySwiftRef

Type: varchar

Available from: / (25.11.0.62283)

ShipVendorCode string

ShipVendorCode

Type: varchar

Available from: / (25.11.0.62283)

Address_Remarks string

Address_Remarks

Type: varchar

Available from: / (25.11.0.62283)

CCPLastAuthCode string

CCPLastAuthCode

Type: varchar

Available from: / (25.11.0.62283)

OhCCPmerchantID string

OhCCPmerchantID

Type: varchar

Available from: / (25.11.0.62283)

OrderLinesTotal string

OrderLinesTotal

Type: varchar

Available from: / (25.11.0.62283)

OrderNrExternal string

OrderNrExternal

Type: varchar

Available from: / (25.11.0.62283)

ccpSetFailTries integer

ccpSetFailTries

Type: int

Available from: / (25.11.0.62283)

CCPPaymentInfoOK string

CCPPaymentInfoOK

Type: varchar

Available from: / (25.11.0.62283)

CCPReauthorizeYN string

CCPReauthorizeYN

Type: varchar

Available from: / (25.11.0.62283)

OhChargeShipCost string

OhChargeShipCost

Type: varchar

Available from: / (25.11.0.62283)

OhSCostChargeType integer

OhSCostChargeType

Type: int

Available from: / (25.11.0.62283)

AutoPaymentCreated boolean

AutoPaymentCreated

Type: bit

Available from: / (25.11.0.62283)

OrderLinesDiscount string

OrderLinesDiscount

Type: varchar

Available from: / (25.11.0.62283)

ccpSetFailLastTime string

ccpSetFailLastTime

Type: datetime

Available from: / (25.11.0.62283)

AutoReservationDone boolean

AutoReservationDone

Type: bit

Available from: / (25.11.0.62283)

ExtraShippingCharged string

ExtraShippingCharged

Type: varchar

Available from: / (25.11.0.62283)

OHMultiForceToPicklist boolean

OHMultiForceToPicklist

Type: bit

Available from: / (25.11.0.62283)

OhSCostFirstItemCharged string

OhSCostFirstItemCharged

Type: varchar

Available from: / (25.11.0.62283)

ForceToPicklistIfNotFULL boolean

ForceToPicklistIfNotFULL

Type: bit

Available from: / (25.11.0.62283)

OHCancelAfterForcedShipOut boolean

OHCancelAfterForcedShipOut

Type: bit

Available from: / (25.11.0.62283)