BizTalk Adapter for USPS

Build 20.0.7587

ストアドプロシージャ

ストアドプロシージャを使用することにより、データモデル で利用可能なデータを補完することができます。ビューのデータは、テーブルのような直接的な双方向更新ができないため、その場合はストアドプロシージャを使用して更新する必要があります。この場合、データは適切なビューまたはテーブルを使用して取得されますが、更新はストアドプロシージャを呼び出して実行されます。ストアドプロシージャは、パラメータのリストを受け取り、応答を構成するタプルのコレクションを含むデータセットを返します。

CData BizTalk Adapter for USPS ストアドプロシージャ

Name Description
CalculateRates Returns rate information for a specified service or all services. This table will, at a minimum, take pertinent input information from the Shipments, Senders, Recipients, and Packages tables. The information it fetches from these tables will depend on the provided ShipmentId. The output will be a result set of individual services that will all be automatically inserted into the RateHistory table. It should be noted that if the PostageProvider is set to Stamps, only the first package in the shipment will be processed.
CancelPickup Cancels a requested pickup. The pickup in question is specified by its ConfirmationNumber. Other input information that is related to the pickup will be fetched from the corresponding record in the Pickups table. A side effect of this procedure is that the pertinent record will be deleted from the Pickups table.
ChangePassphrase Change the PassPhrase for an account. Bear in mind that this procedure will not work in test mode.
ChangePickup Changes requested data in your original Pickup Schedule request and schedules a new pickup. Input information will, at a minimum, be gathered from the Senders table. While the number of package types, package location, and any special instructions can be changed here, the original pickup address are immutable. The results reported will be automatically updated in the Pickups table.
GenerateLabels Generates a shipping label for the first package in a given shipment. This table will, at a minimum, take pertinent input information from the Shipments, Senders, Recipients, and Packages tables. Depending on the ShipmentId provided, the Payors, CommercialInvoices, and Commodities tables may be examined as well. The output will be a result set of pertinent label information across multiple records. Each record will be automatically inserted into the LabelHistory table.
GenerateReturnLabels Generates a shipping label for the first package in a given shipment. This table will, at a minimum, take pertinent input information from the Shipments, Senders, Recipients, and Packages tables. Depending on the ShipmentId provided, the Payors, CommercialInvoices, and Commodities tables may be examined as well. The output will be a result set of pertinent label information across multiple records. Each record will be automatically inserted into the LabelHistory table. Unlike GenerateLabels, this procedure will reverse the Sender and Recipient when creating the label.
GetAccountStatus Retrieves balance and account information.
PickupAvailability Checks availability for courier dispatch service for an address. This should be used prior to executing SchedulePickup in order to ensure the service will be available. The output values are not stored internally.
Recredit Add specified postage funds to an account.
Refund Submit refund requests for an account.
SchedulePickup Schedules a courier pickup from a specified sender's location. Input information will, at a minimum, be gathered from the Senders table. While the ConfirmationNumber is displayed immediately, this value will be inserted alongside other pertinent values in the Pickups table automatically.
TrackShipment Returns tracking data for requested idValue of IdentifierType type. This procedure does not need to fetch input from your tables. Its output is a result set containing track event records. Each record will automatically be inserted into the TrackHistory table.

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