FinancialTableColumns

This component runs the Financial Table Columns (FTC) function.

Note: 
  • The column data codes in FinancialTableColumns, which are used for Financials Table reports, are not the same as those in FinancialReportsColumnHeadings, which are used for Financial Analysis and Financial Statements.
  • The Navigator function has been restructured for SunSystems 6.2, and consequently the payload has changed. There is now a header record called Financial Tables Column Set with child Column.

    The new SDM function has parent Financial Reporting Column Set, and child Columns. The old xml tag names have been retained where possible, and now all occur at child level.

Methods

CreateOrAmend
Driver Type: SASI
Use this method to create one or more financial table columns. A financial table column is created if it does not already exist and is amended it if it does.
Delete
Driver Type: SASI
Use this method to delete one or more financial table columns.
DeleteChildData
Driver Type: SASI
Use this method to delete the financial columns defined in the payload, but leaves the parent columns set in place.
Query
Driver Type: Export
Use this method to obtain financial table column details or to extract financial table column data from SunSystems.

Mandatory fields

A value must be supplied for Content Column Code - payload element <ColumnContentCode> except for the Query method where it is optional.

In addition, if creating or amending Column data, or using the DeleteChildData method, then Column Number - payload element <VColumn.VSsrfmscFtc_FtcColNum> must be supplied.

Note: 
  • In SunSystems, the content code may be displayed on the form as column code.
  • At runtime the component validates the payload contents to ensure that the values supplied are correct. Various combinations of values may require other elements in the payload to be specified before the payload can be processed successfully.

Related data

Column.