pixiReportInvlines

Invlines report.

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


Request

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

Request body

Name Type Required Description
EAN string false

Filter by item (ean barcode).

Type: varchar(13)

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

DateTo string false

Date until when invlines are taken.

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

ShopID string false

Shop Id

Type: varchar(3)

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

SupplNr string false

Filter by Supplier number.

Type: varchar(4)

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

Category string false

Filter by Category.

Type: varchar(50)

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

DateFrom string false

Required date from when report is created.

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

Rowcount integer false

Number of returned records.

Type: int

Default value: 1000

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

ItemNrInt string false

Filter by internal item number.

Type: varchar(50)

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

PaymentType string false

Filter by Payment type.

Type: char

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Return status

Name Type Description
EANUPC string

EANUPC

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShopID string

ShopID

Type: varchar

Available from: 25.06 (25.6.0.58802)

InvDate string

InvDate

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemQty integer

ItemQty

Type: int

Available from: 25.06 (25.6.0.58802)

Itemkey integer

Itemkey

Type: int

Available from: 25.06 (25.6.0.58802)

SupplNR string

SupplNR

Type: varchar

Available from: 25.06 (25.6.0.58802)

Category string

Category

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemName string

ItemName

Type: varchar

Available from: 25.06 (25.6.0.58802)

Supplier string

Supplier

Type: varchar

Available from: 25.06 (25.6.0.58802)

InvoiceNR string

InvoiceNR

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemNrInt string

ItemNrInt

Type: varchar

Available from: 25.06 (25.6.0.58802)

InvoiceKey integer

InvoiceKey

Type: int

Available from: 25.06 (25.6.0.58802)

SupplPrice integer

SupplPrice

Type: int

Available from: 25.06 (25.6.0.58802)

ItemNrSuppl string

ItemNrSuppl

Type: varchar

Available from: 25.06 (25.6.0.58802)

PaymentType string

PaymentType

Type: varchar

Available from: 25.06 (25.6.0.58802)

orderlinekey integer

orderlinekey

Type: int

Available from: 25.06 (25.6.0.58802)

ItemPrice_VAT integer

ItemPrice_VAT

Type: int

Available from: 25.06 (25.6.0.58802)

ItemPrice_netto integer

ItemPrice_netto

Type: int

Available from: 25.06 (25.6.0.58802)

ItemPrice_Brutto integer

ItemPrice_Brutto

Type: int

Available from: 25.06 (25.6.0.58802)

OrderCurrencyCode string

OrderCurrencyCode

Type: varchar

Available from: 25.06 (25.6.0.58802)