...
Índice
The State x State registration routine aims to make registrations of tax rules that vary depending on the Source and Target States. These rules will be used in the calculation and bookkeeping of tax documents.
If the State x State (FISA080) file is not available, follow the guidance below.
In the Configurator (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 Name | Submenu | Routine Name | Program | Tables |
---|---|---|---|---|
Updates | Files | State x State | FISA080 | CFC |
In the Configurator (SIGACFG), access Database/Dictionary/Database and add or check the following fields:
CFC Table - State x State
Key | Name | Mode | PYME |
---|---|---|---|
CFC | State x State | E | S |
Field | CFC_PAUTFB |
---|---|
Title | FOB Base Value |
Used | No |
Mandatory | No |
Type | Numeric |
Help | Indicates whether there will be FOB freight calculation. |
Description | Calculate FOB Freight |
Format | @E 999,999.99 |
Size | 9 |
Decimal | 2 |
Level | 1 |
Field | CFC_FILIAL |
---|---|
Type | Character |
Size | <defined by customer> |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Current Branch |
Level | 1 |
Used | No |
Mandatory | No |
Help | Enter the branch that will use the file. |
Field | CFC_UF |
---|---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | State |
Description | Federative Unit |
Mandatory | No |
Help | Enter the State that will use the file. |
Field | CFC_UFORIG |
---|---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Source State |
Description | Source State |
Used | Yes |
Mandatory | Yes |
Help | Enter the State that is the source of the operation. This field, next to the CFC_UFDEST field, defines the origin and destination of the operation to fill in the fields and rules of that relationship. |
Field | CFC_UFDEST |
---|---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Target State |
Description | Target State |
Level | 1 |
Used | Yes |
Mandatory | Yes |
Help | Enter the target State of the operation. This field, next to the CFC_UFORIG field, defines the origin and destination of the operation to fill in the fields and rules of that relationship. |
Field | CFC_CODPRD |
---|---|
Type | Character |
Size | Size defined through the field group of the product code. |
Format | @! |
Title | Prod. Code |
Description | Product Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | When a product has a different rule than the one registered using only source and target States, fill this field with the product code that has the specific rules. |
Field | CFC_ALQFCP |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | FECP rate |
Description | FECP tax rate |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | Fill in the percentage of the Poverty Reduction Fund in relation to the target State. |
Field | CFC_IDHIST |
---|---|
Type | Character |
Size | 20 |
Decimal | 0 |
Format | @! |
Title | Hist. Id |
Description | History ID |
Level | 1 |
Used | No |
Mandatory | No |
Field | CFC_DESCR1 |
---|---|
Type | Character |
Size | 30 |
Decimal | 0 |
Format | @! |
Title | Prod. Desc. |
Description | Product Description |
Level | 1 |
Used | No |
Mandatory | No |
Help | Product description field. |
Field | CFC_MGLQST |
---|---|
Type | Numeric |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | State Net Marg. |
Description | State's Net Margin |
Level | 1 |
Used | No |
Mandatory | No |
Help | Fill in the margin for net ICMS ST calculation. |
Field | CFC_ALQSTL |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | ST Net Rate |
Description | ST Net Rate |
Level | 1 |
Used | No |
Mandatory | No |
Help | Fill in the rate for calculation of the net ICMS ST. |
...
Field | CFC_MVAES |
---|---|
Decimal | 0 |
Description | MVA in Input or Output |
Format | @! |
Help | MVA used in inputs and outputs. |
Size | 1 |
Type | Character |
Title | Inp/Outp MVA |
Field | CFC_MARGEM |
---|---|
Type | Numeric |
Size | 5 |
Decimal | 2 |
Format | @E 99.99 |
Title | MVA |
Description | Added Value Margin |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | Enter the percentage of added value margin. |
Field | CFC_ALFCPO |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | Src.FCP.Rt. |
Description | Rate of Source State FECP |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | Enter the percentage of the Fund to Combat Poverty in relation to the source State. |
Field | CFC_FCPAUX |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | FCP.Aux Ind. |
Description | FECP Auxiliary Index |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | Enter the Auxiliary Index for calculation of ICMS Fecp and/or ICMS ST if necessary. Used in the calculation of some States according to legislation. |
Field | CFC_FCPINT |
---|---|
Decimal | 0 |
Description | Calc. Int/Imp Oper FECP |
Format | @! |
Help | Enter 1=Yes;2=No |
Size | 1 |
Type | Character |
Title | Int/Imp Op |
Field | CFC_FCPXDA |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
Title | Rt Diff Calc |
Description | Calculation of Fecp – Different. Rate |
Level | 1 |
Used | Yes |
Mandatory | No |
Help | Indicate if the FECP will be increased in the Rate of the ICMS differential rates. |
Field | CFC_NUMCON |
---|---|
Type | Character |
Size | 30 |
Decimal | 0 |
Format | @! |
Title | Agreement No |
Description | Number of the Agreement |
Help | Enter the agreement number |
Field | CFC_PRECST |
---|---|
Type | Character |
Size | 01 |
Decimal | 0 |
Format | @! |
Title | ST Inc. Tm |
Description | ST Inc. Term |
Level | 1 |
Used | Yes |
Mandatory | No |
Options | 1=No;2=Yes |
Val. System | Belong("12") |
Help | Indicate whether the product is part of Decree No. 59,967. |
...
Field | CFC_RDCTIM |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | % Tax Load |
Description | ICMS Tax Load % |
Level | 1 |
Help | Enter the ICMS Tax Load percentage for import. Decree no. 34560/2010 |
Field | CFC_ADICST |
---|---|
Type | Numeric |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | Add ST % |
Description | Add. ST % |
Level | 1 |
Help | Enter the additional percentage for sites opting for the Simples Nacional for net load ST. |
...
Field | CFC_VLICMP |
---|---|
Decimal | 2 |
Description | Loc. ICMS Base Value |
Format | @E 999,999.99 |
Help | Enter the local base value ICMS |
Size | 9 |
Type | Numeric |
Title | Base Value ICMS |
Field | CFC_VL_ICM |
---|---|
Type | Numeric |
Size | 9 |
Decimal | 2 |
Format | @E 999,999.99 |
Title | Settled ICMS |
Description | Value of ICMS base |
Help | Enter the base ICMS value. |
Field | CFC_PICM |
---|---|
Type | Numeric |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | Targ. ICM. Rate |
Description | Target ICMS Rate |
Level | 1 |
Help | Enter the rate of the target ICMS |
Field | CFC_ALFEEF |
---|---|
Type | Numeric |
Size | 5 |
Decimal | 2 |
Format | @E 99.99 |
Title | FEEF Rate |
Description | FEEF Rate |
Context | Real |
Ownership | Edit |
Level | 1 |
Help | Enter the FEEF rate. |
Field | CFC_BFCPST |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Bs.FCP ST |
Description | Base FCP-ST |
Used | Yes |
Mandatory | No |
Browse | Yes |
Options | #cBoxBsST() |
Help | FCP Calculation Base - ST |
Field | CFC_VL_ANT |
---|---|
Type | Numeric |
Size | 9 |
Decimal | 2 |
Format | @E 999,999.99 |
Title | Settled ICMS A. |
Description | Base of ICMS Anticipation |
Help | Base of ICMS Anticipation |
...
Field | CFC_BFCPCM |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | COMP FCP Bs. |
Description | basis of Complementary FCP |
Used | Yes |
Mandatory | No |
Browse | Yes |
Options | #cBoxBsCMP() |
Help | Complementary FCP Calculation Base |
Field | CFC_BFCPPR |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Loc. FCP Bs. |
Description | Base of local FCP |
Help | Enter the base of local FCP |
Field | CFC_AFCPST |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | FCP-ST Rt. |
Description | Rate of FCP-ST |
Used | Yes |
Mandatory | No |
Browse | Yes |
Options | 1=StxSt;2=Customer |
Help | Indicate the source of the FCP-ST rate. Options: |
Field | CFC_FCPBSR |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
Title | Red Bs FCP |
Description | FECP on Red. Base |
Context | Real |
Ownership | Edit |
Level | 1 |
Help | Enter whether to consider the value of the FECP on the reduced basis of the local ICMS or the full base |
Field | CFC_FCPAJT |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
Title | Adjust FCP |
Description | Fit FCP Val. in ICMS |
Context | Real |
Ownership | Edit |
Level | 1 |
Help | Determine whether, in XML, the value of the FCP will be deducted from the value and percentage of the ICMS |
Aviso | ||
---|---|---|
| ||
When reporting this field as 2= No, the values of the local ICMS did not follow the percentage entered because the value of the FECP will be added to the value of the ICMS. |
Table SS9 - State x State
Key | Name | Mode | PYME |
---|---|---|---|
SS9 | State x State | E | S |
Field | S9_FILIAL |
---|---|
Type | Character |
Size | <defined by customer> |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch |
Level | 1 |
Used | No |
Mandatory | No |
Field | S9_UFORIG |
---|---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Source State |
Description | Source State |
Used | Yes |
Mandatory | Yes |
Field | S9_UFDEST |
---|---|
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Target State |
Description | Target State |
Level | 1 |
Used | Yes |
Mandatory | Yes |
Field | S9_CODPRD |
---|---|
Type | Character |
Size | Size defined through the product code field group |
Format | @! |
Title | Prod. Code |
Description | Product Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_ALQFCP |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | FECP rate |
Description | FECP tax rate |
Level | 1 |
Used | Yes |
Mandatory | No |
...
Field | S9_MGLQST |
---|---|
Type | Numeric |
Size | 06 |
Decimal | 2 |
Format | @E 999.99 |
Title | State Net Marg. |
Description | State's Net Margin |
Level | 1 |
Used | No |
Mandatory | No |
Field | S9_ALQSTL |
---|---|
Type | Numeric |
Size | 06 |
Decimal | 2 |
Format | @E 99.9999 |
Title | ST Net Rate |
Description | ST Net Rate |
Level | 1 |
Used | No |
Mandatory | No |
...
Field | S9_MARGEM |
---|---|
Type | Numeric |
Size | 5 |
Decimal | 2 |
Format | @E 99.99 |
Title | MVA |
Description | Added Value Margin |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_ALFCPO |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 2 |
Format | @E 99.9999 |
Title | Src.FCP.Rt. |
Description | Rate of Source State FECP |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_FCPAUX |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 2 |
Format | @E 99.9999 |
Title | FCP.Aux Ind. |
Description | FECP Auxiliary Index |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_FCPXDA |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Rt Diff Calc |
Description | Calculation of Fecp – Different. |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_FCPINT |
---|---|
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Internal Oper. |
Description | Calculation of Fecp - Internal |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_PRECST |
---|---|
Type | Character |
Size | 01 |
Decimal | 0 |
Format | @! |
Title | ST Inc. Tm |
Description | Inc. Time ST |
Level | 1 |
Used | Yes |
Mandatory | No |
Field | S9_RDCTIM |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | % Tax Load |
Description | ICMS Tax Load % |
Level | 1 |
Help | Enter the percentage of the ICMS tax for import. |
Field | S9_ADICST |
---|---|
Type | Numeric |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | Add ST % |
Description | Add. ST % |
Level | 1 |
Help | Enter the additional percentage for sites opting for the Simples Nacional for net load ST. |
...
Field | SS9_PICM |
---|---|
Type | Numeric |
Size | 6 |
Decimal | 2 |
Format | @E 999.99 |
Title | ICM Perc. |
Description | ICMS |
Level
1
Perc. |
http://perc.do/]
Level | 1 |
Help | Enter ICMS percentage for internal operations |
Table | SS9 |
---|---|
Field | SS9_ALFEEF |
Type | Numeric |
Size | 5 |
Decimal | 2 |
Format | @E 99.99 |
Title | FEEF Rate |
Description | FEEF Rate |
Context | Real |
Ownership | Edit |
Help | Enter the FEEF rate. |
Field | CFC_ALQANT |
---|---|
Type | Numeric |
Size | 7 |
Decimal | 4 |
Format | @E 99.9999 |
Title | FEEF Rate |
Description | ICMS Anticipation Rate |
Context | Real |
Ownership | Edit |
Level | 1 |
Help | Enter the percentage of the ICMS anticipation rate in internal acquisitions. |
State x State CFC Table
Field | Sequence | Content | Target Field |
---|---|---|---|
CFC_CODPRD | 001 | SB1->B1_DESC | CFC_DESCR1 |
Creation of Questions in file SX1 – Questions:
Question | Source State |
---|---|
Routine | FISA080 |
Type | Character |
Question | Target State |
---|---|
Routine | FISA080 |
Type | Character |
Question | From NCM: |
---|---|
Routine | FISA080 |
Type | Character |
Question | To NCM: |
---|---|
Routine | FISA080 |
Type | Character |
...
Question | To Group: |
---|---|
Routine | FISA080 |
Type | Character |
Question | From Product: |
---|---|
Routine | FISA080 |
Type | Character |
...
Question | To Product: |
---|---|
Routine | FISA080 |
Type | Character |
Question | Edit? |
---|---|
Routine | FISA080 |
Type | Character |
Question | Product Source? |
---|---|
Routine | FISA080 |
Type | Character |
Details of the available fields on the registration screen:
...
...
...
...
...
...
...
...
...
...
...
...
...
In the bookkeeping of the tax document, a query will be made in the table State x State (CFC) considering the source State of the tax document, the target State of the tax document, and the product used in the document item. If an entry is found in this table, the information available there will be considered for the calculation and bookkeeping of the tax document.
The product code is optional in this registration, so if an entry exists with source State and target State without product code, the information in the State x State table will be valid for all invoices that fall within this combination of States.
The information can be manually registered record by record, or via batch processing, carried out through the facilitator.
Facilitator
In order to expedite the registration in the State x State 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:
Source State: Enter the source State that will be recorded.
Target State: Enter the target State that will be recorded.
IMPORTANT
To consider all States as the target, simply enter "*" in the *Target State question.
From NCM: Enter the initial NCM that you wish to process;
To NCM: Enter the final NCM that you wish to process;
IMPORTANT
To consider all NCMs, just leave the the From NCM question blank, and enter "Z" into the To NCM question until you fill the field up.
IMPORTANT
From Group: Enter the Initial Tax Group for which you wish to carry out the processing;
To Group: Enter the Final Tax Group for which you wish to carry out the processing;
IMPORTANT
To consider all Tax Groups simply leave the question question From Group blank, and fill in the To Group question with the letter "Z" until you fill the field up.
From Product: Enter the initial product code to be considered when processing;
To Product: Enter the final product code to be considered when processing;
IMPORTANT
To consider all Product Codes, just leave the From Product question blank, and enter "Z" into the To Product question until you fill the field up.
Edit?: The answer to this question indicates whether the Facilitator's processing will edit an existing record or not. Enter the available options:
Yes: Will edit the record;
No: Will not edit the record.
Product Source?: This question will validate which product source should be processed.
After you confirm these questions, a screen with the following fields will appear:
FECP rate
In this field, the value of the FECP rate should be entered, which should be recorded in the table State x State for Target/Source State, NCM, Tax Group, and Products entered in the previous questions.
Facilitator Processing Examples
Example 1: - Register FECP rate of 2.0000 for operations originating in SE and with RJ as target considering the products with codes between 1 and 10
Questions
| |
---|---|
| |
| |
| |
| |
| |
| |
Screen with available fields
FECP rate |
---|
|
Example 2: - Register FECP rate of 3.0000 for operations originating in TO and with CE as the target for all Product Codes
Source State | TO |
---|---|
Target State | CE |
To NCM | ZZZZZZZZZZ |
To Group | ZZZZZZ |
To Product | ZZZZZZZZZZZZZZZ |
Edit? | 1-YES |
Screen with available fields
FECP rate |
---|
|
Example 3: - Record FECP rate of 1.0000 for operations originating in BA and targeted at any State, considering NCM between codes 27050000 and 27079100:
Questions
Source State | BA |
---|---|
Target State | ** |
From NCM | 27050000 |
To NCM | 27079100 |
To Group | ZZZZZZ |
To Product | ZZZZZZZZZZZZZZZ |
Edit? | 1-YES |
Screen with available fields
FECP rate |
---|
1.0000 |
Aviso | ||
---|---|---|
| ||
The facilitator cannot be run in more than one instance. |
It is possible to group the issuance of ICMS-ST payment forms by agreement number from the outgoing document. With the current demand for the generation of forms per product made in another State through the National Payment Form (GNRE), a scenario was pointed out where there may be different GNREs by agreement or protocol between the States, considering operations with several agreements or protocols between the States. Seeing this scenario and that the tracking cannot be manual because, in only one invoice, 10 different agreements or protocols can be added, a treatment to group the generation of the payment forms by agreement number from the binding State x State file (FISA080) was created.
To use the feature, you should check in the database for the existence of the CFC_NUMCON field in the CFC table (State x State). In this field, the Agreement/Protocol number must be entered together with the operation Source State - Target State and the respective product code.
Configuration of the CFC_NUNCON field
Type | Character |
---|---|
Size | 30 |
Context | Real |
Ownership | Edit |
Title | Agreement No. |
Description | Number Agreement |
Help | Number of agreement or protocol/goods |
Example of Use
As an example, we will use the issuance of an outgoing document with 10 different product codes, all with a percentage of 12% ICMS-ST to be calculated at the outflow:
Item | Product | Amount | Unit Value | Total Amount | ICMS Amount | ICMS-ST amount |
---|---|---|---|---|---|---|
01 | PROD001 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
02 | PROD002 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
03 | PROD003 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
04 | PROD004 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
05 | PROD005 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
06 | PROD006 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
07 | PROD007 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
08 | PROD008 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
09 | PROD009 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
10 | PROD010 | 10 | 10.00 | 100.00 | 7.00 | 12.04 |
In the State x State file (FISA080), the following binding was registered
Source State | Target State | Product Code | Number Agreement |
---|---|---|---|
SP | AC | PROD001 | 170/15 |
SP | AC | PROD002 | 155/12 |
SP | AC | PROD003 | 170/15 |
SP | AC | PROD004 | 155/12 |
SP | AC | PROD006 | 155/12 |
When issuing the invoice, we have the following generation of payment forms:
Products that do not have State x State binding and Agreement Number reported (default system process).
Product Code | Agreement | ICMS-ST amount | GNRE Number | Amount |
---|---|---|---|---|
PRO001 | 170/15 | 12.04 |
PRO003 | 170/15 | 12.04 | ICM000000117 | 12.04 + 12.04 = 24.08 |
PRO002 | 155/12 | 12.04 |
PRO004 | 155/12 | 12.04 |
PRO006 | 155/12 | 12.04 | ICM000000118 | 12,04 + 12,04 + 12,04 = 31,12 |
Aviso | ||
---|---|---|
| ||
If the "Generate Bill" question is set to "Yes", the bills in the Financial module follow the same order as above. |
CFC - State x State
SF9 - State x State