Reviewing EFD PIS COFINS Changes to Block F
Block F contains other fiscal documents and transactions not related to fiscal documents reported under blocks A, C and D.
Review the changes to Block F that support the EFD PIS COFINS report:
Register Number |
Field Number |
Field Name |
Description |
|---|---|---|---|
F001 |
1 |
REG |
F001 |
F001 |
2 |
IND_MOV |
Indicates if the block has information in the file. |
F010 |
1 |
REG |
F010 |
F010 |
2 |
CNPJ |
Company AN8 |
F100 |
1 |
REG |
F100 |
F100 |
2 |
IND_OPER |
With F76B012.B76TSPIS, access UDC 76B/XP and retrieve Description 02, position 2. |
F100 |
3 |
COD_PART |
If F7601B.BNFS < 5 then F7601B.AN8V. Otherwise, F7601B.AN8. |
F100 |
4 |
COD_ITEM |
F7611B.ITM |
F100 |
5 |
DT_OPER |
F7601B.ISSU |
F100 |
6 |
VL_OPER |
F7611B. AEXP |
F100 |
7 |
CST_PIS |
F76B012.B76TSPIS |
F100 |
8 |
VL_BC_PIS |
Summarize F76B011.TDBRTXB where F76B011.TDBNNF = F7611B.FDBNNF and F76B011.TDBSER = F7611B.FDBSER and F76B011.TDN001 = F7611B.FDN001 and F76B011.TDDCT = F7611B.FDDCT and F76B011.TDLNID = F7611B.FDLNID and F76B011.TDBRTX = "05" |
F100 |
9 |
ALIQ_PIS |
F76B011.TDBRTXR where F76B011.TDBNNF = F7611B.FDBNNF and F76B011.TDBSER = F7611B.FDBSER and F76B011.TDN001 = F7611B.FDN001 and F76B011.TDDCT = F7611B.FDDCT and F76B011.TDLNID = F7611B.FDLNID and F76B011.TDBRTX = "05" |
F100 |
10 |
VL_PIS |
F76B001.THBRTXA where F76B001.THBNNF = F7601B.FHBNNF and F76B001.THBSER = F7601B.FHBSER and F76B001.THN001 = F7601B.FHN001 and F76B001.THDCT = F7601B.FHDCT and F76B001.THBRTX = "05" |
F100 |
11 |
CST_COFINS |
F76B012.B76TSCOF |
F100 |
12 |
VL_BC_COFINS |
F76B011.TDBRTXB where F76B011.TDBNNF = F7611B.FDBNNF and F76B011.TDBSER = F7611B.FDBSER and F76B011.TDN001 = F7611B.FDN001 and F76B011.TDDCT = F7611B.FDDCT and F76B011.TDLNID = F7611B.FDLNID and F76B011.TDBRTX = "06" |
F100 |
13 |
ALIQ_COFINS |
F76B011.TDBRTXR where F76B011.TDBNNF = F7611B.FDBNNF and F76B011.TDBSER = F7611B.FDBSER and F76B011.TDN001 = F7611B.FDN001 and F76B011.TDDCT = F7611B.FDDCT and F76B011.TDLNID = F7611B.FDLNID and F76B011.TDBRTX = "06" |
F100 |
14 |
VL_COFINS |
Sum F76B001.THBRTXA where F76B011.THBNNF = F7601B.FHBNNF and F76B011.THBSER = F7601B.FHBSER and F76B011.THN001 = F7601B.FHN001 and F76B011.THDCT = F7601B.FHDCT and F76B001.THBRTX = "05" |
F100 |
16 |
IND_ORIG_CRED |
F7611b.FDBORI |
F111 |
1 |
REG |
F111 |
F111 |
2 |
NUM_PROC |
Select from F76B038 and F76B036 related process. |
F111 |
3 |
IND_PROC |
B76POI from the F76B035 table an F76B037 for the process selected before. |
F120 |
1 |
REG |
F120 |
F120 |
2 |
NAT_BC_CRED |
F76B1201.B76CBC |
F120 |
3 |
IDENT_BEM_IMOB |
F76B1201.B76ASID |
F120 |
4 |
IND_ORIG_CRED |
F76B1201.B76AOI |
F120 |
5 |
IND_UTIL_BEM_IMOB |
F76B1201.B76AUI |
F120 |
6 |
VL_OPER_DEP |
F1202. Period Value |
F120 |
8 |
CST_PIS |
F76B012.B76TSPIS |
F120 |
9 |
VL_BC_PIS |
F1202. Period Value |
F120 |
10 |
ALIQ_PIS |
Get Aliquota from Nota Fiscal |
F120 |
11 |
VL_PIS |
Field 9x10 |
F120 |
12 |
CST_COFINS |
F76B012.B76TSCOF |
F120 |
13 |
VL_BC_COFINS |
F1202. Period Value |
F120 |
14 |
ALIQ_COFINS |
Get Aliquota from Nota Fiscal |
F120 |
15 |
VL_COFINS |
Field 13x14 |
F120 |
16 |
COD_CTA |
F1202.MCU.OBJ.SUB for CHCH="4" |
F120 |
17 |
COD_CCUS |
F1202.MCU |
F120 |
18 |
DESC_ BEM_IMOB |
F1201.Description |
F129 |
1 |
REG |
F129 |
F129 |
2 |
NUM_PROC |
Select from F76B038 and F76B036 related process. |
F129 |
3 |
IND_PROC |
B76POI from the F76B035 table and F76B037 for the process selected before. |
F130 |
1 |
REG |
F130 |
F130 |
2 |
NAT_BC_CRED |
F76B1201.B76CBC |
F130 |
3 |
IDENT_BEM_IMOB |
F76B1201.B76ASID |
F130 |
4 |
IND_ORIG_CRED |
F76B1201.B76AOI |
F130 |
5 |
IND_UTIL_BEM_IMOB |
F76B1201.B76AUI |
F130 |
6 |
MES_OPER_AQUIS |
F1201.AdquisitionDate (ADJ) |
F130 |
7 |
VL_OPER_AQUIS |
F7611B.AEXP |
F130 |
9 |
VL_BC_CRED |
F7611B.AEXP |
F130 |
10 |
IND_NR_PARC |
With F76B1201.B76NOP, select the parcel indicator (1, 2, 3, 4, 5 or 9) |
F130 |
11 |
CST_PIS |
F76B012.B76TSPIS |
F130 |
12 |
VL_BC_PIS |
A parcel or total of NF PIS: F76B011.BRTXB for BRTX =05"" / F76B01201.B76NOP |
F130 |
13 |
ALIQ_PIS |
F76B011.BRTXR for BRTX="05" |
F130 |
14 |
VL_PIS |
Field 12 X Field 13 / 100 |
F130 |
15 |
CST_COFINS |
F76B012.B76TSCOF |
F130 |
16 |
VL_BC_COFINS |
"A Parcel o total of NF COFINS: F76B011.BRTXB for BRTX=""06"" / F76B01201.B76NOP" |
F130 |
17 |
ALIQ_COFINS |
F76B011.BRTXR for BRTX="06" |
F130 |
18 |
VL_COFINS |
Field 16 X Field 17 / 100 |
F130 |
19 |
COD_CTA |
F1201.AMCU.AOBJ.ASUB |
F130 |
20 |
COD_CCUS |
F1201.AMCU |
F130 |
21 |
DESC_ BEM_IMOB |
F1201.Description |
F139 |
1 |
REG |
F139 |
F139 |
2 |
NUM_PROC |
Select from F76B038 and F76B036 related process. |
F139 |
3 |
IND_PROC |
B76POI from the F76B035 table an F76B037 for the process selected before. |
F990 |
1 |
REG |
F990 |
F990 |
2 |
QTD_LIN_F |
Total of lines in block F |