User Configuration Tables

These tables store the user configuration data needed for communication with the UPS Web Service APIs.

This file contains the UPS OnLine Tools Account information, as well as account-level configuration values.
A          R RUPSUSER

Record

UPS Online Tools Account Information Record

A            USERID        30A

Key

UPS User ID

A            PWD           30A

UPS User Password

A            ACCKEY        30A

UPS Access Key

A            SMARTDFT       1A

Smart Default On

Valid Values:

  • T
  • Y

A            CURCD          3A

Default Currency Code

A            WGTCD          3A

Default Weight Code

A            SVCCD          4A

Default UPS Service Code

A            DIMCD          2A

Default Dimension Code

A            PKGCD          2A

Default Package Type Code

A            AVURL          4A

Address Validation URL Type

Valid Values:

  • DEV
  • PROD

A            XVURL          4A

Street-Level Address Validation URL Type

Valid Values:

  • DEV
  • PROD

A            TTURL          4A

Time in Transit URL Type

Valid Values:

  • DEV
  • PROD

A            RTURL          4A

Rating URL Type

Valid Values:

  • DEV
  • PROD

A            TKURL          4A

Tracking URL Type

Valid Values:

  • DEV
  • PROD

A            SCURL          4A

Shipment Confirm URL Type

Valid Values:

  • DEV
  • PROD

A            SAURL          4A

Shipment Accept URL Type

Valid Values:

  • DEV
  • PROD

A            SVURL          4A

Shipment Void URL Type

Valid Values:

  • DEV
  • PROD

A            PCURL          4A

Pickup Creation URL Type

Valid Values:

  • DEV
  • PROD

A            PRURL          4A

Pickup Rating URL Type

Valid Values:

  • DEV
  • PROD

A            PXURL          4A

Pickup Cancel URL Type

Valid Values:

  • DEV
  • PROD

A            PSURL          4A

Pickup Status URL Type

Valid Values:

  • DEV
  • PROD

This file contains the UPS Shipper Accounts used to ship with UPS Toolkit for i. This file is a child file of UPSUSER.
A          R RUPSACCT

Record

UPS Shipper Accounts Record

A            USERID        30A

Key

UPS User ID

A            ACCTNBR       10A

Key

UPS Account Number

A            DESC          30A

UPS Account Description

A            CONAME        35A

Shipper Company Name

A            ATNAME        35A

Shipper Attention Name

A            PHONE         15A

Shipper Phone Number

A            ADDR1         35A

Shipper Address Line 1

A            ADDR2         35A

Shipper Address Line 2

A            ADDR3         35A

Shipper Address Line 3

A            TOWN          30A

Shipper Town/Division

A            CITY          40A

Shipper City

A            STATE          5A

Shipper State

A            POSTCD        16A

Shipper Postal Code

A            CNTRY          2A

Shipper Country

A            EMAIL         50A

Shipper Email

A            FAX           15A

Shipper Fax Number

A            TAXID         15A

Shipper Tax ID