pixiReadBundleOrderlines

API call returns bundle orderlines

Since pixi version: 21.01 (9.0.23.54983) Additional notes:


Request

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

Request body

Name Type Required Description
RowCount integer false

Maximum number of records returned

Type: int

Default value: 1000

Example: 123

Available from: 21.01 (9.0.23.54983)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)

OrderlineKey integer false

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

Type: int

Default value: NULL

Example: 123

Available from: 21.01 (9.0.23.54983)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: 21.01 (9.0.23.54983)


Response

1. Bundle ordeline details

Name Type Description
Qty integer

Bundle item quantity

Type: int

Available from: / (25.8.0.59841)

Note string

Bundle orderline note

Type: varchar (60)

Available from: / (25.8.0.59841)

ArtNr string

Item barcode

Type: varchar (50)

Available from: / (25.8.0.59841)

Price number

Bundle item price

Type: money

Available from: / (25.8.0.59841)

Source string

Record creation source

Type: varchar (1)

Available from: / (25.8.0.59841)

Status string

Bundle orderline status

Type: varchar (3)

Available from: / (25.8.0.59841)

AddrRef integer

Billing address ID

Type: int

Available from: / (25.8.0.59841)

ArtName string

Name of the item

Type: varchar (120)

Available from: / (25.8.0.59841)

CustRef integer

ID of customer

Type: int

Available from: / (25.8.0.59841)

DF_type string

Direct fulfillment type

Type: varchar (1)

Available from: / (25.8.0.59841)

ItemRef integer

Item ID

Type: int

Available from: / (25.8.0.59841)

OrderMS string

Currency code

Type: varchar (3)

Available from: / (25.8.0.59841)

OrderNr integer

Order number in pixi*

Type: int

Available from: / (25.8.0.59841)

TaxRate number

VAT rate

Type: numeric

Available from: / (25.8.0.59841)

VATsRef integer

VAT refference ID

Type: int

Available from: / (25.8.0.59841)

rowguid string

Uniquely identifying row

Type: uniqueidentifier

Available from: / (25.8.0.59841)

TimeZone string

Time zone

Type: char

Available from: / (25.8.0.59841)

WaitDays integer

Days to wait before shipping

Type: int

Available from: / (25.8.0.59841)

CreateEmp string

Creator of the recodr (pixi user)

Type: varchar (50)

Available from: / (25.8.0.59841)

FullPrice number

Bundle orderline full price

Type: money

Available from: / (25.8.0.59841)

OrdShopID string

Shop ID

Type: varchar (3)

Available from: / (25.8.0.59841)

OrderDate string

Order date

Type: datetime

Available from: / (25.8.0.59841)

Price_Net number

Price without VAT

Type: money

Available from: / (25.8.0.59841)

SupplInfo string

Supplier code

Type: varchar (4)

Available from: / (25.8.0.59841)

TaxAmount number

VAT amount

Type: money

Available from: / (25.8.0.59841)

UpdateEmp string

User who last updated the record

Type: varchar (50)

Available from: / (25.8.0.59841)

VoucherID string

ID of the voucher

Type: varchar (50)

Available from: / (25.8.0.59841)

ConfigType string

Category ID

Type: varchar (4)

Available from: / (25.8.0.59841)

CreateDate string

Create date

Type: datetime

Available from: / (25.8.0.59841)

LocationID string

Location ID

Type: varchar (3)

Available from: / (25.8.0.59841)

ShipAdrRef integer

Shipping address ID

Type: int

Available from: / (25.8.0.59841)

SupplGroup string

Item supplier group

Type: varchar (4)

Available from: / (25.8.0.59841)

SupplPrice number

Supplier price of the item

Type: money

Available from: / (25.8.0.59841)

UpdateDate string

Last update date of the record

Type: datetime

Available from: / (25.8.0.59841)

VATPercent number

VAT percent

Type: numeric

Available from: / (25.8.0.59841)

DiscountPerc number

Discount percent

Type: numeric

Available from: / (25.8.0.59841)

OrderlineKey integer

ID for the Orderline record

Type: int

Available from: / (25.8.0.59841)

DiscountValue number

Discount value

Type: money

Available from: / (25.8.0.59841)

OrderLineType string

Type of order

Type: varchar (3)

Available from: / (25.8.0.59841)

ItemNrExternal string

Item number external (Imported from Shop)

Type: varchar (50)

Available from: / (25.8.0.59841)

OrderNrExternal string

External order number

Type: varchar (50)

Available from: / (25.8.0.59841)

ShipCostPerItem string

Shipping costs per item

Type: varchar (1)

Available from: / (25.8.0.59841)

oItemSpecialNote string

Bundle item note

Type: varchar (8000)

Available from: / (25.8.0.59841)

LastOrdLocationID string

Last order location ID

Type: varchar (3)

Available from: / (25.8.0.59841)