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.
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 |
In the Tax Records Module (SIGAFIS), access Updates/Sped/IPM Table (FISA094). Proceed as follows:
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
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.
|
| 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. |
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 |
Key | Name | Mode | Pyme |
|---|---|---|---|
CLN | City participation index | Shared | Yes |
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 |
Variable Name | MV_UFIPM |
|---|---|
Type | Character |
Description | Defines which States are able to generate the 1400 file of the Tax SPED |
Default Value | blank |
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) |
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') |
