pixiReadCustomerAccount

API Call to retrieve all customer account lines

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


Request

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

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)

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)

CustomerAccountKey integer false

pixi* Customer Account Key

Type: int

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
Amount string

Amount

Type: varchar

Available from: 25.06 (25.6.0.58802)

CATKey integer

CATKey

Type: int

Available from: 25.06 (25.6.0.58802)

Comment string

Comment

Type: varchar

Available from: 25.06 (25.6.0.58802)

CustRef integer

CustRef

Type: int

Available from: 25.06 (25.6.0.58802)

EventID string

EventID

Type: varchar

Available from: 25.06 (25.6.0.58802)

Matched string

Matched

Type: varchar

Available from: 25.06 (25.6.0.58802)

DTAUSref integer

DTAUSref

Type: int

Available from: 25.06 (25.6.0.58802)

CreateEmp string

CreateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

EventDate string

EventDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

Reference string

Reference

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)

CurrencyId integer

CurrencyId

Type: int

Available from: 25.06 (25.6.0.58802)

ExchRateId integer

ExchRateId

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)

BanklineRef integer

BanklineRef

Type: int

Available from: 25.06 (25.6.0.58802)

DoNotRefund boolean

DoNotRefund

Type: bit

Available from: 25.06 (25.6.0.58802)

ManualBookingRef integer

ManualBookingRef

Type: int

Available from: 25.06 (25.6.0.58802)

CustomerAccountKey integer

CustomerAccountKey

Type: int

Available from: 25.06 (25.6.0.58802)