...
Main Columns | Details |
|---|---|
RESERVATION_TAX_ID | |
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
Main Columns | Details |
|---|---|
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. |
...
Main Columns | Details |
|---|---|
RESERVATION_BILL_SNAPSHOT_ID | |
RESERVEDRESOURCE_ID | |
RESERVATION_ID | Internal backend reference ID for reservation |
RESOURCE_TYPE | |
RESOURCE_NAME | |
CASHFLOWRULE_NAME | Identifyer of bill lines |
START_DATE | |
END_DATE | |
VALUE | Base amount of resource |
QUANTITY | Quantity of resource in bill |
MULTIPLIER | |
TOTAL | Total amount per resource in bill |
OVERRIDE_VALUE | |
VIRTUAL_OVERRIDE_VALUE | Updated bill amounts including VAT after price override |
VAT_RATE | VAT rate per resource in bill |
EXTRA_ISWARRANT | |
PAY_AT_RESORT | |
STAY_ARTICLE | |
WITHHOLDINGARTICLE | |
OVERRIDE_EMPLOYEE_ID | |
OVERRIDE_EMPLOYEE_NAME | |
OVERRIDE_REASON | |
BILL_LINE_TYPE | |
TOTAL_EXCL_VAT | Bill amounts excluding VAT |
ADMIN_ORGANISATION_ID | |
PAYER_TYPE | |
CODE | |
ENTRY_DATE | |
VALUE_EXCL_VAT | |
TOTAL_VAT | |
SEQUENCE_NUMBER |
...
Main Columns | Details |
|---|---|
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 |
AMOUNT | |
MUTATION_DATE | |
AMOUNT_IN_PAYER_CURRENCY | |
STATEMENT_NUMBER | |
ORIGIN_MUTATION_ID | |
BANKSTATEMENT_ID | |
PAYMENTREFERENCE_NUMBER | |
PAYMENT_NUMBER | |
CHEQUE_NUMBER | |
MONEYORDER_NUMBER | |
EMPLOYEE_ID | ID of entity registering the transaction |
EMPLOYEE_NAME | Name of entity registering the transaction |
ACCOUNT_ID | |
ACCOUNT_NAME | Name of payment method |
ADMIN_ORGANISATION_ID | |
ADMIN_ORGANISATION_NAME | Name of the legal entity the archive is created for |
Signature_file
Main Columns | Details |
|---|---|
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 |
...