## (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.

Register | Description of Contents | Compliance and Occurrence
0000 (Opening file and Contributor Identification) | Includes information about the taxpayer from data stored in the F0101, F76011, and the Ato Cotepe 11 Constant Setup table (F76B0715), and from UDC tables. | This register must be present in the electronic file. One record exists in this register.
0001 (Block zero opening) | Includes information about block 0. This data is based on a fixed value from the F76B0715 table. | This register must be present in the electronic file. One record exists in this register.
0005 (Contributor complementary date) | Includes additional information about the taxpayer from data stored in the F0101, F76011, and F76B0715 tables. | This register is not mandatory. One record exists in this register.
0015 (Substitute contributor) | Includes information about bookkeeping from data stored in the source tables and the F76B0715 table. | Multiple records can exist in this register.
0100 (Accountant) | Includes information about the accountant for the reporting company from the F0101, F76011, and F76B0715 tables. | One record exists in this register.
0150 (Participant data) | Includes information about the suppliers, customers, and consumers from data in the F0101, F76011, and F76B0715 tables, and in UDCs. | Numerous records exist in this register.
0175 (Participant information changes) | Includes address information about suppliers, customers, and consumers from data in the F0101 and F76011 tables. | There is a one-to-one correlation between the records in register 0150 and register 0175.
0190 (Unit of measure) | Includes the unit of measure and unit of measure description from UDC table 00/UM. | Numerous records exist in this register.
0200 (Item code identification) | Includes information about items from the F4101 table. | Numerous records exist in this register.
0205 (Item code changes) | Includes information about item description changes from the F76B0765 table. | Multiple records can exist for each record in register 0200.
0206 (Item coded for combustible) | The JD Edwards EnterpriseOne software does not include data for this register. | The system leaves this register blank.
0220 (Item unit conversion) | Includes information about the unit of measure conversion and factor from the Unit of Measure Standard Conversion table (F41003). | Multiple records can exist in this register for each record in the 0190 register.
0400 (Nature of operation) | Includes the transaction nature for items from the F7615B table. | Numerous records can exist in this register.
0450 (Observation fiscal book) | Includes the transaction nature for fiscal book records based on the Fiscal Message/Observations (76B/M1) UDC table. | Numerous records can exist in this register.
0460 | The JD Edwards EnterpriseOne software does not include data for this register. | The system leaves this register blank.
0999 (End block 0) | Includes information about the block. | This register must be present in the electronic file; the system inserts this register when you run the Ato Cotepe 11 - Block 9 Control & Ending program (R76B0760). One record exists in this register.

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.

Registers | Description | Compliance and Occurrence
C001 (Opening block C) | Includes information about the block. | This register must be present in the electronic file. One record exists in this register.
C100 (Notas fiscais services) | Includes information about electronic notas fiscais (NFe) and notas fiscais for telecommunications services. The information is based on the F7611B F7601B, F76101B, and F76B01TE tables. The system processes records only when a corresponding record exists in register 150 of block 0. | Multiple records can exist for the register.
C110 (Supplemental information) | Includes supplemental information for notas fiscais. The information is based on the F7601B table. The system processes records only when a corresponding record exists in register 450 of block 0. | Multiple records can exist for each record in the C100 register.
C113 (Referenced fiscal document) | Includes information about the fiscal document based on information in the F76101B table. | Multiple records can exist for each record in the C100 register.
C130 (ISSQN, IRRF, and Social Security) | Includes information about the ISSQN, IRRF, and Social Security taxes based on information in the F7611B and F76101B tables. | One record only exists for each record in the C100 register.
C140 (Invoices) | Includes information about invoices based on information in the F7611B and F76101B tables. | One record only exists for each record in the C100 register.
C141 (Invoice due date) | Includes information about the invoice due date based on information in the F7601B and F03B11 tables. | Multiple records can exist in this register for each record in the C140 register.
C160 (Transported volumes) | Includes information based on the F76101B table. The system processes records only when a corresponding record exists in register 150 of block 0. | One record only exists for each record in the C100 register.
C170 (Document details) | Includes information based on the F76111B and F7611B tables. The system processes records only when a corresponding record exists in registers 0190, 0200, and 0400 of block 0. | One record only exists for each record in the C100 register.
C172 (ISSQN operations) | Includes information based on the F76111B and F7611B tables. | Multiple records can exist for each record in the C170 register.
C179 (ST Supplemental information) | Includes information from the F7611B table. | One record only exists for each record in the C170 register.
C190 (Document Analytic Register) | Includes information from the F76111B and F7611B tables. | One record only exists for each record in the C100 register.
C990 (End block C) | Includes information about block C. | This register must be present in the electronic file; the system inserts this register when you run the Ato Cotepe 11 - Block 9 Control & Ending program (R76B0760). One record exists in this register.

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.

Registers | Description | Compliance and Occurrence
E001 (Opening block E) | Includes information about the block. | This register must be present in the electronic file. One record exists in this register.
E100 (Period of verification for ICMS) | Includes information about the reporting period from the setup information. | One record per period exists in this register.
E110 (ICMS tax verification - own operations) | Includes information about ICMS taxes from the F7611B, F7601B, F76101B, and F76B0770 tables. | One record per period exists in this register.
E200 (ICMS tax verification period, tributary substitution) | Includes information about the reporting period from the setup information. | One record per period exists in this register.
E210 (ICMS tax verification, tributary substitution) | Includes information about ICMS taxes from the F7611B, F7601B, F76111B, F76101B, and F76B0770 tables. | One record per period exists in this register.
E500 (IPI tax verification period) | Includes information about the reporting period from the setup information. | One record per period exists in this register.
E510 (IPI values consolidation) | Includes information about IPI taxes from the F76111B, F76101B, and F76B0771 tables. | Multiple records per period exist in this register.
E520 (IPI verification) | Includes information about IPI taxes from the F76111B, F76101B, and F76B0771 tables. | Multiple records per period exist in this register.
E990 (Ending block) | Includes information about block E. | This register must be present in the electronic file; the system inserts this register when you run the Ato Cotepe 11 - Block 9 Control & Ending program (R76B0760). One record exists in this register.

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.

Register | Description | Compliance and Occurrence
H001 (Opening block H) | Includes information about the block. | This register must be present in the electronic file. One record exists in this register.
H005 (Inventory totals) | Includes information about the inventory from the F4112 table. | One record exists in this register.
H010 (Inventory) | Includes information about the inventory quantities of each item for items that appear in block 0. The items must also exist in the F4101 and F4112 tables. | Numerous records can exist in this register.
H020 (Manufactured items) | Includes information about manufactured items and the units of measure based on the F4101 and F3002 tables. The items must also appear in block 0. | Numerous records can exist in this register.
H030 (Part list) | Includes information about the part list based on the F3002 table. The items must also appear in block 0. | Numerous records can exist in this register.
H990 (End block H) | Includes information about block H. | This register must be present in the electronic file; the system inserts this register when you run the Ato Cotepe 11 - Block 9 Control & Ending program (R76B0760). One record exists in this register.

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.

Register | Description | Occurrence and Compliance
9001 | Includes information about the block. | This register must be present in the electronic file. One record exists in this register.
9900 | Includes the totals of the registers of each block in the table. | Multiple records can exist in this register.
9990 | Includes the quantity of records in block 0. | One record exists in this register.
9999 | Includes the total number of lines of the entire output file. | One record exists in this register.