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.06 (25.6.0.58802)

Note string

Type: VARCHAR(60)

Available from: 25.06 (25.6.0.58802)

ArtNr string

Barcode

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

BoxNr integer

Type: INT

Available from: 25.06 (25.6.0.58802)

Price number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

ArtVAT string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

ConfMS string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

InvRef integer

ID for the Invoice record

Type: INT

Available from: 25.06 (25.6.0.58802)

NODRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

ShipId string

Type: VARCHAR(13)

Available from: 25.06 (25.6.0.58802)

Source string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

Status string

Status

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

AddrRef integer

ID for the Address record

Type: INT

Available from: 25.06 (25.6.0.58802)

ArtName string

Name of the item

Type: varchar (120)

Available from: 25.06 (25.6.0.58802)

ConfVia string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

CustRef integer

IF for the Customer record

Type: INT

Available from: 25.06 (25.6.0.58802)

DF_type string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

ItemRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

OrGosF1 string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

OrGosF2 string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

OrderMS string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

OrderNr integer

Order number in pixi*

Type: INT

Available from: 25.06 (25.6.0.58802)

ShipRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

TaxRate number

Type: numeric

Available from: 25.06 (25.6.0.58802)

VATsRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

rowguid string

Type: UNIQUEIDENTIFIER

Available from: 25.06 (25.6.0.58802)

Backlist string

Type: SMALLINT

Available from: 25.06 (25.6.0.58802)

ConfDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

Discount string

Type: SMALLINT

Available from: 25.06 (25.6.0.58802)

LConfVia string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

Order_Id integer

Type: INT

Available from: 25.06 (25.6.0.58802)

Refunded boolean

Type: BIT

Available from: 25.06 (25.6.0.58802)

SerialNr string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

ShipCost number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

ShipDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

SupplRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

TimeZone string

Type: CHAR(6)

Available from: 25.06 (25.6.0.58802)

WaitDays integer

Type: INT

Available from: 25.06 (25.6.0.58802)

CreateEmp string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

FullPrice number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

LConfDate integer

Type: INT

Available from: 25.06 (25.6.0.58802)

MusicType string

Type: VARCHAR(4)

Available from: 25.06 (25.6.0.58802)

OrCCPLock string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

OrdShopID string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

OrderDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

Price_Net number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

SupplInfo string

Type: VARCHAR(4)

Available from: 25.06 (25.6.0.58802)

TaxAmount number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

UpdateEmp string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

VoucherID string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

ChangeDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

ConfigType string

Type: VARCHAR(4)

Available from: 25.06 (25.6.0.58802)

CreateDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

DFShipDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

DIcheckbox boolean

Type: BIT

Available from: 25.06 (25.6.0.58802)

HALEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

LocationID string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

NotEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

OrReplFlag string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

SOrderDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

ShipAdrRef integer

ID for the Shipping Address record

Type: INT

Available from: 25.06 (25.6.0.58802)

SupplGroup string

Type: VARCHAR(4)

Available from: 25.06 (25.6.0.58802)

SupplPrice number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

UpdateDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

VATPercent number

Type: NUMERIC

Available from: 25.06 (25.6.0.58802)

BatchNumber string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

ConfEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

Curr_Source string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

AktionsKennz string

Type: VARCHAR(10)

Available from: 25.06 (25.6.0.58802)

BackorderRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

CCEXpEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

CCReqEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

DelayEMailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

DiscountPerc number

Type: NUMERIC

Available from: 25.06 (25.6.0.58802)

OrderlineKey integer

ID for the Orderline record

Type: INT

Available from: 25.06 (25.6.0.58802)

BookAccountNr string

Type: VARCHAR(20)

Available from: 25.06 (25.6.0.58802)

DiscountValue string

Type: MOMNEY

Available from: 25.06 (25.6.0.58802)

OrderCurrency string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

OrderExchRate number

Type: numeric

Available from: 25.06 (25.6.0.58802)

OrderLineType string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

SOrderlineRef integer

*Obsolete

Type: INT

Available from: 25.06 (25.6.0.58802)

AlreadyOrdered boolean

Type: BIT

Available from: 25.06 (25.6.0.58802)

BestBeforeDate string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

ChangeSequence integer

Type: INT

Available from: 25.06 (25.6.0.58802)

ItemNrExternal string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

LastDelayEmail string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

MeasuredWeight integer

Type: INT

Available from: 25.06 (25.6.0.58802)

OrShippingNote string

Type: VARCHAR(100)

Available from: 25.06 (25.6.0.58802)

PickListNrUsed integer

Type: INT

Available from: 25.06 (25.6.0.58802)

CustomerEMailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

ForceFirstSuppl string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

ForceLocToSuppl string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

OrderNrExternal string

Type: VARCHAR(50)

Available from: 25.06 (25.6.0.58802)

Price_OrderCurr number

*Obsolete

Type: MONEY

Available from: 25.06 (25.6.0.58802)

ShipCostPerItem string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

UpdateBackToHal boolean

Type: BIT

Available from: 25.06 (25.6.0.58802)

InvSorderlineRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

SupplGroupScanIn string

Type: VARCHAR(4)

Available from: 25.06 (25.6.0.58802)

oItemSpecialNote string

Type: VARCHAR(8000)

Available from: 25.06 (25.6.0.58802)

EstimatedDelivery string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

ForceParallelShip string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

InvoiceNrExternal string

Type: VARCHAR(20)

Available from: 25.06 (25.6.0.58802)

LastOrdLocationID string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

RealSorderlineRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

SupplPrice_Source string

Type: VARCHAR(3)

Available from: 25.06 (25.6.0.58802)

BundleOrderlineRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

NLBCustomerEmailed string

Type: VARCHAR(1)

Available from: 25.06 (25.6.0.58802)

ShipCost_OrderCurr number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

OrderDateStartOfDay string

Type: DATETIME

Available from: 25.06 (25.6.0.58802)

Price_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: 25.06 (25.6.0.58802)

DFShipmentTrackingID string

Type: VARCHAR(100)

Available from: 25.06 (25.6.0.58802)

OriginalOrderlineRef integer

Type: INT

Available from: 25.06 (25.6.0.58802)

ItemOriginalFullPrice number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

PriceWeightUnits_Price number

Type: MONEY

Available from: 25.06 (25.6.0.58802)

ShipCost_OrderCurr_Set integer

*Obsolete

Type: INT

Available from: 25.06 (25.6.0.58802)