...
Pour chaque fichier, une explication plus détaillée des principales colonnes est donnée :
...
Document Name
...
Main Columns
...
Details
*Reservation_tax_total_report
Ce fichier contient tous les grands totaux (GTT, GTF, GTP, GTM, GTA
...
) pour l'archive créée, qui est enregistrée dans nf525_reservation_tax_total
...
et les valeurs et montants des taxes applicables provenant de la table reservation_tax_total
...
Operation type, electronic signatures, customer details, issueing entity details, operation type, NF version, software name
...
Furthermore, the following ticket and invoice details are included
.
En outre, les détails suivants du ticket et de la facture sont inclus : type d'opération, signatures électroniques, détails du client, détails de l'entité émettrice, type d'opération, version NF, nom du logiciel.
*Reservation_tax_report
Les principales colonnes sont les suivantes :
RESERVATION_TAX_TOTAL_ID
...
: ID de l'enregistrement correspondant dans Reservation_tax_total_report.
TAX_PERCENTAGE
...
Identifier of VAT rate for the record
...
TAX_AMOUNT
...
VAT amount for VAT rate
: identifiant du taux de TVA pour l'enregistrement.
TAX_AMOUNT : Montant de la TVA pour le taux de TVA
RESOURCE_AMOUNT_INCL_TAX
...
: Montant total de la facture incluant la TVA pour le taux de TVA
RESOURCE_AMOUNT_EXCL_TAX
...
Total bill amount excluding VAT for the VAT rate
...
: montant total de la facture hors TVA pour le taux de TVA.
*Eventlog_report
Les principales colonnes sont les suivantes :
EVENTLOG_ID
...
ID for record in database
...
EMPLOYEE
...
: ID de l'enregistrement dans la base de données.
EMPLOYEE : Employé exécutant l'événement qui conduit à l'enregistrement dans le journal des événements
EVENT_TYPE
...
: Eventcodes NF525
...
EVENT_TYPE_DESCRIPTION
...
: Désignation du type d'événement NF525
EVENT_TIME
...
: Heure de l'événement
OLD_VALUE_VARCHAR2
...
: ID de l'enregistrement initial de l'événement dans la clé primaire de la table particulière.
OLD_VALUE_DESCRIPTION
...
: Ancienne valeur, si applicable.
NEW_VALUE_VARCHAR2
...
: ID de l'enregistrement de l'événement dans la clé primaire de la table particulière.
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.
: Nouvelle valeur, si applicable.
SIGNATURE : Signature électronique du numéro de l'événement
PREVIOUS_SIGNATURE : Signature électronique du numéro de l'événement précédent.
EVENT_NUMBER : Numéro séquentiel de l'événement.
*Reservation_Bill_Snapshot
Les principales colonnes sont les suivantes :
RESERVATION_
...
ID : ID de référence interne du backend pour la réservation.
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
: Identificateur des lignes de facturation
VALUE : Montant de base de la ressource
QUANTITY : Quantité de la ressource dans la facture
TOTAL : Montant total par ressource dans la facture
VIRTUAL_OVERRIDE_VALUE : Montants de la facture actualisés, y compris la TVA, après le remplacement du prix.
VAT_RATE : Taux de TVA par ressource dans la facture
TOTAL_EXCL_VAT : Montant de la facture hors TVA.
*Payment details report
MUTATION_ID : ID
...
backend interne pour la transaction
RESERVATION_ID
...
: ID de référence interne du backend pour la réservation
RESERVATION_NUMBER
...
Reservation number
: Numéro de réservation
PAYER_TYPE
...
Payment made by Customer, Paying Customer or Agent
...
DEBIT
...
Amount for incoming transaction
...
CREDIT
...
: Paiement effectué par le client, le client payeur ou l'agent.
DEBIT : Montant de la transaction entrante
CREDIT : Montant de la transaction sortante
MUTATION_DATE
...
: Date d'enregistrement de la transaction dans le système
DEBIT_PAYER_CURRENCY AMOUNT
...
: Montant de la transaction entrante dans la devise de réservation
CREDIT_PAYER_CURRENCY AMOUNT
...
: Montant de la transaction sortante dans la devise de réservation
EMPLOYEE_ID
...
: ID de l'entité qui enregistre la transaction.
EMPLOYEE_NAME
...
: Nom de l'entité qui enregistre la 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
...
: Nom du mode de paiement
ADMINORGANISATION_NAME : Nom de l'entité juridique pour laquelle l'archive est créée
*signature_file
SIGNATURE : Signature électronique créée pour l'archive fiscale créée sur la base des paramètres d'entrée tels que décrits précédemment dans ce document.
PREVIOUS_SIGNATURE : Signature électronique créée précédemment.
------ENGLISH TEXT BELOW------
...
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.
*Reservation_tax_report
Main columns are:
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
Main columns are:
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
Main columns are:
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.
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 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 |