Click on the banner to learn about and purchase my database training on Azure

Protheus - Names and Descriptions of TOTVS ERP tables

Views: 144.254 views
Reading Time: 7 minutes

Hello guys,
Good night!
All right?

Today I will bring to the blog, content that can help many Protheus professionals and / or consultants on a daily basis, which is the name and description of most of the tables of ERTV of TOTVS (Old Microsiga), Protheus.

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

REGISTRATIONS
SA1 CUSTOMER BASE
SA2 SUPPLIER REGISTRATION
SA3 SELLER REGISTRATION
SA4 CARRIER REGISTRATION
SA5 PRODUCT X SUPPLIER MOORING
SA6 BANK REGISTRATION
SA7 PRODUCT X CUSTOMER MOORING
SA9 TECHNICAL REGISTRATION
SAA HOUR PACK REGISTRATION
SAB COMMISSION REGISTRATION
CSC MOORING PRODUCT X VERSION
USA GROUP X SUPPLIER MOORING
SAE CREDIT CARD REGISTRATION
SAF FACTOR REGISTRATION FOR FINANCING
SAG NON-CONFORMITY REGISTRATION
CHESS MEASURING UNITS REGISTRATION
SAI APPLICANT REGISTRATION
SAJ SHOPPING GROUP REGISTRATION
SAK APPROVERS REGISTRATION
SHAWL APPROVAL GROUPS
SAM EDI CODE REGISTRATION
SAN MOORING USERS X EVENTS
SAO REF. COMMERCIAL AND BANKING
SAP UNIT CONVERSION
PRODUCTS / STOCK
SB0 ADDITIONAL DATA - STORE
SB1 GENERAL PRODUCT DESCRIPTION
SB2 PHYSICAL AND FINANCIAL BALANCES
SB3 DEMANDS
SB4 PRODUCT REFERENCE REGISTRATION
SB5 ADDITIONAL PRODUCT DATA
SB6 BALANCE IN POWER OF THIRD PARTIES
SB7 INVENTORY LAUNCHES
SB8 BALANCE BATCH
SB9 INITIAL BALANCES
SBA SALES FORECAST - SIGALOJA
SBB PRICE TABLE - SIGAFAS
SBC OP LOSS
SBD FIFO COST BATCH BALANCE
SBE ADDRESS REGISTER
SBF ADDRESS BALANCES
SBG BUDGET SUGGESTION
SBH BUDGET SUGGESTION ITEMS
SBI PRODUCTS X PRICES
SBJ BATCH INITIAL BALANCES
SBK INITIAL BALANCES BY ADDRESS
SBL PURCHASE SUGGESTION
SBM PRODUCT GROUP
INPUTS / EXITS STOCKS
SC0 BILLING RESERVATIONS
SC1 PURCHASE REQUESTS
SC2 PRODUCTION ORDERS
SC3 PARTNERSHIP AGREEMENT
SC4 SALES FORECAST
SC5 SALE REQUESTS
SC6 SALE REQUEST ITEMS
SC7 PURCHASE REQUESTS
SC8 QUOTATIONS
SC9 RELEASED REQUESTS
SCA MOVEMENT OF
SCB CONTRACT REGISTRATION
SCE CLOSURE OF QUOTATIONS
SCJ BUDGETS
SCK pins can be used BUDGET ITEMS
SCL BUDGET ITEMS - TIP
SCP WAREHOUSE REQUESTS
SCQ PRE-REQUIREMENTS
SCR DOCUMENTS WITH ALÈADA
SCS APPROVAL BALANCES
SCT SALES GOAL
SCV ORDERS X PAYMENT FORMS
STOCK MOVEMENTS
SD1 INPUT NF ITEMS
SD2 NF SALE ITEMS
SD3 INTERNAL MOVEMENTS
SD4 COMMITTED REQUIREMENTS
SD5 BATCH REQUIREMENTS
SD6 CONTRACT ITEMS
SD7 TRANSFERS TO QC
SD8 MOVEMENT FOR COST FIFO LOT
SDA BALANCES TO BE DISTRIBUTED
SDB DISTRIBUTION MOVEMENTS
SDC COMPOSITION OF THE
SDD LOTS LOCK
SDE RATE OF TAX NOTE
SDF ITEMS SHOPPING
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 Register Folders
SXB Standard Query
SXC User Control
SXD Process Schedule Control
SXE Document Sequence (+ 1)
SXF Document Sequence (next)
SXG Default size for fields
Sxk Question Tracking (SX1) Users
Sxo Table log control
SXP Table log control
SIX File Indexes (1)
SINDEX File Indexes (2)
TAX BOOKS
SF1 INPUT NF'S HEAD
SF2 HEAD OF OUTPUT NF'S
SF3 TAX BOOKS
SF4 INPUT AND OUTPUT TYPES
SF5 TYPES OF MOVEMENT
SF6 COLLECTION GUIDELINES
SF7 TAXATION GROUP
SF8 Mooring NF ORIG X NF IMP / FRE
SF9 CIAP MAINTENANCE
SFA CIAP MONTHLY BACKGROUND
SFB VARIABLE TAX REGISTRATION
SFC Mooring TES X TAXES
IFC SUMMARY REDUCTION Z
SFJ PURCHASE SUGGESTION
SFK INITIAL-SUB-TAX BALANCE
ASSEMBLY STRUCTURES
SG1 PRODUCT STRUCTURES
SG2 OPERATIONS
SG3 SELECTIVE GROUPS
SG4 SELECTIVE PRODUCT COMPOSITION
SG5 STRUCTURE REVIEW REGISTRATION
SG6 RESOURCE GROUP
SG7 SECONDARY RESTRICTIONS
SG8 PREFERRED SEQUENCE
SG9 SETUP GROUPS
EMS REGISTRATION GROUP OF OPTIONALS
SGB APS CALENDAR
SGC RESOURCE TIME X OPERATION
SGD SETUP MOTHER
SGE PRODUCT ATTRIBUTES
MACHINE LOAD
SH1 RESOURCES
SH2 ALTERNATIVE RESOURCES / SECUND.
SH3 FEATURES AND TOOL. BY OPER
SH4 TOOLS
SH6 PRODUCTION MOVEMENT
SH7 CALENDAR
SH8 ALLOCATED OPERATIONS
SH9 LOCKERS AND EXCEPTIONS
SHB WORK CENTER
SHC MASTER PLAN OF PRODUCTION
SHD OPERATION Sacred Allocated
SHE SACRAMED TOOLS
SHF PRODUCTION MONITORING
ACCOUNTING
SE1 BILLS TO RECEIVE
SE2 BILLS TO PAY
SI1 ACCOUNTING PLAN
SI2 ACCOUNTING ENTRIES
SI3 COST CENTERS
SI4 ACCOUNT X ITEMS BALANCE
SI5 STANDARDIZED LAUNCHES
SI6 BATCH TOTALS
SI7 PLAN ACCOUNTS IN OTHER COINS
SI8 HISTORY REGISTRATION
SI9 RATE REGISTRATION
SIA ORCED VALUES
Battles OFF LINE RATE
SIC PRE-LAUNCHES
SID ITEM REGISTRATION
SJ0 Federal Revenue Unit
SJ1 NALADI SH
SJ2 NALADI NCCA
SJ3 MONTHLY ACCUMULATED
SJ5 UNIT CONVERSION
SJ6 PAYMENT MODE
SJ7 FINANCING INSTITUTIONS
SJ8 REASONS NOT COVERED
SJ9 SECEX AGENCIES
SJA CUSTOMS RECOMMENDED
SJB TYPES OF STATEMENT
SJC ALADI
SJD CONTAINER CONTROL
SL1 BUDGET
SL2 BUDGET ITEMS
SL3 ACCUMULATED SALES
SL4 CAD CONDITION NEGOTIED
SL5 SALES SUMMARY
SL9 REGISTRATION PRODUCTION POINT
SLA PRODUCTION POINT ITEMS
SLB PRODUCTS DISPOSAL
SLC DISPOSAL ITEMS
SLF BOX PROFILE / ACCESS
SLG STATION REGISTRATION
SLH MODIFICATION LOG
SLI MONITORING OF STATIONS
FLS STORE IDENTIFICATION
SLK BAR CODES BY PRODUCT
SLL BASE CLEAN CONTROL
SLM DISTRIBUTION HEAD
SLN DISTRIBUTION ITEMS
SM2 SYSTEM COINS
SM4 FORMULAS
SM5 COMPANY NEWSPAPER
FIXED ASSETS
SN1 PROPERTY 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 SIMULATION REGISTRATION SALES
SN8 INVENTORY REGISTRATION
SN9 SHARE 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 HEAD OF THEM
SO9 SERVICE ORDERS
SOA OS TIME POINT
REINDEER FREE MAINTENANCE
SOC SERVICE TABLE ITEMS
PAYROLL
SP0 DESCRIPTION OF POINT WATCH
SP1 MEAL REGISTRATION
SP2 Exceptions
SP3 HOLIDAYS
SP4 TYPES OF EXTRA HOURS
SP5 REFECTORY
SP6 REASON FOR REASON / JUSTIFICATION
SP7 OUT OF USE (COMPATIB ONLY)
SP8 MARKINGS
SP9 EVENTS
SPA VALIDATION RULES
SPB RESULTS
SPC APPOINTMENTS
SPD Rounds
PES PROVISIONAL CRACHAS
SPF TRANSFER FROM TURNO TRAB.
SPG ACCUMULATED MARKINGS
SPH ACCUMULATED POINTS
SPI BANK OF HOURS
SPJ STANDARD TIMETABLE
SPK Awarded Events
SPL ACCUMULATED RESULTS
SPM MEAL
SPN Accumulated refectory
SQ0 FUNCTIONAL GROUPS
SQ1 EVALUATION FACTORS
SQ2 FACTORS GRADUATION
SQ3 POST SPECIFICATION
SQ4 POST GRADUATION
SQ5 POSITION SALARIES
SQ6 INFORMANT
SQ7 FACTORS / INFORMANT WEIGHTING
SQ8 GRADUATION WORKING FACTORS
SQ9 EXTRA CURRICULAR
SQA POST CLASSIFICATION
SQB Personnel
SQC CAREER HISTORY
SQD AGENDA
SQE SELECTIVE PROCESS
SQG CURRICULUM REGISTRATION
SQH Curriculum Configuration
SQI CURRICULUM QUALIFICATION
SQL PROFESSIONAL HISTORY
SQM CURRICULUM COURSES
SQN CALCULABLE FACTORS
SQO ISSUE REGISTRATION
SQP ALTERNATIVE REGISTRATION
SQQ TEST
SQR Curriculum Evaluation
SQS VACANCY REGISTRATION
SQT COURSE REGISTRATION
SQU RESEARCH REGISTRATION
SQV EVALUATION FACTORS
SQW TEST MODELS
SR0 TRANSPORT TRANSPORT ITEMS
SR1 EXTRA VALUES
SR2 RAIS
SR3 HISTORY SALARY VALUES
SR4 DIRF ITEMS / INCOME REPORT
SR5 PARAMETER CONFIGURATION
SR6 WORK SHIFTS
SR7 HISTORY SALARY CHANGES
SR8 Clearances
SR9 HISTORY OF EMPLOYEES
SRA EMPLOYEES
SRB DEPENDENTS
SRC MONTHLY MOVEMENT
SRD YEAR YEAR
SRE TRANSFERS
SRF PROVISIONS
SRG TERMINATION HEADER
SRH HOLIDAY RECEIPT HEAD
SRI 2A. 13 SHARE. SALARY
SRJ FUNCTIONS
SRK FUTURE VALUES
SRL HEAD DIRF / INCOME REPORT.
SRM CALCULATION ROUTES
SRN MEANS OF TRANSPORT
SRO TASKS
SRP MEDIA STATEMENT
SRQ BENEFICIARIES
SRR HOLIDAY ITEMS AND TERMINATIONS
SRS FGTS BALANCES
SRT ACCUMULATED PROVISIONS
SRU MANAGEMENT RESEARCH
SRV VERBS
SRW USER PROCESS CONTROL
SRX PARAMETERS
SRZ SHEET SUMMARY
ST0 SPECIALTIES
ST1 EMPLOYEES
ST2 EMPLOYEE SPECIALTIES
PREVENTIVE
ST3 RESOURCE LOCK
ST4 MAINTENANCE SERVICES
ST5 MAINTENANCE TASKS
ST6 FAMILY OF GOODS
ST7 GOOD MANUFACTURER
ST8 OCCURRENCES
ST9 WELL
STA SERVICE ORDER PROBLEMS
ETC. DETAILS OF GOOD
STC Asset
STD MAINTENANCE AREA
STE TYPE OF MAINTENANCE
STF PREVENTIVE
STG MAINTENANCE DETAILS
STH MAINTENANCE STEPS
STI MAINTENANCE PLAN
STJ MAINTENANCE SERVICE ORDERS
PCS EMPLOYEE LOCK
STL SERVICE ORDER DETAILS
STM MAINTENANCE DEPENDENCIES
STN RETURNS MAINTENANCE
STO MONITORING PLAN
STP FOLLOW-UP SERVICE ORDERS
STQ STEPS PERFORMED
STR WEAR BY PRODUCTION
STS MAINTENANCE HISTORY
STT MAINT DETAILS HISTORY
STU HISTORY OF OCCURRENCES
STV TROUBLESHOOTING
STW FOLLOW-UP HISTORY
STX HISTORY OF STEPS PERFORMED
STY RETURN HISTORY PRODUCTION
STZ PROPERTY MOVEMENT
TELEMARKETING
SU0 POST OF SALE
SU1 ACCESSORIES
SU2 COMPETITORS
SU3 PROMOTIONS
SU4 CONTACT LISTS
SU5 CONTACT US
SU6 CONTACT LIST ITEMS
SU7 OPERATORS
SU8 MARKETING HISTORY
SU9 Occurrence Register
USA CALL BUDGET
SUB TELEVENDMENT BUDGET ITEMS
JUICE TELEMARKETING HEADER
SOUTH TELEMARKETING ITEMS
ITS TMK CONFIGURATION HEAD
SUF TMK SETUP ITEMS
SUG ACCESSORIES HEAD
SUH MEDIA REGISTRATION
SUK EXECUTED CAMPAIGN ITEMS
SOUTH REGISTRATION OF COMMUNICAC TYPE.
POST REGISTRATION
SUN REGISTRATION OF TYPE OF CLOSE.
SUO CAMPAIGN REGISTRATION
SUP DYNAMIC SCRIPT ITEMS
SUQ SHARE REGISTRATION
ON OCCURRENCE X ACTION REGISTRATION
SUS PROSPECTS REGISTRATION
SUV IN / OUT CUSTOMER REGISTRATION
SUW DYNAMIC SCRIPT X CAMPAIGN
SUZ DYNAMIC SCRIPT REGISTRATION
VEHICLES
SV1 VEHICLE REGISTRATION
SV2 TRANSIT VEHICLES
SV3 STOCK VEHICLES
SV4 SALES SIMULATIONS
SV8 PRICE TABLE
SV9 TYPE OF
EXPORT
SW0 SI (COVER)
SW1 SI (ITEMS)
SW2 PO (COVER)
SW3 PO (ITEMS)
SW4 PLI (COVER)
SW5 PLI (ITEMS)
SW6 DI (COVER)
SW7 DI (ITEMS)
SW8 INVOICES
SW9 INVOICES (COVER)
SWA EXCHANGE (COVER)
SWB EXCHANGE (ITEMS)
SWC CREDIT LETTER
Swd DI EXPENDITURE
SWE SPECIAL GI (ITEMS)
SWF PRE-CALCULATION TABLE
SWG HEADER FINANCING
SWH PRE-CALCULATION EXPENDITURE (DET)
SWI PRE-CALCULATION TABLE
SWJ ITEM HISTORY
SWK GENERAL HISTORY
SWL FINANCING DETAIL
SWM ROF EL / C AGREEMENT
SWN NFE IMPORT ITEMS
SWO OCCURRENCES
SWP LI COVER
SWQ PLI RETURN
SWR PRICE QUOTATION
SWS QUOTATION ITEMS
SWT QUOTATION DETAIL
SWU REQUEST MODEL
SWV BATCH / PLI REGISTRATION
SWW NF EXPENSES
SWX CFO
SWZ OPERATION
SX5 TABLE REGISTRATION
SY0 PRINTED DOCUMENTS
SY1 BUYERS
SY2 DELIVERY PLACES
SY3 REQUESTING UNIT (C.COST)
SY4 SHIPMENT AGENTS
SY5 DISPATCHERS / COMPANIES
SY6 PAYMENT CONDITIONS
SY7 POSTS
SY8 IMPORT SCHEME
SY9 PORTS / AIRPORTS
SYA COUNTRIES
SYB EXPENDITURE REGISTRATION
SYC PRODUCT FAMILY
SYD NCM
SYE CONVERSION RATES
SYF COINS
SYG MINISTRY REGISTRATION
SYH CREDIT LETTERS (DETAIL)
SYI ADDITIVES
SYJ INCOTERMS
SYK INSURANCE REGISTRATION
SYL REPORTING MODEL (COVER)
SYM REPORTING FIELDS
SYN REPORT DICTIONARY
SYO REPORT ORIGINS
SYP MEMO FIELD DESCRIPTIONS
SYQ TRANSPORT WAY
SYR FREIGHT CHARGES
SYS COST CENTER PERCENTAGE
SYT IMPORTERS / CONSIGNERS
SYU EASY-GIPLITE INTEGRATION TABLE
SYV ENGINEERING REGISTRATION (COVER)
SYW REAL ESTATE AGENCIES
SYX ENGINEERING REGISTRATION (ITEMS)
SYZ PRODUCT REGISTRATION FREE ZONE
SAQ FRAME REGISTRATION
SBP STRUCTURED CODE BASE
SBQ STRUCTURED CODE ITEMS
SBR PRODUCT BASIC DATA
SBS CHARACTERISTIC OPTIONS
SBT RESTRICTED FOR CODE FORMATION
SBU STRUCTURE COMPOSITION
SET BOX REGISTRATION
YOUR MULTIPLE NATURES BY TITLE
SEX FRAMEWORK COMMITTEES
SEY Receipt X Chargers
SEZ DISTRIB. OF NATURES IN DC
SFM THES SMART
SJE DOCS FOR ORDERING INSTRUCTION
SJF PACKING TYPES
SJG IMPORT SECTOR
SJH TAX REVENUE
SJI TYPE OF LEGAL ACT
SJJ ISSUER OF LEGAL ACT
SJK VALUATION ATTRIBUTES
SJL VALUATION SPECIFICATIONS
SJM VALUATION METHODS
SJN ACCREMENT TABLE
SJO DECREASE TABLE
SJP TABLE OF TAX SCHEMES
SJR REASON FOR TEMPORARY ADMISSION
SJT RECIPIENT TYPE
SJU INTEREST RATES - BACEN
SLO LAY-AWAY REGISTRATION
SLP LAY-AWAY MOORINGS
SLQ BUDGET
SLR BUDGET ITEMS
CNS BALANCE ON ACCOUNT AND COST
SNG REGISTRATION OF GOODS GROUPS
SPO POINTING PERIODS
SPP MESSAGE REGISTRATION ACCESS
SPQ OCCURRENCE REGISTRATION ACCESS
SPR OCCURRENCE ITEMS ACCESS
SPS PROGRAMMING OCCURS ACCESS
SRY CALCULATION HEADER
CONFIGURATION
SX1 Perguntas
SX2 FILE DICTIONARIES
SX3 FIELD DICTIONARY
SX4 AGENDA
SX5 TABLES
SX6 PARAMETERS
SX7 TRIPS
SX8 SEQ DOCUMENTATION
SIX Indices
SXE SEQ NUMBERING
SXF SEQ NUMBERING

To the next.