Page Comparison

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

RESERVATION_TAX_TOTAL_ID

ENTRYDATE

ADMIN_ORGANISATION_ID

ADMIN_ORGANISATION_NAME

ADMIN_ORGANISATION_DESCRIPTION

LEGAL_NAME

VAT_NUMBER

CHAMBER_OF_COMMERCE_NUMBER

RCS_CITY_OF_REGISTRATION

SOCIAL_CAPITAL

NAF_CODE

APE_CODE

SIRET

SIREN

ADDRESS1

HOUSENUMBER

HOUSENUMBER_SUFFIX

ZIPCODE

CITY

COUNTRY

PAYERTYPE

GRAND_TOTAL_TYPE

RESERVATION_ID

RESERVATION_NUMBER

GRAND_TOTAL

ABSOLUTE_TOTAL

RELATIVE_TOTAL

SIGNATURE

PREVIOUS_SIGNATURE

EMPLOYEE_ID

DOCUMENT_ID

DOCUMENT_TYPE

INVOICE_TYPE

CUMULATIVE_DAY

CUMULATIVE_MONTH

CUMULATIVE_YEAR

OPERATION_TYPE

TOTAL_NO_OF_BILL_LINES

TOTAL_VAT

INVOICE_DATE

SERVICE_EXECUTION_DATE

CUSTOMER_ID

CUSTOMER_NAME

CUSTOMER_ADDRESS1

CUSTOMER_ZIPCODE

CUSTOMER_CITY

CUSTOMER_COUNTRY_NAME

PAYING_CUSTOMER_COMPANY_NAME

PAYING_CUSTOMER_VAT_NUMBER

INVOICE_CREATOR_ID

NF525_VERSION

SOFTWARE_NAME

RESERVATION_TAX_ID

RESERVATION_TAX_TOTAL_ID

TAX_PERCENTAGE

TAX_AMOUNT

RESOURCE_AMOUNT_INCL_TAX

RESOURCE_AMOUNT_EXCL_TAX

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_ID

RESERVEDRESOURCE_ID

RESERVATION_ID

RESOURCE_TYPE

RESOURCE_NAME

CASHFLOWRULE_NAME

START_DATE

END_DATE

VALUE

QUANTITY

MULTIPLIER

TOTAL

OVERRIDE_VALUE

VIRTUAL_OVERRIDE_VALUE

VAT_RATE

EXTRA_ISWARRANT

PAY_AT_RESORT

STAY_ARTICLE

WITHHOLDINGARTICLE

OVERRIDE_EMPLOYEE_ID

OVERRIDE_EMPLOYEE_NAME

OVERRIDE_REASON

BILL_LINE_TYPE

TOTAL_EXCL_VAT

ADMIN_ORGANISATION_ID

PAYER_TYPE

CODE

ENTRY_DATE

VALUE_EXCL_VAT

TOTAL_VAT

SEQUENCE_NUMBER

MUTATION_

ID

RESERVATION_ID

RESERVATION_NUMBER

PAYER_TYPE

AMOUNT

MUTATION_DATE

AMOUNT_IN_PAYER_CURRENCY

STATEMENT_NUMBER

ORIGIN_MUTATION_ID

BANKSTATEMENT_ID

PAYMENTREFERENCE_NUMBER

PAYMENT_NUMBER

CHEQUE_NUMBER

MONEYORDER_NUMBER

EMPLOYEE_ID

EMPLOYEE_NAME

ACCOUNT_ID

ACCOUNT_NAME

ADMIN_ORGANISATION_ID

ADMIN_ORGANISATION_NAME

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