Scheduled loads report

This report contains all outstanding pending loads.
This report can keep track of the minimum balance required in the funding account to cover all pending loads. Pending loads are grouped by funding account. This report is a spreadsheet with multiple sheets consisting of a Funding Requirements Summary sheet and associated detailed sheets per time frame. The report is generated daily.

Latest version: 3.13.0
File repository path:Scheduled Loads/Daily
File name pattern: Scheduled_Loads_daily

REPORT CONTENT
Funding Account Name Contains the name of the funding account.
Currency Represents the currency of the funding account.
Funding Account Balance Balance (as of midnight of the previous day) of the funding account associated with the scheduled load.

Funds Required in the next:

TIMEFRAME	DESCRIPTION
Day (dd/mm/yyyy)	Summation of scheduled loads associated with the respective funding account to happen on the report generation day.
2 Days	The summation of scheduled loads associated with the respective funding account will happen during the next two days (including the summation from the previous day).
7 Days	The summation of scheduled loads associated with the respective funding account will happen during the next seven days (including the summation from the previous days).
30 Days	The summation of scheduled loads associated with the respective funding account will happen during the next thirty days (including the summation from the previous days).

Associated details sheets per time frame

These sheets enlist all the scheduled loads that will take place per time frame, irrespective of the funding account that they are associated with. The main difference is that each sheet will include the details of all scheduled loads bound to happen from the current time when the report was generated to the time frame specified in the sheet name.

Schedule Loads – [dd/mm/yyyy] which represents any scheduled loads bound to happen on the report generation date]
Schedule Loads – 2 Days
Schedule Loads – 7 Days
Schedule Loads – 30 Days
Schedule Loads – All
- Enlists all pending loads, irrespective of timeframe.
  These sheets have the following structure:

SHEET STRUCTURE
Funding Account Name Contains the name of the funding account.
Funding Account Balance Current balance (when the report is being generated) of the funding account with which the scheduled load is associated.
Funding Account Currency Currency of the funding account with which the scheduled load is associated.
Card Number It contains the first six and the last four digits of the virtual card with which the scheduled load is associated. This should not be used to match or map card numbers (multiple cards can share the same first six and last four digits). Card reference should be used instead.
Card Reference It contains a unique Nium reference of the card associated with the scheduled load.
Scheduled Load ID Contains the unique Nium reference for the scheduled load.
Card Created Date Date when the card with which the scheduled load is associated was created.
Scheduled Load Date Date when the scheduled load at hand will take place.
Load Amount The amount that will be loaded on the card by the scheduled load on Scheduled Load Date
Card Currency Currency of the virtual card with which the scheduled load is associated to.
Last Settled Auth Currency Currency is respective to the most recent settlement received on this card (if available).
Last Settled Auth Date It will be set to the date the card received its most recent settlement entry (if available).
Card Delete Date Date when the card should be deleted as specified by the respective scheduled load (Clearance Date).
Card Status Current status of the card with which the scheduled load is associated to
Card Factory Name The card product factory of the card with which the scheduled load is associated to.
Card Type Whether the card with which the scheduled load is associated is a single or a multi-use card.
Custom Fields Name and value pairs in separate columns for the 20 custom field combinations.