Hey guys,
Goodnight!
Everything ok?

Today I'm going to bring to the blog content that can help many Protheus professionals and/or consultants in their day-to-day lives, which is the name and description of most of the TOTVS (Formerly Microsiga) ERP tables, Protheus.

If a table is missing, leave the name and description here in the comment.

REGISTRATIONS
SA1 CUSTOMER REGISTRATION
SA2 SUPPLIER REGISTRATION
SA3 SELLER REGISTRATION
SA4 CARRIER REGISTRATION
SA5 MOORING PRODUCT X SUPPLIER
SA6 BANK REGISTRATION
SA7 PRODUCT X CUSTOMER TIE
SA9 TECHNICIAN REGISTRATION
SAA REGISTRATION OF HOUR PACKAGES
SAT COMMISSION REGISTRATION
SAC MOORING PRODUCT X VERSION
SAD GROUP X SUPPLIER MOORING
SAE CREDIT CARD REGISTRATION
SAF REGISTRATION OF FACTORS FOR FINANCE
SAG REGISTRATION OF NONCONFORMITIES
SAH REGISTRATION OF MEASUREMENT UNITS
LEAVE APPLICANT REGISTRATION
SAJ REGISTRATION OF PURCHASING GROUPS
SAK APPROVERS REGISTRATION
SALT APPROVAL GROUPS
SAM CODE REGISTRATION FOR EDI
SAN TIE USERS X EVENTS
THEY ARE REF. COMMERCIAL AND BANKING
SAP UNITS CONVERSION
PRODUCTS / STOCK
SB0 ADDITIONAL DATA – STORE
SB1 GENERAL DESCRIPTION OF THE PRODUCT
SB2 PHYSICAL AND FINANCIAL BALANCES
SB3 DEMANDS
SB4 PRODUCT REF. REGISTRATION
SB5 ADDITIONAL PRODUCT DATA
SB6 BALANCE IN THE POWER OF THIRD PARTIES
SB7 INVENTORY RELEASES
SB8 BALANCES PER LOT
SB9 STARTING BALANCES
SBA SALES FORECAST – SIGALOJA
SBB PRICE LIST – SIGAFAS
SBC LOSS BY OP
SBD BALANCE FOR FIFO COST LOT
SBE ADDRESS REGISTRATION
SBF BALANCES BY ADDRESS
SBG BUDGET SUGGESTION
SBH BUDGET SUGGESTION ITEMS
SBI PRODUCTS
SBJ INITIAL BALANCES PER LOT
SBK INITIAL BALANCES BY ADDRESS
SBL PURCHASE SUGGESTION
SBM PRODUCT GROUP
STOCK IN/OUT
SC0 RESERVATIONS FOR BILLING
SC1 PURCHASE REQUESTS
SC2 PRODUCTION ORDERS
SC3 PARTNERSHIP AGREEMENT
SC4 SALES FORECAST
SC5 SALE ORDERS
SC6 SALES ORDERS ITEMS
SC7 PURCHASE ORDERS
SC8 QUOTES
SC9 ORDERS RELEASED
SCA MOVEMENT OF O.S.
SCB CONTRACT REGISTRATION
SCE CLOSING OF QUOTATIONS
SCJ BUDGETS
SCK BUDGET ITEMS
SCL BUDGET ITEMS – SUGGESTION
SCP WAREHOUSE REQUESTS
SCQ PREREQUISITIONS
SCR DOCUMENTS WITH HEIGHT
SCS APPROVERS' BALANCES
SCT SALES GOAL
SCV ORDERS X PAYMENT METHODS
STOCK MOVEMENTS
SD1 ITEMS OF INPUT NF’S
SD2 NF SALE ITEMS
SD3 INTERNAL MOVEMENTS
SD4 COMMITTED REQUIREMENTS
SD5 REQUIREMENTS PER LOT
SD6 CONTRACT ITEMS
SD7 TRANSFERS TO QC
SD8 MOVEMENT. FOR FIFO COST LOT
SDA BALANCES TO DISTRIBUTE
SDB DISTRIBUTION MOVEMENTS
SDC COMPOSITION OF THE COMMITMENT
SDD LOT BLOCKING
SDE TAX INVOICE PRODUCTIONS
SDF SHOPPING SUGGESTED ITEMS
SETTINGS
SX1 Questions and answers
SX2 File mapping
SX3 Data dictionary
SX4 Process schedule schedule
SX5 Tables
SX6 Parameters
SX7 Triggers
SX9 Relationship between files
SXA Registration folders
SXB Default query
SXC User control
SXD Process scheduling control
SXE Document sequence (+1)
SXF Document sequence (next)
SXG Default size for fields
SXK Question control (SX1) users
SXO Log control by table
SXP Log control by table
SIX File indexes (1)
SINDEX File indexes (2)
TAX BOOKS
SF1 INPUT NF HEADER
SF2 HEADER OF OUTPUT NF’S
SF3 TAX BOOKS
SF4 INPUT AND OUTPUT TYPES
SF5 TYPES OF MOVEMENT
SF6 CAD. GUIDES COLLECTION NAC.
SF7 TAXATION GROUP
SF8 MOORING NF ORIG
SF9 CIAP MAINTENANCE
SFA CIAP MONTHLY CANCELLATION
SFB VARIABLE TAX REGISTRATION
CFS TES X TAXES
SFI SUMMARY Z REDUCTION
SFJ PURCHASE SUGGESTION
SFK INITIAL BALANCE-TAX SUBST.
MOUNTING STRUCTURES
SG1 PRODUCT STRUCTURES
SG2 OPERATIONS
SG3 SELECTIVITY GROUPS
SG4 SELECTIVE COMPOSITION OF THE PRODUCT
SG5 REVISION REGISTRATION STRUCTURE
SG6 RESOURCE GROUP
SG7 SECONDARY RESTRICTIONS
SG8 PREFERRED SEQUENCE
SG9 SETUP GROUPS
SGA OPTIONS GROUP REGISTRATION
SGB APS CALENDAR
SGC TIME PER RESOURCE X OPERATION
SGD SETUP MATRIX
SGE PRODUCT ATTRIBUTES
MACHINE LOAD
SH1 RESOURCES
SH2 ALTERNATIVE/SECOND RESOURCES.
SH3 RESOURCES AND TOOLS. BY OPER.
SH4 TOOLS
SH6 PRODUCTION MOVEMENT
SH7 CALENDAR
SH8 ALLOCated OPERATIONS
SH9 BLOCKS AND EXCEPTIONS
SHB WORK CENTER
SHC PRODUCTION MASTER PLAN
SHD OPERAC. SACRAMENTED ALLOCATIONS
S.H.E. SACRAMENTED TOOLS
SHF PRODUCTION MONITORING
ACCOUNTING
SE1 ACCOUNTS RECEIVABLE
SE2 ACCOUNTS PAYABLE
SI1 PLAN OF ACCOUNTS
SI2 ACCOUNTING ENTRY
SI3 COST CENTERS
SI4 ACCOUNT BALANCES
SI5 STANDARDIZED RELEASES
SI6 LOT TOTALS
SI7 ACCOUNT PLAN IN OTHER CURRENCIES
SI8 HISTORY REGISTRATION
SI9 APPOINTMENT REGISTRATION
SIA PRICED VALUES
SIB OFFLINE RATE
SIC PRE-RELEASES
SID ITEMS REGISTRATION
SJ0 URF-FEDERAL REVENUE UNIT
SJ1 NALADI SH
SJ2 NALADI NCCA
SJ3 MONTHLY ACCUMULATIONS
SJ5 UNITS CONVERSION
SJ6 PAYMENT MODE
SJ7 FINANCING INSTITUTIONS
SJ8 REASONS WITHOUT COVERAGE
SJ9 SECEX AGENCIES
SJA CUSTOMS FACILITY
SJB TYPES OF DECLARATION
SJC ALADI
SJD CONTAINER CONTROL
SL1 BUDGET
SL2 BUDGET ITEMS
SL3 ACCUMULATED SALES
SL4 CAD NEGOTIATED CONDITION
SL5 SALES SUMMARY
SL9 REGISTRATION PRODUCTION NOTE
SLA ITEMS PRODUCTION NOTE
SLB PRODUCT DISPOSAL
SLC PRODUCT DISPOSAL ITEMS
SLF TELLER PROFILE/ACCESS
SLG REGISTRATION OF STATIONS
SLH CHANGES LOG
SLI STATION MONITORING
SLJ STORE IDENTIFICATION
SLK BARCODES BY PRODUCT
SLL BASE CLEANING CONTROL
SLM DISTRIBUTION HEADER
SLN DISTRIBUTION ITEMS
SM2 SYSTEM CURRENCIES
SM4 FORMULAS
SM5 COMPANY NEWSPAPER
FIXED ASSET
SN1 FIXED ASSET REGISTRATION
SN2 EXTENDED DESCRIPTIONS
SN3 REGISTRATION OF BALANCES AND VALUES
SN4 FIXED ASSET MOVEMENTS
SN5 BALANCE FILES
SN6 BALANCES BY ACCOUNT AND ITEM
SN7 SALES SIMULATION REGISTRATION
SN8 INVENTORY REGISTRATION
SN9 SHARES REGISTRATION
SNA BALANCES BY CTA, ITEM AND CL VLR
CRM
SO1 SERVICES TABLE
SO2 WARRANTY REQUESTS
SO3 WORKSHOP EMPLOYEES
SO4 REPAIR KIT
SO5 VEHICLE IDENTIFICATION
SO6 BUDGET HEADER
SO7 BUDGET ITEMS
SO8 O.S. HEADER
SO9 SERVICE ORDERS
SOA O.S. TIME NOTE
UNDER FREE MAINTENANCE
SOC SERVICES TABLE ITEMS
PAYROLL
SP0 DESCRIPTION OF THE TIME CLOCK
SP1 MEAL REGISTRATION
SP2 EXCEPTIONS
SP3 HOLIDAYS
SP4 TYPES OF OVERTIME
SP5 REFEITORY
SP6 REASON ALLOWANCE/JUSTIFICATION
SP7 OUT OF USE (COMPATIB ONLY)
SP8 APPOINTMENTS
SP9 EVENTS
SPA VALIDATION RULES
SPB RESULTS
SPC NOTES
SPD ROUNDING
SPE PROVISIONAL BADGES
SPF WORK SHIFT TRANSFER.
SPG ACCUMULATED APPOINTMENTS
SPH ACCUMULATED NOTES
SPI ANNUAL LEAVE
SPJ STANDARD TIMETABLE
SPK PAID EVENTS
SPL ACCUMULATED RESULTS
SPM SNACK
SPN CAFETERIAL ACCUMULATED
SQ0 FUNCTIONAL GROUPS
SQ1 EVALUATION FACTORS
SQ2 FACTOR GRADUATION
SQ3 JOB SPECIFICATION
SQ4 GRADUATION OF POSITIONS
SQ5 JOB SALARIES
SQ6 INFORMANTS
SQ7 WEIGHTING FACTORS/INFORMANTS
SQ8 GRADUATION EMPLOYEE FACTORS
SQ9 EXTRA CURRICULARS
SQA CLASSIFICATION OF POSITIONS
SQB DEPARTMENT
SQC CAREER HISTORY
SQD AGENDA
SQE SELECTION PROCESS
SQG CURRICULUM REGISTRATION
SQH CURRICULUM SETUP
SQI CURRICULUM QUALIFICATION
SQL PROFESSIONAL HISTORY
SQM CURRICULUM COURSES
SQN CALCULABLE FACTORS
SQO QUESTION REGISTRATION
SQP REGISTRATION OF ALTERNATIVES
SQQ TEST
SQR CURRICULUM EVALUATION
SQS VACANCY REGISTRATION
SQT COURSE REGISTRATION
SQU RESEARCH REGISTRATION
SQV GENERAL EVALUATION FACTORS
SQW TESTING MODELS
SR0 TRANSPORTATION VOUCHER ITEMS
SR1 EXTRA VALUES
SR2 R.A.I.S.
SR3 SALARY VALUES HISTORY
SR4 DIRF ITEMS/INCOME REPORT
SR5 PARAMETER SETTING
SR6 WORK SHIFTS
SR7 SALARY CHANGES HISTORY
SR8 LEAVES
SR9 EMPLOYEE HISTORY
MRS EMPLOYEES
SRB DEPENDENTS
SRC MONTHLY MOVEMENT
SRD ANNUAL ACCUMULATIONS
SRE TRANSFERS
SRF PROVISIONS
SRG TERMINATIONS HEADER
SRH VACATION RECEIPT HEADER
SRI 2A. INSTALLMENT 13O. WAGE
SRJ FUNCTIONS
SRK FUTURE VALUES
SRL DIRF HEADER/INFORME RENDIM.
SRM CALCULATION ROUTES
SRN MEANS OF TRANSPORT
SRO TASKS
SRP STATEMENT OF AVERAGES
SRQ BENEFICIARIES
SRR VACATION AND TERMINATION ITEMS
SRS F.G.T.S. BALANCES
SRT ACCUMULATED PROVISION
SRU MANAGEMENT RESEARCH
SRV MONEY
SRW USER PROCESS CONTROL
SRX PARAMETERS
SRZ SHEET SUMMARY
ST0 SPECIALTIES
ST1 EMPLOYEES
ST2 EMPLOYEE SPECIALTIES
MAINTENANCE
ST3 RESOURCE BLOCK
ST4 MAINTENANCE SERVICES
ST5 MAINTENANCE TASKS
ST6 FAMILY OF GOODS
ST7 GOOD MANUFACTURER
ST8 OCCURRENCES
ST9 GOOD
STA PROBLEMS WITH SERVICE ORDERS
STB DETAILS OF THE GOOD
STC STRUCTURE
STD MAINTENANCE AREA
STE TYPE OF MAINTENANCE
STF MAINTENANCE
STG MAINTENANCE DETAILS
STH MAINTENANCE STEPS
STI MAINTENANCE PLAN
STJ MAINTENANCE SERVICE ORDERS.
STK EMPLOYEE BLOCKING
STL SERVICE ORDER DETAILS
STM MAINTENANCE DEPENDENCIES
STN OCCURRENCES RETURN MAINTENANCE
STO FOLLOW-UP PLAN
STP ORDERS SERVICE TRACKING
STQ STEPS PERFORMED
STR PRODUCTION WEAR
STS MAINTENANCE HISTORY
STT MAINTENANCE DETAIL HISTORY
STU HISTORY OF OCCURRENCES
STV PROBLEM HISTORY
STW FOLLOW-UP HISTORY
STX HISTORY OF STEPS EXECUTED
STY PRODUCTION RETURN HISTORY
STZ MOVEMENT OF GOODS
TELEMARKETING
SU0 SALES POINT
SU1 ACCESSORIES
SU2 COMPETITORS
SU3 PROMOTIONS
SU4 CONTACT LISTS
SU5 CONTACTS
SU6 CONTACT LIST ITEMS
SU7 OPERATORS
SU8 MARKETING HISTORY
SU9 REGISTRATION OF OCCURRENCES
YOUR TELESALES BUDGET
SUB TELESALES BUDGET ITEMS
SUC TELEMARKETING HEADER
LDS TELEMARKETING ITEMS
SUE TMK CONFIGURATION HEADER
SUF TMK SETUP ITEMS
SUG ACCESSORIES HEADER
SUH MEDIA REGISTRATION
SUK ITEMS FROM EXECUTED CAMPAIGNS
SOUTH REGISTRATION OF THE TYPE OF COMMUNICATION.
SUM JOB REGISTRATION
SUN REGISTRATION OF THE TYPE OF CLOSE.
SWEAT CAMPAIGN REGISTRATION
SUP DYNAMIC SCRIPT ITEMS
SUQ SHARES REGISTRATION
SUR OCCURRENCE REGISTRATION
SUS PROSPECT REGISTRATION
SUV REGISTRATION OF IN/OUT ATTENDANTS
SUW DYNAMIC SCRIPT
SUZ DYNAMIC SCRIPT REGISTRATION
VEHICLES
SV1 VEHICLE REGISTRATION
SV2 VEHICLES IN TRANSIT
SV3 VEHICLES IN STOCK
SV4 SALES SIMULATIONS
SV8 PRICE LIST
SV9 TYPE OF OS
EXPORT
SW0 S.I. (COVER)
SW1 S.I. (ITEMS)
SW2 P.O. (COVER)
SW3 P.O. (ITEMS)
SW4 P.L.I. (COVER)
SW5 P.L.I. (ITEMS)
SW6 DI. (COVER)
SW7 DI. (ITEMS)
SW8 INVOICES (ITEMS)
SW9 INVOICES (COVER)
SWA GEARBOX (COVER)
SWB EXCHANGE EXCHANGE (ITEMS)
SWC CREDIT LETTER
SWD DI. EXPENSES
SWE G.I. SPECIALS (ITEMS)
SWF PRE-CALCULATION TABLE
SWG HEADER FINANCING
SWH PRE-CALCULATION EXPENSES (DET)
SWI PRE-CALCULATION TABLE
SWJ ITEM HISTORY
SWK GENERAL HISTORY
SWL FINANCING DETAIL
SWM ROF AND L/C AGREEMENT
SWN IMPORT NFE ITEMS
SWO OCCURRENCES
SWP L.I. COVER
SWQ RETURN OF THE P.L.I
SWR PRICE QUOTE
SWS QUOTE ITEMS
SWT QUOTE DETAILS
SWU ORDER MODEL
SWV LOT REGISTRATION / PLI
SWW NF EXPENSES
SWX C.F.O.
SWZ OPERATION
SX5 TABLE REGISTRATION
SY0 PRINTED DOCUMENTS
SY1 BUYERS
SY2 DELIVERY LOCATIONS
SY3 REQUESTING UNIT (C.COST)
SY4 SHIPPING AGENTS
SY5 DISPATCHERS/COMPANY
SY6 PAYMENT TERMS
SY7 MESSAGES
SY8 IMPORT REGIME
SY9 PORTS/AIRPORTS
SYA COUNTRIES
SYB EXPENSES REGISTRATION
SYC PRODUCT FAMILY
SYD NCM
SYE CONVERSION RATES
SYF COINS
SYG REGISTRATION WITH THE MINISTRY
SYH LETTERS OF CREDIT (DETAIL)
SYI ADDITIVES
SYJ INCOTERMS
SYK INSURANCE REGISTRATION
SYL REPORT TEMPLATE (COVER)
SYM REPORT FIELDS
SYN REPORT DICTIONARY
SYO SOURCES OF THE REPORT
SYP MEMO FIELD DESCRIPTIONS
SYQ TRANSPORTATION ROUTES
SYR SHIPPING RATES
SYS COST CENTER PERCENTAGES
SYT IMPORTERS / CONSIGNEES
SYU EASY-GIPLITE INTEGRATION TABLE
SYV ENGINEERING REGISTRATION (COVER)
SYW BROKERS
SYX ENGINEERING REGISTRATION (ITEMS)
SYZ FREE ZONE PRODUCT REGISTRATION
SAQ REGISTRATION OF COLLECTORS
SBP STRUCTURED CODE BASE
SBQ STRUCTURED CODE ITEMS
SBR BASIC PRODUCT DATA
SBS OPTIONS FOR FEATURES
SBT RESTR. FOR CODE FORMATION
SBU STRUCTURE COMPOSITION
SET BOX REGISTRATION
YOUR MULTIPLE NATURES BY TITLE
FRI COLLECTORS COMMISSIONS
SEY RECEIPT
SEZ DISTRIB. OF NATURES IN C.C.
SFM SMART TES
SJE DOCS FOR DISPATCH INSTRUCTIONS
SJF TYPES OF PACKAGING
SJG IMPORT SECTOR
SJH TAX REVENUE
SJI TYPE OF LEGAL ACT
SJJ LEGAL ACT ISSUING BODY
SJK ATTRIBUTES FOR VALUATION
SJL SPECIFICATIONS FOR VALUATION
SJM VALUATION METHODS
SJN ACCREATION TABLE
SJO DECREASE TABLE
S.J.P. TABLE OF TAX REGIMES
SJR REASON FOR TEMPORARY ADMISSION
SJT TYPE OF RECEIVER
SJU INTEREST RATES – BACEN
SLO LAY-AWAY REGISTRATION
SLP LAY-AWAY MOORINGS
SLQ BUDGET
SLR BUDGET ITEMS
CNS BALANCES ON ACCOUNT AND COST
SNG REGISTRATION OF GROUPS OF GOODS
SPO APPOINTMENT PERIODS
SPP MESSAGE REGISTRATION ACCESS
SPQ INCIDENT REGISTRATION ACCESS
SPR ACCESS OCCURRENCE ITEMS
SPS PROGRAMMING OCCURRENCES ACCESS
SRY CALCULATION ROUTE HEADER
SETTINGS
SX1 QUESTIONS
SX2 FILE DICTIONARIES
SX3 FIELD DICTIONARY
SX4 AGENDA
SX5 TABLES
SX6 PARAMETERS
SX7 TRIGGER
SX8 SEQ. DOCUMENTATION
SIX INDICES
SXE SEQ. NUMBERING
SXF SEQ. NUMBERING

Until next time.