pixiReadOrderlines

API Call to retrieve all relevant orderlines lines

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


Request

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

Request body

Name Type Required Description
RowCount integer false

Maximum number of rows returned

Type: int

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderlineKey integer false

pixi* orderline Key. If @RowCount is NULL then it returns only this row, otherwise next @RowCount records.

Type: int

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Orderlines list

Name Type Description
Qty integer

Quantity

Type: INT

Available from: / (26.7.0.12837)

Note string

Type: VARCHAR(60)

Available from: / (26.7.0.12837)

ArtNr string

Barcode

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

BoxNr integer

Type: INT

Available from: / (26.7.0.12837)

Price number

Type: MONEY

Available from: / (26.7.0.12837)

ArtVAT string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

ConfMS string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

InvRef integer

ID for the Invoice record

Type: INT

Available from: / (26.7.0.12837)

NODRef integer

Type: INT

Available from: / (26.7.0.12837)

ShipId string

Type: VARCHAR(13)

Available from: / (26.7.0.12837)

Source string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

Status string

Status

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

AddrRef integer

ID for the Address record

Type: INT

Available from: / (26.7.0.12837)

ArtName string

Name of the item

Type: varchar (120)

Available from: / (26.7.0.12837)

ConfVia string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

CustRef integer

IF for the Customer record

Type: INT

Available from: / (26.7.0.12837)

DF_type string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

ItemRef integer

Type: INT

Available from: / (26.7.0.12837)

OrGosF1 string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

OrGosF2 string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

OrderMS string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

OrderNr integer

Order number in pixi*

Type: INT

Available from: / (26.7.0.12837)

ShipRef integer

Type: INT

Available from: / (26.7.0.12837)

TaxRate number

Type: numeric

Available from: / (26.7.0.12837)

VATsRef integer

Type: INT

Available from: / (26.7.0.12837)

rowguid string

Type: UNIQUEIDENTIFIER

Available from: / (26.7.0.12837)

Backlist string

Type: SMALLINT

Available from: / (26.7.0.12837)

ConfDate string

Type: DATETIME

Available from: / (26.7.0.12837)

Discount string

Type: SMALLINT

Available from: / (26.7.0.12837)

LConfVia string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

Order_Id integer

Type: INT

Available from: / (26.7.0.12837)

Refunded boolean

Type: BIT

Available from: / (26.7.0.12837)

SerialNr string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

ShipCost number

Type: MONEY

Available from: / (26.7.0.12837)

ShipDate string

Type: DATETIME

Available from: / (26.7.0.12837)

SupplRef integer

Type: INT

Available from: / (26.7.0.12837)

TimeZone string

Type: CHAR(6)

Available from: / (26.7.0.12837)

WaitDays integer

Type: INT

Available from: / (26.7.0.12837)

CreateEmp string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

FullPrice number

Type: MONEY

Available from: / (26.7.0.12837)

LConfDate integer

Type: INT

Available from: / (26.7.0.12837)

MusicType string

Type: VARCHAR(4)

Available from: / (26.7.0.12837)

OrCCPLock string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

OrdShopID string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

OrderDate string

Type: DATETIME

Available from: / (26.7.0.12837)

Price_Net number

Type: MONEY

Available from: / (26.7.0.12837)

SupplInfo string

Type: VARCHAR(4)

Available from: / (26.7.0.12837)

TaxAmount number

Type: MONEY

Available from: / (26.7.0.12837)

UpdateEmp string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

VoucherID string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

ChangeDate string

Type: DATETIME

Available from: / (26.7.0.12837)

ConfigType string

Type: VARCHAR(4)

Available from: / (26.7.0.12837)

CreateDate string

Type: DATETIME

Available from: / (26.7.0.12837)

DFShipDate string

Type: DATETIME

Available from: / (26.7.0.12837)

DIcheckbox boolean

Type: BIT

Available from: / (26.7.0.12837)

HALEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

LocationID string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

NotEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

OrReplFlag string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

SOrderDate string

Type: DATETIME

Available from: / (26.7.0.12837)

ShipAdrRef integer

ID for the Shipping Address record

Type: INT

Available from: / (26.7.0.12837)

SupplGroup string

Type: VARCHAR(4)

Available from: / (26.7.0.12837)

SupplPrice number

Type: MONEY

Available from: / (26.7.0.12837)

UpdateDate string

Type: DATETIME

Available from: / (26.7.0.12837)

VATPercent number

Type: NUMERIC

Available from: / (26.7.0.12837)

BatchNumber string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

ConfEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

Curr_Source string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

AktionsKennz string

Type: VARCHAR(10)

Available from: / (26.7.0.12837)

BackorderRef integer

Type: INT

Available from: / (26.7.0.12837)

CCEXpEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

CCReqEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

DelayEMailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

DiscountPerc number

Type: NUMERIC

Available from: / (26.7.0.12837)

OrderlineKey integer

ID for the Orderline record

Type: INT

Available from: / (26.7.0.12837)

BookAccountNr string

Type: VARCHAR(20)

Available from: / (26.7.0.12837)

DiscountValue string

Type: MOMNEY

Available from: / (26.7.0.12837)

OrderCurrency string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

OrderExchRate number

Type: numeric

Available from: / (26.7.0.12837)

OrderLineType string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

SOrderlineRef integer

*Obsolete

Type: INT

Available from: / (26.7.0.12837)

AlreadyOrdered boolean

Type: BIT

Available from: / (26.7.0.12837)

BestBeforeDate string

Type: DATETIME

Available from: / (26.7.0.12837)

ChangeSequence integer

Type: INT

Available from: / (26.7.0.12837)

ItemNrExternal string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

LastDelayEmail string

Type: DATETIME

Available from: / (26.7.0.12837)

MeasuredWeight integer

Type: INT

Available from: / (26.7.0.12837)

OrShippingNote string

Type: VARCHAR(100)

Available from: / (26.7.0.12837)

PickListNrUsed integer

Type: INT

Available from: / (26.7.0.12837)

CustomerEMailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

ForceFirstSuppl string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

ForceLocToSuppl string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

OrderNrExternal string

Type: VARCHAR(50)

Available from: / (26.7.0.12837)

Price_OrderCurr number

*Obsolete

Type: MONEY

Available from: / (26.7.0.12837)

ShipCostPerItem string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

UpdateBackToHal boolean

Type: BIT

Available from: / (26.7.0.12837)

InvSorderlineRef integer

Type: INT

Available from: / (26.7.0.12837)

SupplGroupScanIn string

Type: VARCHAR(4)

Available from: / (26.7.0.12837)

oItemSpecialNote string

Type: VARCHAR(8000)

Available from: / (26.7.0.12837)

EstimatedDelivery string

Type: DATETIME

Available from: / (26.7.0.12837)

ForceParallelShip string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

InvoiceNrExternal string

Type: VARCHAR(20)

Available from: / (26.7.0.12837)

LastOrdLocationID string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

RealSorderlineRef integer

Type: INT

Available from: / (26.7.0.12837)

SupplPrice_Source string

Type: VARCHAR(3)

Available from: / (26.7.0.12837)

BundleOrderlineRef integer

Type: INT

Available from: / (26.7.0.12837)

NLBCustomerEmailed string

Type: VARCHAR(1)

Available from: / (26.7.0.12837)

ShipCost_OrderCurr number

Type: MONEY

Available from: / (26.7.0.12837)

OrderDateStartOfDay string

Type: DATETIME

Available from: / (26.7.0.12837)

Price_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (26.7.0.12837)

DFShipmentTrackingID string

Type: VARCHAR(100)

Available from: / (26.7.0.12837)

OriginalOrderlineRef integer

Type: INT

Available from: / (26.7.0.12837)

ItemOriginalFullPrice number

Type: MONEY

Available from: / (26.7.0.12837)

PriceWeightUnits_Price number

Type: MONEY

Available from: / (26.7.0.12837)

ShipCost_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (26.7.0.12837)