Objectif
L'objectif de cet article est de décrire la logique sous-jacente des signatures électroniques générées et de clarifier la manière dont les entrées de signature sont mises en correspondance avec les concepts MXT.
Introduction
Conformément aux exigences de la norme NF, les signatures électroniques sont créées lors de l'enregistrement :
GTT (recettes des tickets)
GTF (recettes des factures)
GTP (clôture quotidienne)
GTM (clôture mensuelle)
GTA (clôture annuelle)
Entrées du journal des événements (Eventlog entries)
Une signature électronique codée en base 64url est créée et enregistrée pour les GTT, GTF, GTP, GTM, GTA, eventlog conformément aux exigences du standard. Ainsi, un extrait de signature à 4 chiffres est imprimé sur le ticket ou la facture (positions 3, 7, 13, 19 de la signature).
Un exemple de chaîne de caractères pour la signature électronique est fourni pour GTT :
2000:750|1000:1999|0550:100,2849,20200419152534,18,SALE,N
GTT signature
| Parameter | Data |
|---|---|
| Amounts (tax incl) brokendown per VAT rate | Fetch amounts per VAT rate from nf525_reservation_tax |
| Total Tax. incl amount of the ticket | Fetch total amount from nf525_reservation_tax_total |
| Operation timestamp | Fetch from nf525_reservation_tax_total column ENTRYDATE |
| Document number (unique) | Fetch from nf525_reservation_tax_total column DOCUMENT_ID |
| Operation type (SALE / REFUND) | Fetch from nf525_reservation_tax_total column DOCUMENT_TYPE |
| Previous signature Y/N | Populate based on presence previous signature |
| Previous signature (if present) | Fetch from nf525_reservation_tax_total column PREVIOUS_SIGNATURE |
GTF signature
| Parameter | Data |
|---|---|
| Amounts (tax incl) brokendown per VAT rate | Fetch amounts per VAT rate from nf525_reservation_tax |
| Total amount of the invoice | Fetch total amount from nf525_reservation_tax_total |
| Timestamp of the operation | Fetch from nf525_reservation_tax_total column ENTRYDATE |
| Invoice number | Fetch from nf525_reservation_tax_total column DOCUMENT_ID |
| Document type | Fetch from nf525_reservation_tax_total column DOCUMENT_TYPE |
| Company name (B2B) or customer name (B2C) | For Customer bill: fetch customer lastname For Paying Customer bill: fetch companyname if populated, otherwise customer name For Agent bill: fetch DC name |
| Customer zip code | For Customer bill: fetch customer zipcode For Paying Customer bill: fetch PC zipcode For Agent bill: fetch fetch DC zipcode |
| VAT number of customer | For Customer bill: do not fetch For Paying Customer bill: fetch from Paying Customer details For Agent bill: fetch from DC |
| Previous signature Y/N | Populate based on presence previous signature |
| Previous signature (in case present) | Fetch from nf525_reservation_tax_total column PREVIOUS_SIGNATURE |
Grand Total signature
| Parameter | Data |
|---|---|
| Amounts (tax incl) brokendown per VAT rate | Fetch from nf525_reservation_tax table based on RESERVATION_TAX_TOTAL_ID for created closing total |
| Cumulative Grand Total of period | Fetch from nf525_reservation_tax_total table column ABSOLUTE_TOTAL for grand total created |
| Cumulative Perpetual Grand Total (real value) | Fetch from nf525_reservation_tax_total table column RELATIVE_TOTAL for grand total created |
| Timestamp of the operation | Fetch from nf525_reservation_tax_total table column ENTRY_DATE |
| Unique ID of period | Fetch from nf525_reservation_tax_total table column DOCUMENT_ID |
| Previous signature Y/N | Check for previous signature for grand_total_type |
| Previous signature (if present) | Use grand_total_type previous signature, if present |
| Document type | Fetch from nf525_reservation_tax_total table column DOCUMENT_TYPE |
Eventlog entry signature
| Parameter | Data |
|---|---|
| Continuous ID | New DB column in nf525_eventlog table, to be implemented via this ticket. |
| Event code | In nf525_eventlog table, fetch from column EVENT_TYPE |
| Additional information | In nf525_eventlog table, fetch from column NEW_VALUE_DESCRIPTION |
| Timestamp | In nf525_eventlog table, fetch from column EVENT_TIME |
| Operator code | In nf525_eventlog table, fetch from column EMPLOYEE |
| POS code | In nf525_eventlog table, fetch from column CONCERN_ID |
| Previous signature Y/N | Check if previous entry with electronic signature is present |
| Previous signature | In nf525_eventlog table, fetch from column PREVIOUS_SIGNATURE |
Fiscal Archive signature
| Parameter | Data |
|---|---|
| Tax incl. amounts brokendown per vat rate | From table nf525_reservation_tax, use total sum of column RESOURCE_AMOUNT_INCL_TAX, separated per value in column TAX_PERCENTAGE (using a pipe | as separator) |
| Tax incl. amounts of the period | From table nf525_reservation_tax_total, use total sum of GRAND_TOTAL column for selected data range |
| Operation timestamp | Timestamp of Fiscal Archive creation |
| Terminal/POS code | Use AO code |
| Operation type | Hardcoded 'archiving' |
| Previous signature Y/N | Check if signature is present |
| If present, previous electronic signature | Previous Fiscal Archive electronic signature |