| Table Definitions (ttadv4120s000) |  |
| Use this session to maintain tables in a package VRC. A table is used to store data in the database. The fields of a table identify which data is stored.
Fields | Description
Package | The table's package code.
VRC | The package version code for which the table is defined.
VRC | The release of the package for which the table is defined.
VRC | The customer extension of the package for which the table is defined. Note The customer extension is only relevant for customized software.
Module | The module code to which the table belongs.
Table | The table identification code. A table is uniquely identified by the combination of package code, module code, and table code.
Date | The date. Related topics To enter a date
User | The name or initials of the designer who created the table definitions.
User | The name of the Tools user.
Update Ref. Message | Select the message code, which appears if a user tries to change the primary key to which another table refers. For example Table: pkitm001 Item table Reference message update: pkitmt0001 Item code cannot be changed, item is in use. Table pksls041 (Sales order line) refers to the item table by its item code. If a user tries to change the item code in the item table, which is used in a sales order line, Tools gives the defined reference message.
Delete Ref. Message | The message code, which appears if a user tries to delete the primary key referred to by another table. For example Table: pkitm001 Item table Reference message delete: pkitmt0001 Item code cannot be deleted, item is in use. Table pksls041 (Sales order line) refers to the item table by its item code. If a user tries to delete the item code in the item table, which is used in a sales order line, Tools displays the defined reference message.
Relation Type | The relation type for the fields in this table. Note This indication is important for delayed lock facilities in the bshell. If you use a delayed lock, two users can change one record at the same time. Notice that they cannot change the same fields or the fields that are related to each other.
Expired | If this check box is selected, the table has expired for this package VRC and its derivatives.
Tech.Documentation | If this check box is selected, documentation is available for the table.
Release Notes | If this check box is selected, release notes are available for the table.