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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

APLICACAO

Application purpose for the item.

ITEM_MASTER

Y

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FABRICACAO

Indicates if the item falls into one of the 2 categories for tax calculation purposes.

ITEM_MASTER

Y

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y Fiscal Reporting: N

BR

ORIG

Origin classification code for items (code defined by fiscal authority).

ITEM_MASTER

Y

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

NCM

Item classification code (code defined for Mercosul trading zone).

ITEM_MASTER

Y

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

EXNCM

Sublevel of the NCM code (internal code meant for tax rule conditions).

ITEM_MASTER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

EXTIPI

Tax exception classification applied to IPI tax.

ITEM_MASTER

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

UF_FABRICACAO

Indicates the state where the product was manufactured.

ITEM_MASTER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

IND_ESCALA

Item Produced at a relevant scale. Attribute required to be stored for NF creation.

ITEM_MASTER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CNPJ_FAB

Associated with attributes Produced at a relevant Scale to store data for NF creation.

ITEM_MASTER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

ITEM_MASTER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FABRICACAO

Indicates if the item falls into one of the 2 categories for tax calculation purposes.

ITEM_SUPPLIER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

ORIG

Origin classification code for items (code defined by fiscal authority).

ITEM_SUPPLIER

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

UF_FABRICACAO

Indicates the state where the product was manufactured.

ITEM_SUPPLIER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

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

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

ITEM_SUPPLIER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FABRICACAO

Indicates if the item falls into one of the 2 categories for tax calculation purposes.

ITEM_LOC

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

ORIG

Origin classification code for items (code defined by fiscal authority).

ITEM_LOC

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

UF_FABRICACAO

Indicates the state where the product was manufactured.

ITEM_LOC

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

N_FCI

FCI process code stored at item/location level for NF creation.

ITEM_LOC

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

GROUP_ITEMS_ST

This flag will make group items while creating NFs.

ITEM_LOC

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

ITEM_LOC

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

PESSOA_JURIDICA

Corporate taxpayer indicator.

LOCATION

Y

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: Y

BR

CNAE

CNAE code (database attribute for other entities). Activity identification code for companies.

LOCATION

Y

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

CNPJ

Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers.

LOCATION

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE

Taxpayer ID for state level tax authorities.

LOCATION

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IND_IE

Indicates the type of State Inscription for the Recipient.

LOCATION

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IM

Taxpayer ID for city level tax authorities.

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CRT

Define the taxpayer's taxation regime (Normal Regime or National Simples).

LOCATION

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

CRT_SIMPLES_ALIQ

Percentage rate if the CRT equals the SIMPLES Contributor.

LOCATION

C

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

I_SUF

Specific free zone taxpayer code for exemption purposes.

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

LOCATION

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

CONTROL_FISCAL_LEDGER

Location-level definition for fiscal ledger control. If Yes, all NFs are controlled (in and out).

LOCATION

Y

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

DISCR_FISCAL_DOCUMENT

Location level definition of resolution method if the resolution type is automatic. If YES a fiscal document (RNF) is generated. If NO, a non-fiscal document is generated (credit note).

LOCATION

Y

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

DISCR_RESOLUTION_TYPE

Location level control for discrepancy resolution option.

LOCATION

Y

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

ST_BREAK_NF_IND

Indicates if the RTV must have ST tax in a separate NF. RFM behavior flag.

LOCATION

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

LEDGER_BALANCE_METHOD

Ledger balance method (LIFO, or FIFO) - Default: LIFO.

LOCATION

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

NFE_MANIFEST_DAYS

Indicates the number of days to Manifest NFe Rejection.

LOCATION

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

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

Fiscal Document Use: N

Tax Calculation: N

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

Fiscal Document Use: N

Tax Calculation: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: N

BR

IE_ST_AC

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_AL

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_AM

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_AP

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N Fiscal Reporting: Y

BR

IE_ST_BA

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_CE

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_DF

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_ES

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_GO

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_MA

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_MG

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_MS

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_MT

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_PA

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_PB

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_PE

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_PI

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_PR

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_RJ

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_RN

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_RO

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_RR

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_RS

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_SC

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_SE

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_SP

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE_ST_TO

State inscription as ST substitute (can be more than one depending on the state).

LOCATION

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

PESSOA_JURIDICA

Corporate taxpayer indicator.

SUPS

Y

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: Y

BR

CNPJ

Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers.

SUPS

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CPF

Taxpayer ID for federal level tax authorities. Exclusive for individual taxpayers.

SUPS

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE

Taxpayer ID for state level tax authorities.

SUPS

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IND_IE

Indicates the type of State Inscription for the Recipient.

SUPS

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CNAE

CNAE code (database attribute for other entities). Activity identification code for companies.

SUPS

Y

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

IM

Taxpayer ID for city level tax authorities.

SUPS

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

I_SUF

Specific free zone taxpayer code for exemption purposes.

SUPS

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CRT

Define the taxpayer's taxation regime (Normal Regime or National Simples).

SUPS

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

CRT_SIMPLES_ALIQ

Percentage rate if the CRT equals the SIMPLES Contributor.

SUPS

C

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FABRICANTE_DISTRIBUIDOR

Information for special tax regimes.

SUPS

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FAIXA_FATURAMENTO_ANUAL

Is income range eligible.

SUPS

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

PRODUTOR_RURAL

Rural Producer indicator.

SUPS

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

SUPS

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

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.

SUPS

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

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.

SUPS

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

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.

SUPS

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

PESSOA_JURIDICA

Corporate taxpayer indicator.

PARTNER

Y

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: Y

BR

CNPJ

Taxpayer ID for federal level tax authorities. Exclusive for corporate taxpayers.

PARTNER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CPF

Taxpayer ID for federal level tax authorities. Exclusive for individual taxpayers.

PARTNER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IE

Taxpayer ID for state level tax authorities.

PARTNER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

IND_IE

Indicates the type of State Inscription for the Recipient.

PARTNER

C

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CNAE

CNAE code (database attribute for other entities). Activity identification code for companies.

PARTNER

Y

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

IM

Taxpayer ID for city level tax authorities.

PARTNER

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

I_SUF

Specific free zone taxpayer code for exemption purposes.

PARTNER

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: N

Fiscal Reporting: Y

BR

CRT

Define the taxpayer's taxation regime (Normal Regime or National Simples).

PARTNER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

CRT_SIMPLES_ALIQ

Percentage rate if the CRT equals the SIMPLES Contributor.

PARTNER

C

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FABRICANTE_DISTRIBUIDOR

Information for special tax regimes.

PARTNER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

FAIXA_FATURAMENTO_ANUAL

Is income range eligible.

PARTNER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

BR

PRODUTOR_RURAL

Rural Producer indicator.

PARTNER

N

System Behavior: N

Fiscal Document Use: Y

Tax Calculation: Y

Fiscal Reporting: Y

BR

REGIME_DIF

Internal tax regime code kept in FDM_ATTRIB for tax calculation only.

PARTNER

N

System Behavior: N

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

BR

AUTO_SUBMIT_RECEIPT

Y/N indicator to automatically submit for physical receipt if no discrepancy is found during NF validation.

PARTNER

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

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.

PARTNER

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

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.

PARTNER

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

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.

PARTNER

N

System Behavior: Y

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: N

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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

Fiscal Document Use: N

Tax Calculation: Y

Fiscal Reporting: N

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 RECEIPT message from SIOCS/WMS through MFCS.

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