Power BI Connector for UPS

Build 21.0.7930


Details of a commercial invoice to be included in a freight or international shipment. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references.

Table Specific Information

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

  • GenerateLabels (Freight/Intl only)
  • GenerateReturnLabels (Freight/Intl only)


One may specify a CommercialInvoiceId on creation. However, if one is not provided, then a CommercialInvoiceId be auto-generated.


Name Type ReadOnly References Description
CommercialInvoiceId [KEY] Integer False

Identifier for commercial invoice (required, one will be generated if unspecified).

FreightCharge Double False

Cost to transport the shipment. It is required only if Terms is set to one of the following: CostAndFreight, CostInsuranceAndFreight, CarriageAndInsurancePaid, CarriagePaidTo

Insurance Double False

Insured value of the shipment. It is required only if Terms is set to one of the following: CostInsuranceAndFreight, CarriageAndInsurancePaid

Number String False

Customer assigned invoice number.

Purpose String False

Reason the international shipment was exported, as enumerated.

使用できる値は次のとおりです。Sold, Gift, NotSold, PersonalEffects, RepairAndReturn, Sample

Terms String False

Rights to the seller from the buyer, as enumerated.

使用できる値は次のとおりです。FreeCarrier, FreeOnBoard, CostAndFreight, CostInsuranceAndFreight, CarriageAndInsurancePaid, CarriagePaidTo, DeliveryDutyPaid, DeliveryDutyUnpaid, ExWorks

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