1. Localizations for Brazil Implementation Guide
  2. Understanding ICMS Magnetic Files (Sintegra)

Understanding ICMS Magnetic Files (Sintegra)

The Generate ICMS Magnetic Files - Sintegra program (R76B201) lets you create the flat file that you must submit for fiscal books reporting. Beginning in January 2003, the Brazilian government requires that you use the flat file layout as described in law Convenio ICMS 69/02 when you electronically submit the fiscal books for transactions that occurred after December 31, 2002. You use the format that the Convenio ICMS 57/95 requires for transactions that occurred before January 1, 2003. You specify the format that the system uses in the Convenio processing option.

The system reads records from these tables to populate the flat file:

  • Nota Fiscal - Header (Fiscal Books) (F76101B).

  • Nota Fiscal - Detail (Fiscal Books) (F76111B).

  • Nota Fiscal Taxes Header - Brazil (F76B001).

  • Item ASOF File (F41112).

  • GNRE Table (F76B105).

  • Branch/Plant Fiscal Company X-Reference - Brazil (F7606B).

The system reads tables F76111B, F76B101, and F76B001 to create record type 54 records that are based on data from notas fiscais. The record type 54 records that the system creates from tables F76111B and F76101B contain data about IPI and ICMS taxes. The record type 54 records that the system creates from table F76B001 contain data about PIS/PASEP and COFINS tax credits.

The system reads table F41112 to create record type 74 records that are based on transactions for which no nota fiscal exists, such as inventory adjustments.