CONTENTS
01. OVERVIEW
The registration routine Products x Declaration Value Codes aims to register taxation rules that vary depending on the product, CFOP, and Declaration Value Codes, according to table 5.2 - Table of Additional Calculation Information - Declaration Values, of the Public Tax Bookkeeping System - EFD ICMS/IPI.
These rules will be used in the calculation of ICMS in the recording of the CDV table, so that it is possible to generate the EFD ICMS/IPI record E115 correctly, and, with this, the possibility of importing the file generated for the Normative Instruction GIA-RS - version 8.5
02. EXAMPLE OF USE
SIX - indexes Updates of the compatibilizer
- Table F3K – Items x Declaration Value Codes
Index | F3K |
---|
Order | 1 |
Key | F3K_FILIAL + F3K_PROD + F3K_CFOP + F3K_CODAJU + F3K_CST + F3K_GRCLAN + F3K_GRPLAN + F3K_GRFLAN |
Description | Branch + Product + CFOP + Decl.Val.Code + CST + Customers Grp. + Product Grp. + Supplier Grp. |
Display Search | Yes |
Index | F3K |
---|
Order | 2 |
Key | F3K_FILIAL + F3K_PROD + F3K_CFOP + F3K_CST |
Description | Branch+Product+CFOP+CST |
Display Search | Yes |
SX1 – Questions File:
Question | From NCM: |
---|
Routine | FISA140 |
Type | Character |
Question | To NCM: |
---|
Routine | FISA140 |
Type | Character |
Question | From Product: |
---|
Routine | FISA140 |
Type | Character |
Question | To Product: |
---|
Routine | FISA140 |
Type | Character |
Question | Action ? |
---|
Routine | FISA140 |
Type | Character |
Question | Product Source? |
---|
Routine | FISA140 |
Type | Character |
Question | From Group: |
---|
Routine | FISA140 |
Type | Character |
Question | From Group: |
---|
Routine | FISA140 |
Type | Character |
SX2 – Tables
Key | Name | Mode | Pyme | Key |
---|
F3K | Items x Decl. Val.Codes | Exclusive | Yes | F3K_FILIAL+F3K_PROD+F3K_CFOP+F3K_CODAJU+F3K_CST+F3K_GRCLAN+F3K_GRPLAN+F3K_GRFLAN |
SX3 – Fields:
Field | F3K_FILIAL |
---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | System Branch |
Used | No |
Mandatory | No |
Browse | Yes |
Context | Real |
Ownership | Edit |
Fields Group | 033 - Branch Size |
Order | 01 |
Field | F3K_PROD |
---|
Type | Character |
Size | 15 |
Decimal | 0 |
Format | @! |
Title | Product |
Description | Product |
Used | Yes |
Mandatory | Yes |
Browse | Yes |
System Val. | ExistCpo('SB1') |
Context | Real |
Ownership | Edit |
Stand. Query | SB1 |
Fields Group | 030 - Product Size |
Order | 02 |
Field | F3K_CFOP |
---|
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | CFOP |
Description | CFOP |
Used | Yes |
Mandatory | Yes |
Browse | Yes |
System Val. | ExistCpo('SX5', '13' + M->F3K_CFOP) |
Context | Real |
Ownership | Edit |
Stand. Query | 13 |
Order | 03 |
Field | F3K_CODAJU |
---|
Type | Character |
Size | 8 |
Decimal | 0 |
Format | @! |
Title | Decl. Val. Code |
Description | Decl. Val. Code |
Used | Yes |
Mandatory | Yes |
Browse | Yes |
Val. System | ExistCpo('CDY') |
Context | Real |
Ownership | Edit |
Stand. Query | CDY |
Order | 04 |
Field | F3K_VALOR |
---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Amount |
Description | Value |
Used | Yes |
Mandatory | Yes |
Browse | Yes |
Options | 1=ICMS ST;2=IPI;3=Freight;4=Deferred Value;5=Exempt/Other Reduc. Base 7=Expenses;9=Accounting Value |
Context | Real |
Ownership | Edit |
Order | 05 |
Help | Specify the value as per V.C. Attachment GIA/RS. Options: 1=ICMS ST;2=IPI;3=Freight;4=Deferred Value;5=ICMS Exempted/Others Reduced Base ;7=Expenses;9=Accounting Value. |
Field | F3K_CST |
---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | CST |
Description | CST |
Used | Yes |
Mandatory | No |
Browse | Yes |
System Val. | ExistCpo('SX5', 'S2' + M->F3K_CST) |
Context | Real |
Ownership | Edit |
Stand. Query | S2 |
Order | 06 |
Field | F3K_CODREF |
---|
Type | Character |
Size | 7 |
Decimal | 0 |
Format | @! |
Title | Reflex Code |
Description | Reflex Code |
Used | Yes |
Mandatory | No |
Browse | Yes |
System Val. | ExistCpo('CE0') |
Context | Real |
Ownership | Edit |
Stand. Query | CE0 |
Order | 07 |
Field | F3K_GRCLAN |
---|
Type | Character |
Size | 3 |
Decimal | 0 |
Format | @! |
Title | Customer Grp. |
Description | Customers Group |
Used | Yes |
Mandatory | No |
Browse | Yes |
System Val. |
|
Context | Real |
Ownership | Edit |
Stand. Query |
|
Order | 08 |
Field | F3K_GRPLAN |
---|
Type | Character |
Size | 4 |
Decimal | 0 |
Format | @! |
Title | Product Grp. |
Description | Product Group |
Used | Yes |
Mandatory | No |
Browse | Yes |
System Val. | Vazio() .Or. ExistCpo("SX5","21"+M->F3K_GRPLAN) |
Context | Real |
Ownership | Edit |
Stand. Query | 21 |
Order | 09 |
Field | F3K_GRFLAN |
---|
Type | Character |
Size | 3 |
Decimal | 0 |
Format | @! |
Title | Supplier Grp. |
Description | Suppliers Group |
Used | Yes |
Mandatory | No |
Browse | Yes |
System Val. |
|
Context | Real |
Ownership | Edit |
Stand. Query |
|
Order | 10 |
Field | F3K_IFCOMP |
---|
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @! |
Title | Tax Ent. Note |
Description | Note Tax Entry |
Used | Yes |
Mandatory | No |
Browse | No |
System Val. | Vazio().Or.ExistCpo('CCE') |
Context | Real |
Ownership | Edit |
Stand. Query | CCE |
Order | 11 |
Field | F3K_CODLAN |
---|
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Entry Code |
Description | Entry Code |
Used | Yes |
Mandatory | No |
Browse | No |
System Val. | Vazio() .Or. EXISTCPO("CC6") |
Context | Real |
Ownership | Edit |
Stand. Query | CC6 |
Order | 12 |
SX6 - Parameters:
Items/Folders | Description |
---|
Name | MV_GIAEFD |
Type | Logical |
Description | Indicate whether the Additional Calculation Information - Declaration Values will be calculated through the calculation of ICMS. |
Default Value | .F. |
Items/Folders | Description |
---|
Name | MV_MTCLF3K |
Type | Character |
Description | Method for framing the declaration value F3K. 0 - Framing by product; 1 - Framing by group: customer, product, and supplier. |
Default Value | 0 |
03.USAGE PROCEDURE BY CALCULATION
Details of the available fields on the registration screen:
- Product. (F3K_PROD): Enter the code of the operation product;
- CFOP. (F3K_CFOP): Operation CFOP;
- Decl. Val.Code (F3K_CODAJU): Code of declaration value associated with the operation.
- Value(F3K_VALOR): Value as per Annex I and Annex V of GIA/RS.
- CST(F3K_CST): ICMS CST associated with the operation.
In the ICMS calculation, a query will be performed in the Items x Declaration Value Codes table (F3K) considering the product and the CFOP to identify the associated entry code, allowing the values to be calculated automatically(CDV table - Additional Calculation Information).
- Addition: Allows you to include multiple CFOPs and codes per product;
- Edit: Allows you to edit all CFOP rows and delete any of the existing rows.
- Delete: Delete the selected product and all rows registered in this code.
04.USAGE PROCEDURE BY INVOICE
Details of the available fields on the registration screen:
- Product. (F3K_PROD): Enter the code of the operation product;
- Customer Group (F3K_GRCLAN): Enter the code of the customer's taxation group (A1_GRPTRIB);
- Product Group (F3K_GRPLAN): Enter the code of the product's taxation group (B1_GRTRIB);
- Suppliers Group (F3K_GRFLAN): Enter the code of the supplier's taxation group (A2_GRPTRIB);
- CFOP. (F3K_CFOP): Operation CFOP;
- Decl. Val.Code (F3K_CODAJU): Code of declaration value associated with the operation;
- CST(F3K_CST): ICMS CST associated with the operation;
- Reflex Code (F3K_CODREF): Code of the reflex record containing the calculation rule for the declaration code;
- Tax Entry Note (F3K_IFCOMP): Code of Entry Note (used to generate the C195 record of the Tax SPED);
- Entry Code (F3K_CODLAN): Tax Document Entry Code (see table CC6).
When the invoice is added, it will be verified if a calculation rule is registered in the Items x Declaration Value Codes table (F3K) to automatically process and generate the CDV table - Additional Calculation Information, and the CDA - Tax Document Entries.
If the configuration by customer group is used (A1_GRPTRIB), the system will search, at the time of calculation, if the invoice customer is framed in the field group (F3K_GRCLAN).
If the configuration by product group (B1_GRTRIB) is used, the system will search, at the time of calculation, if the invoice product is framed in the field group (F3K_GRPLAN).
If the supplier group configuration (A2_GRPTRIB) is used, the system will search, at the time of calculation, if the invoice supplier is framed in the field group (F3K_GRFLAN).
05.PROCEDURE FOR USING THE CALCULATION ENTRY
- In routine FISA140, the fields F3K_IFCOMP and F3K_CODLAN were added to generate the calculation entries in the CDA table when issuing a Tax Document, centralizing the operations in a single file.
When filling in the F3K_CODLAN field, they will be written in the Tax Document Entries (CDA) table and can be viewed in the ICMS Accounting Entries Tab, and the code of table 5.2 corresponding to the entry code of table 5.3 is also bound. When using this configuration, it will not be necessary to bind TIO X Calculation Entries in the routine Types of Inflow and Outflow (MATA080).
This allows the link between an Entry Code (F3K_CODLAN) and several Declaration Value Codes (F3K_CODAJU).
This setting is made for records C197 and E111 to display adjustment code information in the supplementary description field of the document adjustment, as shown below:
Record C197
- Field 03: Fill with the code of Table 5.2 corresponding to the standard used and kind, indicated in field 02 of record E115;

Record E111
- Field 03: Fill with the code in Table 5.2 corresponding to the standard used, indicated in field 02 of record E115;

When filling in the F3K_IFCOMP field, the C195 record of the Tax SPED is generated.
06. FACILITATOR
In order to expedite the registration in the Items x Declaration Value Codes (F3K) routine, a facilitator was developed and is available in the " Related Actions" option of this routine. This facilitator will perform the processing, considering the filter and the values entered by the user through the questions in this routine. Below are details of completing these questions:
From NCM: Enter the initial NCM that you wish to process;
To NCM: Enter the final NCM that you wish to process;
From Product: Enter the initial product code to be considered when processing;
To Product: Enter the final product code to be considered when processing;
Action ?: Through this question, it will be indicated whether the facilitator's processing will edit, add, or delete a record if it already exists. Enter the available options:
Edit: Will edit the record;
Add: Will add records using the filter made by the facilitator.
Delete: Will Delete records using the filter made in the facilitator.
Product Source?: This question will validate which product source should be processed.
From Group: Enter the code of the initial product group that should be considered in the processing;
To Group: Enter the code of the final product group that should be considered in the processing;
After confirming these questions, a screen with the following fields will appear:
- CFOP: In this field, the code of the operation is recorded in the Items x Declaration Value Codes table (F3K) for NCM and Product entered in the previous questions.
- Decl.Val.Code: In this field, enter the declaratory value code to be entered in the Items x Declaration Value Codes table (F3K) for the NCM and Product entered in the previous questions.
- CST: In this field, enter the CST to be recorded in the Items x Declaration Value Codes (F3K) table for the NCM and Product entered in the previous questions.
- When MV_GIAEFD is Enabled (.T.), the Value field will be displayed
- Value: In this field, enter the CST to be recorded in the Items x Declaration Value Codes (F3K) table for the NCM and Product entered in the previous questions.
- When MV_GIAEFD is disabled (.F.) the reflex field will be displayed
- Reflex Code: Enter the code of the reflex record containing the calculation rule for the declaration code.
You can enter more than one CFOP for the same product code, or the same CFOP as long as the Declaration Value Codes are different.
Facilitator Processing Example: