...
Pour chaque fichier, une explication plus détaillée des principales colonnes est donnée :
Document Name | Main Columns | Details |
|---|---|---|
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 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 | ID for corresponding record in Reservation_tax_total_report |
TAX_PERCENTAGE | Identifier of VAT rate for the record | |
TAX_AMOUNT | VAT amount for VAT rate | |
RESOURCE_AMOUNT_INCL_TAX | Total bill amount including VAT for the VAT rate | |
RESOURCE_AMOUNT_EXCL_TAX | Total bill amount excluding VAT for the VAT rate | |
Eventlog_report | EVENTLOG_ID | ID for record in database |
EMPLOYEE | Employee executing the event which leads to registration in eventlog | |
EVENT_TYPE, | NF525 eventcodes | |
EVENT_TYPE_DESCRIPTION | NF525 naming of event type | |
EVENT_TIME | Time of event | |
OLD_VALUE_VARCHAR2 | Initial record ID of event in particular table primary key. | |
OLD_VALUE_DESCRIPTION | Old value, if applicable | |
NEW_VALUE_VARCHAR2 | Record ID of event in particular table primary key. | |
NEW_VALUE_DESCRIPTION | New value, if applicable | |
SIGNATURE | Electronic signature of event number | |
PREVIOUS_SIGNATURE | Electronic signature of previous event number | |
EVENT_NUMBER | Sequential event number. | |
Reservation_Bill_Snapshot | RESERVATION_ID | Internal backend reference ID for reservation |
CASHFLOWRULE_NAME | Identifyer of bill lines | |
VALUE | Base amount of resource | |
QUANTITY | Quantity of resource in bill | |
TOTAL | Total amount per resource in bill | |
VIRTUAL_OVERRIDE_VALUE | Updated bill amounts including VAT after price override | |
VAT_RATE | VAT rate per resource in bill | |
TOTAL_EXCL_VAT | Bill amounts excluding VAT | |
Payment details report | MUTATION_ID | Internal backend ID for transaction |
RESERVATION_ID | Internal backend reference ID for reservation | |
RESERVATION_NUMBER | Reservation number | |
PAYER_TYPE | Payment made by Customer, Paying Customer or Agent | |
DEBIT | Amount for incoming transaction | |
CREDIT | Amount for outgoing transaction | |
MUTATION_DATE | Date of registering transaction in system | |
DEBIT_PAYER_CURRENCY AMOUNT | Amount for incoming transaction in reservation currency | |
CREDIT_PAYER_CURRENCY AMOUNT | Amount for outgoing transaction in reservation currency | |
EMPLOYEE_ID | ID of entity registering the transaction | |
EMPLOYEE_NAME | Name of entity registering the transaction | |
ACCOUNT_NAME | Name of payment method | |
ADMINORGANISATION_NAME | Name of the legal entity the archive is created for | |
Signature_file | SIGNATURE, | Created electronic signature for the created fiscal archive based on the input parameters as described earlier in this document |
PREVIOUS_SIGNATURE | Previously created electronic signature |
...