Persons (contacts.Persons)

Shows all persons. (more)

Every row of this data table is a Person.

User guide: The contacts plugin.

Columns

  • Name (name_column) : See Name.

  • Address (address_column) : See Address.

  • e-mail address (email) : The primary email address.

  • Phone (phone) : The primary phone number.

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

  • ID (id) : See ID.

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

Detail layout

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

      • ID (id) : See ID.

      • Remarks (remarks) : See Remarks.

      • Contact for (contacts.RolesByPerson1) : See Contact for.

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

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

        • Gender (gender) : The sex of this person (male, female, nonbinary).

        • Country (country) : See Country.

        • County (region) : See County.

        • Locality (city) : The locality, i.e. usually a village, city or town.

        • Zip code (zip_code) : See Zip code.

      • Address line before street (addr1) : Address line before street

        • Street (street) : Name of street, without house number.

        • No. (street_no) : House number.

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

      • Address line after street (addr2) : Address line to print below street line.

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

        • Responsible team (group) : The user group this row belongs to. This field may be empty, which means that it is not shared in a group, only its author can see it.

        • Private (private) : Whether this row is confidential.

      • e-mail address (email) : The primary email address.

      • URL (url) : See URL.

      • Phone (phone) : The primary phone number.

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

        • Fax (fax) : See Fax.

  • Subscriptions (subscriptions.SubscriptionsByPartner)

  • Tickets (tickets.TicketsByEndUser)

    • Purchase account (purchase_account) : The general account to suggest as default value in purchase invoices from this partner.

    • Trade vouchers (vat.VouchersByPartner1) : See Trade vouchers.

    • Movements (accounting.MovementsByPartner1) : See Movements.

Toolbar actions

  • Table (landscape) (as_pdf) : See (unformatted: <lino_xl.lib.appypod.mixins.PrintTableAction as_pdf ('Table (landscape)')>).

  • Table (portrait) (as_pdf_p) : See (unformatted: <lino_xl.lib.appypod.mixins.PortraitPrintTableAction as_pdf_p ('Table (portrait)')>).

  • Labels (print_labels) : Generate mailing labels for these recipients

  • Export to .xls (export_excel) : Export this table as an .xls document

  • None (grid_post) : See (unformatted: <lino.core.actions.CreateRow grid_post>).

  • None (grid_put) : See (unformatted: <lino.core.actions.SaveGridCell grid_put>).

  • New (insert) : Insert a new Person.

  • Create (submit_insert) : Submit this form, i.e. send your data to the server.

  • Duplicate (clone_row) : Insert a new Person as a copy of this.

  • Delete (delete_selected) : Delete this record

  • Merge (merge_row) : Merge this object into another object of same class.

  • None (start_invoicing_1) : Make Service reports (SRV) for this partner.

  • Debts (due) : 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.

  • Trading rules (show_invoice_partners) : Show partners having this as invoice recipient.

  • Show data problems (show_problems) : See (unformatted: <lino.core.actions.ShowSlaveTable show_problems ('Show data problems')>).

  • Trading rules (show_trading_rules) : Shows the list of trading rules.

  • Upload files (show_uploads) : Opens a data window with the uploaded files associated to this database object.

  • Check data (check_data) : Update data problem messages for this database object, also removing messages that no longer exist. This action does not change anything else in the database.

  • Fix data problems (fix_problems) : Update data problem messages and repair those which are automatically fixable.

  • None (grid) : Shows all persons.

  • None (open_help) : Open Help Window

  • None (validate) : See (unformatted: <lino.core.actions.ValidateForm validate>).

  • Save (submit_detail) : Save changes in this form

Filter parameters

  • Observed event (observed_event) : Extended filter criteria

  • Date range from (start_date) : Start date of observed date range.

  • until (end_date) : End date of observed date range.

  • Aged from (aged_from) : Select only persons aged at least the given number of years.

  • Aged to (aged_to) : Select only persons aged at most the given number of years.

  • Gender (gender) : The sex of this person (male, female, nonbinary).

Hidden columns

  • Private (private) : Whether this row is confidential.

  • Responsible team (group) : The user group this row belongs to. This field may be empty, which means that it is not shared in a group, only its author can see it.

  • Country (country) : See Country.

  • Locality (city) : The locality, i.e. usually a village, city or town.

  • Zip code (zip_code) : See Zip code.

  • County (region) : See County.

  • Address line before street (addr1) : Address line before street

  • Street prefix (street_prefix) : Text to print before name of street, but to ignore for sorting.

  • Street (street) : Name of street, without house number.

  • No. (street_no) : House number.

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

  • Address line after street (addr2) : Address line to print below street line.

  • URL (url) : See URL.

  • Fax (fax) : See Fax.

  • VAT regime (vat_regime) : The default VAT regime to use on invoices for this partner.

  • VAT id (vat_id) : The national VAT identification number of this partner.

  • Send via Peppol (send_peppol) : Whether sales invoices and credit notes to this partner should be sent via the Peppol network.

  • Peppol ID (peppol_id) : How this partner identifies themselves in the Peppol network. This is a string of style schemaID:value, where schemaID refers to a EAS.

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

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

  • Remarks (remarks) : See Remarks.

  • Purchase account (purchase_account) : The general account to suggest as default value in purchase invoices from this partner.

  • Title (title) : An optional professional position or academic qualification like “Dr.” or “PhD”.

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

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

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

  • Gender (gender) : The sex of this person (male, female, nonbinary).

  • Birth date (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”.

  • Select multiple rows (rowselect) : See Select multiple rows.

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