P u r p o s e s  VVwin Club Data




C h o i c e   m e n u s

Menu

Stock Data

Menu
  • Stock Data: New stock data are added with the help of a form. The input form contains as an entry always No. (code) and an explicatory text.
  • Table: Stock data are indicated as a table and can be edited.
  • Print: Stock data are printed as a list.

    Belong to the stock data of a club:
    • Divisions.
    • Fees: Club and Divisions.
    • Honours.
    • Functions.
    • Accounts.
    • Accounts System.
    • Cost Centres.
    • Streets.
    • Facilities.
    • Banks with BC and BIC.


Club Stock

Menu
    The Club Data are edited with the help of 4 forms.
  • Names and Addresses:
    · Club Name 1st line appears in forms and reports, 2nd line, in addition, in reports.
    · Short Address becomes with address adhesive labels,
    · Short Cash-Service with the data to bank exchange uses.
    · Short Name.
    · Office Name of the manager or cashier, appears on reminding and notice letters.
    · Phone of the office.
    · Street, Post code City, Post code Mailbox, Email is the club address.
    · Sport Association, Club No., Sport District Name of the responsible sports alliance / sports circle.
  • Banks and Cashs:
    · Bank Account 1 Giro account for all membership fees. Bank code number, Acct. No., Name, Place refers to the 1st bank account. FAS Counter Account is the counter account of the 1st bank for the Financial Accounting.
    · Bank Account 2 is a possible other giro account. Bank code number, Acct. No., Name, Place refers to the 2nd bank account. FAS Counter Account is the counter account of the 2nd bank for the Financial Accounting.
    · Club Cash-box Name of the club cash-box.
    · Division Cash-box from 1 to 3 Names of the divisions with own cash-boxes. Each of the cash-boxes owns own FAS Counter Account. Instead of for cash-boxes the fields can be also used for other finance accounts.
  • Membership Fees:
    · Club Fee Name club fees. q/h/y Booking entry period. Club Code key club fees. FAS Account Booking entry payment club fees.
    · Division Fee from 1 to 5 Division names of the division fees with q/h/y booking entry period, Division Code and Account in the Financial Accounting.
  • Final Accounts:
    · Accounts for the Annual according to account stock.
    · Creditor ID for SEPA payments.

  • Clients: By the start of the program or in the menu item Clients you select the club.
    A flying clients change in the menu item Clients is possible only by an already registered user or as Master!

Settings

  • Settings: You can select language, window size, design and themes. These are associated to the users and their program modules!

  • Authorized Users: Names for users. Enter and remove by the Master.
  • Currency Unit: Definition of the currency unit
    (EUR,DEM,CHF,ATS), (Ct,Pf,Rp,Gr) according to the DTA convention.
  • Sales Tax/Pretax: Definition on Tax/Pretax.
    · Tax/Pretax Accounts Booking entry accounts in the Financial Accounting.
    · Tax Rate of reduced and normal tax rate in %.
  • Files and Folders:
    · Programs and Data Database files and application files.
    · Cash-Service Cash-Service program files.
    · System programs Windows program files.
    · Backup Backup of the database and all client data.
    · Archiving Archive of the databases to the recovery. You become files vvjjmmtt.vvp and vvjjmmtt.log.
    · 2nd Hard disk Backup of the data and programs, if available leave usually blank.
    · Floppy/Stick External backup of the database, e.g., about memory stick or similar as well as for export/import.

Database

Menu
  • BACKUP/RELOAD: The Database Reorganisation, which is callable any time. All data are saved and than the whole database are loaded anew (packed).
  • UPDATE: The Version Update which is automatically executed from vup.vip file (as a rule concerns it around improved forms to the data entry).
  • RESTORE: A Restore Point is called. The database is anew created with the data of a former version.

  • Data unload: For the purpose of an upgrade (e.g., by change of the database structure) the data of all tables of all Clients of the old database are saved in correct form in a backup folder.
  • Data load: For the purpose of an upgrade (e.g., after change of the database structure) the data of all tables of all Clients are loaded in correct form from the backup folder in the new database. Optional old data are deleted.

  • Export: You can protect data of a table in an external file.
    The file has ASCII format, the columns are separated by , text fields are enclosed in '. It carries the name 'tblname.csv'. The stock data are secure/exported always automatically!
  • Import: You can load data from an external file in a table.
    The file has ASCII format, the columns are separated by , text fields are enclosed in '. It carries the name 'tblname.csv' and must have of course the right structure!
    You are asked whether the original data should be extinguished, i.e. the table is emptied. Otherwise the data are suspended to the table, for double occurence it is not checked!
    Pay attention to double codes, otherwise the consistency of the database is endangered!

  • Encoded export: You can protect data of a table in an external file. This happens as on top described with the Export, however, the files are encoded and cannot be read or be used otherwise.
  • Encoded import: You can load data from an external file in a table. This happens as on top described with the Import, however, the files are encoded and cannot be read or be used otherwise.

Years Turn of

  • Years Turn of:

    —> The turn of the year is to be called in the new year!

    The following tables are exported in ASCII files (for the use in other programs and than backup copy; yyyy=Jahr):

    MiSta1yyyy.csv   Members Inquest,
    MiSta1.csv       Members Inquest all years,
    MiSta2yyyy.csv   Statistics Sports Divisions,
    MiSta2.csv       Statistics Sports Divisions all years,
    MiSta3yyyy.csv   Age Structure,
    MiSta3.csv       Age Structure all years.
    BeDat_yyyy.csv   Fee Data,

    The stock data are automatically saved with every change, e.c.:
    StAbt.csv        Division stock,
    Log_yyyy.csv     Logbook.

    The following tables are exported encoded (as backup copy; yy=Jahr):

    MiDat_yyyy.vep   all Member data,
    FiDat_yyyy.vep   Booking data this year,
    FiBlg_yyyy.vep   Voucher Balances data,
    FiBnz_yyyy.vep   Balance data,
    FiBnz.vep        Balance data all years.

    The database is saved codedly in the archive folder as
    VEREINyyyy.vvp    Restore point,
    VVyyyymmdd.vvp    Restore point.

Tools

Menu
  • Change Book: Changes in the data continuance by users are understandable.
  • Log Book: All movements in the program are understandable.
  • Version Book: All updates in the program are recorded.
  • Data Protection Book: All exports and output to printer or file are recorded.

  • R> Prompt: Direct access to R> Prompt and with it to the 4GL-programming language of the DBMS.
  • Report Generator: ... if the given reports aren't enough.
  • Query Builder: ...for the quick Import/Export of Data from others programmes/to other programmes. You can change the struktur of the tables!

  • Languages:
    • In the Menu item Tools/Languages you can edit the linguistic modules.
    • In the Menu item Club Stock/Settings you select the language.
    • How you can develop your language yourself is described in detail in the Help section!
vvClub
Management

© Dr. Hartmut Braun, Karlsruhe
vv

 Club Management

C l u b  D a t a