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

This appendix discusses:

Click to jump to parent topicRegisters 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.

Click to jump to parent topicRegisters 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:

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.

Click to jump to parent topicRegisters 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).

Click to jump to parent topicRegisters 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:

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.

Click to jump to parent topicRegisters 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.

Click to jump to parent topicRegisters 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.

Click to jump to parent topicRegisters 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.