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.

JDBC Driver for Sage 200

FinancialReportLayouts

Table Specific Information

Select

Columns