CADUF - State x State

01. OVERVIEW

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.

02. SETUP PROCEDURES

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: 1 = StxSt (Default): State x State File 2 = Customer: The rate entered in field A1_PERFECP. Used when the rate varies by CNAE.

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 1 - Subtract FCP from ICMS 2 - Do not subtract FCP from ICMS

IMPORTANT

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. Decree no. 34560/2010

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 Perc.
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

03. USAGE PROCEDURE

Details of the available fields on the registration screen:

Source State (CFC_UFORIG): Enter the source State of the operation.
Target State (CFC_UFDEST): Enter the target State of the operation.
Prod. Code (CFC_CODPRD): Enter the code of the operation product.
FECP Rate (CFC_ALQFCP): Enter the FECP rate.
Prod. Desc. (CFC_DESCR1): This field displays the description of the selected product
ST Net Mar. (CFC_MGLQST): In this field, enter the Margin for calculation of Net ST ICMS. The Net ST Calc. field(F4_STLIQ) must be set to 1-Yes.
ST Add % (CFC_ADICST): Enter the rate for net ST load only for sites opting for the Simples Nacional. This way, its use will occur only for suppliers/customers opting for the Simples. The Net ST Calc. field(F4_STLIQ) must be set to 1-Yes, and ST Net Mar. (CFC_MGLQST) must be filled in with the margin value.
ICM Perc. (CFC_PIMM): Enter the Rate in outflow operations
FEEF Rate: In this field, the FEEF rate to be used for calculation according to the legislation of each State should be entered.

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 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 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

Source State	SE
Target State	RJ
To NCM	ZZZZZZZZZZ
To Group	ZZZZZZ
From Product	1
To Product	10
Edit?	1-YES

Screen with available fields

FECP rate
2.0000

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
3.0000

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

IMPORTANT

The facilitator cannot be run in more than one instance.

04. GROUP PAYMENT FORMS BY AGREEMENT NUMBER

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

IMPORTANT

If the "Generate Bill" question is set to "Yes", the bills in the Financial module follow the same order as above.

05. TABLES

CFC - State x State
SF9 - State x State

Páginas filhas

CADUF - State x State

01. OVERVIEW

02. SETUP PROCEDURES

03. USAGE PROCEDURE

04. GROUP PAYMENT FORMS BY AGREEMENT NUMBER

05. TABLES