This section includes the fields and descriptions for the Database Fields sub-tab.
| Field | Description |
|---|
| Internal Field Name
|
This field shows the system’s internal name of the database field on the current line.
|
| Field Name
|
This field shows the system’s external name of the database field on the current line.
|
| Type
|
This field shows the field type of the database field on the current line. The type determines the kind of information which is allowed to be entered into the field in question, for instance amounts, dates, integers or text strings. For detailed information on the field types available and their functionality, see the manual “Maconomy Database Description.”
|
| Popup Type
|
If the field on the current line is of the type “PopupValue,” this field shows the pop-up type to which the field belongs. The pop-up types are fixed in Maconomy, and are used for determining which options are available in the pop-up field.
|
| Field No.
|
This field shows the current field’s internal sorting order in the relation. The sorting order has no functionality as such, and the field is therefore only for information.
|
| Key Field
|
This field shows whether the field on the current line is part of the key in the current database relation. Key fields are used for uniquely identifying each entry in the database relation as no two entries can have the same values in the key fields. If the key consists of several fields, no two entries in the relation can have the same combination of values in the key fields.
|
| Mandatory Field
|
If the field is marked, the database field is mandatory.
|
| New Field
|
If the field is marked, the database field is open in Create state.
|
| Update Field
|
If the field is marked, the database field is open in Change state.
|
