CADSPED - IPM (City Participation Index) Table Import

01. OVERVIEW

Implemented the IPM Table Import routine (FISA094)provided by SEFAZ that contains the codes for field 02 (COD_ITEM_IPM) of the EFD ICMS/IPI File 1400 (AGGREGATED VALUE INFORMATION).
In addition to importing, you can delete, query, and print this information.

02. MENU SETTINGS

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

Menu	Updates
Submenu	SPED
Routine Name	IPM Table
Program	FISA094
Module	09
Type	01
Tables	CLN

03. USAGE PROCEDURE

In the Tax Records Module (SIGAFIS), access Updates/Sped/IPM Table (FISA094). Proceed as follows:

Select Import.
Enter the State (UF), folder, and file (TXT) provided by the Federal Revenue Service for importing.
The fields will be filled in according to the table provided.
Click Ok.

Later, the file can be edited to inform the type of periodicity of the code in the Type field (CLN_TIPO), with the options: 1=Monthly or 2=Yearly

Important

In order to comply with Resolution No. 4,746 of the state of Minas Gerais, the type of periodicity of the code (CLN_TIPO field) should be informed if it is annual or monthly, because the code "road transport service provision" must be generated in December containing the total value of the entire year for each city, including the host city.

If the field is not changed to 2 - Yearly, the system understands that the periodicity of the code is 1 - Monthly.

Important

The fields F4_IPMSP (Sao Paulo) andF4_IPMMG (Minas Gerais) are available to enter the IPM Table Code (FISA094), which will be written in the COD_ITEM_IPM field. If the IPM Table is not available for your State, the item code (FT_PRODUTO) will be stored as instructed in the Practical Guide Version 2.0.15.

04. DEPLOYMENT PROCEDURE

SIX – Compatibility Tool Update Indexes

CLN - City Participation Index

Index	CLN
Order	1
Key	CLN_FILIAL + CLN_UF + CLN_CODIPM + DTOS(CLN_DTINIV) + DTOS(CLN_DTFIMV)
Description	Branch+State+Code+Effective Start Date+Effective End Date
Display Search	Yes

SX2 – Tables

Key	Name	Mode	Pyme
CLN	City participation index	Shared	Yes

SX3 – Fields:

Field	CLN_FILIAL
Type	Character
Size	2
Decimal	0
Format	@!
Title	Branch
Description	System Branch
Used	No
Mandatory	No
Browse	No
Context	Real
Field Group	033 - Branch Size
Order	01

Field	CLN_UF
Type	Character
Size	2
Decimal	0
Format	@!
Title	State
Description	State Acronym
Used	Yes
Mandatory	Yes
Browser	Yes
Val. System	ExistCpo("SX5", "12" + M->CLN_UF)
Context	Real
Ownership	Edit
Default Query	12 ( Table )
Order	02

Field	CLN_CODIPM
Type	Character
Size	60
Decimal	0
Title	IPM Code
Description	IPM Code
Used	Yes
Mandatory	Yes
Browser	Yes
Context	Real
Ownership	Edit
Order	03

Field	CLN_DSCIPM
Type	Memo
Size	10
Decimal	0
Title	Description
Description	IPM Code Description
Used	Yes
Mandatory	No
Browser	No
Context	Real
Ownership	Edit
Order	04

Field	CLN_DTINIV
Type	Date
Size	8
Decimal	0
Title	Start Dt.
Description	Start of effective date
Used	Yes
Mandatory	Yes
Browser	Yes
Context	Real
Ownership	Edit
Order	05

Field	CLN_DTFIMV
Type	Date
Size	8
Decimal	0
Title	End Dt.
Description	End of effective date
Used	Yes
Mandatory	No
Browser	Yes
Context	Real
Ownership	Edit
Order	06

Field	CLN_TIPO
Type	Character
Size	1
Decimal	0
Format	@!
Title	Type
Description	Type
Used	Yes
Mandatory	No
Browser	Yes
Options	1=Monthly; 2=Yearly
Context	Real
Ownership	Edit
Order	07

SX6 – Parameters

Variable Name	MV_UFIPM
Type	Character
Description	Defines which States are able to generate the 1400 file of the Tax SPED
Default Value	blank

SXB - Standard Query

Query: CLN - City Partic. Ind.
Alias
CLN
Type
1 - Query
Sequence
01
Column
DB
Description
City Partic. Ind.
Contains
CLN

Alias
CLN
Type
2 - Orders
Sequence
01
Column
01
Description
Branch+state+code

Alias
CLN
Type
2 - Orders
Sequence
02
Column
02
Description
State

Alias
CLN
Type
4 - Columns
Sequence
01
Column
01
Description
State
Contains
CLN_UF

Alias
CLN
Type
4 - Columns
Sequence
01
Column
02
Description
IPM Code
Contains
CLN_CODIPM

Alias
CLN
Type
4 - Columns
Sequence
01
Column
03
Description
Start Dt.
Contains
CLN_DTINIV

Alias
CLN
Type
4 - Columns
Sequence
02
Column
01
Description
End Dt.
Contains
CLN_DTFIMV

Alias
CLN
Type
5 - Return
Sequence
01
Contains
CLN->CLN_CODIPM

Alias
CLN
Type
6 - Filter
Sequence
01
Contains
Vazio(CLN->CLN_DTFIMV)
Query: CLN2 - City Partic. Ind.

Alias	CLN2
Type	1 - Query
Sequence	01
Column	DB
Description	City Partic. Ind.
Contains	CLN

Alias	CLN2
Type	2 - Orders
Sequence	01
Column	01
Description	Branch+state+code

Alias	CLN2
Type	2 - Orders
Sequence	02
Column	02
Description	State

Alias	CLN2
Type	4 - Columns
Sequence	01
Column	01
Description	State
Contains	CLN_UF

Alias	CLN2
Type	4 - Columns
Sequence	01
Column	02
Description	IPM Code
Contains	CLN_CODIPM

Alias	CLN2
Type	4 - Columns
Sequence	01
Column	03
Description	Start Dt.
Contains	CLN_DTINIV

Alias	CLN2
Type	4 - Columns
Sequence	02
Column	01
Description	End Dt.
Contains	CLN_DTFIMV

Alias	CLN2
Type	5 - Return
Sequence	01
Contains	CLN->CLN_CODIPM

Alias	CLN2
Type	6 - Filter
Sequence	01
Contains	CLN->CLN_UF == GDFieldGet('F09_UF')

05. TABLES

CLN – IPM Table

06. ADDITIONAL INFORMATION

Páginas filhas

CONTENTS