CData Excel Add-In for USPS 2019J - Online Help

Senders

CData Excel Add-In for USPS 2019J - Build 19.0.7354

Contact and address details about known shipment senders. 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 sender specified for them.

Table Specific Information

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

  • CalculateRates
  • GenerateLabels
  • GenerateReturnLabels
  • PickupAvailability
  • SchedulePickup

Insert

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

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

Columns

Name Type ReadOnly References Description
SenderId [KEY] Integer False

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

Company String False

Sender's company.

FirstName String False

Sender's first name.

LastName String False

Sender's last name.

Phone String False

Sender's phone number.

Fax String False

Sender's fax number.

Email String False

Sender's email address.

Address1 String False

Sender's street address (line 1).

Address2 String False

Sender's street address (line 2).

City String False

Sender's city.

State String False

Sender's state.

ZipCode String False

Sender's zip code.

CountryCode String False

Sender's country code.

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