SSIS Components for UPS

Build 20.0.7587

CommercialInvoices

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)

Insert

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

Columns

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.

The allowed values are Sold, Gift, NotSold, PersonalEffects, RepairAndReturn, Sample.

Terms String False

Rights to the seller from the buyer, as enumerated.

The allowed values are FreeCarrier, FreeOnBoard, CostAndFreight, CostInsuranceAndFreight, CarriageAndInsurancePaid, CarriagePaidTo, DeliveryDutyPaid, DeliveryDutyUnpaid, ExWorks.

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