...
*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
...
detailed explanation of the
...
columns is given:
Reservation_tax_total_report:
Main Columns | Details |
|---|---|
RESERVATION_TAX_TOTAL_ID | ID for the tax total record of a reservation |
ENTRYDATE | Date Timestamp when the entry was made |
ADMIN_ORGANISATION_ID | ID of the administrative organisation |
ADMIN_ORGANISATION_NAME | Name of the administrative organisation |
ADMIN_ORGANISATION_DESCRIPTION | Description of the administrative organisation |
LEGAL_NAME | Legal name of the organisation |
VAT_NUMBER | Value-added tax (VAT) number of the organisation |
CHAMBER_OF_COMMERCE_NUMBER | Chamber of commerce number of the organisation |
RCS_CITY_OF_REGISTRATION | City where the organisation is registered |
SOCIAL_CAPITAL | Amount of social capital of the organisation |
NAF_CODE | Nomenclature of Activities in France (NAF) code |
APE_CODE | Activité principale exercée (APE) code |
SIRET | Système d'identification du répertoire des établissements (SIRET) number |
SIREN | Système d'identification du répertoire des entreprises (SIREN) number |
ADDRESS1 | Address line 1 of the organisation |
HOUSENUMBER | House number of the organisation |
HOUSENUMBER_SUFFIX | House number suffix of the organisation |
ZIPCODE | Zipcode of the organisation |
CITY | City of the organisation |
COUNTRY | Country of the organisation |
PAYERTYPE | Type of payer Reservationbill for which the tax total record is created. There can be up to 3 payer types (e.g. individual, company)customer, paying customer and/or agent) for 1 reservation which each have there own tax total record with relevant details. |
GRAND_TOTAL_TYPE | Type of grand total (e.g. including or excluding tax). This can be GTF (invoice record), GTT (ticket record), GTP (daily closing), GTM (monthly closing) or GTA (yearly closing). |
RESERVATION_ID | ID of the reservation |
RESERVATION_NUMBER | Reservation number |
GRAND_TOTAL | Grand total amount of the reservation |
ABSOLUTE_TOTAL | Absolute total amount (in case of refund)counter |
RELATIVE_TOTAL | Relative total amount (in case of refund)counter |
SIGNATURE | Signature for the invoice |
PREVIOUS_SIGNATURE | Signature for the previous invoice |
EMPLOYEE_ID | ID of the employee creating the invoicetax total record |
DOCUMENT_ID | ID of the document |
DOCUMENT_TYPE | Type of document (e.g. invoice, receipt) |
INVOICE_TYPE | Type of invoice (e.g. finalproduct, proformaservice or mix). |
CUMULATIVE_DAY | Cumulative day |
CUMULATIVE_MONTH | Cumulative month |
CUMULATIVE_YEAR | Cumulative year |
OPERATION_TYPE | Type of operation (e.g. sale, refund) |
TOTAL_NO_OF_BILL_LINES | Total number of bill lines |
TOTAL_VAT | Total value-added tax (VAT) amount |
INVOICE_DATE | Date when the invoice was created |
SERVICE_EXECUTION_DATE | Date when the service was executed |
CUSTOMER_ID | ID of the customer |
CUSTOMER_NAME | Name of the customer |
CUSTOMER_ADDRESS1 | Address line 1 of the customer |
CUSTOMER_ZIPCODE | Zipcode of the customer |
CUSTOMER_CITY | City of the customer |
CUSTOMER_COUNTRY_NAME | Country of the customer |
PAYING_CUSTOMER_COMPANY_NAME | Company name of the paying customer |
PAYING_CUSTOMER_VAT_NUMBER | Company VAT number of the paying customer |
INVOICE_CREATOR_ID | The ID of the employee who created the invoice. |
NF525_VERSION | The version of the NF525 software used to create the invoice. |
SOFTWARE_NAME | The name of the software used to generate the invoice. |
...