Entity to hold data for occurrence information for certain kind of Invoices

[Anil Patel]

Hi,
It will be nice to be able to Store data about frequency on certain  
invoices (Sales or Purchase). If we know frequency on a Invoice then a  
Service can be scheduled that will watch for Invoice events and  
automatically create invoice from template. In cases when those  
invoice need manual intervention then such events should show up in  
upcoming invoice list in a screenlet on main screen of Ar/Ap app.

I need help to model such table. I can see some thing on lines of  
ProductMaint table.
templateInvoiceId       *       String, VARCHAR(20)     
invoiceTypeId           String, VARCHAR(20)     
intervalQuantity                Double, DOUBLE  
intervalUomId           String, VARCHAR(20)     
repeatCount


Regards
Anil Patel