Skip to main content

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

FieldDescription
Funding Account NameContains the name of the funding account.
CurrencyRepresents the currency of the funding account.
Funding Account BalanceBalance (as of midnight of the previous day) of the funding account associated with the scheduled load.

Funds Required in the next:

TIMEFRAMEDESCRIPTION
Day (dd/mm/yyyy)Summation of scheduled loads associated with the respective funding account to happen on the report generation day.
2 DaysThe 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 DaysThe 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 DaysThe 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:
FieldDescription
Funding Account NameContains the name of the funding account.
Funding Account BalanceCurrent balance (when the report is being generated) of the funding account with which the scheduled load is associated.
Funding Account CurrencyCurrency of the funding account with which the scheduled load is associated.
Card NumberIt 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 ReferenceIt contains a unique Nium reference of the card associated with the scheduled load.
Scheduled Load IDContains the unique Nium reference for the scheduled load.
Card Created DateDate when the card with which the scheduled load is associated was created.
Scheduled Load DateDate when the scheduled load at hand will take place.
Load AmountThe amount that will be loaded on the card by the scheduled load on Scheduled Load Date
Card CurrencyCurrency of the virtual card with which the scheduled load is associated to.
Last Settled Auth CurrencyCurrency is respective to the most recent settlement received on this card (if available).
Last Settled Auth DateIt will be set to the date the card received its most recent settlement entry (if available).
Card Delete DateDate when the card should be deleted as specified by the respective scheduled load (Clearance Date).
Card StatusCurrent status of the card with which the scheduled load is associated to
Card Factory NameThe card product factory of the card with which the scheduled load is associated to.
Card TypeWhether the card with which the scheduled load is associated is a single or a multi-use card.
Custom FieldsName and value pairs in separate columns for the 20 custom field combinations.