Data tables

Name	Description
Yes or no (system.YesNo)	A choicelist with two values “Yes” and “No”.
Genders (system.Genders)	Defines the possible choices for the gender of a person (“male”, “female” and “nonbinary”).
Time zones (system.TimeZones)	The list of time zones available on this site.
Date formats (system.DateFormats)	A list of date formats.
Observed events (system.PeriodEvents)	The list of things you can observe on a lino.mixins.periods.DateRange.
Weekdays (system.Weekdays)	A choicelist with the seven days of a week.
DurationUnits (system.DurationUnits)	The list of possible duration units defined by this application.
Recurrences (system.Recurrences)	List of possible choices for a ‘recurrency’ field.
Display colors (system.DisplayColors)	A list of colors to be specified for displaying.
User types (users.UserTypes)	The list of user types available in this application.
Data checkers (checkdata.Checkers)	The list of data checkers known by this application.
Editor types (memo.EditorTypes)	Choice list of source editor types used by FormatPreviewable.
Emotions (comments.Emotions)	The list of available values for the Comment.emotion field.
Observed events (comments.CommentEvents)	The choicelist with selections for Comments.observed_event.
Upload areas (uploads.UploadAreas)	None
Upload shortcuts (uploads.Shortcuts)	The list of available upload shortcut fields in this application.
Image sizes (uploads.ImageSizes)	None
Image formats (uploads.ImageFormats)	None
Document classes (printing.DocumentClasses)	A choicelist that holds the list of available document classes. Plugins add items to this list.
BuildMethods (printing.BuildMethods)	The choicelist of build methods offered on this site.
About (about.About)	The window that opens via the menu command Site ‣ About to show information about this Lino site.
Table classes (jinja.TableClasses)	A choicelist of supported class names for tables in a rich text field.
PrimeReactThemes (react.PrimeReactThemes)	None
TextBoxSizeUnits (react.TextBoxSizeUnits)	None
Background procedures (linod.Procedures)	The choicelist of background procedures available in this application.
Logging levels (linod.LogLevels)	A choicelist of logging levels available in this application.
Domains (system.SiteConfigs)	The table used to present the SiteConfig row in a Detail form.
Site configuration (system.MySiteConfig)	None
Dashboard (system.Dashboard)	None
Pending edit locks (system.PendingEditLocks)	None
content types (gfks.ContentTypes)	None
Broken GFKs (gfks.BrokenGFKs)	None
Broken GFKs (gfks.BrokenGFKsByModel)	None
Priorities (xl.Priorities)	None
PlaceTypes (countries.PlaceTypes)	A choicelist of possible place types.
Countries (countries.Countries)	The table of all countries.
Places (countries.Places)	The table of known geographical places. A geographical place can be a city, a town, a suburb, a province, a lake… any named geographic entity, except for countries because these have their own table.
Subdivisions (countries.PlacesByPlace)	None
Places (countries.PlacesByCountry)	None
Booking directions (accounting.DC)	A choicelist with the two values “debit” and “credit”.
Journal groups (accounting.JournalGroups)	The list of possible journal groups.
Common accounts (accounting.CommonAccounts)	The global list of common accounts.
Voucher types (accounting.VoucherTypes)	The list of voucher types available in this application.
Trade types (accounting.TradeTypes)	The choicelist with the trade types defined for this application.
Voucher states (accounting.VoucherStates)	The list of possible states of a voucher.
Observed events (contacts.PartnerEvents)	A choicelist of observable partner events.
Civil states (contacts.CivilStates)	The global list of civil states that a person can have. The field pointing to this list is usually named civil_state.
VAT classes (vat.VatClasses)	The global list of VAT classes.
VAT areas (vat.VatAreas)	The global list of VAT areas.
VAT columns (vat.VatColumns)	The list of VAT columns available on this site.
VAT regimes (vat.VatRegimes)	The global list of VAT regimes. Each item of this list is an instance of VatRegime.
Declaration fields (vat.DeclarationFieldsBase)	None
VAT rules (vat.VatRules)	The table of all VatRule objects.
Subscription periodicities (invoicing.Periodicities)	None
Excerpt shortcuts (excerpts.Shortcuts)	A choicelists of excerpt shortcut fields.
Accounts (accounting.Accounts)	None
Journals (accounting.Journals)	List of all Journals. Accessible via Configure ‣ Accounting ‣ Journals.
Journals (accounting.JournalsOverview)	The list of all Journals shown in the dashboard.
ByJournal (accounting.ByJournal)	Mixin for journal-based tables of vouchers.
Payment terms (accounting.PaymentTerms)	None
Vouchers (accounting.AllVouchers)	None
Match rules (accounting.MatchRules)	None
Match rules (accounting.MatchRulesByAccount)	None
Match rules (accounting.MatchRulesByJournal)	None
Debts (accounting.ExpectedMovements)	A virtual table of DueMovement rows, showing all “expected” “movements (payments)”.
Debts (accounting.DebtsByAccount)	The ExpectedMovements accessible by clicking the “Debts” action button on an account.
Debts (accounting.DebtsByPartner)	This is the table being printed in a Payment Reminder. Usually this table has one row per sales invoice which is not fully paid. But several invoices (“debts”) may be grouped by match. If the partner has purchase invoices, these are deduced from the balance.
Vouchers (accounting.PartnerVouchers)	Base class for tables of partner vouchers.
General Account Balances (accounting.GeneralAccountBalances)	None
Debtors (accounting.Debtors)	Shows partners who have some debt against us. Inherits from DebtorsCreditors.
Creditors (accounting.Creditors)	Shows partners who give us some form of credit. Inherits from DebtorsCreditors.
Movements (accounting.Movements)	The base table for all tables having ledger movements as rows.
Movements (accounting.AllMovements)	Show all the ledger movements in the database.
Movements (accounting.MovementsByVoucher)	Show the ledger movements generated by a given voucher.
Movements (accounting.MovementsByPartner)	Shows the ledger movements linked to a given partner.
My movements (accounting.MyMovements)	None
Movements (accounting.MovementsByAccount)	Shows the ledger movements done on a given general account.
Movements (accounting.MovementsByMatch)	Show all movements having a given Movement.match.
Partners (contacts.Partners)	None
Partners (contacts.PartnersByCity)	None
Partners (contacts.PartnersByCountry)	None
Persons (contacts.Persons)	Shows all persons.
Legal forms (contacts.CompanyTypes)	None
Organizations (contacts.Companies)	Base table for all tables on organizations.
Functions (contacts.RoleTypes)	None
Contact persons (contacts.Roles)	None
Contact persons (contacts.RolesByCompany)	None
Contact for (contacts.RolesByPerson)	None
Contact requests (webforms.ContactRequests)	None
Contact requests (webforms.ContactRequestsWeb)	None
Requests to create a user account (webforms.CreateUserRequests)	None
Requests to create a user account (webforms.CreateUserRequestsWeb)	None
Users (users.AllUsers)	Shows the list of all users on this site.
Users (users.UsersOverview)	A variant of Users showing only active users and only some fields. This is used on demo sites in admin_main.html to display the list of available users.
My settings (users.Me)	None
Authorities (users.Authorities)	None
Authorities given (users.AuthoritiesGiven)	None
Authorities taken (users.AuthoritiesTaken)	None
User roles (users.UserRoles)	None
User sessions (users.Sessions)	Show a list of all user sessions.
Topics (topics.Topics)	None
Topics (topics.AllTopics)	None
Tags (topics.Tags)	None
Tags (topics.TagsByOwner)	None
Tagged by (topics.TagsByTopic)	None
Interests (topics.Interests)	None
Interests (topics.AllInterests)	None
Interested partners (topics.InterestsByTopic)	None
Interested in (topics.InterestsByPartner)	None
Excerpt Types (excerpts.ExcerptTypes)	Displays all rows of ExcerptType.
Excerpts (excerpts.Excerpts)	Base class for all tables on Excerpt.
Excerpts (excerpts.AllExcerpts)	None
My Excerpts (excerpts.MyExcerpts)	None
Excerpts (excerpts.ExcerptsByType)	None
Existing excerpts (excerpts.ExcerptsByOwner)	Shows all excerpts whose owner field is this.
Reporting types (working.ReportingTypes)	The list of reporting types available on this site.
Message Types (notify.MessageTypes)	The list of possible choices for the message_type field of a Message.
Notification modes (notify.MailModes)	How the system should send email notifications to a user.
Observed events (tickets.TicketEvents)	None
Ticket states (tickets.TicketStates)	The choicelist for the state of a ticket.
YearMonths (cal.YearMonths)	None
Planner columns (cal.PlannerColumns)	A choicelist of columns to show in certain reports.
Task states (cal.TaskStates)	Possible values for the state of a Task. The list of choices for the Task.state field.
Presence states (cal.GuestStates)	Global choicelist of possible guest states.
Observed events (cal.EventEvents)	None
Entry states (cal.EntryStates)	The list of possible states of a calendar entry.
Notify Units (cal.NotifyBeforeUnits)	The list of choices for Event.notify_unit.
States (cal.ReservationStates)	None
Ticket types (tickets.TicketTypes)	The list of all ticket types.
Tickets (tickets.Tickets)	Base class for all tables of tickets.
All tickets (tickets.AllTickets)	Shows all tickets.
Duplicates (tickets.DuplicatesByTicket)	Shows the tickets which are marked as duplicates of this (i.e. whose duplicate_of field points to this ticket.
Reference Tickets (tickets.RefTickets)	Shows all tickets that have a reference.
Unassigned Tickets (tickets.UnassignedTickets)	None
Tickets (tickets.TicketsByEndUser)	Show the tickets introduced on behalf of this end user.
Tickets (tickets.TicketsByType)	None
Public tickets (tickets.PublicTickets)	Shows all public tickets.
Tickets to triage (tickets.TicketsToTriage)	Shows tickets that need to be triaged. Currently this is equivalent to those having their state set to new.
Tickets to talk (tickets.TicketsToTalk)	None
Active tickets (tickets.ActiveTickets)	Show all tickets that are in an active state.
My Tickets (tickets.MyTickets)	Show all active tickets reported by me.
Tickets to work (tickets.MyTicketsToWork)	Show all active tickets assigned to me.
Tickets (tickets.TicketsByGroup)	Show all tickets of this groups.Group.
Children (tickets.TicketsByParent)	None
Tickets (tickets.TicketsByOrder)	None
Checks (tickets.CheckListItems)	None
Checks (tickets.CheckListItemsByTicket)	None
Nicknamings (nicknames.Namings)	None
System tasks (linod.SystemTasks)	The default table for the SystemTask model.
Disabled system tasks (linod.DisabledSystemTasks)	None
Data problem messages (checkdata.Messages)	None
Data problem messages (checkdata.AllMessages)	None
Data problem messages (checkdata.MessagesByOwner)	None
Data problem messages (checkdata.MessagesByChecker)	None
Data problem messages assigned to me (checkdata.MyMessages)	Shows the data problem messages assigned to me.
Planners (calview.Planners)	None
Planner rows (calview.DailyPlannerRows)	None
??? (calview.DailyPlanner)	The virtual table used to render the daily planner.
??? (calview.DailySlave)	None
??? (calview.WeeklySlave)	None
??? (calview.MonthlySlave)	None
Calendar (calview.DailyView)	Shows a calendar navigator with a configurable daily view.
Calendar (calview.WeeklyView)	Shows a calendar navigator with a configurable weekly view.
Calendar (calview.MonthlyView)	Shows a calendar navigator with a configurable monthly view.
Session Types (working.SessionTypes)	None
Reporting rules (working.ReportingRules)	None
Working sessions (working.Sessions)	None
Working sessions (working.AllSessions)	None
Working sessions (working.SessionsByTicket)	Show the working sessions on this ticket.
Working sessions (working.SessionsByOrder)	None
My sessions (working.MySessions)	Shows all my sessions.
My sessions by date (working.MySessionsByDate)	Shows my working sessions of a given day.
Working sessions (working.SessionsByReport)	None
Tickets (working.TicketsByReport)	None
Order summaries (working.OrderSummaries)	None
Order summaries (working.AllSummaries)	None
Order summaries (working.SummariesByOrder)	None
User summaries (working.UserSummaries)	None
User summaries (working.SummariesByUser)	Shows the summary records for a given user.
Worked hours (working.WorkedHours)	None
My sessions by date (working.MySessionsByDay)	None
Working contracts (working.Contracts)	Shows the list of all worker contracts for managing them.
Working contracts (working.ActiveContracts)	Shows the list of all worker contracts with statistic data about their activity.
SubscribeToList request (lists.SubscribeToListRequests)	None
SubscribeToList request (lists.SubscribeToListRequestsWeb)	None
Newsletters (lists.Lists)	None
My Newsletters (lists.MyLists)	None
Newsletters (lists.AllLists)	None
List memberships (lists.Members)	None
Members (lists.MembersByList)	None
List memberships (lists.MembersByUser)	None
List memberships (lists.AllMembers)	None
Change Types (changes.ChangeTypes)	The list of possible choices for the type field of a Change.
Changes (changes.Changes)	None
Changes (changes.ChangesByObject)	Show the history of changes in the current database row.
Changes (changes.ChangesByMaster)	Show the history of changes in the current database row and related data.
Mentions (memo.Mentions)	None
Mentions (memo.MentionsByOwner)	None
Mentioned by (memo.MentionsByTarget)	None
Notification messages (notify.Messages)	Base for all tables of messages.
Notification messages (notify.AllMessages)	The gobal list of all messages.
My Notification messages (notify.MyMessages)	Shows messages emitted to me.
Library volumes (uploads.Volumes)	None
Upload types (uploads.UploadTypes)	The table with all existing upload types.
Upload files (uploads.Uploads)	Base class for all data tables of upload files.
Upload files (uploads.AllUploads)	Shows all upload files on this Lino site.
Upload files (uploads.UploadsByType)	None
Upload files (uploads.UploadsByVolume)	None
My Upload files (uploads.MyUploads)	Shows my uploads (i.e. those whose author is the requesting user).
Upload files (uploads.AreaUploads)	Mixin for tables of upload files where the upload area is known.
Upload files (uploads.UploadsByController)	Shows the uploaded files associated to this database object.
Widgets (dashboard.Widgets)	None
All dashboard widgets (dashboard.AllWidgets)	None
Dashboard (dashboard.WidgetsByUser)	None
Comment Types (comments.CommentTypes)	The table with all existing comment types.
Comments (comments.Comments)	None
My Comments (comments.MyComments)	Show the comments posted by the current user.
Comments (comments.AllComments)	Show all comments.
Comments (comments.CommentsByX)	None
Recent comments (comments.RecentComments)	Show the most recent comments that have been posted on this site.
Comments (comments.CommentsByType)	None
Comments (comments.CommentsByRFC)	Shows the comments about a given database row.
Mentioned in (comments.CommentsByMentioned)	None
Replies (comments.RepliesByComment)	None
Reactions (comments.Reactions)	None
Reactions (comments.ReactionsByComment)	None
User statistics (userstats.UserStats)	None
Teams (groups.Groups)	Shows all groups.
My Teams (groups.MyGroups)	None
Group memberships (groups.Memberships)	None
Memberships (groups.MembershipsByGroup)	None
Group memberships (groups.MembershipsByUser)	None
Group memberships (groups.AllMemberships)	None
Delivery units (products.DeliveryUnits)	The list of possible delivery units of a product.
Product types (products.ProductTypes)	The list of product types.
Price factors (products.PriceFactors)	The choicelist of price factors.
Barcode drivers (products.BarcodeDrivers)	None
Product Categories (products.Categories)	None
Services (products.Products)	Base class for all tables of products.
Products (products.ProductsByCategory)	None
Price rules (products.PriceRules)	The list of price rules.
Period types (periods.PeriodTypes)	A list of choices for the values allowed as periods.period_type.
States (periods.PeriodStates)	None
Fiscal years (periods.StoredYears)	The fiscal years defined in this database.
Accounting periods (periods.StoredPeriods)	The accounting periods defined in this database.
Ledger invoices (vat.Invoices)	The table of all VatAccountInvoice objects.
Ledger invoices (vat.InvoicesByJournal)	Shows all invoices of a given journal. Works only when the voucher_type of the specified master instance is VatAccountInvoice.
Purchase journal (vat.PrintableInvoicesByJournal)	Purchase journal
Content (vat.ItemsByInvoice)	None
Trade vouchers (vat.VouchersByPartner)	None
Movements (vat.MovementsByVoucher)	None
Declared movements (vat.MovementsByDeclaration)	None
VAT sales (vat.SalesByDeclaration)	Show a list of all sales invoices whose VAT regime is Intra-Community.
VAT purchases (vat.PurchasesByDeclaration)	Show a list of all purchase invoices whose VAT regime is Intra-Community.
Intra-Community sales (vat.IntracomSales)	Show a list of all sales invoices having VAT regime is Intra-Community.
Intra-Community purchases (vat.IntracomPurchases)	Show a list of all purchase invoices having VAT regime is Intra-Community.
Follow-up rules (invoicing.FollowUpRules)	None
Follow-up rules (invoicing.RulesByTask)	None
Invoicing tasks (invoicing.Tasks)	None
Flatrates (invoicing.Tariffs)	None
Invoicing plans (invoicing.Plans)	None
My invoicing plan (invoicing.MyPlan)	None
Invoicing plans (invoicing.AllPlans)	None
Invoicing suggestions (invoicing.Items)	None
Invoicing suggestions (invoicing.ItemsByPlan)	None
Paper types (trading.PaperTypes)	None
Trading rules (trading.TradingRules)	Shows the list of trading rules.
Trading rules (trading.RulesByPartner)	None
Trading rules (trading.PartnersByInvoiceRecipient)	None
Trading invoices (trading.Invoices)	None
Trading invoices (trading.InvoicesByJournal)	Shows all invoices of a given journal.
Sales invoice journal (trading.PrintableInvoicesByJournal)	None
Due invoices (trading.DueInvoices)	Shows all due product invoices.
Trading invoice items (trading.InvoiceItems)	None
Content (trading.ItemsByInvoice)	None
Content (trading.ItemsByInvoicePrint)	The table used to render items in a printable document.
Content (trading.ItemsByInvoicePrintNoQtyColumn)	Alternative column layout to be used when printing an invoice.
Trading invoice items (trading.InvoiceItemsByProduct)	None
Invoicings (trading.InvoiceItemsByGenerator)	None
Trading invoices (trading.DocumentsToSign)	None
Trading invoices (trading.InvoicesByPartner)	None
Provision states (storage.ProvisionStates)	None
Transfer rules (storage.TransferRules)	None
Transfer rules (storage.TransferRulesByJournal)	None
Storage movements (storage.Movements)	None
Storage movements (storage.AllMovements)	None
Storage movements (storage.MovementsByVoucher)	None
Storage movements (storage.MovementsByPartner)	None
Storage movements (storage.MovementsByFiller)	None
Storage movements (storage.MovementsByProduct)	None
Storage movements (storage.MovementsByMatch)	None
Provisions (storage.Provisions)	None
Provisions (storage.ProvisionsByProduct)	None
Provisions (storage.ProvisionsByPartner)	None
Components (storage.Components)	None
Components (storage.ComponentsByParent)	None
Delivery notes (storage.DeliveryNotes)	None
Delivery notes (storage.DeliveryNotesByJournal)	None
Delivery items (storage.DeliveryItems)	None
Delivery items (storage.ItemsByDeliveryNote)	None
Invoicings (storage.DeliveriesByGenerator)	None
Storage fillers (storage.Fillers)	None
Storage fillers (storage.FillersByPartner)	None
Storage fillers (storage.FillersByProduct)	None
Sales invoices (to same invoice recipient) (subscriptions.InvoicesBySubscription)	None
Subscriptions (subscriptions.Subscriptions)	None
Subscriptions (subscriptions.SubscriptionsByJournal)	None
All subscriptions (subscriptions.AllSubscriptions)	None
Subscriptions (subscriptions.SubscriptionsByPartner)	None
Subscription items (subscriptions.SubscriptionItems)	None
Content (subscriptions.ItemsBySubscription)	None
Subscription periods (subscriptions.SubscriptionPeriods)	None
Subscription periods (subscriptions.PeriodsBySubscription)	None
Bank accounts (sepa.Accounts)	None
Bank accounts (sepa.AccountsByPartner)	Shows the bank account(s) known for the given partner.
Onboarding states (peppol.OnboardingStates)	None
Ibanity suppliers (peppol.Suppliers)	None
Agenda items (agenda.Items)	None
Agenda items (agenda.ItemsByMeeting)	None
Agenda items (agenda.ItemsByTopic)	None
Remote Calendars (cal.RemoteCalendars)	None
Rooms (cal.Rooms)	Base class for all list of rooms.
Rooms (cal.AllRooms)	Show a list of all rooms.
Calendars (cal.Calendars)	None
Subscriptions (cal.Subscriptions)	None
Subscriptions (cal.SubscriptionsByUser)	None
Subscriptions (cal.SubscriptionsByCalendar)	None
Tasks (cal.Tasks)	Global table of all tasks for all users.
Tasks (cal.TasksByController)	None
Tasks (cal.TasksByUser)	Shows the list of tasks for this user.
My tasks (cal.MyTasks)	Shows my tasks whose start date is today or in the future.
Presences (cal.Guests)	The default table of presences.
Presences (cal.AllGuests)	None
Guest roles (cal.GuestRoles)	Global table of guest roles.
Presences (cal.GuestsByRole)	None
Presences (cal.GuestsByEvent)	None
Presences (cal.GuestsByPartner)	Show the calendar entries having this partner as a guest.
My presences (cal.MyPresences)	Shows all my presences in calendar events, independently of their state.
My pending invitations (cal.MyPendingPresences)	Received invitations waiting for my feedback (accept or reject).
My guests (cal.MyGuests)	None
Calendar entry types (cal.EventTypes)	The list of entry types defined on this site.
Recurring events (cal.RecurrentEvents)	The list of all recurrent events (RecurrentEvent).
Calendar entries (cal.Events)	Table which shows all calendar events.
Calendar entries (cal.AllEvents)	None
Calendar entries (cal.EventsByType)	None
⚔ (cal.ConflictingEvents)	Shows events conflicting with this one (the master).
Upcoming events (cal.UpcomingEvents)	None
Appointments today (cal.EventsByDay)	This table is usually labelled “Appointments today”. It has no “date” column because it shows events of a given date.It is ordred with increasing times.
Calendar entries (cal.EventsByRoom)	Displays the calendar entries at a given Room.
Calendar entries (cal.EventsByController)	Shows the calendar entries controlled by this database object.
Calendar entries (cal.EventsByGuest)	Show the calendar entries having this partner as a guest.
Calendar entries (cal.OneEvent)	Show a single calendar event.
My appointments (cal.MyEvents)	Shows the appointments for which I am responsible.
My appointments today (cal.MyEventsToday)	Like MyEvents, but only today.
Appointments assigned to me (cal.MyAssignedEvents)	Shows the calendar entries that are assigned to me.
Overdue appointments (cal.OverdueAppointments)	Shows overdue appointments, i.e. appointments that happened before today and are still in a nonstable state.
My overdue appointments (cal.MyOverdueAppointments)	Like OverdueAppointments, but only for myself.
My unconfirmed appointments (cal.MyUnconfirmedAppointments)	Shows my appointments in the near future which are in suggested or draft state.
Recurrency policies (cal.EventPolicies)	Global table of all possible recurrency policies.
Search (search.SiteSearch)	A virtual table that searches in all database tables.
subscriptions (notify.SubscriptionTable)	None
ledger infos (accounting.LedgerInfoTable)	None
Ledger invoice items (vat.InvoiceItemTable)	None
Calendar entry repeaters (cal.EntryRepeaterTable)	None
User traits (matrix.UserTraitTable)	None