Anhang 4 – Termintypen

 

Im folgenden ist die Liste der zu den Termintypen gehörigen Zusatzfelder.

In der Spalte Feldnamen wird ggf festgelegt woher die Daten kommen:

 

programm: die Daten kommen aus den Progammen

adrselect: die Daten kommen aus den Adressen. Dahinter steht Feldname im Formular gefolgt vom Adresstyp, nach dem während der Auswahl standardmäßig gefiltert wird

Position legt die Reihenfolge der Felder am Bildschirm fest.

Zeilen gibt an wie groß das Feld im Formular dargestellt wird.


 

  Typ                                       Bleistift

     Abkz.                        PENC

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Künstler.Künstler                                                    1

                                         1  adrselect.Halle.Halle                                                               1

                                         2  Ort                                                                                          1

                                         3  Beginn                                                                                    1

                                         4  adrselect.Veranstalter.Veranstalter                                        1

                                         5  adrselect.Orchester.Orchester                                              1

                                         6  adrselect.Dirigent.Dirigent                                                      1

                                         7  Partner                                                                                    4

                                         8  Programm                                                                              6

                                         9  Honorar                                                                                   1

                                       10  Reise                                                                                      4

  Typ                                       Dienstleistung

     Abkz.                        SRVC

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Kunde.Kunde                                                          1

                                         2  Kontakt                                                                                   1

                                         3  adrselect.Wer.EDV                                                                1

                                         4  Tätigkeit                                                                                  3

                                         5  Dauer                                                                                      1

                                         6  Bemerkung                                                                             3

                                         7  Betrag_pro_Stunde                                                                1

                                         8  Honorar                                                                                   1

                                         9  RechNr                                                                                   1

  Typ                                       frei

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 1 VON 8


     Abkz.                        FREE

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.wer.Person                                                             1

                                         2  wo_erreichbar                                                                        4

  Typ                                       Geburtstag

     Abkz.                        GEB

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Wer.Person                                                            1

                                         2  Hinweis                                                                                   6

  Typ                                       Hotelaufenthalt

     Abkz.                        HOTL

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Wer.Person                                                            1

                                         2  adrselect.Hotel.Hotel                                                              1

                                         3  Anreise                                                                                   1

                                         4  Abreise                                                                                   1

                                         5  Einzelzimmer                                                                         1

                                         6  Doppelzimmer                                                                        1

                                         7  Suiten                                                                                     1

                                         8  EZ_Preis                                                                                 1

                                         9  DZ_Preis                                                                                1

                                       10  SU_Preis                                                                                1

                                       10  Hinweise                                                                                 4

  Typ                                       Künstlerauftritt

     Abkz.                        KSTL

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Künstler.Künstler                                                    1

                                         2  adrselect.Partner.Künstler                                                     1

                                         3  adrselect.Partner2.Künstler                                                   1

                                         4  adrselect.Partner3.Künstler                                                   1

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 2 VON 8


                                         5  adrselect.Partner4.Künstler                                                   1

                                         6  adrselect.Orchester.Orchester                                              1

                                         7  adrselect.Dirigent.Dirigent                                                      1

                                         8  adrselect.Veranstalter.Veranstalter                                        1

                                         9  Kontakt                                                                                   1

                                       10  adrselect.Halle.Halle                                                               1

                                       11  adrselect.TourneeLtg.Tourneeleitung                                    1

                                       12  adrselect.Hotel.Hotel                                                              1

                                       13  Ankunft                                                                                    1

                                       14  Abreise                                                                                   1

                                       15  Travelinfo                                                                                4

                                       16  Hinweise                                                                                 6

                                       17  Proben                                                                                    4

                                       18  Anmerkung                                                                             4

                                       19  Kartenwunsch                                                                        1

                                       20  Honorar                                                                                   1

                                       21  Anmerk_Honorar                                                                    1

                                       22  sonstige_Verg                                                                        1

                                       23  Mitschnitt                                                                                1

                                       24  Mitschnitthonorar                                                                    1

                                       25  Provision                                                                                 1

                                       26  programm.Programm.ID                                                        1

                                       27  Fotos_verschickt                                                                    1

                                       28  Bios_verschickt                                                                      1

                                       29  druckf_Programm                                                                  1

                                       30  MwSt                                                                                       1

                                       31  MwSt_Freistell                                                                        1

                                       32  Info_verschickt                                                                       1

                                       33  Veranstaltungsname                                                              1

                                       34  Notenwender                                                                          1

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 3 VON 8


                                       35  Konzertkleidung                                                                      1

                                       36  Auszahl_Modus                                                                      1

                                       37  Ausl_LSt                                                                                 1

                                       38  als_Text_vers                                                                         1

                                       39  VertragNr                                                                                1

                                       40  Vert_A_an_Veran                                                                   1

                                       41  Vert_A_an_Kstl                                                                       1

                                       42  Vert_B_an_Veran                                                                   1

                                       43  Vert_B_an_Kstl                                                                      1

  Typ                                       Künstlerprobe

     Abkz.                        KPRB

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Künstler.Künstler                                                    1

                                         2  adrselect.Halle.Halle                                                               1

                                         4  Dauer                                                                                      1

                                         5  Wegbeschreibung                                                                  9

  Typ                                       Orchesterauftritt

     Abkz.                        KONZ

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Orchester.Orchester                                              1

                                         2  adrselect.Tourneeleitung.Tourneeleitung                               1

                                         3  adrselect.Dirigent.Dirigent                                                      1

                                         4  adrselect.Künstler.Künstler                                                    1

                                         5  Partner                                                                                    5

                                         6  programm.Programm.ID                                                        1

                                         7  adrselect.Veranstalter.Veranstalter                                        1

                                         8  Kontakt                                                                                   1

                                         9  adrselect.Halle.Halle                                                               1

                                       10  Mitschnitt                                                                                1

                                       11  Honorar                                                                                   1

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 4 VON 8


                                       12  Auszahlungsmodus                                                               1

                                       13  sonst_Vergütung                                                                    1

                                       14  Hinweise                                                                                 4

                                       15  nur_intern                                                                               4

                                       16  Proben                                                                                    4

                                       17  adrselect.Hotel.Hotel                                                              1

                                       18  Ankunft_Hotel                                                                         1

                                       19  Abreise_Hotel                                                                         1

                                       20  EZ                                                                                           1

                                       21  EZ_Preis                                                                                 1

                                       22  DZ                                                                                           1

                                       23  DZ_Preis                                                                                1

                                       24  SU                                                                                           1

                                       25  SU_Preis                                                                                1

                                       26  Stühle                                                                                     1

                                       27  Pulte                                                                                       1

                                       28  Dirigentenpult                                                                         1

                                       29  Dirigentenpodest                                                                    1

                                       30  Kontrabasshocker                                                                  1

                                       31  Freikarten                                                                               1

                                       32  Abendprogramme                                                                  1

                                       33  Plakate                                                                                    1

                                       34  Konzertflügel                                                                          1

                                       35  Stimmung_Flügel                                                                   1

                                       36  Orchesterklavier                                                                     1

                                       37  stimmung_oklavier                                                                 1

                                       38  Konzertcembalo                                                                     1

                                       39  Stimmung_Konzcemb                                                           1

                                       40  Continuocembalo                                                                   1

                                       41  Stimmung_Contiuo                                                                1

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 5 VON 8


                                       42  Konzertkleidung                                                                      1

                                       43  Instr_Transport                                                                       2

                                       44  Sonstige                                                                                 1

                                       45  Instr_Lieferzeit                                                                        1

                                       46  Hilfskräfte                                                                                1

                                       47  Reisen                                                                                    1

                                       48  Bus                                                                                         1

                                       49  Bahn                                                                                       1

                                       50  Flug                                                                                         1

                                       51  Vertragsnummer                                                                    1

                                       52  Vertrag_an_Veranstalter                                                        1

                                       53  Freistellung_MwSt                                                                  1

                                       54  Bios_verschickt                                                                      1

                                       55  Photos_verschickt                                                                  1

                                       56  druckfertiges_Programm                                                       1

                                       57  Klauseln                                                                                  9

                                       58  gedruckt                                                                                  1

  Typ                                       Orchesterprobe

     Abkz.                        OPRB

                              Position  Feldname                                                                        Zeilen

                                         0  adrselect.Orchester.Orchester                                              1

                                         1  adrselect.Saal.Halle                                                               1

                                         2  Dauer                                                                                      1

  Typ                                       Reise

     Abkz.                        TRVL

                              Position  Feldname                                                                        Zeilen

                                         0  adrselect.Wer.Person                                                            1

                                         1  Verkehrsmittel                                                                        1

                                         3  adrselect.Reisebegleitung.Person                                         1

                                         4  Abfahrt_ab                                                                              2

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 6 VON 8


                                         5  Ankunft_in                                                                               2

                                         5  Anmerkung                                                                             4

  Typ                                       Schulung

     Abkz.                        SCHL

                              Position  Feldname                                                                        Zeilen

                                         1  adrselect.Teilnehmer.Kunde                                                  1

                                         1  adrselect.Lehrer.Künstler                                                       1

  Typ                                       Termin

     Abkz.                        TERM

                              Position  Feldname                                                                        Zeilen

                                         0  adrselect.Wer.Person                                                            1

                                         2  Kontakt                                                                                   1

                                         3  adrselect.Wer2.Person                                                          4

                                         4  Nachricht                                                                                4

  Typ                                       Tournee

     Abkz.                        TRNE

                              Position  Feldname                                                                        Zeilen

                                         1  Enddatum                                                                               1

                                         2  adrselect.Solist.Künstler                                                        1

                                         3  adrselect.Orchester.Orchester                                              1

                                         4  adrselect.Dirigent.Dirigent                                                      1

                                         5  adrselect.Veranstalter.Veranstalter                                        1

                                         6  adrselect.Tourneeleitung.Tourneeleitung                               1

                                         7  Honorar                                                                                   1

                                         8  Klauseln                                                                                  9

                                         9  adrselect.Nebenanbieter.Veranstalter                                    1

                                       10  Hotelkosten                                                                             1

  Typ                                       Urlaub

     Abkz.                        HOLI

                              Position  Feldname                                                                        Zeilen

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 7 VON 8


                                         0  Urlaubsanschrift                                                                     6

  Typ                                       Verkauf

     Abkz.                        VERK

                              Position  Feldname                                                                        Zeilen

                                         0  adrselect.Käufer.Kunde                                                         1

                                         1  adrselect.Verkäufer.Lieferant                                                 1

                                         2  Gegenstand                                                                            1

                                         3  Anzahl                                                                                     1

                                         4  Einzelpreis                                                                              1

                                         5  Gesamtpreis                                                                           1

Tutorial AgencyProf, © 2004 Karsten Kaus, PC- und Internetdienste

                                                                                                                                   SEITE 8 VON 8