The Advanced MDF Option

The advanced MDF option is described in the following topics:

• "Overview of Advanced MDF Option"

• "Key Features of MDF Management"

• "Scenario for MDF Management"

• "Process of Setting Up MDF Programs"

  • "Creating MDF Snapshot Periods"

  • "Making Partners Eligible for MDF Participation"

  • "Enabling the HTIM MDF Period Ending Process Workflow"

  • "Setting Up MDF Approval Authority Limits"

• "Creating an MDF Program and Program Account"

• "Adding a Credit to a Program Account"

• "Creating a Preapproval"

• "Reviewing a Preapproval"

• "Creating a Claim"

• "Reviewing a Claim"

• "About MDF Debits"

• "HTIM MDF Period Ending Process Workflow"

Overview of Advanced MDF Option

In this MDF or co-op management process, the marketing manager sets up one or several programs and selects partners who can participate in the associated funds. This automatically creates program accounts for these partner participants so that partners can accrue funds or receive discretionary MDF amounts under the associated programs. Partners can request funding for marketing activities out of the funds accrued or received in their different program accounts. Partners request funding through the Siebel PRM Portal by creating a preapproval with one or more associated line items, identifying the different cost items associated with the marketing activity. These preapprovals are routed to the channel marketing manager, who can review and either accept or reject cost items at the line item level. Once approved, the partner can execute the corresponding marketing activity.

Partners can create claims through the Siebel PRM Portal to redeem the money in their program accounts for marketing activities against the preapprovals. When a claim is approved, the claim debits the program account. The claim amount can then be sent to the accounting system for payment processing. This process includes flexibility for routing and escalating approval requests to multiple people within brand owner organizations.

Key Features of MDF Management

MDF management includes the following features:

• Program Management. Programs give the brand owner the ability to make marketing funds available to partners automatically. The brand owner can define a program with specific characteristics, such as activation date, expiration date, eligible partners, target markets, target products, fund accrual rules and so on. After the participating partners are identified, the Siebel CRM system automatically generates all the program accounts for the participating partners. A pool of money made available to partners for the organization of marketing activities, for example, campaigns or events.

  There are two programs types:

  • Co-Op Program. A program under which the partner accrues credits based on performance. The co-op program is also known as an accrual fund. For example, resellers could accrue 2% of all product revenue into their account set up under this program.

  • MDF Program. A program under which the partner receives discretionary funding from the brand owner. This is a nonperformance-based program. It is also known as a fixed fund. For example, after approval, this money could be spent on marketing activities for a specific product promotion.

• Program Participant. The account or organization participating in the program. For participating, the partner receives a program account for accrual of funds according to the program rules. This is temporary data used in selecting the partners that can be used for a program account.

  
  

  Note: Participants can be selected only from accounts with the Fund Eligible check box selected. This check box appears in the Administration - Partner screen, Registered Partners view.

  
  

• Program Account. The individual account associated with the partner. Program accounts are child funds of the program. The partner accrues funds in a program account according to the program rules, or the channel account manager deposits discretionary amounts of money into the program account. Each partner can have multiple program accounts, one for each program in which the partner participates. Each partner can participate in the same program only once.

• Credit. This is a child of the program account used to represent the crediting of money to a particular program account. Credits are created manually.

• Preapproval. This is a request for funds. Partners request funding for marketing activities out of the funds accrued in their different program accounts. A preapproval can be associated with only one program account.

• Claim. This is a request for payment against a preapproval after a marketing activity has been executed. Claims go through an approval process at the brand owner's company. Claims are created against a specific preapproval. When the claim is approved, the claim debits the program account defined for the associated program account.

• Debit. Debits are read-only and created automatically only after a claim line item is approved.

Scenario for MDF Management

This scenario gives one example of how MDFs might be used. You might use MDFs differently, depending on your business model.

A program manager at the brand owner company is responsible for collaborative marketing with partners. She realizes that partners often have better insight into local markets and are therefore more suited to organize targeted marketing activities. Recently, her company's new product was introduced and in order to give resellers an incentive to resell this product, she has decided to set up a targeted program. This program lasts for six months, active immediately, and only specially certified dealers are eligible for participation. Under the program, resellers accrue 3% of their revenues for the server product line into their program account. All the funds accrued can then be used by the resellers to run marketing activities. However, her firm refunds only 50% of the total amount approved for every activity.

As part of the setup, the program manager selects the resellers eligible for participation and adds them to the program. By clicking the Generate button, individual program accounts are generated for each participating reseller.

The sales manager at one of the brand owner's resellers has noticed the new program set up by the brand owner. The sales manager decides to set up a local event to promote the new product to the existing client base. The plan is to invite the 20 most popular customers to a seminar to discuss the product. The sales manager creates and submits a preapproval to obtain approval from the brand owner to run the event.

After the event, the reseller collects invoices for the individual line items on his preapproval and submits a claim for payment. The reseller submits the claim, aware that the brand owner funds a maximum 50% of the total amount.

The channel account manager at the brand owner company reviews the claim. The manager sees that all conditions for payment are met. The manager sets the status of the claim to Accepted. However, because the channel account manager can only approve claims up to $1000, the claim status is not automatically set to Final Approved. Instead, the claim gets routed to his manager for review, who approves it.

Process of Setting Up MDF Programs

To set up MDF programs, perform the following tasks:

1. "Creating MDF Snapshot Periods"

2. "Making Partners Eligible for MDF Participation"

3. "Enabling the HTIM MDF Period Ending Process Workflow"

4. "Setting Up MDF Approval Authority Limits"

Creating MDF Snapshot Periods

Program account snapshots give an overview of all transactions for a given program account by period. They contain the amount of available and used funds in an MDF during each period. To use snapshots successfully, periods must first be set up in the Administration - Data screen, Periods view. For more information about creating periods, see the chapter that discusses ongoing applications administration tasks in Siebel Applications Administration Guide.

Before creating MDF programs, you must create at least six snapshot periods of type HTIM MDF Snapshot to cover the current month and the five following months.

This task is a step in "Process of Setting Up MDF Programs".

To create snapshot periods 

1. Navigate to the Administration - Data screen, then the Periods view.

2. In the Period Definition list, create a new record.

3. Enter a name for the period in the Period field.

4. From the Type list, select HTIM MDF Snapshot Month.

5. Complete any other necessary fields. For more information about these fields, see Siebel Applications Administration Guide.

   Repeat Step 2 to Step 5 for each subsequent period until you have created at least six HTIM MDF Snapshot Month periods. Each period you create must begin at the end of the preceding period.

Note: You can edit snapshots in the Monthly Snapshot (Admin) view in the MDF Program Accounts screen.

Making Partners Eligible for MDF Participation

Prior to creating an MDF program, you must make sure that each partner you want to include in an MDF program is eligible for funds.

This task is a step in "Process of Setting Up MDF Programs".

To make partners eligible for MDF programs 

1. Navigate to the Administration - Partner screen, then the Registered Partners view.

2. Drill down on the record of the partner you want to include in a MDF program and then navigate to the More Info view.

3. Locate the Fund Eligible field.

   • If the Fund Eligible field is checked, this partner is already eligible for funds and can participate in an MDF program and no action is required.

   • If the Fund Eligible field is not checked, select the check box. The partner is now eligible to participate in an MDF program.

Enabling the HTIM MDF Period Ending Process Workflow

The HTIM MDF Period Ending Process workflow must be run as a server task (workflow manager task). It can be either a manual task or a repeated task running at the end of the period.

This task is a step in "Process of Setting Up MDF Programs".

For more information about the HTIM MDF Period Ending Process workflow, see "HTIM MDF Period Ending Process Workflow" For information about how to activate workflows in Siebel Tools, see Siebel Business Process Framework: Workflow Guide.

Setting Up MDF Approval Authority Limits

You need to set up an approval authority limit in the Administration - User screen for each employee responsible for approving MDF programs.

This task is a step in "Process of Setting Up MDF Programs".

To set up approval authority limits 

1. Navigate to the Administration - User screen, then the Employees view.

2. Drill down on the employee for whom you want to set up approval authority limits.

3. Navigate to the More Info view.

4. In the Approval Authority section, in the Fund Approval Limit field, enter an approval amount.

Creating an MDF Program and Program Account

The program manager creates an MDF program and adds partners to it. A program account is then created automatically so the partner can take advantage of the MDF.

To create an MDF program and a program account 

1. Navigate to the MDF Program screen, then the Programs view.

2. Create a new record and complete the necessary fields in the record and the More Info form. Some fields are described in the following table.

   Field	Description
   Aging Period (Month)	Number of days until new credits expire.
   Start Date	Date preapprovals can start to be created against the program.
   End Date	Date after which partners can no longer create preapprovals against the program. After this date, partners can still claim fund accruals in their Program Accounts (until the claim receipt deadline).
   Amount	Total dollar amount committed to the program. Required if MDF is selected from the Type field.
   Type	MDF or Co-op program.
   Market	Market segment.
   Program GL Code	General ledger account under which the program is created.
   Participation Rate %	Indicates the percentage of activities organized under this program that the brand owner is willing to fund. This value transfers down to the preapprovals and claim line items.
   Available Balance	Total Balance = [Total Credit] - [Total Debit] These values are rolled up from the credit and debit records through the snapshot, to the program account, and then to the program.
   Credit	Rolled up from program account.
   Debit	Rolled up from program account.

   
   
   
   

   Note: Click the Rollup Snapshot button to refresh the sum of all the credits and debits for all MDF Program Accounts associated with the selected MDF program.

   
   

3. Navigate to the Program Participant view, and add a record.

4. In the Pick Account dialog box, select the partners you want to include in this program and click OK.

5. In the Program Accounts subview, click Generate.

   Program accounts are created automatically for each partner.

Setting Up a Program Account's First Snapshot

Before you can add credits to a program account, you must set up snapshot periods for the program account.

To set up a program account's first snapshot 

1. Navigate to the MDF Program Accounts screen.

2. Locate and drill down on the program account for which you want to set up snapshots.

3. Navigate to the Monthly Snapshot (Admin) view and add a new record.

4. Click the Period select button.

5. In the Pick Period dialog box, query for Period Type of HTIM MDF Snapshot Month.

6. Select the period with the Start Date that is less than or equal to today's date, and the End Date less than or equal to today's date and then click OK.

Removing a Participant From an MDF Program

You might need to remove a participant from an MDF program.

To remove a participant from an MDF program 

1. Navigate to the MDF Program screen.

2. Drill down on the program from which you want to remove a participant.

3. In the Program Participants list, select the participant you want to remove.

4. From the menu, select Delete Record.

5. In the warning dialog box, click OK to confirm deletion of this record.

6. Navigate to the MDF Program Accounts screen.

7. In the Program Accounts list, select the program account belonging to the participant you are removing.

8. In the program account form, from the menu, select Delete Record.

9. In the warning dialog box, click OK to confirm deletion of this record.

   The participant no longer has access to this MDF program.

Adding a Credit to a Program Account

Credits make funds available to resellers. You must create credits manually for each program account. In addition, the batch imports of the MDF credits can be performed using Siebel Enterprise Integration Manager. For information on batch imports, see Siebel Enterprise Integration Manager Administration Guide.

There are three types of credits:

• Accrual. Allows partners to accrue credit in their accounts.

• Adjustment. Allows program managers to apply an adjustment to an existing MDF accrual credit.

• Reinstatement. Allows program managers to extend MDF credit that was forfeited.

  
  

  Note: Co-op program credits are incentive-based while MDF program credits are discretionary.

  
  

Use the following procedure to create an Accrual credit.

To create an Accrual credit 

1. Navigate to the MDF Program Account screen, then the Program Account view.

2. Drill down on the program account record for the partner to whom you want to provide a credit.

3. Navigate to the Checkbook (RW) view and add a new record.

4. Complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Type	Indicates the nature of the credit.
   Sub Type	Further indicates the nature of the credit. This field is optional and does not affect how the MDF credit is processed.
   Market	Market segments relevant to this partner.
   Amount	Amount of the credit.
   Period Posted	Period during which this credit is posted. Note that the MDF credit is set to the current period regardless of what information is entered in the Period Posted field.
   Expiration Date	Date on which this credit is no longer available for the partner's use.

   
   

   Repeat for each partner or program account for which you want to provide a credit.

Use the following procedure to create an Adjustment credit.

To create an Adjustment credit 

1. Navigate to the MDF Program Account screen, then the Program Account view.

2. Drill down on the program account record for the partner to whom you want to make an adjustment.

3. Navigate to the Checkbook (RW) view and add a new record.

4. Complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Type	Indicates the nature of the credit.
   Sub Type	Further indicates the nature of the credit. The available values are Correction or Reallocation. This field is optional and does not affect how the MDF credit is processed.
   Market	Indicates the market segments that are relevant to this partner.
   Amount	Amount of the adjustment. Both negative and positive amounts are accepted.
   Period Posted	Period during which this credit is posted. If the adjustment is a correction to an MDF credit, set the Period Posted date to the same date as the Period Posted date of the original MDF credit. If the adjustment is a reallocation, set the Period Posted date according to your business needs.
   Expiration Date	Date on which this credit is no longer available for the partner's use. If the adjustment is a correction to an MDF credit, set the Expiration Date to the same date as the Expiration Date of the original MDF credit. If the adjustment is a reallocation, set the Expiration Date according to your business needs.

   
   

5. Repeat for each partner or program account for which you want to make an adjustment.

Use the following procedure to create a Reinstatement credit.

To create a Reinstatement credit 

1. Navigate to the MDF Program Account screen, then the Program Account view.

2. Drill down on the program account record for the partner to whom you want to reinstate credit.

3. Navigate to the Checkbook (RW) view and add a new record.

4. Complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Type	Indicates the nature of the credit.
   Sub Type	Further indicates the nature of the credit. This field is optional and does not affect how the MDF credit is processed.
   Market	Indicates the market segments that are relevant to this partner.
   Amount	Amount of the reinstatement credit.
   Period Posted	Period during which this credit is posted.
   Expiration Date	Date on which this credit is no longer available for the partner's use.

   
   

5. Repeat for each partner or program account for which you want to make a reinstatement.

Overview of How Credits Affect the Monthly Snapshot

Adding a credit to a program account results in real-time changes to the current Monthly Snapshot. Some fields are described in the following table.

Table 17-7 How Credits Affect the Monthly Snapshot

Field	Description
30	If the expiration date of the MDF credit is within the current period, the 30 field is increased by the new credit value.
60	If the expiration date of the MDF credit is within the second period, the 60 field is increased by the new credit value.
90	If the expiration date of the MDF credit is within the third period, the 90 field is increased by the new credit value.
90+	If the expiration date of the MDF credit is past 90 days, the 90+ field is increased by the new credit value.

Note: For adjustments, the values are either increased or decreased.

Creating a Preapproval

Using the Siebel PRM Portal, the reseller creates a preapproval so that it can request funds offered by the MDF.

The reseller creates a preapproval with several associated line items. Line items allow the partner to identify specific items required for the marketing activity and their estimated cost.

To create a preapproval 

1. In the Siebel PRM Portal, navigate to the MDF Pre-Approvals screen, then the My Pre-Approvals view.

2. Add a new record and complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Pre-Approval #	Automatically generated number for the preapproval.
   Pre-Approval Name	Description of the preapproval.
   Status	Approval status of the preapproval.
   Program Name	Name of the program to which the program account associated with this preapproval belongs.
   Program Account	Program account against which the preapproval was created.
   Assigned To	Name of person responsible for reviewing and approving this preapproval.
   Partner	Name of the partner account that is submitting the preapproval request.
   Submitted By	Name of person who submitted this preapproval.
   Total Amount Proposed	Sum total of the values in each Amount Proposed field in the line items.
   Total Participation Amount	This value is equal to the participation rate multiplied by the amount proposed as part of the preapproval request. The participation rate value comes from the MDF program.
   Total Amount Approved	Calculated field. The amount is rolled up from the preapproval line items.

   
   

3. Drill down on the Preapproval record and navigate to the Line Items view.

4. Add a new record for each component of this preapproval and complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Category	Indicates the kind of item this is. Values include Advertisement, Seminar, Conference, Trade Show, and Collateral.
   Market	Market segments relevant to this partner.
   Vendor Name	Name of the vendor supplying the good or service indicated in the line item.
   Start Date	Date the specified marketing activity starts.
   End Date	Date the specified marketing activity ends.
   Participation Rate	This value is inherited from the MDF Program Participation Rate.
   Participation Amount	Calculated field indicating the maximum amount the brand owner contributes. The value comes from the participation rate multiplied by the proposed amount.
   Amount Approved	Calculated field indicating how much the brand owner approves for a given line item. This defaults to the participation amount multiplied by the approved percentage.
   Category	Indicates the kind of item this is. Values include Advertisement, Seminar, Conference, Trade Show, and Collateral.
   Market	Market segments relevant to this partner.
   Vendor Name	Name of the vendor supplying the good or service indicated in the line item.
   Start Date	Date the specified marketing activity starts.
   End Date	Date the specified marketing activity ends.
   Participation Rate	This value is inherited from the MDF Program Participation Rate.
   Participation Amount	Calculated field indicating the maximum amount the brand owner contributes. The value comes from the participation rate multiplied by the proposed amount.
   Amount Approved	Calculated field indicating how much the brand owner approves for a given line item. This defaults to the participation amount multiplied by the approved percentage.

   
   

5. Navigate to the Activity or Activity Plans view to associate activities with this preapproval.

6. In the Status field of the preapproval form, select Submitted to submit the preapproval, and then save your changes.

Reviewing a Preapproval

After a preapproval has been submitted, the channel account manager reviews it. He or she can change amounts, reject line items, and approve as appropriate.

To review a preapproval 

1. Navigate to the MDF Pre-Approval screen, then the All Pre-Approvals view.

2. Drill down on the preapproval you want to review.

3. Navigate to the Line Items view to review each line item.

4. In the Status field of each line item, select one of the following:

   1. If you approve the line item, select Accepted As Is.

   2. If you approve the line item but have made changes to it, select Accepted With Changes.

   3. If you do not approve the line item, select Denied.

   4. If you want the partner to make changes, select Returned.

5. In the preapproval form, the value in the Status field must be Submitted and can then be changed to one of the following:

   • Accepted

   • Rejected

   • Pending

   • Returned

   • On Hold

Creating a Claim

After the partner has completed the activity for which it submitted the preapproval, the partner can create a claim and submit it to obtain the funds.

One preapproval can have several claims associated with it, but a claim can be associated only with one preapproval.

To create a claim 

1. In the Siebel PRM Portal, navigate to the MDF Claim screen.

2. Add a new record and complete the necessary fields. Some fields are described in the following table.

   Field	Description
   Status	Status of the claim. Values vary depending on where the claim is in the review process.
   Pre-Approval #	Indicates the preapproval against which this claim is being made. All claims originate from a preapproval.
   Claim Name	Name of the claim.
   Program Name	Name of the program from which this claim originates.
   Has Enough Funds	If this check box is selected, it indicates that the internal available balance field is greater than or equal to the total amount approved field.
   Total Amount Claimed	Total sum of money requested by the reseller.
   Total Amount Approved	Total sum of approved line items.
   Total Participation Amount	This value is equal to the participation rate multiplied by the amount proposed. The participation rate value comes from the MDF program.

   
   

3. Save the claim, drill down on it, and enter more information in the More Info form as needed. Some fields are described in the following table.

   Field	Description
   Claim Category	Choose from a variety of types of events to describe what this claim is for.
   Pre-Approval Category	Type of preapproval event. This value comes from the preapproval record.
   Promotion Name	Provide the name used to promote your event.

   
   

4. Navigate to the Line Items view, add a new record for each completed activity or task outlined in the preapproval, and complete the necessary fields.

   Field	Description
   Amount Claimed	Indicates how money much is being requested for this line item.
   Name	Enter a name for this line item.

   
   

5. In the claim form, in the Status field, select Submitted to submit the claim.

6. Save your changes.

Reviewing a Claim

After the reseller submits a claim, the channel manager reviews it and decides whether it is approved.

To review a claim 

1. Navigate to the MDF Claim screen.

2. In the Claims list, drill down on the claim you want to review.

3. Navigate to the Line Items view and review each of the claim's line items.

4. For each line item, enter values in the Amount Approved and Final Amount Approved fields.

   
   

   Note: Amount Approved could be different from Final Amount Approved if the final approver has to make changes. Final Amount Approved is the field used for back-office processing.

   
   

5. In the Status field of each line item, select one of the following:

   • If you approve the line item, select Accepted As Is.

   • If you approve the line item but have made changes to it, select Accepted With Changes.

   • If you do not approve the line item, select Denied.

   • If you want the partner to make changes, select Returned.

6. In the claim form, change the value from In Progress to one of the following:

   • If you approve the claim, select Accepted.

   • After you change the Status field to Accepted, the claim is processed. If there are sufficient funds and the employee has a sufficient approval limit, then the claim status is automatically set to Final Approval and the appropriate debits are created.

     
     

     Note: The status of an accepted claim is not sent to Final Approval if the claim amount is higher than the approval limit of the channel manager. In this situation, the Reserved field in the current Monthly Snapshot is increased by the claim amount. The Reserved field is decreased by the claim amount when the claim is approved or rejected by a manager with the appropriate approval limit.

     
     

   • If you do not approve the claim, select Denied.

   • The claim cannot be edited any further.

   • If you want to make changes to the claim before approving, select Returned.

   • The reseller can change the status to Pending and continue to work on the claim.

About MDF Debits

Debits are read-only and created automatically only after a claim line item is approved. There are two types of MDF debits:

• Paid. This type of debit is created after an MDF claim is approved by the channel manager and the status is set to Final Approval by the Siebel Business Application.

• Forfeiture. Any unused credit for the current period is forfeited when the HTIM MDF Period Ending Process workflow is executed at the end of the current period. In this situation, a Forfeiture debit is created with the value of the unused credit.

Debit creation results in real-time changes to the Monthly Snapshot. The following table describes the changes that occur when a Paid debit is created.

Table 17-8 Changes in the Monthly Snapshot Resulting from a Paid Debit

Field	Description
Paid	The value is increased by the debit amount.
Ending Balance	The value is decreased by the debit amount.
Available Balance	The value is decreased by the debit amount.
30	If the available credit in this field is more than the MDF debit, the value is decreased by the debit amount. If the balance is zero (0) or less than the MDF debit amount, the balance remains 0 or is decreased to 0.
60	If the available credit in this field is more than the remaining debit amount after debiting available credit from the 30 field, this field is decreased by the remaining MDF debit. If the available credit is less than the remaining debit amount, the balance remains 0 or is decreased to 0.
90	If the available credit in this field is more than the remaining debit amount after debiting the available credit from the 30 and 60 fields, this field is decreased by the remaining MDF debit. If the available credit is less than the remaining debit amount, the balance remains 0 or is decreased to 0.
90+	If the entire MDF debit was not used against the available credit balance in the 30, 60 or 90 fields, this field is decreased by the remaining debit amount.

The following table describes the changes that occur in the Monthly Snapshot when a Forfeiture is created.

Table 17-9 Changes in the Monthly Snapshot Resulting from a Forfeiture

Field	Description
Forfeited	The value is increased by the debit amount.
30	The value is decreased to 0.
Ending Balance	The value is decreased by the debit amount.
Available Balance	The value is decreased by the debit amount.

HTIM MDF Period Ending Process Workflow

On the last day of the current period, the MDF program account Monthly Snapshot for the current period is closed and a new Monthly Snapshot for the next period is created. This process is executed by running the HTIM MDF Period Ending Process workflow. For information about enabling this workflow, see "Enabling the HTIM MDF Period Ending Process Workflow".

The workflow appears in Figure 17-1.

Figure 17-1 HTIM MDF Period Ending Process

This workflow performs the following steps:

1. Queries for the next period with an end date that is less than or equal to the current date and where the type is HTIM MDF Snapshot Month.

2. Checks if today is the end of the current period and if there are subsequent periods available:

   • If the period has not ended or there is no subsequent period available, the workflow ends.

   • If the period has ended and a subsequent period is available, the workflow creates a new Monthly Snapshot for each active MDF program account. Some fields in the new Monthly Snapshot are described in the following table.

Table 17-10 Monthly Snapshot Fields

Field	Description
Beginning Balance	Same value as the Ending Balance of the previous Monthly Snapshot.
Accrued	Total of all MDF accrual credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.
Adjusted	Total of all MDF adjustment credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.
Reinstated	Total of all MDF reinstatement credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.
Paid	Total amount of all MDF debits paid for the current new period. The value is always 0 when the new Monthly Snapshot is created.
Reserved	Same value as the Reserved field in the previous Monthly Snapshot.
30	Same value as the 60 field in the previous Monthly Snapshot.
60	Same value as the 90 field in the previous Monthly Snapshot.
90	Value is TC90-TP90 where: TC90 is the Total Credits expiring within 60 to 90 days of this new period. TP90 is the Total Paid amounts equal or less than the total credits expiring within 60 to 90 days of this period.
90+	Value is TC90Plus-TP90Plus where: TC90Plus is the Total Credits expiring within 90+ days of this period. TP90Plus is the Total Paid amounts equal or less than the total credits expiring within 90-plus (+) days of this period.
Available Balance	Total of 30, 60, 90 and 90+ field values.