The report layout table defines the calculation formula for the profit-and-loss report. A report layout table contains the following columns and must conform to the following rules:
Position |
Name | Maximum Length | Description |
1 |
ID | Char 32 | The unique identifying reference for the item
|
2 |
Name | Char 32 | The name of the behavior, which displays on the report |
3 |
Formula | Char 255 | For calculated rows, the formula for the calculation based on the IDs |
4 |
RowOrder | Numeric 8 | The position of the row in the profit-and-loss report |
Note: You can add labels to a report.
The following picture shows a sample report layout table:
Note: Do not include calculated rows, such as the following row, in the report hierarchy table:
The following picture shows the relationship between this sample report layout table and the resulting report: