API Call to retrieve all relevant invoice lines

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


Request

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

Request body

Name Type Required Description
RowCount integer false

Number of rows returned maximum

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

InvlineKey integer false

pixi* Invoice line Key

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Result set

Name Type Description
ItemNr string

ItemNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrRef integer

AddrRef

Type: int

Available from: 25.06 (25.6.0.58802)

CustRef integer

CustRef

Type: int

Available from: 25.06 (25.6.0.58802)

ItemQty integer

ItemQty

Type: int

Available from: 25.06 (25.6.0.58802)

ItemRef integer

ItemRef

Type: int

Available from: 25.06 (25.6.0.58802)

ItemVAT string

ItemVAT

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemText string

ItemText

Type: varchar

Available from: 25.06 (25.6.0.58802)

OrderQty integer

OrderQty

Type: int

Available from: 25.06 (25.6.0.58802)

SerialNr string

SerialNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShipCost string

ShipCost

Type: varchar

Available from: 25.06 (25.6.0.58802)

CreateEmp string

CreateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

FullPrice string

FullPrice

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemPrice string

ItemPrice

Type: varchar

Available from: 25.06 (25.6.0.58802)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

CreateDate string

CreateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

InvLineKey integer

InvLineKey

Type: int

Available from: 25.06 (25.6.0.58802)

InvoiceRef integer

InvoiceRef

Type: int

Available from: 25.06 (25.6.0.58802)

UpdateDate string

UpdateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

CCPChargedYN string

CCPChargedYN

Type: varchar

Available from: 25.06 (25.6.0.58802)

DiscountPerc string

DiscountPerc

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemDiscount integer

ItemDiscount

Type: int

Available from: 25.06 (25.6.0.58802)

OrderLineRef integer

OrderLineRef

Type: int

Available from: 25.06 (25.6.0.58802)

DiscountValue string

DiscountValue

Type: varchar

Available from: 25.06 (25.6.0.58802)

OrderCurrency string

OrderCurrency

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShipCostPerItem string

ShipCostPerItem

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShipCost_OrderCurr string

ShipCost_OrderCurr

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemPrice_OrderCurr string

ItemPrice_OrderCurr

Type: varchar

Available from: 25.06 (25.6.0.58802)