We’ve developed some resources to help you work effectively from home during COVID-19 Click here to learn more

Template variables

In this article
    Appointment

    Variables for appointments, those special for iCal is listed as an own section

    baid Appointment ID.
    bape Appointment, end date for publishing.
    baps Appointment, start date for publishing.
    bcon The appointment's company, name.
    bcrd The appointment's creation date, in PC's local time, formatted YYYYMMdd.
    bcrt The appointment's creation time, in PC's local time, formatted HHmmss.
    bdlg The "superoffice:invitations" link to the invitation dialog.
    bdll The "Use this link to open the Invitation dialog in SuperOffice SIX" link displayed for registered contacts. Blank if recipient is not a registered contact.
    beda The appointment's end date, formatted as YYYYMMdd.
    bema The appointment's owner, e-mail address.
    beti The appointment's end time, formatted as HHmmss.
    bfre Free/busy time.
    biid ID of the person invited to the follow-up.
    binf The appointment's description.
    binl First line of the appointment's description.
    binv Name of the person invited to the follow-up.
    blab Date or deadline. Translated name of an appointment or task.
    bloc Appointment location.
    bmil Is the appointment a milestone appointment. Translated "Yes" or "No".
    bold The appointment's old start date, formatted as YYYYMMdd.
    bolt The appointment's old start time, formatted as HHmmss.
    bown The appointment's owner, name.
    bper The appointment's contact, name.
    bprd The appointment's priority as a number. 1 = low, 2 = medium, 3 = high.
    bpri The appointment's priority as text.
    bpro The appointment's project, name.
    brec The appointment's tooltip for repeating appointments.
    bred The end date for the appointment's repeating pattern, formatted as YYYYMMdd.
    brei Translated text: "This follow-up is part of a repeating pattern:". Empty if this is not a repeating pattern. //SR_RECURR_PATTERN
    brel Translated text "See end of mail for a list of affected repeating follow-ups." Empty if this is not a repeating pattern. // SR_RECURR_SEE_LIST
    brid ID of the appointment's recurrence rule.
    brph Changes in recurrence and/or participants for appointments. Used when sending e-mail to participants on booking changes. (Only SIX.web)
    brsd The start date for the appointment's repeating pattern, formatted as YYYYMMdd.
    bsda The appointment's start date, formatted as YYYYMMdd.
    bsta The appointment's status (in English): "TENTATIVE", "CONFIRMED" or "CANCELLED".
    bsti The appointment's start time, formatted as HHmmss.
    bsug The appointment's SuggestedAppointment ID. 0 when appointment is not part of a sale/project guide.
    btim The appointment's date and time, e.g. 30.03.2005 (16:00)-(17:00).
    btod Today's date in UTC, formatted as YYYYMMdd.
    btot Current time in UTC, formatted as HHmmss.
    btyp Activity type.
    btza The appointment's start date, converted into the PC's local time. Formatted as YYYYMMdd.
    btzb The appointment's start time, converted into the PC's local time. Formatted as HHmmss.
    btzd The time zone offset for summer time, for the PC's local time. Formatted as +0200 or -1200
    btze The appointment's end date, converted into the PC's local time. Formatted as YYYYMMdd.
    btzf The appointment's end time, converted into the PC's local time. Formatted as HHmmss.
    btzk The time zone key, from the appointment's start date. (AR-CN means the Argentina-Corrientes time zone -0300.)
    btzl The time zone ID of the appointment.
    btzn The appointment's date and time converted to UTC if time zones are enabled. For example, 30.03.2005 (17:00)-(18:00).
    btzm Time zone formatted as Norway (GMT +1:00) if time zones are enabled.
    btzs The time zone offset for summer time, for the PC's local time. Formatted as +0200 or -1200
    btzt Time zone information, for the PC's local time. Formatted (GMT+01.00) or (GMT-04.00).
    btzv The appointment's start date converted to UTC if time zones are enabled. Formatted as YYYYMMdd.
    btzw The appointment's start time converted to UTC if time zones are enabled. Formatted as HHmmss.
    btzx The appointment's end date converted to UTC if time zones are enabled. Formatted as YYYYMMdd.
    btzy The appointment's end time converted to UTC if time zones are enabled. Formatted as HHmmss.
    bunt The end date for the appointment's repeating pattern, formatted as "UNTIL=YYYYMMddTHHmmss;".
    bupc The number of times the appointment has been updated. (Counts from version SIX onwards only).
    bupd Update date for the appointment, formatted as YYYYMMdd.
    bupt Update time for the appointment, formatted as HHmmss.
    tf01-10 Brukerdefinert felt 1-10 av typen desimaltall
    tl01-60 Brukerdefinert felt 1-60 av typen heltall.
    ts01-49 Brukerdefinert felt 1-49 av typen tekst.
    Appointment (iCal standard)

    Formatted in accordance with standard for iCal

    bate

    Formatted list of people invited to an appointment, created for iCal.

    ATTENDEE;RSVP=TRUE;CN="First Invited":MAILTO:;PARTSTAT=ACCEPTED

    ATTENDEE;RSVP=TRUE;CN="Test Testesen":MAILTO:test@superoffice.com;PARTSTAT=TENTATIVE

    bpat The main feature of the appointment's repeating pattern, formatted like the Daily pattern "FREQ=DAILY;", for example.
    bprt The appointment's priority, converted to iCal format: our 1 = iCal 9, our 2 = iCal 5 (default), our 3 = iCal 1.
    brul The entire appointment's repeating pattern, formatted as "RRULE:" + bpat + bsub + bunt.
    bsub The secondary feature of the appointment's repeating pattern, formatted as the sub-pattern Daily Workday "BYDAY=MO,TU,WE,TH,FR;", for example.
    bsun The start of the week for the appointment's repeating pattern, formatted as "WKST=SU" or "WKST=MO".
    btzr The time zone rule for standard time, for the PC's local time. Formatted as RRULE:FREQ=YEARLY;WKST=MO;INTERVAL=1;BYMONTH=3;BYDAY=4SU
    btzu The time zone rule for summer time, for the PC's local time. Formatted as RRULE:FREQ=YEARLY;WKST=MO;INTERVAL=1;BYMONTH=10;BYDAY=4SU
    buid Unique ID created for iCal. SerialnoDfollowupIdDinvitedId (where D is a separator). For example, 1010000014D345D971. Only for follow-ups with several participants.
    Company Card
    addr Postal address line 1. If this is empty, street address line 1.
    busi Business.
    cate Category.
    ccid Company's country code.
    cicn Country name in English.
    city Postal town.
    cnt? Country if different from the sender's country. For Germany in capitals.
    cntr Country. For Germany in capitals.
    cnty County (for UK addresses).
    code Code.
    cont Our contact.
    cozg Line feed for internal post in Germany.
    cozi Postcode including country prefix (e.g. N-0163 for a postcode in Norway). Prefix is not used for Germany.
    cozn Line feed for Australian and UK treatment of counties and postcodes.
    cphi Company's phone number, ID (hidden, unique ID).
    cpho Company's phone number.
    cs01-49 User-defined field 1-49 of the text type.
    cf01-10 User-defined field 1-10 of the decimal number type.
    cl01-60 User-defined field 1-60 of the whole number type.
    cszc Postal town, state/province and zipcode (for American, Canadian and Australian addresses, e.g. Bedford, MA 01730).
    cuid Company ID (hidden, unique ID).
    cwwi The company's primary web address, ID (hidden, unique ID).
    cwww The company's primary web address.
    czip County and postcode (for UK addresses).
    dept Department.
    faxi Fax number, ID (hidden, unique ID).
    faxn Fax number. The contact's direct number, if available. Otherwise the company's fax number.
    faxs Fax number. The contact's direct number, if available. Otherwise the company's fax number. Without spaces.
    maii The company's primary e-mail address, ID (hidden, unique ID).
    mail The company's primary e-mail address.
    name The company's name.
    numb Number.
    orgn The company's organisation number.
    padr Postal address, line 1.
    pad2 Postal address, line 2.
    pad3 Postal address, line 3.
    phoi Phone number, ID (hidden, unique ID).
    phon Phone number. The contact's direct number, if available. Otherwise the company's phone number.
    sadr Street address/office address, address line 1.
    sams First address line, including Mail Stop (for American addresses).
    scit Postal town for street address (for German addresses).
    ssta State/province for street address (for American, Canadian and Australian addresses).
    stat State/province (for American, Canadian and Australian addresses). (See also cszc.)
    szip Postcode for street address (for German addresses).
    zici Postcode and postal town (e.g. 0572 OSLO).
    zino Postcode prefix.
    zipc Postcode. (See also cszc.)
    zipp Postcode for street address.
    Document dialog or from the system
    apid Appointment ID.
    atti Title of the contact the document will be sent to.
    attn Selected contact in the Document dialog or text that is specified in the Company field for a recipient of the document.
    date Date in long format, e.g. 10 December 2004.
    desc Description of the created document.
    df01-10 User-defined field 1-10 of the decimal number type.
    dl01-60 User-defined field 1-60 of the whole number type.
    doid Document ID (hidden, unique ID).
    dope Document, end date for publishing.
    dops Document, start date for publishing.
    ds01-49 User-defined field 1-49 of the text type.
    dsug The document's SuggestedDocument Id. 0 when appointment is not part of a sale/project guide.
    file Name of the document, without the path (e.g.SuperO-Inc.-Offer.DOC).
    head The heading for the created document.
    lang The language being used in Sales & Marketing.
    ltim Time in long format, e.g. 12:10:05.
    oref Our reference.
    pltf Which platform, win or web
    ptha SOARC path (from SuperOffice.ini).
    pthi Path to the folder where SuperOffice.ini is located.
    pthp Path to the folder where Sales & Marketing is installed.
    salu Salutation as entered, or created automatically from the contact (Mr/Ms and last name).
    sdat Date in short format, e.g. 10.12.11.
    ser# SuperOffice CRM database's serial number.
    snum Ascending serial number (different for every template).
    time Time in short format, e.g. 12:10.
    ver# Sales & Marketing's version number.
    yref Your reference.
    International addresses

    Formatting here is based on the databasetable addressformat.labelLayout linked to the country.

    fad1 Line 1 in international addresses.
    fad2 Line 2 in international addresses.
    fad3 Line 3 in international addresses.
    fad4 Line 4 in international addresses.
    fad5 Line 5 in international addresses.
    fad6 Line 6 in international addresses.
    fad7 Line 7 in international addresses.
    fad8 Line 8 in international addresses.
    fad9 Line 9 in international addresses.
    fada Line 10 in international addresses.
    fadb Line 11 in international addresses.
    fadc Line 12 in international addresses.
    fadd Line 13 in international addresses.
    fade Line 14 in international addresses.
    fadf Line 15 in international addresses.
    fadg Line 16 in international addresses.
    fadh Line 17 in international addresses.
    fadi Line 18 in international addresses.
    fadj Line 19 in international addresses.
    fadk Line 20 in international addresses.
    fadl Line 21 in international addresses.
    fadm Line 22 in international addresses.
    fadn Line 23 in international addresses.
    fado Line 24 in international addresses.

    atit Sender's title. auac The sender's academic title aubd Date of birth. auca The senders chat address aucd The senders chat address, ID (hidden, unique ID). auci Postal town. (See also aucs.) aucn Country. aucp The senders chat address protocol aucs Postal town, state/province and zipcode (for American, Canadian and Australian addresses, e.g. Bedford, MA 01730). aucy County (for UK addresses). audf Direct fax number. audp Direct phone number. auem E-mail. auid Sender's contact ID (hidden, unique ID). aumr Mr/Ms for sender aums Mail Stop (for American addresses). aunm Number recorded for the document's owner. aup1 Sender's postal address, line 1. aup2 Sender's postal address, line 2. aup3 Sender's postal address, line 3. aupc Mobile phone. auph Home telephone. aupo Position. aupp Other phone (Was Pager before 7.0) // Changed in 7.0 aust State/province (for American, Canadian and Australian addresses). (See also aucs.) auth Sender's first name and last name. auvo The senders voip address auvi The senders voip address, ID (hidden, unique ID). auvs The senders voip service (description) auwi The senders's primary web address, ID (hidden, unique ID). auww The senders's primary web address. auzi Postcode. (See also aucs.) uf01-10 User-defined field 1-10 of the decimal number type. ul01-60 User-defined field 1-60 of the whole number type. us01-49 User-defined field 1-49 of the text type.