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.06 (25.6.0.58802)

CFax string

CFax

Type: varchar

Available from: 25.06 (25.6.0.58802)

SZIP string

SZIP

Type: varchar

Available from: 25.06 (25.6.0.58802)

BtxNr string

BtxNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

CNote string

CNote

Type: varchar

Available from: 25.06 (25.6.0.58802)

Rabat string

Rabat

Type: varchar

Available from: 25.06 (25.6.0.58802)

SCity string

SCity

Type: varchar

Available from: 25.06 (25.6.0.58802)

SName string

SName

Type: varchar

Available from: 25.06 (25.6.0.58802)

VATID string

VATID

Type: varchar

Available from: 25.06 (25.6.0.58802)

CPhone string

CPhone

Type: varchar

Available from: 25.06 (25.6.0.58802)

CardNr string

CardNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

CeMail string

CeMail

Type: varchar

Available from: 25.06 (25.6.0.58802)

LSType string

LSType

Type: varchar

Available from: 25.06 (25.6.0.58802)

SName2 string

SName2

Type: varchar

Available from: 25.06 (25.6.0.58802)

SState string

SState

Type: varchar

Available from: 25.06 (25.6.0.58802)

SZIPMB string

SZIPMB

Type: varchar

Available from: 25.06 (25.6.0.58802)

AccName string

AccName

Type: varchar

Available from: 25.06 (25.6.0.58802)

Account string

Account

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrRef integer

AddrRef

Type: int

Available from: 25.06 (25.6.0.58802)

CAddrNr string

CAddrNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

CardExp string

CardExp

Type: varchar

Available from: 25.06 (25.6.0.58802)

CustKey integer

CustKey

Type: int

Available from: 25.06 (25.6.0.58802)

DLocked string

DLocked

Type: varchar

Available from: 25.06 (25.6.0.58802)

IssueNr string

IssueNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

Payment string

Payment

Type: varchar

Available from: 25.06 (25.6.0.58802)

SAnrede string

SAnrede

Type: varchar

Available from: 25.06 (25.6.0.58802)

SCareOf string

SCareOf

Type: varchar

Available from: 25.06 (25.6.0.58802)

SLocked string

SLocked

Type: varchar

Available from: 25.06 (25.6.0.58802)

SStreet string

SStreet

Type: varchar

Available from: 25.06 (25.6.0.58802)

ShipRef integer

ShipRef

Type: int

Available from: 25.06 (25.6.0.58802)

ZZNetto integer

ZZNetto

Type: int

Available from: 25.06 (25.6.0.58802)

BankName string

BankName

Type: varchar

Available from: 25.06 (25.6.0.58802)

BulkShip string

BulkShip

Type: varchar

Available from: 25.06 (25.6.0.58802)

CHisNote string

CHisNote

Type: varchar

Available from: 25.06 (25.6.0.58802)

CardName string

CardName

Type: varchar

Available from: 25.06 (25.6.0.58802)

CardType string

CardType

Type: varchar

Available from: 25.06 (25.6.0.58802)

Discount string

Discount

Type: varchar

Available from: 25.06 (25.6.0.58802)

Password string

Password

Type: varchar

Available from: 25.06 (25.6.0.58802)

SAddress string

SAddress

Type: varchar

Available from: 25.06 (25.6.0.58802)

SCountry string

SCountry

Type: varchar

Available from: 25.06 (25.6.0.58802)

SHouseNr string

SHouseNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

SMailbox string

SMailbox

Type: varchar

Available from: 25.06 (25.6.0.58802)

UserName string

UserName

Type: varchar

Available from: 25.06 (25.6.0.58802)

WaitDays integer

WaitDays

Type: int

Available from: 25.06 (25.6.0.58802)

WaitHour integer

WaitHour

Type: int

Available from: 25.06 (25.6.0.58802)

ZZSkonto integer

ZZSkonto

Type: int

Available from: 25.06 (25.6.0.58802)

CLangCode string

CLangCode

Type: varchar

Available from: 25.06 (25.6.0.58802)

CreateEmp string

CreateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

NoInvoice string

NoInvoice

Type: varchar

Available from: 25.06 (25.6.0.58802)

Person_Id integer

Person_Id

Type: int

Available from: 25.06 (25.6.0.58802)

SLastName string

SLastName

Type: varchar

Available from: 25.06 (25.6.0.58802)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

eMailInfo string

eMailInfo

Type: varchar

Available from: 25.06 (25.6.0.58802)

CreateDate string

CreateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

CustomerOf string

CustomerOf

Type: varchar

Available from: 25.06 (25.6.0.58802)

SFirstName string

SFirstName

Type: varchar

Available from: 25.06 (25.6.0.58802)

UpdateDate string

UpdateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

WaitMinute integer

WaitMinute

Type: int

Available from: 25.06 (25.6.0.58802)

MinOrderQty integer

MinOrderQty

Type: int

Available from: 25.06 (25.6.0.58802)

NoShipCosts string

NoShipCosts

Type: varchar

Available from: 25.06 (25.6.0.58802)

POSCustomer string

POSCustomer

Type: varchar

Available from: 25.06 (25.6.0.58802)

UseShipAddr string

UseShipAddr

Type: varchar

Available from: 25.06 (25.6.0.58802)

Discountable string

Discountable

Type: varchar

Available from: 25.06 (25.6.0.58802)

ReminderCost integer

ReminderCost

Type: int

Available from: 25.06 (25.6.0.58802)

TaxOnInvoice string

TaxOnInvoice

Type: varchar

Available from: 25.06 (25.6.0.58802)

NextShipImmed string

NextShipImmed

Type: varchar

Available from: 25.06 (25.6.0.58802)

InvoiceDueDays integer

InvoiceDueDays

Type: int

Available from: 25.06 (25.6.0.58802)

ReminderAction string

ReminderAction

Type: varchar

Available from: 25.06 (25.6.0.58802)

ReminderDueDays integer

ReminderDueDays

Type: int

Available from: 25.06 (25.6.0.58802)

ZZSkontoProzent integer

ZZSkontoProzent

Type: int

Available from: 25.06 (25.6.0.58802)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: 25.06 (25.6.0.58802)

DaysForNextReminder integer

DaysForNextReminder

Type: int

Available from: 25.06 (25.6.0.58802)

DaysForFirstReminder integer

DaysForFirstReminder

Type: int

Available from: 25.06 (25.6.0.58802)