4 Add Data source columns

This table provides systematic instructions to add Data source columns.

1. Right-click on the data source to add the data source column.
   Select Fields window displays.

   Figure 4-1 Adding Fields to created Data Source

   
   

   
   Description of "Figure 4-1 Adding Fields to created Data Source"

   
   
2. Select all the columns which have to be included as per the design and then click on the OK button.

   Note:

   All the columns mentioned as primary key columns in the data source level have to be mandatorily included.

   If the footer template is Maintenance Audit, audit columns should not be selected for the master data source. ODT will attach the audit columns automatically while generating units.
   Data Source Field Details screen displays.

   Figure 4-2 Data Source Fields Details

   
   

   
   Description of "Figure 4-2 Data Source Fields Details"

   
   
3. Specify the Data Source Fields details.

   Table 4-1 Data Source Fields Details- Field Description

   Field	Description
   Column Name	This is an information column. The tool will not allow the user to change the value.
   Max Length	The max length of the column will have defaulted while adding a column and it can be overwritten. This value will be considered for the field max length of the designed screen. It means, at the run time system will not allow the user to enter the text more than this length.
   Data Type	This shows the data type of the column selected and the value will be populated while adding the column, this is a non-editable field.
   Block Name	It is an information field, if the field is added to a block, that block name will be populated here.
   Field Name	It is an information field. This displays the data block field to which the column is mapped.
   Upload Table Column	If an adapter upload package is required, the column name in the upload table to which this column is mapped has to be provided. If the field is left blank, then the column name in the upload table will be assumed to be the same as the data source column name.
   Not Required in Upload Tables	If the particular column is not mapped to any upload table column, then this option has to be checked.