Index

01. OVERVIEW

The Tax Credit Control routine (FISA034) is available.
This process aims to enable the Effective Control of the entries and uses of Credits by the user and the completion of the Tax SPED file that requires such information for certain Units of the Federation.

02. DEPLOYMENT PROCEDURE

Field	CE5_CODIGO
Type	Character
Size	6
Format	@E 999999
Title	Code
Description	Code
Level	1
Used	Yes
Required	Yes
Browser	Yes
Relation	GetSXENum("CE5","CE5_CODIGO")
Help	Reference code for Tracking

Field	CE5_DATA
Type	Date
Size	8
Title	Date
Description	Date of Inclusion
Level	1
Used	Yes
Required	Yes
Browser	Yes
Help	Date of inclusion

Field	CE5_CODLAN
Type	Character
Size	22
Title	Adjustment Code
Description	Adjustment Code
Level	1
Used	Yes
Required	Yes
Browser	Yes
Standard Query	CDO
System Val.	ExistCpo('CDO')
Help	Adjustment Code referring to Credit Receiving

Field	CE5_CODUTI
Type	Character
Size	4
Title	Usage Code
Description	Usage Code
Level	1
Used	Yes
Required	No
Browse	Yes
Standard Query	CE7
Help	Adjustment Code referring to the Type of Credit Usage

Field	CE5_CODCDH
Type	Character
Size	22
Title	Calc. Adj. Code
Description	Calculation Adjustment Code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Adjustment Code of Calculation referring to Credit Usage

Field	CE5_TPMOV
Type	Character
Size	1
Title	Transaction Type
Description	Type of Transaction
Level	1
Used	Yes
Required	Yes
Browser	Yes
Options	R=Credit Receiving; U=Credit Usage
Val. System	Belong (" RU")
Help	Type of Transaction

Field	CE5_VALOR
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Credit Value
Description	Credit Value
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Operation Value

Field	CE5_TRANSF
Type	Character
Size	1
Title	Transf.
Description	Transfer
Level	1
Used	Yes
Required	No
Browse	Yes
Options	1=Yes, 2=No
Val. System	Belong ("12")
Help	Indicate if the Operation is a credit transfer

Field	CE5_NUMDOC
Type	Character
Size	9
Title	Doc No.
Description	Document Number
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Indicate the number of the document used in the credit transfer

Field	CE5_SERIE
Type	Character
Size	3
Format	@!
Title	Series
Description	Document Series
Level	1
Used	Yes
Required	No
Browse	Yes
Help	When the operation involves a credit transfer, indicate the document series

Field	CE5_CLIFOR
Type	Character
Size	6
Format	@!
Title	Supp.Cust
Description	Customer or supplier code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	When the operation involves a credit transfer, enter the customer or supplier of the document used

Field	CE5_LOJACF
Type	Character
Size	2
Format	@!
Title	Store
Description	Supplier or customer store
Level	1
Used	Yes
Required	No
Browse	Yes
Help	When the operation involves a credit transfer, enter the customer or supplier's store

Field	CE5_PERIOD
Type	Character
Size	6
Format	@!
Title	Period
Description	Period
Level	1
Used	No
Required	No
Browse	Yes
Help	Operation Period

Field	CE6_PERIOD
Type	Character
Size	6
Format	@!
Title	Period
Description	Period
Level	1
Used	Yes
Required	Yes
Browser	Yes
Help	Operation Period

Field	CE6_CODLAN
Type	Character
Size	22
Title	Adjustment Code
Description	Adjustment Code
Level	1
Used	Yes
Required	Yes
Browser	Yes
Help	Adjustment Code of Credits

Field	CE6_TOTCRE
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Tot. Credit
Description	Total Credit
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Total Credit Received in the Period

Field	CE6_TOTUTI
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Tot. Usage
Description	Total Credit Used
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Total Credit Used in the Period

Field	CE6_SALDO
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Balance
Description	Balance
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Period Balance

Field	CE6_TOTTRA
Type	Numeric
Size	14
Decimal	2
Format	@E 99,999,999,999.99
Title	Tot. Transf.
Description	Total Transferred Credit
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Total Credit by transfer

Field	CE7_CODUTI
Type	Character
Size	4
Title	Usage Code
Description	Usage Code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Credit Usage Code

Field	CE7_DESCR
Type	Character
Size	50
Format	@!
Title	Usage Code Desc.
Description	Description of Usage Code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Description of Adjustment Code

Field	CE7_DESCR2
Type	Character
Size	6
Format	@!
Title	Descr2
Description	Descr2
Level	1
Used	No
Required	Yes
Browser	No

Field	CE7_VERSAO
Type	Character
Size	5
Format	@!
Title	Version
Description	Version
Level	1
Used	No
Required	No
Browse	No
Help	Version

Field	CDO_CODUTI
Type	Character
Size	4
Title	Usage Code
Description	Usage Code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Adjustment Code referring to the Type of Credit Usage. Field used to the Credit Control routine when generating Tax SPED in records 1200 and 1210.

Field	CDO_CODCRE
Type	Character
Size	22
Title	Cred. Adj. Code
Description	Credit Adjustment Code
Level	1
Used	Yes
Required	No
Browse	Yes
Help	Adjustment Code referring to Credit Receiving. Field used to the Credit Control routine when generating Tax SPED in records 1200 and 1210.

The size of fields that have groups may vary according to the environment in use.

Alias	CE7
Sequence	01
Column	DB
Description	Usage Codes
Contains	CE7

Index	CE5
Order	2
Key	CE5_FILIAL+CE5_CODLAN+CE5_PERIOD
Description	CodLan+Period.

Index	CE5
Order	3
Key	CE5_FILIAL+CE5_CODCDH+CE5_PERIOD
Description	CalcCode+Period.

Index	CE6
Order	1
Key	CE6_FILIAL+CE6_CODLAN+CE6_PERIOD
Description	CodLan+Period

Index	CE7
Order	1
Key	CE7_FILIAL+CE7_CODUTI
Description	Branch+Usage Code

03. USAGE PROCEDURE

In the Tax Records Module (SIGAFIS), access Updates/Sped/Credit Control (FISA034).

The system displays a window with records from table CE5 – Tax Credit Control.

To add manually, select the option in the Menu and add the record by entering the necessary data:
The fields CE5_CODLAN, CE5_DATA, and CE5_VALOR are mandatory, as they are used to generate records from Table CE6 - Tax Credits Balance.
To add the Credit Usage records, you can use the automatic routine through ICMS Calculation (MATA953). For example, using a deduction row, you can use this functionality:

Example:
When adding a row 012.01 - Deduction with Adjustment Code GO040022, table CE5 - Tax Credit Control automatically generates a record with the following references (Relationship made from the tables in the Manual SPED EFD according to State guidance):

The Adjustment Code GO040022 is filled out in the field CE5_CODCDH. The System automatically converts the Usage Type codes, GO09 here (value of field CE5_CODUTI) and Adjustment Code of reference, that is, GO020047 (value of field CE5_CODLAN).

The relationship between the Manual Posting codes and Usage Type codes is done using table CDO - Manual Calculation Adjustments, with the creation of the fields CDO_CODUTI and CDO_CODCRE. After the Adjustment Codes import, edit the record that is used in the Credit Control and fill out the fields with related information (available in the State EFD available).

3. The balance is generated from the records included in the Credit Control.

4. To complete the process, you must generate the Tax SPED magnetic file and confirm the processed data.

This routine is only active for querying the last 5 years. It does not allow inclusions. This tracking is currently made using the Extra Credit Calculation routine available at the ICMS calculation routine (MATA953). For more information on this feature, access Extra Calculation Credit

04. TABLES

CE5 – Tax Credit Control
CE6 – Tax Credit Balance
CE7 – Credit Usage Types
CDH – ICMS Calculation
CDO - Manual Calculation Adjustments