TechShorts

The Period Matrix table, Pd_Matrix, is used in calculating accounting period formulas. These formulas include current month, quarter or years activity or balance. These formulas can also be created using standard SQL functions but not all functions are common between SQL Server and MS Access. The Period Matrix has the advantage in that it can be used in any DBMS and it also can be used in table pivoting and folding. The table listed below is for use with the Activity table and not the Balance table. Either a separate matrix table will have to be created or an additional field would have to be added for calculating account formulas with the Balance table. Pd_Type Pd_ID Pd_Name pd_1 pd_2 pd_3 pd_4 pd_5 pd_6 pd_7 pd_8 pd_9 pd_10 pd_11 pd_12 annual 1 YR 1 1 1 1 1 1 1 1 1 1 1 1 month 1 JAN 1 0 0 0 0 0 0 0 0 0 0 0 month 2 FEB 0 1 0 0 0 0 0 0 0 0 0 0 month 3 MAR 0 0 1 0 0 0 0 0 0 0 0 0 month 4 APR 0 0 0 1 0 0 0 0 0 0 0 0 month 5 MAY 0 0 0 0 1 0 0 0 0 0 0 0 month 6 JUN 0 0 0 0 0 1 0 0 0 0 0 0