Reviewing EFD PIS COFINS Changes to Block 0
Block 0 contains information about all the other blocks, such as:
Opening information
Company and subsidiary
Customers and suppliers
Items and unit of measure
Transaction nature
Messages
Cost centers
Accounts
Review the fields in Block 0 that support the EFD PIS COFINS functionality:
Register Number |
Field Number |
Field Name |
Description |
---|---|---|---|
0000 |
1 |
REG |
0000 |
0000 |
2 |
COD_VER |
SPED job header. Field F76B040.B76VPC |
0000 |
3 |
TIPO_ESCRIT |
SPED job header. Field F76B040.B76WRTY |
0000 |
4 |
IND_SIT_ESP |
Value in the Special Situation Indicator field in the P76B010 program. F76ISE for the legal company (UDC 76B/SI) |
0000 |
5 |
NUM_REC_ANTERIOR |
SPED job header. Field F76B040.B76RNP |
0000 |
6 |
DT_INI |
SPED job header. Field F76B040.B76EFTB. Either monthly or range of dates in the same month. |
0000 |
7 |
DT_FIN |
SPED job header Field F76B040.B76EFTE. Either monthly or range of dates in the same month. |
0000 |
8 |
NOME |
Company mailing name from the address book F0111.MLNM. It is necessary remove the blank spaces at the beginning and end. |
0000 |
9 |
CNPJ |
Company address book F0101.TAX if the contributor is a legal entity |
0000 |
10 |
UF |
Company address book F0116.ADDS |
0000 |
11 |
COD_MUN |
Company address book. JDE Cif data, supplemental database code=AB and Data Type $J |
0000 |
12 |
SUFRAMA |
Company address book F76011.BISC |
0000 |
13 |
IND_NAT_PJ |
F76B026.B76CONI |
0000 |
14 |
IND_ATIV |
F76B026.B76ATIV |
0001 |
1 |
REG |
0001 |
0001 |
2 |
IND_MOV |
Indicates if the block has information in the file. |
0100 |
1 |
REG |
0100 |
0100 |
2 |
NOME |
Mailing name of the AN8 related to the job signatory in the P76B010 program. |
0100 |
3 |
CPF |
Accountant address book F0101.TAX, if the contributor is a person. |
0100 |
4 |
CRC |
Data is retrieved from the Address Book Inscription table (F76B140). The account inscription number should be obtained filter by Signatory AN8 and AN8InscriptionType = 30. If the COD ASSIM noted in item 5 is 900, this field is required. |
0100 |
5 |
CNPJ |
Accountant address book F0101.TAX, if the contributor is corporate. |
0100 |
6 |
CEP |
Accountant address number, access zip code F0116.ADDZ |
0100 |
7 |
END |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to processing option. It is necessary to remove the blank spaces at the beginning and end. |
0100 |
8 |
NUM |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to processing option. It is necessary to remove the blank spaces at the beginning and end. |
0100 |
9 |
COMPL |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to processing option. It is necessary to remove the blank spaces at the beginning and end. |
0100 |
10 |
BAIRRO |
Accountant address number, access JDE Cif data, supplemental database code=AB and Data Type $N, find description of UDC 76B/NC. |
0100 |
11 |
FONE |
Accountant address number, access the F0115 table. PAR1+PH1 when PHTP = blanco |
0100 |
12 |
FAX |
Accountant address number, access the F0115 table. PAR1+PH1 when PHTP=FAX |
0100 |
13 |
Accountant address number, access F01151.EMAL when AETP=E |
|
0100 |
14 |
COD_MUN |
Accountant address number, DE Cif data, supplemental database code=AB and Data Type $J |
0110 |
1 |
REG |
0110 |
0110 |
2 |
COD_INC_TRIB |
SPED job header F76B040.B76TIC |
0110 |
3 |
IND_APRO_CRED |
SPED job header F76B040.B76MOA |
0110 |
4 |
COD_TIPO_CONT |
SPED job header F76B040.B76TOC |
0110 |
5 |
IND_REG_CUM |
Blanks |
0140 |
1 |
REG |
0140 |
0140 |
2 |
COD_EST |
Find subsidiary company in the F76B015 table and retrieve value in B76AN8C field. If = 0, find F0101.AN8 (company address number.) |
0140 |
3 |
NOME |
Subsidiary address number F0111.MLNM. It is necessary to remove the blank spaces at the beginning and end. |
0140 |
4 |
CNPJ |
Subsidiary address number F0101.TAX |
0140 |
5 |
UF |
Subsidiary address number F0116.ADDS |
0140 |
6 |
IE |
Subsidiary address number F0101.ABTX2 |
0140 |
7 |
COD_MUN |
Subsidiary address number DE Cif data, supplemental database code=AB and Data Type $J |
0140 |
8 |
IM |
Subsidiary address number F76011.BMUN |
0140 |
9 |
SUFRAMA |
Subsidiary address number F76011.BISC |
0150 |
1 |
REG |
0150 |
0150 |
2 |
COD_PART |
In the F0101 table, AN8 or AN8V address number. |
0150 |
3 |
NOME |
Address Number mailing name F0111.MLNM. It is necessary to remove the blank spaces at the beginning and end. |
0150 |
4 |
COD_PAIS |
Address number, F0116.CTR, with code access 76B/CD and find description 2. |
0150 |
5 |
CNPJ |
If address number is contributor, F0101.TAX. |
0150 |
6 |
CPF |
If address number is individual, F0101.TAX. |
0150 |
7 |
IE |
Address number F0101.ABTX2 |
0150 |
8 |
COD_MUN |
Address number, DE Cif data, supplemental database code=AB and Data Type $J |
0150 |
9 |
SUFRAMA |
Address number F76011.BISC |
0150 |
10 |
END |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to the processing option. It is necessary to remove the blank spaces at the beginning and end. |
0150 |
11 |
NUM |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to the processing option. It is necessary to remove the blank spaces at the beginning and end. |
0150 |
12 |
COMPL |
F0116.ADD1, F0116.ADD2, F0116.ADD3, F0116.ADD4 according to the processing option. It is necessary to remove the blank spaces at the beginning and end. |
0150 |
13 |
BAIRRO |
Accountant address number, access JDE Cif data, supplemental database code=AB and Data Type $N, find description of UDC 76B/NC. |
0190 |
1 |
REG |
0190 |
0190 |
2 |
UNID |
Unit of measure code used on the other blocks |
0190 |
3 |
DESCR |
Access UDC 00/UM with unit of measure code. |
0200 |
1 |
REG |
0200 |
0200 |
2 |
COD_ITEM |
F4101.ITM |
0200 |
3 |
DESCR_ITEM |
F4101.DSC1 |
0200 |
4 |
COD_BARRA |
Access F4104 Key: AN8 = "0" XRT = "UP" ITM=F7611B.ITM Retrieve CITM |
0200 |
5 |
COD_ANT_ITEM |
Blanks |
0200 |
6 |
UNID_INV |
Access the F4101 table (key LITM or ITM) and retrieve the primary unit of measure (IMUOM1). |
0200 |
7 |
TIPO_ITEM |
With item/branch plant, access regional info category code 1. With the category code, access UDC 70/C1 and find description. If no information is entered by item/branch plant, access item regional info category code 1 and then find UDC 70/C1 description. |
0200 |
8 |
COD_NCM |
With item/branch plant, access regional info category code 2. With the category code, access UDC 70/C2 and find description. If no information is entered by item/branch plant, access item regional info category code 2 and then find UDC 70/C2 description. |
0200 |
9 |
EX_IPI |
With item/branch plant, access regional info category code 3. With the category code, access UDC 70/C3 and find description. If no information is entered by item/branch plant, access item regional info category code 3 and then find UDC 70/C3 description. |
0200 |
10 |
COD_GEN |
With item/branch plant, access regional info category code 4. With the category code, access UDC 70/C4 and find description. If no information is entered by item/branch plant, access item regional info category code 4 and then find UDC 70/C4 description. |
0200 |
11 |
COD_LST |
With item/branch plant, access regional info category code 5. With the category code, access UDC 70/C5 and find description. If no information is entered by item/branch plant, access item regional info category code 5 and then find UDC 70/C5 description. |
0200 |
12 |
ALIQ_ICMS |
F7608B.TXR1 accessing with the item master number used, the company mark up level (AC30 of the company address book) and the state of the company (state field of address book company). It uses only state from to access F7608B and state is always Blanks. |
0205 |
1 |
REG |
0205 |
0205 |
2 |
DESCR_ANT_ITEM |
F76B0765.DSC1 |
0205 |
3 |
DT_INI |
View item changes in the F76B0765 table [Item Change Track - BRA - 76B). |
0205 |
4 |
DT_FIM |
View item changes in the F76B0765 table [Item Change Track - BRA - 76B). |
0205 |
5 |
COD_ANT_ITEM |
Blanks |
0206 |
1 |
REG |
0206 |
0206 |
2 |
COD_COMB |
Access item regional info category code 6 and then find UDC 70/C6 description /F704101.G70CC06. |
0208 |
1 |
REG |
0208 |
0208 |
2 |
COD_TAB |
Access item regional info category code 7 and retrieve position 1 and 2 of F704101.G70CC07. |
0208 |
3 |
COD_GRU |
Access item regional info category code 7 and retrieve position 3 and 4 of F704101.G70CC07. |
0208 |
4 |
MARCA_COM |
Access item regional info category code 7 and then find description of UDC 70/C7. |
0400 |
1 |
REG |
0400 |
0400 |
2 |
COD_NAT |
F7611b.fdBNOP Concatenated to F7611B.BSOP |
0400 |
3 |
DESCR_NAT |
F7615B.DESC |
0450 |
1 |
REG |
0450 |
0450 |
2 |
COD_INF |
All code messages used in the nota fiscais used before. The code messages used are the ones from the following registers: A110, C110, C500, D100 &D500, |
0450 |
3 |
TXT |
Access UDC 40/PM. TXT = UDC Description. |
0500 |
1 |
REG |
0500 |
0500 |
2 |
DT_ALT |
F0901.UPMJ or field DT_INI from record 0000 if F0901.UPMJ > DT_INI. |
0500 |
3 |
COD_ NAT_CC |
F76B925 (Brazilian Account Information) field B76AGTC (Account/Group Type Code). |
0500 |
4 |
IND_CTA |
if F0901.GMPEC = N then "S" else "A" |
0500 |
5 |
NÍVEL |
F0901.GMLDA |
0500 |
6 |
COD_CTA |
F0901.MCU F0901.OBJ F0901.SUB |
0500 |
7 |
NOME_CTA |
F0901.DL01 |
0500 |
8 |
COD_CTA_REF |
With Juridic Person Qualification F76B034.B76JPQ and account number access the F76B926 table and retrieve field B76REFA. |
0600 |
1 |
REG |
0600 |
0600 |
2 |
DT_ALT |
F0006.UPMJ or field DT_INI from record 0000 if F0901.UPMJ > DT_INI |
0600 |
3 |
COD_CCUS |
MCU number |
0600 |
4 |
CCUS |
F0006.DL01 |
0990 |
1 |
REG |
0990 |
0990 |
2 |
QTD_LIN_0 |
Count total lines block 0 |