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: / (25.11.0.62283)

Fax string

Fax

Type: varchar

Available from: / (25.11.0.62283)

ZIP string

ZIP

Type: varchar

Available from: / (25.11.0.62283)

ABLZ string

ABLZ

Type: varchar

Available from: / (25.11.0.62283)

City string

City

Type: varchar

Available from: / (25.11.0.62283)

Fax2 string

Fax2

Type: varchar

Available from: / (25.11.0.62283)

IBAN string

IBAN

Type: varchar

Available from: / (25.11.0.62283)

Name string

Name

Type: varchar

Available from: / (25.11.0.62283)

Note string

Note

Type: datetime

Available from: / (25.11.0.62283)

CCCVC string

CCCVC

Type: varchar

Available from: / (25.11.0.62283)

Name2 string

Name2

Type: varchar

Available from: / (25.11.0.62283)

Phone string

Phone

Type: varchar

Available from: / (25.11.0.62283)

State string

State

Type: varchar

Available from: / (25.11.0.62283)

ZIPMB string

ZIPMB

Type: varchar

Available from: / (25.11.0.62283)

eMail string

eMail

Type: varchar

Available from: / (25.11.0.62283)

AGosF1 string

AGosF1

Type: varchar

Available from: / (25.11.0.62283)

AGosF2 string

AGosF2

Type: varchar

Available from: / (25.11.0.62283)

AddrNr string

AddrNr

Type: varchar

Available from: / (25.11.0.62283)

Anrede string

Anrede

Type: varchar

Available from: / (25.11.0.62283)

CareOf string

CareOf

Type: varchar

Available from: / (25.11.0.62283)

Phone2 string

Phone2

Type: varchar

Available from: / (25.11.0.62283)

Street string

Street

Type: varchar

Available from: / (25.11.0.62283)

UsStId string

UsStId

Type: varchar

Available from: / (25.11.0.62283)

active string

active

Type: varchar

Available from: / (25.11.0.62283)

eMail2 string

eMail2

Type: varchar

Available from: / (25.11.0.62283)

ACardNr string

ACardNr

Type: varchar

Available from: / (25.11.0.62283)

AddrKey integer

AddrKey

Type: int

Available from: / (25.11.0.62283)

Address string

Address

Type: varchar

Available from: / (25.11.0.62283)

CAnrede string

CAnrede

Type: varchar

Available from: / (25.11.0.62283)

Contact string

Contact

Type: varchar

Available from: / (25.11.0.62283)

Country string

Country

Type: varchar

Available from: / (25.11.0.62283)

HouseNr string

HouseNr

Type: varchar

Available from: / (25.11.0.62283)

Mailbox string

Mailbox

Type: varchar

Available from: / (25.11.0.62283)

rowguid integer

rowguid

Type: int

Available from: / (25.11.0.62283)

AAccName string

AAccName

Type: varchar

Available from: / (25.11.0.62283)

AAccount string

AAccount

Type: varchar

Available from: / (25.11.0.62283)

ACardExp string

ACardExp

Type: varchar

Available from: / (25.11.0.62283)

AHisNote string

AHisNote

Type: varchar

Available from: / (25.11.0.62283)

AIssueNr string

AIssueNr

Type: varchar

Available from: / (25.11.0.62283)

APayment string

APayment

Type: varchar

Available from: / (25.11.0.62283)

ASlocked string

ASlocked

Type: varchar

Available from: / (25.11.0.62283)

AddrType string

AddrType

Type: varchar

Available from: / (25.11.0.62283)

LastName string

LastName

Type: varchar

Available from: / (25.11.0.62283)

ABankName string

ABankName

Type: varchar

Available from: / (25.11.0.62283)

ACardName string

ACardName

Type: varchar

Available from: / (25.11.0.62283)

ACardType string

ACardType

Type: varchar

Available from: / (25.11.0.62283)

AReplFlag string

AReplFlag

Type: varchar

Available from: / (25.11.0.62283)

AWaitDays integer

AWaitDays

Type: int

Available from: / (25.11.0.62283)

Ansprache string

Ansprache

Type: varchar

Available from: / (25.11.0.62283)

BirthDate string

BirthDate

Type: datetime

Available from: / (25.11.0.62283)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.11.0.62283)

FirstName string

FirstName

Type: varchar

Available from: / (25.11.0.62283)

SearchKey string

SearchKey

Type: varchar

Available from: / (25.11.0.62283)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.11.0.62283)

AShipImmed string

AShipImmed

Type: varchar

Available from: / (25.11.0.62283)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (25.11.0.62283)

AdrCustRef integer

AdrCustRef

Type: int

Available from: / (25.11.0.62283)

Billing_Id integer

Billing_Id

Type: int

Available from: / (25.11.0.62283)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.11.0.62283)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.11.0.62283)

CompanyType integer

CompanyType

Type: int

Available from: / (25.11.0.62283)

CompanySince string

CompanySince

Type: datetime

Available from: / (25.11.0.62283)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (25.11.0.62283)

PersonContact_Id integer

PersonContact_Id

Type: int

Available from: / (25.11.0.62283)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: / (25.11.0.62283)