(BRA) Understanding Blocks, Registers, and Records for Ato COTEPE 11 of 2007

This chapter provides overviews of:

• Block 0 registers and records.

• Block C registers and records.

• Block D register and records.

• Block E registers and records.

• Block H registers and records.

• Block 1 registers and records.

• Block 9 registers and records.

Block 0 Registers and Records for Ato COTEPE 11 of 2007

You generate block 0 registers and records to provide opening, identification, and reference information for the electronic files that you submit for tax reporting. Multiple programs exist to populate the records for block 0. You must run all of the programs for block 0 before running the programs for any of the other blocks.

Important! The JD Edwards EnterpriseOne system generate records for only the registers and fields listed in this section. Data for other Block 0 registers and fields does not reside in the JD Edwards EnterpriseOne system. You must populate the registers that require non-JD Edwards EnterpriseOne data in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors.

Note. The Address by Effective Date constant in the Address Book Constants program (P0000) must be enabled before the system can track the address book changes as required for Ato COTEPE 11 of 2007.

Source Tables

The system uses these source tables for data for the block 0 process:

• Who's Who (F0111).

• Address Book Master (F0101).

• Address by Date (F0116).

• Address Book - Phone Numbers (F0015).

• Address Book Brazilian Tag Table (F76011).

• Supplemental Data (F00092).

• Item Master (F4101).

• Unit of Measure Standard Conversion (F41003).

• Transaction Nature (F7615B).

• Generic Item Master Add Info (F704101).

  The system populates this table when you use the Item Master Additional Info program (P704101) to add additional item master information.

• Item Track Change (F76B0765).

  The system populates this table when you use the Item Master program (P4101) to make changes to item descriptions when the localization code for your user ID is set to BR (Brazil).

Output Tables

Output tables for the block 0 process are:

• Address Book Brazilian Work File (F76B0520).

  This table is the input table for all participant information used for other blocks.

• Item Master Brazilian Work File (F76B0521).

  This table is the input table for all item information used for other blocks.

• Transaction Nature Brazilian Work File (F76B0522).

  This table is the input table for all transactions nature information used for other blocks.

• Observation Fiscal Brazilian Work File (F76B0523).

  This table is the input table for all observation information for notas fiscais used for other blocks.

• Ato Cotepe Process (F76B0740).

  This header table is used as one of the input tables when you generate blocks and registers.

• Electronic Reporting Processing Details (F76B0511).

  This detail table is used as one of the input tables when you generate blocks and registers.

Contents of Block 0 Registers

The system writes records for block 0 to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.

Ato Cotepe 11 - Block 0 Address Book (R76B0700)

The system generates these registers for block 0 when you run the Ato Cotepe 11 - Block 0 Address Book program:

• 0000 (Opening file and contributor identification)

• 0001 (Opening Block 0)

• 0005 (Contributor complementary date)

• 0015 (Substitute Contributor)

• 0100 (Accountant information)

• 0150 (Participant information)

• 0175 (Participant information changes)

The Ato Cotepe 11 - Block 0 Address Book program uses the Address by Effective Date standard functionality to determine the address book records to report. If there are modifications within the reporting date range, the system writes the address book information to register 0175 of block 0.

The Ato Cotepe 11 - Block 0 Address Book program also generates a report that includes the fields of each processed register. A status column shows whether the records were successfully processed, and gives details of any issues found. The report also includes a totals section that shows the quantity of registers successfully processed and the quantity that were not successfully processed.

Note. The COD_PART field of register 150 is completed with the address book number. The COD_MUN field in registers 000, 0010, and 0150 is completed from the Fiscal Code (76B/FC) UDC table, as set up in the Supplemental Database program (P00092).

See Setting Up the Fiscal City Code.

See (BRA) Fields for Flat Files for Ato COTEPE 11 of 2007.

Ato Cotepe 11 - Block 0 Items (R76B0701)

The system generates these registers for block 0 when you run the Ato Cotepe 11 - Block 0 Items program:

• 0190 (Unit of measure)

• 0200 (Item code identification)

• 0205 (Item code changes)

• 0206 (Item code for combustible)

• 0220 (Item unit conversion)

The Ato Cotepe 11 - Block 0 Items program includes in the 0200 register the additional item master information if you enter the additional information in the Generic Item Master Add Info program (P704101). You associate category codes to items in the Generic Item Master Add Info program to include this additional information in the Generic Item Master Add Info table (F704101):

• Item type

• Mercosur code

• EX code according TIPI

• Item generic code

• Service code

The Item Master program (P4101) includes a localization to track changes to item descriptions. When you use the Item Master program to modify a description, the system calls the localization to write a record to the Item Track Change table (F76B0765) with information about the description change and the effective date of the change. The Ato Cotepe 11 - Block 0 Items program reads the F76B0765 table and writes data about the changes to register 0205 of block 0.

The report printed by the Ato Cotepe 11 - Block 0 Items program shows the information included for the fields of each processed register. It also shows which records were successfully processed, and the quantity of registers successfully or non-successfully processed.

Note. The COD_ITEM field in register 0200 is populated from the first, second, and third item number from the F4101 table.

Ato Cotepe 11 - Block 0 Transaction Nature (R76B0702)

The system generates the 0400 (Nature operation) register for block 0 when you run the Ato Cotepe 11 - Block 0 Transaction Nature program. You can set data selection for this report.

The report printed by the Ato Cotepe 11 - Block 0 Transaction Nature program shows the information included for the fields of each processed register. It also shows which records were successfully processed, and the quantity of registers successfully or non-successfully processed.

Ato Cotepe 11 - Block 0 Observation Fiscal Books (R76B0703)

The system generates these registers for block 0 when you run the Ato Cotepe 11 - Block 0 Observation Fiscal Books program:

• 0450 (Fiscal complementary information)

• 0460 (Observation fiscal book)

• 0999 (End block 0)

The report printed by the Ato Cotepe 11 - Block 0 Observation Fiscal Books program shows the information included for the fields of each processed register. It also shows which records were successfully processed, and the quantity of registers successfully or non-successfully processed.

Block C Registers and Records for Ato COTEPE 11 of 2007

You generate block C registers and records to report on notas fiscais for goods. The system processes records for goods for which records exist in block 0.

Important! The J.D. Edwards OneWorld and JD Edwards EnterpriseOne systems do not generate records for registers C111, C112, C114, C115, C120, C150, C165, C171, C173–C178, and C190–C790. Data for those registers does not reside in J.D. Edwards OneWorld or JD Edwards EnterpriseOne tables. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors.

Source Tables

The system uses these source tables for data for the block C process:

• Nota Fiscal Header - Brazil (F7601B)

• Nota Fiscal Detail - Brazil (F7611B)

• Nota Fiscal Header (Fiscal Books) (F76101B)

• Nota Fiscal Detail (Fiscal Books) (F76111B)

• Accounts Payable Ledger (F0411)

• Voucher Additional Information (F76B0411)

• Nota Fiscal Taxes Header (F76B001)

• Customer Ledger (F03B11)

• NFe Header (F76B01TE)

Output Tables

Output tables for the block C process are:

• Ato Cotepe Process (F76B0740)

• Electronic Reporting Processing Details (F76B0511)

Contents of Block C Registers

The system writes records for block C to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.

Ato Cotepe 11 - Block C – Fiscal Document I – Goods (R76B0710)

The system generates the supported registers for block C when you run the Ato Cotepe 11 - Block C Fiscal Document I – Goods program. The system also generates a report that you use to verify the data generated. Because the information in block C is extensive, the report includes the most relevant information, whether registers were successfully generated, and the errors in the registers, if any. If an error exists, the system does not include any of the related records for the register. For example, if a register includes details about the records in another register, the system does not populate the fields for either register if an error exists for one or the other register. You can correct errors and rerun the report as many times as necessary to complete the file generation with no errors.

The Ato Cotepe 11 - Block C Fiscal Document I – Goods program includes a processing option that enables you to specify how the system displays column titles in the report.

Block D Registers and Records for Ato COTEPE 11 of 2007

You generate block D registers and records to report on notas fiscais for services. The system generates the registers, but leaves all of the records blank, except that the system completes the first field (REG) of each register with the register number. Additionally, the system completes the second field of the D001 register with a value of 1 (no information in the block).

Block E Registers and Records for Ato COTEPE 11 of 2007

You generate block E registers and records to report on Imposto sobre Circulação de Mercadorias e Serviços (ICMS) and Imposto sobre Produtos Industrializados (IPI) information included in your fiscal books. The system processes records for items for which records exist in block 0.

Important! The J.D. Edwards OneWorld and JD Edwards EnterpriseOne systems do not generate records for registers E111–E116, E220–E250, and E530. Data for those registers does not reside in J.D. Edwards OneWorld and JD Edwards EnterpriseOne tables. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors.

Source Tables

The system uses these tables for source data for the block E process:

• Nota Fiscal Header - Brazil (F7601B).

• Nota Fiscal Detail - Brazil (F7611B).

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

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

• Address Book Brazilian Work File (F76B0520).

• Item Master Brazilian Work File (F76B0521).

• Transaction Nature WF Block 0 (F76B0522).

• Observation Fiscal Brazilian WF Block 0 (F76B0523).

• ICMS Period Balance for State/Company (F76B0770).

• IPI Period Balance by Company (F76B0771).

Output Tables

This table shows the J.D. Edwards OneWorld or JD Edwards EnterpriseOne output tables and data items for the block E process:

• Ato Cotepe Process (F76B0740)

• Electronic Reporting Processing Details (F76B0511)

Contents of Block E Registers

The system writes records for block E to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.

Ato Cotepe 11 - Block E - IPI/ICMS Tax Verification (R76B0730)

The system generates the supported registers for block E when you run the Ato Cotepe 11 - Block E - IPI/ICMS Tax Verification program. The system also generates a report that you use to verify the data generated. Because the information in Block E is extensive, the report includes the most relevant information, whether registers were successfully generated, and the errors in the registers, if any. If an error exists, the system does not include any of the related records for the register. For example, if a register includes details about the records in another register, the system does not populate the fields for either register if an error exists for one or the other register. You can correct errors and rerun the report as many times as necessary to complete the file generation with no errors.

The Ato Cotepe 11 - Block E - IPI/ICMS Tax Verification program completes the E110, E210, and E520 registers with the ICMS and IPI balances to carry forward to the next period only when you use the ICMS Period Balance Maintenance (P76B0070) and IPI Period Balance Maintenance (P76B0771) programs to specify the amounts to include in the report. The program also updates the F76B0770 and F76B0771 tables for each period with the new calculated amounts of the IPI/ICMS balance to transfer to the next period.

See Setting Up the ICMS Period Balance Amounts

See Setting Up the IPI Period Balance Amounts

The Block E - IPI/ICMS Tax Verification program includes a processing option that enables you to specify how the system displays column titles.

Block H Registers and Records for Ato COTEPE 11 of 2007

You generate block H registers and records to process information related to physical inventory and inventory control. The system processes records for items for which records exist in block 0.

Source Tables

The system uses these source tables for the block H process:

• Item Master (F4101)

• Item ASOF File (F4112)

• Bill of Material Master File (F3002)

• Item Master WF Block 0 (F76B521)

Output Tables

The system writes records to these tables for the block H process:

• Ato Cotepe Process (F76B0740)

• Electronic Reporting Process Detail (F76B0511)

Contents of Block H Registers

The system writes records for block H to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.

Ato Cotepe 11 - Block H Inventory (R76B0740)

The Ato Cotepe 11 - Block H Inventory program populates the work tables with data about inventory, manufactured items, and parts lists. It also generates a report that includes the data for the fields in the registers and a status column to show whether the record was successfully processed.

The system includes in block H only the items that are listed in field 2 (COD_ITEM) of register 0200 in block 0. Additionally, field 2 (COD_PART) of register 0150 in block 0 must include the address book number of the company for which you report the data. If the COD_PART and COD_ITEM fields do not include values, the system does not process records for block H; instead the system issues an error message.

Because block H registers are based, in part, on the Item ASOF File table (F4112), you must run the As Of Updating program (R41548) and Item Ledger - As Of Record Generation program (R41542) before you process block H. The H020 and H030 registers include only active part list items as specified in the beginning and ending dates that you specify in the processing options for the Ato Cotepe Administ Process program (P76B0760).

Block 1 Registers and Records for Ato COTEPE 11 of 2007

You generate block 1 registers and records to report on other required information. The system generates the registers, but leaves all of the records blank, except that the system completes the first field (REG) of each register with the register number. Additionally, the system completes the second field of the 1001 register with a value of 1 (no information in the block).

Block 9 Registers and Records for Ato COTEPE 11 of 2007

The Ato Cotepe 11 - Block 9 Control and Join program (R76B0760) is the last process that you run to report taxes as required by Ato COTEPE 11 of 2007. The Ato Cotepe 11 - Block 9 Control and Join program calculates the number of records in each block and writes that information in the ending register of each block. The Ato Cotepe 11 - Block 9 Control and Join program also generates and populates the block 9 registers.

Source Tables

The Ato Cotepe 11 - Block 9 Control and Join program reads records from these work tables:

• Ato Cotepe Process (F76B0740)

• Electronic Reporting Process Detail (F76B0511)

Output Tables

The Ato Cotepe 11 - Block 9 Control and Join program writes data to these tables:

• Text Processor Header (F007101)

• Text Processor Detail Table (F007111)

After the system populates the F007101 and F007111 tables, you use the Text File Processor program (P007101) to copy the data to the media that you send to the government.

Contents of Block 9 Registers

The system writes records for block 9 to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.