...
Documentation en français
HOW TO READ THE ARCHIVE
The fiscal archive is created for invoices and tickets created within the date range selected before creating an archive. A zipfile is created with multiple Excel files which hold the details of relevant invoices and tickets. Furthermore, this explanatory file is part of the created fiscal archive.
The integrity of the file is controlled via the created electronic signature which is added separately in the file. To generate the electronic signature, there are the following input parameters:
Tax incl. amounts broken down per vat rate
Tax incl. amounts of the period
Operation timestamp
Terminal/POS code
Operation type
Previous signature Y/N
If present, previous electronic signature
THE ARCHITECTURE OF THE ARCHIVE
For each generated archive a zip file is created. That file is stored in a Google Cloud Storage Bucket and made accessible through the software as a download option.
Before the zipfile is created, all required files are being build up. Mostly by exporting data from the Oracle database into a csv file, combined with this pdf, it’s packaged together in a zip archive. For this zip file we generate a signature hash and store this in the database.
THE CONTENT OF THE ARCHIVE
...
COMMENT LIRE LES ARCHIVES
L'archive fiscale est créée pour les factures et les tickets créés dans la plage de dates sélectionnée avant de créer une archive. Un fichier zip est créé avec plusieurs fichiers Excel qui contiennent les détails des factures et des tickets concernés. En outre, ce fichier explicatif fait partie de l'archive fiscale créée.
L'intégrité du fichier est contrôlée par la signature électronique créée qui est ajoutée séparément dans le fichier. Pour générer la signature électronique, les paramètres d'entrée suivants sont nécessaires :
Taxes comprises, montants décomposés par taux de tva
Montants TTC de la période
Horodatage de l'opération
Code terminal/POS
Type d'opération
Signature précédente O/N
Si présente, signature électronique précédente
L'ARCHITECTURE DE L'ARCHIVE
Pour chaque archive générée, un fichier zip est créé. Ce fichier est enregistré dans un Google Cloud Storage Bucket et rendu accessible par le logiciel en tant qu'option de téléchargement.
Avant la création du fichier zip, tous les fichiers requis sont constitués. Principalement en exportant les données de la base de données Oracle dans un fichier csv, combiné avec ce pdf, le tout est rassemblé dans une archive zip. Pour ce fichier zip, nous générons un hash de signature et l'enregistrons dans la base de données.
LE CONTENU DES ARCHIVES
Les fichiers de l'archive sont les suivants :
*Reservation_Tax_Total_Report: This is the main file in the fiscal archive with almost all details related to invoices, tickets and periodical closing totalsIl s'agit du principal fichier des archives fiscales, qui contient presque tous les détails relatifs aux factures, aux tickets et aux totaux de clôture périodiques.
*Reservation_Tax_Report: This document holds VAT specifics on ticket/invoice level Ce document contient les spécificités de la TVA au niveau des tickets/factures.
*Eventlog_Report: This Ce document holds JET data for selected daterange, which is stored in contient les données JET pour la gamme sélectionnée, qui sont enregistrées dans la table nf525_eventlog table.
*Reservation_Bill_Snapshot_Report: This document contains a snapshot of the bill, everytime a transaction on the reservation performed. Data is stored in Ce document contient un extrait de la facture, chaque fois qu'une transaction sur la réservation est effectuée. Les données sont enregistrées dans la table reservation_bill_snapshot table.
*Payment: This file holds received payment detailsCe document contient les détails des paiements reçus.
*signature_file: This document contains the electronic signature of the archive, as well as electronic signature of previous fiscal archive (if applicable).
...
Ce document contient la signature électronique de l'archive, ainsi que la signature électronique de l'archive fiscale précédente ( si elle existe).
Pour chaque fichier, une explication plus détaillée des principales colonnes est donnée :
Reservation_tax_total_report | GTT, GTF, GTP, GTM, GTA, | This file holds all grand totals for the archive created, which is stored in nf525_reservation_tax_total and the applicable tax values and amounts from reservation_tax_total table. |
operation type, electronic signatures, customer details, issueing entity details, operation type, NF version, software name | Furthermore, the following ticket and invoice details are included | |
Reservation_tax_report | RESERVATION_TAX_TOTAL_ID, TAX_PERCENTAGE, TAX_AMOUNT, RESOURCE_AMOUNT_INCL_TAX, RESOURCE_AMOUNT_EXCL_TAX | Contains corresponding record ID, VAT rate identifier, VAT amount, total bill amount incl. and excl. VAT. |
Eventlog_report | EVENTLOG_ID, EMPLOYEE, EVENT_TYPE, EVENT_TYPE_DESCRIPTION, EVENT_TIME, OLD_VALUE_VARCHAR2, OLD_VALUE_DESCRIPTION, NEW_VALUE_VARCHAR2, NEW_VALUE_DESCRIPTION, SIGNATURE, PREVIOUS_SIGNATURE, EVENT_NUMBER | Records database events, includes details such as employee executing event, event type, time, values before and after event, electronic signatures, and sequential event number. |
Reservation_Bill_Snapshot | RESERVATION_ID, CASHFLOWRULE_NAME, VALUE, QUANTITY, TOTAL, VIRTUAL_OVERRIDE_VALUE, VAT_RATE, TOTAL_EXCL_VAT | Contains reservation ID, bill line identifier, base amount, quantity, total amount, updated bill amounts incl. VAT after price override, VAT rate, and bill amount excl. VAT. |
Payment details report | MUTATION_ID, RESERVATION_ID, RESERVATION_NUMBER, PAYER_TYPE, DEBIT, CREDIT, MUTATION_DATE, DEBIT_PAYER_CURRENCY AMOUNT, CREDIT_PAYER_CURRENCY AMOUNT, EMPLOYEE_ID, EMPLOYEE_NAME, ACCOUNT_NAME, ADMINORGANISATION_NAME | Holds transaction information such as transaction ID, reservation ID, reservation number, payment details, date of transaction, employee ID and name, payment method, and legal entity name. |
Signature_file | SIGNATURE, PREVIOUS_SIGNATURE | Contains electronic signature created for fiscal archive based on input parameters and the previously created signature. |
*Reservation_tax_total_report
This file holds all grand totals (GTT, GTF, GTP, GTM, GTA) for the archive created, which is stored in nf525_reservation_tax_total and the applicable tax values and amounts from reservation_tax_total table.
Furthermore, the following ticket and invoice details are included: operation type, electronic signatures, customer details, issueing entity details, operation type, NF version, Software name.
...
------ENGLISH TEXT BELOW------
English Documentation
HOW TO READ THE ARCHIVE
The fiscal archive is created for invoices and tickets created within the date range selected before creating an archive. A zipfile is created with multiple Excel files which hold the details of relevant invoices and tickets. Furthermore, this explanatory file is part of the created fiscal archive.
...
Tax incl. amounts broken down per vat rate
Tax incl. amounts of the period
Operation timestamp
Terminal/POS code
Operation type
Previous signature Y/N
If present, previous electronic signature
THE ARCHITECTURE OF THE ARCHIVE
For each generated archive a zip file is created. That file is stored in a Google Cloud Storage Bucket and made accessible through the software as a download option.
Before the zipfile is created, all required files are being build up. Mostly by exporting data from the Oracle database into a csv file, combined with this pdf, it’s packaged together in a zip archive. For this zip file we generate a signature hash and store this in the database.
THE CONTENT OF THE ARCHIVE
The files in the archive are:
...
*signature_file: This document contains the electronic signature of the archive, as well as electronic signature of previous fiscal archive (if applicable).
Per file, a more detailed explanation of the main columns is given:
*Reservation_tax_total_report
This file holds all grand totals (GTT, GTF, GTP, GTM, GTA) for the archive created, which is stored in nf525_reservation_tax_total and the applicable tax values and amounts from reservation_tax_total table.
Furthermore, the following ticket and invoice details are included: operation type, electronic signatures, customer details, issueing entity details, operation type, NF version, Software name.
...