BizTalk Adapter for USPS

Build 20.0.7587

Recipients

Contact and address details about known shipment recipients. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. All shipments will need a recipient specified for them.

Table Specific Information

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

  • CalculateRates
  • GenerateLabels
  • GenerateReturnLabels
  • SchedulePickup (intl only)

Insert

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

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

Columns

Name Type ReadOnly References Description
RecipientId [KEY] Integer False

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

Company String False

Recipient's company.

FirstName String False

Recipient's first name.

LastName String False

Recipient's last name.

Phone String False

Recipient's phone number.

Fax String False

Recipient's fax number.

Email String False

Recipient's email address.

Address1 String False

Recipient's street address (line 1).

Address2 String False

Recipient's street address (line 2).

City String False

Recipient's city.

State String False

Recipient's state.

ZipCode String False

Recipient's zip code.

CountryCode String False

Recipient's country code.

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