No.

The ID number of the field and the field's order on the table.

Name

The name of the field on the table. May be entered with spaces, these will be stripped for the field name and retained for the default display label.

Display Label

Text that will appear in the Header for the Grid. An override for the label to be displayed for the field, leave blank to use the field name as entered.

Type

The type of data stored in the field affects the disk storage each field occupies. See Table Field Types for field types available.

Domain

Select a pre-defined size and type from existing data. If a Domain is selected, the Type, Size and Upper fields use the existing data (read-only). The field and the data have the usual Accredo rules, for example, GL Account codes must be formatted ####.###.

See Domain Documentation for a list of available domains.

Currency Code Field

Shows the currency code field to be used, if available.

Use the FX Amount Domain to set a currency code for an amount. Make sure there is another field in the table with the Domain CO Currency Code, and use that field.

Size

You can set the maximum number of characters allowed in String and Variant Type fields. The maximum field size is based on the number of characters. 1 character = 1 byte.

Width

You can set the amount of characters to be displayed for the field.

Req

Selected, a field value is required before Save.

Clear, a record can be saved if the field is empty.

LPad

For string fields, pads strings with space characters to the maximum size specified by adding spaces to the left of the string.

Uppr

Selected, entered text will be upper case. This is often used for codes.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert an item at the selected line.

Move (Ctrl+Up) (Ctrl+Down)

Select an item and move it higher or lower on the list.

Delete (F3)

Delete the selected item.

Select all (Shift+F4)

Set Visible on all fields to Selected.

Unselect all (Shift+F3)

Set Visible on all fields to Clear.

Buttons

Generate (Alt+G)

Generate MaxBasic code to create a memory table based on field selections. Code will be displayed in the Script Editor.

Table Schema (Alt+T)

Load a custom table or an Accredo table schema.

Import (Alt+I)

Load a Memory Table Builder definition pfm file created in Memory Table Builder.

Export (Alt+E)

Save the Memory Table as a Memory Table Builder definition pfm file.

Upgrade Table (Alt+U)

Converts all non Unicode domains to the equivalent Unicode domain if one exits, e.g. Name -> Name U, Address Line 1 -> Address Line 1 U.

Save (F9)

Save the table.

Cancel (Esc)

Close the form without saving any changes.