API Call to retrieve all relevant addresses

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


Request

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

Request body

Name Type Required Description
AddrKey integer false

pixi* Address 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
BIC string

BIC

Type: varchar

Available from: / (26.4.0.10717)

Fax string

Fax

Type: varchar

Available from: / (26.4.0.10717)

ZIP string

ZIP

Type: varchar

Available from: / (26.4.0.10717)

ABLZ string

ABLZ

Type: varchar

Available from: / (26.4.0.10717)

City string

City

Type: varchar

Available from: / (26.4.0.10717)

Fax2 string

Fax2

Type: varchar

Available from: / (26.4.0.10717)

IBAN string

IBAN

Type: varchar

Available from: / (26.4.0.10717)

Name string

Name

Type: varchar

Available from: / (26.4.0.10717)

Note string

Note

Type: datetime

Available from: / (26.4.0.10717)

CCCVC string

CCCVC

Type: varchar

Available from: / (26.4.0.10717)

Name2 string

Name2

Type: varchar

Available from: / (26.4.0.10717)

Phone string

Phone

Type: varchar

Available from: / (26.4.0.10717)

State string

State

Type: varchar

Available from: / (26.4.0.10717)

ZIPMB string

ZIPMB

Type: varchar

Available from: / (26.4.0.10717)

eMail string

eMail

Type: varchar

Available from: / (26.4.0.10717)

AGosF1 string

AGosF1

Type: varchar

Available from: / (26.4.0.10717)

AGosF2 string

AGosF2

Type: varchar

Available from: / (26.4.0.10717)

AddrNr string

AddrNr

Type: varchar

Available from: / (26.4.0.10717)

Anrede string

Anrede

Type: varchar

Available from: / (26.4.0.10717)

CareOf string

CareOf

Type: varchar

Available from: / (26.4.0.10717)

Phone2 string

Phone2

Type: varchar

Available from: / (26.4.0.10717)

Street string

Street

Type: varchar

Available from: / (26.4.0.10717)

UsStId string

UsStId

Type: varchar

Available from: / (26.4.0.10717)

active string

active

Type: varchar

Available from: / (26.4.0.10717)

eMail2 string

eMail2

Type: varchar

Available from: / (26.4.0.10717)

ACardNr string

ACardNr

Type: varchar

Available from: / (26.4.0.10717)

AddrKey integer

AddrKey

Type: int

Available from: / (26.4.0.10717)

Address string

Address

Type: varchar

Available from: / (26.4.0.10717)

CAnrede string

CAnrede

Type: varchar

Available from: / (26.4.0.10717)

Contact string

Contact

Type: varchar

Available from: / (26.4.0.10717)

Country string

Country

Type: varchar

Available from: / (26.4.0.10717)

HouseNr string

HouseNr

Type: varchar

Available from: / (26.4.0.10717)

Mailbox string

Mailbox

Type: varchar

Available from: / (26.4.0.10717)

rowguid integer

rowguid

Type: int

Available from: / (26.4.0.10717)

AAccName string

AAccName

Type: varchar

Available from: / (26.4.0.10717)

AAccount string

AAccount

Type: varchar

Available from: / (26.4.0.10717)

ACardExp string

ACardExp

Type: varchar

Available from: / (26.4.0.10717)

AHisNote string

AHisNote

Type: varchar

Available from: / (26.4.0.10717)

AIssueNr string

AIssueNr

Type: varchar

Available from: / (26.4.0.10717)

APayment string

APayment

Type: varchar

Available from: / (26.4.0.10717)

ASlocked string

ASlocked

Type: varchar

Available from: / (26.4.0.10717)

AddrType string

AddrType

Type: varchar

Available from: / (26.4.0.10717)

LastName string

LastName

Type: varchar

Available from: / (26.4.0.10717)

ABankName string

ABankName

Type: varchar

Available from: / (26.4.0.10717)

ACardName string

ACardName

Type: varchar

Available from: / (26.4.0.10717)

ACardType string

ACardType

Type: varchar

Available from: / (26.4.0.10717)

AReplFlag string

AReplFlag

Type: varchar

Available from: / (26.4.0.10717)

AWaitDays integer

AWaitDays

Type: int

Available from: / (26.4.0.10717)

Ansprache string

Ansprache

Type: varchar

Available from: / (26.4.0.10717)

BirthDate string

BirthDate

Type: datetime

Available from: / (26.4.0.10717)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (26.4.0.10717)

FirstName string

FirstName

Type: varchar

Available from: / (26.4.0.10717)

SearchKey string

SearchKey

Type: varchar

Available from: / (26.4.0.10717)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (26.4.0.10717)

AShipImmed string

AShipImmed

Type: varchar

Available from: / (26.4.0.10717)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (26.4.0.10717)

AdrCustRef integer

AdrCustRef

Type: int

Available from: / (26.4.0.10717)

Billing_Id integer

Billing_Id

Type: int

Available from: / (26.4.0.10717)

CreateDate string

CreateDate

Type: datetime

Available from: / (26.4.0.10717)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (26.4.0.10717)

CompanyType integer

CompanyType

Type: int

Available from: / (26.4.0.10717)

CompanySince string

CompanySince

Type: datetime

Available from: / (26.4.0.10717)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (26.4.0.10717)

PersonContact_Id integer

PersonContact_Id

Type: int

Available from: / (26.4.0.10717)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: / (26.4.0.10717)