CADSPED - Registration of Statement Value Codes - Table 5.2

01. OVERVIEW

Routine of registration of Code of Statement Values in Table 5.2 of the Federal Revenue provided by the Revenue Service.

02. EXAMPLE OF USE

In the Configuration Tool (SIGACFG), access Environment/Files/Menus and add, to the menu of module Tax Records (SIGAFIS), as specified below:

Menu Name	Submenu	Routine Name	Program	Tables
Updates	SPED	Statement Value Codes	FISA156	CDY

SIX - Updates of the compatibility tool indexes

TABLE CDY– ADDIT. CALC. INFO CODE

Index	CDY
Order	1
Key	CDY_FILIAL + CDY_CODAJU + DTOS(CDY_DTINI)
Description	Branch+Adjustment Code+Start Date
Display Search	Yes

SX3 – Fields

Field	CDY_FILIAL
Type	Character
Size	2
Decimal	0
Title	Branch
Description	System Branch
Used	No
Mandatory	No
Browser	No
Context	Real
Field Group	033 - Branch Size
Order	01

Field	CDY_CODAJU
Type	Character
Size	8
Decimal	0
Format	@!
Title	Adjustment Code
Description	Adjustment Code
Used	Yes
Mandatory	Yes
Browser	Yes
Order	02

Field	CDY_DESCR
Type	Character
Size	254
Decimal	0
Format	@!
Title	Complem. Desc.
Description	Compl. Desc.of Adjustment
Used	Yes
Mandatory	No
Browser	Yes
Order	03

Field	CDY_VERSAO
Type	Character
Size	5
Decimal	0
Format	@!
Title	Version
Description	Version
Used	Yes
Mandatory	Yes
Browser	Yes
Context	Real
Ownership	View
Order	04

Field	CDY_DTINI
Type	Date
Size	8
Decimal	0
Title	Start Date
Description	Start Date
Used	Yes
Mandatory	No
Browser	Yes
Context	Real
Ownership	Edit
Order	05

Field	CDY_DTFIM
Type	Date
Size	8
Decimal	0
Title	End Date
Description	End Date
Used	Yes
Mandatory	No
Browser	Yes
Context	Real
Ownership	Edit
Order	06

Field	CDY_NFE
Type	Character
Size	1
Decimal	0
Format	@!
Title	Generate Invoice:
Description	Consider code for e-Invoice
Used	Yes
Mandatory	No
Browser	Yes
Options	1=YES, 2=No
Val. System	pertence(" 12")
Context	Real
Ownership	Edit
Order	07

Field	CDY_ZERAVL
Type	Character
Size	1
Decimal	0
Format	@!
Title	Zero value?
Description	Zero value?
Used	Yes
Mandatory	No
Browser	No
Options	1=YES, 2=No
Val. System	pertence(" 12")
Context	Real
Ownership	Edit
Order	08

SXB - Standard Query

Query: CDY - Addit. Calc. Info

Alias	CDY
Type	1 - Query
Sequence	01
Column	DB
Description	Additional Calculation Info
Contains	CDY

Alias	CDY
Type	2 - Orders
Sequence	01
Column	01
Description	CODE

Alias	CDY
Type	3 - Reg. New
Sequence	01
Column	01
Description	Register New
Contains	01

Alias	CDY
Type	4 - Columns
Sequence	01
Column	01
Description	CODE
Contains	CDY_CODAJU

Alias	CDY
Type	4 - Columns
Sequence	01
Column	02
Description	DESCRIPTION
Contains	CDY_DESCR

Alias	CDY
Type	5 - Return
Sequence	01
Contains	CDY->CDY_CODAJU

03. SETUP PROCEDURE

The codes which refer to additional calculation information - Statement Values are automatically imported from the CDY - Additional Calculation Information Code table when the IMPSPED routine is executed.

When running the U_IMPSPED compatibility tool as the initial program, you will need to enter the directory containing the files with code from Table 5.2 made available by the state (in .*txt format) so that the system can import them automatically.

Therefore, first download these files from the SPED website and copy them to a folder on the server.

Note that some states have not published the tables yet. Thus, for these states, you must wait for the release and process IMPSPED again to perform the import.

To check the full list of releases and the states that have already published the codes, go to the Code Tables section on the SPED website.

CDY – published on the SPED website as Statement Values.

Important

For correct import in the CDY table, you must rename the downloaded TXT file from the SPED website for table 5.2 to TABELA52.txt

After importing these codes, to correctly generate the record, you should declare the amounts using the Additional Calculation Information routine.

Add them to the menu and register the amounts to be sent to Block E - ICMS and IPI Tax Calculation Records, in Record type E115 - Additional Calculation Information - Statement Values.

This record is generated for Additional ICMS Calculation Information linked to the Additional Calculation Information routine.

In the Additional Calculation Information routine, you must manually enter the additional calculation data, and you are required to add the period to which such additional information refers and its respective adjustment code. After you add the adjustment code, the system releases the adjustment description trigger.

Record E115 deals with statement values related to the ICMS according to the definition of the relevant state legislation.

These values are merely declaratory and are not computed in the calculation of the ICMS.

Therefore, they should be informed in the system using the Addit. Calc. Info routine (MATA017).

After the calculation of ICMS (MATA953), in the Additional Calculation Information (MATA017) routine, add the information according to state legislation, respecting the calculation codes provided by SEFAZ, by state, using table 5.2 - Additional Calculation Information.

04. ADDITIONAL INFORMATION

Code Table: {+}http://www.sped.fazenda.gov.br/spedtabelas/AppConsulta/publico/aspx/ConsultaTabelasExternas.aspx?CodSistema=SpedFiscal+

Páginas filhas

CONTENTS