Exibir origem

Table Maintenance

Linha Microsiga Protheus - Inglês > Table Maintenance - Dominican Republic-gpea320_tabela_dom.htm > dom.jpg

This register is used to perform table maintenance according to the structure registered in Table Definition.

Data storage has the following fields as search keys: Branch, Reference Month/Year and Sequence. These fields are mandatory in any table and there is no need to define them in the structure, as they are created automatically by the system.

The tables can be differentiated between branches, if necessary; otherwise the field Branch must be left blank so that the table is common to all branches. Besides, they can be registered monthly or even create a table for unregistered months. Thus, leave the field Month/Year blank.

The sequence is filled out automatically for each existing search key and, as it is registered, it is classified according to the caption.

Example:

Using the title table, the table filled with the classification of the titles and their respective percentages is displayed as follows:

Branch	Month/Year	Sequence	Code	Description	Percentage
		001	01	GRADUATION	1%
		002	02	SPECIALIZATION	2%
		003	03	MASTER'S DEGREE	3%
		004	04	DOCTOR'S DEGREE	4%

The columns Code, Description and Percentage were defined by the Table Definition routine.

Linha Microsiga Protheus - Inglês > Table Maintenance - Dominican Republic-gpea320_tabela_dom.htm > help_button.zoom40.gif Important:

•	Table deletion is subject to its use in calculations, i.e., if in use, it cannot be deleted.

•	In order to fill out the table and use the defined structure in calculations, you must define a calculation formula anticipating their types and percentages. Otherwise, the act of creating a table and filling it out does not have any consequence in calculation results.