Tables

Protheus has files of Tables (SX5) that enable you to standardize some information used by system. To add, change or delete items of tables, you must use Configurator module.

Tables are identified by codes and relate information a field may contain.

To access these tables in its respective fields of module operation, place cursor on field and F3.

It is easy to identify field related to tables. On right side of field you can make queries. Click it and table is displayed.

If this table is blank, it means data are not registered yet. Access Configurator module to update it.

Module Positions and Salary contains topics:

 

Table

Description

Example

R0 - Types of Factor

List types of factors that may be used for calculation.

001 – Career

RC - Regions

Lists regions where company is located.

 

0001 – Capital
0002 – ABCD
0003 – Guarulhos
0004 - Campinas and Country side

RD - Activity Area

Lists companies activity area.

001 – Trade
002 - Industry
003 - Provision of Services

RE - Invoicing

Lists interval of invoicing values of a company.

001 – from 100,000 to 500,000
002 – from 501,000 to 1,000,000
003 – from 1,000,001 to 2,000,000

RF - Salary Survey Result

Lists values of possible result for Salary Survey.

0001 – 1st Decile
0002 – 9th Decile
0003 – 1st Quartile
0004 – 3rd Quartile
0005 – Median
0006 – Average
0007 – Total Frequency
0008 – Variance
0009 – Standard Deviation
0010 – Variation
0011 – Number of Classes
0012 – Sample Scope
0013 – Class Scope

RG - Cut in Salary Survey

Lists types of cuts in Salary Survey.

001 - Standard Deviation
002 - % M.A.P.

RH - Type of Position

Lists Types of Positions.

01 - Managerial
02 - Technician
03 - Administrative
04 - Operational

See how to register tables Configurator environment, topic Tables.