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

Extras string

Extras

Type: varchar

Available from: / (25.7.0.59144)

AddrRef integer

AddrRef

Type: int

Available from: / (25.7.0.59144)

CustRef integer

CustRef

Type: int

Available from: / (25.7.0.59144)

OhGosF1 string

OhGosF1

Type: varchar

Available from: / (25.7.0.59144)

OhGosF2 string

OhGosF2

Type: varchar

Available from: / (25.7.0.59144)

OrderNr integer

OrderNr

Type: int

Available from: / (25.7.0.59144)

Product string

Product

Type: varchar

Available from: / (25.7.0.59144)

rowguid integer

rowguid

Type: int

Available from: / (25.7.0.59144)

Discount string

Discount

Type: varchar

Available from: / (25.7.0.59144)

OhShipID string

OhShipID

Type: varchar

Available from: / (25.7.0.59144)

Referrer string

Referrer

Type: varchar

Available from: / (25.7.0.59144)

ShipCost string

ShipCost

Type: varchar

Available from: / (25.7.0.59144)

Shipdate string

Shipdate

Type: datetime

Available from: / (25.7.0.59144)

ccpPayID string

ccpPayID

Type: varchar

Available from: / (25.7.0.59144)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.7.0.59144)

IPAddress string

IPAddress

Type: varchar

Available from: / (25.7.0.59144)

OhSLocked string

OhSLocked

Type: varchar

Available from: / (25.7.0.59144)

Shop_Note string

Shop_Note

Type: varchar

Available from: / (25.7.0.59144)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.7.0.59144)

Verfahren string

Verfahren

Type: varchar

Available from: / (25.7.0.59144)

ChangeDate string

ChangeDate

Type: datetime

Available from: / (25.7.0.59144)

ChannelRef integer

ChannelRef

Type: int

Available from: / (25.7.0.59144)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.7.0.59144)

CurrencyId integer

CurrencyId

Type: int

Available from: / (25.7.0.59144)

ExchRateId integer

ExchRateId

Type: int

Available from: / (25.7.0.59144)

OhWaitDays integer

OhWaitDays

Type: int

Available from: / (25.7.0.59144)

OhWrapType string

OhWrapType

Type: varchar

Available from: / (25.7.0.59144)

OrderTotal string

OrderTotal

Type: varchar

Available from: / (25.7.0.59144)

ShipAdrRef integer

ShipAdrRef

Type: int

Available from: / (25.7.0.59144)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.7.0.59144)

GiftMessage string

GiftMessage

Type: varchar

Available from: / (25.7.0.59144)

OhShipImmed string

OhShipImmed

Type: varchar

Available from: / (25.7.0.59144)

OrderStatus string

OrderStatus

Type: varchar

Available from: / (25.7.0.59144)

SubShopLogo string

SubShopLogo

Type: varchar

Available from: / (25.7.0.59144)

SubShopName string

SubShopName

Type: varchar

Available from: / (25.7.0.59144)

ResOnLocDate string

ResOnLocDate

Type: datetime

Available from: / (25.7.0.59144)

ShipInstruct string

ShipInstruct

Type: varchar

Available from: / (25.7.0.59144)

CCPNumOfTries integer

CCPNumOfTries

Type: int

Available from: / (25.7.0.59144)

ManualResDate string

ManualResDate

Type: datetime

Available from: / (25.7.0.59144)

OhWrapMessage string

OhWrapMessage

Type: varchar

Available from: / (25.7.0.59144)

ChangeReported string

ChangeReported

Type: varchar

Available from: / (25.7.0.59144)

ChangeSequence integer

ChangeSequence

Type: int

Available from: / (25.7.0.59144)

OhSCostCharged string

OhSCostCharged

Type: varchar

Available from: / (25.7.0.59144)

OhShippingNote string

OhShippingNote

Type: varchar

Available from: / (25.7.0.59144)

OrderHeaderKey integer

OrderHeaderKey

Type: int

Available from: / (25.7.0.59144)

PaidByCustomer string

PaidByCustomer

Type: varchar

Available from: / (25.7.0.59144)

PaidBySwiftRef string

PaidBySwiftRef

Type: varchar

Available from: / (25.7.0.59144)

ShipVendorCode string

ShipVendorCode

Type: varchar

Available from: / (25.7.0.59144)

Address_Remarks string

Address_Remarks

Type: varchar

Available from: / (25.7.0.59144)

CCPLastAuthCode string

CCPLastAuthCode

Type: varchar

Available from: / (25.7.0.59144)

OhCCPmerchantID string

OhCCPmerchantID

Type: varchar

Available from: / (25.7.0.59144)

OrderLinesTotal string

OrderLinesTotal

Type: varchar

Available from: / (25.7.0.59144)

OrderNrExternal string

OrderNrExternal

Type: varchar

Available from: / (25.7.0.59144)

ccpSetFailTries integer

ccpSetFailTries

Type: int

Available from: / (25.7.0.59144)

CCPPaymentInfoOK string

CCPPaymentInfoOK

Type: varchar

Available from: / (25.7.0.59144)

CCPReauthorizeYN string

CCPReauthorizeYN

Type: varchar

Available from: / (25.7.0.59144)

OhChargeShipCost string

OhChargeShipCost

Type: varchar

Available from: / (25.7.0.59144)

OhSCostChargeType integer

OhSCostChargeType

Type: int

Available from: / (25.7.0.59144)

AutoPaymentCreated boolean

AutoPaymentCreated

Type: bit

Available from: / (25.7.0.59144)

OrderLinesDiscount string

OrderLinesDiscount

Type: varchar

Available from: / (25.7.0.59144)

ccpSetFailLastTime string

ccpSetFailLastTime

Type: datetime

Available from: / (25.7.0.59144)

AutoReservationDone boolean

AutoReservationDone

Type: bit

Available from: / (25.7.0.59144)

ExtraShippingCharged string

ExtraShippingCharged

Type: varchar

Available from: / (25.7.0.59144)

OHMultiForceToPicklist boolean

OHMultiForceToPicklist

Type: bit

Available from: / (25.7.0.59144)

OhSCostFirstItemCharged string

OhSCostFirstItemCharged

Type: varchar

Available from: / (25.7.0.59144)

ForceToPicklistIfNotFULL boolean

ForceToPicklistIfNotFULL

Type: bit

Available from: / (25.7.0.59144)

OHCancelAfterForcedShipOut boolean

OHCancelAfterForcedShipOut

Type: bit

Available from: / (25.7.0.59144)