Company Accounts<br>

<style>


	table.cfdump_wddx,
	table.cfdump_xml,
	table.cfdump_struct,
	table.cfdump_varundefined,
	table.cfdump_array,
	table.cfdump_query,
	table.cfdump_cfc,
	table.cfdump_object,
	table.cfdump_binary,
	table.cfdump_udf,
	table.cfdump_udfbody,
	table.cfdump_varnull,
	table.cfdump_udfarguments {
		font-size: xx-small;
		font-family: verdana, arial, helvetica, sans-serif;
	}

	table.cfdump_wddx th,
	table.cfdump_xml th,
	table.cfdump_struct th,
	table.cfdump_varundefined th,
	table.cfdump_array th,
	table.cfdump_query th,
	table.cfdump_cfc th,
	table.cfdump_object th,
	table.cfdump_binary th,
	table.cfdump_udf th,
	table.cfdump_udfbody th,
	table.cfdump_varnull th,
	table.cfdump_udfarguments th {
		text-align: left;
		color: white;
		padding: 5px;
	}

	table.cfdump_wddx td,
	table.cfdump_xml td,
	table.cfdump_struct td,
	table.cfdump_varundefined td,
	table.cfdump_array td,
	table.cfdump_query td,
	table.cfdump_cfc td,
	table.cfdump_object td,
	table.cfdump_binary td,
	table.cfdump_udf td,
	table.cfdump_udfbody td,
	table.cfdump_varnull td,
	table.cfdump_udfarguments td {
		padding: 3px;
		background-color: #ffffff;
		vertical-align : top;
	}

	table.cfdump_wddx {
		background-color: #000000;
	}
	table.cfdump_wddx th.wddx {
		background-color: #444444;
	}


	table.cfdump_xml {
		background-color: #888888;
	}
	table.cfdump_xml th.xml {
		background-color: #aaaaaa;
	}
	table.cfdump_xml td.xml {
		background-color: #dddddd;
	}

	table.cfdump_struct {
		background-color: #0000cc ;
	}
	table.cfdump_struct th.struct {
		background-color: #4444cc ;
	}
	table.cfdump_struct td.struct {
		background-color: #ccddff;
	}

	table.cfdump_varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined th.varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined td.varundefined {
		background-color: #ccddff;
	}

	table.cfdump_array {
		background-color: #006600 ;
	}
	table.cfdump_array th.array {
		background-color: #009900 ;
	}
	table.cfdump_array td.array {
		background-color: #ccffcc ;
	}

	table.cfdump_query {
		background-color: #884488 ;
	}
	table.cfdump_query th.query {
		background-color: #aa66aa ;
	}
	table.cfdump_query td.query {
		background-color: #ffddff ;
	}


	table.cfdump_cfc {
		background-color: #ff0000;
	}
	table.cfdump_cfc th.cfc{
		background-color: #ff4444;
	}
	table.cfdump_cfc td.cfc {
		background-color: #ffcccc;
	}


	table.cfdump_object {
		background-color : #ff0000;
	}
	table.cfdump_object th.object{
		background-color: #ff4444;
	}

	table.cfdump_binary {
		background-color : #eebb00;
	}
	table.cfdump_binary th.binary {
		background-color: #ffcc44;
	}
	table.cfdump_binary td {
		font-size: x-small;
	}
	table.cfdump_udf {
		background-color: #aa4400;
	}
	table.cfdump_udf th.udf {
		background-color: #cc6600;
	}
	table.cfdump_udfarguments {
		background-color: #dddddd;
	}
	table.cfdump_udfarguments th {
		background-color: #eeeeee;
		color: #000000;
	}

</style> <script language="javascript">


// for queries we have more than one td element to collapse/expand
	var expand = "open";

	dump = function( obj ) {
		var out = "" ;
		if ( typeof obj == "object" ) {
			for ( key in obj ) {
				if ( typeof obj[key] != "function" ) out += key + ': ' + obj[key] + '<br>' ;
			}
		}
	}


	cfdump_toggleRow = function(source) {
		//target is the right cell
		if(document.all) target = source.parentElement.cells[1];
		else {
			var element = null;
			var vLen = source.parentNode.childNodes.length;
			for(var i=vLen-1;i>0;i--){
				if(source.parentNode.childNodes[i].nodeType == 1){
					element = source.parentNode.childNodes[i];
					break;
				}
			}
			if(element == null)
				target = source.parentNode.lastChild;
			else
				target = element;
		}
		//target = source.parentNode.lastChild ;
		cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
	}

	cfdump_toggleXmlDoc = function(source) {

		var caption = source.innerHTML.split( ' [' ) ;

		// toggle source (header)
		if ( source.style.fontStyle == 'italic' ) {
			// closed -> short
			source.style.fontStyle = 'normal' ;
			source.innerHTML = caption[0] + ' [short version]' ;
			source.title = 'click to maximize' ;
			switchLongToState = 'closed' ;
			switchShortToState = 'open' ;
		} else if ( source.innerHTML.indexOf('[short version]') != -1 ) {
			// short -> full
			source.innerHTML = caption[0] + ' [long version]' ;
			source.title = 'click to collapse' ;
			switchLongToState = 'open' ;
			switchShortToState = 'closed' ;
		} else {
			// full -> closed
			source.style.fontStyle = 'italic' ;
			source.title = 'click to expand' ;
			source.innerHTML = caption[0] ;
			switchLongToState = 'closed' ;
			switchShortToState = 'closed' ;
		}

		// Toggle the target (everething below the header row).
		// First two rows are XMLComment and XMLRoot - they are part
		// of the long dump, the rest are direct children - part of the
		// short dump
		if(document.all) {
			var table = source.parentElement.parentElement ;
			for ( var i = 1; i < table.rows.length; i++ ) {
				target = table.rows[i] ;
				if ( i < 3 ) cfdump_toggleTarget( target, switchLongToState ) ;
				else cfdump_toggleTarget( target, switchShortToState ) ;
			}
		}
		else {
			var table = source.parentNode.parentNode ;
			var row = 1;
			for ( var i = 1; i < table.childNodes.length; i++ ) {
				target = table.childNodes[i] ;
				if( target.style ) {
					if ( row < 3 ) {
						cfdump_toggleTarget( target, switchLongToState ) ;
					} else {
						cfdump_toggleTarget( target, switchShortToState ) ;
					}
					row++;
				}
			}
		}
	}

	cfdump_toggleTable = function(source) {

		var switchToState = cfdump_toggleSource( source ) ;
		if(document.all) {
			var table = source.parentElement.parentElement ;
			for ( var i = 1; i < table.rows.length; i++ ) {
				target = table.rows[i] ;
				cfdump_toggleTarget( target, switchToState ) ;
			}
		}
		else {
			var table = source.parentNode.parentNode ;
			for ( var i = 1; i < table.childNodes.length; i++ ) {
				target = table.childNodes[i] ;
				if(target.style) {
					cfdump_toggleTarget( target, switchToState ) ;
				}
			}
		}
	}

	cfdump_toggleSource = function( source ) {
		if ( source.style.fontStyle == 'italic' || source.style.fontStyle == null) {
			source.style.fontStyle = 'normal' ;
			source.title = 'click to collapse' ;
			return 'open' ;
		} else {
			source.style.fontStyle = 'italic' ;
			source.title = 'click to expand' ;
			return 'closed' ;
		}
	}

	cfdump_toggleTarget = function( target, switchToState ) {
		if ( switchToState == 'open' )	target.style.display = '' ;
		else target.style.display = 'none' ;
	}

	// collapse all td elements for queries
	cfdump_toggleRow_qry = function(source) {
		expand = (source.title == "click to collapse") ? "closed" : "open";
		if(document.all) {
			var nbrChildren = source.parentElement.cells.length;
			if(nbrChildren > 1){
				for(i=nbrChildren-1;i>0;i--){
					target = source.parentElement.cells[i];
					cfdump_toggleTarget( target,expand ) ;
					cfdump_toggleSource_qry(source);
				}
			}
			else {
				//target is the right cell
				target = source.parentElement.cells[1];
				cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
			}
		}
		else{
			var target = null;
			var vLen = source.parentNode.childNodes.length;
			for(var i=vLen-1;i>1;i--){
				if(source.parentNode.childNodes[i].nodeType == 1){
					target = source.parentNode.childNodes[i];
					cfdump_toggleTarget( target,expand );
					cfdump_toggleSource_qry(source);
				}
			}
			if(target == null){
				//target is the last cell
				target = source.parentNode.lastChild;
				cfdump_toggleTarget( target, cfdump_toggleSource( source ) ) ;
			}
		}
	}

	cfdump_toggleSource_qry = function(source) {
		if(expand == "closed"){
			source.title = "click to expand";
			source.style.fontStyle = "italic";
		}
		else{
			source.title = "click to collapse";
			source.style.fontStyle = "normal";
		}
	}

</script> 
		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="13" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">ACCOUNT_ADDRESS1</td>
				
				<td class="query">ACCOUNT_ADDRESS2</td>
				
				<td class="query">ACCOUNT_BUSINESS_NAME</td>
				
				<td class="query">ACCOUNT_CITY</td>
				
				<td class="query">ACCOUNT_CONTACT_NAME</td>
				
				<td class="query">ACCOUNT_DATE_ADDED</td>
				
				<td class="query">ACCOUNT_EMAIL</td>
				
				<td class="query">ACCOUNT_NAME</td>
				
				<td class="query">ACCOUNT_PHONE(MAIN)</td>
				
				<td class="query">ACCOUNT_PHONE(MOBILE)</td>
				
				<td class="query">ACCOUNT_STATE</td>
				
				<td class="query">SR_ACCOUNT_ID</td>
				
				</tr>
				
				
				<tr >
				<td   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" class="query">1</td>
				
				
					<td valign="top">
					100 Blue Street 
					</td>
				
					<td valign="top">
					[empty string] 
					</td>
				
					<td valign="top">
					Global Company LLC 
					</td>
				
					<td valign="top">
					New York 
					</td>
				
					<td valign="top">
					John John 
					</td>
				
					<td valign="top">
					2017-10-31 00:00:00.0 
					</td>
				
					<td valign="top">
					Manger@globalcompany.com 
					</td>
				
					<td valign="top">
					Global_Company 
					</td>
				
					<td valign="top">
					5555555555 
					</td>
				
					<td valign="top">
					5555555511 
					</td>
				
					<td valign="top">
					New York 
					</td>
				
					<td valign="top">
					3 
					</td>
				
				</tr>
				
				</table>
				</td>
			</tr>
			
			
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td> false </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>24 </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>Select * From sr_account </td>
						</tr>
					
		</table>
		

<br>
<br>
Company Locations<br>


		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="4" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">LOCATION_CITY_EX_ID</td>
				
				<td class="query">LOCATION_ID</td>
				
				<td class="query">LOCATION_NAME_VENUE</td>
				
				</tr>
				
				
				<tr >
				<td   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" class="query">1</td>
				
				
					<td valign="top">
					3401 
					</td>
				
					<td valign="top">
					1 
					</td>
				
					<td valign="top">
					Yankee Stadium 
					</td>
				
				</tr>
				
				</table>
				</td>
			</tr>
			
			
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td> false </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>2 </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>Select * From sr_location </td>
						</tr>
					
		</table>
		

	<br>
<br>
Company Events<br>

	
		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="9" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">SR_EVENT_ACCOUNT_ID</td>
				
				<td class="query">SR_EVENT_CRDATE</td>
				
				<td class="query">SR_EVENT_END_DATE</td>
				
				<td class="query">SR_EVENT_ID</td>
				
				<td class="query">SR_EVENT_LOCATION</td>
				
				<td class="query">SR_EVENT_NAME</td>
				
				<td class="query">SR_EVENT_ONGOING</td>
				
				<td class="query">SR_EVENT_SDATE</td>
				
				</tr>
				
				
				<tr >
				<td   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" class="query">1</td>
				
				
					<td valign="top">
					3 
					</td>
				
					<td valign="top">
					2017-10-31 17:35:00.0 
					</td>
				
					<td valign="top">
					2017-11-30 22:00:00.0 
					</td>
				
					<td valign="top">
					1 
					</td>
				
					<td valign="top">
					1 
					</td>
				
					<td valign="top">
					Global_Company Concessions 
					</td>
				
					<td valign="top">
					[empty string] 
					</td>
				
					<td valign="top">
					2017-11-19 10:00:00.0 
					</td>
				
				</tr>
				
				</table>
				</td>
			</tr>
			
			
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td> false </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>2 </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>Select * From sr_event </td>
						</tr>
					
		</table>
		<br>
<br>


Event by Account view<br>


		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="7" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">ACCOUNT_NAME</td>
				
				<td class="query">SR_ACCOUNT_ID</td>
				
				<td class="query">SR_EVENT_ACCOUNT_ID</td>
				
				<td class="query">SR_EVENT_END_DATE</td>
				
				<td class="query">SR_EVENT_ID</td>
				
				<td class="query">SR_EVENT_SDATE</td>
				
				</tr>
				
				
				<tr >
				<td   style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" class="query">1</td>
				
				
					<td valign="top">
					Global_Company 
					</td>
				
					<td valign="top">
					3 
					</td>
				
					<td valign="top">
					3 
					</td>
				
					<td valign="top">
					2017-11-30 22:00:00.0 
					</td>
				
					<td valign="top">
					1 
					</td>
				
					<td valign="top">
					2017-11-19 10:00:00.0 
					</td>
				
				</tr>
				
				</table>
				</td>
			</tr>
			
			
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td> false </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>0 </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query"  style="cursor:pointer;" title="click to collapse" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>SELECT sr_event.sr_event_id, sr_event.sr_event_account_id, sr_event.sr_event_sdate, sr_event.sr_event_end_date, sr_account.sr_account_id, sr_account.account_name
	FROM sr_event
	INNER JOIN sr_account ON sr_event.sr_event_account_id=sr_account.sr_account_id </td>
						</tr>
					
		</table>