| Field | Finnish | English | Type | Format | Example | Notes |
|---|---|---|---|---|---|---|
| id | Integer | Unique | 123 | |||
| firstname | Etunimi | First name | Text | |||
| lastname | Sukunimi | Last name | Text | Required. | ||
| Sähköposti | Text | Unique email address. Used for logging in. If the email already exists in the system, this value is automatically moved to invoice_email | ||||
| invoice_email | Toissijainen sähköposti | Secondary email | Text | Only fill in if different from default email. | ||
| phone | Puhelin | Phone | Text | |||
| mobile | Matkapuhelin | Mobile | Text | '+358441234567' | Any format is allowed. For sending SMS, use E.164 format | |
| primary_address | Ensisijainen osoite | Primary address | Text | home, employer | Address to be printed on stickers and letters. | |
| address | Osoite | Address | Text | |||
| extraaddress | Lisäosoite | Extra address | Text | 'PB 123' | ||
| postcode | Postinumero | Post code | Text | |||
| postoffice | Postitoimipaikka | Post office | Text | |||
| residency | Kotipaikka | Residency | Text | If other than postoffice | ||
| country | Maa | Country | Text | 'USA' | ||
| title | Titteli | Title | Text | |||
| nationality | Kansallisuus | Nationality | Text | |||
| language | Kieli | Language | Text | fi-FI, sv-SE, en-GB |
||
| is_foreign | Ulkomainen | Boolean | 0=no, 1=yes | 1 | ||
| gender | Sukupuoli | Gender | Integer | 1 = male, 2 = female, 3 = other, 4 = prefer not to say | ||
| born | Syntynyt | Born | Date | dd.mm.yyyy | '31.12.1979' | |
| info | Uutiskirjeet | Newsletters | Integer | 1 = email, 2 = email and paper, 3 = no newsletter, 4 = paper | 1 | |
| extrainfo | Lisätiedot | Extra info | Text | |||
| employer | Työnantaja | Employer | Text | |||
| employer_address | Osoite (työnantaja) | Address (employer) | Text | |||
| employer_extraaddress | Lisäosoite (työnantaja) | Extra address (employer) | Text | |||
| employer_postcode | Postinumero (työnantaja) | Postcode (employer) | Text | |||
| employer_postoffice | Postitoimipaikka (työnantaja) | Post office (employer) | Text | |||
| employer_country | Maa (työnantaja) | Country (employer) | Text | |||
| invoice_preference | Toivottu laskutustapa | Invoice preference | Integer | 1 = email, 2 = paper, 3 = e-invoice | To set as 1, email or invoice_email must be set. Automatically set to 3 if edi is set. | |
| invoicing_address | Laskutusosoite | Invoicing address | Text | Full address, please use line breaks (Shift + Enter) | Yritys Oy Esimerkkitie 5 33101 TAMPERE | Replaces both recipient's name and address on invoices. |
| businessid | Y-tunnus | Business ID | Text | |||
| yourreference | Viite | Reference | Text | Printed as 'Your reference' on invoices sent to this person. | ||
| edi | EDI / OVT | EDI / OVT | Text | |||
| operator | Verkkolasku- operaattori | E-invoice operator | Text | Operator must be 6 to 15 characters with no spaces. | 'DABAFIHH' or '003710948874' | |
| donations_edi | EDI / OVT lahjoituksia varten | EDI / OVT for donations | Text | |||
| donations_operator | Lahjoitusten verkkolasku- operaattori | E-invoice operator for donations | Text | |||
| member_card_valid_until | Jäsenkortti voimassa asti | Membership card valid until | Text | dd.mm.yyyy | '31.12.2035' | |
| date_joined | Liittynyt | Joined | Text | dd.mm.yyyy | '15.06.2023' |