FinancialReportLayouts
Financial statement layouts are designed to provide a clear representation of your accounts. This resource returns the details of all financial statement layouts. The default sort (orderby) field are by 'financial_report_layout_id' and 'financial_report_row_report_row' ascending.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM FinancialReportLayoutViews WHERE LayoutId = 46151 SELECT * FROM FinancialReportLayoutViews WHERE LayoutAccountReportType = 'ProfitLoss' SELECT * FROM FinancialReportLayoutViews WHERE LayoutName = 'Sample Profit and Loss Layout' SELECT * FROM FinancialReportLayoutViews WHERE RowId = 47221 SELECT * FROM FinancialReportLayoutViews WHERE RowLineType = 'Text' SELECT * FROM FinancialReportLayoutViews WHERE RowLayoutPositionType = 'Unknown' SELECT * FROM FinancialReportLayoutViews WHERE RowLayoutDebitOrCreditType = 'Unknown' SELECT * FROM FinancialReportLayoutViews WHERE RowReportRow = 1 SELECT * FROM FinancialReportLayoutViews WHERE RowTitle = 'Sales' SELECT * FROM FinancialReportLayoutViews WHERE RowSubtotalGroup = 1 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak1 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak2 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak3 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak4 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak5 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak6 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak7 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak8 = 0 SELECT * FROM FinancialReportLayoutViews WHERE RowGroupBreak9 = 0 SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryId = 123 SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryCode = 'abc' SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryDescription = 'abc'
Columns
Name | Type | References | Description |
LayoutId [KEY] | Long | Financial report layout record Id. | |
LayoutAccountReportType | String | The type of the financial layout. See financial_report_layout_types | |
LayoutName | String | financial report layout name. | |
RowId | Long | An asscoiated financial report row Id. | |
RowLineType | String | The type of the financial layout. See financial_report_row_line_types | |
RowLayoutPositionType | String | The type of the financial report row layout position. See financial_report_row_layout_position_types | |
RowLayoutDebitOrCreditType | String | The type of the financial layout. See financial_report_row_layout_debit_or_credit_types | |
RowReportRow | Int | Value to show the line number of the report row in the layout. | |
RowTitle | String | The row title. | |
RowSubtotalGroup | Int | Value to represent the sub total group. | |
RowGroupBreak1 | Int | Value to represent the report row group break 1. | |
RowGroupBreak2 | Int | Value to represent the report row group break 2. | |
RowGroupBreak3 | Int | Value to represent the report row group break 3. | |
RowGroupBreak4 | Int | Value to represent the report row group break 4. | |
RowGroupBreak5 | Int | Value to represent the report row group break 5. | |
RowGroupBreak6 | Int | Value to represent the report row group break 6. | |
RowGroupBreak7 | Int | Value to represent the report row group break 7. | |
RowGroupBreak8 | Int | Value to represent the report row group break 8. | |
RowGroupBreak9 | Int | Value to represent the report row group break 9. | |
NominalAccountReportCategoryId | Long | An Id specific to each nominal account report category. See nominal_report_category_types | |
NominalAccountReportCategoryCode | String | The nominal account report category code. | |
NominalAccountReportCategoryDescription | String | The nominal account report category description. |