| # 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. 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. |