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

Note string

Type: VARCHAR(60)

Available from: / (26.9.0.14135)

ArtNr string

Barcode

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

BoxNr integer

Type: INT

Available from: / (26.9.0.14135)

Price number

Type: MONEY

Available from: / (26.9.0.14135)

ArtVAT string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

ConfMS string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

InvRef integer

ID for the Invoice record

Type: INT

Available from: / (26.9.0.14135)

NODRef integer

Type: INT

Available from: / (26.9.0.14135)

ShipId string

Type: VARCHAR(13)

Available from: / (26.9.0.14135)

Source string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

Status string

Status

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

AddrRef integer

ID for the Address record

Type: INT

Available from: / (26.9.0.14135)

ArtName string

Name of the item

Type: varchar (120)

Available from: / (26.9.0.14135)

ConfVia string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

CustRef integer

IF for the Customer record

Type: INT

Available from: / (26.9.0.14135)

DF_type string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

ItemRef integer

Type: INT

Available from: / (26.9.0.14135)

OrGosF1 string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

OrGosF2 string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

OrderMS string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

OrderNr integer

Order number in pixi*

Type: INT

Available from: / (26.9.0.14135)

ShipRef integer

Type: INT

Available from: / (26.9.0.14135)

TaxRate number

Type: numeric

Available from: / (26.9.0.14135)

VATsRef integer

Type: INT

Available from: / (26.9.0.14135)

rowguid string

Type: UNIQUEIDENTIFIER

Available from: / (26.9.0.14135)

Backlist string

Type: SMALLINT

Available from: / (26.9.0.14135)

ConfDate string

Type: DATETIME

Available from: / (26.9.0.14135)

Discount string

Type: SMALLINT

Available from: / (26.9.0.14135)

LConfVia string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

Order_Id integer

Type: INT

Available from: / (26.9.0.14135)

Refunded boolean

Type: BIT

Available from: / (26.9.0.14135)

SerialNr string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

ShipCost number

Type: MONEY

Available from: / (26.9.0.14135)

ShipDate string

Type: DATETIME

Available from: / (26.9.0.14135)

SupplRef integer

Type: INT

Available from: / (26.9.0.14135)

TimeZone string

Type: CHAR(6)

Available from: / (26.9.0.14135)

WaitDays integer

Type: INT

Available from: / (26.9.0.14135)

CreateEmp string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

FullPrice number

Type: MONEY

Available from: / (26.9.0.14135)

LConfDate integer

Type: INT

Available from: / (26.9.0.14135)

MusicType string

Type: VARCHAR(4)

Available from: / (26.9.0.14135)

OrCCPLock string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

OrdShopID string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

OrderDate string

Type: DATETIME

Available from: / (26.9.0.14135)

Price_Net number

Type: MONEY

Available from: / (26.9.0.14135)

SupplInfo string

Type: VARCHAR(4)

Available from: / (26.9.0.14135)

TaxAmount number

Type: MONEY

Available from: / (26.9.0.14135)

UpdateEmp string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

VoucherID string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

ChangeDate string

Type: DATETIME

Available from: / (26.9.0.14135)

ConfigType string

Type: VARCHAR(4)

Available from: / (26.9.0.14135)

CreateDate string

Type: DATETIME

Available from: / (26.9.0.14135)

DFShipDate string

Type: DATETIME

Available from: / (26.9.0.14135)

DIcheckbox boolean

Type: BIT

Available from: / (26.9.0.14135)

HALEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

LocationID string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

NotEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

OrReplFlag string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

SOrderDate string

Type: DATETIME

Available from: / (26.9.0.14135)

ShipAdrRef integer

ID for the Shipping Address record

Type: INT

Available from: / (26.9.0.14135)

SupplGroup string

Type: VARCHAR(4)

Available from: / (26.9.0.14135)

SupplPrice number

Type: MONEY

Available from: / (26.9.0.14135)

UpdateDate string

Type: DATETIME

Available from: / (26.9.0.14135)

VATPercent number

Type: NUMERIC

Available from: / (26.9.0.14135)

BatchNumber string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

ConfEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

Curr_Source string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

AktionsKennz string

Type: VARCHAR(10)

Available from: / (26.9.0.14135)

BackorderRef integer

Type: INT

Available from: / (26.9.0.14135)

CCEXpEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

CCReqEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

DelayEMailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

DiscountPerc number

Type: NUMERIC

Available from: / (26.9.0.14135)

OrderlineKey integer

ID for the Orderline record

Type: INT

Available from: / (26.9.0.14135)

BookAccountNr string

Type: VARCHAR(20)

Available from: / (26.9.0.14135)

DiscountValue string

Type: MOMNEY

Available from: / (26.9.0.14135)

OrderCurrency string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

OrderExchRate number

Type: numeric

Available from: / (26.9.0.14135)

OrderLineType string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

SOrderlineRef integer

*Obsolete

Type: INT

Available from: / (26.9.0.14135)

AlreadyOrdered boolean

Type: BIT

Available from: / (26.9.0.14135)

BestBeforeDate string

Type: DATETIME

Available from: / (26.9.0.14135)

ChangeSequence integer

Type: INT

Available from: / (26.9.0.14135)

ItemNrExternal string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

LastDelayEmail string

Type: DATETIME

Available from: / (26.9.0.14135)

MeasuredWeight integer

Type: INT

Available from: / (26.9.0.14135)

OrShippingNote string

Type: VARCHAR(100)

Available from: / (26.9.0.14135)

PickListNrUsed integer

Type: INT

Available from: / (26.9.0.14135)

CustomerEMailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

ForceFirstSuppl string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

ForceLocToSuppl string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

OrderNrExternal string

Type: VARCHAR(50)

Available from: / (26.9.0.14135)

Price_OrderCurr number

*Obsolete

Type: MONEY

Available from: / (26.9.0.14135)

ShipCostPerItem string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

UpdateBackToHal boolean

Type: BIT

Available from: / (26.9.0.14135)

InvSorderlineRef integer

Type: INT

Available from: / (26.9.0.14135)

SupplGroupScanIn string

Type: VARCHAR(4)

Available from: / (26.9.0.14135)

oItemSpecialNote string

Type: VARCHAR(8000)

Available from: / (26.9.0.14135)

EstimatedDelivery string

Type: DATETIME

Available from: / (26.9.0.14135)

ForceParallelShip string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

InvoiceNrExternal string

Type: VARCHAR(20)

Available from: / (26.9.0.14135)

LastOrdLocationID string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

RealSorderlineRef integer

Type: INT

Available from: / (26.9.0.14135)

SupplPrice_Source string

Type: VARCHAR(3)

Available from: / (26.9.0.14135)

BundleOrderlineRef integer

Type: INT

Available from: / (26.9.0.14135)

NLBCustomerEmailed string

Type: VARCHAR(1)

Available from: / (26.9.0.14135)

ShipCost_OrderCurr number

Type: MONEY

Available from: / (26.9.0.14135)

OrderDateStartOfDay string

Type: DATETIME

Available from: / (26.9.0.14135)

Price_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (26.9.0.14135)

DFShipmentTrackingID string

Type: VARCHAR(100)

Available from: / (26.9.0.14135)

OriginalOrderlineRef integer

Type: INT

Available from: / (26.9.0.14135)

ItemOriginalFullPrice number

Type: MONEY

Available from: / (26.9.0.14135)

PriceWeightUnits_Price number

Type: MONEY

Available from: / (26.9.0.14135)

ShipCost_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (26.9.0.14135)