Registers and Fields for Block 0
Block 0 includes information about the reporting company. If the required value is not in JD Edwards EnterpriseOne tables, the system leaves the Description field blank.
Register Number |
Field Number |
Field Name |
Description |
---|---|---|---|
0000 |
1 |
REG |
Fixed value of 0000. |
0000 |
2 |
COD_VER |
Code of layout version, according to reference table 3.1.1 |
0000 |
3 |
COD_FIN |
File Type. Values are: 0: Original 1: Substitute |
0000 |
4 |
DT_INI |
Begin date of the file. |
0000 |
5 |
DT_FIN |
End date of the file. |
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). The code must be from city table (www.ibge.gov.br). |
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 Fiscal Presentation Type field in SPED Fiscal 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 Activity Code field in the SPED Fiscal Constant Setup program. |
0001 |
1 |
REG |
Fixed value of 0001. |
0001 |
2 |
IND_MOV |
Movement indicator. This field indicates if the block has information in the file. 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, as defined in a processing option. |
0005 |
5 |
NUM |
Mailing address, as defined in a processing option. |
0005 |
6 |
COMPL |
Mailing address, as defined in a processing option. |
0005 |
7 |
BAIRRO |
CIF data $N description of UDC 76B/NE |
0005 |
8 |
FONE |
Phone number. The system concatenates F0115. PAR1 and F0115.PH1 when PHTP is blank. |
0005 |
9 |
FAX |
Fax number. (F0115. PAR1 + PH1 when PHTP = FAX) |
0005 |
10 |
E-mail 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 SPED Fiscal 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 SPED Fiscal Constant Setup program. |
0100 |
4 |
CRC |
CRC number. This system retrieves this value from the Address Book Inscriptions table (F76B140) with Inscription Code equal to 30. |
0100 |
5 |
CNPJ |
CNPJ number. The value of F0101.TAX for the address book number specified for the accountant in the SPED Fiscal Constant Setup program. |
0100 |
6 |
CEP |
Zip code. The value of F0116.ADDZ for the address book number specified for the accountant in the SPED Fiscal Constant Setup program. |
0100 |
7 |
END |
Mailing address, as defined in a processing option. |
0100 |
8 |
NUM |
Mailing address, as defined in a processing option. |
0100 |
9 |
COMPL |
Mailing address, as defined in a processing option. |
0100 |
10 |
BAIRRO |
CIF data $N description of UDC 76B/NE |
0100 |
11 |
FONE |
Phone number. The value of F0115. PAR1 + PH1 when PHTP is blank for the accountant in the SPED Fiscal Constant Setup program. |
0100 |
12 |
FAX |
Fax number. The value of F0115. PAR1 + PH1 when PHTP equals FAX for the accountant in the SPED Fiscal Constant Setup program. |
0100 |
13 |
E-mail address. The value of F01151.EMAL when AETP equals E for the accountant in the SPED Fiscal Constant Setup program. |
|
0100 |
14 |
COD_MUN |
City code. The city code associated with the address book number for the accountant in the SPED Fiscal 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 from F0116.CTR 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 from 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 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, as defined in a processing option. |
0150 |
11 |
NUM |
Mailing address, as defined in a processing option. |
0150 |
12 |
COMPL |
Mailing address, as defined in a processing option. |
0150 |
13 |
BAIRRO |
CIF data $N description of UDC 76B/NE |
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 from UDC 00/UM. |
0190 |
3 |
DESCR |
Unit of measure description from 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. When the value of AN8 is 0 and XRT is UP in the F4104 table, write the value from the CITM.F7611B. |
0200 |
5 |
COD_ANT_ITEM |
Item number. The system leaves this field blank. |
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 UDC 70/01 table. |
0200 |
8 |
COD_NCM |
Mercosur code from the UDC 70/02 table. |
0200 |
9 |
EX_IPI |
Ex code from the UDC 70/03 table. |
0200 |
10 |
COD_GEN |
Item generic code from the UDC 70/04 table. |
0200 |
11 |
COD_LST |
Service code from the UDC 70/05 table. |
0200 |
12 |
ALIQ_ICMS |
Uses the item master number, the company mark up level (AC30 of the company address book) and the state of the company (state field of address book company) to access to the F7608B table then recover the F7608B.TXRL. Uses only state from to access the F7608B, The states always in blanks. |
0205 |
1 |
REG |
Fixed value of 0205. |
0205 |
2 |
DESCR_ANT_ITEM |
Description from the F4101.DSC1 table. |
0205 |
3 |
DT_INI |
Begin date. View item changes in the F76B0765 table. This field is completed using a value that you enter in the SPED Fiscal Administ Process program. |
0205 |
4 |
DT_FIM |
End date. View item changes in the F76B0765 table. This field is completed using a value that you enter in the SPED Fiscal Administ Process program. |
0205 |
5 |
COD_ANT_ITEM |
Item code of the last item The system leaves this field blank. |
0206 |
1 |
REG |
Fixed value of 0206. |
0206 |
2 |
COD_COMB |
Combustible code. The system leaves this field 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_CONV |
Conversion factor. Access the F41003 table and retrieve the conversion factor (CONV). |
0300 |
1 |
REG |
Fixed value of 0300. |
0300 |
2 |
COD_IND_BEM |
Fixed asset number from F1201.FLANUMB |
0300 |
3 |
IDENT_MERC |
Fixed asset type. Values are: 1: Fixed asset 2: Component Retrieve F1201.FANUMB and F1201.FAAAID. If they are equal, it is a fixed asset. If they are different, it is a component. |
0300 |
4 |
DESCR_ITEM |
Fixed asset description from F1201.FADL01. |
0300 |
5 |
COD_PRNC |
Principal fixed asset number from the F1201.FAAAID when item 3 is equal to 2. |
0300 |
6 |
COD_CTA |
GL account for fixed asset from F1201.FAAMCU.FAAOBJ.FAASUB |
0300 |
7 |
NR_PARC |
Number of quotes. The system leaves this field blank. |
0305 |
1 |
REG |
Fixed value of 0305. |
0305 |
2 |
COD_CCUS |
Cost center from F1201.FALOC. |
0305 |
3 |
FUNC |
Asset functionalityfrom the supplermental database. |
0305 |
4 |
VIDA_UTIL |
Asset life from F1202.FLADLM. First record found in ledger AA. |
0400 |
1 |
REG |
Fixed value of 0400. |
0400 |
2 |
COD_NAT |
Transaction nature code from F7615B.tnbnop and tnbsop. |
0400 |
3 |
DESCR_NAT |
Transaction nature description from F7615B.tndesc. |
0450 |
1 |
REG |
Fixed value of 0450. |
0450 |
2 |
COD_INF |
Observation fiscal book code from UDC 40/PM. |
0450 |
3 |
TXT |
Description of 0450- COD_INF |
0460 |
1 |
REG |
Fixed value of 0460. |
0460 |
2 |
COD_OBS |
Fiscal observation code. The system leaves this field blank. |
0460 |
3 |
TXT |
Description The system leaves this field blank. |
0500 |
1 |
REG |
Fixed value of 0500. |
0500 |
2 |
DT_ALT |
Inclusion/Change date from the F0901.UPMJ or DT_INI field from record 0000 if F0901.UPMJ is greater than DT_INI. |
0500 |
3 |
COD_ NAT_CC |
Account/Group type code from the B76AGTC field (Account/Group Type Code) in the Brazilian Account Information table (F76B925). |
0500 |
4 |
IND_CTA |
Account type indicator. Values are: S: Resumed (Sintetica) (Accounts Group) A: Analytic (Account) If F0901.GMPEC equals N, then S else A. |
0500 |
5 |
NÍVEL |
Account Level analytic/Accounts group from F0901.GMLDA. |
0500 |
6 |
COD_CTA |
Accounting Code analytic/Accounts group from F0901.MCU, F0901.OBJ, and F0901.SUB. |
0500 |
7 |
NOME_CTA |
Account Name analytic/Accounts group from F0901.DL01. |
600 |
1 |
REG |
Fixed value of 0600. |
600 |
2 |
DT_ALT |
Inclusion/Change date from F0006.UPMJ or DT_INI field from record 0000 if F0901.UPMJ is greater than DT_INI. |
600 |
3 |
COD_CCUS |
Cost center number. |
600 |
4 |
CCUS |
Cost center name from F0006.DL01. |
0990 |
1 |
REG |
Fixed value of 0990. |
0990 |
2 |
QTD_LIN_0 |
Quantity of lines in block 0. |