Old vs. New Print Template Merge Fields

Print Friendly and PDF Follow

The default print templates for ILLiad contain clearer names for the mail merge fields. For example, they use Transactions_TransactionNumber versus TRANSACTION. 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