CData BizTalk Adapter for FedEx 2019 - Online Help
Questions / Feedback?

Brokers

CData BizTalk Adapter for FedEx 2019 - Build 19.0.7354

Contact and address details of known brokers for freight and international shipments. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references.

Table Specific Information

The following stored procedures will rely on input from this table:

  • GenerateLabels (Freight/Intl only)
  • GenerateReturnLabels (Freight/Intl only)

Insert

In order to add a Broker, one must specify FirstName, LastName, Phone, Address1, City, State, ZipCode, and CountryCode. See the example below:

INSERT INTO Brokers (FirstName, LastName, Phone, Address1, City, State, ZipCode, CountryCode) VALUES ('James', 'Doe', '336-111-0377', '049 Address St', 'Chapel Hill', 'NC', '27517', 'US')
One may specify a BrokerId on creation. However, if one is not provided, then a BrokerId be auto-generated.

Columns

Name Type ReadOnly References Description
BrokerId [KEY] Integer False

Identifier of the broker (required, one will be generated if unspecified).

BrokerType String False

Type of brokerage as enumerated.

The allowed values are Unassigned, Inclusive, InclusiveNonResidentImporter, Select, SelectNonResidentImporter.

Company String False

Broker's company.

FirstName String False

Broker's first name.

LastName String False

Broker's last name.

Phone String False

Broker's phone number.

Fax String False

Broker's fax number.

Email String False

Broker's email address.

Address1 String False

Broker's street address (line 1).

Address2 String False

Broker's street address (line 2).

City String False

Broker's city.

State String False

Broker's state.

ZipCode String False

Broker's zip code.

CountryCode String False

Broker's country code.

IsResidential Boolean False

Whether broker's address is residential.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0