JDBC Driver for Sage 200

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062