Table 42 - Taxation Configuration
- This article presents the fields of the tax client integration layout. To better understand the concept behind taxation, see our article on Taxation Concept.
- To carry out this integration it is necessary to send the information along with Table 41 - Type of Tax Client.
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table identifier (IDENTIFICADOR) | FIXO=42 (2) | Yes | 2.13 | |
| 2 | Branch/Unit (codFilialUnidade) | Text (15) | Yes | 2.13 | Send ‘XX’ if the configuration is the same regardless of the Branch/Unit. |
| 3 | Product NCM (codNCM) | Text (20) | Yes | 2.13 | Send ‘XX’ if the configuration applies to all NCM’s (Rare situation), if your system does not have configuration at NCM level, send ‘XX’, but send details by product. |
| 4 | Product Code (codProduto) | Text (30) | Yes | 2.13 | Send ‘XX’ if this configuration applies to all other unspecified products, or if your configuration is per NCM level. |
| 5 | Destination UF (ufDestino) | Text (2) | Yes | 2.13 | Send here the UF of the Destination state to which the configuration applies. If the configuration applies to all states, or to all non-detailed states, use ‘XX’ |
| 6 | Tax Client Type (codTipoCliente) | Text (20) | Yes | 2.13 | Send ‘XX’ if you do not use the concept of Client Type Tax, or if this configuration applies to other unspecified Types. |
| 7 | IPI Calculation Base (baseCalculoIPI) | Decimal | Yes | 2.13 | Percentage of the Product Price, which must be used in the IPI calculation. (Inform percentage between 0 and 100) |
| 8 | IPI rate (aliquotaIPI) | Decimal | Yes | 2.13 | IPI rate that must be used. (Enter a percentage between 0 and 100) |
| 9 | Own ICMS Calculation Base (baseCalculoICMS) | Decimal | Yes | 2.13 | Percentage of the Product Price, which must be used in the calculation of Own ICMS. Important: Even if the company is part of Simples Nacional, enter the Percentage here, as it is used in part of the ICMS ST calculation (Inform percentage between 0 and 100) |
| 10 | Own ICMS Rate (aliquotaICMS) | Decimal | Yes | 2.13 | Rate that must be used in calculating the ICMS Own. Important: Even if the company is part of Simples Nacional, enter the rate here, as it is used in part of the ICMS ST calculation (Inform percentage between 0 and 100) |
| 11 | ST Calculation Method (modalidadeCalculoST) (Former field usarPrecoPauta) | Integer (1) | Yes | 4.54 | 0 = Use MVA Modality in the Calculation. |
| 12 | MVA (Added Value Margin) (MVA) | Decimal | Yes | 2.13 | Inform percentage between 0 and 100 |
| 13 | ICMS ST Calculation Base (baseCalculoIcmsSt) | Decimal | Yes | 2.13 | Percentage of the Product Price, including IPI, which must be used as a Base for Calculating Destination ICMS |
| 14 | ICMS ST Rate (aliquotaIcmsSt) | Decimal | Yes | 2.13 | ICMS Rate in the State of Destination |
| 15 | Tariff Price (precoPauta) | Decimal | Yes | 2.22 | Tariff Price |
| 16 | Percentage Reduction Tariff Price (percReducaoPrecoPauta) | Decimal | Yes | 2.22 | Tariff Price Reduction Percentage |
| 17 | IPI Calculation Method (modalidadeCalculoIPI) | Integer (1) | Yes | 2.25 | 1 - Calculation by Rate 2 - Value per Standard Unit NOTE: If the modality is “1 - Calculation by Rate”, the system calculates the IPI using fields 7 and 8 of this table, whereas if it is “2 - Value per Standard Unit”, the system uses the field “IPI Value per Unit” from table “15 - Product” |
| 18 | Discount type code (codtipoDesconto) | Text (20) | No | 3.3 | Discount type code referring to the record registered in table 130 – Type of discount |
| 19 | Additional fee modality (modalidadeTaxaAdicional) | Integer (1) | Yes | 3.3 | The additional fee modality is to identify whether the fee will be based on a percentage or a fixed amount; Valid options: 1 = percentage; 2 = fixed value |
| 20 | Additional Fee (taxaAdicional) | Decimal | No | 3.3 | value of the additional fee that will be applied |
| 21 | Customer Segment (codSegmento) | Text (30) | No | 4.20 | Customer segment code |
| 22 | Uses IPI in the calculation base ICMS_ST (utilizarIPINaBaseCalcST) | Tinyint(1) | No | 4.45 | The inclusion of IPI in the ICMS_ST calculation base will be determined based on the information provided. In the absence of such information, it is assumed that the IPI value will be considered in the aforementioned calculation base. |
Registration Example:
42|1|XX|26|XX|3|0|0|100|0|0||100||0|0|1|||||