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 |