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 FinancialReportLayoutId = 46151 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportLayoutAccountReportType = 'ProfitLoss' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportLayoutName = 'Sample Profit and Loss Layout' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowId = 47221 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowLineType = 'Text' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowLayoutPositionType = 'Unknown' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowLayoutDebitOrCreditType = 'Unknown' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowReportRow = 1 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowTitle = 'Sales' SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowSubtotalGroup = 1 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak1 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak2 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak3 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak4 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak5 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak6 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak7 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak8 = 0 SELECT * FROM FinancialReportLayoutViews WHERE FinancialReportRowGroupBreak9 = 0 SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryId = 123 SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryCode = 'abc' SELECT * FROM FinancialReportLayoutViews WHERE NominalAccountReportCategoryDescription = 'abc'
Columns
Name | Type | References | Description |
FinancialReportLayoutId [KEY] | Long | Financial report layout record Id. | |
FinancialReportLayoutAccountReportType | String | The type of the financial layout. See financial_report_layout_types | |
FinancialReportLayoutName | String | financial report layout name. | |
FinancialReportRowId | Long | An asscoiated financial report row Id. | |
FinancialReportRowLineType | String | The type of the financial layout. See financial_report_row_line_types | |
FinancialReportRowLayoutPositionType | String | The type of the financial report row layout position. See financial_report_row_layout_position_types | |
FinancialReportRowLayoutDebitOrCreditType | String | The type of the financial layout. See financial_report_row_layout_debit_or_credit_types | |
FinancialReportRowReportRow | Int | Value to show the line number of the report row in the layout. | |
FinancialReportRowTitle | String | The row title. | |
FinancialReportRowSubtotalGroup | Int | Value to represent the sub total group. | |
FinancialReportRowGroupBreak1 | Int | Value to represent the report row group break 1. | |
FinancialReportRowGroupBreak2 | Int | Value to represent the report row group break 2. | |
FinancialReportRowGroupBreak3 | Int | Value to represent the report row group break 3. | |
FinancialReportRowGroupBreak4 | Int | Value to represent the report row group break 4. | |
FinancialReportRowGroupBreak5 | Int | Value to represent the report row group break 5. | |
FinancialReportRowGroupBreak6 | Int | Value to represent the report row group break 6. | |
FinancialReportRowGroupBreak7 | Int | Value to represent the report row group break 7. | |
FinancialReportRowGroupBreak8 | Int | Value to represent the report row group break 8. | |
FinancialReportRowGroupBreak9 | 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. |