Select this to accept the table name you entered.

The existing columns for the table you selected are displayed in the listview.

This field is used to name the column in the data dictionary.

Once this name has been created it cannot be changed.

Standard column names should be used across the tables, as this helps with linking. e.g. StockCode.

If your company defines one or more key columns as numeric it is advisable to add a new column to the data dictionary defining the column as numeric, especially if you use these key columns as run time prompts.

This field is used to describe the column in the data dictionary.

You can change this description at a later stage.

Indicate the level of access permitted. The lowest permission held against the table/column is used as the default.

The lower access of the table and column permissions is used to determine the actual access allowed. Therefore, although you can define Read/Write access against the column here, if the level of access against the table is defined as Read only; then you will only have Read only access to the column.

The Column sequence number is a three digit numeric number in the data dictionary that is used to maintain a list of all the columns by sequence number for each table.

It can be used when either browsing on the columns, or when listing them in the Data Dictionary Columns Listing program.

The standard data dictionary generates a sequence number from 1 upwards, reflecting the position within the table. You can therefore, list the fields in the same sequence that they are defined in the record layouts.

If you add a user defined column that is related to a standard column, then give this column the same sequence number as the standard column. This will enable you to find the position easily.

For example: In the Inventory Master table, the Product Class column has a sequence number of 20 and an edit pattern of 4. The first 2 characters of the product class depicts the type, for instance BH is for Bicycle Helmets. You now want further details within the Bicycle Helmets, for instance the size and the color. To do this, add a new column called Product Group with an edit pattern of 2, then give this column the same sequence number of 20. Now, when browsing or listing the columns, the Product Group will appear together with the Product Class.

This field is displayed for verification purposes only and cannot be changed.

This field merely displays what the field will look like when it is printed. This will assist you when aligning the headings on a report.

If the column is a Numeric type, then you must define the edit pattern to be used. An additional edit pattern option is displayed once the column type is set to numeric enabling you to enter edit pattern to be used when printing the field.

This indicates the length of the column. i.e. The number of characters that the column occupies within a line.

This is dependent on the number of decimal places and the selected format.

This is not available for Date type columns.

Select this option if you do not want to print leading zeros in the column. This option is only available for alphanumeric type columns.

Example Customer Code 0001234 is printed as 1234.

This option is only available for alphanumeric column types.

Some General Ledger tables, such as GenMaster, store a company id as the first column and against this column is a behind-the-scenes flag indicating that this must be the current company. The Report Writer uses the Company column flagged as mentioned above to ensure that only rows for the current company id are accessed.

By default this option is selected, which causes the Report Writer to only select records for the current company when the General Ledger is shared.

If this option is deselected, then the Report Writer selects all records in the shared General Ledger files (unless there is some conditional logic limiting the Companies selected in the report). This means you can produce a report that lists all the ledger codes in a consolidated GenMaster table.

This option indicates that numbers have an implied decimal point and that negative numbers do not store the sign as a separate character, but instead changes the last digit according to a table. i.e. The decimal point and sign do not take up any characters.

This indicates the edit pattern to be used when printing the field and is only enabled for Numeric Types.

The number preceding the decimal point represents the number of integers, and the number after the decimal point represents the number of decimal places. If a negative sign is entered, it means values under zero will be printed.

The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.

Select this option if you want to prevent the field from being printed if it has a zero value.

When the file contains 0.0000 for a line, it will print nothing under the column.

This indicates the format in which you want the date displayed and is only enabled for Date type columns.

All dates are now stored as CCYYMMDD in the files, but can displayed as required. The format chosen determines the number of characters required on the line.

This indicates the format to be used when printing a date column.

The same format codes are available throughout the Report Writer.

The dates are held in an internal format and presented according to the format entered here. The editing formats use a / (forward slash) to edit the dates.

Select this to save the information you entered.

	If the table to which you are adding the column resides on a SQL server, you must also add the column to the appropriate table on the SQL server system. i.e. The Browse on Data Dictionary Columns program only adds the column to the Report Writer table.

This indicates the level of access permitted for the column.