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

Fax string

Fax

Type: varchar

Available from: 25.06 (25.6.0.58802)

ZIP string

ZIP

Type: varchar

Available from: 25.06 (25.6.0.58802)

ABLZ string

ABLZ

Type: varchar

Available from: 25.06 (25.6.0.58802)

City string

City

Type: varchar

Available from: 25.06 (25.6.0.58802)

Fax2 string

Fax2

Type: varchar

Available from: 25.06 (25.6.0.58802)

IBAN string

IBAN

Type: varchar

Available from: 25.06 (25.6.0.58802)

Name string

Name

Type: varchar

Available from: 25.06 (25.6.0.58802)

Note string

Note

Type: datetime

Available from: 25.06 (25.6.0.58802)

CCCVC string

CCCVC

Type: varchar

Available from: 25.06 (25.6.0.58802)

Name2 string

Name2

Type: varchar

Available from: 25.06 (25.6.0.58802)

Phone string

Phone

Type: varchar

Available from: 25.06 (25.6.0.58802)

State string

State

Type: varchar

Available from: 25.06 (25.6.0.58802)

ZIPMB string

ZIPMB

Type: varchar

Available from: 25.06 (25.6.0.58802)

eMail string

eMail

Type: varchar

Available from: 25.06 (25.6.0.58802)

AGosF1 string

AGosF1

Type: varchar

Available from: 25.06 (25.6.0.58802)

AGosF2 string

AGosF2

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrNr string

AddrNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

Anrede string

Anrede

Type: varchar

Available from: 25.06 (25.6.0.58802)

CareOf string

CareOf

Type: varchar

Available from: 25.06 (25.6.0.58802)

Phone2 string

Phone2

Type: varchar

Available from: 25.06 (25.6.0.58802)

Street string

Street

Type: varchar

Available from: 25.06 (25.6.0.58802)

UsStId string

UsStId

Type: varchar

Available from: 25.06 (25.6.0.58802)

active string

active

Type: varchar

Available from: 25.06 (25.6.0.58802)

eMail2 string

eMail2

Type: varchar

Available from: 25.06 (25.6.0.58802)

ACardNr string

ACardNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrKey integer

AddrKey

Type: int

Available from: 25.06 (25.6.0.58802)

Address string

Address

Type: varchar

Available from: 25.06 (25.6.0.58802)

CAnrede string

CAnrede

Type: varchar

Available from: 25.06 (25.6.0.58802)

Contact string

Contact

Type: varchar

Available from: 25.06 (25.6.0.58802)

Country string

Country

Type: varchar

Available from: 25.06 (25.6.0.58802)

HouseNr string

HouseNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

Mailbox string

Mailbox

Type: varchar

Available from: 25.06 (25.6.0.58802)

rowguid integer

rowguid

Type: int

Available from: 25.06 (25.6.0.58802)

AAccName string

AAccName

Type: varchar

Available from: 25.06 (25.6.0.58802)

AAccount string

AAccount

Type: varchar

Available from: 25.06 (25.6.0.58802)

ACardExp string

ACardExp

Type: varchar

Available from: 25.06 (25.6.0.58802)

AHisNote string

AHisNote

Type: varchar

Available from: 25.06 (25.6.0.58802)

AIssueNr string

AIssueNr

Type: varchar

Available from: 25.06 (25.6.0.58802)

APayment string

APayment

Type: varchar

Available from: 25.06 (25.6.0.58802)

ASlocked string

ASlocked

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrType string

AddrType

Type: varchar

Available from: 25.06 (25.6.0.58802)

LastName string

LastName

Type: varchar

Available from: 25.06 (25.6.0.58802)

ABankName string

ABankName

Type: varchar

Available from: 25.06 (25.6.0.58802)

ACardName string

ACardName

Type: varchar

Available from: 25.06 (25.6.0.58802)

ACardType string

ACardType

Type: varchar

Available from: 25.06 (25.6.0.58802)

AReplFlag string

AReplFlag

Type: varchar

Available from: 25.06 (25.6.0.58802)

AWaitDays integer

AWaitDays

Type: int

Available from: 25.06 (25.6.0.58802)

Ansprache string

Ansprache

Type: varchar

Available from: 25.06 (25.6.0.58802)

BirthDate string

BirthDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

CreateEmp string

CreateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

FirstName string

FirstName

Type: varchar

Available from: 25.06 (25.6.0.58802)

SearchKey string

SearchKey

Type: varchar

Available from: 25.06 (25.6.0.58802)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: 25.06 (25.6.0.58802)

AShipImmed string

AShipImmed

Type: varchar

Available from: 25.06 (25.6.0.58802)

AddrShopID string

AddrShopID

Type: varchar

Available from: 25.06 (25.6.0.58802)

AdrCustRef integer

AdrCustRef

Type: int

Available from: 25.06 (25.6.0.58802)

Billing_Id integer

Billing_Id

Type: int

Available from: 25.06 (25.6.0.58802)

CreateDate string

CreateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

UpdateDate string

UpdateDate

Type: datetime

Available from: 25.06 (25.6.0.58802)

CompanyType integer

CompanyType

Type: int

Available from: 25.06 (25.6.0.58802)

CompanySince string

CompanySince

Type: datetime

Available from: 25.06 (25.6.0.58802)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: 25.06 (25.6.0.58802)

PersonContact_Id integer

PersonContact_Id

Type: int

Available from: 25.06 (25.6.0.58802)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: 25.06 (25.6.0.58802)