Páginas filhas
  • SPCAT207 - File Checking Report of Decree CAT207 de 13/10/2009

CONTENTS

01. OVERVIEW

The CAT207 (FISR026) report states the records generated with data on ICMS Accrued Credit Calculation for issued tax documents, in accordance with the digital file guidance manual of the Simplified System of Accrued Credit Calculation of Decree CAT – 207, pursuant to article 30 of ICMS Rule DDTTs.

Important

For further information on how to configure and generate the CAT - 207 magnetic file, refer to the Decree CAT207 technical bulletin on the TDN portal.


In the Configurator (SIGACFG), access Environment/Registers/Menus and add, to the menu of module Tax Records (SIGAFIS), as specified below:

Menu Name

Sub-menu

Routine Name

Program

Tables

Reports

Checking List

Report CAT207

FISR026

SF3, SA1, CFF

02. EXAMPLE

In Tax Records (SIGAFIS), access Reports/Checklist/CAT207 Rep. and set routine parameters as follows

Important

This report uses TReport technology; therefore, it is only available from version 8.11 Release 4.  In order to be able to use it, the MV_TREPORT parameter must be set to 2 or 3.

  

Sales Period? 

Enter the Sales Period used for generating the report: Format MMYYYY.


Selected Records? 

Select the number of desired record.


Select Branches?


Select desired branches. Select NO to list only the current branch.

Click Finish. The report configuration screen will appear, where you can customize the overall layout, such as records, fields, filters, etc.

03. OTHER INFORMATION

The report is based on table SFT (Tax Records per Invoice Item); therefore, it shows the value of each item on the invoice. 

04. FIELDS

Field

Description

FT_NFISCAL

Tax Document Number

FT_SERIE

Tax Document Series

FT_ITEM

Code of Item

FT_CLIEFOR

Customer/Supplier

FT_LOJA

Supplier/Customer Store Code

FT_ENTRADA

Invoice Inflow Date

FT_CFOP

Inst/Oper Tax Code

FT_TIPO

Type of Entry

FT_BASEICM

ICMS Base Value

FT_ALIQICM

ICMS Rate

FT_VALICM

ICMS Value

FT_VALCONT

Accounting Value

A2_NOME

Supplier Corporate Name

A2_CGC

Supplier CNPJ/CPF

A2_INSCR

Supplier State Registration

A2_EST

Supplier State Acronym

A2_CEP

Supplier Postal Code

A2_CODPAIS

Supplier Country

A1_NOME

Customer Corporate Name

A1_CGC

Customer CNPJ/CPF

A1_INSCR

Customer State Registration.

A1_EST

Customer State Acronym

A1_CEP

Customer Postal Code

A1_CODPAIS

Customer Country


05. TABLES

Table

Description

SA1

Customer Register

SA2

Supplier Register

CFF

ICMS Accrued Credit Complement

SYA

Countries Register

SFT

Tax Records by Invoice Item