Code

Table

Description

SA6

Banks

It stores information on banks, agencies and accounts of the company and the employees.

SEF

Checks

It stores identification data of the checks indicated in the manual or automatic posting payable routines and/or banking transactions.

Your data is created in Check Generation, where the checks are listed for the respective payments.

SE5

Banking Transaction

It stores data related to banking and/or cash transactions, such as: class, value, due date, transaction date, etc.

SE2

Accounts Payable Transaction

It stores data related to financial transactions.

CT1

Chart of Accounts

It stores data related to ledger accounts of the company.

This table is used in the integration with the Accounting module to generate the accounting entries.

CT2

Accounting Entries

It stores the accounting entries, such as date, type, account number, and value, performed by the transactions of the Personnel Management Module.

Entries are generated by the Accounting routine, according to the definition in the Standardized Entry Registry.

CTT

Cost Centers

It stores identification data of the company cost centers, their debts and credits.

The Cost Centers Table is updated by the Personnel Management Module during the Accounting routine and the routines in which data from this table is necessary, such as the cost center description.

CT6

Batch Totals

It stores data regarding the total of each Accounting Entry Batch of the transactions. It is used in the integration of Accounting and the other system modules.

The Batch Totals Table is used as a comparison tool of the debts of each entry batch generated.

The lot numbers for automatic entries of the other modules are defined in parameters, and the number for accounting are defined by the user.

CT7

Account Plan in Other Currencies

It stores data regarding ledger accounts, their credits, debts and balances. It is used in the integration with the Accounting module and the other modules.

CT5

Standardized Entries

It stores the standardized entries for recording the transactions in order to automate  the procedure, eliminating the need of typing the accounting entries.

To account the Payroll events, standardized entries must be used with codes from A01 to Z99.

The entry codes of the Payroll must be  associated with the budgets of revenues/deductions/basis, through the Budgets Registry.

By using a predefined code for generating the entry, the user must specify the debt and credit accounts,  the history and values. To get this information, formulas in AdvPL can be used.

SR0

Transport Ticket Budgets

It stores data related to the transport tickets used by the employee, such as registration number, employee name, cost center, ticket type, quantity, value paid by the company and the transport ticket value.

SR1

Extra Values

It stores data related to additional values, such as budget code, cost center, total of hours, value, number of installments, budget source, and payment date.

SR2

RAIS

It store required information for the generation of the RAIS (Annual Social Reports List) File on a floppy disk, such as the company's CNPJ (Corporate Taxpayer ID Number), the company's PIS (Social Integration Program), registration number, name, employee salary, salary type, weekly work hours, admission type and others.

SR3

Salary Raise Values

It stores information related to the salary change values by date.

SR4

DIRF Items / Income Statement

It stores the items by beneficiary of the DIRF (Withheld Income Tax Report) Table (SRL - Request to Rectify Entry), such as registration number, beneficiary CNPJ/CPF (Corporate Taxpayer ID Number / Individual Taxpayer ID Number), payment month, income type, value, withholding code and value in UFIRs (Fiscal Reference Unit).

SR5

Parameter Configuration

It stores the layout to record different parameter types (Parameter Table - SRX), such as key file prefix, field name and size, number of decimal places, bill for presentation, and so on.

SR6

Work Shifts

It stores data related to company or branch working shifts, such as code, description, regular hours and resting hours.

SR7

Header of Salary Changes

It stores data related to salary changes by date and type.

SR8

Leaves

It stores information about employee leaves.

SR9

Registry Changes

It stores information on file changes.

SRA

Employees

It stores all data related to the company employees, such as registration number, name, payroll status, functional category, salary, working shift, and advance percentage. This information is essential to generate the payroll.

SRB

Dependants

It stores data related to the employee dependants, such as sequence code, name, birth date, gender, kinship degree, IR dependant type and family allowance.

SRC

Monthly Transaction

It stores revenues, deductions and bases of a specific employee in the transaction month.

SRD

Annual Accrued

It stores revenues, deductions and bases of a specific employee during the accrued period, providing a base to calculations of Year-end Bonus averages, Vacation and Prior Notice, the Financial Form, and the Social Security History.

SRE

Transfers

It stores information about employee shifts, such as branch code, registration number, and source and destination cost center.

SRF

Vacation Schedule

It stores the vacation basis data to pay the employee, as well as the data related to the Vacation Schedule.

SRG

Termination Header

It stores information on agreement rescission header, such as registration number, monthly, daily and hourly salary, dismissal date, homologation date, and days of prior notice.

SRH

Vacation Receipt Header

It stores data on vacation granted to the employees, such as registration number, monthly, daily and hourly salary, initial basis date of vacation, final basis date of vacation, overdue vacation, total of days to deduct due to absences, total of vacation days, and premium days.

SRI

2nd installment of Year-end bonus

It stores revenues, deductions, and basis of a specific employee regarding calculation of the 2nd installment of Year-end bonus.

SRJ

Roles

It stores data related to the roles existing in the company or branch, such as role code, role description, CBO (Brazilian Code of Occupations) and salary paid to the role.

SRK

Future Values

It stores data to be posted later in the Monthly Transaction Table, depending on the due date.

SRL

DIRF Heading/Income Statement

It stores header records for each one of the beneficiaries  by withhold code. The Items are registered at SR4 – DIRF Table (Withheld Income Tax Report)/Income Statement/Items.

SRM

Calculation Procedure

It stores, in a detailed way, the procedures used by each calculation program of this module.

SRN

Transport Means

It stores data related to the several types of transport means used in the company/branch, such as description, unit value, nominal values, in addition to the values necessary to calculate differences of transport ticket.

SRO

Tasks

It stores data to be used when calculating the Pieceworker Payroll, such as registration number, date to perform the task, task code, status of the performed task, and task unit value.

SRP

Average Statement

It stores data regarding the vacation bonus, year-end bonus and prior notice of the last employee whose average was calculated, by using the information in the Annual Accrued Table as reference.

This is a temporary working file, so this file presents only the information about the last employee whose averages were calculated.

SRQ

Beneficiaries

It stores data related to the employee payees.

SRR

Vacation and Termination Items

It stores the resulting revenues, deductions and base in the contractual terminations calculated by the module.

SRS

FGTS Balances

It stores data related to deposits and interests credited in the FGTS (Guarantee Fund for Length of Service) account of the employee.

SRT

Provision Accrued

It stores information about vacation provision and Year-end bonus, month by month, using the base date of vacation and the registered provision budgets as a reference.

SRU

Managerial Search

It stores the search types defined by the users.

SRW

User Process Control

It stores information about the user control of employee data.

SRV

Budgets

It stores the incidences referring to the budget codes, which can be revenues, deductions or bases.

SRX

Parameters

It stores data from different parameter types used by this module.

SRZ

Payroll Summary

It stores information about the GRPS (Social Security Payment Bill) and totaled entries for integration with the Accounting module.

This summary is generated from the payroll and provisions generation routines.

RB7

Scheduled Raise

It stores the scheduled raises for the employees.

RB8

Personnel

It stores data related to the personnel. The information stored in this table can be used to calculate cost values for later periods.

RC0

Definition of Bills

It stores the definitions of bills to generate.

RC1

Bill Transaction for Payroll

It stores the transaction of the bills to generate for Financial.