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.
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 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 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. |
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. |
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).
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. |
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. |
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.
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. |