SSIS Components for USPS

Build 20.0.7587


Retrieves balance and account information.

Procedure Specific Information

The stored procedure does not interact with any tables.


In order to execute this procedure no special input is needed. See the example below:

EXECUTE GetAccountStatus

Result Set Columns

Name Type Description
PostageBalance Decimal Remaining postage balance after re-credit in dollars and cents.
AscendingBalance Decimal Total amount of postage printed (after re-credit) in dollars and cents. (Endicia only)
SerialNumber String The Serial Number of the last item created on the account.
AccountStatus String The status of the account. 'A' indicates the account is active.
DeviceId String The account's 12 character Device ID.
ControlTotal String account control total. (Stamps only)
TransactionId String Transaction Id for each credit purchase. (Stamps only)
PurchaseStatus String Purchase status for each credit purchase. (Stamps only)
IntegratorTxId String transaction integrator Id. (Stamps only)

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