Tableau Connector for UPS

Build 21.0.7930


Details of a payor for certain shipments. A Payor will only need to be defined if the shipment's PayorType is Recipient or Thirdparty.

Table Specific Information

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

  • GenerateLabels
  • GenerateReturnLabels


In order to add a Payor, one must specify PayorAccountNumber, and CountryCode. See the example below:

INSERT INTO Payors (PayorAccountNumber, Name, CountryCode) VALUES ('133711037', 'John Doe', 'US')
One may specify a PayorId on creation. However, if one is not provided, then a PayorId be auto-generated.


Name Type ReadOnly References Description
PayorId [KEY] Integer False

Identifier for the payor (required, one will be generated if unspecified).

PayorAccountNumber String False

Account number of the payor.

Name String False

Payor's name.

Address String False

Payor's address.

City String False

Payor's city.

State String False

Payor's state.

ZipCode String False

Payor's zip code.

CountryCode String False

Payor's country code.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930