<?php
$tdataPending_Customers=array();
	$tdataPending_Customers[".NumberOfChars"]=80; 
	$tdataPending_Customers[".ShortName"]="Pending_Customers";
	$tdataPending_Customers[".OwnerID"]="Region";
	$tdataPending_Customers[".OriginalTable"]="customer_list";


	
//	field labels
$fieldLabelsPending_Customers = array();
if(mlang_getcurrentlang()=="English")
{
	$fieldLabelsPending_Customers["English"]=array();
	$fieldToolTipsPending_Customers["English"]=array();
	$fieldLabelsPending_Customers["English"]["idCL"] = "Id CL";
	$fieldToolTipsPending_Customers["English"]["idCL"] = "";
	$fieldLabelsPending_Customers["English"]["Customer_Name"] = "Customer Name";
	$fieldToolTipsPending_Customers["English"]["Customer Name"] = "";
	$fieldLabelsPending_Customers["English"]["Address"] = "Address";
	$fieldToolTipsPending_Customers["English"]["Address"] = "";
	$fieldLabelsPending_Customers["English"]["City"] = "City";
	$fieldToolTipsPending_Customers["English"]["City"] = "";
	$fieldLabelsPending_Customers["English"]["State"] = "State";
	$fieldToolTipsPending_Customers["English"]["State"] = "";
	$fieldLabelsPending_Customers["English"]["Country"] = "Country";
	$fieldToolTipsPending_Customers["English"]["Country"] = "";
	$fieldLabelsPending_Customers["English"]["Postal_Code"] = "Postal Code";
	$fieldToolTipsPending_Customers["English"]["Postal Code"] = "";
	$fieldLabelsPending_Customers["English"]["Web_address"] = "Web Address";
	$fieldToolTipsPending_Customers["English"]["Web address"] = "";
	$fieldLabelsPending_Customers["English"]["Area"] = "Area";
	$fieldToolTipsPending_Customers["English"]["Area"] = "";
	$fieldLabelsPending_Customers["English"]["Customer_Category"] = "Customer Category";
	$fieldToolTipsPending_Customers["English"]["Customer_Category"] = "";
	$fieldLabelsPending_Customers["English"]["Breif_About_the_Company"] = "Breif About the Company";
	$fieldToolTipsPending_Customers["English"]["Breif About the Company"] = "";
	$fieldLabelsPending_Customers["English"]["Existing_Setup"] = "Existing Setup";
	$fieldToolTipsPending_Customers["English"]["Existing Setup"] = "";
	$fieldLabelsPending_Customers["English"]["Interaction_Summary"] = "Interaction Summary";
	$fieldToolTipsPending_Customers["English"]["Interaction Summary"] = "";
	$fieldLabelsPending_Customers["English"]["Commercial_Summary"] = "Commercial Summary";
	$fieldToolTipsPending_Customers["English"]["Commercial Summary"] = "";
	$fieldLabelsPending_Customers["English"]["Customer_Status"] = "Customer Status";
	$fieldToolTipsPending_Customers["English"]["Customer Status"] = "";
	$fieldLabelsPending_Customers["English"]["Region"] = "Region";
	$fieldToolTipsPending_Customers["English"]["Region"] = "";
	$fieldLabelsPending_Customers["English"]["Last_Updated_on"] = "Last Updated on";
	$fieldToolTipsPending_Customers["English"]["Last Updated on"] = "";
	$fieldLabelsPending_Customers["English"]["LU_Month"] = "LU-Month";
	$fieldToolTipsPending_Customers["English"]["LU-Month"] = "";
	$fieldLabelsPending_Customers["English"]["LU_Year"] = "LU-Year";
	$fieldToolTipsPending_Customers["English"]["LU-Year"] = "";
	$fieldLabelsPending_Customers["English"]["Created_on"] = "Created On";
	$fieldToolTipsPending_Customers["English"]["Created on"] = "";
	$fieldLabelsPending_Customers["English"]["Assigned_Executive"] = "Assigned Executive";
	$fieldToolTipsPending_Customers["English"]["Assigned Executive"] = "";
	$fieldLabelsPending_Customers["English"]["Assigned_Date"] = "Assigned Date";
	$fieldToolTipsPending_Customers["English"]["Assigned Date"] = "";
	$fieldLabelsPending_Customers["English"]["Aligned_Partner"] = "Aligned Partner";
	$fieldToolTipsPending_Customers["English"]["Aligned Partner"] = "";
	if (count($fieldToolTipsPending_Customers["English"])){
		$tdataPending_Customers[".isUseToolTips"]=true;
	}
}


	

	

$tdataPending_Customers[".shortTableName"] = "Pending_Customers";
$tdataPending_Customers[".nSecOptions"] = 1;
$tdataPending_Customers[".recsPerRowList"] = 1;	
$tdataPending_Customers[".tableGroupBy"] = "0";
$tdataPending_Customers[".mainTableOwnerID"] = "Region";
$tdataPending_Customers[".moveNext"] = 1;




$tdataPending_Customers[".showAddInPopup"] = false;

$tdataPending_Customers[".showEditInPopup"] = false;

$tdataPending_Customers[".showViewInPopup"] = false;


$tdataPending_Customers[".fieldsForRegister"] = array();

$tdataPending_Customers[".listAjax"] = false;

	$tdataPending_Customers[".audit"] = false;

	$tdataPending_Customers[".locking"] = true;
	
$tdataPending_Customers[".listIcons"] = true;
$tdataPending_Customers[".edit"] = true;
$tdataPending_Customers[".view"] = true;




$tdataPending_Customers[".showSimpleSearchOptions"] = false;

$tdataPending_Customers[".showSearchPanel"] = true;


$tdataPending_Customers[".isUseAjaxSuggest"] = true;

$tdataPending_Customers[".rowHighlite"] = true;


// button handlers file names

$tdataPending_Customers[".addPageEvents"] = false;

$tdataPending_Customers[".arrKeyFields"][] = "idCL";

// use datepicker for search panel
$tdataPending_Customers[".isUseCalendarForSearch"] = true;

// use timepicker for search panel
$tdataPending_Customers[".isUseTimeForSearch"] = false;

$tdataPending_Customers[".isUseiBox"] = false;


$tdataPending_Customers[".useDetailsPreview"] = true;	


$tdataPending_Customers[".isUseInlineJs"] = $tdataPending_Customers[".isUseInlineAdd"] || $tdataPending_Customers[".isUseInlineEdit"];

$tdataPending_Customers[".allSearchFields"] = array();

$tdataPending_Customers[".globSearchFields"][] = "Customer Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Customer Name", $tdataPending_Customers[".allSearchFields"]))
{
	$tdataPending_Customers[".allSearchFields"][] = "Customer Name";	
}
$tdataPending_Customers[".globSearchFields"][] = "Aligned Partner";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Aligned Partner", $tdataPending_Customers[".allSearchFields"]))
{
	$tdataPending_Customers[".allSearchFields"][] = "Aligned Partner";	
}


$tdataPending_Customers[".googleLikeFields"][] = "Customer Name";
$tdataPending_Customers[".googleLikeFields"][] = "idCL";
$tdataPending_Customers[".googleLikeFields"][] = "Address";
$tdataPending_Customers[".googleLikeFields"][] = "City";
$tdataPending_Customers[".googleLikeFields"][] = "State";
$tdataPending_Customers[".googleLikeFields"][] = "Country";
$tdataPending_Customers[".googleLikeFields"][] = "Postal Code";
$tdataPending_Customers[".googleLikeFields"][] = "Region";
$tdataPending_Customers[".googleLikeFields"][] = "Area";
$tdataPending_Customers[".googleLikeFields"][] = "Web address";
$tdataPending_Customers[".googleLikeFields"][] = "Customer_Category";
$tdataPending_Customers[".googleLikeFields"][] = "Last Updated on";
$tdataPending_Customers[".googleLikeFields"][] = "Created on";
$tdataPending_Customers[".googleLikeFields"][] = "LU-Month";
$tdataPending_Customers[".googleLikeFields"][] = "Breif About the Company";
$tdataPending_Customers[".googleLikeFields"][] = "Existing Setup";
$tdataPending_Customers[".googleLikeFields"][] = "Interaction Summary";
$tdataPending_Customers[".googleLikeFields"][] = "Commercial Summary";
$tdataPending_Customers[".googleLikeFields"][] = "LU-Year";
$tdataPending_Customers[".googleLikeFields"][] = "Customer Status";
$tdataPending_Customers[".googleLikeFields"][] = "Assigned Executive";
$tdataPending_Customers[".googleLikeFields"][] = "Assigned Date";
$tdataPending_Customers[".googleLikeFields"][] = "Aligned Partner";



$tdataPending_Customers[".advSearchFields"][] = "Customer Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Customer Name", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Customer Name";	
}
$tdataPending_Customers[".advSearchFields"][] = "idCL";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("idCL", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "idCL";	
}
$tdataPending_Customers[".advSearchFields"][] = "Address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Address", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Address";	
}
$tdataPending_Customers[".advSearchFields"][] = "City";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("City", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "City";	
}
$tdataPending_Customers[".advSearchFields"][] = "State";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("State", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "State";	
}
$tdataPending_Customers[".advSearchFields"][] = "Country";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Country", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Country";	
}
$tdataPending_Customers[".advSearchFields"][] = "Postal Code";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Postal Code", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Postal Code";	
}
$tdataPending_Customers[".advSearchFields"][] = "Region";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Region", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Region";	
}
$tdataPending_Customers[".advSearchFields"][] = "Area";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Area", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Area";	
}
$tdataPending_Customers[".advSearchFields"][] = "Web address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Web address", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Web address";	
}
$tdataPending_Customers[".advSearchFields"][] = "Customer_Category";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Customer_Category", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Customer_Category";	
}
$tdataPending_Customers[".advSearchFields"][] = "Last Updated on";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Last Updated on", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Last Updated on";	
}
$tdataPending_Customers[".advSearchFields"][] = "Created on";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Created on", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Created on";	
}
$tdataPending_Customers[".advSearchFields"][] = "LU-Month";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("LU-Month", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "LU-Month";	
}
$tdataPending_Customers[".advSearchFields"][] = "Breif About the Company";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Breif About the Company", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Breif About the Company";	
}
$tdataPending_Customers[".advSearchFields"][] = "Existing Setup";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Existing Setup", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Existing Setup";	
}
$tdataPending_Customers[".advSearchFields"][] = "Interaction Summary";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Interaction Summary", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Interaction Summary";	
}
$tdataPending_Customers[".advSearchFields"][] = "Commercial Summary";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Commercial Summary", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Commercial Summary";	
}
$tdataPending_Customers[".advSearchFields"][] = "LU-Year";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("LU-Year", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "LU-Year";	
}
$tdataPending_Customers[".advSearchFields"][] = "Customer Status";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Customer Status", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Customer Status";	
}
$tdataPending_Customers[".advSearchFields"][] = "Assigned Executive";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Assigned Executive", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Assigned Executive";	
}
$tdataPending_Customers[".advSearchFields"][] = "Assigned Date";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Assigned Date", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Assigned Date";	
}
$tdataPending_Customers[".advSearchFields"][] = "Aligned Partner";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Aligned Partner", $tdataPending_Customers[".allSearchFields"])) 
{
	$tdataPending_Customers[".allSearchFields"][] = "Aligned Partner";	
}

$tdataPending_Customers[".isTableType"] = "list";


	

$tdataPending_Customers[".isDisplayLoading"] = true;

$tdataPending_Customers[".isResizeColumns"] = false;

	$tdataPending_Customers[".subQueriesSupAccess"] = true;




$tdataPending_Customers[".pageSize"] = 20;

$gstrOrderBy = "ORDER BY idCL DESC";
if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
	$gstrOrderBy = "order by ".$gstrOrderBy;
$tdataPending_Customers[".strOrderBy"] = $gstrOrderBy;
	
$tdataPending_Customers[".orderindexes"] = array();
$tdataPending_Customers[".orderindexes"][] = array(1, (0 ? "ASC" : "DESC"), "idCL");

$tdataPending_Customers[".sqlHead"] = "Select idCL,  `Customer Name`,  Address,  City,  `State`,  Country,  `Postal Code`,  `Web address`,  Area,  Customer_Category,  `Breif About the Company`,  `Existing Setup`,  `Interaction Summary`,  `Commercial Summary`,  `Customer Status`,  Region,  `Last Updated on`,  MonthName(`Last Updated on`) AS `LU-Month`,  Year(`Last Updated on`) AS `LU-Year`,  `Created on`,  `Assigned Executive`,  `Assigned Date`,  `Aligned Partner`";
$tdataPending_Customers[".sqlFrom"] = "FROM customer_list";
$tdataPending_Customers[".sqlWhereExpr"] = "(`Customer Status` = 'Pending')";
$tdataPending_Customers[".sqlTail"] = "";

//fill array of tabs for edit page
$arrEditTabs = array();
	$tabFields = array();
	$tabFields[]="Address";
	$tabFields[]="City";
	$tabFields[]="State";
	$tabFields[]="Country";
	$tabFields[]="Postal Code";
$arrEditTabs[] = array('tabId'=>'Address_Details1',
					   'tabName'=>"Address Details",
					   'nType'=>'1',
					   'nOrder'=>2,
					   'tabGroup'=>0,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[]="Region";
	$tabFields[]="Area";
	$tabFields[]="Web address";
	$tabFields[]="Customer_Category";
	$tabFields[]="Last Updated on";
$arrEditTabs[] = array('tabId'=>'Other_Details1',
					   'tabName'=>"Other Details",
					   'nType'=>'1',
					   'nOrder'=>8,
					   'tabGroup'=>0,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[]="Breif About the Company";
$arrEditTabs[] = array('tabId'=>'About__1',
					   'tabName'=>"About..",
					   'nType'=>'0',
					   'nOrder'=>14,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[]="Existing Setup";
$arrEditTabs[] = array('tabId'=>'Existing_Setup1',
					   'tabName'=>"Existing Setup",
					   'nType'=>'0',
					   'nOrder'=>16,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[]="Interaction Summary";
$arrEditTabs[] = array('tabId'=>'Interaction_Details1',
					   'tabName'=>"Interaction Details",
					   'nType'=>'0',
					   'nOrder'=>18,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[]="Commercial Summary";
$arrEditTabs[] = array('tabId'=>'Commercial_Details1',
					   'tabName'=>"Commercial Details",
					   'nType'=>'0',
					   'nOrder'=>20,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
$tdataPending_Customers[".arrEditTabs"] = $arrEditTabs;

//fill array of tabs for add page
$arrAddTabs = array();
	$tabFields = array();
	$tabFields[] = "Address";
	$tabFields[] = "City";
	$tabFields[] = "State";
	$tabFields[] = "Country";
	$tabFields[] = "Postal Code";
$arrAddTabs[] = array('tabId'=>'Address_Details1',
					  'tabName'=>"Address Details",
					  'nType'=>'1',
					  'nOrder'=>2,
					  'tabGroup'=>0,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Region";
	$tabFields[] = "Area";
	$tabFields[] = "Web address";
	$tabFields[] = "Customer_Category";
	$tabFields[] = "Last Updated on";
$arrAddTabs[] = array('tabId'=>'Other_Details1',
					  'tabName'=>"Other Details",
					  'nType'=>'1',
					  'nOrder'=>8,
					  'tabGroup'=>0,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Breif About the Company";
$arrAddTabs[] = array('tabId'=>'About__1',
					  'tabName'=>"About..",
					  'nType'=>'0',
					  'nOrder'=>14,
					  'tabGroup'=>1,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Existing Setup";
$arrAddTabs[] = array('tabId'=>'Existing_Setup1',
					  'tabName'=>"Existing Setup",
					  'nType'=>'0',
					  'nOrder'=>16,
					  'tabGroup'=>1,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Interaction Summary";
$arrAddTabs[] = array('tabId'=>'Interaction_Details1',
					  'tabName'=>"Interaction Details",
					  'nType'=>'0',
					  'nOrder'=>18,
					  'tabGroup'=>1,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Commercial Summary";
$arrAddTabs[] = array('tabId'=>'Commercial_Details1',
					  'tabName'=>"Commercial Details",
					  'nType'=>'0',
					  'nOrder'=>20,
					  'tabGroup'=>1,
					  'arrFields'=> $tabFields,
					  'expandSec'=>0);
$tdataPending_Customers[".arrAddTabs"] = $arrAddTabs;

//fill array of tabs for view page
$arrViewTabs = array();
	$tabFields = array();
	$tabFields[] = "Address";
	$tabFields[] = "City";
	$tabFields[] = "State";
	$tabFields[] = "Country";
	$tabFields[] = "Postal Code";
$arrViewTabs[] = array('tabId'=>'Address_Details1',
					   'tabName'=>"Address Details",
					   'nType'=>'1',
					   'nOrder'=>3,
					   'tabGroup'=>0,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Region";
	$tabFields[] = "Area";
	$tabFields[] = "Web address";
	$tabFields[] = "Customer_Category";
	$tabFields[] = "Last Updated on";
$arrViewTabs[] = array('tabId'=>'Other_Details1',
					   'tabName'=>"Other Details",
					   'nType'=>'1',
					   'nOrder'=>9,
					   'tabGroup'=>0,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Breif About the Company";
$arrViewTabs[] = array('tabId'=>'About__1',
					   'tabName'=>"About..",
					   'nType'=>'0',
					   'nOrder'=>15,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Existing Setup";
$arrViewTabs[] = array('tabId'=>'Existing_Setup1',
					   'tabName'=>"Existing Setup",
					   'nType'=>'0',
					   'nOrder'=>17,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Interaction Summary";
$arrViewTabs[] = array('tabId'=>'Interaction_Details1',
					   'tabName'=>"Interaction Details",
					   'nType'=>'0',
					   'nOrder'=>19,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Commercial Summary";
$arrViewTabs[] = array('tabId'=>'Commercial_Details1',
					   'tabName'=>"Commercial Details",
					   'nType'=>'0',
					   'nOrder'=>21,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
$tdataPending_Customers[".arrViewTabs"] = $arrViewTabs;

//fill array of records per page for list and report without group fields
$arrRPP = array();
$arrRPP[] = 10;
$arrRPP[] = 20;
$arrRPP[] = 30;
$arrRPP[] = 50;
$arrRPP[] = 100;
$arrRPP[] = 500;
$arrRPP[] = -1;
$tdataPending_Customers[".arrRecsPerPage"] = $arrRPP;

//fill array of groups per page for report with group fields
$arrGPP = array();
$arrGPP[] = 1;
$arrGPP[] = 3;
$arrGPP[] = 5;
$arrGPP[] = 10;
$arrGPP[] = 50;
$arrGPP[] = 100;
$arrGPP[] = -1;
$tdataPending_Customers[".arrGroupsPerPage"] = $arrGPP;

	$tableKeys = array();
	$tableKeys[] = "idCL";
	$tdataPending_Customers[".Keys"] = $tableKeys;

//	idCL
	$fdata = array();
	$fdata["strName"] = "idCL";
	$fdata["ownerTable"] = "customer_list";
		$fdata["Label"]="Id CL"; 
	
		
		
	$fdata["FieldType"]= 3;
	
		$fdata["AutoInc"]=true;
	
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "idCL";
	
		$fdata["FullName"]= "idCL";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 1;
				$fdata["EditParams"]="";
			
		$fdata["bListPage"]=true; 
	
		
		
		
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
				$fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");	
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["idCL"]=$fdata;
//	Customer Name
	$fdata = array();
	$fdata["strName"] = "Customer Name";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Readonly";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Customer_Name";
	
		$fdata["FullName"]= "`Customer Name`";
	
		
		
		
		
		
				$fdata["Index"]= 2;
				
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Customer Name"]=$fdata;
//	Address
	$fdata = array();
	$fdata["strName"] = "Address";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Address";
	
		$fdata["FullName"]= "Address";
	
		
		
		
		
		
				$fdata["Index"]= 3;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=100";
		$fdata["nRows"] = 100;
			$fdata["EditParams"].= " cols=200";
		$fdata["nCols"] = 200;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Address"]=$fdata;
//	City
	$fdata = array();
	$fdata["strName"] = "City";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "City";
	
		$fdata["FullName"]= "City";
	
		
		
		
		
		
				$fdata["Index"]= 4;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["City"]=$fdata;
//	State
	$fdata = array();
	$fdata["strName"] = "State";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "State";
	
		$fdata["FullName"]= "`State`";
	
		
		
		
		
		
				$fdata["Index"]= 5;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["State"]=$fdata;
//	Country
	$fdata = array();
	$fdata["strName"] = "Country";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Country";
	
		$fdata["FullName"]= "Country";
	
		
		
		
		
		
				$fdata["Index"]= 6;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Country"]=$fdata;
//	Postal Code
	$fdata = array();
	$fdata["strName"] = "Postal Code";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Postal_Code";
	
		$fdata["FullName"]= "`Postal Code`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 7;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=10";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Postal Code"]=$fdata;
//	Web address
	$fdata = array();
	$fdata["strName"] = "Web address";
	$fdata["ownerTable"] = "customer_list";
		$fdata["Label"]="Web Address"; 
	
		
		$fdata["LinkPrefix"]="http://"; 
	
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "Hyperlink";
	
		
		
		
		
		
	$fdata["GoodName"]= "Web_address";
	
		$fdata["FullName"]= "`Web address`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 8;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=100";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Web address"]=$fdata;
//	Area
	$fdata = array();
	$fdata["strName"] = "Area";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="Area Name";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Area Name";
				$fdata["LookupTable"]="area";
	$fdata["LookupOrderBy"]="Area Name";
										$fdata["UseCategory"]=true; 
	$fdata["CategoryControl"]="Region"; 
	$fdata["CategoryFilter"]="Region"; 
										
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Area";
	
		$fdata["FullName"]= "Area";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 9;
				
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Area"]=$fdata;
//	Customer_Category
	$fdata = array();
	$fdata["strName"] = "Customer_Category";
	$fdata["ownerTable"] = "customer_list";
		$fdata["Label"]="Customer Category"; 
	
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="Customer_Category";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Customer_Category";
				$fdata["LookupTable"]="customer_category";
	$fdata["LookupOrderBy"]="Customer_Category";
																			$fdata["SimpleAdd"]=true;
	
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Customer_Category";
	
		$fdata["FullName"]= "Customer_Category";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 10;
				
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Customer_Category"]=$fdata;
//	Breif About the Company
	$fdata = array();
	$fdata["strName"] = "Breif About the Company";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "HTML";
	
		
		
		
		
		
	$fdata["GoodName"]= "Breif_About_the_Company";
	
		$fdata["FullName"]= "`Breif About the Company`";
	
		
		$fdata["UseRTE"]=true; 
	
		$fdata["UseRTEBasic"] = true; 
	
		
		
				$fdata["Index"]= 11;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=150";
		$fdata["nRows"] = 150;
			$fdata["EditParams"].= " cols=950";
		$fdata["nCols"] = 950;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Breif About the Company"]=$fdata;
//	Existing Setup
	$fdata = array();
	$fdata["strName"] = "Existing Setup";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "HTML";
	
		
		
		
		
		
	$fdata["GoodName"]= "Existing_Setup";
	
		$fdata["FullName"]= "`Existing Setup`";
	
		
		$fdata["UseRTE"]=true; 
	
		$fdata["UseRTEBasic"] = true; 
	
		
		
				$fdata["Index"]= 12;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=150";
		$fdata["nRows"] = 150;
			$fdata["EditParams"].= " cols=950";
		$fdata["nCols"] = 950;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Existing Setup"]=$fdata;
//	Interaction Summary
	$fdata = array();
	$fdata["strName"] = "Interaction Summary";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "HTML";
	
		
		
		
		
		
	$fdata["GoodName"]= "Interaction_Summary";
	
		$fdata["FullName"]= "`Interaction Summary`";
	
		$fdata["IsRequired"]=true; 
	
		$fdata["UseRTE"]=true; 
	
		$fdata["UseRTEBasic"] = true; 
	
		
		
				$fdata["Index"]= 13;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=150";
		$fdata["nRows"] = 150;
			$fdata["EditParams"].= " cols=950";
		$fdata["nCols"] = 950;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Interaction Summary"]=$fdata;
//	Commercial Summary
	$fdata = array();
	$fdata["strName"] = "Commercial Summary";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "HTML";
	
		
		
		
		
		
	$fdata["GoodName"]= "Commercial_Summary";
	
		$fdata["FullName"]= "`Commercial Summary`";
	
		$fdata["IsRequired"]=true; 
	
		$fdata["UseRTE"]=true; 
	
		$fdata["UseRTEBasic"] = true; 
	
		
		
				$fdata["Index"]= 14;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=150";
		$fdata["nRows"] = 150;
			$fdata["EditParams"].= " cols=950";
		$fdata["nCols"] = 950;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Commercial Summary"]=$fdata;
//	Customer Status
	$fdata = array();
	$fdata["strName"] = "Customer Status";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Radio button";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=0;
	$fdata["pLookupType"] = 0;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
					$fdata["HorizontalLookup"]= true;
					$fdata["LookupValues"]=array();
	$fdata["LookupValues"][]="Review";
	$fdata["LookupValues"][]="Pending";
			
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Customer_Status";
	
		$fdata["FullName"]= "`Customer Status`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 15;
				
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Customer Status"]=$fdata;
//	Region
	$fdata = array();
	$fdata["strName"] = "Region";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="Region Name";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Region Name";
				$fdata["LookupTable"]="region";
	$fdata["LookupOrderBy"]="Region Name";
																			$fdata["SimpleAdd"]=true;
	
				//	dependent dropdowns	
	$fdata["DependentLookups"]=array();
	$fdata["DependentLookups"][]="Area";
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Region";
	
		$fdata["FullName"]= "Region";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 16;
				
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Region"]=$fdata;
//	Last Updated on
	$fdata = array();
	$fdata["strName"] = "Last Updated on";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 135;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Date";
	$fdata["ViewFormat"]= "Short Date";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Last_Updated_on";
	
		$fdata["FullName"]= "`Last Updated on`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 17;
		$fdata["DateEditType"] = 11; 
	$fdata["InitialYearFactor"] = 100; 
	$fdata["LastYearFactor"] = 10; 
			
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Last Updated on"]=$fdata;
//	LU-Month
	$fdata = array();
	$fdata["strName"] = "LU-Month";
	$fdata["ownerTable"] = "";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "LU_Month";
	
		$fdata["FullName"]= "MonthName(`Last Updated on`)";
	
		
		
		
		
		
				$fdata["Index"]= 18;
				$fdata["EditParams"]="";
			
		$fdata["bListPage"]=true; 
	
		
		
		
		
		
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["LU-Month"]=$fdata;
//	LU-Year
	$fdata = array();
	$fdata["strName"] = "LU-Year";
	$fdata["ownerTable"] = "";
		
		
		
	$fdata["FieldType"]= 3;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "LU_Year";
	
		$fdata["FullName"]= "Year(`Last Updated on`)";
	
		
		
		
		
		
				$fdata["Index"]= 19;
				$fdata["EditParams"]="";
			
		$fdata["bListPage"]=true; 
	
		
		
		
		
		
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
				$fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");	
						
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["LU-Year"]=$fdata;
//	Created on
	$fdata = array();
	$fdata["strName"] = "Created on";
	$fdata["ownerTable"] = "customer_list";
		$fdata["Label"]="Created On"; 
	
		
		
	$fdata["FieldType"]= 135;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Date";
	$fdata["ViewFormat"]= "Short Date";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Created_on";
	
		$fdata["FullName"]= "`Created on`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 20;
		$fdata["DateEditType"] = 13; 
	$fdata["InitialYearFactor"] = 100; 
	$fdata["LastYearFactor"] = 10; 
			
		
		
		
		
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Created on"]=$fdata;
//	Assigned Executive
	$fdata = array();
	$fdata["strName"] = "Assigned Executive";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="username";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Full Name";
				$fdata["LookupTable"]="employee_list";
	$fdata["LookupOrderBy"]="";
																			
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Assigned_Executive";
	
		$fdata["FullName"]= "`Assigned Executive`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 21;
				
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Assigned Executive"]=$fdata;
//	Assigned Date
	$fdata = array();
	$fdata["strName"] = "Assigned Date";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 135;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Date";
	$fdata["ViewFormat"]= "Short Date";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Assigned_Date";
	
		$fdata["FullName"]= "`Assigned Date`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 22;
		$fdata["DateEditType"] = 11; 
	$fdata["InitialYearFactor"] = 100; 
	$fdata["LastYearFactor"] = 10; 
			
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Assigned Date"]=$fdata;
//	Aligned Partner
	$fdata = array();
	$fdata["strName"] = "Aligned Partner";
	$fdata["ownerTable"] = "customer_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="E-Mail";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Company Name";
				$fdata["LookupTable"]="partner_list";
	$fdata["LookupOrderBy"]="";
																			$fdata["SimpleAdd"]=true;
	
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Aligned_Partner";
	
		$fdata["FullName"]= "`Aligned Partner`";
	
		
		
		
		
		
				$fdata["Index"]= 23;
				
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		$fdata["bEditPage"]=true; 
	
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		$fdata["bPrinterPage"]=true; 
	
		$fdata["bExportPage"]=true; 
	
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataPending_Customers["Aligned Partner"]=$fdata;

	
$tables_data["Pending Customers"]=&$tdataPending_Customers;
$field_labels["Pending_Customers"] = &$fieldLabelsPending_Customers;
$fieldToolTips["Pending Customers"] = &$fieldToolTipsPending_Customers;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["Pending Customers"] = array();
$dIndex = 1-1;
			$strOriginalDetailsTable="cust_list_contact_person";
	$detailsTablesData["Pending Customers"][$dIndex] = array(
		  "dDataSourceTable"=>"Contact Details"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"Contact_Details"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT idCLCP,  Name,  `Job Title`,  `Phone- Direct`,  `Phone Extn`,  Mobile,  `E-Mail`,  Notes,  `Company Name`"	
		, "sqlFrom"=>"FROM cust_list_contact_person"	
		, "sqlWhere"=>""
		, "sqlTail"=>""
		, "groupBy"=>"0"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$detailsTablesData["Pending Customers"][$dIndex]["masterKeys"][]="Customer Name";
		$detailsTablesData["Pending Customers"][$dIndex]["detailKeys"][]="Company Name";

$dIndex = 2-1;
			$strOriginalDetailsTable="calls";
	$detailsTablesData["Pending Customers"][$dIndex] = array(
		  "dDataSourceTable"=>"calls"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"calls"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT idCalls,  `Date`,  `Call Details`,  `Executive Name`,  `Customer Name`"	
		, "sqlFrom"=>"FROM calls"	
		, "sqlWhere"=>""
		, "sqlTail"=>""
		, "groupBy"=>"0"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$detailsTablesData["Pending Customers"][$dIndex]["masterKeys"][]="Customer Name";
		$detailsTablesData["Pending Customers"][$dIndex]["detailKeys"][]="Customer Name";


	
// tables which are master tables for current table (detail)
$masterTablesData["Pending Customers"] = array();

// -----------------end  prepare master-details data arrays ------------------------------//

require_once(getabspath("classes/sql.php"));










$proto820=array();
$proto820["m_strHead"] = "Select";
$proto820["m_strFieldList"] = "idCL,  `Customer Name`,  Address,  City,  `State`,  Country,  `Postal Code`,  `Web address`,  Area,  Customer_Category,  `Breif About the Company`,  `Existing Setup`,  `Interaction Summary`,  `Commercial Summary`,  `Customer Status`,  Region,  `Last Updated on`,  MonthName(`Last Updated on`) AS `LU-Month`,  Year(`Last Updated on`) AS `LU-Year`,  `Created on`,  `Assigned Executive`,  `Assigned Date`,  `Aligned Partner`";
$proto820["m_strFrom"] = "FROM customer_list";
$proto820["m_strWhere"] = "(`Customer Status` = 'Pending')";
$proto820["m_strOrderBy"] = "ORDER BY idCL DESC";
$proto820["m_strTail"] = "";
$proto821=array();
$proto821["m_sql"] = "`Customer Status` = 'Pending'";
$proto821["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "Customer Status",
	"m_strTable" => "customer_list"
));

$proto821["m_column"]=$obj;
$proto821["m_contained"] = array();
$proto821["m_strCase"] = "= 'Pending'";
$proto821["m_havingmode"] = "0";
$proto821["m_inBrackets"] = "0";
$proto821["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto821);

$proto820["m_where"] = $obj;
$proto823=array();
$proto823["m_sql"] = "";
$proto823["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto823["m_column"]=$obj;
$proto823["m_contained"] = array();
$proto823["m_strCase"] = "";
$proto823["m_havingmode"] = "0";
$proto823["m_inBrackets"] = "0";
$proto823["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto823);

$proto820["m_having"] = $obj;
$proto820["m_fieldlist"] = array();
						$proto825=array();
			$obj = new SQLField(array(
	"m_strName" => "idCL",
	"m_strTable" => "customer_list"
));

$proto825["m_expr"]=$obj;
$proto825["m_alias"] = "";
$obj = new SQLFieldListItem($proto825);

$proto820["m_fieldlist"][]=$obj;
						$proto827=array();
			$obj = new SQLField(array(
	"m_strName" => "Customer Name",
	"m_strTable" => "customer_list"
));

$proto827["m_expr"]=$obj;
$proto827["m_alias"] = "";
$obj = new SQLFieldListItem($proto827);

$proto820["m_fieldlist"][]=$obj;
						$proto829=array();
			$obj = new SQLField(array(
	"m_strName" => "Address",
	"m_strTable" => "customer_list"
));

$proto829["m_expr"]=$obj;
$proto829["m_alias"] = "";
$obj = new SQLFieldListItem($proto829);

$proto820["m_fieldlist"][]=$obj;
						$proto831=array();
			$obj = new SQLField(array(
	"m_strName" => "City",
	"m_strTable" => "customer_list"
));

$proto831["m_expr"]=$obj;
$proto831["m_alias"] = "";
$obj = new SQLFieldListItem($proto831);

$proto820["m_fieldlist"][]=$obj;
						$proto833=array();
			$obj = new SQLField(array(
	"m_strName" => "State",
	"m_strTable" => "customer_list"
));

$proto833["m_expr"]=$obj;
$proto833["m_alias"] = "";
$obj = new SQLFieldListItem($proto833);

$proto820["m_fieldlist"][]=$obj;
						$proto835=array();
			$obj = new SQLField(array(
	"m_strName" => "Country",
	"m_strTable" => "customer_list"
));

$proto835["m_expr"]=$obj;
$proto835["m_alias"] = "";
$obj = new SQLFieldListItem($proto835);

$proto820["m_fieldlist"][]=$obj;
						$proto837=array();
			$obj = new SQLField(array(
	"m_strName" => "Postal Code",
	"m_strTable" => "customer_list"
));

$proto837["m_expr"]=$obj;
$proto837["m_alias"] = "";
$obj = new SQLFieldListItem($proto837);

$proto820["m_fieldlist"][]=$obj;
						$proto839=array();
			$obj = new SQLField(array(
	"m_strName" => "Web address",
	"m_strTable" => "customer_list"
));

$proto839["m_expr"]=$obj;
$proto839["m_alias"] = "";
$obj = new SQLFieldListItem($proto839);

$proto820["m_fieldlist"][]=$obj;
						$proto841=array();
			$obj = new SQLField(array(
	"m_strName" => "Area",
	"m_strTable" => "customer_list"
));

$proto841["m_expr"]=$obj;
$proto841["m_alias"] = "";
$obj = new SQLFieldListItem($proto841);

$proto820["m_fieldlist"][]=$obj;
						$proto843=array();
			$obj = new SQLField(array(
	"m_strName" => "Customer_Category",
	"m_strTable" => "customer_list"
));

$proto843["m_expr"]=$obj;
$proto843["m_alias"] = "";
$obj = new SQLFieldListItem($proto843);

$proto820["m_fieldlist"][]=$obj;
						$proto845=array();
			$obj = new SQLField(array(
	"m_strName" => "Breif About the Company",
	"m_strTable" => "customer_list"
));

$proto845["m_expr"]=$obj;
$proto845["m_alias"] = "";
$obj = new SQLFieldListItem($proto845);

$proto820["m_fieldlist"][]=$obj;
						$proto847=array();
			$obj = new SQLField(array(
	"m_strName" => "Existing Setup",
	"m_strTable" => "customer_list"
));

$proto847["m_expr"]=$obj;
$proto847["m_alias"] = "";
$obj = new SQLFieldListItem($proto847);

$proto820["m_fieldlist"][]=$obj;
						$proto849=array();
			$obj = new SQLField(array(
	"m_strName" => "Interaction Summary",
	"m_strTable" => "customer_list"
));

$proto849["m_expr"]=$obj;
$proto849["m_alias"] = "";
$obj = new SQLFieldListItem($proto849);

$proto820["m_fieldlist"][]=$obj;
						$proto851=array();
			$obj = new SQLField(array(
	"m_strName" => "Commercial Summary",
	"m_strTable" => "customer_list"
));

$proto851["m_expr"]=$obj;
$proto851["m_alias"] = "";
$obj = new SQLFieldListItem($proto851);

$proto820["m_fieldlist"][]=$obj;
						$proto853=array();
			$obj = new SQLField(array(
	"m_strName" => "Customer Status",
	"m_strTable" => "customer_list"
));

$proto853["m_expr"]=$obj;
$proto853["m_alias"] = "";
$obj = new SQLFieldListItem($proto853);

$proto820["m_fieldlist"][]=$obj;
						$proto855=array();
			$obj = new SQLField(array(
	"m_strName" => "Region",
	"m_strTable" => "customer_list"
));

$proto855["m_expr"]=$obj;
$proto855["m_alias"] = "";
$obj = new SQLFieldListItem($proto855);

$proto820["m_fieldlist"][]=$obj;
						$proto857=array();
			$obj = new SQLField(array(
	"m_strName" => "Last Updated on",
	"m_strTable" => "customer_list"
));

$proto857["m_expr"]=$obj;
$proto857["m_alias"] = "";
$obj = new SQLFieldListItem($proto857);

$proto820["m_fieldlist"][]=$obj;
						$proto859=array();
			$proto860=array();
$proto860["m_functiontype"] = "SQLF_CUSTOM";
$proto860["m_arguments"] = array();
						$obj = new SQLNonParsed(array(
	"m_sql" => "`Last Updated on`"
));

$proto860["m_arguments"][]=$obj;
$proto860["m_strFunctionName"] = "MonthName";
$obj = new SQLFunctionCall($proto860);

$proto859["m_expr"]=$obj;
$proto859["m_alias"] = "LU-Month";
$obj = new SQLFieldListItem($proto859);

$proto820["m_fieldlist"][]=$obj;
						$proto862=array();
			$proto863=array();
$proto863["m_functiontype"] = "SQLF_CUSTOM";
$proto863["m_arguments"] = array();
						$obj = new SQLNonParsed(array(
	"m_sql" => "`Last Updated on`"
));

$proto863["m_arguments"][]=$obj;
$proto863["m_strFunctionName"] = "Year";
$obj = new SQLFunctionCall($proto863);

$proto862["m_expr"]=$obj;
$proto862["m_alias"] = "LU-Year";
$obj = new SQLFieldListItem($proto862);

$proto820["m_fieldlist"][]=$obj;
						$proto865=array();
			$obj = new SQLField(array(
	"m_strName" => "Created on",
	"m_strTable" => "customer_list"
));

$proto865["m_expr"]=$obj;
$proto865["m_alias"] = "";
$obj = new SQLFieldListItem($proto865);

$proto820["m_fieldlist"][]=$obj;
						$proto867=array();
			$obj = new SQLField(array(
	"m_strName" => "Assigned Executive",
	"m_strTable" => "customer_list"
));

$proto867["m_expr"]=$obj;
$proto867["m_alias"] = "";
$obj = new SQLFieldListItem($proto867);

$proto820["m_fieldlist"][]=$obj;
						$proto869=array();
			$obj = new SQLField(array(
	"m_strName" => "Assigned Date",
	"m_strTable" => "customer_list"
));

$proto869["m_expr"]=$obj;
$proto869["m_alias"] = "";
$obj = new SQLFieldListItem($proto869);

$proto820["m_fieldlist"][]=$obj;
						$proto871=array();
			$obj = new SQLField(array(
	"m_strName" => "Aligned Partner",
	"m_strTable" => "customer_list"
));

$proto871["m_expr"]=$obj;
$proto871["m_alias"] = "";
$obj = new SQLFieldListItem($proto871);

$proto820["m_fieldlist"][]=$obj;
$proto820["m_fromlist"] = array();
												$proto873=array();
$proto873["m_link"] = "SQLL_MAIN";
			$proto874=array();
$proto874["m_strName"] = "customer_list";
$proto874["m_columns"] = array();
$proto874["m_columns"][] = "idCL";
$proto874["m_columns"][] = "Created on";
$proto874["m_columns"][] = "Region";
$proto874["m_columns"][] = "Customer Name";
$proto874["m_columns"][] = "Address";
$proto874["m_columns"][] = "City";
$proto874["m_columns"][] = "State";
$proto874["m_columns"][] = "Country";
$proto874["m_columns"][] = "Postal Code";
$proto874["m_columns"][] = "Web address";
$proto874["m_columns"][] = "Area";
$proto874["m_columns"][] = "Customer_Category";
$proto874["m_columns"][] = "Breif About the Company";
$proto874["m_columns"][] = "Existing Setup";
$proto874["m_columns"][] = "Interaction Summary";
$proto874["m_columns"][] = "Commercial Summary";
$proto874["m_columns"][] = "Customer Status";
$proto874["m_columns"][] = "Assigned Executive";
$proto874["m_columns"][] = "Assigned Date";
$proto874["m_columns"][] = "Last Updated on";
$proto874["m_columns"][] = "Aligned Partner";
$obj = new SQLTable($proto874);

$proto873["m_table"] = $obj;
$proto873["m_alias"] = "";
$proto875=array();
$proto875["m_sql"] = "";
$proto875["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto875["m_column"]=$obj;
$proto875["m_contained"] = array();
$proto875["m_strCase"] = "";
$proto875["m_havingmode"] = "0";
$proto875["m_inBrackets"] = "0";
$proto875["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto875);

$proto873["m_joinon"] = $obj;
$obj = new SQLFromListItem($proto873);

$proto820["m_fromlist"][]=$obj;
$proto820["m_groupby"] = array();
$proto820["m_orderby"] = array();
												$proto877=array();
						$obj = new SQLField(array(
	"m_strName" => "idCL",
	"m_strTable" => "customer_list"
));

$proto877["m_column"]=$obj;
$proto877["m_bAsc"] = 0;
$proto877["m_nColumn"] = 0;
$obj = new SQLOrderByItem($proto877);

$proto820["m_orderby"][]=$obj;					
$obj = new SQLQuery($proto820);

$queryData_Pending_Customers = $obj;
$tdataPending_Customers[".sqlquery"] = $queryData_Pending_Customers;

$tableEvents["Pending Customers"] = new eventsBase;

?>
