Default content controls for contract templates (mail merge)TO USE:Open this file in Microsoft Word and turn on Developer > Design Mode.Copy the desired content controls and paste them into your .xml template.Create a new template via CRM: Configuration Records > KORE > Mail Merge Template > Create New Mail Merge Template.Paste the separately-provided SQL query into the new CRM record.Table of Contents TOC \o "1-3" \h \z \u GENERAL INFORMATION PAGEREF _Toc113467265 \h 2PREMIUM DEAL INFORMATION PAGEREF _Toc113467266 \h 2MULTI-LOCATION DEAL LOCATION INFORMATION PAGEREF _Toc113467267 \h 3SINGLE GAME EVENT LOCATION INFORMATION PAGEREF _Toc113467268 \h 4PREMIUM DEAL VALUE INFORMATION PAGEREF _Toc113467269 \h 4ACCOUNT INFORMATION PAGEREF _Toc113467270 \h 5GENERAL CONTACT INFORMATION PAGEREF _Toc113467271 \h 6BILLING CONTACT INFORMATION PAGEREF _Toc113467272 \h 6ACCOUNT CONTACT INFORMATION PAGEREF _Toc113467273 \h 7PRIMARY CONTACT INFORMATION PAGEREF _Toc113467274 \h 7PRIMARY BILLING CONTACT INFORMATION PAGEREF _Toc113467275 \h 8SALESPERSON/COORDINATOR INFORMATION PAGEREF _Toc113467276 \h 8REPEATERS PAGEREF _Toc113467277 \h 9CONTRACT SEASON PAGEREF _Toc113467278 \h 9BILLING INFORMATION PAGEREF _Toc113467279 \h 9INVENTORY LIST INFORMATION PAGEREF _Toc113467280 \h 9INVENTORY HIERARCHY INFORMATION PAGEREF _Toc113467281 \h 10INVOICE LIST INFORMATION PAGEREF _Toc113467282 \h 10GENERAL INFORMATIONTopicContent ControlDescriptionSample ValueGeneral InformationTodayToday’s DateSeptember 5, 2022General InformationToday ShortToday’s Date Shortened09/05/2022General InformationCurrent DayCurrent Day5General InformationToday Ordinary DayToday’s Ordinary Day5thGeneral InformationToday Month YearToday’s Month and YearSeptember, 2022General InformationToday YearToday’s Year 2022General InformationNext YearNext Year2023General InformationCurrent SeasonCurrent Season2022PREMIUM DEAL INFORMATIONTopicContent ControlDescriptionSample ValuePremium Deal InformationPremium Deal Number Premium Deal Number1002Premium Deal InformationAccount NumberAccount Number12345Premium Deal InformationDescriptionPremium Deal DescriptionTextPremium Deal InformationDeal TypeDeal TypeLease, Rental Premium Deal InformationDeal StatusDeal StatusDraft, ContractedPremium Deal InformationApproval StatusApproval StatusDraft Deal Sheet, Contract Finalized Premium Deal InformationIs LeaseLease✔Premium Deal InformationIs RentalRental✔Premium Deal Information Lease Sub TypeLease Sub Type100%, 50%, 33.3%Premium Deal InformationOrder StatusOrder StatusReady for ProcessingPremium Deal InformationRental TypeRental TypeNightly Rental – RegularPremium Deal InformationContract Start YearContract Start Year2017 Premium Deal InformationContract Start MonthContract Start Month9 Premium Deal InformationContract Start DayContract Start Day1Premium Deal InformationContract Start Month YearContract Start Month YearSeptember, 2017 Premium Deal InformationContract Start Ordinary DayContract Start Ordinary Day 1stPremium Deal InformationContract Start DateContract Start DateSeptember 1, 2017Premium Deal InformationEnd Contract DateEnd Contract DateAugust 31, 2020Premium Deal InformationEnd YearEnd Year2020MULTI-LOCATION DEAL LOCATION INFORMATIONTopicContent ControlDescriptionSample ValueMulti-location Deal Location InformationSection Or Seat Name List One LineSection Or Seat Name List One LineSuite 2.05Multi-location Deal Location InformationSection List One LineSection List One LineSuite 2.05Multi-location Deal Location InformationTicketing Section List One LineTicketing Section List One Line Suite 2.Multi-location Deal Location InformationSeats List One LineSeats List One Line Table 4_1_1, Table 4_1_2, Table 4_1_3, Table 4_1_4Multi-location Deal Location InformationRow List One LineRow List One Line 1, 2, 17, 18, 19, 20SINGLE GAME EVENT LOCATION INFORMATIONTopicContent ControlDescriptionSample ValueSingle Game Event Location Information Location TypeLocation TypeSuite 2.05, Suite 17, L10H9L_43_1Single Game Event Location InformationLocation NameLocation NameSuite 2.05, Suite 17, L10H9L_43_1Single Game Event Location InformationSection SuiteSection Suite Arena4Single Game Event Location InformationNum of TicketNumber of Tickets 4 Single Game Event Location InformationNum of SRONumber of SRO 6Single Game Event Location InformationParking SpacesParking Spaces 1Single Game Event Location InformationMax CapacityMaximum Capacity 18PREMIUM DEAL VALUE INFORMATION TopicContent ControlDescriptionSample ValuePremium Deal Value Information Security DepositSecurity Deposit$400Premium Deal Value InformationIf Deposit PlacedIf Deposit Placed No Premium Deal Value InformationIf EscalationIf Escalation Yes Premium Deal Value InformationEscalation RateEscalation Rate 200.00% Premium Deal Value InformationTotal Contract GrossTotal Contract Gross$100,912.40Premium Deal Value InformationFirst Year FeeFirst Year Fee $33,000.00Premium Deal Value InformationFirst Year Billing TotalFirst Year Billing Total $33,000.00Premium Deal Value InformationAnnual FeeAnnual Fee$33,000.00Premium Deal Value InformationAmount DueAmount Due $33,000.00Premium Deal Value InformationPremium Deal TermsPremium Deal Terms3Premium Deal Value InformationPremium Events List One LinePremium Events List One Line Real Madrid v CA Osasuna, Real Madrid v Atlético de Madrid, Real Madrid v. Elche CFPremium Deal Value InformationPremium Event Dates List One LinePremium Event Dates List One LineSunday, January 1, 2017 12:00 AM, Friday, September 7, 2018 12:00 AM, Saturday, September 8, 2018 12:00 AM Premium Deal Value InformationVenueVenuePlace Bell Premium Deal Value InformationTotal TicketTotal Tickets6Premium Deal Value InformationTotal ParkingTotal Parking 1Premium Deal Value InformationTotal SROTotal SRO 6Premium Deal Value InformationAdd On List One LineAdd On List One Line4 (Four) Food & Beverage (Alcohol Included) Package, 1 (One) All You Care to Eat Food IncludedACCOUNT INFORMATIONTopicContent ControlDescriptionSample ValueAccount InformationAccount NameAccount NameASC PLUS INC. Account InformationAccount Legal NameAccount Legal NameASC PLUS INC.Account InformationAccount Legal Name or Account NameAccount Legal Name or Account NameASC PLUS INC. Account InformationFinance NumberAccount Finance NumberASCAccount InformationIndustryAccount IndustryHealth CareAccount InformationAddress 1Account Address 1123 First AveAccount InformationAddress 2Account Address 2Suite 789Account InformationCityAccount CityAnytownAccount InformationStateAccount StateNYAccount InformationCountryAccount CountryUSAAccount InformationZipAccount Zip00234Account InformationFaxAccount Fax1-888-555-0123Account InformationAccount Address Line 1Account Address Line 1123 First Ave, Suite 789Account InformationAccount Address Line 2Account Address Line 2Anytown, NY, 00234GENERAL CONTACT INFORMATIONTopicContent ControlDescriptionSample ValueGeneral ContactContact MemberContact MemberBrenda Robertson General ContactContact Address Line 1Contact Address Line 1127 Avalon RoadGeneral ContactContact Address Line 2Contact Address Line 2New York, NY, 12797 General ContactPhoneContact Phone Number(438) 394-9417General ContactJob TitleContact Job TitleCEO General ContactEmailContact Emailbrenda.robertson@example.netBILLING CONTACT INFORMATIONTopicContent ControlDescriptionSample ValueBilling ContactNameBilling Contact NameSteve AdamsBilling ContactBilling Address Line 1Billing Address Line 1 789 First StBilling Contact Billing Address Line 2Billing Address Line 1Atlanta, GA, 00333Billing ContactPhoneBilling Contact Phone(404) 555-0177Billing ContactJob TitleBilling Contact Job TitleCMOBilling ContactEmailBilling Contact Emails.adams@example.netACCOUNT CONTACT INFORMATIONTopicContent ControlDescriptionSample ValueAccount Contact InformationAccount Contact NameAccount Contact NameASC PLUS INC. Account Contact InformationAccount Contact Legal NameAccount Contact Legal NameASC PLUS INC. Account Contact InformationAccount Contact NumberAccount Contact Number12343Account Contact InformationAccount Contact Address Line 1Account Contact Address Line 1123 First Ave, Suite 789Account Contact InformationAccount Contact Address Line 2Account Contact Address Line 2Anytown, NY, 00234Account Contact InformationPhoneAccount Contact Phone Number(800) 123-4567PRIMARY CONTACT INFORMATIONTopicContent ControlDescriptionSample ValuePrimary ContactPrimary ContactPrimary Contact NameHelena SilvaPrimary ContactPrimary Contact Address Line 1Primary Contact Address Line 1 789 First StPrimary ContactPrimary Contact Address Line 2Primary Contact Address Line 2Atlanta, GA, 00333Primary ContactPhonePrimary Contact Phone(404) 555-0177Primary ContactJob TitlePrimary Contact Job TitleCFOPrimary ContactEmailPrimary Contact Emailh.silva@example.netPRIMARY BILLING CONTACT INFORMATIONTopicContent ControlDescriptionSample ValuePrimary Billing ContactPrimary Billing NamePrimary Billing Contact NameBrenda Robertson Primary Billing ContactPrimary Billing Address Line 1Primary Billing Address Line 1 127 Avalon RoadPrimary Billing ContactPrimary Billing Address Line 2Primary Billing Address Line 2New York, NY, 12797Primary Billing ContactPhonePrimary Billing Contact Phone(438) 394-9417Primary Billing ContactJob TitlePrimary Billing Contact Job TitleCEOPrimary Billing ContactEmailPrimary Billing Contact Emailbrenda.robertson@example.netSALESPERSON/COORDINATOR INFORMATIONTopicContent ControlDescriptionSample ValueSalesperson InformationSalespersonSalesperson NameMatthew EichelSalesperson InformationCoordinatorCoordinator NameJeffrey SveinsonSalesperson InformationSuite AdminSuite AdminSarah DunnSalesperson InformationSales Rep NameSales Rep NameJayden PerezSalesperson InformationPhoneSales Rep Phone(888) 555-0199Salesperson InformationEmailSales Rep EmailJ.Perez@example.com PAGE \* MERGEFORMAT 1Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Click here to enter text.Dan SmithRayne Rong2532017-03-22T14:38:00Z2022-09-07T18:33:00Z2645817069725Microsoft Office Word08122falseTitle1false11409falsefalse16.0000