Registers and Fields for Block E
Block E includes information about IPI and ICMS taxes. Not all of the information required in this block resides in the JD Edwards EnterpriseOne tables. This section lists only the fields that are populated from the JD Edwards EnterpriseOne tables.
Register |
Field Number |
Field Name |
Description |
|---|---|---|---|
E001 |
1 |
REG |
Fixed value of E001. |
E001 |
2 |
IND_MOV |
Movement indicator. Values are: 0: Block with information 1: Block without information |
E100 |
1 |
REG |
Fixed value of E100. |
E100 |
2 |
DT_INI |
Verification start date from a value that you enter in the SPED Fiscal Administ Process program. |
E100 |
3 |
DT_FIN |
Verification end date from a value that you enter in the SPED Fiscal Administ Process program. |
E110 |
1 |
REG |
Fixed value of E110. |
E110 |
2 |
VL_TOT_DEBITOS |
Total debit amount. For output nota fiscal, the sum of F76101B BICM. |
E110 |
3 |
VL_AJ_DEBITOS |
Total debit adjustment amount. The system leaves this field blank. |
E110 |
4 |
VL_TOT_AJ_DEBITOS |
Total debit adjustment. The system leaves this field blank. |
E110 |
5 |
VL_ESTORNOS_CRED |
Total adjustments for debit reversions. The system leaves this field blank. |
E110 |
6 |
VL_TOT_CREDITOS |
Total credit amount. For inbound nota fiscal, the sum of F76101B BICM. |
E110 |
7 |
VL_AJ_CREDITOS |
Total credit adjustment amount. The system leaves this field blank. |
E110 |
8 |
VL_TOT_AJ_CREDITOS |
Total credit adjustment. The system leaves this field blank. |
E110 |
9 |
VL_ESTORNOS_DEB |
Total adjustments for credit reversions. The system leaves this field blank. |
E110 |
10 |
VL_SLD_CREDOR_ANT |
ICMS credit balance to transfer to next period. |
E110 |
11 |
VL-SLD_APURADO |
Balance due. Sum fields: 02+03+04+05−06−07−08−09−10 |
E110 |
12 |
VL_TOT_DED |
Deduction amounts. The system leaves this field blank. |
E110 |
13 |
VL_ICMS_RECOLHER |
Net amount. The value in field 11 minus the value in field 12. |
E110 |
14 |
VL_SLD_CREDOR_TRANSPORT_AR |
ICMS credit balance to transfer to next period. The system completes this field when the net amount is in favor to the contributor. |
E110 |
15 |
DEB_ESP |
ICMS amount to pay The system completes this field when the net amount is in favor to the fiscal authority. |
E111 |
1 |
REG |
Fixed value of E111. |
E111 |
2 |
COD_AJ_APUR |
Verification adjust code The system leaves this field blank. |
E111 |
3 |
DESCR_COMPL_AJ |
Description The system leaves this field blank. |
E111 |
4 |
VL_AJ_APUR |
Verification amount The system leaves this field blank. |
E112 |
1 |
REG |
Fixed value of E112. |
E112 |
2 |
NUM_DA |
Document number The system leaves this field blank. |
E112 |
3 |
NUM_PROC |
Process number The system leaves this field blank. |
E112 |
4 |
IND_PROC |
Indicator of process origin. Values are: 0: Sefaz 1: Justiça Federal 2: Justiça Estadual 9: Others The system leaves this field blank. |
E112 |
5 |
PROC |
Description The system leaves this field blank. |
E112 |
6 |
TXT_COMPL |
The system populates this field with the reference code field 2 of register 0450. The system leaves this field blank. |
E113 |
1 |
REG |
Fixed value of E113. |
E113 |
2 |
COD_PART |
Address number. The system leaves this field blank. |
E113 |
3 |
COD_MOD |
Nota fiscal model The system leaves this field blank. |
E113 |
4 |
SER |
Fiscal document series The system leaves this field blank. |
E113 |
5 |
SUB |
Fiscal document subseries The system leaves this field blank. |
E113 |
6 |
NUM_DOC |
Nota fiscal number The system leaves this field blank. |
E113 |
7 |
DT_DOC |
Issue date The system leaves this field blank. |
E113 |
8 |
COD_ITEM |
Item number The system leaves this field blank. |
E113 |
9 |
VL_AJ_ITEM |
Adjust amount The system leaves this field blank. |
E115 |
1 |
REG |
Fixed value of E115. |
E115 |
2 |
COD_INF_ADIC |
Additional information The system leaves this field blank. |
E115 |
3 |
VL_INF_ADIC |
Reference value The system leaves this field blank. |
E115 |
4 |
DESCR_COMPL_AJ |
Additional information The system leaves this field blank. |
E116 |
1 |
REG |
Fixed value of E116. |
E116 |
2 |
COD_OR |
To pay code according to reference table 5.4. 000 |
E116 |
3 |
VL_OR |
To pay amount = E110, field 13 if field is different than zero. |
E116 |
4 |
DT_VCTO |
Due date is the last date of the job. |
E116 |
5 |
COD_REC |
Receita code = 0. |
E116 |
6 |
NUM_PROC |
Process number The system leaves this field blank. |
E116 |
7 |
IND_PROC |
Indicator of process origin. Values are: 0: Sefaz 1: Justiça Federal 2: Justiça Estadual 9: Others The system leaves this field blank. |
E116 |
8 |
PROC |
Description The system leaves this field blank. |
E116 |
9 |
TXT_COMPL |
Description The system leaves this field blank. |
E116 |
10 |
MES_REF |
Monthly. The system reports the value only if E116 Field 3 is informed. |
E200 |
1 |
REG |
Fixed value of E200. |
E200 |
2 |
UR |
State from F76101B. BRAUFE. |
E200 |
3 |
DT_FIN |
Verification beginning date from a value that you enter in the SPED Fiscal Block Setup program. |
E200 |
4 |
DT_FIN |
Verification end date from a value that you enter in the SPED Fiscal Block Setup program. |
E210 |
1 |
REG |
Fixed value of E210. |
E210 |
2 |
IND_MOV_ST |
Movement indicator. Values are: 0: without ICMS ST 1: with ICMS ST |
E210 |
3 |
VL_SLD_CRED_ANT_ST |
ICMS substitute tax balance to transfer to next period. |
E210 |
4 |
VL_DEVOL_ST |
Total ICMS substitute tax by returned goods. The system leaves this field blank. |
E210 |
5 |
VL_RESSARC_ST |
Total ICMS substitute tax by indemnity. The system leaves this field blank. |
E210 |
6 |
VL_OUT_CRED_ST |
Total credit substitute tax. For outbound notas fiscais, F7611B.FDBNFS. For inbound notas fiscais, F76111B.BVIS. |
E210 |
7 |
VL_AJ_CREDITOS_ST |
Total credit ICMS substitute tax by adjustments to the legal documents. The system leaves this field blank. |
E210 |
8 |
VL_RETENÇAO_ST |
Total ICMS substitute tax withheld. The system leaves this field blank. |
E210 |
9 |
VL_OUT_DEB_ST |
Total debit substitute tax. For outbound notas fiscais, F7611B.FDBNFS. For inbound notas fiscais, F76111B.BVIS. |
E210 |
10 |
VL_AJ_DEBITOS_ST |
Total debit ICMS substitute tax by adjustments to the legal documents. The system leaves this field blank. |
E210 |
11 |
VL_SLD_DEV_ANT_ST |
ICMS substitute tax to pay before deductions. Sum of fields: [(09+10+11) − (04+05+06+07+08)]. |
E210 |
12 |
VL_DEDUÇÕES_ST |
ICMS substitute tax deduction. The system leaves this field blank. |
E210 |
13 |
VL_ICMS_RECOL_ST |
Amount to pay. The value of field 12 minus the value of field 13. |
E210 |
14 |
VL_SLD_CRED_ST_TRANSFORTAR |
ICMS substitute tax credit balance to transfer to next period. Sum of fields: [(04+05+06+07+08) − (09+10+11)]. |
E210 |
15 |
DEB_ESP_ST |
Extra values The system leaves this field blank. |
E220 |
1 |
REG |
Fixed value of E220. |
E220 |
2 |
COD_AJ_APUR |
Adjust code according to table 5.1.1. The system leaves this field blank. |
E220 |
3 |
DESCR_COMPL_AJ |
Description The system leaves this field blank. |
E220 |
4 |
VL_AJ_APUR |
Adjust amount The system leaves this field blank. |
E230 |
1 |
REG |
Fixed value of E230. |
E230 |
2 |
NUM_DA |
Document number The system leaves this field blank. |
E230 |
3 |
NUM_PROC |
Process number The system leaves this field blank. |
E230 |
4 |
IND_PROC |
Indicator of process origin. Values are: 0: Sefaz 1: Justiça Federal 2: Justiça Estadual 9: Others The system leaves this field blank. |
E230 |
5 |
PROC |
Description The system leaves this field blank. |
E230 |
6 |
TXT_COMPL |
The system populates this field with the reference code from field 2 of register 0450. The system leaves this field blank. |
E240 |
1 |
REG |
Fixed value of E240. |
E240 |
2 |
COD_PART |
Address number The system leaves this field blank. |
E240 |
3 |
COD_MOD |
Nota fiscal model The system leaves this field blank. |
E240 |
4 |
SER |
Fiscal document series The system leaves this field blank. |
E240 |
5 |
SUB |
Fiscal document subseries The system leaves this field blank. |
E240 |
6 |
NUM_DOC |
Nota fiscal number The system leaves this field blank. |
E240 |
7 |
DT_DOC |
Issue date The system leaves this field blank. |
E240 |
8 |
COD_ITEM |
Item number The system leaves this field blank. |
E240 |
9 |
VL_AJ_ITEM |
Adjust amount The system leaves this field blank. |
E250 |
1 |
REG |
Fixed value of E250. |
E250 |
2 |
COD_OR |
To pay code, according to reference table 5.4. The system leaves this field blank. |
E250 |
3 |
VL_OR |
To pay amount The system leaves this field blank. |
E250 |
4 |
DT_VCTO |
Due date The system leaves this field blank. |
E250 |
5 |
COD_REC |
Receita code The system leaves this field blank. |
E250 |
6 |
NUM_PROC |
Process number The system leaves this field blank. |
E250 |
7 |
IND_PROC |
Indicator of process origin. Values are: 0: Sefaz 1: Justiça Federal 2: Justiça Estadual 9: Others The system leaves this field blank. |
E250 |
8 |
PROC |
Description The system leaves this field blank. |
E250 |
9 |
TXT_COMPL |
Description The system leaves this field blank. |
E250 |
10 |
MES_REF |
Monthly The system leaves this field blank. |
E500 |
1 |
REG |
Fixed value of E500. |
E500 |
2 |
IND_APUR |
Period indicator. Values are: 0: Monthly 1: 10 months Value is always 0. |
E500 |
3 |
DT_INI |
Verification begin date. From a value that you set up in the SPED Fiscal Block Setup program. |
E500 |
4 |
DT_FIN |
Verification end date. From a value that you set up in the SPED Fiscal Block Setup program. |
E510 |
1 |
REG |
Fixed value of E510. |
E510 |
2 |
CFOP |
Transaction nature from F76111B.BRNOP. |
E510 |
3 |
CST_IPI |
IPI tax situation code. The value from F76B012.B76TSIPI. If no value exists, then write the value from the Special Handling Code field of UDC 76B/CW for the value that exists in F76111B. BRAITP. |
E510 |
4 |
VL_CONT_IPI |
Accounting amount by CFOP and CTIPI. The sum of the values from F76111B.AEXP − F76111B.BDES. |
E510 |
5 |
VL_BC_IPI |
IPI taxable amount by CFOP and CTIPI from F76111B.BBTP. |
E510 |
6 |
VL_IPI |
IPI amount by CFOP and CTIPI from F76111B.BRBIPI. |
E520 |
1 |
REG |
Fixed value of E510. |
E520 |
2 |
VL_SD_ANT_IPI |
IPI credit balance before period zero. |
E520 |
3 |
VL_DEB_IPI |
Total debit amount "output with debit tax": For output, if (F76111B.BRAITP) = "1,4,5"Sum F76111B.BIPI. |
E520 |
4 |
VL_CRED_IPI |
Total amount "input with credit tax": For input, if (F76111B.BRAITP) = "1,4,5"Sum F76111B.BIPI. |
E520 |
5 |
VL_OD_IPI |
Total amount "other debit": For output, if (BF76111B.BRAITP = "5"), sum BF76111B.BRABIP. If (BF76111B.BRAITP) = "3", sum F76111B.BIPI. |
E520 |
6 |
VL_OC_IPI |
Total amount "other credit": For input, if (BF76111B.BRAITP = "5"), sum BF76111B.BRABIP. If (BF76111B.BRAITP) = "3", sum F76111B.BIPI. |
E520 |
7 |
VL_SC_IPI |
IPI credit balance to transfer to next period: TotalCredit = TotalCreditTax + TotalOtherCreditTax + IPI Credit Balance Before Period |
E520 |
8 |
VL_SD_IPI |
IPI amount to pay: TotalDebit = TotalDebitTax + TotalOtherDebitTax. if TotalCredit > TotalDebit then IPI credit balance to transfer to next period = TotalCredit - TotalDebit IPI Amount to pay = 0 Else IPI credit balance to transfer to next period = 0 IPI Amount to pay = TotalDebit - TotalCreditEnd |
E530 |
1 |
REG |
Fixed value of E530. |
E530 |
2 |
IND_AJ |
Indicator of adjust type. Values are: 0: Debit adjust 1: Credit adjust The system leaves this field blank. |
E530 |
3 |
VL_AJ |
Adjust amount The system leaves this field blank. |
E530 |
4 |
COD_AJ |
Adjust code according to table 4.5.4. The system leaves this field blank. |
E530 |
5 |
IND_DOC |
Origin of the document The system leaves this field blank. |
E530 |
6 |
NUM_DOC |
Document number The system leaves this field blank. |
E530 |
7 |
DESCR_AJ |
Adjust description The system leaves this field blank. |
E990 |
1 |
REG |
Fixed value of E990. |
E990 |
2 |
QTD_LIN_E |
Quantity of lines in block E. |