C1-REF-DTCAL

This algorithm is used to calculate scheduled extraction date for automatic refund clearing records in the CI_​ADJ_​CLR_​STG table. You must attach this algorithm to the Refund Auto Pay Date Calculation Algorithm system event of the required auto pay route types that are used for the automatic refund process.

It contains the following parameters:

• Extract Date Basis - Used to indicate the date when you want to extract the automatic refund clearing record of the credit bill. The valid values are:

  • C - It stands for the adjustment creation date. Used when you want to consider the adjustment creation date for calculating the extraction date.

  • F - It stands for the adjustment freeze date. Used when you want to consider the adjustment freeze date for calculating the extraction date.

    Note: If you do not specify any value for this parameter, by default, it is set to C.

• Due Days - Used when you want to grant additional grace days while calculating the extraction date. For example, if the due days is set to 5, the extract date basis is set to C, and the adjustment creation date is 02-Jan-2026, then the scheduled extraction date is set to 07-Jan-2026 (i.e., 02-Jan-2026 + 5 days).

  Note: If you do not specify any value for this parameter, by default, it is set to 0.

• Days Type - Used to indicate whether you want to use the calendar or business days while calculating the extraction date. The valid values are:

  • C - It stands for the calendar days. Used when you want to use the calendar days while calculating the extraction date.

  • W - It stands for the business days. Used when you want to use the business days while calculating the extraction date. The business days are derived using the work calendar defined on the respective account’s division.

  Note: If you do not specify any value for this parameter, by default, it is set to W.