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: / (25.7.0.59144)

Note string

Type: VARCHAR(60)

Available from: / (25.7.0.59144)

ArtNr string

Barcode

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

BoxNr integer

Type: INT

Available from: / (25.7.0.59144)

Price number

Type: MONEY

Available from: / (25.7.0.59144)

ArtVAT string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

ConfMS string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

InvRef integer

ID for the Invoice record

Type: INT

Available from: / (25.7.0.59144)

NODRef integer

Type: INT

Available from: / (25.7.0.59144)

ShipId string

Type: VARCHAR(13)

Available from: / (25.7.0.59144)

Source string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

Status string

Status

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

AddrRef integer

ID for the Address record

Type: INT

Available from: / (25.7.0.59144)

ArtName string

Name of the item

Type: varchar (120)

Available from: / (25.7.0.59144)

ConfVia string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

CustRef integer

IF for the Customer record

Type: INT

Available from: / (25.7.0.59144)

DF_type string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

ItemRef integer

Type: INT

Available from: / (25.7.0.59144)

OrGosF1 string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

OrGosF2 string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

OrderMS string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

OrderNr integer

Order number in pixi*

Type: INT

Available from: / (25.7.0.59144)

ShipRef integer

Type: INT

Available from: / (25.7.0.59144)

TaxRate number

Type: numeric

Available from: / (25.7.0.59144)

VATsRef integer

Type: INT

Available from: / (25.7.0.59144)

rowguid string

Type: UNIQUEIDENTIFIER

Available from: / (25.7.0.59144)

Backlist string

Type: SMALLINT

Available from: / (25.7.0.59144)

ConfDate string

Type: DATETIME

Available from: / (25.7.0.59144)

Discount string

Type: SMALLINT

Available from: / (25.7.0.59144)

LConfVia string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

Order_Id integer

Type: INT

Available from: / (25.7.0.59144)

Refunded boolean

Type: BIT

Available from: / (25.7.0.59144)

SerialNr string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

ShipCost number

Type: MONEY

Available from: / (25.7.0.59144)

ShipDate string

Type: DATETIME

Available from: / (25.7.0.59144)

SupplRef integer

Type: INT

Available from: / (25.7.0.59144)

TimeZone string

Type: CHAR(6)

Available from: / (25.7.0.59144)

WaitDays integer

Type: INT

Available from: / (25.7.0.59144)

CreateEmp string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

FullPrice number

Type: MONEY

Available from: / (25.7.0.59144)

LConfDate integer

Type: INT

Available from: / (25.7.0.59144)

MusicType string

Type: VARCHAR(4)

Available from: / (25.7.0.59144)

OrCCPLock string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

OrdShopID string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

OrderDate string

Type: DATETIME

Available from: / (25.7.0.59144)

Price_Net number

Type: MONEY

Available from: / (25.7.0.59144)

SupplInfo string

Type: VARCHAR(4)

Available from: / (25.7.0.59144)

TaxAmount number

Type: MONEY

Available from: / (25.7.0.59144)

UpdateEmp string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

VoucherID string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

ChangeDate string

Type: DATETIME

Available from: / (25.7.0.59144)

ConfigType string

Type: VARCHAR(4)

Available from: / (25.7.0.59144)

CreateDate string

Type: DATETIME

Available from: / (25.7.0.59144)

DFShipDate string

Type: DATETIME

Available from: / (25.7.0.59144)

DIcheckbox boolean

Type: BIT

Available from: / (25.7.0.59144)

HALEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

LocationID string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

NotEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

OrReplFlag string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

SOrderDate string

Type: DATETIME

Available from: / (25.7.0.59144)

ShipAdrRef integer

ID for the Shipping Address record

Type: INT

Available from: / (25.7.0.59144)

SupplGroup string

Type: VARCHAR(4)

Available from: / (25.7.0.59144)

SupplPrice number

Type: MONEY

Available from: / (25.7.0.59144)

UpdateDate string

Type: DATETIME

Available from: / (25.7.0.59144)

VATPercent number

Type: NUMERIC

Available from: / (25.7.0.59144)

BatchNumber string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

ConfEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

Curr_Source string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

AktionsKennz string

Type: VARCHAR(10)

Available from: / (25.7.0.59144)

BackorderRef integer

Type: INT

Available from: / (25.7.0.59144)

CCEXpEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

CCReqEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

DelayEMailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

DiscountPerc number

Type: NUMERIC

Available from: / (25.7.0.59144)

OrderlineKey integer

ID for the Orderline record

Type: INT

Available from: / (25.7.0.59144)

BookAccountNr string

Type: VARCHAR(20)

Available from: / (25.7.0.59144)

DiscountValue string

Type: MOMNEY

Available from: / (25.7.0.59144)

OrderCurrency string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

OrderExchRate number

Type: numeric

Available from: / (25.7.0.59144)

OrderLineType string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

SOrderlineRef integer

*Obsolete

Type: INT

Available from: / (25.7.0.59144)

AlreadyOrdered boolean

Type: BIT

Available from: / (25.7.0.59144)

BestBeforeDate string

Type: DATETIME

Available from: / (25.7.0.59144)

ChangeSequence integer

Type: INT

Available from: / (25.7.0.59144)

ItemNrExternal string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

LastDelayEmail string

Type: DATETIME

Available from: / (25.7.0.59144)

MeasuredWeight integer

Type: INT

Available from: / (25.7.0.59144)

OrShippingNote string

Type: VARCHAR(100)

Available from: / (25.7.0.59144)

PickListNrUsed integer

Type: INT

Available from: / (25.7.0.59144)

CustomerEMailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

ForceFirstSuppl string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

ForceLocToSuppl string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

OrderNrExternal string

Type: VARCHAR(50)

Available from: / (25.7.0.59144)

Price_OrderCurr number

*Obsolete

Type: MONEY

Available from: / (25.7.0.59144)

ShipCostPerItem string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

UpdateBackToHal boolean

Type: BIT

Available from: / (25.7.0.59144)

InvSorderlineRef integer

Type: INT

Available from: / (25.7.0.59144)

SupplGroupScanIn string

Type: VARCHAR(4)

Available from: / (25.7.0.59144)

oItemSpecialNote string

Type: VARCHAR(8000)

Available from: / (25.7.0.59144)

EstimatedDelivery string

Type: DATETIME

Available from: / (25.7.0.59144)

ForceParallelShip string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

InvoiceNrExternal string

Type: VARCHAR(20)

Available from: / (25.7.0.59144)

LastOrdLocationID string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

RealSorderlineRef integer

Type: INT

Available from: / (25.7.0.59144)

SupplPrice_Source string

Type: VARCHAR(3)

Available from: / (25.7.0.59144)

BundleOrderlineRef integer

Type: INT

Available from: / (25.7.0.59144)

NLBCustomerEmailed string

Type: VARCHAR(1)

Available from: / (25.7.0.59144)

ShipCost_OrderCurr number

Type: MONEY

Available from: / (25.7.0.59144)

OrderDateStartOfDay string

Type: DATETIME

Available from: / (25.7.0.59144)

Price_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (25.7.0.59144)

DFShipmentTrackingID string

Type: VARCHAR(100)

Available from: / (25.7.0.59144)

OriginalOrderlineRef integer

Type: INT

Available from: / (25.7.0.59144)

ItemOriginalFullPrice number

Type: MONEY

Available from: / (25.7.0.59144)

PriceWeightUnits_Price number

Type: MONEY

Available from: / (25.7.0.59144)

ShipCost_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: / (25.7.0.59144)