API Call to retrieve all relevant customers

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


Request

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

Request body

Name Type Required Description
CustKey integer false

pixi* Customer Key

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

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)

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

BLZ

Type: varchar

Available from: / (25.7.0.59144)

CFax string

CFax

Type: varchar

Available from: / (25.7.0.59144)

SZIP string

SZIP

Type: varchar

Available from: / (25.7.0.59144)

BtxNr string

BtxNr

Type: varchar

Available from: / (25.7.0.59144)

CNote string

CNote

Type: varchar

Available from: / (25.7.0.59144)

Rabat string

Rabat

Type: varchar

Available from: / (25.7.0.59144)

SCity string

SCity

Type: varchar

Available from: / (25.7.0.59144)

SName string

SName

Type: varchar

Available from: / (25.7.0.59144)

VATID string

VATID

Type: varchar

Available from: / (25.7.0.59144)

CPhone string

CPhone

Type: varchar

Available from: / (25.7.0.59144)

CardNr string

CardNr

Type: varchar

Available from: / (25.7.0.59144)

CeMail string

CeMail

Type: varchar

Available from: / (25.7.0.59144)

LSType string

LSType

Type: varchar

Available from: / (25.7.0.59144)

SName2 string

SName2

Type: varchar

Available from: / (25.7.0.59144)

SState string

SState

Type: varchar

Available from: / (25.7.0.59144)

SZIPMB string

SZIPMB

Type: varchar

Available from: / (25.7.0.59144)

AccName string

AccName

Type: varchar

Available from: / (25.7.0.59144)

Account string

Account

Type: varchar

Available from: / (25.7.0.59144)

AddrRef integer

AddrRef

Type: int

Available from: / (25.7.0.59144)

CAddrNr string

CAddrNr

Type: varchar

Available from: / (25.7.0.59144)

CardExp string

CardExp

Type: varchar

Available from: / (25.7.0.59144)

CustKey integer

CustKey

Type: int

Available from: / (25.7.0.59144)

DLocked string

DLocked

Type: varchar

Available from: / (25.7.0.59144)

IssueNr string

IssueNr

Type: varchar

Available from: / (25.7.0.59144)

Payment string

Payment

Type: varchar

Available from: / (25.7.0.59144)

SAnrede string

SAnrede

Type: varchar

Available from: / (25.7.0.59144)

SCareOf string

SCareOf

Type: varchar

Available from: / (25.7.0.59144)

SLocked string

SLocked

Type: varchar

Available from: / (25.7.0.59144)

SStreet string

SStreet

Type: varchar

Available from: / (25.7.0.59144)

ShipRef integer

ShipRef

Type: int

Available from: / (25.7.0.59144)

ZZNetto integer

ZZNetto

Type: int

Available from: / (25.7.0.59144)

BankName string

BankName

Type: varchar

Available from: / (25.7.0.59144)

BulkShip string

BulkShip

Type: varchar

Available from: / (25.7.0.59144)

CHisNote string

CHisNote

Type: varchar

Available from: / (25.7.0.59144)

CardName string

CardName

Type: varchar

Available from: / (25.7.0.59144)

CardType string

CardType

Type: varchar

Available from: / (25.7.0.59144)

Discount string

Discount

Type: varchar

Available from: / (25.7.0.59144)

Password string

Password

Type: varchar

Available from: / (25.7.0.59144)

SAddress string

SAddress

Type: varchar

Available from: / (25.7.0.59144)

SCountry string

SCountry

Type: varchar

Available from: / (25.7.0.59144)

SHouseNr string

SHouseNr

Type: varchar

Available from: / (25.7.0.59144)

SMailbox string

SMailbox

Type: varchar

Available from: / (25.7.0.59144)

UserName string

UserName

Type: varchar

Available from: / (25.7.0.59144)

WaitDays integer

WaitDays

Type: int

Available from: / (25.7.0.59144)

WaitHour integer

WaitHour

Type: int

Available from: / (25.7.0.59144)

ZZSkonto integer

ZZSkonto

Type: int

Available from: / (25.7.0.59144)

CLangCode string

CLangCode

Type: varchar

Available from: / (25.7.0.59144)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.7.0.59144)

NoInvoice string

NoInvoice

Type: varchar

Available from: / (25.7.0.59144)

Person_Id integer

Person_Id

Type: int

Available from: / (25.7.0.59144)

SLastName string

SLastName

Type: varchar

Available from: / (25.7.0.59144)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.7.0.59144)

eMailInfo string

eMailInfo

Type: varchar

Available from: / (25.7.0.59144)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.7.0.59144)

CustomerOf string

CustomerOf

Type: varchar

Available from: / (25.7.0.59144)

SFirstName string

SFirstName

Type: varchar

Available from: / (25.7.0.59144)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.7.0.59144)

WaitMinute integer

WaitMinute

Type: int

Available from: / (25.7.0.59144)

MinOrderQty integer

MinOrderQty

Type: int

Available from: / (25.7.0.59144)

NoShipCosts string

NoShipCosts

Type: varchar

Available from: / (25.7.0.59144)

POSCustomer string

POSCustomer

Type: varchar

Available from: / (25.7.0.59144)

UseShipAddr string

UseShipAddr

Type: varchar

Available from: / (25.7.0.59144)

Discountable string

Discountable

Type: varchar

Available from: / (25.7.0.59144)

ReminderCost integer

ReminderCost

Type: int

Available from: / (25.7.0.59144)

TaxOnInvoice string

TaxOnInvoice

Type: varchar

Available from: / (25.7.0.59144)

NextShipImmed string

NextShipImmed

Type: varchar

Available from: / (25.7.0.59144)

InvoiceDueDays integer

InvoiceDueDays

Type: int

Available from: / (25.7.0.59144)

ReminderAction string

ReminderAction

Type: varchar

Available from: / (25.7.0.59144)

ReminderDueDays integer

ReminderDueDays

Type: int

Available from: / (25.7.0.59144)

ZZSkontoProzent integer

ZZSkontoProzent

Type: int

Available from: / (25.7.0.59144)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: / (25.7.0.59144)

DaysForNextReminder integer

DaysForNextReminder

Type: int

Available from: / (25.7.0.59144)

DaysForFirstReminder integer

DaysForFirstReminder

Type: int

Available from: / (25.7.0.59144)