Power BI Connector for UPS

Build 20.0.7587

LabelHistory

Stored details about generated labels for each shipped package. This table is populated by the GenerateLabels and GenerateReturnLabels stored procedures. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled. It should also be noted that the CancelShipment and CancelPackage stored procedures will remove records from this table.

Table Specific Information

The following stored procedures will add records to this table:

  • GenerateLabels
  • GenerateReturnLabels

The following stored procedures will remove records from this table:

  • CancelShipment
  • CancelPackage

Insert

INSERT statements are not supported for this table.

Update

UPDATE statements are not supported for this table.

Columns

Name Type ReadOnly References Description
LabelId [KEY] Integer False

Identifier for this package label.

TrackingNumber String False

Tracking Number for this package.

ShipmentId Integer False

Identifier for applicable shipment.

PackageId Integer False

Identifier for the specific package for this label.

SenderId Integer False

Identifier for the shipment's sender.

RecipientId Integer False

Identifier for the shipment's recipient.

LabelDate Datetime False

Date the label was generated by the provider.

MasterTrackingNumber String False

Tracking Number for the entire shipment.

Surcharges Decimal False

Total surcharges for this package.

TotalBaseCharge Decimal False

Base charge for the entire shipment.

TotalNetCharge Decimal False

Net charge of the entire shipment.

TotalSurcharges Decimal False

Total surcharges for the entire shipment.

ShippingLabelFile String False

File location for the generated label for this package. The naming convention will be the following: RecipientName_ShipmentId_PackageId.gif (or other file type)

ShipmentType String False

Type of service used to generate label.

使用できる値は次のとおりです。Ship, FreightShip, ShipIntl

IsReturnShipment Boolean False

Whether or not this label was for a return shipment.

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