Reviewing EFD PIS COFINS Changes to Block C
Block C contains fiscal documents I - goods (ICMS/IPI taxes).
Review the changes to Block C that support the EFD PIS COFINS report:
Register Number |
Field Number |
Field Name |
Description |
|---|---|---|---|
C001 |
1 |
REG |
C001 |
C001 |
2 |
IND_MOV |
Indicates if the block has information in the file. |
C010 |
1 |
REG |
C010 |
C010 |
2 |
CNPJ |
Company's tax ID number in AN8 |
C010 |
3 |
IND_ESCRI |
2 |
C100 |
1 |
REG |
C100 |
C100 |
2 |
IND_OPER |
F76101B.BRNOP <5000 "0". Otherwise, "1" |
C100 |
3 |
IND_EMIT |
If IND_OPER=0 then 1. Otherwise, 0. |
C100 |
4 |
COD_PART |
If IND_OPER= 1 F7601B.AN8 else F7601B. AN8V address number. |
C100 |
5 |
COD_MOD |
With nota fiscal number, access F76B030.B76MOTY. |
C100 |
6 |
COD_SIT |
Sales Orders Classic and Sao Paolo: If F7601B.CNDJ = Blanks then 00 else 02 (Cancelled) National Sales orders: Access with nota fiscal to F76B12TE with B76SACT=Y, find B76NFST: C = 02 U = 05 R = 04 The value is in the special handling code field in UDC 76B/ST. For purchase orders: if F7601B.CNDJ = Blanks 08. Otherwise, 02. |
C100 |
7 |
SER |
If the nota fiscal is paper, then the F7601B.BSER value. If the nota fiscal has a legal number in the F7601BTE table, then the series number of it. For BRNFI-NA: Serie 3 digits from position 10, BRNFI-TE: Nota Fiscal Number: if length of B76ELN is equal to 13, then Nota Fiscal Series = Blank. If length of B76ELN is equal to 15, then Nota Fiscal Series = Characters 14 and 15. If length of B76ELN is equal to 24, then Nota Fiscal Series = S.U. For BRNFI-SP: Blanks. |
C100 |
8 |
NUM_DOC |
If the nota fiscal is paper (not in the F76B01TE table), then the F7601B.BNNF value. If the nota fiscal is at F7601BTE and nota fiscal type = BRNFI-NA first 9 characters of B76ELN, if nota fiscal type = BRNFI-TE the first 13 characters of B76ELN, if BRNFI-SP B76ELN. |
C100 |
9 |
CHV_NFE |
Blog XML |
C100 |
10 |
DT_DOC |
Issue Date |
C100 |
11 |
DT_E_S |
Nota fiscal outbound – BRADEJ(F76101B). |
C100 |
12 |
VL_DOC |
Nota fiscal inbound – BRADLJ(F76101B). |
C100 |
13 |
IND_PGTO |
With Sales Order access F4201/9, with purchase order access f4301/9 and find PTC in both cases. With PTC access F0014 and retrieve the NDTP (Net days to pay) and NSP (Split). If both are 0, then inform 0. Otherwise, 1. If is a standalone, inform 9. |
C100 |
14 |
VL_DESC |
F7611B.BDES |
C100 |
15 |
VL_ABAT_NT |
F7601B.FHBDIZ |
C100 |
16 |
VL_MERC |
F76101B.BRAVAL |
C100 |
17 |
IND_FRT |
With the F7601B.FRTH value, access UDC 76B|FO and retrieve the second description. If description is blank or FRTH does not exist, then 9. |
C100 |
18 |
VL_FRT |
F7601B.BFRT |
C100 |
19 |
VL_SEG |
F7601B.BSEG |
C100 |
20 |
VL_OUT_DA |
F7601B.BDFN |
C100 |
21 |
VL_BC_ICMS |
F7601B.BBCL |
C100 |
22 |
VL_ICMS |
Sum F7611B.BRAVCI |
C100 |
23 |
VL_BC_ICMS_ST |
Sum F7611B.BBIS |
C100 |
24 |
VL_ICMS_ST |
Sum F7611B.BVIS |
C100 |
25 |
VL_IPI |
Sum F7611B.BRBIPI |
C100 |
26 |
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". |
C100 |
27 |
VL_COFINS |
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 = "06". |
C100 |
28 |
VL_PIS_ST |
Sum F76B031.B76PSA |
C100 |
29 |
VL_COFINS_ST |
Sum F76B031.B76CFSA |
C110 |
1 |
REG |
C110 |
C110 |
2 |
COD_INF |
F7601B.BINM - Fiscal Message |
C110 |
3 |
TXT_COMPL |
Access UDC 40/PM. Description is UDC description. |
C111 |
1 |
REG |
C111 |
C111 |
2 |
NUM_PROC |
With nota fiscal number, access the F76B038 table and retrieve Administrative Process ID (B76APID) or/and F76B036 and retrieve Judicial Process ID (B76JPID). |
C111 |
3 |
IND_PROC |
With judicial process, access F76B035 and find B76POI or F76B037 and find B76POI. |
C120 |
1 |
REG |
C120 |
C120 |
2 |
COD_DOC_IMP |
For all nota fiscal lines, access the F76B018 table and retrieve Import Declaration Type (B76IDCT). If value is DSI then 1. Otherwise, 0. |
C120 |
3 |
NUM_DOC__IMP |
For all nota fiscal lines, access the F76B018 table and retrieve Import Declaration Number. With Import declaration number and import declaration type, find legal number in the F76B022 table. |
C120 |
6 |
NUM_ACDRAW |
For all nota fiscal lines, access the F76B018 table and retrieve Import Declaration Number. With Import declaration number and import declaration type, find the drawback number at F76B033.B76NCRD. |
C170 |
1 |
REG |
C170 |
C170 |
2 |
NUM_ITEM |
Sequential number |
C170 |
3 |
COD_ITEM |
F4101.ITM |
C170 |
4 |
DESCR_COMPL |
Line message, F7611B.BINM and then find message description |
C170 |
5 |
QTD |
F7611B.UORG |
C170 |
6 |
UNID |
F7611B.UOM |
C170 |
7 |
VL_ITEM |
F7611B. AEXP |
C170 |
8 |
VL_DESC |
F7611B.BDES |
C170 |
9 |
IND_MOV |
If the item is a service then "1". If the item is a good, then "0". |
C170 |
10 |
CST ICMS |
F7611B.BST1 |
C170 |
11 |
CFOP |
F7611B.BRNOP |
C170 |
12 |
COD_NAT |
F7611b.fdBNOP Concatenated to F7611B.BSOP |
C170 |
13 |
VL_BC_ICMS |
F7601B.BBCL |
C170 |
14 |
ALIQ_ICMS |
F7611B.TXR1 |
C170 |
15 |
VL_ICMS |
F7611B.BRAVCI |
C170 |
16 |
VL_BC_ICMS_ST |
F7611B.BBIS |
C170 |
18 |
VL_ICMS_ST |
F7611B.BVIS |
C170 |
19 |
IND_APUR |
UBE processing option |
C170 |
20 |
CST IPI |
F76B012.B76TSIPI |
C170 |
22 |
VL_BC_IPI |
F7611B.BBTP |
C170 |
23 |
ALIQ_IPI |
F7611B.BRAAIP |
C170 |
24 |
VL_IPI |
F7611B BRBIPI |
C170 |
25 |
CST_PIS |
F76B012.B76TSPIS |
C170 |
26 |
VL_BC_PIS |
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". |
C170 |
27 |
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". |
C170 |
30 |
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". |
C170 |
31 |
CST_COFINS |
F76B012.B76TSCOF |
C170 |
32 |
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". |
C170 |
33 |
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". |
C170 |
36 |
VL_COFINS |
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 = "06". |
C500 |
1 |
REG |
C500 |
C500 |
2 |
COD_PART |
If F7601B.BNFS < 5 then F7601B.AN8V. Otherwise, F7601B.AN8. |
C500 |
3 |
COD_MOD |
With nota fiscal number, access F76B030.B76MOTY. |
C500 |
4 |
COD_SIT |
Sales Orders Classic and Sao Paolo: If F7601B.CNDJ <> Blanks =00 else 02 (Cancelled) National Sales orders: Access with nota fiscal to F76B12TE with B76SACT=Y, find B76NFST: C = 02 U = 05 R = 04 The value is in the special handling code field in UDC 76B/ST. |
C500 |
5 |
SER |
If the nota fiscal is a paper one, then the F7601B.BSER. If the nota fiscal has a legal number in the F7601BTE table, then the series number of it. For BRNFI-NA: Serie 3 digits from position 10, BRNFI-TE: NF Number: if length of B76ELN is equal to 13, then NF Series = Blank. If length of B76ELN is equal to 15, then NF Series = Characters 14 and 15. If length of B76ELN is equal to 24, then NF Series = S.U. For BRNFI-SP: Blanks. |
C500 |
7 |
NUM_DOC |
If the nota fiscal paper, (not in the F76B01TE table) then the F7601B.BNNF. If the nota fiscal is at F7601BTE and nota fiscal type = BRNFI-NA first 9 characters of B76ELN, if nota fiscal type = BRNFI-TE the first 13 characters of B76ELN, if BRNFI-SP B76ELN. |
C500 |
8 |
DT_DOC |
Issue Date F7601B.ISSU |
C500 |
9 |
DT_ENT |
F7601B.ADDJ |
C500 |
10 |
VL_DOC |
F7601B.BVTN |
C500 |
11 |
VL_ICMS |
Sum F76111B.BRAVCI |
C500 |
12 |
COD_INF |
F7601B.BINM - Fiscal Message |
C500 |
13 |
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". |
C500 |
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". |
C501 |
1 |
REG |
C501 |
C501 |
2 |
CST_PIS |
F76B012.B76TSPIS |
C501 |
3 |
VL_ITEM |
F7611B. AEXP |
C501 |
5 |
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" |
C501 |
6 |
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" |
C501 |
7 |
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 |
C505 |
1 |
REG |
C505 |
C505 |
2 |
CST_COFINS |
F76B012.B76TSCOF |
C505 |
3 |
VL_ITEM |
F7611B. AEXP |
C505 |
5 |
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" |
C505 |
6 |
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" |
C505 |
7 |
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 |
C509 |
1 |
REG |
C509 |
C509 |
2 |
NUM_PROC |
Select from the F76B038 table and the F76B036 table related process. |
C509 |
3 |
IND_PROC |
B76POI from the F76B035 table an F76B037 for the process selected before. |
C990 |
1 |
REG |
C990 |
C990 |
2 |
QTD_LIN_C |
Total of lines in block C |