2 Backend System Administration and Configuration
This chapter is intended for administrators who provide support and monitor the running system.
The content in this chapter is not procedural. Instead, it is meant to provide descriptive overviews of the parameters and configurations of the system that come with the Retail Fiscal Management application.
Fiscal Data Management
Fiscal Data Management is the set of features under RFMCS that manages fiscal attribute creation and item/entity fiscal classification. The association of fiscal-related attributes to items and entities is required to support fiscal document generation, tax calculation, and fiscal reporting. Depending on country-specific requirements, a set of pre-defined attributes is made available along with RFMCS.
Note:
The association of any pre-defined attribute to its specific entity (items, locations, suppliers, and so on) will not be delivered as part of the RFMCS installation. This association or “fiscal classification” is part of implementation activities.For the pre-defined attributes that require a list of values, the list will also be provided as part of the installation. However, some attributes have their list of values provided by governments or external entities. For customers to have the autonomy to keep these lists updated, the Fiscal Attributes List of Values are updated using Merchandising REST services. See Chapter 3, “Integration” for details.
The list of pre-defined attributes available in this release of RFMCS and the entity with which they are associated is described below. This list is not exhaustive, as it does not have all the configuration parameters for each attribute. These details are fetched from the application by calling the Fiscal Attributes Request Service. See Chapter 3, “Integration” for details.
Table 2-1 Pre-defined Fiscal Attributes for Brazil
| COUNTRY | CODE | DESCRIPTION | TEMPLATE | MANDATORY | Behavior |
|---|---|---|---|---|---|
|
BR |
CD_CLASSIFICACAO |
Classification code for the item. |
ITEM_MASTER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
APLICACAO |
Application purpose for the item. |
ITEM_MASTER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FABRICACAO |
Indicates if the item falls into one of the 2 categories for tax calculation purposes. |
ITEM_MASTER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: |
|
BR |
ORIG |
Origin classification code for items (code defined by fiscal authority). |
ITEM_MASTER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
NCM |
Item classification code (code defined for Mercosul trading zone). |
ITEM_MASTER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
EXNCM |
Sublevel of the NCM code (internal code meant for tax rule conditions). |
ITEM_MASTER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CEST |
Extension code associated to the NCM code. This code is meant to identify items that are under the ST regime. Used for NF creation and tax calculation. |
ITEM_MASTER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
EXTIPI |
Tax exception classification applied to IPI tax. |
ITEM_MASTER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
UF_FABRICACAO |
Indicates the state where the product was manufactured. |
ITEM_MASTER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IND_ESCALA |
Item Produced at a relevant scale. Attribute required to be stored for NF creation. |
ITEM_MASTER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNPJ_FAB |
Associated with attributes Produced at a relevant Scale to store data for NF creation. |
ITEM_MASTER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
ITEM_MASTER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FABRICACAO |
Indicates if the item falls into one of the 2 categories for tax calculation purposes. |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
ORIG |
Origin classification code for items (code defined by fiscal authority). |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
UF_FABRICACAO |
Indicates the state where the product was manufactured. |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
UN_FISCAL |
Fiscal UOM. Used for when the NF UOM is different than the Merchandising SUOM. Conversion created only in RFM. |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FATOR_UN_FISCAL |
Fiscal UOM conversion factor. Used for when the NF UOM is different than Merchandising SUOM. Conversion created only in RFM. |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
ITEM_SUPPLIER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FABRICACAO |
Indicates if the item falls into one of the 2 categories for tax calculation purposes. |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
ORIG |
Origin classification code for items (code defined by fiscal authority). |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
UF_FABRICACAO |
Indicates the state where the product was manufactured. |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
N_FCI |
FCI process code stored at item/location level for NF creation. |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
GROUP_ITEMS_ST |
This flag will make group items while creating NFs. |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
ITEM_LOC |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
PESSOA_JURIDICA |
Corporate taxpayer indicator. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNAE |
CNAE code (database attribute for other entities). Activity identification code for companies. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNPJ |
Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers. |
LOCATION |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE |
Taxpayer ID for state level tax authorities. |
LOCATION |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IND_IE |
Indicates the type of State Inscription for the Recipient. |
LOCATION |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IM |
Taxpayer ID for city level tax authorities. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT |
Define the taxpayer's taxation regime (Normal Regime or National Simples). |
LOCATION |
N |
System Behavior: N Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT_SIMPLES_ALIQ |
Percentage rate if the CRT equals the SIMPLES Contributor. |
LOCATION |
C |
System Behavior: N Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
I_SUF |
Specific free zone taxpayer code for exemption purposes. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CONTROL_FISCAL_LEDGER |
Location-level definition
for fiscal ledger control. If |
LOCATION |
Y |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: N |
|
BR |
DISCR_FISCAL_DOCUMENT |
Location level definition
of resolution method if the resolution type is automatic. If |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
DISCR_RESOLUTION_TYPE |
Location level control for discrepancy resolution option. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_COST |
Indicates the level of the document that is compared with the PO in POFDR Flow for Cost. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_DISCOUNT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Discount. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_FREIGHT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Freight. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: |
|
BR |
MATCH_LEVEL_INSURANCE |
Indicates the level of the document that is compared with the PO in POFDR Flow for Insurance. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_EXPENSES |
Indicates the level of the document that is compared with the PO in POFDR Flow for Expenses. |
LOCATION |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
ST_BREAK_NF_IND |
Indicates if the RTV must have ST tax in a separate NF. RFM behavior flag. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: |
|
BR |
ST_BALANCE_AVG_IND |
Indicates the use of weighted average for the ST tax recovery calculation based on the fiscal ledger documents consumed. |
LOCATION |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
LEDGER_BALANCE_METHOD |
Ledger balance method
( |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
NFE_MANIFEST_DAYS |
Indicates the number of days to Manifest NFe Rejection. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_COST |
Indicates the percentage rate of tolerance to be applied in the comparison of item cost between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: N |
|
BR |
TOLERANCE_VALUE_COST |
Indicates the value of tolerance to be applied in the comparison of item cost between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: N |
|
BR |
TOLERANCE_RATE_DISCOUNT |
Indicates the percentage rate of tolerance to be applied in the comparison of discounts between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: N |
|
BR |
TOLERANCE_VALUE_DISCOUNT |
Indicates the value of tolerance to be applied in the comparison of discounts between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_FREIGHT |
Indicates the percentage rate of tolerance to be applied in the comparison of freight cost between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_FREIGHT |
Indicates the value of tolerance to be applied in the comparison of freight cost between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_INSURANCE |
Indicates the percentage rate of tolerance to be applied in the comparison of insurance between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_INSURANCE |
Indicates the value of the tolerance to be applied in the comparison of insurance between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_EXPENSES |
Indicates the percentage rate of tolerance to be applied in the comparison of expenses between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_EXPENSES |
Indicates the value of tolerance to be applied in the comparison of expenses between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document
Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system. |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX_RET |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
LOCATION |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX_RET |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
LOCATION |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MD_ARRED |
Indicates if the tax calculation should be rounded or truncated. In either case the result will be provided with 2 decimals (only for totals) |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax
Calculation: Fiscal Reporting: |
|
BR |
IE_ST_AC |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_AL |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_AM |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_AP |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: |
|
BR |
IE_ST_BA |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_CE |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_DF |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_ES |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_GO |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_MA |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_MG |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_MS |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_MT |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_PA |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_PB |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_PE |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_PI |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_PR |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_RJ |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_RN |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_RO |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_RR |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_RS |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_SC |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_SE |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_SP |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE_ST_TO |
State inscription as ST substitute (can be more than one depending on the state). |
LOCATION |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
PESSOA_JURIDICA |
Corporate taxpayer indicator. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNPJ |
Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers. |
SUPS |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CPF |
Taxpayer ID for federal level tax authorities. Exclusive for individual taxpayers. |
SUPS |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE |
Taxpayer ID for state level tax authorities. |
SUPS |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IND_IE |
Indicates the type of State Inscription for the Recipient. |
SUPS |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNAE |
CNAE code (database attribute for other entities). Activity identification code for companies. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IM |
Taxpayer ID for city level tax authorities. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
I_SUF |
Specific free zone taxpayer code for exemption purposes. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT |
Define the taxpayer's taxation regime (Normal Regime or National Simples). |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT_SIMPLES_ALIQ |
Percentage rate if the |
SUPS |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FABRICANTE_DISTRIBUIDOR |
Information for special tax regimes. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FAIXA_FATURAMENTO_ANUAL |
Is income range eligible. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
PRODUTOR_RURAL |
Rural Producer indicator. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_COST |
Indicates the level of the document that is compared with the PO in POFDR Flow for Cost. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_DISCOUNT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Discount. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_FREIGHT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Freight. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_INSURANCE |
Indicates the level of the document that is compared with the PO in POFDR Flow for Insurance. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_EXPENSES |
Indicates the level of the document that is compared with the PO in POFDR Flow for Expenses. |
SUPS |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
AUTO_SUBMIT_RECEIPT |
Y/N indicator to automatically submit for physical receipt if no discrepancy is found during NF validation. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_COST |
Indicates the percentage rate of tolerance to be applied in the comparison of item cost between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_COST |
Indicates the value of tolerance to be applied in the comparison of item cost between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_DISCOUNT |
Indicates the percentage rate of tolerance to be applied in the comparison of discounts between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_DISCOUNT |
Indicates the value of tolerance to be applied in the comparison of discounts between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_FREIGHT |
Indicates the percentage rate of tolerance to be applied in the comparison of freight cost between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_FREIGHT |
Indicates the value of tolerance to be applied in the comparison of freight cost between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_INSURANCE |
Indicates the percentage rate of tolerance to be applied in the comparison of insurance between NF and the system. |
SUPS |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_INSURANCE |
Indicates the value of tolerance to be applied in the comparison of insurance between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_EXPENSES |
Indicates the percentage rate of tolerance to be applied in the comparison of expenses between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_EXPENSES |
Indicates the value of tolerance to be applied in the comparison of expenses between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system. |
SUPS |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX_RET |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
SUPS |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX_RET |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
SUPS |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
PESSOA_JURIDICA |
Corporate taxpayer indicator. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNPJ |
Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers. |
PARTNER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CPF |
Taxpayer ID for federal level tax authorities. Exclusive for individual taxpayers. |
PARTNER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IE |
Taxpayer ID for state level tax authorities. |
PARTNER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IND_IE |
Indicates the type of State Inscription for the Recipient. |
PARTNER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CNAE |
CNAE code (database attribute for other entities). Activity identification code for companies. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
IM |
Taxpayer ID for city level tax authorities. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
I_SUF |
Specific free zone taxpayer code for exemption purposes. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT |
Define the taxpayer's taxation regime (Normal Regime or National Simples). |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
CRT_SIMPLES_ALIQ |
Percentage rate if the |
PARTNER |
C |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FABRICANTE_DISTRIBUIDOR |
Information for special tax regimes. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
FAIXA_FATURAMENTO_ANUAL |
Is income range eligible. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
PRODUTOR_RURAL |
Rural Producer indicator. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
REGIME_DIF |
Internal tax regime code kept
in |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_COST |
Indicates the level of the document that is compared with the PO in POFDR Flow for Cost. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_DISCOUNT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Discount. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_FREIGHT |
Indicates the level of the document that is compared with the PO in POFDR Flow for Freight. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_INSURANCE |
Indicates the level of the document that is compared with the PO in POFDR Flow for Insurance. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
MATCH_LEVEL_EXPENSES |
Indicates the level of the document that is compared with the PO in POFDR Flow for Expenses. |
PARTNER |
Y |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
AUTO_SUBMIT_RECEIPT |
|
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_COST |
Indicates the percentage rate of tolerance to be applied in the comparison of item cost between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_COST |
Indicates the value of tolerance to be applied in the comparison of item cost between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_DISCOUNT |
Indicates the percentage rate of tolerance to be applied in the comparison of discounts between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_DISCOUNT |
Indicates the value of tolerance to be applied in the comparison of discounts between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_FREIGHT |
Indicates the percentage rate of tolerance to be applied in the comparison of freight cost between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_FREIGHT |
Indicates the value of tolerance to be applied in the comparison of freight cost between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_INSURANCE |
Indicates the percentage rate of tolerance to be applied in the comparison of insurance between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_INSURANCE |
Indicates the value of tolerance to be applied in the comparison of insurance between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_EXPENSES |
Indicates the percentage rate of tolerance to be applied in the comparison of expenses between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_EXPENSES |
Indicates the value of tolerance to be applied in the comparison of expenses between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system. |
PARTNER |
N |
System Behavior: Fiscal Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_RATE_TAX_RET |
Indicates the percentage rate of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
PARTNER |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
|
BR |
TOLERANCE_VALUE_TAX_RET |
Indicates the value of tolerance to be applied in the comparison of taxes between NF and the system for retained taxes. |
PARTNER |
N |
System Behavior: Fiscal
Document Use: Tax Calculation: Fiscal Reporting: |
Fiscal Documents Management
In RFMCS, the main objective is the management of fiscal documents and the support of fiscal document receiving and generation.
RFMCS and its fiscal document management capabilities introduces the concept of workflow-based development for which the processing of a transaction is based on a sequence of events configured for each country/transaction/document type combination. With this approach, the business rules applied to the transactions are kept separated from the workflow processing components. Each step executed returns the output of the execution, the messages generated, validations and errors. All of it is visible on the screen, which gives the user a complete view of what happens in the process flow.
Workflows are not configurable to users and are made available as part of the product. A workflow is defined by country, transaction, and document type.
POFDR: Purchase Order Fiscal Document Receive
-
Country: Brazil
-
Document Type: Brazilian NFe – Model 55
-
Overview: This workflow is meant to support the fiscal receiving of purchase orders that are associated with the Brazilian fiscal document “NFE”.
Table 2-2 POFDR Workflow Steps
| Step Group | Step Name | Step Summary |
|---|---|---|
|
Document Receiving |
Purchase Order Fiscal Document Receive |
Initial step where the fiscal document is uploaded into the system. |
|
Validate Document Unicity |
First validation to check duplicity. |
|
|
Deduce Key Data |
Deduction of internal IDs for issuer and destination entities. |
|
|
Validate Key Data |
Validation of the deduced data. |
|
|
NFE Status Verification Request |
Verification of NFE validity – Request to 3rd party. |
|
|
NFE Status Verification Response |
Verification of NFE validity – Response from 3rd party. |
|
|
Deduce Foundation Data |
Deduce Foundation Data |
Deduction of item and PO data. |
|
Validate Foundation Data |
Validation of the deduced data. |
|
|
Commercial Validation |
Deduce Commercial Data |
Deduction of PO costs and expenses. |
|
Validate Commercial Data |
Validation of the deduced data. |
|
|
Match Document with PO |
Match costs and expenses including tolerances. |
|
|
Tax Validation |
Tax Validate Request |
Match taxes – Request to 3rd party tax engine. |
|
Tax Validate Response |
Match taxes – Response from 3rd party tax engine. |
|
|
Submit to Physical Receiving |
Verify Auto Submit Setup |
Check system behavior fiscal attributes. |
|
NFE Status Verification Request |
Verification of NFE validity (optional) – Request to 3rd party. |
|
|
NFE Status Verification Response |
Verification of NFE validity – Response from 3rd party. |
|
|
Generate ASNIN Data |
Generation of ASNIN data. |
|
|
Update Merchandise ASNIN Data |
Update MFCS with ASNIN data. |
|
|
Verify Location Type |
Check system behavior fiscal attributes. |
|
|
Submit to Physical Receipt Warehouse |
Post ASNIN to integration table. |
|
|
Submit to Physical Receipt Store |
Push ASNIN to SIOCS if the location is a store. |
|
|
Process Receipt |
Consume Receipt Message |
Consume |
|
Process Receipt Message |
Match receipt quantities. |
|
|
Verify Overage Report Data |
Check if any overage quantity was informed and generate overage report data. |
|
|
Verify Return Discrepancy Document Type |
Check system behavior fiscal attributes. |
|
|
Generate Credit Note Data |
Check if any return quantity was informed and generate credit note data depending on the location fiscal attribute. |
|
|
Generate RNF Data |
Check if any return quantity was informed and generate return NF data depending on the location fiscal attribute. |
|
|
Return Document Request |
Check if any return quantity was informed and request a document generation to FDG.. |
|
|
Tax Account |
Tax Account Request |
Request accounting taxes – Request to 3rd party tax engine. |
|
Tax Account Response |
Request accounting taxes – Response from 3rd party tax engine. |
|
|
Create Tax Account Data |
Update accounting tax data into the document. |
|
|
Calculate Receiving Cost |
Calculate the receiving cost considering the accounting tax data (credits). |
|
|
Update Fiscal Ledger |
Create Fiscal Ledger Data |
Update fiscal ledger with the document data. |
|
Update Fiscal Ledger In |
Update document with fiscal ledger IDs. |
|
|
Update Inventory |
Update Inventory |
Update MFCS inventory. |
|
Generate Transaction Codes |
Update Financial Postings |
Apply transaction codes setup and generate transaction data for the document. |
|
Manifest Document |
Update Manifest Data |
Generate recipient-manifest-related data confirming the receiving of the document. |
|
Update Reject Manifest Data |
Generate recipient-manifest-related data if the document was rejected. |
|
|
Nfe Reject Manifest |
Check system behavior fiscal attributes – Manifest days. |
|
|
Nfe Manifest Request |
Call 3rd party system for recipient manifest events - Request. |
|
|
Nfe Manifest Response |
Call 3rd party system for recipient manifest events - Response. |
|
|
POFDR Process Closure |
Create Fiscal Report Data |
Generate fiscal report data to be available to external systems. |
|
Pre Archive Document |
Convert document to the archive data format. |
|
|
Archive Document |
Move document to archive repository. |
|
|
Validate Document Reject |
Check if document was rejected to update final step accordingly. |
|
|
POFDR Workflow Completed |
Update document to final workflow step if the receipt is completed. |
|
|
POFDR Workflow Terminated |
Update document to final workflow step if the receipt is not completed (that is, the document is rejected or deleted). |