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, TAX_PERCENTAGE, TAX_AMOUNT, RESOURCE_AMOUNT_INCL_TAX, RESOURCE_AMOUNT_EXCL_TAX

Contains corresponding record ID, VAT rate identifier, VAT amount, total bill amount incl. and excl. VAT.

Eventlog_report

EVENTLOG_ID, EMPLOYEE, EVENT_TYPE, EVENT_TYPE_DESCRIPTION, EVENT_TIME, OLD_VALUE_VARCHAR2, OLD_VALUE_DESCRIPTION, NEW_VALUE_VARCHAR2, NEW_VALUE_DESCRIPTION, SIGNATURE, PREVIOUS_SIGNATURE, EVENT_NUMBER

Records database events, includes details such as employee executing event, event type, time, values before and after event, electronic signatures, and sequential event number.

Reservation_Bill_Snapshot

RESERVATION_ID, CASHFLOWRULE_NAME, VALUE, QUANTITY, TOTAL, VIRTUAL_OVERRIDE_VALUE, VAT_RATE, TOTAL_EXCL_VAT

Contains reservation ID, bill line identifier, base amount, quantity, total amount, updated bill amounts incl. VAT after price override, VAT rate, and bill amount excl. VAT.

Payment details report

MUTATION_ID, RESERVATION_ID, RESERVATION_NUMBER, PAYER_TYPE, DEBIT, CREDIT, MUTATION_DATE, DEBIT_PAYER_CURRENCY AMOUNT, CREDIT_PAYER_CURRENCY AMOUNT, EMPLOYEE_ID, EMPLOYEE_NAME, ACCOUNT_NAME, ADMINORGANISATION_NAMEHolds transaction information such as transaction ID, reservation ID, reservation number, payment details, date of transaction, employee ID and name, payment method, and legal entity name.

Signature_file

SIGNATURE, PREVIOUS_SIGNATURE

Contains electronic signature created for fiscal archive based on input parameters and the previously created signature.

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