Power BI Connector for UPS

Build 20.0.7587

テーブル

本製品 はUPS のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、UPS テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData Power BI Connector for UPS テーブル

Name Description
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.
Commodities Details about a commodity item. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. Specification of at least one commodity item is required only for freight and international shipments.
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.
Packages Type and measures of a given package. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. All shipments will need at least one package specified for them.
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.
Pickups Details of scheduled Pickups from a sender's location. This table is populated by the SchedulePickups stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled. It should also be noted that the CancelPickup stored procedure will remove records from this table.
RateHistory Collection of calculated service rates. This table is populated by the CalculateRates stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled.
Recipients Contact and address details about known shipment recipients. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. All shipments will need a recipient specified for them.
Senders Contact and address details about known shipment senders. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. All shipments will need a sender specified for them.
Shipments Linked entity associations for a shipment. Every shipment will at least need a Sender, Recipient, and at least one Package. It will be from a specified ShipmentId that certain stored procedures (like GenerateLabels) will fetch needed input information from the other related tables, such as Senders, Recipients, and Packages.
TimeHistory Collection of determined shipping time details. This table is populated by the GetShippingTime stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled.
TrackHistory Contains tracked events for a shipment's progress. This table is populated by the TrackShipment stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled.

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