AR Revenue Recognition setup for various periods( period 1 through period 60)

AR Guru,

We have a requirement to start recognizing our invoices based on service start and service end date that are coming through our AR Transaction interface processing.

We need to recognize the revenue for these invoice line based on computation of invoice line service start and service end date.

Here is some example:

Start date  End date

    1/1/2014     2/1/2014

    1/1/2014     3/1/2014

    1/1/2014     4/1/2014 

    1/1/2014     5/1/2014

    1/1/2014     6/1/2014 

    1/1/2014     7/1/2014

    1/1/2014     8/1/2014 

    1/1/2014     9/1/2014

    1/1/2014     10/1/2014 

    1/1/2014     11/1/2014

    1/1/2014    12/1/2014 

    1/1/2014     1/1/2015

    1/1/2014     2/1/2015

    1/1/2014     3/1/2015

    1/1/2014     4/1/2015 

    1/1/2014     5/1/2015

    1/1/2014     6/1/2015 

    1/1/2014     7/1/2015

    1/1/2014     8/1/2015

    1/1/2014     9/1/2015 

    1/1/2014     10/1/2015

    1/1/2014     11/1/2015 

    1/1/2014     12/1/2015 

    1/1/2014     1/1/2016

          "            "

          "            "

    1/1/2014     1/1/2019

Note: The start date may be any day within any given month.

Questions:

                    1- How should we setup our AR invoice and accounting rule for above mentioned requirements? About 60 different periods

                    2- All our AR transactions come to our AR via Oracle Transaction interface process. What are the columns that we need to populate and map based on the Service start and Service date date that we receive from our