|
|
|
|
|
Displays the table you selected in the Table Names window. The associated lookup button opens the Table Names window, where you can select a table and view table names.
Displays the product that contains the table displayed in the Table field.
Displays the series for the table displayed in the Table field.
Displays the table's technical name.
Displays the table's operating system name. This name appears when you view it in the operating system or database.
Displays the display name of the table group that the table in the Table field belongs to.
Displays the technical name of the table group that the table in the Table field belongs to.
Displays the keys in the selected table. A key is a field or combination of fields within a record that are used as a basis by which to store, retrieve and sort records. Typically, the value of the key fields for each record are unique, so the record can be located quickly. For example, the Customer ID field is a key value for the Customer Master table, and each customer has a unique Customer ID.
Displays the key segments (fields that make up the key) for the key selected in the Keys drop-down list.
Displays the selected table's record size. This is the maximum size of a record in the selected table.
Fields that compose the selected table are displayed in the scrolling window at the bottom of the Table Descriptions window.
Field Displays the name of each field in the selected table. These fields are referred to as table fields. Each table field stores individual pieces of information for a particular record.
Physical Name Displays the physical name for each field in the table. If the field is used in a SQL database table, the physical name is used as the column name in the table.
Storage Type Displays the storage type, which indicates how the field's data is stored within the application. If you are integrating with the table, this information can help determine how information should be read and written. If you're using the Import utility to create an import definition, you can review the storage type to verify that the data you're importing will be stored correctly by each field in the table. If you need to find a field's control type, use the Additional Field Information window.
Position Displays each field's position in the record. The position in the record is determined by the size of the previous fields. For instance, if a field is 15 characters in length and is the first field in the record, then the second field would start at position 16.