Summary

Technical Aspect

Here is a list of all tables that store the Fast Formulas data.

Note:

• In the table below, if the Date tracked column is marked as Yes, assume the Primary key to be Composite. The given Primary will bind with the two date tracked columns to make the Composite Primary keys
• Some of the values in the column Table could be a view / synonym.

Summary

In this chapter we discussed about the need and usage of fats formulas. We started with the basics, like variables, data types and expressions. Then we moved on to the database items and global variables. We discussed about the flow of a formula, the conditions, comments, Input Values and the different keywords. Then we discussed about the user functions, their definition and how they are helpful in adopting PLSQL programming into formulae. We discussed the compilations, tips on the efficiency of the formula, the underlying table structures and finally we saw two different examples of fast formulas.