Old vs. New Print Template Merge Fields

Follow

The default print templates for ILLiad 8.1 and higher contain clearer names for the mail merge fields. For example, they use Transactions_TransactionNumber versus TRANSACTIO. A list of the old merge field names and their corresponding new field names are listed below.

Transactions Table Fields

Old Fields New Fields
TRANSACTIO Transactions_TransactionNumber
USERNAME Transactions_Username
REQUESTTYP Transactions_RequestType
LOANAUTHOR Transactions_LoanAuthor
LOANTITLE Transactions_LoanTitle
LOANPUBLIS Transactions_LoanPublisher
LOANPLACE Transactions_LoanPlace
LOANEDITION Transactions_LoanEdition
PHOTOJOURN Transactions_PhotoJournalTitle
PHOTOJOU_1 Transactions_PhotoJournalVolume
PHOTOJOU_2 Transactions_PhotoJournalIssue
PHOTOJOU_3 Transactions_PhotoJournalMonth
PHOTOJOU_4 Transactions_PhotoJournalYear
PHOTOJOU_5 Transactions_PhotoJournalInclusivePages
PHOTOARTIC Transactions_PhotoArticleAuthor
PHOTOART_1 Transactions_PhotoArticleTitle
CITEDIN Transactions_CitedIn
CITEDTITLE Transactions_CitedTitle
CITEDDATE

Transactions_CitedDate

CITEDVOLUM Transactions_CitedVolume
CITEDPAGES Transactions_CitedPages
NOTWANTEDA Transactions_NotWantedAfter
ACCEPTNONE Transactions_AcceptNonEnglish
ACCEPTALTE Transactions_AcceptAlternateEdition
TRANSACT_1 Transactions_TransactionStatus
TRANSACT_2 Transactions_TransactionDate
ISSN Transactions_ISSN
ILLNUMBER Transactions_ILLNumber
ESPNUMBER Transactions_ESPNumber
LENDINGSTR Transactions_LendingString
BASEFEE Transactions_BaseFee
PERPAGE Transactions_PerPage
PAGES Transactions_Pages
DUEDATE Transactions_DueDate
RENEWALSAL Transactions_RenewalsAllowed
SPECINS Transactions_SpecIns
PIECES Transactions_Pieces
LIBRARYUSE Transactions_LibraryUseOnly
ALLOWPHOTO Transactions_AllowPhotocopies
LENDINGLIB Transactions_LendingLibrary
REASONFORC Transactions_ReasonForCancellation
CALLNUMBER Transactions_CallNumber
LOCATION Transactions_Location
MAXCOST Transactions_Maxcost
PROCESSTYP Transactions_ProcessType
ITEMNUMBER Transactions_ItemNumber
LENDERADDR Transactions_LenderAddressNumber
ARIEL Transactions_Ariel
PATRON Transactions_Patron
PHOTOITEMA Transactions_PhotoItemAuthor
PHOTOITEMP Transactions_PhotoItemPlace
PHOTOITE_1 Transactions_PhotoItemPublisher
PHOTOITEME Transactions_PhotoItemEdition
DOCUMENTTY Transactions_DocumentType
PRIORITYSH Transactions_PriorityShipping
RUSH Transactions_Rush
COPYRIGHTA Transactions_CopyrightAlreadyPaid
DELIVERYME Transactions_WantedBy
SYSTEMID Transactions_SystemID
REPLACEMEN Transactions_ReplacementPages
IFMCOST Transactions_IFMCost
COPYRIGHTP Transactions_CopyrightPaymentMethod
SHIPPINGOP Transactions_ShippingOptions
INTLSHIPPI Transactions_IntlShippingOptions
SHIPPINGAC Transactions_ShippingAcctNo
REFERENCEN Transactions_ReferenceNumber
COPYRIGHTC Transactions_CopyrightComp
TADDRESS Transactions_TAddress
TADDRESS2 Transactions_TAddress2
TCITY Transactions_TCity
TSTATE Transactions_TState
TZIP Transactions_TZip
TCOUNTRY Transactions_TCountry
TFAX Transactions_TFax
TEMAILADDR Transactions_TEMailAddress
HANDLEWITH Transactions_HandleWithCare
COPYWITHCA Transactions_CopyWithCare
RESTRICTED Transactions_RestrictedUse
RECEIVEDVI Transactions_ReceivedVia
CANCELLATI Transactions_CancellationCode
BILLINGCAT Transactions_BillingCategory

Users Table Fields

Old Fields New Fields
USERNAME_1 Users_UserName
LASTNAME Users_LastName
FIRSTNAME Users_FirstName
SSN Users_SSN
STATUS Users_Status
EMAILADDRE Users_EMailAddress
PHONE Users_Phone
DEPARTMENT Users_Department
NVTGC Users_NVTGC
NOTIFICATI Users_NotificationMethod
DELIVERY_1 Users_DeliveryMethod
LOANDELIVE Users_LoanDeliveryMethod
LASTCHANGE Users_LastChangedDate
AUTHORIZED Users_AuthorizedUsers
CLEARED Users_Cleared
WEB_1 Users_Web
ADDRESS Users_Address
ADDRESS2 Users_Address2
CITY Users_City
STATE Users_State
ZIP Users_Zip
SITE Users_Site
EXPIRATION Users_ExpirationDate
NUMBER Users_Number
ORGANIZATI Users_Organization
FAX Users_Fax
BILLINGC_1 Users_BillingCategory
COUNTRY Users_Country
SADDRESS Users_SAddress
SADDRESS2 Users_SAddress2
SCITY Users_SCity
SSTATE Users_SState
SZIP Users_SZip
AUTHTYPE Users_AuthType

LocalInfo Table Fields

Old Fields New Fields
NVTGC_1 LocalInfo_NVTGC
SYSTEMNAME LocalInfo_SystemName
SYSTEMURL LocalInfo_SystemURL
INSTITUTIO LocalInfo_InstitutionName
LIBRARYNAM LocalInfo_LibraryName
OCLCSYMBOL LocalInfo_OCLCSymbol
DOCLINESYM LocalInfo_DoclineSymbol
RLINSYMBOL LocalInfo_RLINSymbol
GENERALCON LocalInfo_GeneralContactName
GENERALPHO LocalInfo_GeneralPhone
GENERALEMA LocalInfo_GeneralEMailAddress
GENERALADD LocalInfo_GeneralAddress1
GENERALA_1 LocalInfo_GeneralAddress2
GENERALCIT LocalInfo_GeneralCity
GENERALSTA LocalInfo_GeneralState
GENERALZIP LocalInfo_GeneralZip
GENERALFAX LocalInfo_GeneralFax
GENERALHOU LocalInfo_GeneralHours
BORROWINGC LocalInfo_BorrowingContact
BORROWINGP LocalInfo_BorrowingPhone
BORROWINGE LocalInfo_BorrowinEMailAddress
BORROWINGA LocalInfo_BorrowingAddress
BORROWIN_2 LocalInfo_BorrowingAddress2
BORROWIN_1 LocalInfo_BorrowingCity
BORROWINGS LocalInfo_BorrowingState
BORROWINGZ LocalInfo_BorrowingZip
BORROWINGF LocalInfo_BorrowingFax
BORROWINGH LocalInfo_BorrowingHours
BORROWIN_3 LocalInfo_BorrowingArielAddress
DOCDELCONT LocalInfo_DocDelContactName
DOCDELPHON LocalInfo_DocDelPhone
DOCDELEMAI LocalInfo_DocDelEMailAddress
DOCDELADDR LocalInfo_DocDelAddress1
DOCDELAD_1 LocalInfo_DocDelAddress2
DOCDELCITY LocalInfo_DocDelCity
DOCDELSTAT LocalInfo_DocDelState
DOCDELZIP LocalInfo_DocDelZip
DOCDELFAX LocalInfo_DocDelFax
DOCDELHOUR LocalInfo_DocDelHours
DOCDELARIE LocalInfo_DocDelArielAddress
LENDINGCON LocalInfo_LendingContact
LENDINGPHO LocalInfo_LendingPhone
LENDINGEMA LocalInfo_LendingEMailAddress
LENDINGADD LocalInfo_LendingAddress
LENDINGA_1 LocalInfo_LendingAddress1
LENDINGCIT LocalInfo_LendingCity
LENDINGSTA LocalInfo_LendingState
LENDINGZIP LocalInfo_LendingZip
LENDINGFAX LocalInfo_LendingFax
LENDINGHOU LocalInfo_LendingHours
LENDINGARI LocalInfo_LendingArielAddress

LenderAddresses Table Fields

Old Fields New Fields
NVTGC_2 LenderAddress_NVTGC
LENDERSTRI LenderAddress_LenderString
ADDRESSNUM LenderAddress_AddressNumber
LIBRARYN_1 LenderAddress_LibraryName
ADDRESS1 LenderAddress_Address1
ADDRESS2 LenderAddress_Address2
ADDRESS3 LenderAddress_Address3
ADDRESS4 LenderAddress_Address4
BADDRESS1 LenderAddress_BAddress1
BADDRESS2 LenderAddress_BAddress2
BADDRESS3 LenderAddress_BAddress3
BADDRESS4 LenderAddress_BAddress4
FAX LenderAddress_Fax
ARIELADDRE LenderAddress_ArielAddress
PHONE LenderAddress_Phone
PRIORITY_1 LenderAddress_PriorityShipping
COPYRIGH_1 LenderAddress_CopyrightPayer
BILLINGEXE LenderAddress_BillingExempt
LIBCOPYCHA LenderAddress_LibCopyCharge
LIBLOANCHA LenderAddress_LibLoanCharge
LIBBILLING LenderAddress_LibBillingMethod
NOTES LenderAddress_Notes
BILLINGC_1 LenderAddress_BillingCategory
RSSID LenderAddress_RSSID
ESPSHIPTO LenderAddress_ESPShipTo
ESPBILLTO LenderAddress_ESPBillTo

Questions?

If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation:

Feedback