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.

Field Information

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.

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.