Report Lines

Report Lines shows all lines in all reports.

Description of table fields:

ID is unique identifier of report line.

ParentID is parent of report.

ReportID and SubreportID are identifiers of Report.

Indent and Bold impacts how this line of the report is represented on the screen.

Formula2 describes formula of calculation the report line with the reference to Chart of Accounts.

FullDescr is field from the system description for line of the report.

Prop1 means type of value in the line. This is Financial, calculated value, comment, Natural or quantitative value, or shares.

Prop2 is about type of the line. It can be group, line, total value or separator.

Prop3 allows to know type of financial value: whether it is asset or liability, revenue or expense.

Prop4 indicates if it is Debit line or Credit line of the report.

Prop5 is applicable to Expense, Revenue and Profit lines of the reports. It specifies whether it is Operating or non-operating expenses.

Prop6 is also about expense lines. It represents type of expenses such as Tax, Rent, Insurance and so on.

Prop7 specifies type of other expenses like Decorations, Cluster Services, Cleaning Suppliers et cetera.

DepartmentID is specified if report line can be related to some department or business function. For example, departments in Payroll-related reports, or Payroll expenses of operating reports.