1. Implementing Financials for EMEA
  2. Appendix 4 – Version 1.1 changes in Extract

Appendix 4 – Version 1.1 changes in Extract

You can view the version changes in the extract.

Version 1.1 changes in Extract and Existing Extract

Changes introduced in Version 1.1 are readily available in XML files for these registers:

  • Issued Invoices Register
  • Received Invoices Register
  • Selected Intra-EU Transactions Register
  • Transactions Register
  • Payments Register

Received Invoices Register

The table explains the new columns in extract included for SII Version1.1 changes and provides information and the purpose of the new column to be used in XSL tags.

Extract Column Data Type Extract Table Column Name Values Description
Simplified invoice Optional – Yes Length -1 – Type -Char Possible values are Y or N. JE_ZZ_VAT _REP_TRX_ T je_info_v26 IF Simplified Invoice GDF is set to Yes, Display S, Else, Display as N.(Document type to print 'S' or 'N') The field InvoiceSimplifiedArticles7 .2_7.3 should only be reported when the type of invoice is F1, F3, R1, R2, R3, R4. Tag name: <sum1:FacturaSimplificad aArticulos7.2_7.3>
Late Submission Optional – Yes Length -1 – Type -Char Possible values are Y or N. JE_ZZ_VAT _REP_TRX_ T je_info_v25 IF Late Submission GDF is set to Y, Display ‘S’, Else Display ‘N’ End if Tag RegPrevioGGEEoREDEME oCompetencia (Y/N indicator). This tag is marked if transaction can’t be reported in time due to one of the reasons indicated in the name.
External Reference Optional – Yes Length -1 – Type -Char Possible values are Y or N. - je_info_v24 External reference – Journal number Tag -<sum1:RefExterna>
Reverse Charge - - je_info_v23 - -

Issued Invoices Register

The table explains the new columns in extract included for SII Version1.1 changes and provides information and the purpose of the new column to be used in XSL tags.

Extract Column Data Type Extract Table Column Name Values Description
Simplified invoice Optional – Yes Length -1 Type -Char Possible values are Y or N. JE_ZZ_VAT _REP_TRX_ T je_info_v24 IF Simplified Invoice GDF is set to Yes, Display S, Else, Display as N.(Document type to print 'S' or 'N') The field InvoiceSimplifiedArticles7 .2_7.3 should only be reported when the type of invoice is F1, F3, R1, R2, R3, R4. Tag name: <sum1:FacturaSimplificad aArticulos7.2_7.3>
Late Submission Optional – Yes Length -1 – Type -Char Possible values are Y or N. JE_ZZ_VAT _REP_TRX_ T je_info_v23 IF Late Submission GDF is set to Y, Display ‘S’, Else Display ‘N’ End if Tag RegPrevioGGEEoREDEME oCompetencia (Y/N indicator). This tag is marked if transaction can’t be reported in time due to one of the reasons indicated in the name.
External Reference Optional – Yes Length -1 – Type -Char Possible values are Y or N. - je_info_v14 External reference – Journal number Tag -<sum1:RefExterna>
Invoice without counterpart - - je_info_v28 - -
Note: In Issued Invoices Register, in block <TipoDesglose> add the tag <DetalleExenta> to allow subdividing the exempt amount depending on the exemption reason, which are now compatible. This process doesn’t require any additional values from the extract because the solution displays one exempt amount only if applies.

Selected Intra-EU Transactions Register

The table explains the new columns in the extract included for SII Version1.1 changes and provides information and the purpose of the new column to be used in XSL tags. This table selected Intra-EU Transaction Register changes in SII Version 1.1.

Extract Column Data Type Extract Table Column Name Values Description
Late Submission

Optional – Yes

Length -1

Type -Char

Possible Values - Y/N

 JE_ZZ_VAT_REP_TRX_T je_info_v23 IF Late Submission GDF is set to Y, Display ‘S’,

Else Display ‘N’

End if

 Tag RegPrevioGGEEoREDEME oCompetencia (Y/N indicator)

This tag is marked if transaction can’t be reported in time due to one of the reasons indicated in the name.
External Reference Optional - je_info_v14 External reference journal number Tag -<sum1:RefExterna>

Collections for the Received Invoices Register

There are no changes introduced in SII Version 1.1 extract.

Payments Register

There are no changes introduced in SII Version 1.1 extract.