BrokersCData 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)
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.
Identifier of the broker (required, one will be generated if unspecified).
Type of brokerage as enumerated.
The allowed values are Unassigned, Inclusive, InclusiveNonResidentImporter, Select, SelectNonResidentImporter.
Broker's first name.
Broker's last name.
Broker's phone number.
Broker's fax number.
Broker's email address.
Broker's street address (line 1).
Broker's street address (line 2).
Broker's zip code.
Broker's country code.
Whether broker's address is residential.