Avancerade bekräftelser med taggar
Här finns en lista på de möjliga bekräftelsetaggar som går att använda i skapandet av avancerade bekräftelser.
Notera att detta är ett avancerat område som av användare kan komma att kräva kunskaper i att hantera tabeller i HTML, utbildning i hur Delegia använder ID-nummer för aktiviter, hotell, frågor och seminarier samt en grundläggande förståelse för databashantering.
Exempel på hur taggarna kan användas:
|
Det här är utan confirmationbody!
Lite info om personen...
[PersonFirstName] [PersonLastName] [Personemail] du har köpt [ProductSum-Quantity] st
registeredid: [RegisteredId]
Och om han har Fakturaföretag så är det [InvoiceCompanyName]
finns det ett altföretag så är det [AltCompanyName]
första personen i din grupp är [P1_PersonFirstName] |
Orderrader
|
Beskrivning |
Pris |
Moms |
antal |
Total |
|
|
[OrderRow][HIDE:11330] |
[SeminarNameLong] |
[Amount] |
[VATAmount] |
[Quantity] |
[RowTotal] |
|
[Sum-Amount] |
[Sum-VATAmount] |
[Sum-Quantity] |
[Sum-RowTotal] |
Dina aktiviteter
|
[ActivityRow] |
[SeminarNameLong] |
[Amount] |
[VATAmount] |
[RowTotal] |
|
[ActivitySum-Amount] |
[ActivitySum-VATAmount] |
[ActivitySum-RowTotal] |
Dina Hotell
|
[HotelRow] |
[SeminarNameLong] |
[Amount] |
[VATAmount] |
[RowTotal] |
|
|
[HotelSum-Amount] |
[HotelSum-VATAmount] |
[HotelSum-RowTotal] |
[HotelRowSum] = Denna tagg kan användas i kombination med [HotelRow] för att summera hela hotellvistelsen.
[HotelRow] = Denna tagg specificerar varje hotellnatt för sig.
Båda dessa taggar måste användas i kombination med andra taggar som tar fram den data du vill visa, se tabell ovan.
Exempel: (Taggarna måste ligga i samma cell/grid för att de ska fungera.
|
Hotellets namn: [HotelRow][HotelRowSum] [SeminarNameLong]
Ankomstdag: [HotelArrivalDate] |
Dina produkter
|
[ProductRow] |
[SeminarNameLong] |
[Amount] |
[VATAmount] |
[RowTotal] |
|
[ProductSum-Amount] |
[ProductSum-VATAmount] |
[ProductSum-RowTotal] |
Frågor
Du kan ange ett specifikt svar på en fråga genom att använda taggen: [Question:xxxxxx] xxxx byts ut mot det id nr som anges på frågan du vill visa svaret på. Se exempel i tabellen nedan. För att visa svar på en fråga med radioknappar behövs även [AnswerLabel] finnas med, utöver [AnswerText] som visar svar på fritextfrågor.
|
[QuestionRow] |
[QuestionLabel] |
[AnswerText][AnswerLabel] |
[Label] [Intro] |
Mat allergi: | [Question:167845] |
Din grupp
|
[GroupRow] |
[GroupPersonFirstName] [GroupPersonLastName] |
[GroupPersonemail] |
[GroupCompanyName] |
Speciell information bara för person 1 i gruppregistrering
Den här taggen visar enbart information för person 1 i gruppanmälningar. Detta kan användas då du vill att enbart person 1 ska se exempelvis kostnad, faktureringsadress, specialinformation om eventet eller dylikt. Båda taggarna måste finnas med, och mellan dem ska texten/taggarna som bara person 1 ska se skrivas in. Se exemplet nedan.
[ShowOnlyForP1]
Texten/taggarna som person 1 ska se men inte de andra.
[/ShowOnlyForP1]
Person and registration
[RegisteredId]
[projectId]
[BadgeNoMiddle]
[PersonId]
[OrderGroupId]
[RegistrationType]
[RegistrationTypeName]
[RegistrationStatus]
[ReglineNo]
[RegistrationLanguageId]
[RePrints]
[MailConfirmationReadDate]
[InvitationDate]
[InvitationReadDate]
[AcceptedDeniedDate]
[InputStation]
[InputStart]
[InputStop]
[UpdateSource]
[UpdateDate]
[UpdateBy]
[Browser]
[ScreenWidth]
[Source]
[RegDate]
[UpdateUserId]
[RemoteAddr]
[PersonId]
[CompanyId]
[PersonPrefix]
[PersonFirstName]
[PersonMiddleName]
[PersonLastName]
[PersonSuffix]
[PersonTitle]
[PersonAddress1]
[PersonAddress2]
[PersonDepartment]
[PersonZip]
[PersonCity]
[PersonCountryId]
[PersonTelephone1]
[PersonTelephone2]
[PersonTelephone3]
[PersonTelephone4]
[Personemail]
[PersonInfo]
[PersonCreateDate]
[PersonUpdateDate]
[PersonPoliticalPartyId]
[PersonAgencyId]
[PersonComment]
[PersonPassword]
[PersonUsername]
[UpdateUserId]
[RemoteAddr]
[CompanyId]
[CompanyName]
[CompanyAddress1]
[CompanyAddress2]
[CompanyVisitorAddress]
[CompanyZip]
[CompanyCity]
[CompanyStateId]
[Country]
[Companyorgno]
[CompanyTelephone]
[CompanyTelefax]
[CompanyEmail]
[CompanyUrl]
[CompanyCreateDate]
[CompanyUpdateDate]
[UpdateUserId]
[RemoteAddr]
[CustomerGroupId]
[CompanyInvoiceId]
[SourceCompanyId]
[CountryId]
[Countrycode]
[CountryNumber]
[CountryNameSwe]
[CountryNameInt]
[VATArea]
Invoice company (Dessa taggar används för att visa fakturaadress i en bekräftelse)
[InvoiceRegisteredId]
[InvoiceprojectId]
[InvoiceBadgeNoMiddle]
[InvoicePersonId]
[InvoiceOrderGroupId]
[InvoiceRegistrationType]
[InvoiceRegistrationStatus]
[InvoiceReglineNo]
[InvoiceRegistrationLanguageId]
[InvoiceRePrints]
[InvoiceMailConfirmationReadDate]
[InvoiceInvitationDate]
[InvoiceInvitationReadDate]
[InvoiceAcceptedDeniedDate]
[InvoiceInputStation]
[InvoiceInputStart]
[InvoiceInputStop]
[InvoiceUpdateSource]
[InvoiceUpdateDate]
[InvoiceUpdateBy]
[InvoiceBrowser]
[InvoiceScreenWidth]
[InvoiceSource]
[InvoiceRegDate]
[InvoiceUpdateUserId]
[InvoiceRemoteAddr]
[InvoiceOrderId]
[InvoiceProjectId]
[InvoiceOrderGroupId]
[InvoicePersonId]
[InvoiceAltCompanyId]
[InvoiceInvoiceCompanyId]
[InvoiceTotalAmount]
[InvoiceVATAmount]
[InvoiceCurrency]
[InvoiceBalance]
[InvoiceComment]
[InvoiceStatus]
[InvoiceRequisitionNo]
[InvoiceOrderReference]
[InvoiceOrderDate]
[InvoiceOrderUpdateDate]
[InvoiceUpdateUserId]
[InvoiceRemoteAddr]
[InvoiceCompanyId]
[InvoiceCompanyName]
[InvoiceCompanyAddress1]
[InvoiceCompanyAddress2]
[InvoiceCompanyVisitorAddress]
[InvoiceCompanyZip]
[InvoiceCompanyCity]
[InvoiceCompanyStateId]
[InvoiceCompanyCountryId]
[InvoiceCompanyorgno]
[InvoiceCompanyTelephone]
[InvoiceCompanyTelefax]
[InvoiceCompanyEmail]
[InvoiceCompanyUrl]
[InvoiceCompanyCreateDate]
[InvoiceCompanyUpdateDate]
[InvoiceUpdateUserId]
[InvoiceRemoteAddr]
[InvoiceCustomerGroupId]
[InvoiceCompanyInvoiceId]
[InvoiceSourceCompanyId]
Alternative company
[AltRegisteredId]
[AltprojectId]
[AltBadgeNoMiddle]
[AltPersonId]
[AltOrderGroupId]
[AltRegistrationType]
[AltRegistrationStatus]
[AltReglineNo]
[AltRegistrationLanguageId]
[AltRePrints]
[AltMailConfirmationReadDate]
[AltInvitationDate]
[AltInvitationReadDate]
[AltAcceptedDeniedDate]
[AltInputStation]
[AltInputStart]
[AltInputStop]
[AltUpdateSource]
[AltUpdateDate]
[AltUpdateBy]
[AltBrowser]
[AltScreenWidth]
[AltSource]
[AltRegDate]
[AltUpdateUserId]
[AltRemoteAddr]
[AltOrderId]
[AltProjectId]
[AltOrderGroupId]
[AltPersonId]
[AltAltCompanyId]
[AltInvoiceCompanyId]
[AltTotalAmount]
[AltVATAmount]
[AltCurrency]
[AltBalance]
[AltComment]
[AltStatus]
[AltRequisitionNo]
[AltOrderReference]
[AltOrderDate]
[AltOrderUpdateDate]
[AltUpdateUserId]
[AltRemoteAddr]
[AltCompanyId]
[AltCompanyName]
[AltCompanyAddress1]
[AltCompanyAddress2]
[AltCompanyVisitorAddress]
[AltCompanyZip]
[AltCompanyCity]
[AltCompanyStateId]
[AltCompanyCountryId]
[AltCompanyorgno]
[AltCompanyTelephone]
[AltCompanyTelefax]
[AltCompanyEmail]
[AltCompanyUrl]
[AltCompanyCreateDate]
[AltCompanyUpdateDate]
[AltUpdateUserId]
[AltRemoteAddr]
[AltCustomerGroupId]
[AltCompanyInvoiceId]
[AltSourceCompanyId]
Order rows [OrderRow]
[SeminarId] [Sum-SeminarId]
[ProjectId] [Sum-ProjectId]
[ItemType] [Sum-ItemType]
[UnderType] [Sum-UnderType]
[SeminarGroup] [Sum-SeminarGroup]
[SeminarGroupId] [Sum-SeminarGroupId]
[SortOrder] [Sum-SortOrder]
[SeminarNo] [Sum-SeminarNo]
[SeminarNameLong] [Sum-SeminarNameLong]
[SeminarNameShort] [Sum-SeminarNameShort]
[SeminarDescrShort] [Sum-SeminarDescrShort]
[SeminarDescrLong] [Sum-SeminarDescrLong]
[SeminarOrganizer] [Sum-SeminarOrganizer]
[SeminarSpeaker] [Sum-SeminarSpeaker]
[SeminarSpeakerInfo] [Sum-SeminarSpeakerInfo]
[SeminarDate] [Sum-SeminarDate]
[SeminarTimeStart] [Sum-SeminarTimeStart]
[SeminarTimeEnd] [Sum-SeminarTimeEnd]
[DepartureCity] [Sum-DepartureCity]
[ArrivalCity] [Sum-ArrivalCity]
[SeminarLanguage] [Sum-SeminarLanguage]
[SeminarOrderDeadline] [Sum-SeminarOrderDeadline]
[BadgeCode] [Sum-BadgeCode]
[Status] [Sum-Status]
[SeminarActive] [Sum-SeminarActive]
[SeminarClosed] [Sum-SeminarClosed]
[SeminarCancelled] [Sum-SeminarCancelled]
[PreChecked] [Sum-PreChecked]
[Minimum] [Sum-Minimum]
[SeminarSeats] [Sum-SeminarSeats]
[SeminarPrice] [Sum-SeminarPrice]
[VATPercent] [Sum-VATPercent]
[RoomLastCancelDate] [Sum-RoomLastCancelDate]
[InternalNote] [Sum-InternalNote]
[UserId] [Sum-UserId]
[Account] [Sum-Account]
[Responsibility] [Sum-Responsibility]
[Mission] [Sum-Mission]
[AccountFlag] [Sum-AccountFlag]
[OrgSection] [Sum-OrgSection]
[FieldArea] [Sum-FieldArea]
[City] [Sum-City]
[Room] [Sum-Room]
[Administrator] [Sum-Administrator]
[Extra1] [Sum-Extra1]
[Extra2] [Sum-Extra2]
[Extra3] [Sum-Extra3]
[InsertDate] [Sum-InsertDate]
[UpdateDate] [Sum-UpdateDate]
[Decide] [Sum-Decide]
[BreakfastPrice] [Sum-BreakfastPrice]
[WaitingList] [Sum-WaitingList]
[ActiveAnswer] [Sum-ActiveAnswer]
[Hide] [Sum-Hide]
[OrderRowId] [Sum-OrderRowId]
[OrderId] [Sum-OrderId]
[SeminarId] [Sum-SeminarId]
[Status] [Sum-Status]
[StatusConfirmedDateTime] [Sum-StatusConfirmedDateTime]
[Rebate] [Sum-Rebate]
[Quantity] [Sum-Quantity]
[Amount] [Sum-Amount]
[VATAmount] [Sum-VATAmount]
[Balance] [Sum-Balance]
[HotelArrivalDate] [Sum-HotelArrivalDate]
[HotelDepartureDate] [Sum-HotelDepartureDate]
[Comment] [Sum-Comment]
[RowNotified] [Sum-RowNotified]
[RowNotifiedDateTime] [Sum-RowNotifiedDateTime]
[RowInvoiced] [Sum-RowInvoiced]
[RowInvoicedDateTime] [Sum-RowInvoicedDateTime]
[UpdateUserId] [Sum-UpdateUserId]
[RemoteAddr] [Sum-RemoteAddr]
[OrderId] [Sum-OrderId]
[ProjectId] [Sum-ProjectId]
[OrderGroupId] [Sum-OrderGroupId]
[PersonId] [Sum-PersonId]
[AltCompanyId] [Sum-AltCompanyId]
[InvoiceCompanyId] [Sum-InvoiceCompanyId]
[TotalAmount] [Sum-TotalAmount]
[VATAmount] [Sum-VATAmount]
[Currency] [Sum-Currency]
[Balance] [Sum-Balance]
[Comment] [Sum-Comment]
[Status] [Sum-Status]
[RequisitionNo] [Sum-RequisitionNo]
[OrderReference] [Sum-OrderReference]
[OrderDate] [Sum-OrderDate]
[OrderUpdateDate] [Sum-OrderUpdateDate]
[UpdateUserId] [Sum-UpdateUserId]
[RemoteAddr] [Sum-RemoteAddr]
[RowTotal] [Sum-RowTotal]
Activity rows [ActivityRow]
[SeminarId] [ActivitySum-SeminarId]
[ProjectId] [ActivitySum-ProjectId]
[ItemType] [ActivitySum-ItemType]
[UnderType] [ActivitySum-UnderType]
[SeminarGroup] [ActivitySum-SeminarGroup]
[SeminarGroupId] [ActivitySum-SeminarGroupId]
[SortOrder] [ActivitySum-SortOrder]
[SeminarNo] [ActivitySum-SeminarNo]
[SeminarNameLong] [ActivitySum-SeminarNameLong]
[SeminarNameShort] [ActivitySum-SeminarNameShort]
[SeminarDescrShort] [ActivitySum-SeminarDescrShort]
[SeminarDescrLong] [ActivitySum-SeminarDescrLong]
[SeminarOrganizer] [ActivitySum-SeminarOrganizer]
[SeminarSpeaker] [ActivitySum-SeminarSpeaker]
[SeminarSpeakerInfo] [ActivitySum-SeminarSpeakerInfo]
[SeminarDate] [ActivitySum-SeminarDate]
[SeminarTimeStart] [ActivitySum-SeminarTimeStart]
[SeminarTimeEnd] [ActivitySum-SeminarTimeEnd]
[DepartureCity] [ActivitySum-DepartureCity]
[ArrivalCity] [ActivitySum-ArrivalCity]
[SeminarLanguage] [ActivitySum-SeminarLanguage]
[SeminarOrderDeadline] [ActivitySum-SeminarOrderDeadline]
[BadgeCode] [ActivitySum-BadgeCode]
[Status] [ActivitySum-Status]
[SeminarActive] [ActivitySum-SeminarActive]
[SeminarClosed] [ActivitySum-SeminarClosed]
[SeminarCancelled] [ActivitySum-SeminarCancelled]
[PreChecked] [ActivitySum-PreChecked]
[Minimum] [ActivitySum-Minimum]
[SeminarSeats] [ActivitySum-SeminarSeats]
[SeminarPrice] [ActivitySum-SeminarPrice]
[VATPercent] [ActivitySum-VATPercent]
[RoomLastCancelDate] [ActivitySum-RoomLastCancelDate]
[InternalNote] [ActivitySum-InternalNote]
[UserId] [ActivitySum-UserId]
[Account] [ActivitySum-Account]
[Responsibility] [ActivitySum-Responsibility]
[Mission] [ActivitySum-Mission]
[AccountFlag] [ActivitySum-AccountFlag]
[OrgSection] [ActivitySum-OrgSection]
[FieldArea] [ActivitySum-FieldArea]
[City] [ActivitySum-City]
[Room] [ActivitySum-Room]
[Administrator] [ActivitySum-Administrator]
[Extra1] [ActivitySum-Extra1]
[Extra2] [ActivitySum-Extra2]
[Extra3] [ActivitySum-Extra3]
[InsertDate] [ActivitySum-InsertDate]
[UpdateDate] [ActivitySum-UpdateDate]
[Decide] [ActivitySum-Decide]
[BreakfastPrice] [ActivitySum-BreakfastPrice]
[WaitingList] [ActivitySum-WaitingList]
[ActiveAnswer] [ActivitySum-ActiveAnswer]
[Hide] [ActivitySum-Hide]
[OrderRowId] [ActivitySum-OrderRowId]
[OrderId] [ActivitySum-OrderId]
[SeminarId] [ActivitySum-SeminarId]
[Status] [ActivitySum-Status]
[StatusConfirmedDateTime] [ActivitySum-StatusConfirmedDateTime]
[Rebate] [ActivitySum-Rebate]
[Quantity] [ActivitySum-Quantity]
[Amount] [ActivitySum-Amount]
[VATAmount] [ActivitySum-VATAmount]
[Balance] [ActivitySum-Balance]
[HotelArrivalDate] [ActivitySum-HotelArrivalDate]
[HotelDepartureDate] [ActivitySum-HotelDepartureDate]
[Comment] [ActivitySum-Comment]
[RowNotified] [ActivitySum-RowNotified]
[RowNotifiedDateTime] [ActivitySum-RowNotifiedDateTime]
[RowInvoiced] [ActivitySum-RowInvoiced]
[RowInvoicedDateTime] [ActivitySum-RowInvoicedDateTime]
[UpdateUserId] [ActivitySum-UpdateUserId]
[RemoteAddr] [ActivitySum-RemoteAddr]
[OrderId] [ActivitySum-OrderId]
[ProjectId] [ActivitySum-ProjectId]
[OrderGroupId] [ActivitySum-OrderGroupId]
[PersonId] [ActivitySum-PersonId]
[AltCompanyId] [ActivitySum-AltCompanyId]
[InvoiceCompanyId] [ActivitySum-InvoiceCompanyId]
[TotalAmount] [ActivitySum-TotalAmount]
[VATAmount] [ActivitySum-VATAmount]
[Currency] [ActivitySum-Currency]
[Balance] [ActivitySum-Balance]
[Comment] [ActivitySum-Comment]
[Status] [ActivitySum-Status]
[RequisitionNo] [ActivitySum-RequisitionNo]
[OrderReference] [ActivitySum-OrderReference]
[OrderDate] [ActivitySum-OrderDate]
[OrderUpdateDate] [ActivitySum-OrderUpdateDate]
[UpdateUserId] [ActivitySum-UpdateUserId]
[RemoteAddr] [ActivitySum-RemoteAddr]
[RowTotal] [ActivitySum-RowTotal]
[SeminarImage] <--- Om det finns en bild tillagd på aktiviteten så blir den här taggen bildens URL. För att lägga till en synlig bild - klicka på lägg till bild och skriv taggen i URL fältet.
Hotel rows [HotelRow]
[SeminarId] [HotelSum-SeminarId]
[ProjectId] [HotelSum-ProjectId]
[ItemType] [HotelSum-ItemType]
[UnderType] [HotelSum-UnderType]
[SeminarGroup] [HotelSum-SeminarGroup]
[SeminarGroupId] [HotelSum-SeminarGroupId]
[SortOrder] [HotelSum-SortOrder]
[SeminarNo] [HotelSum-SeminarNo]
[SeminarNameLong] [HotelSum-SeminarNameLong]
[SeminarNameShort] [HotelSum-SeminarNameShort]
[SeminarDescrShort] [HotelSum-SeminarDescrShort]
[SeminarDescrLong] [HotelSum-SeminarDescrLong]
[SeminarOrganizer] [HotelSum-SeminarOrganizer]
[SeminarSpeaker] [HotelSum-SeminarSpeaker]
[SeminarSpeakerInfo] [HotelSum-SeminarSpeakerInfo]
[SeminarDate] [HotelSum-SeminarDate]
[SeminarTimeStart] [HotelSum-SeminarTimeStart]
[SeminarTimeEnd] [HotelSum-SeminarTimeEnd]
[DepartureCity] [HotelSum-DepartureCity]
[ArrivalCity] [HotelSum-ArrivalCity]
[SeminarLanguage] [HotelSum-SeminarLanguage]
[SeminarOrderDeadline] [HotelSum-SeminarOrderDeadline]
[BadgeCode] [HotelSum-BadgeCode]
[Status] [HotelSum-Status]
[SeminarActive] [HotelSum-SeminarActive]
[SeminarClosed] [HotelSum-SeminarClosed]
[SeminarCancelled] [HotelSum-SeminarCancelled]
[PreChecked] [HotelSum-PreChecked]
[Minimum] [HotelSum-Minimum]
[SeminarSeats] [HotelSum-SeminarSeats]
[SeminarPrice] [HotelSum-SeminarPrice]
[VATPercent] [HotelSum-VATPercent]
[RoomLastCancelDate] [HotelSum-RoomLastCancelDate]
[InternalNote] [HotelSum-InternalNote]
[UserId] [HotelSum-UserId]
[Account] [HotelSum-Account]
[Responsibility] [HotelSum-Responsibility]
[Mission] [HotelSum-Mission]
[AccountFlag] [HotelSum-AccountFlag]
[OrgSection] [HotelSum-OrgSection]
[FieldArea] [HotelSum-FieldArea]
[City] [HotelSum-City]
[Room] [HotelSum-Room]
[Administrator] [HotelSum-Administrator]
[Extra1] [HotelSum-Extra1]
[Extra2] [HotelSum-Extra2]
[Extra3] [HotelSum-Extra3]
[InsertDate] [HotelSum-InsertDate]
[UpdateDate] [HotelSum-UpdateDate]
[Decide] [HotelSum-Decide]
[BreakfastPrice] [HotelSum-BreakfastPrice]
[WaitingList] [HotelSum-WaitingList]
[ActiveAnswer] [HotelSum-ActiveAnswer]
[Hide] [HotelSum-Hide]
[OrderRowId] [HotelSum-OrderRowId]
[OrderId] [HotelSum-OrderId]
[SeminarId] [HotelSum-SeminarId]
[Status] [HotelSum-Status]
[StatusConfirmedDateTime] [HotelSum-StatusConfirmedDateTime]
[Rebate] [HotelSum-Rebate]
[Quantity] [HotelSum-Quantity]
[Amount] [HotelSum-Amount]
[VATAmount] [HotelSum-VATAmount]
[Balance] [HotelSum-Balance]
[HotelArrivalDate] [HotelSum-HotelArrivalDate]
[HotelDepartureDate] [HotelSum-HotelDepartureDate]
[Comment] [HotelSum-Comment]
[RowNotified] [HotelSum-RowNotified]
[RowNotifiedDateTime] [HotelSum-RowNotifiedDateTime]
[RowInvoiced] [HotelSum-RowInvoiced]
[RowInvoicedDateTime] [HotelSum-RowInvoicedDateTime]
[UpdateUserId] [HotelSum-UpdateUserId]
[RemoteAddr] [HotelSum-RemoteAddr]
[OrderId] [HotelSum-OrderId]
[ProjectId] [HotelSum-ProjectId]
[OrderGroupId] [HotelSum-OrderGroupId]
[PersonId] [HotelSum-PersonId]
[AltCompanyId] [HotelSum-AltCompanyId]
[InvoiceCompanyId] [HotelSum-InvoiceCompanyId]
[TotalAmount] [HotelSum-TotalAmount]
[VATAmount] [HotelSum-VATAmount]
[Currency] [HotelSum-Currency]
[Balance] [HotelSum-Balance]
[Comment] [HotelSum-Comment]
[Status] [HotelSum-Status]
[RequisitionNo] [HotelSum-RequisitionNo]
[OrderReference] [HotelSum-OrderReference]
[OrderDate] [HotelSum-OrderDate]
[OrderUpdateDate] [HotelSum-OrderUpdateDate]
[UpdateUserId] [HotelSum-UpdateUserId]
[RemoteAddr] [HotelSum-RemoteAddr]
[RowTotal] [HotelSum-RowTotal]
Product rows [ProductRow]
[SeminarId] [ProductSum-SeminarId]
[ProjectId] [ProductSum-ProjectId]
[ItemType] [ProductSum-ItemType]
[UnderType] [ProductSum-UnderType]
[SeminarGroup] [ProductSum-SeminarGroup]
[SeminarGroupId] [ProductSum-SeminarGroupId]
[SortOrder] [ProductSum-SortOrder]
[SeminarNo] [ProductSum-SeminarNo]
[SeminarNameLong] [ProductSum-SeminarNameLong]
[SeminarNameShort] [ProductSum-SeminarNameShort]
[SeminarDescrShort] [ProductSum-SeminarDescrShort]
[SeminarDescrLong] [ProductSum-SeminarDescrLong]
[SeminarOrganizer] [ProductSum-SeminarOrganizer]
[SeminarSpeaker] [ProductSum-SeminarSpeaker]
[SeminarSpeakerInfo] [ProductSum-SeminarSpeakerInfo]
[SeminarDate] [ProductSum-SeminarDate]
[SeminarTimeStart] [ProductSum-SeminarTimeStart]
[SeminarTimeEnd] [ProductSum-SeminarTimeEnd]
[DepartureCity] [ProductSum-DepartureCity]
[ArrivalCity] [ProductSum-ArrivalCity]
[SeminarLanguage] [ProductSum-SeminarLanguage]
[SeminarOrderDeadline] [ProductSum-SeminarOrderDeadline]
[BadgeCode] [ProductSum-BadgeCode]
[Status] [ProductSum-Status]
[SeminarActive] [ProductSum-SeminarActive]
[SeminarClosed] [ProductSum-SeminarClosed]
[SeminarCancelled] [ProductSum-SeminarCancelled]
[PreChecked] [ProductSum-PreChecked]
[Minimum] [ProductSum-Minimum]
[SeminarSeats] [ProductSum-SeminarSeats]
[SeminarPrice] [ProductSum-SeminarPrice]
[VATPercent] [ProductSum-VATPercent]
[RoomLastCancelDate] [ProductSum-RoomLastCancelDate]
[InternalNote] [ProductSum-InternalNote]
[UserId] [ProductSum-UserId]
[Account] [ProductSum-Account]
[Responsibility] [ProductSum-Responsibility]
[Mission] [ProductSum-Mission]
[AccountFlag] [ProductSum-AccountFlag]
[OrgSection] [ProductSum-OrgSection]
[FieldArea] [ProductSum-FieldArea]
[City] [ProductSum-City]
[Room] [ProductSum-Room]
[Administrator] [ProductSum-Administrator]
[Extra1] [ProductSum-Extra1]
[Extra2] [ProductSum-Extra2]
[Extra3] [ProductSum-Extra3]
[InsertDate] [ProductSum-InsertDate]
[UpdateDate] [ProductSum-UpdateDate]
[Decide] [ProductSum-Decide]
[BreakfastPrice] [ProductSum-BreakfastPrice]
[WaitingList] [ProductSum-WaitingList]
[ActiveAnswer] [ProductSum-ActiveAnswer]
[Hide] [ProductSum-Hide]
[OrderRowId] [ProductSum-OrderRowId]
[OrderId] [ProductSum-OrderId]
[SeminarId] [ProductSum-SeminarId]
[Status] [ProductSum-Status]
[StatusConfirmedDateTime] [ProductSum-StatusConfirmedDateTime]
[Rebate] [ProductSum-Rebate]
[Quantity] [ProductSum-Quantity]
[Amount] [ProductSum-Amount]
[VATAmount] [ProductSum-VATAmount]
[Balance] [ProductSum-Balance]
[HotelArrivalDate] [ProductSum-HotelArrivalDate]
[HotelDepartureDate] [ProductSum-HotelDepartureDate]
[Comment] [ProductSum-Comment]
[RowNotified] [ProductSum-RowNotified]
[RowNotifiedDateTime] [ProductSum-RowNotifiedDateTime]
[RowInvoiced] [ProductSum-RowInvoiced]
[RowInvoicedDateTime] [ProductSum-RowInvoicedDateTime]
[UpdateUserId] [ProductSum-UpdateUserId]
[RemoteAddr] [ProductSum-RemoteAddr]
[OrderId] [ProductSum-OrderId]
[ProjectId] [ProductSum-ProjectId]
[OrderGroupId] [ProductSum-OrderGroupId]
[PersonId] [ProductSum-PersonId]
[AltCompanyId] [ProductSum-AltCompanyId]
[InvoiceCompanyId] [ProductSum-InvoiceCompanyId]
[TotalAmount] [ProductSum-TotalAmount]
[VATAmount] [ProductSum-VATAmount]
[Currency] [ProductSum-Currency]
[Balance] [ProductSum-Balance]
[Comment] [ProductSum-Comment]
[Status] [ProductSum-Status]
[RequisitionNo] [ProductSum-RequisitionNo]
[OrderReference] [ProductSum-OrderReference]
[OrderDate] [ProductSum-OrderDate]
[OrderUpdateDate] [ProductSum-OrderUpdateDate]
[UpdateUserId] [ProductSum-UpdateUserId]
[RemoteAddr] [ProductSum-RemoteAddr]
[RowTotal] [ProductSum-RowTotal]
Group rows [GroupRow]
[RegisteredId] [GroupSum-RegisteredId]
[projectId] [GroupSum-projectId]
[BadgeNoMiddle] [GroupSum-BadgeNoMiddle]
[BadgeGUID] [GroupBadgeGUID]
[PersonId] [GroupSum-PersonId]
[OrderGroupId] [GroupSum-OrderGroupId]
[RegistrationType] [GroupSum-RegistrationType]
[RegistrationStatus] [GroupSum-RegistrationStatus]
[ReglineNo] [GroupSum-ReglineNo]
[RegistrationLanguageId] [GroupSum-RegistrationLanguageId]
[RePrints] [GroupSum-RePrints]
[MailConfirmationReadDate] [GroupSum-MailConfirmationReadDate]
[InvitationDate] [GroupSum-InvitationDate]
[InvitationReadDate] [GroupSum-InvitationReadDate]
[AcceptedDeniedDate] [GroupSum-AcceptedDeniedDate]
[InputStation] [GroupSum-InputStation]
[InputStart] [GroupSum-InputStart]
[InputStop] [GroupSum-InputStop]
[UpdateSource] [GroupSum-UpdateSource]
[UpdateDate] [GroupSum-UpdateDate]
[UpdateBy] [GroupSum-UpdateBy]
[Browser] [GroupSum-Browser]
[ScreenWidth] [GroupSum-ScreenWidth]
[Source] [GroupSum-Source]
[RegDate] [GroupSum-RegDate]
[UpdateUserId] [GroupSum-UpdateUserId]
[RemoteAddr] [GroupSum-RemoteAddr]
[PersonId] [GroupSum-PersonId]
[CompanyId] [GroupSum-CompanyId]
[PersonPrefix] [GroupSum-PersonPrefix]
[PersonFirstName] [GroupSum-PersonFirstName]
[PersonMiddleName] [GroupSum-PersonMiddleName]
[PersonLastName] [GroupSum-PersonLastName]
[PersonSuffix] [GroupSum-PersonSuffix]
[PersonTitle] [GroupSum-PersonTitle]
[PersonAddress1] [GroupSum-PersonAddress1]
[PersonAddress2] [GroupSum-PersonAddress2]
[PersonDepartment] [GroupSum-PersonDepartment]
[PersonZip] [GroupSum-PersonZip]
[PersonCity] [GroupSum-PersonCity]
[PersonCountryId] [GroupSum-PersonCountryId]
[PersonTelephone1] [GroupSum-PersonTelephone1]
[PersonTelephone2] [GroupSum-PersonTelephone2]
[PersonTelephone3] [GroupSum-PersonTelephone3]
[PersonTelephone4] [GroupSum-PersonTelephone4]
[Personemail] [GroupSum-Personemail]
[PersonInfo] [GroupSum-PersonInfo]
[PersonCreateDate] [GroupSum-PersonCreateDate]
[PersonUpdateDate] [GroupSum-PersonUpdateDate]
[PersonPoliticalPartyId] [GroupSum-PersonPoliticalPartyId]
[PersonAgencyId] [GroupSum-PersonAgencyId]
[PersonComment] [GroupSum-PersonComment]
[UpdateUserId] [GroupSum-UpdateUserId]
[RemoteAddr] [GroupSum-RemoteAddr]
[CompanyId] [GroupSum-CompanyId]
[CompanyName] [GroupSum-CompanyName]
[CompanyAddress1] [GroupSum-CompanyAddress1]
[CompanyAddress2] [GroupSum-CompanyAddress2]
[CompanyVisitorAddress] [GroupSum-CompanyVisitorAddress]
[CompanyZip] [GroupSum-CompanyZip]
[CompanyCity] [GroupSum-CompanyCity]
[CompanyStateId] [GroupSum-CompanyStateId]
[CompanyCountryId] [GroupSum-CompanyCountryId]
[Companyorgno] [GroupSum-Companyorgno]
[CompanyTelephone] [GroupSum-CompanyTelephone]
[CompanyTelefax] [GroupSum-CompanyTelefax]
[CompanyEmail] [GroupSum-CompanyEmail]
[CompanyUrl] [GroupSum-CompanyUrl]
[CompanyCreateDate] [GroupSum-CompanyCreateDate]
[CompanyUpdateDate] [GroupSum-CompanyUpdateDate]
[UpdateUserId] [GroupSum-UpdateUserId]
[RemoteAddr] [GroupSum-RemoteAddr]
[CustomerGroupId] [GroupSum-CustomerGroupId]
[CompanyInvoiceId] [GroupSum-CompanyInvoiceId]
[SourceCompanyId] [GroupSum-SourceCompanyId]
[CountryId] [GroupSum-CountryId]
[Countrycode] [GroupSum-Countrycode]
[CountryNumber] [GroupSum-CountryNumber]
[CountryNameSwe] [GroupSum-CountryNameSwe]
[CountryNameInt] [GroupSum-CountryNameInt]
[VATArea] [GroupSum-VATArea]
[OrderSumAmount] [GroupSum-OrderSumAmount]
[OrderSumVATAmount] [GroupSum-OrderSumVATAmount]
[OrderSumQuantity] [GroupSum-OrderSumQuantity]
[OrderSumRebate] [GroupSum-OrderSumRebate]
[OrderSumTotal] [GroupSum-OrderSumTotal]
[PersonId] [GroupSum-PersonId]
Question rows [QuestionRow]
[RegisteredId] [QuestionSum-RegisteredId]
[projectId] [QuestionSum-projectId]
[BadgeNoMiddle] [QuestionSum-BadgeNoMiddle]
[PersonId] [QuestionSum-PersonId]
[OrderGroupId] [QuestionSum-OrderGroupId]
[RegistrationType] [QuestionSum-RegistrationType]
[RegistrationStatus] [QuestionSum-RegistrationStatus]
[ReglineNo] [QuestionSum-ReglineNo]
[RegistrationLanguageId] [QuestionSum-RegistrationLanguageId]
[RePrints] [QuestionSum-RePrints]
[MailConfirmationReadDate] [QuestionSum-MailConfirmationReadDate]
[InvitationDate] [QuestionSum-InvitationDate]
[InvitationReadDate] [QuestionSum-InvitationReadDate]
[AcceptedDeniedDate] [QuestionSum-AcceptedDeniedDate]
[InputStation] [QuestionSum-InputStation]
[InputStart] [QuestionSum-InputStart]
[InputStop] [QuestionSum-InputStop]
[UpdateSource] [QuestionSum-UpdateSource]
[UpdateDate] [QuestionSum-UpdateDate]
[UpdateBy] [QuestionSum-UpdateBy]
[Browser] [QuestionSum-Browser]
[ScreenWidth] [QuestionSum-ScreenWidth]
[Source] [QuestionSum-Source]
[RegDate] [QuestionSum-RegDate]
[UpdateUserId] [QuestionSum-UpdateUserId]
[RemoteAddr] [QuestionSum-RemoteAddr]
[AnswerId] [QuestionSum-AnswerId]
[QuestionId] [QuestionSum-QuestionId]
[RegisteredId] [QuestionSum-RegisteredId]
[PersonId] [QuestionSum-PersonId]
[ExhibitorId] [QuestionSum-ExhibitorId]
[SurveyRecipientId] [QuestionSum-SurveyRecipientId]
[AnswerDate] [QuestionSum-AnswerDate]
[AnswerOptionId] [QuestionSum-AnswerOptionId]
[AnswerId] [QuestionSum-AnswerId]
[QuestionOptionId] [QuestionSum-QuestionOptionId]
[AnswerTextId] [QuestionSum-AnswerTextId]
[AnswerId] [QuestionSum-AnswerId]
[AnswerText] [QuestionSum-AnswerText]
[QuestionId] [QuestionSum-QuestionId]
[QuestionAreaId] [QuestionSum-QuestionAreaId]
[ColumnNo] [QuestionSum-ColumnNo]
[SortNo] [QuestionSum-SortNo]
[Active] [QuestionSum-Active]
[QuestionType] [QuestionSum-QuestionType]
[TextWidth] [QuestionSum-TextWidth]
[TextHeight] [QuestionSum-TextHeight]
[RequiredMin] [QuestionSum-RequiredMin]
[RequiredMax] [QuestionSum-RequiredMax]
[DependenceSeminarId] [QuestionSum-DependenceSeminarId]
[DependenceString] [QuestionSum-DependenceString]
[DependenceType] [QuestionSum-DependenceType]
[HeaderQuestion] [QuestionSum-HeaderQuestion]
[ShowInConfirmation] [QuestionSum-ShowInConfirmation]
[InsertDateTime] [QuestionSum-InsertDateTime]
[UpdateDateTime] [QuestionSum-UpdateDateTime]
[DependenceHide] [QuestionSum-DependenceHide]
[QuestionLabelLangId] [QuestionSum-QuestionLabelLangId]
[QuestionId] [QuestionSum-QuestionId]
[LanguageId] [QuestionSum-LanguageId]
[Label] [QuestionSum-Label]
[Intro] [QuestionSum-Intro]
[QuestionOptionLangId] [QuestionSum-QuestionOptionLangId]
[QuestionOptionId] [QuestionSum-QuestionOptionId]
[LanguageId] [QuestionSum-LanguageId]
[Label] [QuestionSum-Label]
[Intro] [QuestionSum-Intro]
[QuestionLabel] [QuestionSum-QuestionLabel]
[AnswerLabel] [QuestionSum-AnswerLabel]
Specific question [QuestionRow]
[QuestionId:QuestionId:RegisteredId]
[QuestionId:QuestionId:projectId]
[QuestionId:QuestionId:BadgeNoMiddle]
[QuestionId:QuestionId:PersonId]
[QuestionId:QuestionId:OrderGroupId]
[QuestionId:QuestionId:RegistrationType]
[QuestionId:QuestionId:RegistrationStatus]
[QuestionId:QuestionId:ReglineNo]
[QuestionId:QuestionId:RegistrationLanguageId]
[QuestionId:QuestionId:RePrints]
[QuestionId:QuestionId:MailConfirmationReadDate]
[QuestionId:QuestionId:InvitationDate]
[QuestionId:QuestionId:InvitationReadDate]
[QuestionId:QuestionId:AcceptedDeniedDate]
[QuestionId:QuestionId:InputStation]
[QuestionId:QuestionId:InputStart]
[QuestionId:QuestionId:InputStop]
[QuestionId:QuestionId:UpdateSource]
[QuestionId:QuestionId:UpdateDate]
[QuestionId:QuestionId:UpdateBy]
[QuestionId:QuestionId:Browser]
[QuestionId:QuestionId:ScreenWidth]
[QuestionId:QuestionId:Source]
[QuestionId:QuestionId:RegDate]
[QuestionId:QuestionId:UpdateUserId]
[QuestionId:QuestionId:RemoteAddr]
[QuestionId:QuestionId:AnswerId]
[QuestionId:QuestionId:QuestionId]
[QuestionId:QuestionId:RegisteredId]
[QuestionId:QuestionId:PersonId]
[QuestionId:QuestionId:ExhibitorId]
[QuestionId:QuestionId:SurveyRecipientId]
[QuestionId:QuestionId:AnswerDate]
[QuestionId:QuestionId:AnswerOptionId]
[QuestionId:QuestionId:AnswerId]
[QuestionId:QuestionId:QuestionOptionId]
[QuestionId:QuestionId:AnswerTextId]
[QuestionId:QuestionId:AnswerId]
[QuestionId:QuestionId:AnswerText]
[QuestionId:QuestionId:QuestionId]
[QuestionId:QuestionId:QuestionAreaId]
[QuestionId:QuestionId:ColumnNo]
[QuestionId:QuestionId:SortNo]
[QuestionId:QuestionId:Active]
[QuestionId:QuestionId:QuestionType]
[QuestionId:QuestionId:TextWidth]
[QuestionId:QuestionId:TextHeight]
[QuestionId:QuestionId:RequiredMin]
[QuestionId:QuestionId:RequiredMax]
[QuestionId:QuestionId:DependenceSeminarId]
[QuestionId:QuestionId:DependenceString]
[QuestionId:QuestionId:DependenceType]
[QuestionId:QuestionId:HeaderQuestion]
[QuestionId:QuestionId:ShowInConfirmation]
[QuestionId:QuestionId:InsertDateTime]
[QuestionId:QuestionId:UpdateDateTime]
[QuestionId:QuestionId:DependenceHide]
[QuestionId:QuestionId:QuestionLabelLangId]
[QuestionId:QuestionId:QuestionId]
[QuestionId:QuestionId:LanguageId]
[QuestionId:QuestionId:Label]
[QuestionId:QuestionId:Intro]
[QuestionId:QuestionId:QuestionOptionLangId]
[QuestionId:QuestionId:QuestionOptionId]
[QuestionId:QuestionId:LanguageId]
[QuestionId:QuestionId:Label]
[QuestionId:QuestionId:Intro]
[QuestionId:QuestionId:QuestionLabel]
[QuestionId:QuestionId:AnswerLabel]
First person in group
[P1_RegisteredId]
[P1_projectId]
[P1_BadgeNoMiddle]
[P1_PersonId]
[P1_OrderGroupId]
[P1_RegistrationType]
[P1_RegistrationStatus]
[P1_ReglineNo]
[P1_RegistrationLanguageId]
[P1_RePrints]
[P1_MailConfirmationReadDate]
[P1_InvitationDate]
[P1_InvitationReadDate]
[P1_AcceptedDeniedDate]
[P1_InputStation]
[P1_InputStart]
[P1_InputStop]
[P1_UpdateSource]
[P1_UpdateDate]
[P1_UpdateBy]
[P1_Browser]
[P1_ScreenWidth]
[P1_Source]
[P1_RegDate]
[P1_UpdateUserId]
[P1_RemoteAddr]
[P1_PersonId]
[P1_CompanyId]
[P1_PersonPrefix]
[P1_PersonFirstName]
[P1_PersonMiddleName]
[P1_PersonLastName]
[P1_PersonSuffix]
[P1_PersonTitle]
[P1_PersonAddress1]
[P1_PersonAddress2]
[P1_PersonDepartment]
[P1_PersonZip]
[P1_PersonCity]
[P1_PersonCountryId]
[P1_PersonTelephone1]
[P1_PersonTelephone2]
[P1_PersonTelephone3]
[P1_PersonTelephone4]
[P1_Personemail]
[P1_PersonInfo]
[P1_PersonCreateDate]
[P1_PersonUpdateDate]
[P1_PersonPoliticalPartyId]
[P1_PersonAgencyId]
[P1_PersonComment]
[P1_UpdateUserId]
[P1_RemoteAddr]
[P1_CompanyId]
[P1_CompanyName]
[P1_CompanyAddress1]
[P1_CompanyAddress2]
[P1_CompanyVisitorAddress]
[P1_CompanyZip]
[P1_CompanyCity]
[P1_CompanyStateId]
[P1_CompanyCountryId]
[P1_Companyorgno]
[P1_CompanyTelephone]
[P1_CompanyTelefax]
[P1_CompanyEmail]
[P1_CompanyUrl]
[P1_CompanyCreateDate]
[P1_CompanyUpdateDate]
[P1_UpdateUserId]
[P1_RemoteAddr]
[P1_CustomerGroupId]
[P1_CompanyInvoiceId]
[P1_SourceCompanyId]
[P1_CountryId]
[P1_Countrycode]
[P1_CountryNumber]
[P1_CountryNameSwe]
[P1_CountryNameInt]
[P1_VATArea]
Transaction [TransActionRow]
[VerificationId] [Sum-VerificationId]
[ProjectId] [Sum-ProjectId]
[PayMethod] [Sum-PayMethod]
[DibsTransactionNo] [Sum-DibsTransactionNo]
[LastFourDigits] [Sum-LastFourDigits]
[InsertDateTime] [Sum-InsertDateTime]
[Amount] [Sum-Amount]
[Currency] [Sum-Currency]
[Comment] [Sum-Comment]
[Account] [Sum-Account]
[UserId] [Sum-UserId]
[PayDateTime] [Sum-PayDateTime]