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.

This data is generated in the check generation routine, in which checks are listed in order to make the payments.

SE5

Banking Transaction

It stores data related to banking and/or cash transactions, such as: class, amount, 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 amount, performed by the transactions of the Project Management Environment.

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 batch 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 items of revenues/deductions/base, through the Item File.

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

SFD

Earnings Table

It sores data for discount and calculation of Earnings, deductions and deduction limits are allowed.

SR0

Transportation Ticket Items

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

Additional Bonus

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.

SR3

Salary Raise Values

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

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

Leave

It stores information about employee leaves.

SR9

Registration Data Changes

It stores information on registration data 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 revenue, discounts and basis for a certain employee during the accumulated period , providing support to calculate the averages of the year-end bonus. Salary, vacations and prior notice, financial form and social security record.

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

Rescission 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, 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.

SRM

Calculation Procedure

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

SRN

Means of Transportation

It stores data related to the several types of transport means used in the company/branch, such as description, unit amount, nominal amounts, in addition to the amounts 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.

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

Payroll Items

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 regarding GRPS and total records for integration with the Accounting Environment.

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

RB7

Scheduled Raise

It stores the scheduled raises for 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 be generated.

RC1

Bill Transaction for Payroll

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

RCV

Header of Annual Statement

It stores data entered in the header of Annual Statement

RCW

Annual Statement Items

It stores data of items entered in the Annual Statement