Reports-Get Data Fields from Table or Webform (since V6R2009x)

This section gives the information about the data dispalyed in different sections of reports using tables and webforms.

The data displayed in certain sections of Reports can be altered using 'configurable components' like tables & webforms. New API methods have been added which retrieve data as per the definition of a table or webform. These APIs return row sets which are used to show data in reports using layout defined in RPT files.

When table is used to get data sets, an inquiry or jpo/method also has to be defined so that API can get the objects on which table column definition can be applied.

Below table lists sections of various reports and their configurable components.

All sections in these reports which are not listed in this table are custom written JPO methods.

Report

Section

Webform

Table

Inquiry

Product Specification Package

Basic Details of Product

FAOtype_Products_SpecPkg

    

Fabric Mill Sheet

Fabric details(except Image)

FAOtype_Fabric_MillSheet

    
 

Approved Colors section

  

FAOFabricApprovedColors

FAOApprovedColors

Seasonal Plan Board Sheet(4 per page)

Details of Seasonal Plan

FAOtype_LinePlan

    
 

Details of Product

  

FAOMyDeskProductList

FAOProjectSpaceProducts

Note: All fields defined in these table/webforms need not be used in the report. When you make any changes in these tables/webforms, run Database > Verify the Database operation in the corresponding RPT file for the change to take effect.