Dynamic Payout FBO Settlement Balance Report
The Dynamic Payout Balance report is a Dynamic Payout report containing data about settlement activities associated with the FBO account since the last report. Worldpay produces the report daily at 10:00 AM ET, Monday through Friday, except bank holidays. This report applies only to Payment Facilitators and merchants using the Dynamic Payout solution. If no activity occurs on a particular day, we do not produce a report for that day.
The table below shows how the data in each daily report varies depending upon a Monday holiday.
|
Report Day |
Report Data for (no holiday) |
Report Data (Monday holiday) |
|---|---|---|
|
Monday |
Friday data |
No Report |
|
Tuesday |
Monday and weekend data |
Friday data |
|
Wednesday |
Tuesday |
Monday, Tuesday, and weekend data |
|
Thursday |
Wednesday |
Wednesday |
|
Friday |
Thursday |
Thursday |
Filename Syntax
The syntax of the report filename is:
DynamicPayoutFBOSettlementBalanceReport_${organizationId}_${targetDay}
where
-
organizationIdis the of the parent merchant organization -
targetDayis the date we generated the report
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.
A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as:
17 digits + decimal point + 2 digits + sign.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
|
Org ID |
Numeric |
19 |
The ID of the Organization. |
|
Org Name |
Alphanumeric |
50 |
The name of the Organization. |
|
Bank Settlement Day |
Date (mm/dd/yyyy) |
10 |
The bank settlement date of the funds transfer. |
|
Activity Type |
Alphanumeric |
50 |
The type of activity associated with the funding instruction. Possible values are:
|
|
Amount |
Signed Decimal |
19 |
The amount of the settlement associated with the Activity Type. |
|
Balance |
Signed Decimal |
19 |
The accumulated account balance after the designated activity. |