Le but de cette documentation est de définir les modalités de l'archivage fiscal :
...
Columns | Explanation |
---|---|
RESERVATION_TAX_TOTAL_ID | ID for the tax total record of a reservation |
ENTRYDATE | Timestamp when the entry was made in the format YYYYMMDDHHMMSS |
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 | Reservationbill for which the tax total record is created. There can be up to 3 payer types (e.g. 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. 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 counter |
RELATIVE_TOTAL | Relative total amount counter |
SIGNATURE | Signature for the invoice |
PREVIOUS_SIGNATURE | Signature for the previous invoice |
EMPLOYEE_ID | ID of the employee creating the tax total record |
DOCUMENT_NUMBER | Number of the document |
DOCUMENT_TYPE | Type of document (e.g. invoice, receipt) |
INVOICE_TYPE | Type of invoice (e.g. product, service or mix). |
CUMULATIVE_DAY | Cumulative counter per document_type per day |
CUMULATIVE_MONTH | Cumulative counter per document_type per month |
CUMULATIVE_YEAR | Cumulative counter per document_type per year |
OPERATION_TYPE | Type of operation (e.g. sale, refund) |
TOTAL_NO_OF_BILL_LINES | Total number of bill lines on a ticket |
TOTAL_VAT | Total value-added tax (VAT) amount |
NO_OF_PRINTS | Total number of prints of the document |
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 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. |
MUTATION_ID | The ID of the payment for which the down payment invoice is generated. |
REVERTED_INVOICE_ID | The ID of the invoice for which the credit invoice is created. |
DISTRIBUTIONCHANNEL_ID | The ID of the agent for which the agent bill invoice is issued |
DC_NAME | Name of the agent |
DC_ADDRESS1 | Address line of the agent |
DC_ZIPCODE | Zipcode of the agent |
DC_CITY | City of the agent |
DC_COUNTRY_NAME | Country of the agent |
DC_VAT_NUMBER | VAT number of the agent |
LOCATION_ID | The ID of the holiday destination location for which the invoice is issued |
LOCATION_NAME | The name of the holiday destination location for which the invoice is issued |
FILE_ID | The ID of the generated PDF document for the invoice. |
Reservation_Tax_Report:
Columns | Explanation |
---|---|
RESERVATION_TAX_ID | ID of the record in Reservation_tax_total |
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 |
DP_RESERVATION_TAX_TOTAL_ID | ID of the down payment invoice record for which VAT is reverted based on issueing final invoice |
Eventlog_report
Columns | Explanation |
---|---|
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. |
...