16 Obtaining the FCI Number from SEFAZ

This chapter contains the following topics:

16.1 Understanding FCI Numbers

You must include in some fiscal documents information about the imported content for certain transactions involving the interstate sales of goods with imported content. Because the ICMS tax rate differs depending on the import content, you must maintain information about each items's origin and import content.

You maintain information about the content and item origin in the Item Master Regional Information Brazil (P4101BR) and Item Branch Regional Information - Brazil (P76412B) programs. These tables include item information that is specific to Brazil:

  • Item Master Regional Information - Brazil (F76411).

  • Item Branch Regional Information - Brazil table (F76412).

  • Tag File F76411 - Item Master (F76B4101).

    This table includes a field for the FCI number.

  • Tag File F76412 - Item Branch (F76B4102).

    This table includes a field for the FCI number.

You must also include in certain fiscal documents and reports the FCI (Content Import Form) number for imported products that are subject to industrial processing. You obtain the FCI number by submitting a text file with item and fiscal classification information to the SEFAZ (Secretaria do Estado da Fazenda do Brasil, the State Revenue Department). SEFAZ returns a file to you with the FCI number for your items. You then add the FCI numbers to your item and item/branch records so that the numbers can be included in documents and reports as required.

The JD Edwards EnterpriseOne software for Brazil includes programs that you use to generate text files to send to SEFAZ, review text files, and upload the FCI numbers provided to you by SEFAZ.

16.1.1 Process to Obtain FCI Numbers from SEFAZ

To obtain FCI numbers from SEFAZ and update your item records with the FCI number, complete these steps:

  1. Populate the register tables for the FCI text files.

    Run the FCI TXT File Generation by Item (R76B0070) and FCI TXT File Generation by Item/Branch (R76B0071) programs in final mode to write item data to the FCI TXT File Process Header Blocks (F76B0070), FCI TXT File Process Detail Blocks table (F76B0071), Text Processor Header (F007101) and Text Processor Detail (F007111) tables.

    See Section 16.2, "Populating the FCI Text File Register Tables"

  2. Review the register tables.

    Use the FCI TXT File Process Blocks program (P76B0070) to review the batch and detailed data in the F76B0070 and F76B0071 tables.

    See Section 16.3, "Reviewing the FCI Register Tables and FCI Status"

  3. Generate the text file to submit to SEFAZ.

    Select the batch in the FCI TXT File Process Blocks program and the Run the Text File Processor program (P007101) to copy the files from the Text Processor Header table (F007101) and Text Processor Detail Table (F007111) to the text file. The system updates the status of tables F76B0070, F76B0071, F007101 and F007111 to 1).

    The program groups the records into the blocks and fields as required.

    See Section 16.4, "Generating the Text Files to Submit to SEFAZ"

  4. Send the files to SEFAZ.

    Note:

    Do not send additional files to SEFAZ until you receive the reply on the files sent.
  5. Review the status of the returned files with the FCI TXT File Process Blocks program (P76B0070). The status of the record must be Processed (outbound). Only one record should show as Processed.

    The SEFAZ file includes the FCI numbers for the item information that you sent.

    Run the Download FCI Information program (R76B0072) in proof mode to generate a PDF that you can review. The report displays the list of items with the FCI numbers. In proof mode, the program does not upload data to tables.

    See Section 16.5, "Uploading and Reviewing FCI Numbers Returned by SEFAZ"

  6. Run the Download FCI Information program (R76B0072) in final mode to generate the PDF report that displays the list of items with the FCI numbers and update the Item Master Tag file F76411 (F76B4101) and Item Branch Tag file F76412 (F76B4102) tables with the FCI number for each item. You also update the Text Processor Header (F007101) table with the information from SEFAZ (Hash Code, Receipt Date, Receipt Code Validated Date, File Validation Indicator) and the Text Processor Detail (F007111) table with the FCI number and the File Validation Indicator for each item.

    The status of the file updates to Processed.

    See Section 16.5, "Uploading and Reviewing FCI Numbers Returned by SEFAZ"

  7. Use the FCI TXT File Process Blocks (P76B0070) program to review the status of the returned files that you uploaded to the FCI TXT File Process Header Blocks (F76B0070) and FCI TXT File Process Detail Blocks (F76B0071) tables.

    See Section 16.5, "Uploading and Reviewing FCI Numbers Returned by SEFAZ"

  8. Upload the FCI number to the item and item/branch tables.

    Run the Download FCI Information program (R76B0072) in final mode to update the F76B4101 table if you ran the FCI TXT File Generation by Item program to begin the process, and to update the F76B4102 table if you ran the FCI TXT File Generation by Item/Branch program to begin the process.

    See Section 16.5, "Uploading and Reviewing FCI Numbers Returned by SEFAZ"

16.1.2 Prerequisites

Before you begin the tasks in this section:

  • Add R76B0072 to UDC 03B/UP.

  • Verify that the item origin and imported content information exists in these tables for the items for which you request an FCI number:

    • Item Master Regional Information - Brazil (F76411).

    • Item Branch Regional Information - Brazil table (F76412).

    • Tag File F76411 - Item Master (F76B4101).

    • Tag File F76412 - Item Branch (F76B4102).

    You can use the Item Master Regional Information Brazil (P4101BR) and Item Branch Regional Information - Brazil (P76412B) programs to enter data for each item record.

16.2 Populating the FCI Text File Register Tables

This section provides an overview of how to populate the FCI text file register tables and discusses how to:

  • Run the FCI TXT File Generation by Item program.

    Run the FCI TXT File Generation by Item/Branch program.

  • Set processing options for FCI TXT File Generation by Item (R76B0070) and FCI TXT File Generation by Item/Branch (R76B0071).

16.2.1 Understanding How to Populate the FCI Text File Register Tables

You run the FCI TXT File Generation by Item (R76B0070) and FCI TXT File Generation by Item/Branch (R76B0071) programs to populate the register tables that the system uses to create the text file that you send to SEFAZ. You populate register tables so that you can review the data before sending it to SEFAZ.

When you run the R76B0070 program, the system reads data from the Tag File F76411 - Item Master table (F76B4101) and writes data to the FCI TXT File Process Header Blocks (F76B0070) and FCI TXT File Process Detail Blocks (F76B0071) tables. Similarly, when you run the R76B0071 program, the system reads data from the Tag File F76412 - Item Branch Master table (F76B4102) and writes data to the FCI TXT File Process Header Blocks (F76B0070) and FCI TXT File Process Detail Blocks (F76B0071) tables. The F76B0070 and F76B0071 tables are the register tables.

When you run the R76B0070 and R76B0071 programs, the system validates the legal company information. If errors exist in the setup of the legal company, the program stops processing and writes error messages to a PDF file. If errors exist at the item level, the program writes error messages to the PDF and continues processing the items without errors. Oracle recommends that you run the programs in proof mode first so that you can review and fix errors before you run the program in final mode to generate a batch and transaction number for the files.

The R76B0070 and R76B0071 programs generate the text file information in blocks of information. Block 0 includes the legal company information, based on the legal company you specify in the processing options. Block 5 includes the item information. The unit of measure included in block 5 is obtained from the primary unit of measure for the item as set up in your item records. For items included in the text file that reside in the F4101/F76411 tables, the item number is the short item number. For items that reside in the F4102/F76412 tables, the item number included in the text file is a concatenation of the internal item number, the branch plant, and the location. Block 9 include information about the text file.

Important Note:

Be sure to run the Download FCI Information program in final mode before generating additional text files so that the system does not overwrite text file records.

16.2.2 Running the FCI Text File Generation Programs

Use one of these navigations:

  • Select Brazil FCI Maintenance (G76BFCI), FCI TXT Generation by Item.

  • Select Brazil FCI Maintenance (G76BFCI), FCI TXT Generation by Item/Branch Plant.

16.2.3 Setting Processing Options for the FCI Text File Generation Programs (R76B0070 and R76B0071)

Processing options enable you to specify default processing values.

16.2.3.1 General

1. Legal Company

Enter the company number of the legal company.

2. File Version

Specify the file version to print in the header of the file.

3. Type of Data to Recover the City Code from Supplemental Data

Enter the supplemental data code that you set up for the city code.

4. Process Mode

Enter 1 to process the files in final mode. In final mode, the system generates a batch number and transaction number in the text file processor tables.

16.2.3.2 Selection Tab

1. FCI Number Mode Selection

Enter 1 to process only the item and item/branch records that do not have an FCI number. Leave this processing option blank to include all item and item/branch records.

16.3 Reviewing the FCI Register Tables and FCI Status

This section provides an overview of FCI register tables, lists the forms used to review FCI register tables, and discusses how to set processing options for the FCI TXT File Process Blocks program (P76B0070).

16.3.1 Understanding the FCI Register Tables

When you run the FCI TXT File Generation by Item (R76B0070) and FCI TXT File Generation by Item/Branch (R76B0071) programs, the system populates the FCI TXT File Process Header Blocks (F76B0070) and FCI TXT File Process Detail Blocks (F76B0071) tables. You can use the FCI TXT File Process Blocks program (P76B0070) to review the data in the tables before you generate the file to request FCI numbers from SEFAZ.

You can view the header record (F76B0070) on the Work with FCI Text Generator form, and can view the detail records (F76B0071) on the FCI Text Output File form.

After you run the FCI TXT File Generation by Item (R76B0070) or FCI TXT File Generation by Item/Branch (R76B0071) program in final mode, the system generates records in the Text Processor Header table (F007101) and Text Processor Detail Table (F007111). You can then use the Text File Processor program (P007101) to copy the text files to the medium you use to submit the text files to SENFAZ.

After SEFAZ returns FCI files to you, you upload the files to the F76B0070 and F76B0071 tables for review. You can view the status of the individual item records and the FCI number that SEFAZ assigned to the items.

16.3.2 Forms Used to Review the FCI Text File Register

Form Name Form ID Navigation Usage
Work with FCI Txt Generator W76B0070A Brazil FCI Maintenance (G76BFCI), FCI TXT File Process Blocks Review batches generated by the FCI TXT File Generation by Item (R76B0070) or FCI TXT File Generation by Item/Branch (R76B0071) programs.'

View the status of batches.

Generate the text files using the Text File Processor program (P007101).

FCI TXT Output File W76B0070C On the Work with FCI Txt Generator form, select a batch, and then click Select. View the values in the text file and view the status of individual records.

16.3.3 Setting Processing Options for FCI TXT File Process Blocks (P76B0070)

Processing options enable you to provide default processing values.

16.3.3.1 Version

Enter the Version for P007101

Specify the version of the Text File Processor program that you launch from the FCI Text File Register program.

16.4 Generating the Text Files to Submit to SEFAZ

This section provides an overview of text file generation for FCI text files and lists the forms used to generate the text files to submit to SEFAZ.

16.4.1 Understanding Text File Generations for FCI Text Files

After you review the information written to the F76B0070 and F76B0071 tables, you use the Text File Processor program (P007101) to generate the text files that you send to SEFAZ. The Text File Processor program writes data to the Text Processor Header (F007101) and Text Processor Detail Table (F007111). You then copy the data to the medium that you use to submit the files to SEFAZ.

You can access the Text File Processor program from the FCI TXT File Process Blocks program (P76B0070) or from a menu.

16.4.2 Forms Used to Generate the Text Files to Submit to SEFAZ

Form Name Form ID Navigation Usage
Work With Text Batches W007101A Brazil FCI Maintenance (G76BFCI), FCI TXT File Process Blocks

Select a batch, and then select Generate Txt File from the Row menu.

Alternatively, select Text File Processor (G0071), Text File Processor.

Select the batch to process.

16.5 Uploading and Reviewing FCI Numbers Returned by SEFAZ

This section provides an overview of how to upload and review FCI files and discusses how to:

  • Run the Download FCI Return File into Brazil Localization program.

  • Set processing options for Download FCI Return File into Brazil Localization (R76B0072).

16.5.1 Understanding How to Upload and Review FCI Files

After you submit a text file with item information to SEFAZ, SEFAZ sends you a return file that includes the FCI number for the items. You upload the returned file, verify the status of the records in the file, and then upload the FCI numbers to the F76B4101 and F76B4102 tables.

You run the Download FCI Information program (R76B0072) in proof mode to load the file that SEFAZ returns to you to the FCI TXT File Process Header Blocks (F76B0070) and FCI TXT File Process Detail Blocks (F76B0071) tables. You then use the FCI TXT File Process Blocks program (P76B0070) to review the batch data in the R76B0070 and R76B0071 tables. After you are satisfied that the record status and FCI numbers are correct, you run the Download FCI Information program in final mode to add the FCI numbers to the item records in the F76B0070, F76B0071, F76B4101 and F76B4102 tables.

16.5.2 Running the Download FCI Return File into Brazil Localization Program

Select Brazil FCI Maintenance, Download FCI Return File into Brazil Localization.

16.5.3 Setting Processing Options for Download FCI Return File into Brazil Localization (R76B0072)

Processing options enable you to specify default processing values.

16.5.3.1 General

1. Process Mode

Enter 1 to process files in final mode. In final mode, the system writes data to the Tag File F76411 - Item Master table (F76B4101) and the Tag File F76412 - Item Branch table (F76B4102) table. If you leave this processing blank, the system prints the data that you upload from SEFAZ in a PDF file and does not update tables.