These columns determine when to start the recurring payment and when to stop it. START_DATE, END_DATE and MAX_NUM_PAYMENTS can only be updated through the UI. START_DATE is required, but you set only one of the END_DATE (end by that date) or MAX_NUM_PAYMENTS (end when this number of payments is made). The recurring payment STATUS is active when it is created and it has not reached either END_DATE or MAX_NUM_PAYMENTS. When one of them is reached, the STATUS is changed to inactive and the recurring payment will never take effect again. If END_DATE is chosen, NEXT_PAY_DATE (the pay date for the next bill to be paid) is greater than or equal to START_DATE and less than or equal to END_DATE, the bill will be paid. The STATUS is set to inactive if NEXT_PAY_DATE > END_DATE. If MAX_NUM_PAYMENTS is chosen, the STATUS is changed to inactive when CURR_NUM_PAYMENTS reaches MAX_NUM_PAYMENTS. |