Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...