Function idvTranslateRecurrence

Description

This function translates a recurrence interval as on the database to the value exposed via the views.

Parameters

pAsOnDB The recurrence field as on ISOL1411/ISOL1417
Returns

The user value as exposed via the views

  • M = Monthly intervals
  • M2 = Two monthly intervals
  • M3 = Quarterly intervals
  • M4 = Four monthly intervals
  • M6 = Six monthly intervals
  • Y = Annual intervals
  • AP = Once per accounting period
  • W = Weekly intervals
  • W2 = Two weekly intervals
  • W4 = Four weekly intervals
  • N = Unspecified intervals

 

  •