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:
- SchedulePickup (intl only)
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.
Identifier of the recipient (required, one will be generated if unspecified).
Recipient's first name.
Recipient's last name.
Recipient's phone number.
Recipient's fax number.
Recipient's email address.
Recipient's street address (line 1).
Recipient's street address (line 2).
Recipient's zip code.
Recipient's country code.
Whether recipient's address is residential.