## Appendix: (BRA) Fields for Flat Files for Ato COTEPE 11 of 2007

This appendix discusses:

- Registers and fields for block 0.

- Registers and fields for block C.

- Registers and fields for block D.

- Registers and fields for block E.

- Registers and fields for block H.

- Registers and fields for block 1.

- Registers and fields for block 9.

### Registers and Fields for Block 0

Block 0 includes information about the reporting company. If the value required does not reside in J.D. Edwards OneWorld or JD Edwards EnterpriseOne tables, the Description field shows a value of Blank.

Register Number | Field Number | Field Name | Description
0000 | 1 | REG | Fixed value of 0000.
0000 | 2 | COD_VER | Code of layout version from the Code of Layout Reg Government (76B/VL) UDC table.
0000 | 3 | COD_FIN | File Type. Values are: 0: Original 1: Substitute
0000 | 4 | DT_INI | Begin date of the file from a field that you complete in the Ato Cotepe Administ Process program (P76B0740).
0000 | 5 | DT_FIN | End date of the file from a field that you complete in the Ato Cotepe Administ Process program (P76B0740).
0000 | 6 | NOME | Mailing name from F0111.MLNM.
0000 | 7 | CNPJ | CNPJ number if the reporting entity is a legal entity. From F0101.TAX.
0000 | 8 | CPF | CPF number if the reporting entity is a natural person. From F0101.TAX.
0000 | 9 | UF | State from F0116.ADDS.
0000 | 10 | IE | State tax ID. If the contributor is an individual entity (1, 4, or P) then the word Isento if not, F0101.ABTX2.
0000 | 11 | COD_MUN | City code. The city code associated with the address number in the Supplemental Database program (P00092).
0000 | 12 | IM | Municipal tax ID from F76011.BMUN.
0000 | 13 | SUFRAMA | SUFRAMA number from F76011.BISC.
0000 | 14 | IND_PERFIL | Fiscal presentation type. This field is completed from a value that you enter in the Ato Cotepe 11 Constant Setup program (P76B0715).
0000 | 15 | IND_ATIV | Activity code. Values are: 0: Other 1: Industry This field is completed from a value that you enter in the Ato Cotepe 11 Constant Setup program.
0001 | 1 | REG | Fixed value of 0001.
0001 | 2 | IND_MOV | Movement indicator. Values are: 0: Block with information 1: Block without information
0005 | 1 | REG | Fixed value of 0005.
0005 | 2 | FANTASIA | Mailing name from F0111.MLNM.
0005 | 3 | CEP | Zip code from F0116.ADDZ.
0005 | 4 | END | Mailing address. (F0116.ADD1 + F0116.ADD2)
0005 | 5 | NUM | Blank
0005 | 6 | COMPL | Mailing address. (F0116.ADD3 + F0116.ADD4)
0005 | 7 | BAIRRO | Blank
0005 | 8 | FONE | Phone number. (F0115. PAR1+PH1 when PHTP is blank)
0005 | 9 | FAX | Fax number. (F0115. PAR1 + PH1 when PHTP = FAX)
0005 | 10 | EMAIL | Email address. (F01151.EMAL when AETP = E)
0015 | 1 | REG | Fixed value of 0015.
0015 | 2 | UF_ST | State from F0116.ADDS.
0015 | 3 | IE_ST | State tax ID from F76011.TX2.
0100 | 1 | REG | Fixed value of 0100.
0100 | 2 | NOME | Mailing name from F0111.MLNM. The mailing name of the accountant from F0111.MLNM for the address book number specified in the Ato Cotepe 11 Constant Setup program.
0100 | 3 | CPF | CPF number. The value from F76011.AIBCPF or F0101.TAX for the address book number specified for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 4 | CRC | CRC number. This field is completed from a value that you enter in the Ato Cotepe 11 Constant Setup program.
0100 | 5 | CNPJ | CNPJ number. The value of F0101.TAX for the address book number specified for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 6 | CEP | Zip code. The value of F0116.ADDZ for the address book number specified for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 7 | END | Mailing address. (F0116.ADD1, F0116.ADD2)
0100 | 8 | NUM | Blank
0100 | 9 | COMPL | Mailing address. (F0116.ADD3, F0116.ADD4)
0100 | 10 | BAIRRO | Blank
0100 | 11 | FONE | Phone number. The value of F0115. PAR1 + PH1 when PHTP = blank for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 12 | FAX | Fax number . The value of F0115. PAR1 + PH1 when PHTP = FAX for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 13 | EMAIL | Email address. The value of F01151.EMAL when AETP = E for the accountant in the Ato Cotepe 11 Constant Setup program.
0100 | 14 | COD_MUN | City code. The city code associated with the address book number for the accountant in the Ato Cotepe 11 Constant Setup program as set up in the Supplemental Database program (P0092).
0150 | 1 | REG | Fixed value of 0150.
0150 | 2 | COD_PART | Address number.
0150 | 3 | NOME | Mailing number from F0111.MLNM.
0150 | 4 | COD_PAIS | Country. A value from the NFe IBGE Country Code (76B/CD) UDC table.
0150 | 5 | CNPJ | CNPJ number from F0101.TAX.
0150 | 6 | CPF | CPF number. (F76011.AIBCPF or F0101.TAX)
0150 | 7 | IE | State tax ID. If the contributor is an individual entity (1, 4, or P) then the word Isento, if not F0101.ABTX2.
0150 | 8 | COD_MUN | City, city code. The city code associated with the address book number as set up in the Supplemental Database program (P0092).
0150 | 9 | SUFRAMA | SUFRAMA number from F76011.BISC.
0150 | 10 | END | Mailing address. (F0116.ADD1, F0116.ADD2)
0150 | 11 | NUM | Blank
0150 | 12 | COMPL | Mailing address. (F0116.ADD3, F0116.ADD4)
0150 | 13 | BAIRRO | Blank
0175 | 1 | REG | Fixed value of 0175.
0175 | 2 | DT_ALT | Number of the field in the 0150 register that changed, if the Address by Effective Date constant in the Address Book Constants program (P0000) is enabled; otherwise the field is blank.
0175 | 3 | NR_CAMPO | The new value for the name in the F0016 table, if the Address by Effective Date constant in the Address Book Constants program (P0000) is enabled; otherwise the field is blank.
0175 | 4 | CONT_ANT | The old value from the F0016 table, if the Address by Effective Date constant in the Address Book Constants program (P0000) is enabled; otherwise the field is blank.
0190 | 1 | REG | Fixed value of 0190.
0190 | 2 | UNID | Unit measure code (UDC 00/UM).
0190 | 3 | DESCR | Unit of measure description (UDC 00/UM).
0200 | 1 | REG | Fixed value of 0200.
0200 | 2 | COD_ITEM | Item number. (F4101.ITM / LITM / AITM)
0200 | 3 | DESCR_ITEM | Item description from F4101.DSC1.
0200 | 4 | COD_BARRA | Bar code. Blanks
0200 | 5 | COD_ANT_ITEM | Item number. (F4101.ITM / LITM / AITM)
0200 | 6 | UNID_INV | Stock unit of measure. Access the F4101 table (key LITM or ITM) and retrieve the primary unit of measure (IMUOM1).
0200 | 7 | TIPO_ITEM | Item type from the F704101 table.
0200 | 8 | COD_NCM | Mercosur code from the F704101 table.
0200 | 9 | EX_IPI | Ex code from the F704101 table.
0200 | 10 | CID_GEN | Item generic code from the F704101 table.
0200 | 11 | COD_LST | Service code from the F704101 table.
0205 | 1 | REG | Fixed value of 0205.
0205 | 2 | DESCR_ANT_ITEM | Changed item description from the F76B0765 table.
0205 | 3 | DT_INI | Begin date. This field is completed using a value that you enter in the Ato Cotepe Administ Process program.
0205 | 4 | DT_FIM | End date. This field is completed using a value that you enter in the Ato Cotepe Administ Process program.
0206 | 1 | REG | Fixed value of 0206.
0206 | 2 | COD_COMB | Combustible code. Blank
0220 | 1 | REG | Fixed value of 0220.
0220 | 2 | UNID_CONV | Converted unit of measure. Access the F41003 table and retrieve the converted unit of measure (RUM).
0220 | 3 | FAT_CINV | Conversion factor. Access the F41003 table and retrieve the conversion factor (CONV).
0400 | 1 | REG | Fixed value of 0400.
0400 | 2 | COD_NAT | Transaction nature code. (F7615B.BNOP and BSOP).
0400 | 3 | DESCR_NAT | Transaction nature description from F7615B.DESC.
0450 | 1 | REG | Fixed value of 0450.
0450 | 2 | COD_INF | Observation fiscal book code from UDC 40/PM.
0450 | 3 | TXT | Blank
0460 | 1 | REG | Fixed value of 0460.
0460 | 2 | COD_OBS | Blank
0460 | 3 | TXT | Blank
0990 | 1 | REG | Fixed value of 0990.

### Registers and Fields for Block C

This table includes information about notas fiscais for goods.

The first field of each register (REG) includes the register number. Because the J.D. Edwards OneWorld and JD Edwards EnterpriseOne software populates only the REG field for certain registers, those registers are not included in this table. The registers for which the system populates only the REG field are:

- C111

- C112

- C114

- C115

- C120

- C150

- C165

- C171

- C173–C178

- C195

- C197

- C300

- C310

- C320

- C321

- C400

- C405

- C410

- C420

- C425

- C460

- C470

- C490

- C500

- C510

- C520

- C590

- C600

- C601

- C610

- C620

- C690

- C700

- C790

Register Number | Field Number | Field Name | Description
C001 | 1 | REG | Fixed value of C001.
C001 | 2 | IND_MOV | Movement indicator. Values are: 0: Block with information 1: Block without information
C100 | 1 | REG | Fixed value of C100.
C100 | 2 | IND_OPER | Indicator of operation type. Values from F7611B.BNFS are: 0: Input 1: Output
C100 | 3 | IND_EMIT | Indicator of fiscal document issue. Values are: 0: Owner issue 1: Other
C100 | 4 | COD_PART | Address number (field 2 of register 0150 of block 0 if the document is an input document). The buyer's address if an output document.
C100 | 5 | COD_MOD | Model of the fiscal document. A value from UDC table 76B/CN. Values are: 01: Paper nota fiscal 55: BRNFI-NA 55: BRNFI-SP 22: BRNFI-TE
C100 | 6 | COD_SIT | Nota fiscal situation. A value from UDC table 76B/CI. Values are: 00: Accepted 02: Canceled 04: Denied
C100 | 7 | SER | Fiscal document series. If the nota fiscal is a paper one and the F7601BTE table is empty, then the F7601B.BSER. If the nota fiscal has a legal number in table F7601BTE, then the system uses the series number of the nota fiscal.
C100 | 8 | NUM_DOC | Nota fiscal number. If the nota fiscal is a paper one and the F7601BTE table is empty, then the F7601B.BNNFR. If the nota fiscal has a legal number in table F7601BTE, then the system uses that number.
C100 | 9 | CHV_NFE | Legal NFe key.
C100 | 10 | DT_DOC | Issue date from F7601B.ISSU.
C100 | 11 | DT_E_S | Input or output date. If the nota fiscal is outbound, F7610B.BRADEJ. If the nota fiscal is inbound, F76B101.BRADLJ.
C100 | 12 | VL_DOC | Total amount from F7601B.BVTN.
C100 | 13 | IND_PGTO | Indicator of the payment type. Values are: 0: Immediate 1: Installments 9: Without payment The system completes this field with 1 if the value for the payment terms in the F03B11 and F0401 tables is 1. If the value is not 1, the system leaves this field blank.
C100 | 14 | VL_DESC | Discount amount from F7601B.BDES.
C100 | 15 | VL_ABAT_NT | Free port discount amount from F7601B.BDIZ.
C100 | 16 | VL_MERC | Nota fiscal item amount from F76101B.BRAVAL.
C100 | 17 | IND_FRT | Freight mode. Values from F76B101.FRTH are: 0: Payment by third person 1: Payment by remittent 2: Payment by addressee 9: Without freight
C100 | 18 | VL_FRT | Freight amount from F76101B.BFRT.
C100 | 19 | VL_SEG | Insurance amount from F76101B.BSEG.
C100 | 20 | VL_OUT_DA | Expense amount from F76101B.BDFN.
C100 | 21 | VL_BC_ICMS | ICMS taxable amount from F76101B.BBCL.
C100 | 22 | VL_ICMS | ICMS amount from F76101B.BICM.
C100 | 23 | VL_BC_ST | ICMS substitute taxable amount from F76101B.BBIS.
C100 | 24 | VL_ST | ICMS substitute amount from F76101B.BVIS.
C100 | 25 | VL_IPI | IPI amount from F76101B.BIPI.
C100 | 26 | VL_PIA | PIS amount. For inbound transactions, the value of AA in the F76B0411 table when the value of BRTXTP is 05. For outbound transactions, the value of BRTXA in the F76B001 table when the value of BRTX is 05.
C100 | 27 | VL_COFINS | COFINS amount. For inbound transactions, the value of AA in the F76B0411 table when the value of BRTXTP is 06. For outbound transactions, the value of BRTXA in the F76B001 table when the value of BRTX is 06.
C100 | 28 | VL_PIS_ST | Blank
C100 | 29 | VL_COFINS_ST | Blank
C110 | 1 | REG | Fixed value of C110.
C110 | 2 | COD_INF | Reference code (field 2 from register 0450 of block 0).
C110 | 3 | TXT_COMPL | Complementary reference code. Blank
C113 | 1 | REG | Fixed value of C113.
C113 | 2 | IND_OPER | Indicator of operation type. Values from F7611B.BNFS are: 0: Input 1: Output
C113 | 3 | IND_EMIT | Indicator of fiscal document issue. Values are: 0: Owner issue 1: Other
C113 | 4 | COD_PART | Address number (field 2 of register 0150 of block 0 if the document is an input document). The buyer's address if an output document.
C113 | 5 | COD_MOD | Model of the fiscal document. A value from UDC table 76B/CN. Values are: 01: Paper nota fiscal 55: BRNFI-NA 55: BRNFI-SP 22: BRNFI-TE
C113 | 6 | SER | Fiscal document series. If the nota fiscal is a paper one and the F7601BTE table is empty, then the F7601B.BSER. If the nota fiscal has a legal number in table F7601BTE, then the system uses the series number of the nota fiscal.
C113 | 7 | SUB | Fiscal document subseries. Blank
C113 | 8 | NUM_DOC | Fiscal document number. If the nota fiscal is a paper one and the F7601BTE table is empty, then the F7601B.BNNFR. If the nota fiscal has a legal number in table F7601BTE, then the system uses that number.
C113 | 9 | DT_DOC | Issue date from F7601B.ISSU.
C130 | 1 | REG | Fixed value of C130.
C130 | 2 | VL_SERV_NT | Service not taxable ICMS amount. Blanks
C130 | 3 | VL_BC_ISSQN | ISSQN taxable amount. For inbound transactions, if the value for TXTP in the F76B0401 table is 02, then use F76B0411.BRTXTT. For outbound transactions, F7611B.BBCS.
C130 | 4 | VL_ISSQN | ISSQN amount. For inbound transactions, if the value for TXTP in the F76B0401 table is 02, then use F76B0411.AA For outbound transactions, F7611B.BISS.
C130 | 5 | VL_BC_IRRF | IRRF taxable amount.
C130 | 6 | VL_IRRF | IRRF amount. Inbound transactions: F76B0411.VBAA if the value of BRTXTP is equal to 01 Outbound transactions: F7601B.BIRT.
C130 | 7 | VL_BC_PREV | INSS taxable amount. Inbound nota fiscal: F76B0411.BRTXTT if the value for BRTXTP is 03. Outbound nota fiscal: Blank.
C130 | 8 | VL_PREV | INSS value. Inbound nota fiscal: F76B0411.AA if the value for BRTXTP is 03. Outbound nota fiscal: Blank
C140 | 1 | REG | Fixed value of C140.
C140 | 2 | IND_EMIT | Indicator of invoice issue. Values from F7611B.BNFS are: 0: Owner issue 1: Other
C140 | 3 | IND_TT | Indicator of document type from F7601B.FHDCT. Values are: 00: Duplicata 01: Check 02: Promissória 03: Recibo 99: Outros (descrever)
C140 | 4 | DESC_TIT | Complementary description of the invoice from F03B11.RMK.
C140 | 5 | NUM_TIT | Invoice number from F7601B.BNNF + BSER.
C140 | 6 | QTD_PARC | Quantity of the installments. The number of installment records in the F03B11 for accounts receivable installments, and the number of installment records in the F0401 for accounts payable installments.
C140 | 7 | VL_TIT | Invoice amount from F7601B.BVTN.
C141 | 1 | REG | Fixed value of C141.
C141 | 2 | NUM_PARC | Installment number. For each record written, increment the record number by 1. (Reads the installments in the F03B11 table.)
C141 | 3 | DT_VCTO | Due date from F03B11.DDJ.
C141 | 4 | VL_PARC | Installment amount from F03B11.AG - ADSA.
C160 | 1 | REG | Fixed value of C160.
C160 | 2 | COD_PART | Carrier address number. The value for F7601B.ANCR for the address book number from field 2 in register 0150 in block 0.
C160 | 3 | VEIC_ID | Vehicle identification from F7601B.LICP.
C160 | 4 | QTD_VOL | Volume quantity from F7601B.TOQN.
C160 | 5 | PESO_BRT | Gross weight from F76B01.ITWT.
C160 | 6 | PESO_LIQ | Net weight from F76B0.TOWT.
C170 | 1 | REG | Fixed value of C170.
C170 | 2 | NUM_ITEM | Item line number from F76111B.LNID.
C170 | 3 | COD_ITEM | Item number from F76111B.LITM.
C170 | 4 | DESCR_COMPL | Complementary description of item. Blank
C170 | 5 | QTD | Quantity from F76111B.UORG.
C170 | 6 | UNID | Unit of measure from F76111B.UOM.
C170 | 7 | VL_ITEM | Item amount from F76111B.AEXP.
C170 | 8 | VL_DESC | Discount amount from F76111B.BDES.
C170 | 9 | IND_MOV | Indicator of movement. Values are: 0: Real 1: Symbolic
C170 | 10 | CST_ICMS | State tax situation from F76111B.BST1.
C170 | 11 | CFOP | Transaction nature from F76111B.BRNOP.
C170 | 12 | COD_NAT | Transaction nature (field 2 from register 0400 of block 0).
C170 | 13 | VL_BC_ICMS | ICMS taxable amount from F76111B.BBCL.
C170 | 14 | ALIQ_ICMS | ICMS rate from F76111B.BRAAIC.
C170 | 15 | VL_ICMS | ICMS amount from F76111B.BRAVCI.
C170 | 16 | VL_BC_ICMS_ST | ICMS substitute taxable amount from F76111B.BBIS.
C170 | 17 | ALIQ_ST | ICMS substitute taxable rate. Blanks
C170 | 18 | VL_ICMS_ST | IMCS substitute amount from F76111B.BVIS.
C170 | 19 | IND_APUR | IPI index. Blanks
C170 | 20 | CST_IPI | IPI tax situation from F76111B.BRAITP.
C170 | 21 | COD_ENQ | IPI legal code. Blanks
C170 | 22 | VL_BC_IPI | IPI taxable amount from F76111B.BBTP.
C170 | 23 | ALIQ_IPI | IPI rate from F76111B.BRAAIP.
C170 | 24 | VL_IPI | IPI amount from F76111B.BRBIPI.
C170 | 25 | CST_PIS | PIS tax situation. Value of 03.
C170 | 26 | VL_BC_PIS | PIS taxable amount. For outbound transactions, F76B001.BRTXB. For inbound transactions, F76B0411.BRTXTT.
C170 | 27 | ALIQ_PIS | PIS rate. Inbound nota fiscal: F76B0411.BRALQ if the value for BRTXTP is 05. Outbound nota fiscal: If the value of BRTX is 05 in the F76B001 table, use BRTXB or BRTXB multiplied by 100.
C170 | 28 | QUANT_BC_PIS | PIS quantity. Blanks
C170 | 29 | ALIQ_PIS | PIS rate in money. Blanks
C170 | 30 | VL_PIS | PIS amount. Inbound nota fiscal: F76B0411.AA if the value of BRTXTP is 05. Outbound nota fiscal: F76B001.BRTXA if the value of BRTX is 05.
C170 | 31 | CST_COFINS | Cofins tax situation. Value of 03.
C170 | 32 | VL_BC_COFINS | Cofins tax amount. For outbound transactions, F76B001.BRTXB. For inbound transactions, F76B0411.BRTXTT.
C170 | 33 | ALIQ_COFINS | Cofins rate. Inbound nota fiscal: F76B0411.BRALQ if the value of BRTXTP is 06. Outbound nota fiscal: F76B001.BRTXA if the value of BRTX is 06.
C170 | 34 | QUANT_BC_COFINS | Cofins quantity. Blanks
C170 | 35 | ALIQ_COFINS | Cofins rate. Blanks
C170 | 36 | VL_COFINS | Cofins amount. Inbound nota fiscal: F76B0411.AA if the value of BRTXTP is 06. Outbound nota fiscal: F76B001.BRTXA if the value of BRTX is 06.
C170 | 37 | COD_CTA | Account number. Blanks
C172 | 1 | REG | Fixed value of C172.
C172 | 2 | VL_BC_ISSQN | ISSQN taxable amount. For inbound transactions, if the value of TXTP in the F76B0401 table is 02, use F76B0411.BRTXTT. For outbound transactions, F7611B.BBCS.
C172 | 3 | ALIQ_ISSQN | ISS tax amount. For inbound transactions, F76B0411.BRALQ. For outbound transactions, F7611B.TXR3.
C172 | 4 | VL_ISSQN | ISSQN amount. For inbound transactions, F76B0411.AA. For outbound transactions, F7611B.BISS.
C179 | 1 | REG | Fixed value of C179.
C179 | 2 | BC_ST_ORIG_DEST | Taxable base for ICMS ST from F7611B.BBIS.
C179 | 3 | ICMS_ST_REP | ICMS ST amount from F7611B.BVIS.
C179 | 4 | ICMS_ST_COMPL | ICMS ST. Blanks
C179 | 5 | BC_RET | Taxable base for ICMS withholding. Blanks
C179 | 6 | ICMS_RET | ICMS ST withholding. Blanks
C190 | 1 | REG | Fixed value of C190.
C190 | 2 | CST_ICMS | State tax situation from F76111B.BST1.
C190 | 3 | CFOP | Transaction nature from F76111B.BRNOP.
C190 | 4 | ALIQ_ICMS | ICMS rate from F76111B.BRAAIC.
C190 | 5 | VL_OPR | Transaction amount. F76111B: AEXP + BVIS + BIPI + BRATDF − BDIS − BDES
C190 | 6 | VL_BC_IMCS | ICMS taxable amount from F76111B,BBCL.
C190 | 7 | VL_ICMS | ICMS amount from F76111B.BRAVCI.
C190 | 8 | VL_BC_ICMS_ST | ICMS substitute taxable amount form F76111B.BBIS.
C190 | 9 | VL_ICMS_ST | ICMS substitute tax from F76111B.BVIS.
C190 | 10 | VL_RED_BC | Reduced taxable amount. Blanks
C190 | 11 | VL_IPI | IPI amount from F76111B.BRBIPI.
C990 | 1 | REG | Fixed value of C990.
C990 | 2 | QTD_LIN_C | Quantity of lines in block C.

### Registers and Fields for Block D

The J.D. Edwards OneWorld and JD Edwards EnterpriseOne systems generate block D and block D registers, but populate only the REG fields of the registers. You must populate the other required fields in block D by running custom programming. Add your custom programs to the sequence that you set up in the Ato Cotepe Block Setup program (P76B0730).

### Registers and Fields for Block E

Block E includes information about IPI and ICMS taxes. Not all of the information required in this block resides in the J.D. Edwards OneWorld and JD Edwards EnterpriseOne tables. This section lists only the fields that are populated from the J.D. Edwards OneWorld and JD Edwards EnterpriseOne tables.

The first field of each register (REG) includes the register number. Because the J.D. Edwards OneWorld and JD Edwards EnterpriseOne software populates only the REG field for certain registers, those registers are not included in the table below. The registers for which the system populates only the REG field are:

- E111

- E112

- E113

- E115

- E116

- E220

- E230

- E240

- E250

- E530

Register | Field Number | Field Name | Description
E001 | 1 | REG | Fixed value of E001.
E001 | 2 | IND_MOV | Movement indicator. Values are: 0: Block with information 1: Block without information
E100 | 1 | REG | Fixed value of E100.
E100 | 2 | DT_INI | Verification start date from a value that you enter in the Ato Cotepe Administ Process program.
E100 | 3 | DT_FIN | Verification end date from a value that you enter in the Ato Cotepe Administ Process program.
E110 | 1 | REG | Fixed value of E110.
E110 | 2 | VL_TOT_DEBITOS | Total debit amount. For inbound notas fiscais, F7611B.BNFS. For inbound notas fiscais, if the nota fiscal is within the date range as determined by F76101B.BRADLJ, sum F76101B.BICM.
E110 | 3 | VL_AJ_DEBITOS | Total debit adjustment amount. Blanks
E110 | 4 | VL_TOT_AJ_DEBITOS | Total debit adjustment. Blanks
E110 | 5 | VL_ESTORNOS_CRED | Total adjustments for debit reversions. Blanks
E110 | 6 | VL_TOT_CREDITOS | Total credit amount. For outbound notas fiscais, F7611B.BNFS. For inbound notas fiscais, if the nota fiscal is within the date range as determined by F76101B.BRADLJ, sum F76101B.BICM.
E110 | 7 | VL_AJ_CREDITOS | Total credit adjustment amount. Blanks
E110 | 8 | VL_TOT_AJ_CREDITOS | Total credit adjustment. Blanks
E110 | 9 | VL_ESTORNOS_DEB | Total adjustments for credit reversions. Blanks
E110 | 10 | VL_SLD_CREDOR_ANT | ICMS credit balance at the beginning of the period.
E110 | 11 | VL-SLD_APURADO | Balance due. Sum fields: 02 +03+04+05−06−07−08−09−10
E110 | 12 | VL_TOT_DED | Deduction amounts. Blank
E110 | 13 | VL_ICMS_RECOLHER | Net amount. The value in field 11 minus the value in field 12.
E110 | 14 | VL_SLD_CREDOR_TRANSPORT_AR | ICMS credit balance to transfer to next period. The system completes this field when the net amount is in favor to the contributor.
E110 | 15 | DEB_ESP | ICMS amount to pay The system completes this field when the net amount is in favor to the fiscal authority.
E200 | 1 | REG | Fixed value of E200.
E200 | 2 | DT_INI | Verification begin date from a value that you enter in the Ato Cotepe Block Setup program.
E200 | 3 | DT_FIN | Verification end date from a value that you enter in the Ato Cotepe Block Setup program.
E210 | 1 | REG | Fixed value of E210.
E210 | 2 | UF | State from F76101B. BRAUFE.
E210 | 3 | IND_MOD_ST | Movement indicator. Values are: 0: without ICMS ST 1: with ICMS ST
E210 | 4 | VL_SLD_CRED_ANT_ST | ICMS substitute tax balance before the period from F76B0770.B76ICST.
E210 | 5 | VL_DEVOL_ST | Total ICMS substitute tax by returned goods. Blanks
E210 | 6 | VL_RESSARC_ST | Total ICMS substitute tax by indemnity. Blanks
E210 | 7 | VL_OUT_CRED_ST | Total credit substitute tax. For outbound notas fiscais, F7611B.BNFS. For inbound notas fiscais, F76111B.BVIS.
E210 | 8 | VL_AJ_CREDITOS_ST | Total credit ICMS substitute tax by adjustments. Blanks
E210 | 9 | VL_RETENÇAO_ST | Total ICMS substitute tax withheld. Blanks
E210 | 10 | VL_OUT_DEB_ST | Total debit substitute tax. For outbound notas fiscais, F7611B.BNFS. For inbound notas fiscais, F76111B.BVIS.
E210 | 11 | VL_AJ_DEBITOS_ST | Total debit ICMS substitute tax by adjustments. Blanks
E210 | 12 | VL_SLD_DEV_ANT_ST | ICMS substitute tax to pay before deductions. Sum of fields: [(09+10+11) − (04+05+06+07+08)].
E210 | 13 | VL_DEDUÇŐES_ST | ICMS substitute tax deduction. Blanks
E210 | 14 | VL_ICMS_RECOL_ST | Amount to pay. The value of field 12 minus the value of field 13.
E210 | 15 | VL_SLD_CRED_ST_TRANSFORTAR | ICMS substitute tax credit balance to transfer to next period. Sum of fields: [(04+05+06+07+08) − (09+10+11)].
E500 | 1 | REG | Fixed value of E500.
E500 | 2 | IND_APUR | Period indicator. Value is always 0.
E500 | 3 | DT_INI | Verification begin date. From a value that you set up in the Ato Cotepe Block Setup program.
E500 | 4 | DT_FIN | Verification end date. From a value that you set up in the Ato Cotepe Block Setup program.
E510 | 1 | REG | Fixed value of E510.
E510 | 2 | CFOP | Transaction nature from F76111B.BRNOP.
E510 | 3 | CST_IPI | IPI tax situation from F76111B.BRAITP.
E510 | 4 | VL_CONT_IPI | Accounting amount by CFOP and CTIPI. The sum of the values: F76111B.AEXP − F76111B.BDES.
E510 | 5 | VL_BC_IPI | IPI taxable amount by CFOP and CTIPI from F76111B.BBTP.
E510 | 6 | VL_IPI | IPI amount by CFOP and CTIPI from F76111B.BRBIPI.
E520 | 1 | REG | Fixed value of E510.
E520 | 2 | VL_SD_ANT_IPI | IPI credit balance before the period from F76B771.IPIT.
E520 | 3 | VL_DEB_IPI | Total debit amount output with debit tax. Blank
E520 | 4 | VL_CRED_IPI | Total amount input with credit tax. Blank
E520 | 5 | VL_OD_IPI | Total amount other debit. Blank
E520 | 6 | VL_OC_IPI | Total amount other credit. Blank
E520 | 7 | VL_SC_IPI | IPI credit balance to transfer to next period. Blank
E520 | 8 | VL_SD_IPI | IPI amount to pay. Blank
E990 | 1 | REG | Fixed value of E990.
E990 | 2 | QTD_LIN_E | Quantity of lines in block E.

### Registers and Fields for Block H

Block H includes information about inventory.

Register | Field Number | Field Name | Description
H001 | 1 | REG | Fixed value of H001.
H001 | 2 | IND_MOV | Movement indicator. Values are: 0: Block with information 1: Block without information
H005 | 1 | REG | Fixed value of H005.
H005 | 2 | DT_INV | Inventory date.
H005 | 3 | VL_INV | Inventory total amount. Total stock from the F4111 table.
H010 | 1 | REG | Fixed value of H010.
H010 | 2 | COD_ITEM | Item number. Field 02 of the register 0200 in block 0.
H010 | 3 | UNID | Unit value from F4111.TRUM.
H010 | 4 | QTD | Quantity from F4111.TRQT.
H010 | 5 | VL_UNIT | Unit value from F4111.UNCS.
H010 | 6 | VL_ITEM | Item amount from F4111.PAID.
H010 | 7 | IND_PROP | Indicator of inventory owner from a value that you enter in the Ato Cotepe Constant Setup program (P76B0715).
H010 | 8 | COD_PART | Address number of the inventory owner from field 2 of the register 0150 for block 0.
H010 | 9 | COD_OBS | Fiscal observation code. Blanks
H010 | 10 | COD_CTA | Description. Blanks
H020 | 1 | REG | Fixed value of H020.
H020 | 2 | COD_ITEM | Item number. F4101.ITM / LITM / AITM
H020 | 3 | UNID | Unit of measure from F4101.IMUOM1.
H030 | 1 | REG | Fixed value of H030.
H030 | 2 | COD_ITEM | Item number. F4101.ITM / LITM / AITM
H030 | 3 | QTD | Quantity from F3002.QNTY.
H030 | 4 | UNID | Unit of measure from F3002.UM.
H030 | 5 | PERDA | Percentage waste. Blanks
H030 | 6 | DT_INI | Begin date from F3002.EFFF.
H030 | 7 | DT_FIN | End date from F3002.EFFT.
H990 | 1 | REG | Fixed value of H990.
H990 | 2 | QTD_LIN_H | Quantity of lines in block H.

### Registers and Fields for Block 1

The J.D. Edwards OneWorld and JD Edwards EnterpriseOne systems generate block 1 and block 1 registers, but populate only the REG fields of the registers. You must populate the other required fields in block 1 by running custom programming. Add your custom programs to the sequence that you set up in the Ato Cotepe Block Setup program.

### Registers and Fields for Block 9

Block 9 controls how the other blocks are joined and includes information about the number of records in the blocks.

Register | Field Number | Field Name | Description
9001 | 1 | REG | Fixed value of 9001.
9001 | 2 | IND_MOV | Movement indicator. Values are: 0: Block with information 1: Block without information
9900 | 1 | REG | Fixed value of 9900.
9900 | 2 | REG_BLC | Record code.
9900 | 3 | QTD_REG_BLC | Quantity of records in the block described in the previous field.
9990 | 1 | REG | Fixed value of 9990.
9990 | 2 | QTD_LIN_9 | Quantity of records for block 9.
9999 | 1 | REG | Fixed value of 9999.
9999 | 2 | QTD_LIN | Quantity of lines in the file.