FireDAC Components for UPS

Build 20.0.7587

Payors

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

Insert

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.

Columns

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587