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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- accounting.MatchRule (Begleichungsregel):
ID (
id
) :Haushaltsartikel (
account
) :Journal (
journal
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneBeleg (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneXML 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeDatenquelle (
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
) : NoneGemeinde (
municipality
) : The municipality, i.e. either the city or a parent of it.Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
created_natural
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
created_natural
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
created_natural
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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 ContractEndingEnddatum (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneMeldung (
message_html
) : NoneBkTxCd (
txcd_text
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- boards.Member (Gremienmitglied):
ID (
id
) :Gremium (
board
) :Person (
person
) :Funktion (
role
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneMale (
times_text
) : NoneWann (
weekdays_text
) : A virtual field returning the textual formulation of the weekdays where the recurrence occurs.Name (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneDauer (
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
) : NoneWann (
when_html
) : Shows the date and time of the calendar entry with a link that opens all entries on that day.Link URL (
url
) : NoneErinnerung (
reminder
) : NoneKalender (
calendar
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
created_natural
) : NoneDauer (
duration
) : NoneNone (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneBeschreibung (
what_text
) : NoneMale (
times_text
) : NoneWann (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneBeschreibung (
what_text
) : NoneMale (
times_text
) : NoneWann (
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 endBearbeiten (
move_buttons
) : Displays buttons for certain actions on this row:Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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.ManageActionsAbfrageregister (
query_register
) : The register to be query. This must be one of the values in lino_welfare.modlib.cbss.choicelists.QueryRegistersResultat (
result
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
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
) : NoneNone (
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
) : NoneSelect 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
municipality
) : The municipality, i.e. either the city or a parent of it.Erstellt (
created_natural
) : NoneNone (
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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
municipality
) : The municipality, i.e. either the city or a parent of it.Erstellt (
created_natural
) : NoneAlter (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : 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.beActual 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
) : NoneNone (
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
) : NoneSelect 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.beBezeichnung (fr) (
name_fr
) :Bezeichnung (en) (
name_en
) :Kinder (
children_summary
) : A comma-separated list of the children.None (
treeview_panel
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneGemeinde (
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
) : NoneNone (
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
) : NoneSelect 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 CefLevelsZertifikat (
has_certificate
) : Whether this entry is confirmed by a certificate.Name (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- cv.PersonProperty (Eigenschaft):
ID (
id
) :Eigenschaftsgruppe (
group
) :Eigenschaft (
property
) :Wert (
value
) :Klient (
person
) :Bemerkung (
remark
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneGemeinde (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneGemeinde (
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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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 endBearbeiten (
move_buttons
) : Displays buttons for certain actions on this row:Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneErfasste Daten (
data_box
) : NoneZusammenfassung (
summary_box
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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 agencyBeschreibung (
summary_description
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
move_buttons
) : Displays buttons for certain actions on this row:Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- dupable_clients.Word (Phonetisches Wort):
ID (
id
) :word (
word
) :Klient (
owner
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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 yearMonate (
month
) : The number of the month or the week.S.Inf (
esf10
) : Informative sessionsE.Ind (
esf20
) : Individual consultationE.For (
esf21
) : Evaluation of external trainingSIS (
esf30
) : Certified integration serviceTst (
esf40
) : Level testsInfo (
esf41
) : IT basicsMob (
esf42
) : MobilityRem (
esf43
) : Remedial teachingAN! (
esf44
) : Wake up!MSP (
esf50
) : Getting a professional situationCyE (
esf60
) : Cyber Job60§7 (
esf70
) : Art 60§7 job supplymentKlient (
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
) : NoneAusgedruckt (
printed
) : Displays information about when this database row has been printed.Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneVorschau (
preview
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneXML file (
xml_file
) : NoneAusgedruckt (
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
) : NoneEingang (
income
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneXML file (
xml_file
) : NoneAusgedruckt (
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
) : NoneKredit (
credit
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNr. (
number_with_year
) : Shows the accounting year and the number of this voucher within its journal.Eingangsdokument (
source_document
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneXML file (
xml_file
) : NoneAusgedruckt (
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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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 typesName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAlter (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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 ContractEndingEnddatum (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneBeschreibung (
what_text
) : NoneMale (
times_text
) : NoneWann (
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
) : NoneNone (
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
) : NoneSelect 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 ContractEndingEnddatum (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneAusgedruckt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
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 endBearbeiten (
move_buttons
) : Displays buttons for certain actions on this row:Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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 endBearbeiten (
move_buttons
) : Displays buttons for certain actions on this row:Name (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneBeschreibung (
what_text
) : NoneMale (
times_text
) : NoneWann (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- newcomers.Broker (Vermittler):
ID (
id
) :name (
name
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- pcsw.Activity (Beruf):
ID (
id
) :name (
name
) :Listing 104 (
lst104
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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 AdelstitelIntegrationsphase (
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
) : NoneVertrag endet (
applies_until
) : NoneArbeitet bei (
contract_company
) : NoneActive contract (
active_contract
) : NoneZDSS (
cbss_relations
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
municipality
) : The municipality, i.e. either the city or a parent of it.Erstellt (
created_natural
) : NoneAlter (
age
) : Virtual field displaying the age in years.Zusammenfassung ZDSS (
cbss_summary
) : NoneIdentifyPerson-Anfragen (
cbss_identify_person
) : NoneManageAccess-Anfragen (
cbss_manage_access
) : NoneTx25-Anfragen (
cbss_retrieve_ti_groups
) : NoneSprachkenntnis (
language_knowledge
) : A summary of the language knowledges of this person.Muttersprachen (
mother_tongues
) : NoneNone (
cef_level_de
) : NoneNone (
cef_level_fr
) : NoneNone (
cef_level_en
) : NoneeID-Karte (
eid_info
) : NoneNone (
image
) : Virtual field which displays the picture.Primärbegleiter (
primary_coach
) : NoneBegleiter (
coaches
) : NoneTermin finden (
find_appointment
) : None
- pcsw.Conviction (Vorstrafe):
ID (
id
) :Klient (
client
) :Datum (
date
) :Prejudicial (
prejudicial
) :Bezeichnung (
designation
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- pcsw.ExclusionType (AG-Sperrgrund):
ID (
id
) :name (
name
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- pcsw.PersonGroup (Integrationsphase):
ID (
id
) :Bezeichnung (
name
) :Referenzname (
ref_name
) :Aktive Phase (
active
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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 BICKontoart (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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
) : NoneThumbnail (
thumbnail
) : NoneName (
name_column
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneNone (
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
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- users.Authority (Vollmacht):
ID (
id
) :Autor (
user
) : The user who gives the right of representation. author of this authorityBenutzer (
authorized
) : The user who gets the right to represent the authorName (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NonePerson (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneErstellt (
created_natural
) : NoneNone (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneNr. (
number_with_year
) : Shows the accounting year and the number of this voucher within its journal.Eingangsdokument (
source_document
) : NoneXML 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None⇵ (
dndreorder
) : A place holder column for drag and drop row reorder on React front endBearbeiten (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
- xcourses.CourseContent (Kursinhalt):
ID (
id
) :Name (
name
) :Name (
name_column
) : NoneNone (
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
) : NoneSelect 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
) : NoneNone (
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
) : NoneSelect 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ßePrä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 HausnummerNr. (
street_no
) : HausnummerBox (
street_box
) : Text to print after street number on the same line.Adresszeile nach Straße (
addr2
) : Adresszeile nach StraßeName 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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : NoneKontaktangaben (
contact_details
) : NoneAnsicht als (
mti_navigator
) : A virtual field which defines buttons for switching between the different views.Adresse (
address_column
) : NoneGemeinde (
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
) : NoneNone (
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
) : NoneSelect multiple rows (
rowselect
) : None
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 |
+------------------------------+------------------------------+------------------------------------------+