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.