Purpose
Purpose of this article is to describe the underlying logic for generated electronic signatures and clarify how signature-input is mapped to MXT concepts.
Introduction
In accordance with NF requirements, electronic signatures are created when storing:
- GTT (ticket revenue)
- GTF (invoice revenue)
- GTP (daily closing)
- GTM (monthly closing)
- GTA (annual closing)
- Eventlog entries
Base 64url encoded electronic signature is created and stored for GTT, GTF, GTP, GTM, GTA, eventlog in accordance with format requirements. Hence, a 4 digit signature extract is printed on ticket or invoice (position 3, 7, 13, 19 of signature)
An example string for electronic signature is for 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 |