ODBC Driver for Sage 200

Build 20.0.7587

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587