Dynamic Payout Wallet Projected Available Balance Report

The Dynamic Payout Wallet Projected Available Balance Report is a Dynamic Payout report providing the projected balance in various Dynamic Payout client accounts. This report includes all submitted instructions received and accepted based upon the As Of Date field, even though the delivery of some instructions may not have occurred at the time of the report. By including Funding Instructions that we have queued for delivery, the report gives an accurate account of the funds available for additional Funding Instructions in your Settlement and Reserve accounts. Worldpay produces the report daily, each hour between 4:00 AM ET and 9:00 PM ET, Monday through Friday, and only applies to clients using the Dynamic Payout solution.

Filename Syntax

The syntax of the report filename is:

DynamicPayoutWalletProjectedAvailableBalanceReport_${organizationId}_${targetDay}

where

• organizationId is the Id of the parent merchant organization

• targetDay is the date to which the data applies

Report Structure

The table below provides information about the fields included in the report. The report fields are in the order presented in the table.

Field Name	Data Type	Max Size	Description
Org ID	Numeric (with preceding apostrophe)	20	The Organization ID in the Worldpay eComm system.
Projected Available Balance	Decimal	20	The projected available balance of the Settlement account.
Reserve Balance	Decimal	20	The projected available balance of the Reserve account.
As of Date	Timestamp (MM/dd/yyyy HH:mm:ssz)	23	The time/date for which this balance is valid.
Last Update	Timestamp (MM/dd/yyyy HH:mm:ssz)	23	The date and time (GMT) the balance record was last updated. If no activities occurred (i.e. no funds movement), the system leaves this field empty.