Fee Distribution by Internal and External Bookings

Technical name: 0LSO_C01_Q0006

Use

This query displays fee distribution by settlement type. The query compares participation and cancellation fees for the current year per course group with those for the previous year, whereby internal and external fees are taken separately.

Free Characteristics

InfoObject

Description

0TRAINGROUP

 Course group

0TRAINTYPE

Course type

0TRAINTYPOTYP

Object type of course type

0TRAINING

Course

0TRAINOTYPE

Object type of course

0TRAINFORM

Delivery method

0LEARNERTYP

Object type of learner

0LEARNER

Learner

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0EVCOSTINFO

Fee indicator

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

&0CYEAR&

Current calendar year

0LSO_C01_CK001

Total bookings

0BOOKING_NO

Number of attendees or participants

0CANCEL_NO

Number of cancellations

0LSO_C01_CK002

Total fees

0BOOKINGFEE

Participation fee

0CANCELFEE

Cancellation fee