Introduction

Purpose of this document is the creation of a new dialogue in DaVinci where ADMs and ACMs can be recorded. An ADM may contain many ticket numbers and an amount for each ticket. After entering a ticket number the booking (Vorgang) will be searched.
One ADM/ACM can be assigned to many bookings. The amount then has to be split on all bookings.
Related documents:

Objectives

The functionality will also be needed in DaVinci Retail, so the functionality should be programmed in an external GenVas module that can be used from DaVinci, Genesis and other Desktop tools.
It shall be possible to hide the ADM, ACM values from the end customer (optional).
The function will be used by tour operators to modify the bookings with the ADMs / ACMs received from the airlines.

Terms and Definitions

Term	Description
ACM	Agent Credit Memo: A discount you receive on tickets
ADM	Agent Debit Memo: An additional charge you have to pay for tickets
Refund Application	Refund for the price of a complete ticket

Landscape of Function / Function Group

Functional breakdown

:

Related Functions

BSP Import (Configuration  Import/Export  Import BSP Data)

Impact

Function Description

Recording Refund notes (ADM/ACM)

In this Dialogue you record and book the refunds.

ADM / ACM / Refund

Dialog for adding new ADM /ACM /Refund.

Attributes

Field Name	Type	Mandatory / Default value	Description
ADM / ACM number	Number		Numeric
Airline code	Number		Numeric (leading zeros)
Search	Button		Update Grid (search booking No. related to ticket number)
Assigned bookings			Grid: Shows all bookings where the Ticket No. is included
Ticket No.	Display		Enter the ticket numbers here from the ADM/ACM/Refund
Booking No.	Display		Read only booking number
Amount	Display		Read only amount from booking
Diff. Total	Display		Read only split amount you entered
Diff. Fare	Number		Enter manually an amount, or fill it by pressing "Split equal" button. Then the "Fare" will be equally split on all bookings.
Diff. Tax	Number		Enter manually an amount, or fill it by pressing "Split equal" button. Then the "Tax" will be equally split on all bookings.
Diff. Comm.	Number		Enter manually an amount, or fill it by pressing "Split equal" button. Then the "Diff comm." will be equally split on all bookings.
Diff. Comm. Tax	Number		Enter manually an amount, or fill it by pressing "Split equal" button. Then the "Diff com tax" will be equally split on all bookings.
Fare	Number	N/0	Enter total fare here
Tax	Number	N/0	Enter total tax here
Comm.	Number	N/0	Commission
Comm. Tax	Number	N/0	Tax on Commission
Total	Read only	/0	Shows the sum of Fare + Tax + Comm.+ Comm. Tax
Split evenly	Button	/	See processing
Total tax	Number
Service Name	Dropdown	Y/"ACM"	The text will be shown in the booking (optional also the "Booking remark")
Change also sales price	Checkbox	/not checked	Also a price line for the sales price will be added.
Date of issue	Datetime	No/*	*fill with issue date of first found ticket while pressing search (Manually editable).
Booking remark	Text	No/Empty	Reason for ACM/ADM/Refund. The text you enter here will be shown in the new service line of the booking (together with the service name).
Batch Booking	Button	/	Changes the bookings  See processing
Close	Button		Close windows

Validations / Conditions

Field Name	Description	Error message
Ticket No.	Check input for numeric (0-9)	"Only numeric allowed"
Batch Booking	Sum of "Diff-Total" must add up to "Total" amount	"Total is not equal to sum of amounts"

Processing – Search button

Before you press the search button, you have to add at least one ticket number in the grid.
Pressing the "Search" button then will update the grid with all the booking numbers where the ticket number is included.
Fill also the "Date of issue" with the issue date of first found ticket.

Processing – Split evenly

The value included in the field "Total" will be split evenly to all tickets in the grid in the field "Diff. Total" . The same for "Fare", "Tax", "Comm.", "Comm. Tax".
After this split is done the values in the grid fields can additionally be edited manually.
Before you press the button select the correct "Service name" first!
Because for ACM, and Refund the values will be split and added to the grid with a NEGATIVE value. If you select ADM the values will have a positive value.

Processing – Batch booking

This will execute:

a batch rebooking of all bookings with the tickets in the grid.
Create a NEW entry in the table: PNR_TICKET.
Change the field "???????" in the corresponding ticket in the table PNR_TICKET with the right value (ACM, ADM, REF)

Before the bookings are made, it will be checked, that the sum of the fields in the grid are equal to the total fields. If that is not the case, a warning will be shown and no booking will be executed.
A new line for the service will be created:

For purchase prices
For sales prices (only if following flag is checked)

Flag "Change also Sales prices""

A new line for the service will be created:

For purchase prices
For sales prices

Second Functionality / functional block

First screen

Data model changes

It must be stored in a table, that an ADM / ACM / Refund App. has been made for this Ticket.
At the moment it is only stored with the import of a PNR if a refund has been made for this ticket, now we need information if a refund, an ACM or an ADM has been made in DaVinci.
Store data in existing table PNR_TICKETS.
Alternative: create NEW Tables:
Refund, Tickets_refund

Table TICKETS

Field	Type	Mandatory
DATE_TIME	datetime
ID	int	Y
LEISTUNG_ID	int
TEILNEHMER_ID	int
TICKET_DATE	datetime	Y
TICKET_NR	int	Y
TICKET_STATUS	int	Y
VORGANGS_ID	int	Y
VORGANGS_NR	int	Y

Table PNR_TICKET

Field	Type	Mandatory
AIRLINE	char(6)	No
AUSGEGLICHEN	bit	No
AUSSTELLTAG	datetime	No
BEMERKUNG	char(50)	No
BEST_MONAT_BSP	datetime	No
BETRAG_CASH	float	No
BETRAG_CREDIT_CARD	float	No
BETRAG_KICK_ABGERECHNET	float	No
BETRAG_KICK_BACK	float	No
BETRAG_MAX_FARE	float	No
BETRAG_MIN_FARE	float	No
BETRAG_RATE	float	No
CONJ_ANZ	int	No
CREDIT_CARD	bit	No
CRS_CHECK_NO	char(2)	No
CRS_IMPORT	bit	No
CRS_NUM_1	int	No
CRS_NUM_2	int	No
CUR_EQUI_FARE	char(10)	No
CUR_FARE	char(10)	No
EK_PREIS	float	No
ENDORSEMENT	char(80)	No
EQUI_FARE	float	No
EXPORT	int	No
FARE	float	No
FAREBASE	char(20)	No
FEHLER_LISTE_OK	bit	No
FILE_KEY_1	char(20)	No
FILE_KEY_2	char(20)	No
FORM_OF_PAYMENT	char(80)	No
HANDLING_FEE	float	No
IATA_NR	char(20)	No
ID	int	Yes
INLAND_FLUG	bit	No
KARD_GESELLSCHAFT	char(30)	No
KARD_NO	char(30)	No
KOMMISION_BETRAG	float	No
KOMMISION_PROZENT	float	No
MEHR_FACH_TICKET	bit	No
MITARBEITER	char(6)	No
NETTO	float	No
NON_IATA_TICKET	bit	No
PENALTYSPESEN	float	No
PREISWAHLGRUND	char(6)	No
REFOUND_VORHANDEN	bit	No
RESERVIERT_DATE	datetime	No
STEUER_KOMMISION	float	No
TAX_BETRAG_1	float	No
TAX_BETRAG_2	float	No
TAX_BETRAG_3	float	No
TAX_BETRAG_4	float	No
TAX_KENNUNG_1	char(10)	No
TAX_KENNUNG_2	char(10)	No
TAX_KENNUNG_3	char(10)	No
TAX_KENNUNG_4	char(10)	No
TAX_SUMME	float	No
TEILNEHMER_NAME	char(50)	No
TICKET_ART	int	No
TICKET_DRUCK	bit	No
TICKET_GEBUCHT	bit	No
TICKET_IMPORT_COUNTER	int	No
TICKET_IN_EXCHANGE_FOR	char(20)	No
TICKET_LFD_NO	int	No
TICKET_NO	char(20)	No
TICKET_NO_ZUSATZ	char(20)	No
TOTAL_FARE	float	No
TOURCODE	char(20)	No
UNIQUE_NR	int	No
VKP_TAX	float	No
VKP_TICKET_FARE	float	No
VORGANG_ID	int	No
VORGANG_NO	int	No

Requirement Cross reference

Functional Requirement	Functionality	Chapter/Paragraph
RQ12-x-nn-xxxxxxxx.xls		Chapter x

DaVinci Dokumentationen

ADM ACM

Analytics