Column and Order Specification Dialog - Business Object (CSV) File

Use the Column and Order Specification dialog to include columns from the tables listed on the Comma Separated tab for a Business Object (CSV) file.

column and order specification dialog, described below
Note: Rows in the Business Object (CSV) file are not grouped by table name. Instead, the rows are presented in joined view, and all selected columns are listed as a single ‘table'. A parent row is repeated for each child row.
Table
Click the down arrow to select the name of a joined table.
Available Columns
The names of the available columns in the specified table. Double-click the grid to add a column name to the Columns in Generated Row list.
Note: Columns in the specified table(s) with a Binary, Bit, BLOB, or CLOB data type are not available for selection.

Additionally, you can right-click a column name to display the shortcut menu:

  • Add Column –– add column to the Columns in Generated Row list.
  • Add All Columns –– add all columns from currently selected table to the Columns in Generated Row list.
Columns in Generated Row
The names of the columns (from all tables) to be included in the Business Objects (CSV) file. Double-click the grid to remove a column name from the list. Additionally, you can right-click a column name to display the shortcut menu:
  • Remove Column –– remove column from the list.
  • Remove Columns in Same Table –– remove all columns from the list that share the same table.
  • Remove All Columns –– remove all columns from the list.