Exibir origem

Table Maintenance

Linha Microsiga Protheus - Inglês > Table Maintenance - Peru-gpea320_manut_tabelas_per.htm > per.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 for all branches. Besides, they can be registered monthly or even have a table for unregistered months, as long as the field Month/Year is left 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 - Peru-gpea320_manut_tabelas_per.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 simple act of creating a table and filling it out does not have any consequence in calculation results.

The tables used for Peru are:

Code	Description
S001	Utilities
S002	UIT - Unidad Impositiva Tributaria
S003	RMV - Remuneración Mínima Vital
S004	Entidades Pensionales - AFP - Administradoras de Fondos de Pensiones
S005	Aportes Pensionales
S006	Entities SNP - Sistema Nacional de Pensiones
S007	Contributions to EPS - Entidad Promotora de Salud
S008	SCTR - Seguro Complementario de Trabajo de Riesgo
S009	SENATI
S010	5th Category
S011	Fraccionamiento 5ª Categoria
S012	Asignación Familiar
S013	Contract Type
S014	Contract Reason
S015	Parámetros de La Empresa
S016	Life Insurance
S017	Vacaciones
S018	Tipos de Vía
S019	Zone Types
S020	Departments
S021	Province
S022	District
S023	Nationalities

Procedures

Maintaining tables:

1.	In Tables, select Add.

The fields to be filled out are displayed on screen according to the structure registered in the Table Definition.

2.	Fill out data according to field help instructions.

3.	After entering the fields, check and confirm them.