Reviewing EFD PIS COFINS Changes to Block A
Block A contains services fiscal documents (ISS tax only).
Review the changes to Block A that support the EFD PIS COFINS report:
Register Number |
Field Number |
Field Name |
Description |
|---|---|---|---|
A001 |
1 |
REG |
A001 |
A001 |
2 |
IND_MOV |
Indicates if the block has information in the file. |
A010 |
1 |
REG |
A010 |
A010 |
2 |
CNPJ |
With establishment AN8 inform F0101.TAX. This is the Company's CNPJ (tax ID number) Nota Fiscal. |
A100 |
1 |
REG |
A100 |
A100 |
2 |
IND_OPER |
F76101B.BRNOP < 5000 "0" Otherwise, "1" |
A100 |
3 |
IND_EMIT |
If IND_OPER =0, then 1 (others), else 0 (owner issue). |
A100 |
4 |
COD_PART |
If F7601B.BNFS < 5 then F7601B.AN8V, else F7601B.AN8. |
A100 |
5 |
COD_SIT |
If F7601B.CNDJ <> Blanks = 00, else 02 (Cancelled). |
A100 |
6 |
SER |
If the nota fiscal is paper, then 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 |
A100 |
7 |
Blanks |
|
A100 |
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 |
A100 |
9 |
CHV_NFSE |
Access key from F76B01TE (only for electronic nota fiscal) Blog XML |
A100 |
10 |
DT_DOC |
F7601B.FHISSU |
A100 |
11 |
DT_EXE_SERV |
Blanks |
A100 |
12 |
VL_DOC |
F7601B.BVTN |
A100 |
13 |
IND_PGTO |
With F7611B.DOCO and F7611B.PDCTO and F7611B.KCOO access the following: For inbound - F4311/F43119 and recover PTC, for outbound recover F4211/9.PTC: With payment term access F0014. If NDTP = 0 and NSP= 0, then 0. Otherwise 1. |
A100 |
14 |
VL_DESC |
F7601B.BDES |
A100 |
15 |
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" |
A100 |
16 |
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" |
A100 |
17 |
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" |
A100 |
18 |
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" |
A100 |
19 |
VL_PIS_RET |
Sales: Summarize nota fiscal PIS WH Amount from F76B429.BRTXA when tax type='05'. |
A100 |
20 |
VL_COFINS_RET |
Sales: Summarize nota fiscal COFINS WH Amount from F76B429.BRTXA when tax type='06'. |
A100 |
21 |
VL_ISS |
Nota fiscal ISS tax amount from F7601B.BISS |
A110 |
1 |
REG |
A110 |
A110 |
2 |
COD_INF |
F7611B.BINM - Fiscal Message |
A110 |
3 |
Access UDC 40/PM. Description is UDC description. |
|
A111 |
1 |
REG |
A100 |
A111 |
2 |
NUM_PROC |
Select from F76B038 and F76B036 related process. |
A111 |
3 |
IND_PROC |
B76POI from the F76B035 table and the F76B037 table for the process selected before. |
A120 |
1 |
REG |
A120 |
A120 |
2 |
VL_TOT_SERV |
F7601B.BVTN (Nota Fiscal Total Amount) |
A120 |
3 |
VL_BC_PIS |
With purchase order number and type access F76B0411 (F76B0411.ODCT, ODOC and KCO, BRTXTP =05 and sum (BRTXTT). |
A120 |
4 |
VL_PIS_IMP |
With purchase order number and type, access (F76B0411.ODCT, ODOC and KCO, BRTXTP =05 and sum AA. |
A120 |
5 |
DT_PAG_PIS |
With purchase order number and type, access (F76B0411.ODCT, ODOC and KCO, BRTXTP =05 and find DDJ. |
A120 |
6 |
VL_BC_COFINS |
With purchase order number and type access F76B0411 (F76B0411.ODCT, ODOC and KCO, BRTXTP =06 and sum (BRTXTT). |
A120 |
7 |
VL_COFINS_IMP |
With purchase order number and type, access (F76B0411.ODCT, ODOC and KCO, BRTXTP =06 and sum AA. |
A120 |
8 |
DT_PAG_COFINS |
With purchase order number and type, access (F76B0411.ODCT, ODOC and KCO, BRTXTP =05 and find DDJ. |
A120 |
9 |
LOC_EXE_SERV |
Import information, execution place F76B033.B76PSE. |
A170 |
1 |
REG |
A170 |
A170 |
2 |
NUM_ITEM |
F7611B.LNID |
A170 |
3 |
COD_ITEM |
F4101.ITM |
A170 |
4 |
DESCR_COMPL |
Line message, F7611B.BINM and then find message description. |
A170 |
5 |
VL_ITEM |
F7611B. AEXP |
A170 |
6 |
VL_DESC |
F7611B.BDES |
A170 |
7 |
NAT_BC_CRED |
Blanks |
A170 |
8 |
IND_ORIG_CRED |
If the nota fiscal is inbound and supplier is foreign (Country<> BR), inform 1. Otherwise, 0. |
A170 |
9 |
CST_PIS |
F76B012.B76TSPIS |
A170 |
10 |
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". |
A170 |
11 |
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". |
A170 |
12 |
VL_PIS |
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". |
A170 |
13 |
CST_COFINS |
F76B012.B76TSCOF |
A170 |
14 |
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 = "05". |
A170 |
15 |
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". |
A170 |
16 |
VL_COFINS |
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 = "06". |
A170 |
17 |
COD_CTA |
Blanks |
A170 |
18 |
COD_CCUS |
Blanks |
A990 |
1 |
REG |
A990 |
A990 |
2 |
QTD_LIN_A |
Count total lines block A, |