Caption Attribute

In the OutputField element, the optional Caption attribute provides a friendly name to display for an output field. If not specified, the column name defined in the query is used. Hidden columns typically do not require a caption. In the sample below, the FOODBANKTYPE column has a caption of "Food Bank Type."

...
SELECT
      FBCONSTITUENTID
      , FOODBANKTXHEADERID
      , FOODBANKTXDETAILID
      , FBCONSTITUENTNAME
      , FOODBANKTYPE
      , TXCONSTITUENTID
      , TXCONSTITUENTNAME
      , FOODBANKTXTYPE
      FROM CTE
    </CreateFunctionSQL>
    <Parameters>
      <common:FormMetaData>
        <common:FormFields>
          <common:FormField FieldID="FOODBANKID" Caption="Food Bank" Required="false" DataType="Guid">
            <common:SearchList SearchListID="3eceea4c-cf42-4938-9cf1-c7c77ebc7dc9" EnableQuickFind="true" />
          </common:FormField>
        </common:FormFields>
      </common:FormMetaData> 
    </Parameters>
  </TVFImplementation>
  <Output>
    <OutputFields>
      <OutputField Name="FBCONSTITUENTID" IsHidden="true" DataType="Guid" />
      <OutputField Name="FOODBANKTXHEADERID" Caption="FOODBANKTXHEADERID" DataType="Guid" IsHidden="true" />
      <OutputField Name="FOODBANKTXDETAILID" Caption="FOODBANKTXDETAILID" DataType="Guid" IsHidden="true" />
      <OutputField Name="FBCONSTITUENTNAME" Caption="Food Bank" DataType="String" />
      <OutputField Name="FOODBANKTYPE" Caption="Food Bank Type">
        <LookupInfo>
          <CodeTable CodeTableName="USR_FOODBANKTYPECODE" />
        </LookupInfo>
      </OutputField>
...