CADSPED - Registration of Statement Value Codes - Table 5.2

CONTENTS

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:
 

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

• Tax SPED: FIS0005_SPED_FISCAL

        MATA017 - Additional Sub-calculation Information – Statement Values: FIS0087_Additional ICMS calculation information (E115 and 1925)

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