The Lino Welfare “Eupen” variant

This page contains code snippets (lines starting with >>>), which are being tested during our development workflow. The following snippet initializes the demo project used throughout this page.

>>> from lino import startup
>>> startup('lino_welfare.projects.gerd.settings.doctests')
>>> from lino.api.doctest import *

Overview

Lino Welfare à la Eupen is the oldest Lino application in the world, it was the first Lino that went into production in 2010.

>>> print(analyzer.show_complexity_factors())
...
- 65 plugins
- 144 models
- 18 user types
- 535 views
- 34 dialog actions
>>> from lino.utils.code import analyze_rst
>>> print(analyze_rst('lino', 'lino_xl', 'lino_welfare'))
============== ============ =========== =============== =============
 name           code lines   doc lines   comment lines   total lines
-------------- ------------ ----------- --------------- -------------
 lino           36.6k        24.9k       11.1k           90.3k
 lino_xl        10.8k        5.9k        2.5k            23.8k
 lino_welfare   5.9k         5.3k        3.0k            17.8k
 total          53.3k        36.1k       16.5k           131.9k
============== ============ =========== =============== =============

Database structure

Overview

This is the list of models used in the Eupen variant of Lino Welfare:

>>> analyzer.show_db_overview()
...
65 plugins: lino, printing, system, about, jinja, bootstrap3, extjs, help,
office, xl, countries, contacts, appypod, humanize, users, contenttypes, gfks,
memo, linod, notify, changes, properties, checkdata, addresses, excerpts,
uploads, outbox, extensible, cal, reception, boards, clients, coachings, pcsw,
welfare, periods, weasyprint, accounting, sepa, b2c, finan, vatless,
languages, cv, integ, isip, jobs, art61, xcourses, newcomers, cbss, households,
humanlinks, debts, notes, aids, summaries, esf, beid, dashboard, export_excel,
dupable_clients, tinymce, staticfiles, sessions.
144 models:
============================== =============================== ========= =======
 Name                           Default table                   #fields   #rows
------------------------------ ------------------------------- --------- -------
 accounting.Account             accounting.Accounts             16        41
 accounting.Journal             accounting.Journals             25        4
 accounting.LedgerInfo          accounting.LedgerInfoTable      2         0
 accounting.MatchRule           accounting.MatchRules           3         2
 accounting.Movement            accounting.Movements            10        580
 accounting.PaymentTerm         accounting.PaymentTerms         12        8
 accounting.Voucher             accounting.AllVouchers          9         56
 addresses.Address              addresses.Addresses             16        175
 aids.AidType                   aids.AidTypes                   21        11
 aids.Category                  aids.Categories                 4         3
 aids.Granting                  aids.Grantings                  12        59
 aids.IncomeConfirmation        aids.IncomeConfirmations        17        60
 aids.RefundConfirmation        aids.RefundConfirmations        18        12
 aids.SimpleConfirmation        aids.SimpleConfirmations        15        19
 art61.Activation               art61.Activations               10        0
 art61.Contract                 art61.Contracts                 38        7
 art61.ContractType             art61.ContractTypes             9         1
 b2c.Account                    b2c.Accounts                    6         34
 b2c.Statement                  b2c.Statements                  8         34
 b2c.Transaction                b2c.Transactions                17        57
 boards.Board                   boards.Boards                   6         3
 boards.Member                  boards.Members                  4         0
 cal.Calendar                   cal.Calendars                   6         11
 cal.EntryRepeater              cal.EntryRepeaterTable          17        0
 cal.Event                      cal.Events                      26        618
 cal.EventPolicy                cal.EventPolicies               20        6
 cal.EventType                  cal.EventTypes                  26        12
 cal.Guest                      cal.Guests                      10        727
 cal.GuestRole                  cal.GuestRoles                  5         4
 cal.RecurrentEvent             cal.RecurrentEvents             22        15
 cal.RemoteCalendar             cal.RemoteCalendars             7         0
 cal.Room                       cal.Rooms                       10        0
 cal.Subscription               cal.Subscriptions               4         9
 cal.Task                       cal.Tasks                       18        40
 cbss.IdentifyPersonRequest     cbss.IdentifyPersonRequests     21        5
 cbss.ManageAccessRequest       cbss.ManageAccessRequests       24        1
 cbss.Purpose                   cbss.Purposes                   6         106
 cbss.RetrieveTIGroupsRequest   cbss.RetrieveTIGroupsRequests   15        6
 cbss.Sector                    cbss.Sectors                    9         209
 changes.Change                 changes.Changes                 10        0
 checkdata.Message              checkdata.Messages              6         12
 clients.ClientContact          clients.ClientContacts          7         14
 clients.ClientContactType      clients.ClientContactTypes      7         10
 coachings.Coaching             coachings.Coachings             8         90
 coachings.CoachingEnding       coachings.CoachingEndings       6         4
 coachings.CoachingType         coachings.CoachingTypes         7         3
 contacts.Company               contacts.Companies              28        51
 contacts.CompanyType           contacts.CompanyTypes           7         14
 contacts.Partner               contacts.Partners               25        174
 contacts.Person                contacts.Persons                32        109
 contacts.Role                  contacts.Roles                  4         13
 contacts.RoleType              contacts.RoleTypes              6         5
 contenttypes.ContentType       gfks.ContentTypes               3         144
 countries.Country              countries.Countries             8         224
 countries.Place                countries.Places                10        80
 cv.Duration                    cv.Durations                    4         5
 cv.EducationLevel              cv.EducationLevels              7         5
 cv.Experience                  cv.Experiences                  18        30
 cv.Function                    cv.Functions                    6         4
 cv.LanguageKnowledge           cv.LanguageKnowledges           10        112
 cv.PersonProperty              cv.PersonProperties             6         310
 cv.Regime                      cv.Regimes                      4         3
 cv.Sector                      cv.Sectors                      5         14
 cv.Status                      cv.Statuses                     4         7
 cv.Study                       cv.Studies                      15        22
 cv.StudyType                   cv.StudyTypes                   7         11
 cv.Training                    cv.Trainings                    17        20
 dashboard.Widget               dashboard.Widgets               5         0
 debts.Account                  debts.Accounts                  12        51
 debts.Actor                    debts.Actors                    6         63
 debts.Budget                   debts.Budgets                   11        17
 debts.Entry                    debts.Entries                   16        871
 debts.Group                    debts.Groups                    7         8
 dupable_clients.Word           dupable_clients.Words           3         130
 esf.ClientSummary              esf.Summaries                   24        189
 excerpts.Excerpt               excerpts.Excerpts               12        77
 excerpts.ExcerptType           excerpts.ExcerptTypes           17        21
 finan.BankStatement            finan.BankStatements            17        0
 finan.BankStatementItem        finan.BankStatementItemTable    10        0
 finan.JournalEntry             finan.FinancialVouchers         16        0
 finan.JournalEntryItem         finan.JournalEntryItemTable     10        0
 finan.PaymentOrder             finan.PaymentOrders             16        26
 finan.PaymentOrderItem         finan.PaymentOrderItemTable     10        220
 households.Household           households.Households           27        14
 households.Member              households.Members              14        63
 households.Type                households.Types                4         6
 humanlinks.Link                humanlinks.Links                4         59
 isip.Contract                  isip.Contracts                  24        34
 isip.ContractEnding            isip.ContractEndings            6         4
 isip.ContractPartner           isip.ContractPartners           8         38
 isip.ContractType              isip.ContractTypes              10        5
 isip.ExamPolicy                isip.ExamPolicies               20        6
 jobs.Candidature               jobs.Candidatures               10        74
 jobs.Contract                  jobs.Contracts                  28        16
 jobs.ContractType              jobs.ContractTypes              9         5
 jobs.Job                       jobs.Jobs                       10        8
 jobs.JobProvider               jobs.JobProviders               30        3
 jobs.JobType                   jobs.JobTypes                   5         5
 jobs.Offer                     jobs.Offers                     9         1
 jobs.Schedule                  jobs.Schedules                  4         3
 languages.Language             languages.Languages             5         5
 linod.SystemTask               linod.SystemTasks               25        8
 memo.Mention                   memo.Mentions                   5         0
 newcomers.Broker               newcomers.Brokers               2         2
 newcomers.Competence           newcomers.Competences           5         7
 newcomers.Faculty              newcomers.Faculties             5         5
 notes.EventType                notes.EventTypes                8         10
 notes.Note                     notes.Notes                     18        118
 notes.NoteType                 notes.NoteTypes                 11        13
 notify.Message                 notify.Messages                 11        13
 outbox.Attachment              outbox.Attachments              4         0
 outbox.Mail                    outbox.Mails                    9         63
 outbox.Recipient               outbox.Recipients               6         63
 pcsw.Activity                  pcsw.Activities                 3         0
 pcsw.AidType                   pcsw.AidTypes                   4         0
 pcsw.Client                    pcsw.Clients                    80        63
 pcsw.Conviction                pcsw.Convictions                5         0
 pcsw.Dispense                  pcsw.Dispenses                  6         0
 pcsw.DispenseReason            pcsw.DispenseReasons            5         4
 pcsw.Exclusion                 pcsw.Exclusions                 6         0
 pcsw.ExclusionType             pcsw.ExclusionTypes             2         2
 pcsw.PersonGroup               pcsw.PersonGroups               4         5
 periods.StoredPeriod           periods.StoredPeriods           7         29
 periods.StoredYear             periods.StoredYears             5         8
 properties.PropChoice          properties.PropChoices          6         2
 properties.PropGroup           properties.PropGroups           5         3
 properties.PropType            properties.PropTypes            8         3
 properties.Property            properties.Properties           6         23
 sepa.Account                   sepa.Accounts                   8         51
 sessions.Session               users.Sessions                  3         ...
 system.SiteConfig              system.SiteConfigs              29        1
 tinymce.TextFieldTemplate      tinymce.TextFieldTemplates      5         2
 uploads.Upload                 uploads.Uploads                 20        17
 uploads.UploadType             uploads.UploadTypes             10        10
 uploads.Volume                 uploads.Volumes                 4         1
 users.Authority                users.Authorities               3         3
 users.User                     users.AllUsers                  29        13
 vatless.AccountInvoice         vatless.Invoices                19        30
 vatless.InvoiceItem            vatless.InvoiceItemTable        7         80
 xcourses.Course                xcourses.Courses                5         3
 xcourses.CourseContent         xcourses.CourseContents         2         2
 xcourses.CourseOffer           xcourses.CourseOffers           6         3
 xcourses.CourseProvider        xcourses.CourseProviders        29        2
 xcourses.CourseRequest         xcourses.CourseRequests         10        20
============================== =============================== ========= =======

Database structure (internal)

>>> print(analyzer.show_database_structure())
...
- accounting.Account : id, name, seqno, ref, common_account, needs_partner, clearable, default_amount, name_fr, name_en, sales_allowed, purchases_allowed, wages_allowed, taxes_allowed, clearings_allowed, bank_po_allowed
- accounting.Journal : id, name, seqno, ref, build_method, template, trade_type, voucher_type, journal_group, auto_check_clearings, auto_fill_suggestions, force_sequence, preliminary, make_ledger_movements, account, partner, printed_name, dc, yearly_numbering, uploads_volume, printed_name_fr, printed_name_en, name_fr, name_en, sepa_account
- accounting.LedgerInfo : user, entry_date
- accounting.MatchRule : id, account, journal
- accounting.Movement : id, project, voucher, seqno, partner, value_date, match, cleared, account, amount
- accounting.PaymentTerm : id, name, ref, days, months, end_of_month, printed_text, informal, printed_text_fr, printed_text_en, name_fr, name_en
- accounting.Voucher : id, user, journal, entry_date, voucher_date, fiscal_year, accounting_period, number, narration
- addresses.Address : id, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, data_source, address_type, partner, remark, primary
- aids.AidType : id, name, contact_person, contact_role, company, excerpt_title, aid_regime, confirmation_type, short_name, board, print_directly, is_integ_duty, is_urgent, confirmed_by_primary_coach, pharmacy_type, address_type, body_template, name_fr, name_en, excerpt_title_fr, excerpt_title_en
- aids.Category : id, name, name_fr, name_en
- aids.Granting : id, start_date, end_date, user, decision_date, board, signer, state, client, aid_type, category, request_date
- aids.IncomeConfirmation : id, start_date, end_date, created, contact_person, contact_role, company, printed_by, user, signer, state, client, granting, remark, language, category, amount
- aids.RefundConfirmation : id, start_date, end_date, created, contact_person, contact_role, company, printed_by, user, signer, state, client, granting, remark, language, doctor_type, doctor, pharmacy
- aids.SimpleConfirmation : id, start_date, end_date, created, contact_person, contact_role, company, printed_by, user, signer, state, client, granting, remark, language
- art61.Activation : id, start_date, end_date, contact_person, contact_role, company, user, client, amount, remark
- art61.Contract : id, signer1, signer2, contact_person, contact_role, printed_by, user, client, language, applies_from, applies_until, date_decided, date_issued, user_asd, exam_policy, ending, date_ended, reference_person, responsibilities, sector, function, duration, remark, company, type, job_title, status, cv_duration, regime, sub_10_amount, sub_10_start, sub_10_end, sub_20_amount, sub_20_start, sub_20_end, sub_30_amount, sub_30_start, sub_30_end
- art61.ContractType : id, name, ref, full_name, exam_policy, overlap_group, template, name_fr, name_en
- b2c.Account : id, iban, bic, account_name, owner_name, last_transaction
- b2c.Statement : id, account, statement_number, start_date, end_date, balance_start, balance_end, local_currency
- b2c.Transaction : id, statement, seqno, amount, remote_account, remote_bic, message, eref, remote_owner, remote_owner_address, remote_owner_city, remote_owner_postalcode, remote_owner_country_code, txcd, txcd_issuer, booking_date, value_date
- boards.Board : id, name, start_date, end_date, name_fr, name_en
- boards.Member : id, board, person, role
- cal.Calendar : id, name, description, color, name_fr, name_en
- cal.EntryRepeater : id, start_date, start_time, end_date, end_time, every_unit, every, positions, monday, tuesday, wednesday, thursday, friday, saturday, sunday, max_events, cal_entry
- cal.Event : id, start_date, start_time, end_date, end_time, modified, created, project, build_time, build_method, user, assigned_to, owner_type, owner_id, summary, description, auto_type, priority, event_type, transparent, guests_edited, room, state, notify_before, notify_unit, notified
- cal.EventPolicy : id, name, start_date, start_time, end_date, end_time, every_unit, every, positions, monday, tuesday, wednesday, thursday, friday, saturday, sunday, max_events, event_type, name_fr, name_en
- cal.EventType : id, name, seqno, ref, attach_to_email, email_template, description, is_appointment, is_public, all_rooms, locks_user, force_guest_states, fill_presences, start_date, event_label, max_conflicting, max_days, transparent, planner_column, default_duration, invite_client, name_fr, name_en, event_label_fr, event_label_en, esf_field
- cal.Guest : id, event, partner, role, state, remark, waiting_since, busy_since, gone_since, waiting_number
- cal.GuestRole : id, name, ref, name_fr, name_en
- cal.RecurrentEvent : id, name, start_date, start_time, end_date, end_time, every_unit, every, positions, monday, tuesday, wednesday, thursday, friday, saturday, sunday, max_events, user, event_type, description, name_fr, name_en
- cal.RemoteCalendar : id, seqno, type, url_template, username, password, readonly
- cal.Room : id, name, contact_person, contact_role, company, display_color, description, calendar, name_fr, name_en
- cal.Subscription : id, user, calendar, is_hidden
- cal.Task : id, start_date, start_time, modified, created, project, user, owner_type, owner_id, summary, description, auto_type, priority, due_date, due_time, percent, state, delegated
- cbss.IdentifyPersonRequest : id, printed_by, user, person, sent, status, environment, ticket, request_xml, response_xml, debug_messages, info_messages, national_id, birth_date, sis_card_no, id_card_no, first_name, last_name, middle_name, gender, tolerance
- cbss.ManageAccessRequest : id, printed_by, user, person, sent, status, environment, ticket, request_xml, response_xml, debug_messages, info_messages, national_id, birth_date, sis_card_no, id_card_no, first_name, last_name, sector, purpose, start_date, end_date, action, query_register
- cbss.Purpose : id, name, sector_code, code, name_fr, name_en
- cbss.RetrieveTIGroupsRequest : id, printed_by, user, person, sent, status, environment, ticket, request_xml, response_xml, debug_messages, info_messages, national_id, language, history
- cbss.Sector : id, name, code, subcode, abbr, abbr_fr, abbr_en, name_fr, name_en
- changes.Change : id, user, time, type, object_type, object_id, master_type, master_id, diff, changed_fields
- checkdata.Message : id, user, owner_type, owner_id, checker, message
- clients.ClientContact : id, contact_person, contact_role, company, type, client, remark
- clients.ClientContactType : id, name, known_contact_type, name_fr, name_en, is_bailiff, can_refund
- coachings.Coaching : id, start_date, end_date, user, client, type, primary, ending
- coachings.CoachingEnding : id, name, seqno, type, name_fr, name_en
- coachings.CoachingType : id, name, does_integ, does_gss, eval_guestrole, name_fr, name_en
- contacts.Company : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, type, vat_id
- contacts.CompanyType : id, name, abbr, abbr_fr, abbr_en, name_fr, name_en
- contacts.Partner : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type
- contacts.Person : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, title, first_name, middle_name, last_name, gender, birth_date
- contacts.Role : id, type, person, company
- contacts.RoleType : id, name, can_sign, name_fr, name_en, use_in_contracts
- contenttypes.ContentType : id, app_label, model
- countries.Country : name, isocode, short_code, iso3, inscode, actual_country, name_fr, name_en
- countries.Place : id, name, parent, country, zip_code, type, show_type, inscode, name_fr, name_en
- cv.Duration : id, name, name_fr, name_en
- cv.EducationLevel : id, name, seqno, is_study, is_training, name_fr, name_en
- cv.Experience : id, start_date, end_date, country, city, zip_code, sector, function, person, duration_text, company, title, status, duration, regime, is_training, remarks, termination_reason
- cv.Function : id, name, remark, sector, name_fr, name_en
- cv.LanguageKnowledge : id, person, language, spoken, written, spoken_passively, written_passively, native, cef_level, has_certificate
- cv.PersonProperty : id, group, property, value, person, remark
- cv.Regime : id, name, name_fr, name_en
- cv.Sector : id, name, remark, name_fr, name_en
- cv.Status : id, name, name_fr, name_en
- cv.Study : id, start_date, end_date, country, city, zip_code, person, duration_text, language, school, state, remarks, type, education_level, content
- cv.StudyType : id, name, is_study, is_training, education_level, name_fr, name_en
- cv.Training : id, start_date, end_date, country, city, zip_code, sector, function, person, duration_text, language, school, state, remarks, type, content, certificates
- dashboard.Widget : id, seqno, user, item_name, visible
- debts.Account : id, name, seqno, ref, group, type, required_for_household, required_for_person, periods, default_amount, name_fr, name_en
- debts.Actor : id, seqno, budget, partner, header, remark
- debts.Budget : id, printed_by, user, date, partner, print_todos, print_empty_rows, include_yearly_incomes, intro, conclusion, dist_amount
- debts.Entry : id, seqno, budget, account_type, account, partner, amount, actor, circa, distribute, todo, remark, description, periods, monthly_rate, bailiff
- debts.Group : id, name, ref, account_type, entries_layout, name_fr, name_en
- dupable_clients.Word : id, word, owner
- esf.ClientSummary : id, printed_by, year, month, esf10, esf20, esf21, esf30, esf40, esf41, esf42, esf43, esf44, esf50, esf60, esf70, master, education_level, children_at_charge, certified_handicap, other_difficulty, result, remark, user_modified
- excerpts.Excerpt : id, project, build_time, build_method, contact_person, contact_role, company, user, owner_type, owner_id, excerpt_type, language
- excerpts.ExcerptType : id, name, build_method, template, attach_to_email, email_template, certifying, remark, body_template, content_type, primary, backward_compat, print_recipient, print_directly, shortcut, name_fr, name_en
- finan.BankStatement : id, user, journal, entry_date, voucher_date, fiscal_year, accounting_period, number, narration, voucher_ptr, printed_by, state, item_account, item_remark, last_item_date, balance1, balance2
- finan.BankStatementItem : id, seqno, project, match, amount, remark, account, partner, date, voucher
- finan.JournalEntry : id, user, journal, entry_date, voucher_date, fiscal_year, accounting_period, number, narration, voucher_ptr, printed_by, project, state, item_account, item_remark, last_item_date
- finan.JournalEntryItem : id, seqno, project, match, amount, remark, account, partner, date, voucher
- finan.PaymentOrder : id, user, journal, entry_date, voucher_date, fiscal_year, accounting_period, number, narration, voucher_ptr, printed_by, state, item_account, item_remark, total, execution_date
- finan.PaymentOrderItem : id, seqno, project, match, amount, remark, account, partner, bank_account, voucher
- households.Household : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, type
- households.Member : id, title, first_name, middle_name, last_name, gender, birth_date, start_date, end_date, role, person, household, dependency, primary
- households.Type : id, name, name_fr, name_en
- humanlinks.Link : id, type, parent, child
- isip.Contract : id, signer1, signer2, printed_by, user, client, language, applies_from, applies_until, date_decided, date_issued, user_asd, exam_policy, ending, date_ended, type, study_type, stages, goals, duties_asd, duties_dsbe, duties_pcsw, duties_person, user_dsbe
- isip.ContractEnding : id, name, use_in_isip, use_in_jobs, is_success, needs_date_ended
- isip.ContractPartner : id, contact_person, contact_role, reference_person, responsibilities, company, contract, duties_company
- isip.ContractType : id, name, full_name, exam_policy, overlap_group, template, ref, needs_study_type, name_fr, name_en
- isip.ExamPolicy : id, name, start_date, start_time, end_date, end_time, every_unit, every, positions, monday, tuesday, wednesday, thursday, friday, saturday, sunday, max_events, event_type, name_fr, name_en
- jobs.Candidature : id, sector, function, person, job, date_submitted, remark, state, art60, art61
- jobs.Contract : id, signer1, signer2, contact_person, contact_role, printed_by, user, client, language, applies_from, applies_until, date_decided, date_issued, user_asd, exam_policy, ending, date_ended, reference_person, responsibilities, duration, remark, company, type, job, regime, schedule, hourly_rate, refund_rate
- jobs.ContractType : id, name, ref, full_name, exam_policy, overlap_group, template, name_fr, name_en
- jobs.Job : id, sector, function, name, type, provider, contract_type, hourly_rate, capacity, remark
- jobs.JobProvider : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, type, vat_id, company_ptr, is_social
- jobs.JobType : id, seqno, name, remark, is_social
- jobs.Offer : id, sector, function, name, provider, selection_from, selection_until, start_date, remark
- jobs.Schedule : id, name, name_fr, name_en
- languages.Language : name, id, iso2, name_fr, name_en
- linod.SystemTask : id, start_date, start_time, end_date, end_time, seqno, every_unit, every, positions, monday, tuesday, wednesday, thursday, friday, saturday, sunday, max_events, log_level, disabled, last_start_time, last_end_time, requested_at, message, procedure, name
- memo.Mention : id, owner_type, owner_id, target_type, target_id
- newcomers.Broker : id, name
- newcomers.Competence : id, seqno, user, faculty, weight
- newcomers.Faculty : id, name, weight, name_fr, name_en
- notes.EventType : id, name, remark, body, body_fr, body_en, name_fr, name_en
- notes.Note : id, project, build_time, build_method, contact_person, contact_role, company, user, owner_type, owner_id, date, time, type, event_type, subject, body, language, important
- notes.NoteType : id, name, build_method, template, attach_to_email, email_template, important, remark, special_type, name_fr, name_en
- notify.Message : id, created, user, owner_type, owner_id, message_type, seen, sent, body, mail_mode, subject
- outbox.Attachment : id, owner_type, owner_id, mail
- outbox.Mail : id, project, user, owner_type, owner_id, date, subject, body, sent
- outbox.Recipient : id, mail, partner, type, address, name
- pcsw.Activity : id, name, lst104
- pcsw.AidType : id, name, name_fr, name_en
- pcsw.Client : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, title, first_name, middle_name, last_name, gender, birth_date, person_ptr, client_state, national_id, nationality, birth_country, birth_place, card_number, card_valid_from, card_valid_until, card_type, card_issuer, nationality_text, noble_condition, group, civil_state, residence_type, in_belgium_since, residence_until, unemployed_since, seeking_since, needs_residence_permit, needs_work_permit, work_permit_suspended_until, aid_type, declared_name, is_seeking, unavailable_until, unavailable_why, obstacles, skills, job_office_contact, refusal_reason, remarks2, gesdos_id, tim_id, is_cpas, is_senior, health_insurance, pharmacy, income_ag, income_wg, income_kg, income_rente, income_misc, job_agents, broker, faculty, has_esf
- pcsw.Conviction : id, client, date, prejudicial, designation
- pcsw.Dispense : id, client, reason, remarks, start_date, end_date
- pcsw.DispenseReason : id, name, seqno, name_fr, name_en
- pcsw.Exclusion : id, person, type, excluded_from, excluded_until, remark
- pcsw.ExclusionType : id, name
- pcsw.PersonGroup : id, name, ref_name, active
- periods.StoredPeriod : id, start_date, end_date, ref, state, year, remark
- periods.StoredYear : id, start_date, end_date, ref, state
- properties.PropChoice : id, type, value, text, text_fr, text_en
- properties.PropGroup : id, name, property_area, name_fr, name_en
- properties.PropType : id, name, choicelist, default_value, limit_to_choices, multiple_choices, name_fr, name_en
- properties.Property : id, name, group, type, name_fr, name_en
- sepa.Account : id, partner, iban, bic, remark, primary, account_type, managed
- sessions.Session : session_key, session_data, expire_date
- system.SiteConfig : id, default_build_method, simulate_today, site_company, signer1, signer2, signer1_function, signer2_function, default_event_type, site_calendar, max_auto_events, hide_events_before, default_color, client_calendar, client_guestrole, team_guestrole, prompt_calendar, master_budget, system_note_type, job_office, residence_permit_upload_type, work_permit_upload_type, driving_licence_upload_type, sector, cbss_org_unit, ssdn_user_id, ssdn_email, cbss_http_username, cbss_http_password
- tinymce.TextFieldTemplate : id, user, name, description, text
- uploads.Upload : id, start_date, end_date, project, file, mimetype, file_size, contact_person, contact_role, company, user, owner_type, owner_id, upload_area, type, volume, library_file, description, remark, needed
- uploads.UploadType : id, name, upload_area, max_number, wanted, shortcut, warn_expiry_unit, warn_expiry_value, name_fr, name_en
- uploads.Volume : id, ref, root_dir, description
- users.Authority : id, user, authorized
- users.User : id, start_date, end_date, email, language, modified, created, password, last_login, username, user_type, initials, first_name, last_name, remarks, partner, verification_password, verification_code, verification_code_sent_on, date_format, newcomer_consultations, newcomer_appointments, notify_myself, mail_mode, event_type, calendar, coaching_type, coaching_supervisor, newcomer_quota
- vatless.AccountInvoice : id, user, journal, entry_date, voucher_date, fiscal_year, accounting_period, number, narration, voucher_ptr, partner, project, payment_term, your_ref, due_date, match, bank_account, state, amount
- vatless.InvoiceItem : id, seqno, project, account, voucher, title, amount
- xcourses.Course : id, offer, title, start_date, remark
- xcourses.CourseContent : id, name
- xcourses.CourseOffer : id, title, guest_role, content, provider, description
- xcourses.CourseProvider : id, email, language, url, phone, gsm, fax, modified, created, country, city, zip_code, region, addr1, street_prefix, street, street_no, street_box, addr2, prefix, name, remarks, is_obsolete, activity, client_contact_type, partner_ptr, type, vat_id, company_ptr
- xcourses.CourseRequest : id, person, offer, content, date_submitted, urgent, state, course, remark, date_ended

Database structure (verbose)

  • accounting.Account (Haushaltsartikel):
    • ID (id) :

    • Bezeichnung (name) : The multilingual designation of this account, as the users see it.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Referenz (ref) : An optional unique name which can be used to reference a given account.

    • Gemeinkonto (common_account) :

    • Braucht Partner (needs_partner) : Whether bookings to this account need a partner specified.

    • Auszugleichen (clearable) :

    • Vorschlag Betrag (default_amount) : The default amount to book in bank statements or journal entries when this account has been selected manually. The default booking direction is that of the type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Verkauf (sales_allowed) : Whether this account is available for Verkauf transactions.

    • Einkauf (purchases_allowed) : Whether this account is available for Einkauf transactions.

    • Löhne und Gehälter (wages_allowed) : Whether this account is available for Löhne und Gehälter transactions.

    • Steuern (taxes_allowed) : Whether this account is available for Steuern transactions.

    • Begleichungen (clearings_allowed) : Whether this account is available for Begleichungen transactions.

    • Zahlungsaufträge (bank_po_allowed) : Whether this account is available for Zahlungsaufträge transactions.

    • Beschreibung (description) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • accounting.Journal (Journal):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Druckmethode (build_method) : A pointer to an item of BuildMethods.

    • Vorlage (template) : See PrintableType.template.

    • Handelsart (trade_type) : Pointer to TradeTypes.

    • Belegart (voucher_type) : Pointer to an item of VoucherTypes.

    • Journalgruppe (journal_group) : Pointer to an item of JournalGroups.

    • Begleichung prüfen (auto_check_clearings) : Whether to automatically check and update the ‘cleared’ status of ledger movements when (de)registering a voucher of this journal.

    • Fill suggestions (auto_fill_suggestions) : Whether to automatically fill voucher item from due payments of the partner when entering a financial voucher.

    • Chronologische Reihenfolge (force_sequence) :

    • Preliminary (preliminary) : Whether transactions in this journal are considered preliminary.

    • Make ledger movements (make_ledger_movements) : Whether vouchers in this journal generate ledger movements.

    • Haushaltsartikel (account) : The account to use for the counter-movements generated by vouchers in this journal.

    • Organisation (partner) : The partner to use as default partner for vouchers in this journal.

    • Dokumentbezeichnung Ausdruck (printed_name) :

    • Primäre Buchungsrichtung (dc) : The primary booking direction. Voucher items in this direction increase the total amount of the voucher.

    • Yearly numbering (yearly_numbering) : Whether the number of vouchers should restart at 1 every year.

    • Dateibibliothek (uploads_volume) :

    • Dokumentbezeichnung Ausdruck (fr) (printed_name_fr) :

    • Dokumentbezeichnung Ausdruck (en) (printed_name_en) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Bankkonto (sepa_account) : Your bank account to specify in payment order.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • accounting.LedgerInfo (ledger info):
    • Benutzer (user) : OneToOneField pointing to the user.

    • Letztes Erfassungsdatum (entry_date) : The last value this user typed as entry_date of a voucher. It is the default value for every new voucher.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • accounting.MatchRule (Begleichungsregel):
    • ID (id) :

    • Haushaltsartikel (account) :

    • Journal (journal) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • accounting.Movement (Bewegung):
    • ID (id) :

    • Klient (project) : Pointer to the “project”. This field exists only if the project_model setting is nonempty.

    • Beleg (voucher) : Pointer to the numbered voucher that caused this movement.

    • Seq.-Nr. (seqno) : Sequential number within a voucher.

    • Zahlungsempfänger (partner) : Pointer to the partner involved in this movement.

    • Valuta (value_date) : The date at which this movement is to be entered into the accounting. This is usually the voucher’s entry_date, except e.g. for bank statements where each item can have its own value date.

    • Match (match) : An unique name used to group a set of movements that are to be cleared.

    • Beglichen (cleared) : Whether this movement “is satisfied” or “has been paid”.

    • Haushaltsartikel (account) : Pointer to the Account that is being moved by this movement.

    • amount (amount) :

    • Debit (debit) : Virtual field showing amount if dc is DEBIT.

    • Kredit (credit) : Virtual field showing amount if dc is CREDIT.

    • Match (match_link) : A virtual field which shows a clickable variant of the match string. Clicking it will open a table with all movements having that match.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Beleg (voucher_link) : A virtual field which shows a link to the voucher.

    • Partner (voucher_partner) : A virtual field which returns the partner of the voucher. For incoming invoices this is the supplier, for outgoing invoices this is the customer, for financial vouchers this is empty.

  • accounting.PaymentTerm (Zahlungsbedingungen):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Tage (days) : Number of days to add to voucher_date.

    • Monate (months) : Number of months to add to voucher_date.

    • Monatsende (end_of_month) : Whether to move voucher_date to the end of month.

    • Printed text (printed_text) : Used in trading/VatProductInvoice/trailer.html as follows:

    • Informal (informal) : Whether to suppress the detail ledger movements.

    • Printed text (fr) (printed_text_fr) :

    • Printed text (en) (printed_text_en) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • accounting.Voucher (Beleg):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Journal (journal) : The journal into which this voucher has been booked.

    • Buchungsdatum (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

    • Belegdatum (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

    • Geschäftsjahr (fiscal_year) :

    • Buchungsperiode (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

    • Nr. (number) : The sequence number of this voucher within its journal.

    • Interne Referenz (narration) : A short explanation to explain the subject matter of this journal entry.

    • Nr. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

    • Eingangsdokument (source_document) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • XML file (xml_file) : None

  • addresses.Address (Adresse):
    • ID (id) :

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Datenquelle (data_source) : Pointer to DataSources.

    • Adressenart (address_type) : The type of this address record.

    • Partner (partner) : The owner of this address record. This is business partner to whom this address applies.

    • Bemerkung (remark) :

    • Primär (primary) : Whether this address is the primary address of its owner. Setting this field will automatically uncheck any previousl primary addresses and update the owner’s address fields.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • aids.AidType (Hilfeart):
    • ID (id) :

    • Bezeichnung (name) : The designation of this aid type as seen by the user e.g. when selecting an aid type.

    • Represented by (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Organisation (company) : Pointer to Company.

    • Excerpt title (excerpt_title) : The text to print as title in confirmations. See also lino_xl.lib.excerpts.mixins.ExcerptTitle.excerpt_title.

    • Hilferegime (aid_regime) :

    • Hilfebescheinigungsart (confirmation_type) : The database model to use for issuing an aid confirmation of this type. This is a mandatory pointer to ConfirmationTypes.

    • short name (short_name) : The short name for internal use, e.g. when a user must select an aid type from a combobox.

    • Gremium (board) : Pointer to the default lino_xl.lib.boards.models.Board for aid projects of this type.

    • Direkt drucken (print_directly) :

    • Verpflichtung DSBE (is_integ_duty) : Whether aid grantings of this type are considered as duty for integration contract.

    • Dringend (is_urgent) : Whether aid grantings of this type are considered as urgent. This is used by Confirmation.get_urgent_granting()

    • Primärbegleiter bestätigt (confirmed_by_primary_coach) : Whether grantings for this aid type are to be signed by the client’s primary coach (see Client.get_primary_coach).

    • Klientenkontaktart (pharmacy_type) : A pointer to the ClientContactType to be used when selecting the pharmacy of a refund confirmation (RefundConfirmation.pharmacy).

    • Adressenart (address_type) : Which client address to print on confirmations. If this is empty, Lino will use the primary address.

    • Textkörper-Vorlage (body_template) : The body template to use when printing a confirmation of this type. If this field is empty, Lino uses the excerpt type’s body_template. See also lino.admin.printing.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Excerpt title (fr) (excerpt_title_fr) :

    • Excerpt title (en) (excerpt_title_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • aids.Category (Kategorie):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • aids.Granting (Hilfebeschluss):
    • ID (id) :

    • Laufzeit von (start_date) :

    • bis (end_date) :

    • Autor (user) : The author of this database object.

    • Beschlossen (decision_date) :

    • Gremium (board) : Pointer to the Board which decided to allocate this aid project.

    • Bestätiger (signer) : Pointer to the user who is expected to “sign” this granting (i.e. to confirm that it is real).

    • Zustand (state) : The confirmation state of this object. Pointer to ConfirmationStates.

    • Klient (client) : Pointer to the lino_welfare.modlib.pcsw.models.Client.

    • Hilfeart (aid_type) : The type of aid being granted. Mandatory. Pointer to the AidType.

    • Kategorie (category) : Currently only used for printing an isip.Contract.

    • Datum der Anfrage (request_date) :

    • Aktionen (custom_actions) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • aids.IncomeConfirmation (Einkommensbescheinigung):
    • ID (id) :

    • Periode vom (start_date) :

    • bis (end_date) :

    • Erstellt (created) : The time when this database row was created.

    • Empfänger (Person) (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Empfänger (Organisation) (company) : Pointer to Company.

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Bestätiger (signer) :

    • Zustand (state) : The confirmation state of this object. Pointer to ConfirmationStates.

    • Klient (client) :

    • Hilfebeschluss (granting) :

    • Bemerkung (remark) :

    • Sprache (language) :

    • Kategorie (category) :

    • Betrag (amount) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • aids.RefundConfirmation (Kostenübernahmeschein):
    • ID (id) :

    • Periode vom (start_date) :

    • bis (end_date) :

    • Erstellt (created) : The time when this database row was created.

    • Empfänger (Person) (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Empfänger (Organisation) (company) : Pointer to Company.

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Bestätiger (signer) :

    • Zustand (state) : The confirmation state of this object. Pointer to ConfirmationStates.

    • Klient (client) :

    • Hilfebeschluss (granting) :

    • Bemerkung (remark) :

    • Sprache (language) :

    • Art des Arztes (doctor_type) :

    • Arzt (doctor) :

    • Apotheke (pharmacy) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • aids.SimpleConfirmation (Einfache Bescheinigung):
    • ID (id) :

    • Periode vom (start_date) :

    • bis (end_date) :

    • Erstellt (created) : The time when this database row was created.

    • Empfänger (Person) (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Empfänger (Organisation) (company) : Pointer to Company.

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Bestätiger (signer) :

    • Zustand (state) : The confirmation state of this object. Pointer to ConfirmationStates.

    • Klient (client) :

    • Hilfebeschluss (granting) :

    • Bemerkung (remark) :

    • Sprache (language) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • art61.Activation (Activation):
    • ID (id) :

    • Beginnt am (start_date) :

    • Enddatum (end_date) :

    • Represented by (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Employer or job provider (company) : The employer or job provider.

    • Autor (user) : The author of this database object.

    • Klient (client) :

    • Amount to pay (amount) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • art61.Contract (Art.61-Konvention):
    • ID (id) :

    • Sekretär (signer1) :

    • Präsident (signer2) :

    • Represented by (contact_person) :

    • Represented as (contact_role) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Verantwortlicher (DSBE) (user) : Die Person, die diesen Vertrag erstellt hat.

    • Klient (client) : The client for whom this contract is done.

    • Sprache (language) : The language of this contract. Default value is the client’s language.

    • Laufzeit von (applies_from) : The start date of the contract.

    • Laufzeit bis (applies_until) : The planned end date of this contract.

    • Beschlossen am (date_decided) : When the contract was ratified by the responsible board.

    • Ausgestellt am (date_issued) : When the contract was issued to the client and signed by them.

    • Verantwortlicher (ASD) (user_asd) : Die verantwortliche Person im allgemeinen Sozialdienst.

    • Auswertungsstrategie (exam_policy) :

    • Beendigungsgrund (ending) : The reason of prematured ending. Pointer to ContractEnding

    • Enddatum (date_ended) : The date when this contract was effectively ended. This field is set to the same value as applies_until.

    • Referenzperson (reference_person) :

    • Aufgabenbereich (responsibilities) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Dauer (Arbeitstage) (duration) : The duration of this job supplyment (number of working days).

    • Bemerkung (remark) :

    • Stellenanbieter (company) :

    • Art (type) : The type of this contract. Pointer to a subclass of ContractTypeBase.

    • Berufsbezeichnung (job_title) :

    • Status (status) :

    • Vertragsdauer (cv_duration) :

    • Arbeitsregime (regime) :

    • Hiring assistance (sub_10_amount) :

    • From (sub_10_start) :

    • Until (sub_10_end) :

    • Tutorate (sub_20_amount) :

    • From (sub_20_start) :

    • Until (sub_20_end) :

    • Walloon Region (sub_30_amount) :

    • From (sub_30_start) :

    • Until (sub_30_end) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • art61.ContractType (Art.61-Konventionsart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Voller Name (full_name) : The full description of this contract type as used in printed documents.

    • Auswertungsstrategie (exam_policy) : The default examination policy to be used for contracts of this type.

    • Überlappungsgruppe (overlap_group) : The overlap group to use when checking whether two contracts are overlapping or not. If this field is empty, Lino does not check at all for overlapping contracts.

    • Vorlage (template) : The main template to use instead of the default template defined on the excerpt type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • b2c.Account (Importiertes Bankkonto):
    • ID (id) :

    • IBAN (iban) :

    • BIC (bic) :

    • Kontobezeichnung (account_name) :

    • Name Inhaber (owner_name) :

    • Letzte Transaktion (last_transaction) :

    • Partner (partners) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • b2c.Statement (Statement):
    • ID (id) :

    • Importiertes Bankkonto (account) :

    • Auszugsnummer (statement_number) : Combination of the year and the legal sequential number of the paper statement.

    • Beginnt am (start_date) :

    • Enddatum (end_date) :

    • Alter Saldo (balance_start) :

    • Neuer Saldo (balance_end) :

    • Währung (local_currency) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • b2c.Transaction (Transaction):
    • ID (id) :

    • Statement (statement) :

    • Nr. (seqno) : The sequence number of this transaction in the statement.

    • Betrag (amount) :

    • IBAN (remote_account) :

    • BIC (remote_bic) :

    • Meldung (message) :

    • End to end reference (eref) :

    • Remote owner (remote_owner) :

    • Remote owner adress (remote_owner_address) :

    • Remote owner city (remote_owner_city) :

    • Remote owner postal code (remote_owner_postalcode) :

    • Remote owner country code (remote_owner_country_code) :

    • Transfer type (txcd) :

    • TxCd issuer (txcd_issuer) :

    • Ausführungsdatum (booking_date) :

    • Valuta (value_date) :

    • Gegenpartei (remote_html) : None

    • Meldung (message_html) : None

    • BkTxCd (txcd_text) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • boards.Board (Gremium):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Arbeitet seit (start_date) :

    • Hat gearbeitet bis (end_date) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • boards.Member (Gremienmitglied):
    • ID (id) :

    • Gremium (board) :

    • Person (person) :

    • Funktion (role) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.Calendar (Kalender):
    • ID (id) :

    • Bezeichnung (name) : A babel field containing the designation of the calendar.

    • Beschreibung (description) : A multi-line description of the calendar.

    • Farbe (color) : The color to use for entries of this calendar (in lino_xl.lib.extensible).

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.EntryRepeater (Calendar entry repeater):
    • ID (id) :

    • Beginnt am (start_date) : The start date of the first meeting to be generated.

    • Beginnt um (start_time) :

    • Enddatum (end_date) : The end date of the first meeting to be generated. Leave this field empty if the meetings last less than one day.

    • Endet um (end_time) :

    • Wiederholung (every_unit) : The interval between each periodic iteration.

    • … alle (every) : The frequency of periodic iteration: daily, weekly, monthly or yearly.

    • Positionen (positions) : Space-separated list of one or several positions within the recurrency cycle.

    • Montag (monday) :

    • Dienstag (tuesday) :

    • Mittwoch (wednesday) :

    • Donnerstag (thursday) :

    • Freitag (friday) :

    • Samstag (saturday) :

    • Sonntag (sunday) :

    • Anzahl Termine (max_events) : Maximum number of calendar entries to generate.

    • Kalendereintrag (cal_entry) :

    • Beschreibung (what_text) : None

    • Male (times_text) : None

    • Wann (weekdays_text) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Dauer (duration) : None

  • cal.Event (Kalendereintrag):
    • ID (id) :

    • Beginnt am (start_date) : The starting date of this calendar entry. May not be empty.

    • Beginnt um (start_time) : The starting time. If this is empty, the entry is considered an all-day entry.

    • Enddatum (end_date) : The ending date of this calendar entry. Leave empty for same-day entries.

    • Endet um (end_time) : The ending time. If this is before the starting time, and no ending date is given, Lino considers the entry to end the day after.

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Klient (project) : Pointer to the project to which this object is related.

    • Druckdatum (build_time) : Timestamp of the built target file. Contains None if no build hasn’t been called yet.

    • Druckmethode (build_method) :

    • Verwaltet durch (user) : Der verantwortliche Benutzer.

    • Zugewiesen zu (assigned_to) : Another user who is expected to take responsibility for this entry.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Kurzbeschreibung (summary) : A one-line descriptive text.

    • Beschreibung (description) : A longer descriptive text.

    • Nr. (auto_type) : Contains the sequence number if this is an automatically generated component. Otherwise this field is empty.

    • Priorität (priority) :

    • Kalendereintragsart (event_type) : The type of this calendar entry.

    • nicht blockierend (transparent) : Whether this entry should allow other entries at the same time.

    • guests edited (guests_edited) : Whether the guests list of this event has been modified by an end user.

    • Raum (room) :

    • Zustand (state) : The state of this entry. The state can change according to rules defined by the workflow.

    • Notify before (notify_before) : The multiples of a time unit (notify_unit) before which to send a notification to the corresponding user.

    • Unit (notify_unit) : The unit of time to compute before sending a notification. Example values are: minute, hour, day, week et cetera.

    • notified (notified) : Stores a boolean value as an indication of whether the user has been notified or NOT.

    • Wann (when_text) : Shows the start date and time of the calendar entry.

    • ganztags (all_day) : None

    • Wann (when_html) : Shows the date and time of the calendar entry with a link that opens all entries on that day.

    • Link URL (url) : None

    • Erinnerung (reminder) : None

    • Kalender (calendar) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

    • Dauer (duration) : None

    • None (full_page) : None

  • cal.EventPolicy (Wiederholungsregel):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Beginnt am (start_date) : The start date of the first meeting to be generated.

    • Beginnt um (start_time) :

    • Enddatum (end_date) : The end date of the first meeting to be generated. Leave this field empty if the meetings last less than one day.

    • Endet um (end_time) :

    • Wiederholung (every_unit) : The interval between each periodic iteration.

    • … alle (every) : The frequency of periodic iteration: daily, weekly, monthly or yearly.

    • Positionen (positions) : Space-separated list of one or several positions within the recurrency cycle.

    • Montag (monday) :

    • Dienstag (tuesday) :

    • Mittwoch (wednesday) :

    • Donnerstag (thursday) :

    • Freitag (friday) :

    • Samstag (saturday) :

    • Sonntag (sunday) :

    • Anzahl Termine (max_events) : Maximum number of calendar entries to generate.

    • Kalendereintragsart (event_type) : Generated calendar entries will have this type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Beschreibung (what_text) : None

    • Male (times_text) : None

    • Wann (weekdays_text) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.

    • Dauer (duration) : None

  • cal.EventType (Kalendereintragsart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • als Anhang per E-Mail (attach_to_email) : Whether the printable file should be attached to the email when creating an email from a mailable of this type.

    • E-Mail-Vorlage (email_template) : The name of the file to be used as template when creating an email from a mailable of this type.

    • Beschreibung (description) :

    • Termin (is_appointment) : Whether entries of this type are considered “appointments” (i.e. whose time and place have been agreed upon with other users or external parties).

    • Öffentlich (is_public) :

    • Blockiert alle Räume (all_rooms) :

    • Blockiert den Autor (locks_user) : Whether calendar entries of this type make the user unavailable for other locking events at the same time.

    • Anwesenheiten automatisch (force_guest_states) : Whether presence states should be forced to those defined by the entry state.

    • Gäste ausfüllen (fill_presences) : Whether guests should be automatically filled for calendar entries of this type.

    • Beginnt am (start_date) :

    • Bezeichnung Termin (event_label) : Default text for summary of new entries.

    • Gleichzeitige Termine (max_conflicting) : How many conflicting events should be tolerated.

    • Tage maximal (max_days) : The maximal number of days allowed as duration. 0 means no limit.

    • nicht blockierend (transparent) : Allow entries of this type to conflict with other events.

    • Tagesplanerkolonne (planner_column) :

    • Vorschlag Dauer (default_duration) : An optional default duration for calendar entries of this type.

    • Klient einladen (invite_client) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Bezeichnung Termin (fr) (event_label_fr) :

    • Bezeichnung Termin (en) (event_label_en) :

    • ESF field (esf_field) : How to summarize entries of this type in the ESF summary.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • cal.Guest (Anwesenheit):
    • ID (id) :

    • Kalendereintrag (event) : The calendar event to which this presence applies.

    • Partner (partner) : The partner to which this presence applies.

    • Rolle (role) : The role of this partner in this presence.

    • Zustand (state) : The state of this presence. See GuestStates.

    • Bemerkung (remark) :

    • Wartet seit (waiting_since) : Time when the visitor arrived (checked in).

    • Hat gewartet bis (busy_since) : Time when the visitor was received by agent.

    • Anwesend bis (gone_since) : Time when the visitor left (checked out).

    • Wartenummer (waiting_number) :

    • Klient (client) : Virtual field which returns the partner if it is a client.

    • Kalendereintrag (event_summary) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.GuestRole (Gastrolle):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.RecurrentEvent (Regelmäßiges Ereignis):
    • ID (id) :

    • Bezeichnung (name) : See lino.utils.mldbc.mixins.BabelNamed.name.

    • Beginnt am (start_date) : The start date of the first meeting to be generated.

    • Beginnt um (start_time) :

    • Enddatum (end_date) : The end date of the first meeting to be generated. Leave this field empty if the meetings last less than one day.

    • Endet um (end_time) :

    • Wiederholung (every_unit) : Inherited from RecurrenceSet.every_unit.

    • … alle (every) : The frequency of periodic iteration: daily, weekly, monthly or yearly.

    • Positionen (positions) : Space-separated list of one or several positions within the recurrency cycle.

    • Montag (monday) :

    • Dienstag (tuesday) :

    • Mittwoch (wednesday) :

    • Donnerstag (thursday) :

    • Freitag (friday) :

    • Samstag (saturday) :

    • Sonntag (sunday) :

    • Anzahl Termine (max_events) : Maximum number of calendar entries to generate.

    • Autor (user) : The author of this database object.

    • Kalendereintragsart (event_type) :

    • Beschreibung (description) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Beschreibung (what_text) : None

    • Male (times_text) : None

    • Wann (weekdays_text) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.

    • Dauer (duration) : None

  • cal.RemoteCalendar (Externer Kalender):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Art (type) :

    • URL-Vorlage (url_template) :

    • Benutzername (username) :

    • Passwort (password) :

    • schreibgeschützt (readonly) :

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.Room (Raum):
    • ID (id) :

    • Bezeichnung (name) : The designation of the room. This is not required to be unique.

    • Kontaktperson (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Verantwortlicher (company) : Pointer to Company.

    • Color (display_color) : The color to use when displaying entries in this room in the calendar view.

    • Beschreibung (description) :

    • Kalender (calendar) : Calendar where events in this room are published.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.Subscription (Abonnement):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Kalender (calendar) : The calendar you want to subscribe to.

    • versteckt (is_hidden) : Whether this subscription should “ “initially be displayed as a hidden calendar.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cal.Task (Task):
    • ID (id) :

    • Beginnt am (start_date) :

    • Beginnt um (start_time) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Klient (project) : Pointer to the project to which this object is related.

    • Autor (user) : The author of this database object.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Kurzbeschreibung (summary) :

    • Beschreibung (description) :

    • Nr. (auto_type) : Contains the sequence number if this is an automatically generated component. Otherwise this field is empty.

    • Priorität (priority) : How urgent this task is.

    • Zahlungsziel (due_date) :

    • Fällig um (due_time) :

    • Dauer (Anzahl) (percent) :

    • Zustand (state) : The state of this Task. one of TaskStates.

    • Delegated to client (delegated) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

  • cbss.IdentifyPersonRequest (IdentifyPerson-Anfrage):
    • ID (id) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Klient (person) :

    • Versendet (sent) : The date and time when this request has been executed. This is empty for requests than haven’t been sent. Read-only.

    • Zustand (status) :

    • T/A/B (environment) :

    • Ticket (ticket) :

    • Abfrage (request_xml) : The raw XML string that has (or would have) been sent.

    • Befragung (response_xml) : The raw XML response received.

    • Debug-Meldungen (debug_messages) :

    • Info-Meldungen (info_messages) :

    • NR-Nummer (national_id) :

    • Geburtsdatum (birth_date) : Uncomplete dates are allowed, e.g. “00.00.1980” means “some day in 1980”, “00.07.1980” means “in July 1980” or “23.07.0000” means “on a 23th of July”.

    • SIS-Karten-Nr (sis_card_no) : The number of the SIS card used to authenticate the person.

    • ID-Karten-Nr (id_card_no) : The number of the ID card used to authenticate the person.

    • Vorname (first_name) : Space-separated list of all first names.

    • Familienname (last_name) : Last name (family name).

    • Zwischenname (middle_name) : Whatever this means…

    • Geschlecht (gender) :

    • Toleranz (tolerance) : Falls Monat oder Tag des Geburtsdatums unbekannt sind, um wieviel Monate bzw. Tage die Suche nach unten/oben ausgeweitet wird. Gültige Werte: 0 bis 10.

    • Resultat (result) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • cbss.ManageAccessRequest (ManageAccess-Anfrage):
    • ID (id) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Klient (person) :

    • Versendet (sent) : The date and time when this request has been executed. This is empty for requests than haven’t been sent. Read-only.

    • Zustand (status) :

    • T/A/B (environment) :

    • Ticket (ticket) :

    • Abfrage (request_xml) : The raw XML string that has (or would have) been sent.

    • Befragung (response_xml) : The raw XML response received.

    • Debug-Meldungen (debug_messages) :

    • Info-Meldungen (info_messages) :

    • NR-Nummer (national_id) : The SSIN of the person to register/unregister/list.

    • Geburtsdatum (birth_date) : Uncomplete dates are allowed, e.g. “00.00.1980” means “some day in 1980”, “00.07.1980” means “in July 1980” or “23.07.0000” means “on a 23th of July”.

    • SIS-Karten-Nr (sis_card_no) : The number of the SIS card used to authenticate the person.

    • ID-Karten-Nr (id_card_no) : The number of the ID card used to authenticate the person.

    • Vorname (first_name) : Space-separated list of all first names.

    • Familienname (last_name) : Last name (family name).

    • Sektor (sector) : Pointer to Sector.

    • Eigenschafts-Code (purpose) : Pointer to Purpose.

    • Periode vom (start_date) :

    • Periode bis (end_date) :

    • Aktion (action) : The action to perform. This must be one of the values in lino_welfare.modlib.cbss.choicelists.ManageActions

    • Abfrageregister (query_register) : The register to be query. This must be one of the values in lino_welfare.modlib.cbss.choicelists.QueryRegisters

    • Resultat (result) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • cbss.Purpose (Eigenschafts-Code):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Sektor (sector_code) :

    • Code (code) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cbss.RetrieveTIGroupsRequest (Tx25-Anfrage):
    • ID (id) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Klient (person) :

    • Versendet (sent) : The date and time when this request has been executed. This is empty for requests than haven’t been sent. Read-only.

    • Zustand (status) :

    • T/A/B (environment) :

    • Ticket (ticket) :

    • Abfrage (request_xml) : The raw XML string that has (or would have) been sent.

    • Befragung (response_xml) : The raw XML response received.

    • Debug-Meldungen (debug_messages) :

    • Info-Meldungen (info_messages) :

    • NR-Nummer (national_id) :

    • Sprache (language) :

    • Historie (history) : Whatever this means.

    • Resultat (result) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • cbss.Sector (Sektor):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Code (code) :

    • Unter-Code (subcode) :

    • Abkürzung (abbr) :

    • Abkürzung (fr) (abbr_fr) :

    • Abkürzung (en) (abbr_en) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • changes.Change (Änderung):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • time (time) :

    • Änderungsart (type) :

    • Object type (object_type) :

    • object id (object_id) :

    • Master type (master_type) :

    • master id (master_id) :

    • Änderungen (diff) :

    • Felder (changed_fields) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • checkdata.Message (Datenproblemmeldung):
    • ID (id) :

    • Verantwortlicher (user) : The author of this database object.

    • Datenobjekt (Modell) (owner_type) :

    • Datenobjekt (Objekt) (owner_id) :

    • Checker (checker) :

    • Meldungstext (message) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • clients.ClientContact (Kontakt):
    • ID (id) :

    • Kontaktperson (contact_person) : The contact person in the organization.

    • Represented as (contact_role) : The role of the contact person in the organization.

    • Organisation (company) : The organization.

    • Klientenkontaktart (type) : The type of contact. Pointer to ClientContactType.

    • Klient (client) : The Client.

    • Bemerkungen (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • clients.ClientContactType (Klientenkontaktart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Standard-Klientenkontaktart (known_contact_type) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Schuldeneintreiber (is_bailiff) :

    • Kostenrückerstattung (can_refund) : Whether persons of this type can be used as doctor of a refund confirmation.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • coachings.Coaching (Begleitung):
    • ID (id) :

    • Begleitet seit (start_date) :

    • bis (end_date) :

    • Begleiter (user) : The author of this database object.

    • Klient (client) :

    • Dienst (type) :

    • Primär (primary) : Whether this coaching is primary. Enabling this field will automatically make the other coachings non-primary.

    • Beendigungsgrund (ending) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • coachings.CoachingEnding (Beendigungsgrund):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Dienst (type) : If not empty, allow this ending only on coachings of specified type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • coachings.CoachingType (Dienst):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • DSBE (does_integ) : Whether coachings of this type are to be considered as integration work.

    • ASD (does_gss) : Whether this coaching type does general social work.

    • Role in evaluations (eval_guestrole) : Role when participating in evaluation meetings.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • contacts.Company (Organisation):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Rechtsform (type) : Pointer to the CompanyType.

    • MwSt.-Nr. (vat_id) : The national VAT identification number of this partner.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

  • contacts.CompanyType (Rechtsform):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Abkürzung (abbr) :

    • Abkürzung (fr) (abbr_fr) :

    • Abkürzung (en) (abbr_en) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • contacts.Partner (Partner):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

    • None (overview) : A multi-paragraph representation of this database row.

  • contacts.Person (Person):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Titel (title) : Used to specify a professional position or academic qualification like “Dr.” or “PhD”.

    • Vorname (first_name) : The first name, also known as given name.

    • Zwischenname (middle_name) : A space-separated list of all middle names.

    • Familienname (last_name) : The last name, also known as family name.

    • Geschlecht (gender) : The sex of this person (male or female).

    • Geburtsdatum (birth_date) : Uncomplete dates are allowed, e.g. “00.00.1980” means “some day in 1980”, “00.07.1980” means “in July 1980” or “23.07.0000” means “on a 23th of July”.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

    • Alter (age) : Virtual field displaying the age in years.

  • contacts.Role (Kontaktperson):
    • ID (id) :

    • Funktion (type) : The function of this person in this organization.

    • Person (person) : The person having this role in this organization.

    • Organisation (company) : The organization where this person has this role.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • contacts.RoleType (Funktion):
    • ID (id) :

    • Bezeichnung (name) : A translatable designation. Used e.g. in document templates for contracts.

    • Unterschriftsberechtigt (can_sign) : Whether this is a signer function.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • erlaubt in Verträgen (use_in_contracts) : Whether Links of this type can be used as contact person of a job contract.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • contenttypes.ContentType (Datenbankmodell):
    • ID (id) :

    • app label (app_label) :

    • Python Modell-Klassenname (model) :

    • Workflow (workflow_buttons) : None

  • countries.Country (Land):
    • Bezeichnung (name) : The designation of this country.

    • ISO-Code (isocode) : The two-letter code for this country as defined by ISO 3166-1. For countries that no longer exist it may be a 4-letter code.

    • Short code (short_code) : A short abbreviation for regional usage. Obsolete.

    • ISO3-Code (iso3) : The three-letter code for this country as defined by ISO 3166-1.

    • INS code (inscode) : The official code for this country used by statbel.fgov.be

    • Actual country (actual_country) : Select the actual country if this row represents a refugee status or a former country.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • countries.Place (Ort):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Teil von (parent) : The superordinate geographic place of which this place is a part.

    • Land (country) : The country this place is in.

    • zip code (zip_code) :

    • Ortsart (type) : The type of this place (whether it’s a city. a village, a province…)

    • Show type (show_type) :

    • INS code (inscode) : The official code for this place used by statbel.fgov.be

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Kinder (children_summary) : A comma-separated list of the children.

    • None (treeview_panel) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Duration (Vertragsdauer):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.EducationLevel (Akademischer Grad):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Studium (is_study) : Whether education entries are considered a study entry.

    • Ausbildung (is_training) : Whether education entries are considered a training entry.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • cv.Experience (Berufserfahrung):
    • ID (id) :

    • Beginnt am (start_date) : When this entry started.

    • Enddatum (end_date) : When this entry ended.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Klient (person) : The person to whom this entry applies. Pointer to Plugin.person_model.

    • Dauer (duration_text) : Free-text description of the duration of this entry.

    • Organisation (company) :

    • Berufsbezeichnung (title) :

    • Status (status) :

    • Vertragsdauer (duration) :

    • Arbeitsregime (regime) :

    • Ausbildung (is_training) :

    • Bemerkungen (remarks) :

    • Beendigungsgrund (termination_reason) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

  • cv.Function (Berufsbezeichnung):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bemerkung (remark) :

    • Sektor (sector) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.LanguageKnowledge (Sprachkenntnis):
    • ID (id) :

    • Klient (person) : The person to which this entry applies.

    • Sprache (language) : The language to which this entry applies.

    • Wort (spoken) :

    • Schrift (written) :

    • Wort (passiv) (spoken_passively) :

    • Schrift (passiv) (written_passively) :

    • Muttersprache (native) :

    • CEF-Kategorie (cef_level) : The CEF level. A pointer to a choice of CefLevels

    • Zertifikat (has_certificate) : Whether this entry is confirmed by a certificate.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.PersonProperty (Eigenschaft):
    • ID (id) :

    • Eigenschaftsgruppe (group) :

    • Eigenschaft (property) :

    • Wert (value) :

    • Klient (person) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Regime (Arbeitsregime):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Sector (Sektor):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bemerkung (remark) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Status (Status):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Study (Studium):
    • ID (id) :

    • Beginnt am (start_date) : When this entry started.

    • Enddatum (end_date) : When this entry ended.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Klient (person) : The person to whom this entry applies. Pointer to Plugin.person_model.

    • Dauer (duration_text) : Free-text description of the duration of this entry.

    • Sprache (language) : Foreign key to lino.modlib.languages.Language.

    • Einrichtung (school) : The establishment where the education happened.

    • Zustand (state) :

    • Bemerkungen (remarks) : Remarks about this entry.

    • Bildungsart (type) : Pointer to StudyType.

    • Akademischer Grad (education_level) : Pointer to EducationLevel.

    • Ausbildungsinhalt (content) : Free-text description of the content.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

  • cv.StudyType (Bildungsart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Studium (is_study) : Whether education entries are considered a study entry.

    • Ausbildung (is_training) : Whether education entries are considered a training entry.

    • Akademischer Grad (education_level) : Pointer to EducationLevel.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • cv.Training (Ausbildung):
    • ID (id) :

    • Beginnt am (start_date) : When this entry started.

    • Enddatum (end_date) : When this entry ended.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Klient (person) : The person to whom this entry applies. Pointer to Plugin.person_model.

    • Dauer (duration_text) : Free-text description of the duration of this entry.

    • Sprache (language) : Foreign key to lino.modlib.languages.Language.

    • Einrichtung (school) : The establishment where the education happened.

    • Zustand (state) :

    • Bemerkungen (remarks) : Remarks about this entry.

    • Bildungsart (type) : Pointer to StudyType.

    • Ausbildungsinhalt (content) : Describes the content of this training. A free one-line text field.

    • Diplome (certificates) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

  • dashboard.Widget (Widget):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Benutzer (user) : The author of this database object.

    • Resource (item_name) :

    • Sichtbar (visible) :

    • Label (title) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • debts.Account (Konto):
    • ID (id) :

    • Bezeichnung (name) : The multilingual designation of this account, as the users see it.

    • Nr. (seqno) : The sequence number of this account within its group.

    • Referenz (ref) : An optional unique name which can be used to reference a given account.

    • Kontengruppe (group) : The account group to which this account belongs. This must point to an instance of Group.

    • Kontoart (type) : The account type of this account. This must point to an item of lino_welfare.modlib.debts.AccountTypes.

    • Verpflichtend für Haushalte (required_for_household) :

    • Verpflichtend für Personen (required_for_person) :

    • Perioden (periods) : For how many months the entered amount counts. For example 1 means a monthly amount, 12 a yearly amount.

    • Vorschlag Betrag (default_amount) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • debts.Actor (Budget-Akteur):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Budget (budget) :

    • Partner (partner) :

    • Kolonnenüberschrift (header) :

    • Bemerkung (remark) :

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • debts.Budget (Budget):
    • ID (id) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Autor (user) : The author of this database object.

    • Datum (date) :

    • Partner (partner) :

    • To-do-Liste drucken (print_todos) : Einträge im Feld “To-do” werden nur ausgedruckt, wenn die Option “To-dos drucken” des Budgets angekreuzt ist. Diese Option wird aber momentan noch ignoriert (d.h. To-do-Liste wird gar nicht ausgedruckt), weil wir noch überlegen müssen, wie sie ausgedruckt werden sollen. Vielleicht mit Fußnoten?

    • Auch leere Einträge drucken (print_empty_rows) : Whether to print empty rows.

    • Jährliche Einkommen berücksichtigen (include_yearly_incomes) : Check this to include yearly incomes in the Debts Overview table of this Budget.

    • Einleitung (intro) :

    • Schlussfolgerung (conclusion) :

    • Verteilbarer Betrag (dist_amount) : Der monatlich verfügbare Gesamtbetrag für Tabelle Schuldenverteilung.

    • Gesamtschuld (total_debt) : None

    • Erfasste Daten (data_box) : None

    • Zusammenfassung (summary_box) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • debts.Entry (Eintrag):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Budget (budget) :

    • Kontoart (account_type) :

    • Konto (account) : The related Account.

    • Partner (partner) :

    • Betrag (amount) : The amount of money. An empty amount is different from a zero amount in that the latter will be printed while the former not.

    • Budget-Akteur (actor) : Hier optional den Akteur angeben, der diesen Eintrag beiträgt. Leer lassen, wenn der Eintrag sich auf den Gesamthaushalt bezieht.

    • ca. (circa) :

    • Verteilen (distribute) : Ob diese Schuld in die Schuldenverteilung aufgenommen wird oder nicht.

    • to do (todo) :

    • Bemerkung (remark) : Bemerkungen sind intern und werden nie ausgedruckt.

    • Beschreibung (description) : Beschreibung wird automatisch mit der Kontobezeichung ausgefüllt. Kann man aber manuell ändern. Wenn man das Konto ändert, gehen manuelle Änderungen in diesem Feld verloren. Beim Ausdruck steht in Kolonne “Beschreibung” lediglich der Inhalt dieses Feldes, der eventuellen Bemerkung sowie (falls angegeben bei Schulden) der Partner.

    • Perioden (periods) : Gibt an, für wieviele Monate dieser Betrag sich versteht. Also bei monatlichen Ausgaben steht hier 1, bei jährlichen Ausgaben 12.

    • Monatsrate (monthly_rate) : Eventueller Betrag monatlicher Rückzahlungen, über deren Zahlung nicht verhandelt wird. Wenn hier ein Betrag steht, darf “Verteilen” nicht angekreuzt sein.

    • Schuldeneintreiber (bailiff) : Leave empty for simple debts, otherwise select here the responsible bailiff or collection agency

    • Beschreibung (summary_description) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • debts.Group (Kontengruppe):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • ref (ref) :

    • Kontoart (account_type) :

    • Budget entries layout (entries_layout) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • dupable_clients.Word (Phonetisches Wort):
    • ID (id) :

    • word (word) :

    • Klient (owner) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • esf.ClientSummary (ESF Summary):
    • ID (id) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Jahr (year) : The year

    • Monate (month) : The number of the month or the week.

    • S.Inf (esf10) : Informative sessions

    • E.Ind (esf20) : Individual consultation

    • E.For (esf21) : Evaluation of external training

    • SIS (esf30) : Certified integration service

    • Tst (esf40) : Level tests

    • Info (esf41) : IT basics

    • Mob (esf42) : Mobility

    • Rem (esf43) : Remedial teaching

    • AN! (esf44) : Wake up!

    • MSP (esf50) : Getting a professional situation

    • CyE (esf60) : Cyber Job

    • 60§7 (esf70) : Art 60§7 job supplyment

    • Klient (master) : The target model of the master will automatically receive an action check_summaries.

    • Akademischer Grad (education_level) :

    • Kinder zu Lasten (children_at_charge) :

    • Certified handicap (certified_handicap) :

    • Other difficulty (other_difficulty) :

    • Participation Certificate (result) :

    • Bemerkung (remark) :

    • User modified (user_modified) :

    • Resultate (results) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • excerpts.Excerpt (Auszug):
    • ID (id) :

    • Klient (project) : Pointer to the project to which this object is related.

    • Druckdatum (build_time) : Timestamp of the built target file. Contains None if no build hasn’t been called yet.

    • Druckmethode (build_method) :

    • Empfänger (Person) (contact_person) : The optional contact person of the recipient of this excerpt. See ContactRelated.contact_person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Empfänger (Organisation) (company) : The optional company of the recipient of this excerpt. See ContactRelated.company.

    • Autor (user) : The author of this database object.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Auszugsart (excerpt_type) : The type of this excerpt (ForeignKey to ExcerptType).

    • Sprache (language) : The language used for printing this excerpt.

    • Textkörper-Vorlage (body_template_content) : None

    • Vorschau (preview) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • excerpts.ExcerptType (Auszugsart):
    • ID (id) :

    • Bezeichnung (name) : The designation of this excerpt type. One field for every language.

    • Druckmethode (build_method) : See lino.modlib.printing.mixins.PrintableType.build_method.

    • Vorlage (template) : The main template to be used when printing an excerpt of this type.

    • als Anhang per E-Mail (attach_to_email) : Whether the printable file should be attached to the email when creating an email from a mailable of this type.

    • E-Mail-Vorlage (email_template) : The template to use when sending this an excerpt of this type by email.

    • Bescheinigend (certifying) : Ob Auszüge dieser Art als einmalige Ausdrucke behandelt werden sollen.

    • Bemerkung (remark) :

    • Textkörper-Vorlage (body_template) : The body template to use when printing an excerpt of this type.

    • Modell (content_type) : The database model for which this excerpt type is to be used.

    • Primär (primary) : Whether this is the default type to use for this model. There’s at most one primary type per model. Enabling this field will automatically make the other types non-primary.

    • Backward compatible (backward_compat) : Check this to have this in template context point to owner instead of excerpt.

    • Empfänger drucken (print_recipient) : Whether to print a recipient field in document.

    • Direkt drucken (print_directly) :

    • Excerpt shortcut (shortcut) : Optional pointer to a shortcut field. If this is not empty, then the given shortcut field will manage excerpts of this type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Modell (content_type_display) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • finan.BankStatement (Kontoauszug):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Journal (journal) : The journal into which this voucher has been booked.

    • Buchungsdatum (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

    • Belegdatum (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

    • Geschäftsjahr (fiscal_year) :

    • Buchungsperiode (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

    • Nr. (number) : The sequence number of this voucher within its journal.

    • Interne Referenz (narration) : A short explanation to explain the subject matter of this journal entry.

    • Beleg (voucher_ptr) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Belegzustand (state) : The state of this voucher. It decides among others whether you can edit this voucher or not.

    • Standardwert Konto (item_account) : The default value to use when FinancialVoucherItem.account of an item is empty.

    • Externe Referenz (item_remark) : The default value to use when FinancialVoucherItem.remark of an item is empty.

    • last item date (last_item_date) :

    • Beginnsaldo (balance1) : The old (or start) balance.

    • Endsaldo (balance2) : The new (or end) balance.

    • Nr. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

    • Eingangsdokument (source_document) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • XML file (xml_file) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • finan.BankStatementItem (Belegszeile Kontoauszüge):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Klient (project) : The “project” related to this transaction. For example in Lino Welfare this is the client.

    • Match (match) : The movement to be matched.

    • Betrag (amount) : The amount to be booked. If this is empty, then the voucher cannot be registered.

    • Externe Referenz (remark) : External reference. The description of this transation as seen by the external partner.

    • Haushaltsartikel (account) : The general account to be used in the primary booking. If this is empty, use item_account of the voucher.

    • Partner (partner) : The partner account to be used in the primary booking.

    • Datum (date) : The value date of this item.

    • Kontoauszug (voucher) : A foreign key to the numbered voucher that contains this item. The related_name must be ‘items’.

    • Ausgabe (expense) : None

    • Eingang (income) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • finan.JournalEntry (Diverse Buchung):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Journal (journal) : The journal into which this voucher has been booked.

    • Buchungsdatum (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

    • Belegdatum (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

    • Geschäftsjahr (fiscal_year) :

    • Buchungsperiode (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

    • Nr. (number) : The sequence number of this voucher within its journal.

    • Interne Referenz (narration) : A short explanation to explain the subject matter of this journal entry.

    • Beleg (voucher_ptr) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Klient (project) : Pointer to the “project”. This field exists only if the project_model setting is nonempty.

    • Belegzustand (state) : The state of this voucher. It decides among others whether you can edit this voucher or not.

    • Standardwert Konto (item_account) : The default value to use when FinancialVoucherItem.account of an item is empty.

    • Externe Referenz (item_remark) : The default value to use when FinancialVoucherItem.remark of an item is empty.

    • last item date (last_item_date) :

    • Nr. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

    • Eingangsdokument (source_document) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • XML file (xml_file) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • finan.JournalEntryItem (Belegszeile Diverse Buchungen):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Klient (project) : The “project” related to this transaction. For example in Lino Welfare this is the client.

    • Match (match) : The movement to be matched.

    • Betrag (amount) : The amount to be booked. If this is empty, then the voucher cannot be registered.

    • Externe Referenz (remark) : External reference. The description of this transation as seen by the external partner.

    • Haushaltsartikel (account) : The general account to be used in the primary booking. If this is empty, use item_account of the voucher.

    • Partner (partner) : The partner account to be used in the primary booking.

    • Datum (date) : The value date of this item.

    • Diverse Buchung (voucher) : A foreign key to the numbered voucher that contains this item. The related_name must be ‘items’.

    • Debit (debit) : None

    • Kredit (credit) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • finan.PaymentOrder (Zahlungsauftrag):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Journal (journal) : The journal into which this voucher has been booked.

    • Buchungsdatum (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

    • Belegdatum (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

    • Geschäftsjahr (fiscal_year) :

    • Buchungsperiode (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

    • Nr. (number) : The sequence number of this voucher within its journal.

    • Interne Referenz (narration) : A short explanation to explain the subject matter of this journal entry.

    • Beleg (voucher_ptr) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Belegzustand (state) : The state of this voucher. It decides among others whether you can edit this voucher or not.

    • Standardwert Konto (item_account) : The default value to use when FinancialVoucherItem.account of an item is empty.

    • Externe Referenz (item_remark) : The default value to use when FinancialVoucherItem.remark of an item is empty.

    • Total (total) : The total amount. This is automatically computed when you register de voucher.

    • Ausführungsdatum (execution_date) : The execution date of payment order. If this is empty, Lino assumes the entry_date when writing the pain_001.xml file.

    • Drucken (print_actions) : None

    • Nr. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

    • Eingangsdokument (source_document) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • XML file (xml_file) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • finan.PaymentOrderItem (Belegszeile Zahlungsaufträge):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Klient (project) : The “project” related to this transaction. For example in Lino Welfare this is the client.

    • Match (match) : The movement to be matched.

    • Betrag (amount) : The amount to be booked. If this is empty, then the voucher cannot be registered.

    • Externe Referenz (remark) : External reference. The description of this transation as seen by the external partner.

    • Haushaltsartikel (account) : The general account to be used in the primary booking. If this is empty, use item_account of the voucher.

    • Zahlungsempfänger (partner) : The partner account to be used in the primary booking.

    • Bankkonto (bank_account) :

    • Zahlungsauftrag (voucher) : A foreign key to the numbered voucher that contains this item. The related_name must be ‘items’.

    • Zu zahlen (to_pay) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • households.Household (Haushalt):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Haushaltsart (type) : The type of this household. See household types

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

  • households.Member (Mitglied):
    • ID (id) :

    • Titel (title) : Used to specify a professional position or academic qualification like “Dr.” or “PhD”.

    • Vorname (first_name) : The first name, also known as given name.

    • Zwischenname (middle_name) : A space-separated list of all middle names.

    • Familienname (last_name) : The last name, also known as family name.

    • Geschlecht (gender) : The sex of this person (male or female).

    • Geburtsdatum (birth_date) : Uncomplete dates are allowed, e.g. “00.00.1980” means “some day in 1980”, “00.07.1980” means “in July 1980” or “23.07.0000” means “on a 23th of July”.

    • Beginnt am (start_date) : Since when this membership exists. This is usually empty.

    • Enddatum (end_date) : Until when this membership exists.

    • Rolle (role) :

    • Person (person) :

    • Haushalt (household) :

    • Abhängigkeit (dependency) :

    • Primär (primary) : Whether this is the primary household of this person. Checking this field will automatically disable any other primary memberships.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Alter (age) : Virtual field displaying the age in years.

  • households.Type (Haushaltsart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • humanlinks.Link (Personal Link):
    • ID (id) :

    • Verwandschaftsart (type) : The type of link. Pointer to LinkTypes.

    • Wer ist… (parent) : Pointer to the person who is “parent”.

    • Von wem… (child) : Pointer to the person who is “child”.

    • Art (type_as_parent) : Displays LinkTypes.as_parent() for this link.

    • Art (type_as_child) : Displays LinkTypes.as_child() for this link.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • isip.Contract (VSE):
    • ID (id) :

    • Sekretär (signer1) :

    • Präsident (signer2) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Verantwortlicher (DSBE) (user) : Die Person, die diesen Vertrag erstellt hat.

    • Klient (client) : The client for whom this contract is done.

    • Sprache (language) : The language of this contract. Default value is the client’s language.

    • Laufzeit von (applies_from) : The start date of the contract.

    • Laufzeit bis (applies_until) : The planned end date of this contract.

    • Beschlossen am (date_decided) : When the contract was ratified by the responsible board.

    • Ausgestellt am (date_issued) : When the contract was issued to the client and signed by them.

    • Verantwortlicher (ASD) (user_asd) : Die verantwortliche Person im allgemeinen Sozialdienst.

    • Auswertungsstrategie (exam_policy) :

    • Beendigungsgrund (ending) : The reason of prematured ending. Pointer to ContractEnding

    • Enddatum (date_ended) : The date when this contract was effectively ended. This field is set to the same value as applies_until.

    • Vertragsart (type) : The type of this contract. Pointer to ContractType.

    • Bildungsart (study_type) : The type of study that is going to be followed during this contract.

    • Etappen (stages) :

    • Zielsetzungen (goals) :

    • Verpflichtungen ASD (duties_asd) :

    • Verpflichtungen DSBE (duties_dsbe) :

    • Verpflichtungen ÖSHZ (duties_pcsw) :

    • Verpflichtungen Person (duties_person) :

    • Verantwortlicher (DSBE) (user_dsbe) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • isip.ContractEnding (Beendigungsgrund):
    • ID (id) :

    • Bezeichnung (name) :

    • VSE (use_in_isip) :

    • Art. 60§7 (use_in_jobs) :

    • Erfolgreich abgeschlossen (is_success) :

    • Erfordert Enddatum (needs_date_ended) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • isip.ContractPartner (Vertragspartner):
    • ID (id) :

    • Represented by (contact_person) :

    • Represented as (contact_role) :

    • Referenzperson (reference_person) :

    • Aufgabenbereich (responsibilities) :

    • Organisation (company) :

    • VSE (contract) :

    • Verpflichtungen Firma (duties_company) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • isip.ContractType (VSE-Art):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Voller Name (full_name) : The full description of this contract type as used in printed documents.

    • Auswertungsstrategie (exam_policy) : The default examination policy to be used for contracts of this type.

    • Überlappungsgruppe (overlap_group) : The overlap group to use when checking whether two contracts are overlapping or not. If this field is empty, Lino does not check at all for overlapping contracts.

    • Vorlage (template) : The main template to use instead of the default template defined on the excerpt type.

    • Referenz (ref) :

    • erfordert Ausbildungsart (needs_study_type) : Whether contracts of this type need their study_type field filled in.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • isip.ExamPolicy (Auswertungsstrategie):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Beginnt am (start_date) : The start date of the first meeting to be generated.

    • Beginnt um (start_time) :

    • Enddatum (end_date) : The end date of the first meeting to be generated. Leave this field empty if the meetings last less than one day.

    • Endet um (end_time) :

    • Wiederholung (every_unit) : The interval between each periodic iteration.

    • … alle (every) : The frequency of periodic iteration: daily, weekly, monthly or yearly.

    • Positionen (positions) : Space-separated list of one or several positions within the recurrency cycle.

    • Montag (monday) :

    • Dienstag (tuesday) :

    • Mittwoch (wednesday) :

    • Donnerstag (thursday) :

    • Freitag (friday) :

    • Samstag (saturday) :

    • Sonntag (sunday) :

    • Anzahl Termine (max_events) : Maximum number of calendar entries to generate.

    • Kalendereintragsart (event_type) : Generated events will receive this type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Beschreibung (what_text) : None

    • Male (times_text) : None

    • Wann (weekdays_text) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.

    • Dauer (duration) : None

  • jobs.Candidature (Stellenanfrage):
    • ID (id) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Klient (person) :

    • Stelle (job) :

    • Anfragedatum (date_submitted) : Datum wann der SA die Kandidatur erfasst hat.

    • Bemerkung (remark) :

    • Kandidatur-Zustand (state) :

    • Art.60 (art60) : Whether an art.60 contract can satisfy this candidature.

    • Art.61 (art61) : Whether an art.61 contract can satisfy this candidature.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • jobs.Contract (Art.60§7-Konvention):
    • ID (id) :

    • Sekretär (signer1) :

    • Präsident (signer2) :

    • Represented by (contact_person) :

    • Represented as (contact_role) :

    • Ausgedruckt (printed_by) : Pointer to the database excerpt that certifies this database row.

    • Verantwortlicher (DSBE) (user) : Die Person, die diesen Vertrag erstellt hat.

    • Klient (client) : The client for whom this contract is done.

    • Sprache (language) : The language of this contract. Default value is the client’s language.

    • Laufzeit von (applies_from) : The start date of the contract.

    • Laufzeit bis (applies_until) : The planned end date of this contract.

    • Beschlossen am (date_decided) : When the contract was ratified by the responsible board.

    • Ausgestellt am (date_issued) : When the contract was issued to the client and signed by them.

    • Verantwortlicher (ASD) (user_asd) : Die verantwortliche Person im allgemeinen Sozialdienst.

    • Auswertungsstrategie (exam_policy) :

    • Beendigungsgrund (ending) : The reason of prematured ending. Pointer to ContractEnding

    • Enddatum (date_ended) : The date when this contract was effectively ended. This field is set to the same value as applies_until.

    • Referenzperson (reference_person) :

    • Aufgabenbereich (responsibilities) :

    • Dauer (Arbeitstage) (duration) : The duration of this job supplyment (number of working days).

    • Bemerkung (remark) :

    • Organisation (company) :

    • Art (type) : The type of this contract. Pointer to a subclass of ContractTypeBase.

    • Stelle (job) :

    • Arbeitsregime (regime) :

    • Stundenplan (schedule) :

    • Stundensatz (hourly_rate) :

    • Rückzahlung (refund_rate) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Ausgedruckt (printed) : Displays information about when this database row has been printed.

  • jobs.ContractType (Art.60§7-Konventionsart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Voller Name (full_name) : The full description of this contract type as used in printed documents.

    • Auswertungsstrategie (exam_policy) : The default examination policy to be used for contracts of this type.

    • Überlappungsgruppe (overlap_group) : The overlap group to use when checking whether two contracts are overlapping or not. If this field is empty, Lino does not check at all for overlapping contracts.

    • Vorlage (template) : The main template to use instead of the default template defined on the excerpt type.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • jobs.Job (Stelle):
    • ID (id) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Name (name) :

    • Stellenart (type) :

    • Stellenanbieter (provider) : The job provider for this job.

    • Vertragsart (contract_type) :

    • Stundensatz (hourly_rate) :

    • Kapazität (capacity) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • jobs.JobProvider (Stellenanbieter):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Rechtsform (type) : Pointer to the CompanyType.

    • MwSt.-Nr. (vat_id) : The national VAT identification number of this partner.

    • Organisation (company_ptr) :

    • Sozialökonomie (is_social) : Whether this is a recognized social economy project.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

  • jobs.JobType (Stellenart):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Bezeichnung (name) :

    • Bemerkung (remark) :

    • Sozialökonomie (is_social) :

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • jobs.Offer (Stellenangebot):
    • ID (id) :

    • Sektor (sector) : Pointer to the Sector.

    • Berufsbezeichnung (function) : Pointer to the Function.

    • Name (name) :

    • Stellenanbieter (provider) :

    • Beginn Auswahl (selection_from) :

    • Ende Auswahl (selection_until) :

    • Beginndatum (start_date) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • jobs.Schedule (Stundenplan):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • languages.Language (Sprache):
    • Bezeichnung (name) : The translatable name of this database row.

    • id (id) :

    • iso2 (iso2) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • linod.SystemTask (Systemaufgabe):
    • ID (id) :

    • Beginnt am (start_date) : The start date of the first meeting to be generated.

    • Beginnt um (start_time) :

    • Enddatum (end_date) : The end date of the first meeting to be generated. Leave this field empty if the meetings last less than one day.

    • Endet um (end_time) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Wiederholung (every_unit) : The interval between each periodic iteration.

    • … alle (every) : The frequency of periodic iteration: daily, weekly, monthly or yearly.

    • Positionen (positions) : Space-separated list of one or several positions within the recurrency cycle.

    • Montag (monday) :

    • Dienstag (tuesday) :

    • Mittwoch (wednesday) :

    • Donnerstag (thursday) :

    • Freitag (friday) :

    • Samstag (saturday) :

    • Sonntag (sunday) :

    • Anzahl Termine (max_events) : Maximum number of calendar entries to generate.

    • Logging level (log_level) : The logging level to apply when running this task.

    • Abgeschaltet (disabled) : Tells whether the task should be ignored.

    • Gestartet um (last_start_time) : The timestamp when this task has started running in the task runner.

    • Beendet um (last_end_time) : The timestamp when this task has finished running in the task runner.

    • Angefragt um (requested_at) : The timestamp when a user has explicitly requested to run this task.

    • Protokollierte Nachrichten (message) : Stores information about the job, mostly logs.

    • Background procedure (procedure) : The background procedure to run in this task.

    • Name (name) :

    • Status (status) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Beschreibung (what_text) : None

    • Male (times_text) : None

    • Wann (weekdays_text) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.

    • Dauer (duration) : None

  • memo.Mention (Erwähnung):
    • ID (id) :

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Target (Modell) (target_type) :

    • Target (Objekt) (target_id) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • newcomers.Broker (Vermittler):
    • ID (id) :

    • name (name) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • newcomers.Competence (Kompetenz):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Benutzer (user) : The author of this database object.

    • Fachbereich (faculty) :

    • Aufwand (weight) : Wieviel Aufwand mir persönlich ein Neuantrag in diesem Fachbereich verursacht (0 = gar kein Aufwand, 10 = maximaler Aufwand).

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • newcomers.Faculty (Fachbereich):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Aufwand (weight) : Wieviel Aufwand ein Neuantrag in diesem Fachbereich allgemein verursacht (0 = gar kein Aufwand, 10 = maximaler Aufwand).

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • notes.EventType (Event Type):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bemerkung (remark) :

    • Inhalt (body) :

    • Inhalt (fr) (body_fr) :

    • Inhalt (en) (body_en) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • notes.Note (Ereignis/Notiz):
    • ID (id) :

    • Klient (project) : Pointer to the project to which this object is related.

    • Druckdatum (build_time) : Timestamp of the built target file. Contains None if no build hasn’t been called yet.

    • Druckmethode (build_method) :

    • Empfänger (Person) (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Empfänger (Organisation) (company) : Pointer to Company.

    • Autor (user) : The author of this database object.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Datum (date) :

    • Zeit (time) :

    • Notizart (Inhalt) (type) :

    • Ereignisart (Form) (event_type) :

    • Betreff (subject) :

    • Inhalt (body) :

    • Sprache (language) :

    • Wichtig (important) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • notes.NoteType (Notizart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Druckmethode (build_method) : A pointer to an item of BuildMethods.

    • Vorlage (template) : The name of the file to be used as template.

    • als Anhang per E-Mail (attach_to_email) : Whether the printable file should be attached to the email when creating an email from a mailable of this type.

    • E-Mail-Vorlage (email_template) : The name of the file to be used as template when creating an email from a mailable of this type.

    • wichtig (important) :

    • Bemerkung (remark) :

    • Sondernotizart (special_type) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • notify.Message (Benachrichtigung):
    • ID (id) :

    • Erstellt (created) : Timestamp of when this message has been emitted.

    • Empfänger (user) : The recipient of this message. The site user to whom this message is to be delivered.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Message Type (message_type) : The notification message type.

    • gelesen (seen) : Timestamp of when the recipient of this message has marked it as seen.

    • verschickt (sent) : Timestamp of when this message has been sent via email to its recipient.

    • Inhalt (body) : The body of this message. See Subject and body of a notification message.

    • Benachrichtigungsmodus (mail_mode) :

    • Betreff (subject) : The subject of this message. See Subject and body of a notification message.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

  • outbox.Attachment (Anhang):
    • ID (id) :

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • E-Mail-Ausgang (mail) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • outbox.Mail (E-Mail-Ausgang):
    • ID (id) :

    • Klient (project) : Pointer to the project to which this object is related.

    • Absender (user) : The author of this database object.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Datum (date) :

    • Betreff (subject) :

    • Inhalt (body) :

    • sent (sent) :

    • Empfänger (recipients) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • outbox.Recipient (Empfänger):
    • ID (id) :

    • E-Mail-Ausgang (mail) :

    • Partner (partner) :

    • Empfängerart (type) :

    • Adresse (address) :

    • Name (name) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.Activity (Beruf):
    • ID (id) :

    • name (name) :

    • Listing 104 (lst104) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.AidType (Sozialhilfeart):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.Client (Klient):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Titel (title) : Used to specify a professional position or academic qualification like “Dr.” or “PhD”.

    • Vorname (first_name) : The first name, also known as given name.

    • Zwischenname (middle_name) : A space-separated list of all middle names.

    • Familienname (last_name) : The last name, also known as family name.

    • Geschlecht (gender) : The sex of this person (male or female).

    • Geburtsdatum (birth_date) : Uncomplete dates are allowed, e.g. “00.00.1980” means “some day in 1980”, “00.07.1980” means “in July 1980” or “23.07.0000” means “on a 23th of July”.

    • Person (person_ptr) :

    • Zustand (client_state) : Pointer to ClientStates.

    • NR-Nummer (national_id) : The SSIN. It is a nullable char field declared unique. It is not validated directly because that would cause problems with legacy data where SSINs need manual control. See also BeIdCardHolderChecker.

    • Staatsangehörigkeit (nationality) : The nationality. This is a pointer to countries.Country which should contain also entries for refugee statuses.

    • Geburtsland (birth_country) :

    • Geburtsort (birth_place) : The birth place in plain text as it was on the eid card.

    • eID-Kartennummer (card_number) :

    • ID-Karte gültig von (card_valid_from) :

    • bis (card_valid_until) :

    • eID-Kartenart (card_type) : The type of id card.

    • eID-Karte ausgestellt durch (card_issuer) : The administration who issued this ID card.

    • Nationality (text) (nationality_text) : The nationality in plain text as it was on the eid card. For a French citizen the value on the eid card can be “Français”, “Française”, “Frans”, “Franzose”, “Französin”, “French” depending on the sex and the issuing municipality. This field is just informative, Lino does not automatically map it to the nationality field.

    • Adelstitel (noble_condition) : Eventueller Adelstitel

    • Integrationsphase (group) : Pointer to PersonGroup. The intergration phase of this client.

    • Zivilstand (civil_state) : The civil state of this client. Allowed choices are defined in CivilState.

    • Einwohnerregister (residence_type) :

    • Lebt in Belgien seit (in_belgium_since) :

    • Residence until (residence_until) :

    • Arbeitslos seit (unemployed_since) : Since when the client has not been employed in any regular job.

    • Sucht Arbeit seit (seeking_since) : Since when the client is seeking for a job.

    • Braucht Aufenthaltserlaubnis (needs_residence_permit) :

    • Braucht Arb.Erl. (needs_work_permit) :

    • Wartezeit bis (work_permit_suspended_until) :

    • Sozialhilfeart (aid_type) :

    • Deklarierter Name (declared_name) :

    • Arbeit suchend (is_seeking) :

    • Nicht verfügbar bis (unavailable_until) :

    • Begründung (unavailable_why) :

    • Sonstige Hindernisse (obstacles) :

    • Sonstige Fähigkeiten (skills) :

    • Kontaktperson ADG (job_office_contact) :

    • Ablehnungsgrund (refusal_reason) :

    • Bemerkungen (Sozialsekretariat) (remarks2) :

    • Gesdos-Nr (gesdos_id) :

    • TIM-ID (tim_id) :

    • Sozialhilfeempfänger (is_cpas) :

    • Altenheim (is_senior) :

    • Krankenkasse (health_insurance) :

    • Apotheke (pharmacy) :

    • Arbeitslosengeld (income_ag) :

    • Wartegeld (income_wg) :

    • Krankengeld (income_kg) :

    • Rente (income_rente) :

    • andere Einkommen (income_misc) :

    • Interim-Agenturen (job_agents) :

    • Vermittler (broker) : The Broker who sent this Newcomer.

    • Fachbereich (faculty) : The Faculty this client has been attributed to.

    • ESF data (has_esf) : Whether Lino should make ESF summaries for this client.

    • None (overview) : A panel with general information about this client.

    • Erstellte Lebensläufe (cvs_emitted) : A virtual field displaying a group of shortcut links for managing CVs (Curriculum Vitaes).

    • Identifizierendes Dokument (id_document) : A virtual field displaying a group of buttons for managing the “identifying document”, i.e. an uploaded document which has been used as alternative to the eID card.

    • Vertrag beginnt (applies_from) : None

    • Vertrag endet (applies_until) : None

    • Arbeitet bei (contract_company) : None

    • Active contract (active_contract) : None

    • ZDSS (cbss_relations) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

    • Alter (age) : Virtual field displaying the age in years.

    • Zusammenfassung ZDSS (cbss_summary) : None

    • IdentifyPerson-Anfragen (cbss_identify_person) : None

    • ManageAccess-Anfragen (cbss_manage_access) : None

    • Tx25-Anfragen (cbss_retrieve_ti_groups) : None

    • Sprachkenntnis (language_knowledge) : A summary of the language knowledges of this person.

    • Muttersprachen (mother_tongues) : None

    • None (cef_level_de) : None

    • None (cef_level_fr) : None

    • None (cef_level_en) : None

    • eID-Karte (eid_info) : None

    • None (image) : Virtual field which displays the picture.

    • Primärbegleiter (primary_coach) : None

    • Begleiter (coaches) : None

    • Termin finden (find_appointment) : None

  • pcsw.Conviction (Vorstrafe):
    • ID (id) :

    • Klient (client) :

    • Datum (date) :

    • Prejudicial (prejudicial) :

    • Bezeichnung (designation) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.Dispense (Dispenz):
    • ID (id) :

    • Klient (client) :

    • Begründung (reason) :

    • Bemerkung (remarks) :

    • Dispenziert seit (start_date) :

    • bis (end_date) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.DispenseReason (Dispenzgrund):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • pcsw.Exclusion (AG-Sperre):
    • ID (id) :

    • Klient (person) :

    • Begründung (type) :

    • AG-Sperre seit (excluded_from) :

    • bis (excluded_until) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.ExclusionType (AG-Sperrgrund):
    • ID (id) :

    • name (name) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • pcsw.PersonGroup (Integrationsphase):
    • ID (id) :

    • Bezeichnung (name) :

    • Referenzname (ref_name) :

    • Aktive Phase (active) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • periods.StoredPeriod (Buchungsperiode):
    • ID (id) :

    • Beginnt am (start_date) :

    • Enddatum (end_date) :

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Zustand (state) :

    • Geschäftsjahr (year) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • periods.StoredYear (Geschäftsjahr):
    • ID (id) :

    • Beginnt am (start_date) :

    • Enddatum (end_date) :

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Zustand (state) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • properties.PropChoice (Auswahlmöglichkeit):
    • ID (id) :

    • Eigenschafts-Datentyp (type) :

    • Wert (value) :

    • Bezeichnung (text) :

    • Bezeichnung (fr) (text_fr) :

    • Bezeichnung (en) (text_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • properties.PropGroup (Eigenschaftsgruppe):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Property area (property_area) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • properties.PropType (Eigenschafts-Datentyp):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Auswahliste (choicelist) :

    • Standardwert (default_value) : The default value to set when creating a PropertyOccurence. This is currently used only in some fixture…

    • Beschränken auf Auswahl (limit_to_choices) :

    • Mehrfachauswahl (multiple_choices) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • properties.Property (Eigenschaft):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Eigenschaftsgruppe (group) :

    • Eigenschafts-Datentyp (type) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • sepa.Account (Bankkonto):
    • ID (id) :

    • Partner (partner) : The partner who owns this bank account.

    • IBAN (iban) : IBANField(verbose_name=_(“IBAN”))

    • BIC (bic) : BICField(verbose_name=_(“BIC”), blank=True)

    • Bemerkung (remark) : CharField(_(“Remark”), max_length=200, blank=True)

    • Primär (primary) : Enabling this field will automatically disable any previous primary account and update the partner’s IBAN and BIC

    • Kontoart (account_type) :

    • Verwaltet (managed) : Whether this account is being managed by the PCSW.

    • Kontoauszüge (statements) : A virtual field which displays the date of the last imported statement for this account. Clicking on this date will open the B2C account <lino_xl.lib.b2c.models.Account> with same IBAN number.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • sessions.Session (Sitzung):
    • Sitzungs-ID (session_key) :

    • Sitzungsdaten (session_data) :

    • Verfallsdatum (expire_date) :

    • Workflow (workflow_buttons) : None

  • system.SiteConfig (Site-Konfiguration):
    • ID (id) :

    • Standard-Konstruktionsmethode (default_build_method) : The default build method to use when rendering printable documents.

    • Simuliertes Datum (simulate_today) : A constant user-defined date to be substituted as current system date.

    • Site owner (site_company) : The site operator, i.e. the legal person that operates this Lino site.

    • Sekretär (signer1) :

    • Präsident (signer2) :

    • Funktion des ersten Unterzeichners (signer1_function) : Kontaktfunktion “Sekretär”

    • Funktion des zweiten Unterzeichners (signer2_function) : Kontaktfunktion “Präsident”

    • Standard-Kalenderintragsart (default_event_type) : The default type of events on this site.

    • Site Calendar (site_calendar) : The default calendar of this site.

    • Max automatic events (max_auto_events) : Maximum number of automatic events to be generated.

    • Hide events before (hide_events_before) : If this is specified, certain tables show only events after the given date.

    • Color (default_color) :

    • Default type for client calendar events (client_calendar) :

    • Client guest role (client_guestrole) : Default guest role of client in calendar events.

    • Rolle der anderen bei Gruppenterminen (team_guestrole) :

    • Default type for prompt events (prompt_calendar) :

    • Budget-Kopiervorlage (master_budget) : The budget whose content is to be copied into new budgets.

    • Default system note type (system_note_type) : Note Type used by system notes. If this is empty, then system notes won’t create any entry to the Notes table.

    • Lokales Arbeitsamt (job_office) : The Company whose contact persons will be choices for Person.job_office_contact.

    • Upload-Art Aufenthaltserlaubnis (residence_permit_upload_type) :

    • Upload-Art Arbeitserlaubnis (work_permit_upload_type) :

    • Upload-Art Führerschein (driving_licence_upload_type) :

    • sector (sector) : The CBSS sector/subsector of the requesting organization. For PCSWs this is always 17.1. Used in SSDN requests as text of the MatrixID and MatrixSubID elements of AuthorizedUser. Used in ManageAccess requests as default value for the non-editable field sector (which defines the choices of the purpose field).

    • Anfragende Organisation (cbss_org_unit) : In CBSS requests, identifies the requesting organization. For PCSWs this is the enterprise number (CBE, KBO) and should have 10 digits and no formatting characters. Used in SSDN requests as text of the AuthorizedUserOrgUnit element . Used in new style requests as text of the CustomerIdentificationcbeNumber element .

    • SSDN User Id (ssdn_user_id) : Used in SSDN requests as text of the AuthorizedUserUserID element.

    • SSDN email address (ssdn_email) : Used in SSDN requests as text of the AuthorizedUserEmail element.

    • HTTP username (cbss_http_username) : Used in the http header of new-style requests.

    • HTTP password (cbss_http_password) : Used in the http header of new-style requests.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • tinymce.TextFieldTemplate (Einfügetext):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Bezeichnung (name) :

    • Beschreibung (description) :

    • Vorlagentext (text) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • uploads.Upload (Upload-Datei):
    • ID (id) :

    • Gültig von (start_date) :

    • Gültig bis (end_date) : Date until which the original document is valid.

    • Klient (project) : Pointer to the project to which this object is related.

    • Datei (file) : Pointer to the uploaded file itself (a Django FileField).

    • MIME-Art (mimetype) : The media type of the uploaded file.

    • Dateigröße (file_size) : The size of the file in bytes. Not yet implemented.

    • ausgestellt durch (contact_person) : Pointer to Person.

    • Represented as (contact_role) : The optional Role of the contact_person within company.

    • Organisation (company) : Pointer to Company.

    • Hochgeladen durch (user) : The author of this database object.

    • Verknüpft mit (Modell) (owner_type) :

    • Verknüpft mit (Objekt) (owner_id) :

    • Upload-Bereich (upload_area) : The upload area this file belongs to.

    • Upload-Art (type) : The type of this upload.

    • Dateibibliothek (volume) : A pointer to the library volume where this file is stored.

    • Bibliotheksdatei (library_file) : The path of this file, relative the volume’s root.

    • Beschreibung (description) : A short description entered manually by the user.

    • Bemerkung (remark) :

    • Nötig (needed) : Whether the responsible user should be reminded when validity of this upload reaches its end.

    • Beschreibung (description_link) : Almost the same as description, but if file is not empty, the text is clickable, and clicking on it opens the uploaded file in a new browser window.

    • None (preview) : None

    • Thumbnail (thumbnail) : None

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • None (full_page) : None

  • uploads.UploadType (Upload-Art):
    • ID (id) :

    • Bezeichnung (name) : The translatable name of this database row.

    • Upload-Bereich (upload_area) :

    • Max. number (max_number) : No need to upload more uploads than N of this type. -1 means no limit.

    • Wanted (wanted) : Add a (+) button when there is no upload of this type.

    • Upload shortcut (shortcut) : Optional pointer to a virtual upload shortcut field. If this is not empty, then the given shortcut field will manage uploads of this type. See also Shortcuts.

    • Ablaufwarnung (Einheit) (warn_expiry_unit) :

    • Ablaufwarnung (Wert) (warn_expiry_value) :

    • Bezeichnung (fr) (name_fr) :

    • Bezeichnung (en) (name_en) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • uploads.Volume (Dateibibliothek):
    • ID (id) :

    • Referenz (ref) : Die Referenz. Muss entweder leer oder einzig sein.

    • Root directory (root_dir) :

    • Beschreibung (description) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • users.Authority (Vollmacht):
    • ID (id) :

    • Autor (user) : The user who gives the right of representation. author of this authority

    • Benutzer (authorized) : The user who gets the right to represent the author

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • users.User (Benutzer):
    • ID (id) :

    • Beginnt am (start_date) : If start_date is given, then the user cannot sign in before that date. If end_date is given, then the user cannot sign in after that date.

    • Enddatum (end_date) :

    • E-Mail-Adresse (email) :

    • Sprache (language) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • password (password) :

    • last login (last_login) : Not used in Lino.

    • Benutzername (username) : Must be either unique or empty. User accounts having this field empty cannot be used to sign in.

    • Benutzerart (user_type) : The user type assigned to this user. User accounts having this field empty cannot be used to sign in.

    • Initialien (initials) : The initials used to refer to you when speaking to business partners. Does not need to be unique but should be reasonably identifying.

    • Vorname (first_name) :

    • Familienname (last_name) :

    • Bemerkungen (remarks) :

    • Partner (partner) : The partner record with additional contact information about this user account.

    • verification password (verification_password) : A not-yet-active password given by anonymous when they asked for a password reset. This will become the active password when the user verifies.

    • verification code (verification_code) : A random string that has been sent to the user via email in order to verify their email address.

    • verification code sent on (verification_code_sent_on) :

    • Date format (date_format) : The date format to use when parsing or displaying dates.

    • Erstempfang direkt (newcomer_consultations) : Accepts prompt consultations for newcomers.

    • Erstempfang auf Vereinbarung (newcomer_appointments) : Accepts appointments for newcomers.

    • Benachrichtigungen an mich selbst (notify_myself) :

    • Benachrichtigungsmodus (mail_mode) :

    • Kalendereintragsart (event_type) : The default type for your calendar entries.

    • User Calendar (calendar) : Calendar where your events are published.

    • Dienst (coaching_type) : The coaching type used for new coachings of this user.

    • Coaching supervisor (coaching_supervisor) : Notify me when a coach has been assigned.

    • Quote Erstempfang (newcomer_quota) : Wieviel Arbeitszeit dieser Benutzer für Neuanträge zur Verfügung steht (100 = ganztags, 50 = halbtags, 0 = gar nicht). Wenn zwei Benutzer die gleiche Belastungspunktzahl haben, aber einer davon sich nur zu 50% um Neuanträge kümmert, gilt er als doppelt so belastet wie sein Kollege.

    • Status (status) : None

    • Person (person) : A virtual read-only field that returns the Person MTI child of the partner (if it exists) and otherwise None.

    • Organisation (company) : A virtual read-only field that returns the Company MTI child of the partner (if it exists) and otherwise None.

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Erstellt (created_natural) : None

    • None (full_page) : None

  • vatless.AccountInvoice (Rechnung):
    • ID (id) :

    • Autor (user) : The author of this database object.

    • Journal (journal) : The journal into which this voucher has been booked.

    • Buchungsdatum (entry_date) : The date of the journal entry, i.e. when this voucher is to be booked.

    • Belegdatum (voucher_date) : The date on the voucher (i.e. when it has been issued by its emitter).

    • Geschäftsjahr (fiscal_year) :

    • Buchungsperiode (accounting_period) : The accounting period to use when booking this voucher. The default value is determined from entry_date.

    • Nr. (number) : The sequence number of this voucher within its journal.

    • Interne Referenz (narration) : A short explanation to explain the subject matter of this journal entry.

    • Beleg (voucher_ptr) :

    • Zahlungsempfänger (partner) : The recipient of this document. This can be a person, an organization or any type of business partner.

    • Klient (project) : Pointer to the “project”. This field exists only if the project_model setting is nonempty.

    • Zahlungsbedingungen (payment_term) : The payment term to apply for this transaction.

    • Ihr Zeichen (your_ref) : The reference used by the business partner for referring to this voucher.

    • Zahlungsziel (due_date) : The date when the invoice is expected to have been paid.

    • Match (match) : The movement to be matched.

    • Bankkonto (bank_account) :

    • Belegzustand (state) : The workflow state field.

    • Betrag (amount) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Nr. (number_with_year) : Shows the accounting year and the number of this voucher within its journal.

    • Eingangsdokument (source_document) : None

    • XML file (xml_file) : None

  • vatless.InvoiceItem (Rechnungsposition):
    • ID (id) :

    • Nr. (seqno) : The sequence number of this item with its parent.

    • Klient (project) : Pointer to the “project”. This field exists only if the project_model setting is nonempty.

    • Haushaltsartikel (account) : ForeignKey pointing to the account (accounting.Account) that is to be moved.

    • Rechnung (voucher) : A foreign key to the numbered voucher that contains this item. The related_name must be ‘items’.

    • Beschreibung (title) :

    • Betrag (amount) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • (dndreorder) : A place holder column for drag and drop row reorder on React front end

    • Bearbeiten (move_buttons) : Displays buttons for certain actions on this row:

  • xcourses.Course (Kurs):
    • ID (id) :

    • Kursangebot (offer) :

    • Name (title) :

    • Beginndatum (start_date) :

    • Bemerkung (remark) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • xcourses.CourseContent (Kursinhalt):
    • ID (id) :

    • Name (name) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • xcourses.CourseOffer (Kursangebot):
    • ID (id) :

    • Name (title) :

    • Gastrolle (guest_role) : Default guest role for particpants of events.

    • Kursinhalt (content) :

    • Kursanbieter (provider) :

    • Beschreibung (description) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

  • xcourses.CourseProvider (Kursanbieter):
    • ID (id) :

    • E-Mail-Adresse (email) : The primary email address.

    • Sprache (language) : The language to use when communicating with this partner.

    • Adresse (URL) (url) :

    • Telefon (phone) : The primary phone number.

    • Handy (gsm) : The primary mobile phone number.

    • Fax (fax) :

    • Bearbeitet (modified) : The time when this database object was last modified.

    • Erstellt (created) : The time when this database row was created.

    • Land (country) :

    • Ortschaft (city) : Die Ortschaft, d.h. üblicherweise das Dorf oder die Stadt.

    • Postleitzahl (zip_code) :

    • Regierungsbezirk (region) :

    • Adresszeile vor Straße (addr1) : Adresszeile vor Straße

    • Präfix Straße (street_prefix) : Text to print before name of street, but to ignore for sorting.

    • Straße (street) : Name der Straße, ohne Hausnummer

    • Nr. (street_no) : Hausnummer

    • Box (street_box) : Text to print after street number on the same line.

    • Adresszeile nach Straße (addr2) : Adresszeile nach Straße

    • Name prefix (prefix) : An optional name prefix. For organisations this is inserted before the name, for persons this is inserted between first name and last name.

    • Name (name) : The full name of this partner.

    • Bemerkungen (remarks) :

    • Archiviert (is_obsolete) :

    • Beruf (activity) :

    • Klientenkontaktart (client_contact_type) :

    • Partner (partner_ptr) :

    • Rechtsform (type) : Pointer to the CompanyType.

    • MwSt.-Nr. (vat_id) : The national VAT identification number of this partner.

    • Organisation (company_ptr) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

    • Kontaktangaben (contact_details) : None

    • Ansicht als (mti_navigator) : A virtual field which defines buttons for switching between the different views.

    • Adresse (address_column) : None

    • Gemeinde (municipality) : The municipality, i.e. either the city or a parent of it.

    • Erstellt (created_natural) : None

  • xcourses.CourseRequest (Kursanfragen):
    • ID (id) :

    • Klient (person) : Le client qui désire suivre un cours.

    • Kursangebot (offer) :

    • Kursinhalt (content) : Der gewünschte Kursinhalt.)

    • Anfragedatum (date_submitted) : Datum, an dem die Anfrage erstellt wurde.

    • professionelle Eingliederung (urgent) : Ankreuzen, wenn der Kurs für die Arbeitssuche benötigt wird.

    • Zustand (state) :

    • Kurs gefunden (course) : The course which satisfies this request. Leave blank on open requests.

    • Bemerkung (remark) :

    • Enddatum (date_ended) :

    • Name (name_column) : None

    • None (navigation_panel) : A virtual field that displays the navigation panel for this row. This may be included in a detail layout, usually either on the left or the right side with full height.

    • Workflow (workflow_buttons) : Shows the current workflow state of this database row and a list of available workflow actions.

    • None (overview) : A multi-paragraph representation of this database row.

    • None (list_item) : None

    • Select multiple rows (rowselect) : None

The main menu

Rolf

Rolf is the local system administrator, he has a complete menu:

>>> show_menu('rolf')
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Benachrichtigungen, Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Mein E-Mail-Ausgang, Meine Ereignisse/Notizen, Meine Datenkontrollliste
- Kalender : Kalender, Meine Termine, Überfällige Termine, Meine unbestätigten Termine, Meine Aufgaben, Meine Gäste, Meine Anwesenheiten, Meine überfälligen Termine
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher, Meine Warteschlange
- ÖSHZ : Klienten, Meine Begleitungen, Zu bestätigende Hilfebeschlüsse
- Buchhaltung :
  - Rechnungseingänge : Rechnungseingänge (REG), Sammelrechnungen (SREG)
  - Ausgabeanweisungen : Ausgabeanweisungen (AAW)
  - Zahlungsaufträge : KBC Zahlungsaufträge (ZKBC)
  - SEPA-Import
- DSBE :
  - Klienten
  - VSEs
  - Stellenanbieter
  - Stellen
  - Stellenangebote
  - Art.60§7-Konventionen
  - Art.61-Konventionen
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Kurse : Kursanbieter, Kursangebote, Offene Kursanfragen
- Erstempfang : Neue Klienten, Verfügbare Begleiter
- Schuldnerberatung : Klienten, Meine Budgets
- Berichte :
  - Buchhaltung : Schuldner, Gläubiger
  - DSBE : Benutzer und ihre Klienten, Übersicht Art.60§7-Konventionen, Tätigkeitsbericht
- Konfigurierung :
  - System : Site-Konfiguration, Benutzer, Systemaufgaben
  - Orte : Länder, Orte
  - Kontakte : Rechtsformen, Funktionen, Gremien, Haushaltsarten
  - Eigenschaften : Eigenschaftsgruppen, Eigenschafts-Datentypen, Fachkompetenzen, Sozialkompetenzen, Hindernisse
  - Büro : Auszugsarten, Dateibibliotheken, Upload-Arten, Notizarten, Ereignisarten, Meine Einfügetexte
  - Kalender : Kalenderliste, Räume, Regelmäßige Ereignisse, Gastrollen, Kalendereintragsarten, Wiederholungsregeln, Externe Kalender
  - ÖSHZ : Integrationsphasen, Berufe, AG-Sperrgründe, Dispenzgründe, Hilfearten, Kategorien, Klientenkontaktarten, Dienste, Begleitungsbeendigungsgründe
  - Buchhaltung : Haushaltsartikel, Journale, Zahlungsbedingungen, Geschäftsjahre, Buchungsperioden
  - Lebenslauf : Bildungsarten, Akademische Grade, Sektoren, Berufsbezeichnungen, Arbeitsregimes, Statuus, Vertragsdauern, Sprachen
  - DSBE : VSE-Arten, Vertragsbeendigungsgründe, Auswertungsstrategien, Art.60§7-Konventionsarten, Stellenarten, Stundenpläne, Art.61-Konventionsarten
  - Kurse : Kursinhalte
  - Erstempfang : Vermittler, Fachbereiche
  - ZDSS : Sektoren, Eigenschafts-Codes
  - Schuldnerberatung : Kontengruppen, Konten, Budget-Kopiervorlage
- Explorer :
  - Kontakte : Kontaktpersonen, Partner, Adressenarten, Adressen, Gremienmitglieder, Haushaltsmitgliedsrollen, Mitglieder, Verwandtschaftsbeziehungen, Verwandschaftsarten
  - System : Vollmachten, Benutzerarten, Benutzerrollen, Benachrichtigungen, Änderungen, All dashboard widgets, Datenbankmodelle, Background procedures, Datentests, Datenproblemmeldungen
  - Eigenschaften : Eigenschaften
  - Büro : Auszüge, Upload-Dateien, Upload-Bereiche, E-Mail-Ausgänge, Anhänge, Ereignisse/Notizen, Einfügetexte, Erwähnungen
  - Kalender : Kalendereinträge, Aufgaben, Anwesenheiten, Abonnements, Kalendereintrag-Zustände, Anwesenheits-Zustände, Aufgaben-Zustände, Tagesplanerkolonnen, Display colors
  - ÖSHZ : AG-Sperren, Vorstrafen, Klienten, Zivilstände, Bearbeitungszustände Klienten, eID-Kartenarten, Hilfebeschlüsse, Einkommensbescheinigungen, Kostenübernahmescheine, Einfache Bescheinigungen, Phonetische Wörter, Klientenkontakte, Standard-Klientenkontaktarten, Begleitungen
  - Buchhaltung : Gemeinkonten, Begleichungsregeln, Belege, Belegarten, Bewegungen, Handelsarten, Journalgruppen, Rechnungen
  - SEPA : Bankkonten, Importierte Bankkonten, Kontoauszüge, Transaktionen
  - Finanzjournale : Kontoauszüge, Diverse Buchungen, Zahlungsaufträge
  - Lebenslauf : Sprachkenntnisse, Ausbildungen, Studien, Berufserfahrungen
  - DSBE : VSEs, Art.60§7-Konventionen, Stellenanfragen, Vertragspartner, Art.61-Konventionen, ESF Summaries, ESF fields
  - Kurse : Kurse, Kursanfragen
  - Erstempfang : Kompetenzen
  - ZDSS : IdentifyPerson-Anfragen, ManageAccess-Anfragen, Tx25-Anfragen
  - Schuldnerberatung : Budgets, Einträge
- Site : Info, Benutzersitzungen

Hubert

Hubert is an Integration agent.

>>> show_menu('hubert', language='de')
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Benachrichtigungen, Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Mein E-Mail-Ausgang, Meine Ereignisse/Notizen, Meine Datenkontrollliste
- Kalender : Kalender, Meine Termine, Meine unbestätigten Termine, Meine Aufgaben, Meine Gäste, Meine Anwesenheiten, Meine überfälligen Termine
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher, Meine Warteschlange
- ÖSHZ : Klienten, Meine Begleitungen, Zu bestätigende Hilfebeschlüsse
- DSBE :
  - Klienten
  - VSEs
  - Stellenanbieter
  - Stellen
  - Stellenangebote
  - Art.60§7-Konventionen
  - Art.61-Konventionen
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Kurse : Kursanbieter, Kursangebote, Offene Kursanfragen
- Berichte :
  - DSBE : Benutzer und ihre Klienten, Übersicht Art.60§7-Konventionen, Tätigkeitsbericht
- Konfigurierung :
  - Büro : Meine Einfügetexte
- Explorer :
  - Kontakte : Partner
  - SEPA : Importierte  Bankkonten, Kontoauszüge, Transaktionen
  - DSBE : VSEs, Art.60§7-Konventionen, Art.61-Konventionen
- Site : Info

Mélanie

Mélanie is a manager of the Integration service.

>>> p = rt.login('melanie').get_user().user_type
>>> print(p)
110 (Begleiter im DSBE+DFA (Verwalter))
>>> p.role
<lino_welfare.modlib.welfare.user_types.IntegrationAgentManager object at ...>

Because Mélanie has her language field set to French, we need to explicitly override the language of show_menu to get her menu in German:

>>> show_menu('melanie', language="de")
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Benachrichtigungen, Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Mein E-Mail-Ausgang, Meine Ereignisse/Notizen, Meine Datenkontrollliste
- Kalender : Kalender, Meine Termine, Überfällige Termine, Meine unbestätigten Termine, Meine Aufgaben, Meine Gäste, Meine Anwesenheiten, Meine überfälligen Termine
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher, Meine Warteschlange
- ÖSHZ : Klienten, Meine Begleitungen, Zu bestätigende Hilfebeschlüsse
- DSBE :
  - Klienten
  - VSEs
  - Stellenanbieter
  - Stellen
  - Stellenangebote
  - Art.60§7-Konventionen
  - Art.61-Konventionen
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Kurse : Kursanbieter, Kursangebote, Offene Kursanfragen
- Berichte :
  - DSBE : Benutzer und ihre Klienten, Übersicht Art.60§7-Konventionen, Tätigkeitsbericht
- Konfigurierung :
  - Orte : Länder, Orte
  - Kontakte : Rechtsformen, Funktionen, Haushaltsarten
  - Büro : Dateibibliotheken, Upload-Arten, Notizarten, Ereignisarten, Meine Einfügetexte
  - Kalender : Kalenderliste, Räume, Regelmäßige Ereignisse, Kalendereintragsarten, Wiederholungsregeln, Externe Kalender
  - ÖSHZ : Integrationsphasen, Berufe, AG-Sperrgründe, Dispenzgründe, Hilfearten, Kategorien, Klientenkontaktarten, Dienste, Begleitungsbeendigungsgründe
  - Buchhaltung : Geschäftsjahre, Buchungsperioden
  - Lebenslauf : Bildungsarten, Akademische Grade, Sektoren, Berufsbezeichnungen, Arbeitsregimes, Statuus, Vertragsdauern, Sprachen
  - DSBE : VSE-Arten, Vertragsbeendigungsgründe, Auswertungsstrategien, Art.60§7-Konventionsarten, Stellenarten, Stundenpläne, Art.61-Konventionsarten
  - Kurse : Kursinhalte
  - Erstempfang : Vermittler, Fachbereiche
- Explorer :
  - Kontakte : Kontaktpersonen, Partner, Adressenarten, Haushaltsmitgliedsrollen, Mitglieder, Verwandtschaftsbeziehungen, Verwandschaftsarten
  - Büro : Upload-Dateien, Upload-Bereiche, E-Mail-Ausgänge, Anhänge, Ereignisse/Notizen
  - Kalender : Aufgaben, Abonnements
  - ÖSHZ : AG-Sperren, Vorstrafen, Klienten, Bearbeitungszustände Klienten, Hilfebeschlüsse, Einkommensbescheinigungen, Kostenübernahmescheine, Einfache Bescheinigungen, Klientenkontakte, Standard-Klientenkontaktarten, Begleitungen
  - SEPA : Bankkonten, Importierte  Bankkonten, Kontoauszüge, Transaktionen
  - Lebenslauf : Sprachkenntnisse, Ausbildungen, Studien, Berufserfahrungen
  - DSBE : VSEs, Art.60§7-Konventionen, Stellenanfragen, Vertragspartner, Art.61-Konventionen
  - Kurse : Kurse, Kursanfragen
  - Erstempfang : Kompetenzen
- Site : Info

Kerstin

Kerstin is a debts consultant.

>>> p = rt.login('kerstin').get_user().user_type
>>> print(p)
300 (Schuldenberater)
>>> show_menu('kerstin', language='de')
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Benachrichtigungen, Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Mein E-Mail-Ausgang, Meine Ereignisse/Notizen, Meine Datenkontrollliste
- Kalender : Kalender, Meine Termine, Meine unbestätigten Termine, Meine Aufgaben, Meine Gäste, Meine Anwesenheiten, Meine überfälligen Termine
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher, Meine Warteschlange
- ÖSHZ : Klienten, Meine Begleitungen, Zu bestätigende Hilfebeschlüsse
- DSBE :
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Erstempfang : Neue Klienten, Verfügbare Begleiter
- Schuldnerberatung : Klienten, Meine Budgets
- Konfigurierung :
  - Büro : Meine Einfügetexte
  - Schuldnerberatung : Budget-Kopiervorlage
- Explorer :
  - Kontakte : Partner
  - SEPA : Importierte  Bankkonten, Kontoauszüge, Transaktionen
  - DSBE : VSEs, Art.60§7-Konventionen
- Site : Info

Caroline

Caroline is a newcomers consultant.

>>> p = rt.login('caroline').get_user().user_type
>>> print(p)
200 (Berater Erstempfang)
>>> show_menu('caroline', language='de')
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Benachrichtigungen, Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Mein E-Mail-Ausgang, Meine Ereignisse/Notizen, Meine Datenkontrollliste
- Kalender : Kalender, Meine Termine, Meine unbestätigten Termine, Meine Aufgaben, Meine Gäste, Meine Anwesenheiten, Meine überfälligen Termine
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher, Meine Warteschlange
- ÖSHZ : Klienten, Meine Begleitungen, Zu bestätigende Hilfebeschlüsse
- DSBE :
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Erstempfang : Neue Klienten, Verfügbare Begleiter
- Konfigurierung :
  - Büro : Meine Einfügetexte
- Explorer :
  - Kontakte : Partner
  - SEPA : Importierte  Bankkonten, Kontoauszüge, Transaktionen
  - DSBE : VSEs, Art.60§7-Konventionen
- Site : Info

Theresia

Theresia is a reception clerk.

>>> print(rt.login('theresia').get_user().user_type)
210 (Empfangsschalter)
>>> show_menu('theresia', language="de")
...
- Kontakte : Personen,  ▶ Klienten, Organisationen, -, Partner (alle), Haushalte
- Büro : Meine Auszüge, Meine ablaufenden Upload-Dateien, Meine Upload-Dateien, Meine Ereignisse/Notizen
- Kalender : Upcoming events
- Empfang : Klienten, Termine heute, Wartende Besucher, Beschäftigte Besucher, Gegangene Besucher
- ÖSHZ : Meine Begleitungen
- DSBE :
  - ZDSS : Meine IdentifyPerson-Anfragen, Meine ManageAccess-Anfragen, Meine Tx25-Anfragen
- Konfigurierung :
  - Orte : Länder, Orte
  - Kontakte : Rechtsformen, Funktionen, Haushaltsarten
  - ÖSHZ : Hilfearten, Kategorien, Klientenkontaktarten, Dienste, Begleitungsbeendigungsgründe
- Explorer :
  - Kontakte : Kontaktpersonen, Partner, Haushaltsmitgliedsrollen, Mitglieder, Verwandtschaftsbeziehungen, Verwandschaftsarten
  - ÖSHZ : Bearbeitungszustände Klienten, Hilfebeschlüsse, Einkommensbescheinigungen, Kostenübernahmescheine, Einfache Bescheinigungen, Klientenkontakte, Standard-Klientenkontaktarten, Begleitungen
  - SEPA : Importierte Bankkonten, Kontoauszüge, Transaktionen
- Site : Info

List of window layouts

The following table lists information about all data entry form definitions (called window layouts) used by Lino Welfare. There are detail layouts, insert layouts and action parameter layouts.

Each window layout defines a given set of fields.

>>> #settings.SITE.catch_layout_exceptions = False
>>> print(analyzer.show_window_fields())
...
- about.About.insert_reference : content_type, primary_key
- about.About.reset_password : email, username, new1, new2
- about.About.show : about_html
- about.About.sign_in : username, password
- about.About.verify_user : email, verification_code
- accounting.Accounts.detail : ref, common_account, id, name, name_fr, name_en, needs_partner, clearable, default_amount, accounting.MovementsByAccount
- accounting.Accounts.insert : ref, name, name_fr, name_en
- accounting.Accounts.merge_row : merge_to, reason
- accounting.AllVouchers.detail : journal, number, entry_date, accounting_period, accounting.MovementsByVoucher
- accounting.Journals.detail : name, name_fr, name_en, ref, journal_group, voucher_type, trade_type, seqno, id, account, partner, build_method, template, uploads_volume, dc, make_ledger_movements, force_sequence, yearly_numbering, auto_fill_suggestions, auto_check_clearings, preliminary, printed_name, printed_name_fr, printed_name_en
- accounting.Journals.insert : ref, name, name_fr, name_en, journal_group, voucher_type
- accounting.Journals.merge_row : merge_to, accounting_MatchRule, reason
- accounting.PaymentTerms.detail : ref, months, days, end_of_month, informal, name, name_fr, name_en, printed_text, printed_text_fr, printed_text_en
- accounting.PaymentTerms.merge_row : merge_to, reason
- addresses.Addresses.detail : country, city, zip_code, addr1, street, street_no, street_box, addr2, address_type, remark, data_source, partner
- addresses.Addresses.insert : country, city, street, street_no, street_box, address_type, remark
- aids.AidTypes.detail : id, short_name, confirmation_type, name, name_fr, name_en, excerpt_title, excerpt_title_fr, excerpt_title_en, body_template, print_directly, is_integ_duty, is_urgent, confirmed_by_primary_coach, board, company, contact_person, contact_role, pharmacy_type
- aids.AidTypes.insert : name, name_fr, name_en, confirmation_type
- aids.Categories.detail : id, name, name_fr, name_en
- aids.Grantings.detail : id, client, user, signer, workflow_buttons, request_date, board, decision_date, aid_type, category, start_date, end_date, custom_actions
- aids.Grantings.insert : client, aid_type, signer, board, decision_date, start_date, end_date
- aids.GrantingsByClient.insert : aid_type, board, decision_date, start_date, end_date
- aids.IncomeConfirmations.detail : client, user, signer, workflow_buttons, printed, company, contact_person, language, granting, start_date, end_date, category, amount, id, remark
- aids.IncomeConfirmationsByGranting.insert : client, granting, start_date, end_date, category, amount, company, contact_person, language, remark
- aids.RefundConfirmations.detail : id, client, user, signer, workflow_buttons, granting, start_date, end_date, doctor_type, doctor, pharmacy, company, contact_person, language, printed, remark
- aids.RefundConfirmationsByGranting.insert : start_date, end_date, doctor_type, doctor, pharmacy, company, contact_person, language, printed, remark
- aids.SimpleConfirmations.detail : id, client, user, signer, workflow_buttons, granting, start_date, end_date, company, contact_person, language, printed, remark
- aids.SimpleConfirmationsByGranting.insert : start_date, end_date, company, contact_person, language, remark
- art61.Activations.detail : client, id, remark, amount, company, contact_person, contact_role, start_date, end_date
- art61.ActivationsByClient.insert : company, contact_person, contact_role, start_date, end_date, amount, remark
- art61.ContractTypes.detail : id, name, name_fr, name_en, ref, overlap_group
- art61.ContractTypes.merge_row : merge_to, reason
- art61.Contracts.detail : id, client, user, language, company, contact_person, contact_role, applies_from, duration, applies_until, exam_policy, type, sector, function, job_title, status, cv_duration, regime, reference_person, remark, printed, date_decided, date_issued, date_ended, ending, sub_10_amount, sub_20_amount, sub_30_amount, sub_10_start, sub_20_start, sub_30_start, sub_10_end, sub_20_end, sub_30_end, responsibilities, uploads.UploadsByController
- art61.Contracts.insert : client, company, type, function
- b2c.Accounts.detail : iban, bic, last_transaction, owner_name, account_name, partners
- b2c.Statements.detail : account, account__owner_name, account__account_name, statement_number, local_currency, balance_start, start_date, balance_end, end_date
- b2c.Transactions.detail : statement, seqno, booking_date, value_date, amount, remote_account, remote_bic, eref, txcd_text, remote_owner, remote_owner_address, remote_owner_city, remote_owner_postalcode, remote_owner_country_code, message
- boards.Boards.detail : id, name, name_fr, name_en
- boards.Boards.insert : name, name_fr, name_en
- cal.Calendars.detail : name, name_fr, name_en, color, id, description
- cal.Calendars.insert : name, name_fr, name_en, color
- cal.EntriesByClient.insert : event_type, summary, start_date, start_time, end_date, end_time
- cal.EntriesByGuest.insert : start_date, start_time, end_time, summary, event_type
- cal.EntriesByProject.insert : start_date, start_time, end_time, summary, event_type
- cal.EventTypes.detail : name, name_fr, name_en, event_label, event_label_fr, event_label_en, planner_column, max_conflicting, max_days, esf_field, email_template, id, all_rooms, locks_user, invite_client, is_appointment, attach_to_email
- cal.EventTypes.insert : name, name_fr, name_en, invite_client
- cal.EventTypes.merge_row : merge_to, reason
- cal.Events.detail : event_type, summary, project, start_date, start_time, end_date, end_time, user, assigned_to, room, priority, transparent, owner, workflow_buttons, description, id, created, modified, state
- cal.Events.insert : summary, start_date, start_time, end_date, end_time, event_type, project
- cal.GuestRoles.detail : ref, name, name_fr, name_en, id
- cal.GuestRoles.merge_row : merge_to, reason
- cal.GuestStates.wf1 : notify_subject, notify_body, notify_silent
- cal.GuestStates.wf2 : notify_subject, notify_body, notify_silent
- cal.Guests.checkin : notify_subject, notify_body, notify_silent
- cal.Guests.detail : event, client, role, state, remark, workflow_buttons, waiting_since, busy_since, gone_since
- cal.Guests.insert : event, partner, role
- cal.RecurrentEvents.detail : name, name_fr, name_en, id, user, event_type, start_date, start_time, end_date, end_time, every_unit, every, positions, max_events, monday, tuesday, wednesday, thursday, friday, saturday, sunday, description
- cal.RecurrentEvents.insert : name, name_fr, name_en, start_date, end_date, every_unit, event_type
- cal.Rooms.detail : id, name, name_fr, name_en, company, contact_person, display_color, description
- cal.Rooms.insert : id, name, name_fr, name_en, display_color, company, contact_person
- cal.Tasks.detail : start_date, due_date, id, workflow_buttons, summary, project, user, delegated, owner, created, modified, description
- cal.Tasks.insert : summary, user, project
- cal.TasksByController.insert : summary, start_date, due_date, user, delegated
- cbss.IdentifyPersonRequests.detail : id, person, user, sent, status, printed, national_id, first_name, middle_name, last_name, birth_date, tolerance, gender, environment, ticket, info_messages, debug_messages
- cbss.IdentifyPersonRequests.insert : person, national_id, first_name, middle_name, last_name, birth_date, tolerance, gender
- cbss.ManageAccessRequests.detail : id, person, user, sent, status, printed, action, start_date, end_date, purpose, query_register, national_id, sis_card_no, id_card_no, first_name, last_name, birth_date, result, environment, ticket, info_messages, debug_messages
- cbss.ManageAccessRequests.insert : person, action, start_date, end_date, purpose, query_register, national_id, sis_card_no, id_card_no, first_name, last_name, birth_date
- cbss.RetrieveTIGroupsRequests.detail : id, person, user, sent, status, printed, national_id, language, history, environment, ticket, info_messages, debug_messages
- cbss.RetrieveTIGroupsRequests.insert : person, national_id, language, history
- changes.Changes.detail : time, user, type, master, object, id, diff
- checkdata.Checkers.detail : value, text
- checkdata.Messages.detail : checker, owner, message, user, id
- clients.ClientContactTypes.detail : id, name, name_fr, name_en, can_refund, is_bailiff
- coachings.CoachingEndings.detail : id, name, name_fr, name_en, seqno
- coachings.Coachings.create_visit : user, summary, waiting_number
- contacts.Companies.detail : overview, prefix, name, type, vat_id, url, client_contact_type, email, phone, gsm, fax, contacts.RolesByCompany, remarks, notes.NotesByCompany, vatless.VouchersByPartner, accounting.MovementsByPartner, id, language, activity, is_obsolete, created, modified
- contacts.Companies.insert : name, email, type
- contacts.Companies.merge_row : merge_to, addresses_Address, sepa_Account, reason
- contacts.Partners.detail : overview, id, language, activity, client_contact_type, url, email, phone, gsm, fax, country, region, city, zip_code, addr1, street_prefix, street, street_no, street_box, addr2, remarks, vatless.VouchersByPartner, accounting.MovementsByPartner, is_obsolete, created, modified
- contacts.Partners.merge_row : merge_to, addresses_Address, sepa_Account, reason
- contacts.Persons.create_household : head, type, partner
- contacts.Persons.detail : overview, title, first_name, middle_name, last_name, gender, birth_date, age, id, language, email, phone, gsm, fax, contacts.RolesByPerson, households.MembersByPerson, humanlinks.LinksByHuman, remarks, vatless.VouchersByPartner, accounting.MovementsByPartner, activity, url, client_contact_type, is_obsolete, created, modified
- contacts.Persons.insert : first_name, last_name, gender, email
- contacts.Persons.merge_row : merge_to, addresses_Address, sepa_Account, reason
- contacts.RolesByCompany.insert : person, type
- contacts.RolesByPerson.insert : type, company
- countries.Countries.detail : isocode, name, name_fr, name_en, short_code, inscode, actual_country
- countries.Countries.insert : isocode, inscode, name, name_fr, name_en
- countries.Places.detail : name, name_fr, name_en, country, inscode, zip_code, parent, type, id
- countries.Places.insert : name, name_fr, name_en, country, zip_code, type, parent
- cv.Durations.detail : id, name, name_fr, name_en
- cv.EducationLevels.detail : name, name_fr, name_en, is_study, is_training
- cv.Experiences.detail : person, company, country, city, sector, function, title, status, duration, regime, is_training, start_date, end_date, duration_text, termination_reason, remarks
- cv.ExperiencesByPerson.insert : start_date, end_date, company, function
- cv.Functions.detail : id, name, name_fr, name_en, sector, remark
- cv.LanguageKnowledgesByPerson.detail : language, native, has_certificate, cef_level, spoken_passively, spoken, written
- cv.LanguageKnowledgesByPerson.insert : language, native, has_certificate, cef_level, spoken_passively, spoken, written
- cv.Regimes.detail : id, name, name_fr, name_en
- cv.Sectors.detail : id, name, name_fr, name_en, remark
- cv.Statuses.detail : id, name, name_fr, name_en
- cv.Studies.detail : person, start_date, end_date, duration_text, type, content, education_level, state, school, country, city, remarks
- cv.StudiesByPerson.insert : start_date, end_date, type, content
- cv.StudyTypes.detail : name, name_fr, name_en, id, education_level, is_study, is_training
- cv.StudyTypes.insert : name, name_fr, name_en, is_study, is_training, education_level
- cv.Trainings.detail : person, start_date, end_date, duration_text, type, state, certificates, sector, function, school, country, city, remarks
- cv.Trainings.insert : person, start_date, end_date, type, state, certificates, sector, function, school, country, city
- debts.Accounts.detail : ref, name, name_fr, name_en, group, type, required_for_household, required_for_person, periods, default_amount
- debts.Accounts.insert : ref, group, type, name, name_fr, name_en
- debts.Accounts.merge_row : merge_to, reason
- debts.Budgets.detail : date, partner, id, user, intro, ResultByBudget, DebtsByBudget, AssetsByBudgetSummary, conclusion, dist_amount, printed, total_debt, include_yearly_incomes, print_empty_rows, print_todos, DistByBudget, data_box, summary_box
- debts.Budgets.insert : partner, date, user
- debts.Groups.detail : ref, name, name_fr, name_en, id, account_type, entries_layout
- debts.Groups.insert : name, name_fr, name_en, account_type, ref
- esf.Summaries.detail : master, year, children_at_charge, certified_handicap, other_difficulty, user_modified, education_level, result, remark, id, results
- excerpts.ExcerptTypes.detail : id, name, name_fr, name_en, content_type, build_method, template, body_template, email_template, shortcut, primary, print_directly, certifying, print_recipient, backward_compat, attach_to_email
- excerpts.ExcerptTypes.insert : name, name_fr, name_en, content_type, primary, certifying, build_method, template, body_template
- excerpts.Excerpts.detail : id, excerpt_type, project, user, build_method, company, contact_person, language, owner, build_time, body_template_content
- finan.BankStatements.detail : entry_date, number, balance1, balance2, narration, workflow_buttons, uploads.UploadsByController, journal, accounting_period, user, id, item_account, item_remark, accounting.MovementsByVoucher
- finan.BankStatements.insert : entry_date, balance1
- finan.DisbursementOrders.detail : journal, number, voucher_date, entry_date, accounting_period, item_account, total, workflow_buttons, narration, item_remark, state, user, id, accounting.MovementsByVoucher
- finan.DisbursementOrdersByJournal.insert : item_account, voucher_date
- finan.FinancialVouchers.detail : entry_date, number, workflow_buttons, narration, journal, accounting_period, user, id, item_account, item_remark, accounting.MovementsByVoucher
- finan.FinancialVouchers.insert : entry_date, narration
- finan.PaymentOrders.detail : entry_date, number, total, execution_date, workflow_buttons, narration, journal, accounting_period, user, id, item_account, item_remark, accounting.MovementsByVoucher
- gfks.ContentTypes.detail : id, app_label, model, base_classes
- households.Households.detail : type, prefix, name, id, overview, language, email, phone, gsm
- households.Households.insert : name, type
- households.Households.merge_row : merge_to, households_Member, addresses_Address, sepa_Account, reason
- households.HouseholdsByType.detail : type, prefix, name, id, overview, language, email, phone, gsm
- households.HouseholdsByType.insert : name, language
- households.MembersByPerson.insert : person, role, household, primary
- households.Types.detail : name, name_fr, name_en
- humanlinks.Links.detail : parent, type, child
- humanlinks.Links.insert : parent, type, child
- isip.ContractEndings.detail : name, use_in_isip, use_in_jobs, is_success, needs_date_ended
- isip.ContractPartners.detail : company, contact_person, contact_role, duties_company
- isip.ContractPartners.insert : company, contact_person, contact_role
- isip.ContractTypes.detail : id, ref, exam_policy, overlap_group, needs_study_type, name, name_fr, name_en, full_name
- isip.Contracts.detail : id, client, type, user, user_dsbe, user_asd, study_type, applies_from, applies_until, exam_policy, language, date_decided, date_issued, printed, date_ended, ending, stages, goals, duties_person, duties_asd, duties_dsbe, duties_pcsw
- isip.Contracts.insert : client, type
- isip.ExamPolicies.detail : id, name, name_fr, name_en, max_events, every, every_unit, event_type, monday, tuesday, wednesday, thursday, friday, saturday, sunday
- jobs.ContractTypes.detail : id, name, name_fr, name_en, ref, overlap_group
- jobs.ContractTypes.merge_row : merge_to, reason
- jobs.Contracts.detail : id, client, user, user_asd, language, job, type, company, contact_person, contact_role, applies_from, duration, applies_until, exam_policy, regime, schedule, hourly_rate, refund_rate, reference_person, remark, printed, date_decided, date_issued, date_ended, ending, responsibilities
- jobs.Contracts.insert : client, job
- jobs.JobProviders.detail : overview, prefix, name, type, vat_id, client_contact_type, is_social, url, email, phone, gsm, fax, contacts.RolesByCompany, uploads.UploadsByController, notes.NotesByCompany
- jobs.JobProviders.merge_row : merge_to, addresses_Address, sepa_Account, reason
- jobs.JobTypes.detail : id, name, is_social
- jobs.Jobs.detail : name, provider, contract_type, type, id, sector, function, capacity, hourly_rate, remark
- jobs.Jobs.insert : name, provider, contract_type, type, sector, function
- jobs.JobsOverview.show : body
- jobs.Offers.detail : name, provider, sector, function, selection_from, selection_until, start_date, remark
- jobs.Schedules.detail : id, name, name_fr, name_en
- languages.Languages.detail : id, iso2, name, name_fr, name_en
- linod.SystemTasks.detail : seqno, procedure, name, every, every_unit, log_level, disabled, status, requested_at, last_start_time, last_end_time, message
- linod.SystemTasks.insert : procedure, every, every_unit
- newcomers.AvailableCoachesByClient.assign_coach : notify_subject, notify_body, notify_silent
- newcomers.Faculties.detail : id, name, name_fr, name_en, weight
- newcomers.Faculties.insert : name, name_fr, name_en, weight
- notes.EventTypes.detail : id, name, name_fr, name_en, remark
- notes.NoteTypes.detail : id, name, name_fr, name_en, build_method, template, special_type, email_template, attach_to_email, remark
- notes.NoteTypes.insert : name, name_fr, name_en, build_method
- notes.Notes.detail : date, time, event_type, type, project, subject, important, company, contact_person, user, language, build_time, id, body, uploads.UploadsByController
- notes.Notes.insert : event_type, type, subject, project
- notes.NotesByProject.insert : event_type, type, subject, project
- outbox.Mails.detail : subject, project, date, user, sent, id, owner, outbox.RecipientsByMail, outbox.AttachmentsByMail, uploads.UploadsByController, body
- outbox.Mails.insert : project, subject, body
- outbox.RecipientsByMail.insert : partner, name, address
- pcsw.Clients.create_visit : user, summary, waiting_number
- pcsw.Clients.detail : overview, gender, id, tim_id, first_name, middle_name, last_name, birth_date, age, national_id, nationality, declared_name, civil_state, birth_country, birth_place, language, email, phone, fax, gsm, image, reception.AgentsByClient, dupable_clients.SimilarClients, humanlinks.LinksByHuman, cbss_relations, households.MembersByPerson, workflow_buttons, id_document, broker, faculty, refusal_reason, in_belgium_since, residence_type, gesdos_id, job_agents, group, income_ag, income_wg, income_kg, income_rente, income_misc, seeking_since, unemployed_since, work_permit_suspended_until, needs_residence_permit, needs_work_permit, uploads.UploadsByProject, cvs_emitted, cv.LanguageKnowledgesByPerson, skills, obstacles, notes.NotesByProject, excerpts.ExcerptsByProject, accounting.MovementsByProject, activity, client_state, noble_condition, unavailable_until, unavailable_why, is_cpas, is_senior, is_obsolete, created, modified, remarks, remarks2, checkdata.MessagesByOwner, contacts.RolesByPerson, cbss_identify_person, cbss_manage_access, cbss_retrieve_ti_groups, cbss_summary
- pcsw.Clients.insert : first_name, last_name, national_id, gender, language
- pcsw.Clients.merge_row : merge_to, aids_IncomeConfirmation, aids_RefundConfirmation, aids_SimpleConfirmation, coachings_Coaching, cv_LanguageKnowledge, cv_PersonProperty, dupable_clients_Word, esf_ClientSummary, pcsw_Dispense, addresses_Address, sepa_Account, reason
- pcsw.Clients.refuse_client : reason, remark
- periods.StoredPeriods.merge_row : merge_to, reason
- periods.StoredYears.merge_row : merge_to, reason
- properties.PropGroups.detail : id, name, name_fr, name_en
- properties.PropTypes.detail : id, name, name_fr, name_en, choicelist, default_value
- properties.Properties.detail : id, group, type, name, name_fr, name_en
- sepa.AccountsByPartner.insert : iban, bic, remark, primary
- system.SiteConfigs.detail : site_company, job_office, master_budget, signer1, signer2, signer1_function, signer2_function, system_note_type, default_build_method, residence_permit_upload_type, work_permit_upload_type, driving_licence_upload_type, default_event_type, prompt_calendar, hide_events_before, client_guestrole, team_guestrole, cbss_org_unit, sector, ssdn_user_id, ssdn_email, cbss_http_username, cbss_http_password
- tinymce.TextFieldTemplates.detail : id, name, user, description, text
- tinymce.TextFieldTemplates.insert : name, user
- uploads.AllUploads.detail : user, project, id, type, description, start_date, end_date, needed, company, contact_person, contact_role, file, owner, remark
- uploads.AllUploads.insert : type, description, file, volume, library_file, user
- uploads.UploadTypes.detail : id, upload_area, shortcut, name, name_fr, name_en, warn_expiry_unit, warn_expiry_value, wanted, max_number
- uploads.UploadTypes.insert : upload_area, name, name_fr, name_en, warn_expiry_unit, warn_expiry_value
- uploads.Uploads.camera_stream : type, description
- uploads.Uploads.detail : user, project, id, type, description, start_date, end_date, needed, company, contact_person, contact_role, file, owner, remark
- uploads.Uploads.insert : file, type, project, start_date, end_date, needed, description
- uploads.UploadsByController.insert : file, type, end_date, needed, description
- uploads.UploadsByVolume.detail : user, project, id, type, description, start_date, end_date, needed, company, contact_person, contact_role, file, owner, remark
- uploads.UploadsByVolume.insert : type, description, file, volume, library_file, user
- uploads.Volumes.detail : ref, root_dir, description, overview
- uploads.Volumes.insert : ref, root_dir, description
- uploads.Volumes.merge_row : merge_to, reason
- users.AllUsers.change_password : current, new1, new2
- users.AllUsers.detail : username, user_type, partner, first_name, last_name, initials, email, language, mail_mode, notify_myself, id, created, modified, remarks, event_type, calendar, newcomer_quota, coaching_type, coaching_supervisor, newcomer_consultations, newcomer_appointments
- users.AllUsers.insert : username, email, first_name, last_name, partner, language, user_type
- users.AllUsers.merge_row : merge_to, cal_Subscription, reason
- users.AllUsers.verify_me : verification_code
- vatless.Invoices.detail : journal, number, entry_date, voucher_date, accounting_period, workflow_buttons, partner, payment_term, due_date, bank_account, your_ref, narration, amount, match, state, user, id, accounting.MovementsByVoucher
- vatless.Invoices.insert : journal, partner, entry_date
- vatless.InvoicesByJournal.insert : partner, entry_date
- vatless.ProjectInvoicesByJournal.detail : journal, number, entry_date, voucher_date, accounting_period, workflow_buttons, project, narration, partner, your_ref, payment_term, due_date, bank_account, amount, match, state, user, id, accounting.MovementsByVoucher
- vatless.ProjectInvoicesByJournal.insert : project, partner, entry_date
- vatless.VouchersByPartner.detail : journal, number, entry_date, accounting_period, accounting.MovementsByVoucher
- xcourses.CourseContents.detail : id, name
- xcourses.CourseOffers.detail : id, title, content, provider, guest_role, description
- xcourses.CourseOffers.insert : provider, content, title
- xcourses.CourseProviders.detail : overview, prefix, name, type, vat_id, url, client_contact_type, email, phone, gsm, fax, contacts.RolesByCompany, notes.NotesByCompany
- xcourses.CourseProviders.merge_row : merge_to, addresses_Address, sepa_Account, reason
- xcourses.CourseRequests.detail : date_submitted, person, content, offer, urgent, course, state, date_ended, id, remark, uploads.UploadsByController
- xcourses.Courses.detail : id, start_date, offer, title, remark
- xcourses.Courses.insert : start_date, offer, title

TODO: explain why the following items were no longer shown in above list after 20190107:

  • integ.ActivityReport.show : body

  • accounting.Situation.show : body

Windows and permissions

Each window layout is viewable by a given set of user types.

>>> print(analyzer.show_window_permissions())
...
- about.About.insert_reference : visible for all
- about.About.reset_password : visible for all
- about.About.show : visible for all
- about.About.sign_in : visible for all
- about.About.verify_user : visible for all
- accounting.Accounts.detail : visible for 510 admin 910
- accounting.Accounts.insert : visible for 510 admin 910
- accounting.Accounts.merge_row : visible for admin 910
- accounting.AllVouchers.detail : visible for 510 admin 910
- accounting.Journals.detail : visible for 510 admin 910
- accounting.Journals.insert : visible for 510 admin 910
- accounting.Journals.merge_row : visible for admin 910
- accounting.PaymentTerms.detail : visible for 510 admin 910
- accounting.PaymentTerms.merge_row : visible for admin 910
- addresses.Addresses.detail : visible for admin 910
- addresses.Addresses.insert : visible for admin 910
- aids.AidTypes.detail : visible for 110 120 130 210 410 420 430 500 510 800 admin 910
- aids.AidTypes.insert : visible for 110 120 130 210 410 420 430 500 510 800 admin 910
- aids.Categories.detail : visible for 110 120 130 210 410 420 430 500 510 800 admin 910
- aids.Grantings.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.Grantings.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.GrantingsByClient.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.IncomeConfirmations.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.IncomeConfirmationsByGranting.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.RefundConfirmations.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.RefundConfirmationsByGranting.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.SimpleConfirmations.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- aids.SimpleConfirmationsByGranting.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- art61.Activations.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- art61.ActivationsByClient.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- art61.ContractTypes.detail : visible for 110 120 420 admin 910
- art61.ContractTypes.merge_row : visible for admin 910
- art61.Contracts.detail : visible for 100 110 120 130 420 admin 910
- art61.Contracts.insert : visible for 100 110 120 130 420 admin 910
- b2c.Accounts.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- b2c.Statements.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- b2c.Transactions.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- boards.Boards.detail : visible for admin 910
- boards.Boards.insert : visible for admin 910
- cal.Calendars.detail : visible for 110 120 410 420 admin 910
- cal.Calendars.insert : visible for 110 120 410 420 admin 910
- cal.EntriesByClient.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- cal.EntriesByGuest.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- cal.EntriesByProject.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- cal.EventTypes.detail : visible for 110 120 410 420 admin 910
- cal.EventTypes.insert : visible for 110 120 410 420 admin 910
- cal.EventTypes.merge_row : visible for admin 910
- cal.Events.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 admin 910
- cal.Events.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 admin 910
- cal.GuestRoles.detail : visible for admin 910
- cal.GuestRoles.merge_row : visible for admin 910
- cal.GuestStates.wf1 : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- cal.GuestStates.wf2 : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- cal.Guests.checkin : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- cal.Guests.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- cal.Guests.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- cal.RecurrentEvents.detail : visible for 110 120 410 420 admin 910
- cal.RecurrentEvents.insert : visible for 110 120 410 420 admin 910
- cal.Rooms.detail : visible for 110 120 410 420 admin 910
- cal.Rooms.insert : visible for 110 120 410 420 admin 910
- cal.Tasks.detail : visible for 110 120 410 420 admin 910
- cal.Tasks.insert : visible for 110 120 410 420 admin 910
- cal.TasksByController.insert : visible for 100 110 120 130 200 300 400 410 420 430 500 510 admin 910
- cbss.IdentifyPersonRequests.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- cbss.IdentifyPersonRequests.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- cbss.ManageAccessRequests.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- cbss.ManageAccessRequests.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- cbss.RetrieveTIGroupsRequests.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- cbss.RetrieveTIGroupsRequests.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 admin 910
- changes.Changes.detail : visible for admin 910
- checkdata.Checkers.detail : visible for admin 910
- checkdata.Messages.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- clients.ClientContactTypes.detail : visible for 110 120 130 210 410 420 430 800 admin 910
- coachings.CoachingEndings.detail : visible for 110 120 130 210 410 420 430 admin 910
- coachings.Coachings.create_visit : visible for 110 120 130 210 410 420 430 admin 910
- contacts.Companies.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Companies.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Companies.merge_row : visible for admin 910
- contacts.Partners.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Partners.merge_row : visible for admin 910
- contacts.Persons.create_household : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Persons.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Persons.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.Persons.merge_row : visible for admin 910
- contacts.RolesByCompany.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- contacts.RolesByPerson.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- countries.Countries.detail : visible for 110 120 130 210 410 420 430 800 admin 910
- countries.Countries.insert : visible for 110 120 130 210 410 420 430 800 admin 910
- countries.Places.detail : visible for 110 120 130 210 410 420 430 800 admin 910
- countries.Places.insert : visible for 110 120 130 210 410 420 430 800 admin 910
- cv.Durations.detail : visible for 110 120 420 admin 910
- cv.EducationLevels.detail : visible for 110 120 420 admin 910
- cv.Experiences.detail : visible for 110 120 420 admin 910
- cv.ExperiencesByPerson.insert : visible for 100 110 120 130 420 admin 910
- cv.Functions.detail : visible for 110 120 420 admin 910
- cv.LanguageKnowledgesByPerson.detail : visible for 100 110 120 130 420 admin 910
- cv.LanguageKnowledgesByPerson.insert : visible for 100 110 120 130 420 admin 910
- cv.Regimes.detail : visible for 110 120 420 admin 910
- cv.Sectors.detail : visible for 110 120 420 admin 910
- cv.Statuses.detail : visible for 110 120 420 admin 910
- cv.Studies.detail : visible for 110 120 420 admin 910
- cv.StudiesByPerson.insert : visible for 100 110 120 130 420 admin 910
- cv.StudyTypes.detail : visible for 110 120 420 admin 910
- cv.StudyTypes.insert : visible for 110 120 420 admin 910
- cv.Trainings.detail : visible for 100 110 120 130 420 admin 910
- cv.Trainings.insert : visible for 100 110 120 130 420 admin 910
- debts.Accounts.detail : visible for admin 910
- debts.Accounts.insert : visible for admin 910
- debts.Accounts.merge_row : visible for admin 910
- debts.Budgets.detail : visible for admin 910
- debts.Budgets.insert : visible for admin 910
- debts.Groups.detail : visible for admin 910
- debts.Groups.insert : visible for admin 910
- esf.Summaries.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- excerpts.ExcerptTypes.detail : visible for admin 910
- excerpts.ExcerptTypes.insert : visible for admin 910
- excerpts.Excerpts.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- finan.BankStatements.detail : visible for 500 510 admin 910
- finan.BankStatements.insert : visible for 500 510 admin 910
- finan.DisbursementOrders.detail : visible for 500 510 admin 910
- finan.DisbursementOrdersByJournal.insert : visible for 500 510 admin 910
- finan.FinancialVouchers.detail : visible for 500 510 admin 910
- finan.FinancialVouchers.insert : visible for 500 510 admin 910
- finan.PaymentOrders.detail : visible for 500 510 admin 910
- gfks.ContentTypes.detail : visible for admin 910
- households.Households.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- households.Households.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- households.Households.merge_row : visible for admin 910
- households.HouseholdsByType.detail : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- households.HouseholdsByType.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- households.MembersByPerson.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- households.Types.detail : visible for 110 120 130 210 410 420 430 800 admin 910
- humanlinks.Links.detail : visible for 110 120 130 210 410 420 430 800 admin 910
- humanlinks.Links.insert : visible for 110 120 130 210 410 420 430 800 admin 910
- isip.ContractEndings.detail : visible for 110 120 410 420 admin 910
- isip.ContractPartners.detail : visible for 110 120 410 420 admin 910
- isip.ContractPartners.insert : visible for 110 120 410 420 admin 910
- isip.ContractTypes.detail : visible for 110 120 410 420 admin 910
- isip.Contracts.detail : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- isip.Contracts.insert : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- isip.ExamPolicies.detail : visible for 110 120 410 420 admin 910
- jobs.ContractTypes.detail : visible for 110 120 410 420 admin 910
- jobs.ContractTypes.merge_row : visible for admin 910
- jobs.Contracts.detail : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- jobs.Contracts.insert : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- jobs.JobProviders.detail : visible for 100 110 120 130 420 admin 910
- jobs.JobProviders.merge_row : visible for admin 910
- jobs.JobTypes.detail : visible for 110 120 410 420 admin 910
- jobs.Jobs.detail : visible for 100 110 120 130 420 admin 910
- jobs.Jobs.insert : visible for 100 110 120 130 420 admin 910
- jobs.JobsOverview.show : visible for 100 110 120 130 420 admin 910
- jobs.Offers.detail : visible for 100 110 120 130 420 admin 910
- jobs.Schedules.detail : visible for 110 120 410 420 admin 910
- languages.Languages.detail : visible for 110 120 410 420 admin 910
- linod.SystemTasks.detail : visible for admin 910
- linod.SystemTasks.insert : visible for admin 910
- newcomers.AvailableCoachesByClient.assign_coach : visible for 110 120 200 220 300 420 800 admin 910
- newcomers.Faculties.detail : visible for 110 120 410 420 admin 910
- newcomers.Faculties.insert : visible for 110 120 410 420 admin 910
- notes.EventTypes.detail : visible for 110 120 410 420 admin 910
- notes.NoteTypes.detail : visible for 110 120 410 420 admin 910
- notes.NoteTypes.insert : visible for 110 120 410 420 admin 910
- notes.Notes.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- notes.Notes.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- notes.NotesByProject.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- outbox.Mails.detail : visible for 110 120 410 420 admin 910
- outbox.Mails.insert : visible for 110 120 410 420 admin 910
- outbox.RecipientsByMail.insert : visible for 100 110 120 130 200 300 400 410 420 430 500 510 admin 910
- pcsw.Clients.create_visit : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- pcsw.Clients.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- pcsw.Clients.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- pcsw.Clients.merge_row : visible for admin 910
- pcsw.Clients.refuse_client : visible for 120 200 220 300 420 admin 910
- periods.StoredPeriods.merge_row : visible for admin 910
- periods.StoredYears.merge_row : visible for admin 910
- properties.PropGroups.detail : visible for admin 910
- properties.PropTypes.detail : visible for admin 910
- properties.Properties.detail : visible for admin 910
- sepa.AccountsByPartner.insert : visible for 100 110 120 130 200 210 300 400 410 420 430 500 510 800 admin 910
- system.SiteConfigs.detail : visible for admin 910
- tinymce.TextFieldTemplates.detail : visible for admin 910
- tinymce.TextFieldTemplates.insert : visible for admin 910
- uploads.AllUploads.detail : visible for 110 120 410 420 admin 910
- uploads.AllUploads.insert : visible for 110 120 410 420 admin 910
- uploads.UploadTypes.detail : visible for 110 120 410 420 admin 910
- uploads.UploadTypes.insert : visible for 110 120 410 420 admin 910
- uploads.Uploads.camera_stream : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.Uploads.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.Uploads.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.UploadsByController.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.UploadsByVolume.detail : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.UploadsByVolume.insert : visible for 100 110 120 130 200 210 220 300 400 410 420 430 500 510 800 admin 910
- uploads.Volumes.detail : visible for 110 120 410 420 admin 910
- uploads.Volumes.insert : visible for 110 120 410 420 admin 910
- uploads.Volumes.merge_row : visible for admin 910
- users.AllUsers.change_password : visible for admin 910
- users.AllUsers.detail : visible for admin 910
- users.AllUsers.insert : visible for admin 910
- users.AllUsers.merge_row : visible for admin 910
- users.AllUsers.verify_me : visible for admin 910
- vatless.Invoices.detail : visible for 500 510 admin 910
- vatless.Invoices.insert : visible for 500 510 admin 910
- vatless.InvoicesByJournal.insert : visible for 500 510 admin 910
- vatless.ProjectInvoicesByJournal.detail : visible for 500 510 admin 910
- vatless.ProjectInvoicesByJournal.insert : visible for 500 510 admin 910
- vatless.VouchersByPartner.detail : visible for 500 510 admin 910
- xcourses.CourseContents.detail : visible for 110 120 420 admin 910
- xcourses.CourseOffers.detail : visible for 100 110 120 130 420 admin 910
- xcourses.CourseOffers.insert : visible for 100 110 120 130 420 admin 910
- xcourses.CourseProviders.detail : visible for 100 110 120 130 420 admin 910
- xcourses.CourseProviders.merge_row : visible for admin 910
- xcourses.CourseRequests.detail : visible for 110 120 420 admin 910
- xcourses.Courses.detail : visible for 110 120 420 admin 910
- xcourses.Courses.insert : visible for 110 120 420 admin 910

Visibility of eID reader actions

Here is a list of the eid card reader actions and their availability per user user_type.

>>> from lino_xl.lib.beid.actions import BaseBeIdReadCardAction
>>> print(analyzer.show_action_permissions(BaseBeIdReadCardAction))
...
- debts.Clients.find_by_beid : visible for 120 300 420 admin 910
- debts.Clients.read_beid : visible for 120 300 420 admin 910
- integ.Clients.find_by_beid : visible for 100 110 120 130 420 admin 910
- integ.Clients.read_beid : visible for 100 110 120 130 420 admin 910
- newcomers.ClientsByFaculty.find_by_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- newcomers.ClientsByFaculty.read_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- newcomers.NewClients.find_by_beid : visible for 120 200 220 300 420 admin 910
- newcomers.NewClients.read_beid : visible for 120 200 220 300 420 admin 910
- pcsw.AllClients.find_by_beid : visible for 110 120 410 420 admin 910
- pcsw.AllClients.read_beid : visible for 110 120 410 420 admin 910
- pcsw.Clients.find_by_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- pcsw.Clients.read_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- pcsw.ClientsByNationality.find_by_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- pcsw.ClientsByNationality.read_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- pcsw.CoachedClients.find_by_beid : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- pcsw.CoachedClients.read_beid : visible for 100 110 120 130 200 300 400 410 420 430 admin 910
- reception.Clients.find_by_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910
- reception.Clients.read_beid : visible for 100 110 120 130 200 210 220 300 400 410 420 430 800 admin 910

Dialog actions

Global list of all actions that have a parameter dialog.

>>> analyzer.show_dialog_actions()
...
- about.About.insert_reference : Insert reference
  (main) [visible for all]: **Datenbankmodell** (content_type), **primary key** (primary_key)
- about.About.reset_password : Reset password
  (main) [visible for all]: **E-Mail-Adresse** (email), **Username (optional)** (username), **Neues Passwort** (new1), **Neues Passwort nochmal** (new2)
- about.About.sign_in : Anmelden
  (main) [visible for all]:
  - (login_panel): **Benutzername** (username), **Passwort** (password)
- about.About.verify_user : Verify
  (main) [visible for all]: **E-Mail-Adresse** (email), **Verification code** (verification_code)
- accounting.Accounts.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- accounting.Journals.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begleichungsregeln** (accounting_MatchRule), **Begründung** (reason)
- accounting.PaymentTerms.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- art61.ContractTypes.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- cal.EventTypes.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- cal.GuestRoles.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- cal.GuestStates.wf1 : Zusagen
  (main) [visible for all]: **Kurzbeschreibung** (notify_subject), **Beschreibung** (notify_body), **Keine Mitteilung an andere** (notify_silent)
- cal.GuestStates.wf2 : Absagen
  (main) [visible for all]: **Kurzbeschreibung** (notify_subject), **Beschreibung** (notify_body), **Keine Mitteilung an andere** (notify_silent)
- cal.Guests.checkin : Einchecken
  (main) [visible for all]: **Kurzbeschreibung** (notify_subject), **Beschreibung** (notify_body), **Keine Mitteilung an andere** (notify_silent)
- coachings.Coachings.create_visit : Visite erstellen
  (main) [visible for all]: **Benutzer** (user), **Begründung** (summary), **Wartenummer** (waiting_number)
- contacts.Companies.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles): **Adressen** (addresses_Address), **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- contacts.Partners.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles): **Adressen** (addresses_Address), **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- contacts.Persons.create_household : Haushalt erstellen
  (main) [visible for all]: **Vorstand** (head), **Haushaltsart** (type), **Partner** (partner)
- contacts.Persons.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles): **Adressen** (addresses_Address), **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- debts.Accounts.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- households.Households.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles):
    - (keep_volatiles_1): **Mitglieder** (households_Member), **Adressen** (addresses_Address)
    - **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- jobs.ContractTypes.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- jobs.JobProviders.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles): **Adressen** (addresses_Address), **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- newcomers.AvailableCoachesByClient.assign_coach : Zuweisen
  (main) [visible for all]: **Kurzbeschreibung** (notify_subject), **Beschreibung** (notify_body), **Keine Mitteilung an andere** (notify_silent)
- pcsw.Clients.create_visit : Visite erstellen
  (main) [visible for all]: **Benutzer** (user), **Begründung** (summary), **Wartenummer** (waiting_number)
- pcsw.Clients.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles):
    - (keep_volatiles_1): **Einkommensbescheinigungen** (aids_IncomeConfirmation), **Kostenübernahmescheine** (aids_RefundConfirmation)
    - (keep_volatiles_2): **Einfache Bescheinigungen** (aids_SimpleConfirmation), **Begleitungen** (coachings_Coaching)
    - (keep_volatiles_3): **Sprachkenntnisse** (cv_LanguageKnowledge), **Eigenschaften** (cv_PersonProperty)
    - (keep_volatiles_4): **Phonetische Wörter** (dupable_clients_Word), **ESF Summaries** (esf_ClientSummary)
    - (keep_volatiles_5): **Dispenzen** (pcsw_Dispense), **Adressen** (addresses_Address)
    - **Bankkonten** (sepa_Account)
  - **Begründung** (reason)
- pcsw.Clients.refuse_client : Ablehnen
  (main) [visible for all]: **Ablehnungsgrund** (reason), **Bemerkung** (remark)
- periods.StoredPeriods.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- periods.StoredYears.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- uploads.Uploads.camera_stream : Camera
  (main) [visible for all]: **Upload-Art** (type), **Beschreibung** (description)
- uploads.Volumes.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Begründung** (reason)
- users.AllUsers.change_password : Passwort ändern
  (main) [visible for all]: **Aktuelles Passwort** (current), **Neues Passwort** (new1), **Neues Passwort nochmal** (new2)
- users.AllUsers.merge_row : Fusionieren
  (main) [visible for all]: **nach...** (merge_to), **Abonnements** (cal_Subscription), **Begründung** (reason)
- users.AllUsers.verify_me : Verify
  (main) [visible for all]: **Verification code** (verification_code)
- xcourses.CourseProviders.merge_row : Fusionieren
  (main) [visible for all]:
  - **nach...** (merge_to)
  - **Auch vergängliche verknüpfte Objekte überweisen** (keep_volatiles): **Adressen** (addresses_Address), **Bankkonten** (sepa_Account)
  - **Begründung** (reason)

The murderer bug

Before 20150623 it was possible to inadvertently cause a cascaded delete by calling delete() on an object in a script. For example the following line would have deleted client 127 and all related data instead of raising an exception:

>>> pcsw.Client.objects.get(id=28).delete()
Traceback (most recent call last):
...
Warning: Kann Partner Evers Eberhart nicht löschen weil 48 Bewegungen darauf verweisen.

Some requests

Some choices lists:

>>> kw = dict()
>>> fields = 'count rows'
>>> demo_get('rolf', 'choices/cv/SkillsByPerson/property?mk=28', fields, 6, **kw)
>>> demo_get('rolf', 'choices/cv/ObstaclesByPerson/property?mk=28', fields, 15, **kw)

Learnable combo fields

The feature #3419 (contacts.Role.person is now a learning foreign key) was originally disabled in weleup because the site operator doesn’t like unrequested changes. But since 20221017 the feature is limited to users having the Expert role.

>>> obj = contacts.Role.objects.get(pk=1)
>>> ses = rt.login("hubert")
>>> pprint(obj.create_person_choice("Joe Smith", ses))
Traceback (most recent call last):
...
django.core.exceptions.ValidationError: ["Cannot create new Person from 'Joe Smith' (You are not an expert)"]
>>> ses = rt.login("robin")
>>> pprint(obj.create_person_choice("Joe Smith", ses, save=False))
Person(name='Smith Joe',first_name='Joe',last_name='Smith')

mytasks_start_date

The gerd demo project sets lino_xl.lib.cal.Plugin.mytasks_start_date to -30, which means that users don’t see tasks that are older than 30 days.

>>> dd.plugins.cal.mytasks_start_date
-30
>>> dd.plugins.cal.mytasks_end_date
30

Remote virtual fields

Here is a list of all remote virtual fields that are being used in a detail window.

>>> for a, sf in walk_store_fields(only_detail_fields=True):
...     if "__" in sf.name:
...         print(a, sf, sf.field)
b2c.Statements StoreField 'account__owner_name' b2c.Account.owner_name
b2c.Statements StoreField 'account__account_name' b2c.Account.account_name
b2c.StatementsByAccount StoreField 'account__owner_name' b2c.Account.owner_name
b2c.StatementsByAccount StoreField 'account__account_name' b2c.Account.account_name
>>> show_change_watchers()
+------------------------------+------------------------------+------------------------------------------+
| model                        | master_key                   | ignored_fields                           |
+==============================+==============================+==========================================+
| art61.Contract               | client__partner_ptr          | printed_by                               |
+------------------------------+------------------------------+------------------------------------------+
| cbss.IdentifyPersonRequest   | person__partner_ptr          | debug_messages environment info_messages |
|                              |                              | printed_by request_xml response_xml sent |
|                              |                              | status ticket                            |
+------------------------------+------------------------------+------------------------------------------+
| cbss.ManageAccessRequest     | person__partner_ptr          | debug_messages environment info_messages |
|                              |                              | printed_by request_xml response_xml sent |
|                              |                              | status ticket                            |
+------------------------------+------------------------------+------------------------------------------+
| cbss.RetrieveTIGroupsRequest | person__partner_ptr          | debug_messages environment info_messages |
|                              |                              | printed_by request_xml response_xml sent |
|                              |                              | status ticket                            |
+------------------------------+------------------------------+------------------------------------------+
| clients.ClientContact        | client__partner_ptr          | list_item name_column navigation_panel   |
|                              |                              | overview workflow_buttons                |
+------------------------------+------------------------------+------------------------------------------+
| coachings.Coaching           | client__partner_ptr          | list_item name_column navigation_panel   |
|                              |                              | overview workflow_buttons                |
+------------------------------+------------------------------+------------------------------------------+
| contacts.Company             | contacts.Company.partner_ptr | created modified remarks                 |
+------------------------------+------------------------------+------------------------------------------+
| contacts.Partner             | None                         | address_column contact_details created   |
|                              |                              | created_natural list_item modified       |
|                              |                              | mti_navigator municipality name_column   |
|                              |                              | navigation_panel overview remarks        |
|                              |                              | workflow_buttons                         |
+------------------------------+------------------------------+------------------------------------------+
| contacts.Person              | contacts.Person.partner_ptr  | address_column age contact_details       |
|                              |                              | created created_natural list_item        |
|                              |                              | modified mti_navigator municipality      |
|                              |                              | name_column navigation_panel overview    |
|                              |                              | remarks workflow_buttons                 |
+------------------------------+------------------------------+------------------------------------------+
| households.Household         | None                         | address_column contact_details created   |
|                              |                              | created_natural list_item modified       |
|                              |                              | mti_navigator municipality name_column   |
|                              |                              | navigation_panel overview remarks        |
|                              |                              | workflow_buttons                         |
+------------------------------+------------------------------+------------------------------------------+
| isip.Contract                | client__partner_ptr          | printed_by                               |
+------------------------------+------------------------------+------------------------------------------+
| jobs.Candidature             | person__partner_ptr          |                                          |
+------------------------------+------------------------------+------------------------------------------+
| jobs.Contract                | client__partner_ptr          | printed_by                               |
+------------------------------+------------------------------+------------------------------------------+
| jobs.JobProvider             | contacts.Company.partner_ptr | created modified remarks                 |
+------------------------------+------------------------------+------------------------------------------+
| pcsw.Client                  | contacts.Person.partner_ptr  | created modified remarks remarks2        |
+------------------------------+------------------------------+------------------------------------------+
| xcourses.CourseProvider      | contacts.Company.partner_ptr | created modified remarks                 |
+------------------------------+------------------------------+------------------------------------------+