<?php



$tdatatb_provisao_caixa = array();
$tdatatb_provisao_caixa[".searchableFields"] = array();
$tdatatb_provisao_caixa[".ShortName"] = "tb_provisao_caixa";
$tdatatb_provisao_caixa[".OwnerID"] = "";
$tdatatb_provisao_caixa[".OriginalTable"] = "tb_provisao_caixa";


$tdatatb_provisao_caixa[".pagesByType"] = my_json_decode( "{\"add\":[\"add\"],\"export\":[\"export\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" );
$tdatatb_provisao_caixa[".originalPagesByType"] = $tdatatb_provisao_caixa[".pagesByType"];
$tdatatb_provisao_caixa[".pages"] = types2pages( my_json_decode( "{\"add\":[\"add\"],\"export\":[\"export\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" ) );
$tdatatb_provisao_caixa[".originalPages"] = $tdatatb_provisao_caixa[".pages"];
$tdatatb_provisao_caixa[".defaultPages"] = my_json_decode( "{\"add\":\"add\",\"export\":\"export\",\"list\":\"list\",\"print\":\"print\",\"search\":\"search\",\"view\":\"view\"}" );
$tdatatb_provisao_caixa[".originalDefaultPages"] = $tdatatb_provisao_caixa[".defaultPages"];

//	field labels
$fieldLabelstb_provisao_caixa = array();
$fieldToolTipstb_provisao_caixa = array();
$pageTitlestb_provisao_caixa = array();
$placeHolderstb_provisao_caixa = array();

if(mlang_getcurrentlang()=="Portuguese(Brazil)")
{
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"] = array();
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"] = array();
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"] = array();
	$pageTitlestb_provisao_caixa["Portuguese(Brazil)"] = array();
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["ID"] = "ID";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["ID"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["ID"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["data"] = "Data";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["data"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["data"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["dt_inicial"] = "Dt Inicial";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["dt_inicial"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["dt_inicial"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["dt_final"] = "Dt Final";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["dt_final"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["dt_final"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["fechacxID"] = "Fechacx ID";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["fechacxID"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["fechacxID"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["PIP"] = "PIP";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["PIP"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["PIP"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["qtd"] = "Qtd";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["qtd"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["qtd"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["cota_a"] = " A";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["cota_a"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["cota_a"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["cota_b"] = " B";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["cota_b"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["cota_b"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["cota_c"] = " C";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["cota_c"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["cota_c"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["cota_d"] = " D";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["cota_d"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["cota_d"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["faturado"] = "Faturado";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["faturado"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["faturado"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["data_fatura"] = "Data Fatura";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["data_fatura"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["data_fatura"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CMat"] = "CMat";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CMat"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CMat"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CMO"] = "CMO";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CMO"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CMO"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["GGF"] = "GGF";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["GGF"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["GGF"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["RModel"] = "RModel";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["RModel"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["RModel"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["referencia"] = "Referencia";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["referencia"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["referencia"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CBruto"] = "CBruto";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CBruto"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CBruto"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["PVenda"] = "PVenda";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["PVenda"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["PVenda"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["MKP"] = "MKP";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["MKP"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["MKP"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["LPrev"] = "LPrev";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["LPrev"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["LPrev"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["LReal"] = "LReal";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["LReal"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["LReal"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["Prov_material"] = "Material";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["Prov_material"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["Prov_material"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["Prov_GGF"] = "GGF";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["Prov_GGF"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["Prov_GGF"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["Prov_TMO"] = "M.Obra";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["Prov_TMO"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["Prov_TMO"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["Prov_model"] = "Model";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["Prov_model"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["Prov_model"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["retencao"] = "Retencao";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["retencao"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["retencao"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CA"] = "CA";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CA"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CA"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CB"] = "CB";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CB"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CB"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CC"] = "CC";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CC"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CC"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["CD"] = "CD";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["CD"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["CD"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["Faturamento"] = "Faturamento";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["Faturamento"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["Faturamento"] = "";
	$fieldLabelstb_provisao_caixa["Portuguese(Brazil)"]["v_unit"] = "V.Unit.";
	$fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]["v_unit"] = "";
	$placeHolderstb_provisao_caixa["Portuguese(Brazil)"]["v_unit"] = "";
	if (count($fieldToolTipstb_provisao_caixa["Portuguese(Brazil)"]))
		$tdatatb_provisao_caixa[".isUseToolTips"] = true;
}


	$tdatatb_provisao_caixa[".NCSearch"] = true;


	$tdatatb_provisao_caixa[".scrollGridBody"] = true;

$tdatatb_provisao_caixa[".shortTableName"] = "tb_provisao_caixa";
$tdatatb_provisao_caixa[".nSecOptions"] = 0;

$tdatatb_provisao_caixa[".mainTableOwnerID"] = "";
$tdatatb_provisao_caixa[".entityType"] = 0;

$tdatatb_provisao_caixa[".strOriginalTableName"] = "tb_provisao_caixa";

	



$tdatatb_provisao_caixa[".showAddInPopup"] = false;

$tdatatb_provisao_caixa[".showEditInPopup"] = false;

$tdatatb_provisao_caixa[".showViewInPopup"] = false;

//page's base css files names
$popupPagesLayoutNames = array();
$tdatatb_provisao_caixa[".popupPagesLayoutNames"] = $popupPagesLayoutNames;


$tdatatb_provisao_caixa[".listAjax"] = false;
//	temporary
$tdatatb_provisao_caixa[".listAjax"] = false;

	$tdatatb_provisao_caixa[".audit"] = false;

	$tdatatb_provisao_caixa[".locking"] = false;


$pages = $tdatatb_provisao_caixa[".defaultPages"];

if( $pages[PAGE_EDIT] ) {
	$tdatatb_provisao_caixa[".edit"] = true;
	$tdatatb_provisao_caixa[".afterEditAction"] = 0;
	$tdatatb_provisao_caixa[".closePopupAfterEdit"] = 1;
	$tdatatb_provisao_caixa[".afterEditActionDetTable"] = "Detail tables not found!";
}

if( $pages[PAGE_ADD] ) {
$tdatatb_provisao_caixa[".add"] = true;
$tdatatb_provisao_caixa[".afterAddAction"] = 0;
$tdatatb_provisao_caixa[".closePopupAfterAdd"] = 1;
$tdatatb_provisao_caixa[".afterAddActionDetTable"] = "Detail tables not found!";
}

if( $pages[PAGE_LIST] ) {
	$tdatatb_provisao_caixa[".list"] = true;
}



$tdatatb_provisao_caixa[".strSortControlSettingsJSON"] = "[]";




if( $pages[PAGE_VIEW] ) {
$tdatatb_provisao_caixa[".view"] = true;
}

if( $pages[PAGE_IMPORT] ) {
$tdatatb_provisao_caixa[".import"] = true;
}

if( $pages[PAGE_EXPORT] ) {
$tdatatb_provisao_caixa[".exportTo"] = true;
}

if( $pages[PAGE_PRINT] ) {
$tdatatb_provisao_caixa[".printFriendly"] = true;
}



$tdatatb_provisao_caixa[".showSimpleSearchOptions"] = true; // temp fix #13449

// Allow Show/Hide Fields in GRID
$tdatatb_provisao_caixa[".allowShowHideFields"] = true; // temp fix #13449
//

// Allow Fields Reordering in GRID
$tdatatb_provisao_caixa[".allowFieldsReordering"] = true; // temp fix #13449
//

$tdatatb_provisao_caixa[".isUseAjaxSuggest"] = true;

$tdatatb_provisao_caixa[".rowHighlite"] = true;





$tdatatb_provisao_caixa[".ajaxCodeSnippetAdded"] = false;

$tdatatb_provisao_caixa[".buttonsAdded"] = false;

$tdatatb_provisao_caixa[".addPageEvents"] = false;

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


$tdatatb_provisao_caixa[".badgeColor"] = "edca00";


$tdatatb_provisao_caixa[".allSearchFields"] = array();
$tdatatb_provisao_caixa[".filterFields"] = array();
$tdatatb_provisao_caixa[".requiredSearchFields"] = array();

$tdatatb_provisao_caixa[".googleLikeFields"] = array();
$tdatatb_provisao_caixa[".googleLikeFields"][] = "ID";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "data";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "dt_inicial";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "dt_final";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "fechacxID";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "PIP";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "qtd";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "cota_a";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "cota_b";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "cota_c";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "cota_d";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "faturado";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "data_fatura";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CMat";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CMO";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "GGF";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "RModel";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "referencia";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CBruto";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "PVenda";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "MKP";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "LPrev";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "LReal";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "Prov_material";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "Prov_GGF";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "Prov_TMO";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "Prov_model";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "retencao";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CA";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CB";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CC";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "CD";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "Faturamento";
$tdatatb_provisao_caixa[".googleLikeFields"][] = "v_unit";



$tdatatb_provisao_caixa[".tableType"] = "list";

$tdatatb_provisao_caixa[".printerPageOrientation"] = 1;
$tdatatb_provisao_caixa[".nPrinterPageScale"] = 100;

$tdatatb_provisao_caixa[".nPrinterSplitRecords"] = 40;

$tdatatb_provisao_caixa[".geocodingEnabled"] = false;










$tdatatb_provisao_caixa[".pageSize"] = 20;

$tdatatb_provisao_caixa[".warnLeavingPages"] = true;



$tstrOrderBy = "";
if(strlen($tstrOrderBy) && strtolower(substr($tstrOrderBy,0,8))!="order by")
	$tstrOrderBy = "order by ".$tstrOrderBy;
$tdatatb_provisao_caixa[".strOrderBy"] = $tstrOrderBy;

$tdatatb_provisao_caixa[".orderindexes"] = array();

$tdatatb_provisao_caixa[".sqlHead"] = "SELECT tb_provisao_caixa.ID,  tb_provisao_caixa.`data`,  tb_provisao_caixa.dt_inicial,  tb_provisao_caixa.dt_final,  tb_provisao_caixa.fechacxID,  Concat(dbw_faturados.pedID, \"/\", dbw_faturados.itemID, \"/\", dbw_faturados.pdtoID) AS PIP,  dbw_faturados.qtd,  dbw_faturados.cota_a,  dbw_faturados.cota_b,  dbw_faturados.cota_c,  dbw_faturados.cota_d,  dbw_faturados.faturado,  dbw_faturados.data_fatura,  dbw_resumo_calculo.CMat,  dbw_resumo_calculo.CMO,  dbw_resumo_calculo.GGF,  dbw_resumo_calculo.RModel,  dbw_resumo_calculo.referencia,  dbw_resumo_calculo.CBruto,  dbw_resumo_calculo.PVenda,  dbw_resumo_calculo.MKP,  (dbw_resumo_calculo.PVenda-dbw_resumo_calculo.CBruto)*dbw_faturados.qtd AS LPrev,  (dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd AS LReal,  (dbw_faturados.qtd * dbw_resumo_calculo.CMat) AS Prov_material,  (dbw_faturados.qtd * dbw_resumo_calculo.GGF) AS Prov_GGF,  (dbw_faturados.qtd * dbw_resumo_calculo.CMO) AS Prov_TMO,  (dbw_faturados.qtd * dbw_resumo_calculo.RModel) AS Prov_model,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMat)+(dbw_faturados.qtd * dbw_resumo_calculo.GGF))+((dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd) AS retencao,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_a/100)) AS CA,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_b/100))+ (dbw_faturados.qtd * dbw_resumo_calculo.RModel) AS CB,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_c/100)) AS CC,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_d/100)) AS CD,  dbw_faturados.Faturamento,  dbw_faturados.v_unit";
$tdatatb_provisao_caixa[".sqlFrom"] = "FROM tb_provisao_caixa  , dbw_faturados  RIGHT OUTER JOIN dbw_resumo_calculo ON dbw_resumo_calculo.pdtoID = dbw_faturados.pdtoID";
$tdatatb_provisao_caixa[".sqlWhereExpr"] = "(dbw_faturados.faturado =1) AND (dbw_faturados.data_fatura >= tb_provisao_caixa.dt_inicial) AND (dbw_faturados.data_fatura <= tb_provisao_caixa.dt_final)";
$tdatatb_provisao_caixa[".sqlTail"] = "";










//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;
$tdatatb_provisao_caixa[".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;
$tdatatb_provisao_caixa[".arrGroupsPerPage"] = $arrGPP;

$tdatatb_provisao_caixa[".highlightSearchResults"] = true;

$tableKeystb_provisao_caixa = array();
$tableKeystb_provisao_caixa[] = "ID";
$tdatatb_provisao_caixa[".Keys"] = $tableKeystb_provisao_caixa;


$tdatatb_provisao_caixa[".hideMobileList"] = array();




//	ID
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 1;
	$fdata["strName"] = "ID";
	$fdata["GoodName"] = "ID";
	$fdata["ownerTable"] = "tb_provisao_caixa";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","ID");
	$fdata["FieldType"] = 3;

	
	
	
			

		$fdata["strField"] = "ID";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "tb_provisao_caixa.ID";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["ID"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "ID";
//	data
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 2;
	$fdata["strName"] = "data";
	$fdata["GoodName"] = "data";
	$fdata["ownerTable"] = "tb_provisao_caixa";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","data");
	$fdata["FieldType"] = 7;

	
	
	
			

		$fdata["strField"] = "data";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "tb_provisao_caixa.`data`";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Short Date");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Date");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
		$edata["DateEditType"] = 13;
	$edata["InitialYearFactor"] = 100;
	$edata["LastYearFactor"] = 10;

	
	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Equals";

			// the default search options list
				$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between", EMPTY_SEARCH, NOT_EMPTY );
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["data"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "data";
//	dt_inicial
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 3;
	$fdata["strName"] = "dt_inicial";
	$fdata["GoodName"] = "dt_inicial";
	$fdata["ownerTable"] = "tb_provisao_caixa";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","dt_inicial");
	$fdata["FieldType"] = 7;

	
	
	
			

		$fdata["strField"] = "dt_inicial";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "tb_provisao_caixa.dt_inicial";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Short Date");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Date");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
		$edata["DateEditType"] = 13;
	$edata["InitialYearFactor"] = 100;
	$edata["LastYearFactor"] = 10;

	
	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Equals";

			// the default search options list
				$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between", EMPTY_SEARCH, NOT_EMPTY );
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["dt_inicial"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "dt_inicial";
//	dt_final
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 4;
	$fdata["strName"] = "dt_final";
	$fdata["GoodName"] = "dt_final";
	$fdata["ownerTable"] = "tb_provisao_caixa";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","dt_final");
	$fdata["FieldType"] = 7;

	
	
	
			

		$fdata["strField"] = "dt_final";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "tb_provisao_caixa.dt_final";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Short Date");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Date");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
		$edata["DateEditType"] = 13;
	$edata["InitialYearFactor"] = 100;
	$edata["LastYearFactor"] = 10;

	
	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Equals";

			// the default search options list
				$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between", EMPTY_SEARCH, NOT_EMPTY );
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["dt_final"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "dt_final";
//	fechacxID
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 5;
	$fdata["strName"] = "fechacxID";
	$fdata["GoodName"] = "fechacxID";
	$fdata["ownerTable"] = "tb_provisao_caixa";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","fechacxID");
	$fdata["FieldType"] = 3;

	
	
	
			

		$fdata["strField"] = "fechacxID";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "tb_provisao_caixa.fechacxID";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["fechacxID"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "fechacxID";
//	PIP
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 6;
	$fdata["strName"] = "PIP";
	$fdata["GoodName"] = "PIP";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","PIP");
	$fdata["FieldType"] = 200;

	
	
	
			

		$fdata["strField"] = "PIP";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Concat(dbw_faturados.pedID, \"/\", dbw_faturados.itemID, \"/\", dbw_faturados.pdtoID)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["PIP"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "PIP";
//	qtd
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 7;
	$fdata["strName"] = "qtd";
	$fdata["GoodName"] = "qtd";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","qtd");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "qtd";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.qtd";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 1;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["qtd"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "qtd";
//	cota_a
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 8;
	$fdata["strName"] = "cota_a";
	$fdata["GoodName"] = "cota_a";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","cota_a");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "cota_a";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.cota_a";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 0;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["cota_a"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "cota_a";
//	cota_b
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 9;
	$fdata["strName"] = "cota_b";
	$fdata["GoodName"] = "cota_b";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","cota_b");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "cota_b";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.cota_b";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 0;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["cota_b"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "cota_b";
//	cota_c
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 10;
	$fdata["strName"] = "cota_c";
	$fdata["GoodName"] = "cota_c";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","cota_c");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "cota_c";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.cota_c";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 0;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["cota_c"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "cota_c";
//	cota_d
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 11;
	$fdata["strName"] = "cota_d";
	$fdata["GoodName"] = "cota_d";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","cota_d");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "cota_d";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.cota_d";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 0;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["cota_d"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "cota_d";
//	faturado
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 12;
	$fdata["strName"] = "faturado";
	$fdata["GoodName"] = "faturado";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","faturado");
	$fdata["FieldType"] = 3;

	
	
	
			

		$fdata["strField"] = "faturado";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.faturado";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Checkbox");

	
	
	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Checkbox");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
							
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Equals";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["faturado"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "faturado";
//	data_fatura
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 13;
	$fdata["strName"] = "data_fatura";
	$fdata["GoodName"] = "data_fatura";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","data_fatura");
	$fdata["FieldType"] = 7;

	
	
	
			

		$fdata["strField"] = "data_fatura";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.data_fatura";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Short Date");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Date");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
		$edata["DateEditType"] = 13;
	$edata["InitialYearFactor"] = 100;
	$edata["LastYearFactor"] = 10;

	
	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Equals";

			// the default search options list
				$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between", EMPTY_SEARCH, NOT_EMPTY );
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["data_fatura"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "data_fatura";
//	CMat
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 14;
	$fdata["strName"] = "CMat";
	$fdata["GoodName"] = "CMat";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CMat");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "CMat";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.CMat";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CMat"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CMat";
//	CMO
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 15;
	$fdata["strName"] = "CMO";
	$fdata["GoodName"] = "CMO";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CMO");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CMO";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.CMO";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CMO"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CMO";
//	GGF
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 16;
	$fdata["strName"] = "GGF";
	$fdata["GoodName"] = "GGF";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","GGF");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "GGF";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.GGF";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["GGF"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "GGF";
//	RModel
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 17;
	$fdata["strName"] = "RModel";
	$fdata["GoodName"] = "RModel";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","RModel");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "RModel";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.RModel";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["RModel"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "RModel";
//	referencia
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 18;
	$fdata["strName"] = "referencia";
	$fdata["GoodName"] = "referencia";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","referencia");
	$fdata["FieldType"] = 200;

	
	
	
			

		$fdata["strField"] = "referencia";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.referencia";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["referencia"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "referencia";
//	CBruto
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 19;
	$fdata["strName"] = "CBruto";
	$fdata["GoodName"] = "CBruto";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CBruto");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CBruto";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.CBruto";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CBruto"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CBruto";
//	PVenda
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 20;
	$fdata["strName"] = "PVenda";
	$fdata["GoodName"] = "PVenda";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","PVenda");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "PVenda";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.PVenda";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["PVenda"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "PVenda";
//	MKP
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 21;
	$fdata["strName"] = "MKP";
	$fdata["GoodName"] = "MKP";
	$fdata["ownerTable"] = "dbw_resumo_calculo";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","MKP");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "MKP";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_resumo_calculo.MKP";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 0;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["MKP"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "MKP";
//	LPrev
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 22;
	$fdata["strName"] = "LPrev";
	$fdata["GoodName"] = "LPrev";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","LPrev");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "LPrev";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_resumo_calculo.PVenda-dbw_resumo_calculo.CBruto)*dbw_faturados.qtd";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["LPrev"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "LPrev";
//	LReal
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 23;
	$fdata["strName"] = "LReal";
	$fdata["GoodName"] = "LReal";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","LReal");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "LReal";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["LReal"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "LReal";
//	Prov_material
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 24;
	$fdata["strName"] = "Prov_material";
	$fdata["GoodName"] = "Prov_material";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","Prov_material");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "Prov_material";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_faturados.qtd * dbw_resumo_calculo.CMat)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["Prov_material"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "Prov_material";
//	Prov_GGF
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 25;
	$fdata["strName"] = "Prov_GGF";
	$fdata["GoodName"] = "Prov_GGF";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","Prov_GGF");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "Prov_GGF";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_faturados.qtd * dbw_resumo_calculo.GGF)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["Prov_GGF"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "Prov_GGF";
//	Prov_TMO
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 26;
	$fdata["strName"] = "Prov_TMO";
	$fdata["GoodName"] = "Prov_TMO";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","Prov_TMO");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "Prov_TMO";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_faturados.qtd * dbw_resumo_calculo.CMO)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["Prov_TMO"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "Prov_TMO";
//	Prov_model
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 27;
	$fdata["strName"] = "Prov_model";
	$fdata["GoodName"] = "Prov_model";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","Prov_model");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "Prov_model";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "(dbw_faturados.qtd * dbw_resumo_calculo.RModel)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["Prov_model"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "Prov_model";
//	retencao
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 28;
	$fdata["strName"] = "retencao";
	$fdata["GoodName"] = "retencao";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","retencao");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "retencao";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMat)+(dbw_faturados.qtd * dbw_resumo_calculo.GGF))+((dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["retencao"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "retencao";
//	CA
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 29;
	$fdata["strName"] = "CA";
	$fdata["GoodName"] = "CA";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CA");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CA";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_a/100))";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CA"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CA";
//	CB
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 30;
	$fdata["strName"] = "CB";
	$fdata["GoodName"] = "CB";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CB");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CB";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_b/100))+ (dbw_faturados.qtd * dbw_resumo_calculo.RModel)";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CB"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CB";
//	CC
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 31;
	$fdata["strName"] = "CC";
	$fdata["GoodName"] = "CC";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CC");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CC";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_c/100))";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CC"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CC";
//	CD
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 32;
	$fdata["strName"] = "CD";
	$fdata["GoodName"] = "CD";
	$fdata["ownerTable"] = "";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","CD");
	$fdata["FieldType"] = 5;

	
	
	
			

		$fdata["strField"] = "CD";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_d/100))";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["CD"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "CD";
//	Faturamento
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 33;
	$fdata["strName"] = "Faturamento";
	$fdata["GoodName"] = "Faturamento";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","Faturamento");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "Faturamento";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.Faturamento";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["Faturamento"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "Faturamento";
//	v_unit
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 34;
	$fdata["strName"] = "v_unit";
	$fdata["GoodName"] = "v_unit";
	$fdata["ownerTable"] = "dbw_faturados";
	$fdata["Label"] = GetFieldLabel("tb_provisao_caixa","v_unit");
	$fdata["FieldType"] = 14;

	
	
	
			

		$fdata["strField"] = "v_unit";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "dbw_faturados.v_unit";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Currency");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



		$edata["IsRequired"] = true;

	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
						$edata["validateAs"]["basicValidate"][] = "IsRequired";
		
	
	//	End validation

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatatb_provisao_caixa["v_unit"] = $fdata;
		$tdatatb_provisao_caixa[".searchableFields"][] = "v_unit";


$tables_data["tb_provisao_caixa"]=&$tdatatb_provisao_caixa;
$field_labels["tb_provisao_caixa"] = &$fieldLabelstb_provisao_caixa;
$fieldToolTips["tb_provisao_caixa"] = &$fieldToolTipstb_provisao_caixa;
$placeHolders["tb_provisao_caixa"] = &$placeHolderstb_provisao_caixa;
$page_titles["tb_provisao_caixa"] = &$pageTitlestb_provisao_caixa;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["tb_provisao_caixa"] = array();

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



	
				$strOriginalDetailsTable="tb_fecha_cx";
	$masterParams = array();
	$masterParams["mDataSourceTable"]="tb_fecha_cx";
	$masterParams["mOriginalTable"]= $strOriginalDetailsTable;
	$masterParams["mShortTable"]= "tb_fecha_cx";
	$masterParams["masterKeys"]= array();
	$masterParams["detailKeys"]= array();

	$masterParams["type"] = PAGE_LIST;
					$masterTablesData["tb_provisao_caixa"][0] = $masterParams;
				$masterTablesData["tb_provisao_caixa"][0]["masterKeys"] = array();
	$masterTablesData["tb_provisao_caixa"][0]["masterKeys"][]="fcxID";
				$masterTablesData["tb_provisao_caixa"][0]["masterKeys"][]="dt_fechamento";
				$masterTablesData["tb_provisao_caixa"][0]["masterKeys"][]="periodo_in";
				$masterTablesData["tb_provisao_caixa"][0]["masterKeys"][]="Periodo_out";
				$masterTablesData["tb_provisao_caixa"][0]["detailKeys"] = array();
	$masterTablesData["tb_provisao_caixa"][0]["detailKeys"][]="fechacxID";
				$masterTablesData["tb_provisao_caixa"][0]["detailKeys"][]="data";
				$masterTablesData["tb_provisao_caixa"][0]["detailKeys"][]="dt_inicial";
				$masterTablesData["tb_provisao_caixa"][0]["detailKeys"][]="dt_final";
		
// -----------------end  prepare master-details data arrays ------------------------------//


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










function createSqlQuery_tb_provisao_caixa()
{
$proto0=array();
$proto0["m_strHead"] = "SELECT";
$proto0["m_strFieldList"] = "tb_provisao_caixa.ID,  tb_provisao_caixa.`data`,  tb_provisao_caixa.dt_inicial,  tb_provisao_caixa.dt_final,  tb_provisao_caixa.fechacxID,  Concat(dbw_faturados.pedID, \"/\", dbw_faturados.itemID, \"/\", dbw_faturados.pdtoID) AS PIP,  dbw_faturados.qtd,  dbw_faturados.cota_a,  dbw_faturados.cota_b,  dbw_faturados.cota_c,  dbw_faturados.cota_d,  dbw_faturados.faturado,  dbw_faturados.data_fatura,  dbw_resumo_calculo.CMat,  dbw_resumo_calculo.CMO,  dbw_resumo_calculo.GGF,  dbw_resumo_calculo.RModel,  dbw_resumo_calculo.referencia,  dbw_resumo_calculo.CBruto,  dbw_resumo_calculo.PVenda,  dbw_resumo_calculo.MKP,  (dbw_resumo_calculo.PVenda-dbw_resumo_calculo.CBruto)*dbw_faturados.qtd AS LPrev,  (dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd AS LReal,  (dbw_faturados.qtd * dbw_resumo_calculo.CMat) AS Prov_material,  (dbw_faturados.qtd * dbw_resumo_calculo.GGF) AS Prov_GGF,  (dbw_faturados.qtd * dbw_resumo_calculo.CMO) AS Prov_TMO,  (dbw_faturados.qtd * dbw_resumo_calculo.RModel) AS Prov_model,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMat)+(dbw_faturados.qtd * dbw_resumo_calculo.GGF))+((dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd) AS retencao,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_a/100)) AS CA,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_b/100))+ (dbw_faturados.qtd * dbw_resumo_calculo.RModel) AS CB,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_c/100)) AS CC,  ((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_d/100)) AS CD,  dbw_faturados.Faturamento,  dbw_faturados.v_unit";
$proto0["m_strFrom"] = "FROM tb_provisao_caixa  , dbw_faturados  RIGHT OUTER JOIN dbw_resumo_calculo ON dbw_resumo_calculo.pdtoID = dbw_faturados.pdtoID";
$proto0["m_strWhere"] = "(dbw_faturados.faturado =1) AND (dbw_faturados.data_fatura >= tb_provisao_caixa.dt_inicial) AND (dbw_faturados.data_fatura <= tb_provisao_caixa.dt_final)";
$proto0["m_strOrderBy"] = "";
	
		;
			$proto0["cipherer"] = null;
$proto2=array();
$proto2["m_sql"] = "(dbw_faturados.faturado =1) AND (dbw_faturados.data_fatura >= tb_provisao_caixa.dt_inicial) AND (dbw_faturados.data_fatura <= tb_provisao_caixa.dt_final)";
$proto2["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.faturado =1) AND (dbw_faturados.data_fatura >= tb_provisao_caixa.dt_inicial) AND (dbw_faturados.data_fatura <= tb_provisao_caixa.dt_final)"
));

$proto2["m_column"]=$obj;
$proto2["m_contained"] = array();
						$proto4=array();
$proto4["m_sql"] = "dbw_faturados.faturado =1";
$proto4["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "faturado",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto4["m_column"]=$obj;
$proto4["m_contained"] = array();
$proto4["m_strCase"] = "=1";
$proto4["m_havingmode"] = false;
$proto4["m_inBrackets"] = true;
$proto4["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto4);

			$proto2["m_contained"][]=$obj;
						$proto6=array();
$proto6["m_sql"] = "dbw_faturados.data_fatura >= tb_provisao_caixa.dt_inicial";
$proto6["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "data_fatura",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto6["m_column"]=$obj;
$proto6["m_contained"] = array();
$proto6["m_strCase"] = ">= tb_provisao_caixa.dt_inicial";
$proto6["m_havingmode"] = false;
$proto6["m_inBrackets"] = true;
$proto6["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto6);

			$proto2["m_contained"][]=$obj;
						$proto8=array();
$proto8["m_sql"] = "dbw_faturados.data_fatura <= tb_provisao_caixa.dt_final";
$proto8["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "data_fatura",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto8["m_column"]=$obj;
$proto8["m_contained"] = array();
$proto8["m_strCase"] = "<= tb_provisao_caixa.dt_final";
$proto8["m_havingmode"] = false;
$proto8["m_inBrackets"] = true;
$proto8["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto8);

			$proto2["m_contained"][]=$obj;
$proto2["m_strCase"] = "";
$proto2["m_havingmode"] = false;
$proto2["m_inBrackets"] = false;
$proto2["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto2);

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

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

$proto0["m_having"] = $obj;
$proto0["m_fieldlist"] = array();
						$proto12=array();
			$obj = new SQLField(array(
	"m_strName" => "ID",
	"m_strTable" => "tb_provisao_caixa",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto12["m_sql"] = "tb_provisao_caixa.ID";
$proto12["m_srcTableName"] = "tb_provisao_caixa";
$proto12["m_expr"]=$obj;
$proto12["m_alias"] = "";
$obj = new SQLFieldListItem($proto12);

$proto0["m_fieldlist"][]=$obj;
						$proto14=array();
			$obj = new SQLField(array(
	"m_strName" => "data",
	"m_strTable" => "tb_provisao_caixa",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto14["m_sql"] = "tb_provisao_caixa.`data`";
$proto14["m_srcTableName"] = "tb_provisao_caixa";
$proto14["m_expr"]=$obj;
$proto14["m_alias"] = "";
$obj = new SQLFieldListItem($proto14);

$proto0["m_fieldlist"][]=$obj;
						$proto16=array();
			$obj = new SQLField(array(
	"m_strName" => "dt_inicial",
	"m_strTable" => "tb_provisao_caixa",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto16["m_sql"] = "tb_provisao_caixa.dt_inicial";
$proto16["m_srcTableName"] = "tb_provisao_caixa";
$proto16["m_expr"]=$obj;
$proto16["m_alias"] = "";
$obj = new SQLFieldListItem($proto16);

$proto0["m_fieldlist"][]=$obj;
						$proto18=array();
			$obj = new SQLField(array(
	"m_strName" => "dt_final",
	"m_strTable" => "tb_provisao_caixa",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto18["m_sql"] = "tb_provisao_caixa.dt_final";
$proto18["m_srcTableName"] = "tb_provisao_caixa";
$proto18["m_expr"]=$obj;
$proto18["m_alias"] = "";
$obj = new SQLFieldListItem($proto18);

$proto0["m_fieldlist"][]=$obj;
						$proto20=array();
			$obj = new SQLField(array(
	"m_strName" => "fechacxID",
	"m_strTable" => "tb_provisao_caixa",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto20["m_sql"] = "tb_provisao_caixa.fechacxID";
$proto20["m_srcTableName"] = "tb_provisao_caixa";
$proto20["m_expr"]=$obj;
$proto20["m_alias"] = "";
$obj = new SQLFieldListItem($proto20);

$proto0["m_fieldlist"][]=$obj;
						$proto22=array();
			$proto23=array();
$proto23["m_functiontype"] = "SQLF_CUSTOM";
$proto23["m_arguments"] = array();
						$obj = new SQLNonParsed(array(
	"m_sql" => "dbw_faturados.pedID"
));

$proto23["m_arguments"][]=$obj;
						$obj = new SQLNonParsed(array(
	"m_sql" => "\"/\""
));

$proto23["m_arguments"][]=$obj;
						$obj = new SQLNonParsed(array(
	"m_sql" => "dbw_faturados.itemID"
));

$proto23["m_arguments"][]=$obj;
						$obj = new SQLNonParsed(array(
	"m_sql" => "\"/\""
));

$proto23["m_arguments"][]=$obj;
						$obj = new SQLNonParsed(array(
	"m_sql" => "dbw_faturados.pdtoID"
));

$proto23["m_arguments"][]=$obj;
$proto23["m_strFunctionName"] = "Concat";
$obj = new SQLFunctionCall($proto23);

$proto22["m_sql"] = "Concat(dbw_faturados.pedID, \"/\", dbw_faturados.itemID, \"/\", dbw_faturados.pdtoID)";
$proto22["m_srcTableName"] = "tb_provisao_caixa";
$proto22["m_expr"]=$obj;
$proto22["m_alias"] = "PIP";
$obj = new SQLFieldListItem($proto22);

$proto0["m_fieldlist"][]=$obj;
						$proto29=array();
			$obj = new SQLField(array(
	"m_strName" => "qtd",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto29["m_sql"] = "dbw_faturados.qtd";
$proto29["m_srcTableName"] = "tb_provisao_caixa";
$proto29["m_expr"]=$obj;
$proto29["m_alias"] = "";
$obj = new SQLFieldListItem($proto29);

$proto0["m_fieldlist"][]=$obj;
						$proto31=array();
			$obj = new SQLField(array(
	"m_strName" => "cota_a",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto31["m_sql"] = "dbw_faturados.cota_a";
$proto31["m_srcTableName"] = "tb_provisao_caixa";
$proto31["m_expr"]=$obj;
$proto31["m_alias"] = "";
$obj = new SQLFieldListItem($proto31);

$proto0["m_fieldlist"][]=$obj;
						$proto33=array();
			$obj = new SQLField(array(
	"m_strName" => "cota_b",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto33["m_sql"] = "dbw_faturados.cota_b";
$proto33["m_srcTableName"] = "tb_provisao_caixa";
$proto33["m_expr"]=$obj;
$proto33["m_alias"] = "";
$obj = new SQLFieldListItem($proto33);

$proto0["m_fieldlist"][]=$obj;
						$proto35=array();
			$obj = new SQLField(array(
	"m_strName" => "cota_c",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto35["m_sql"] = "dbw_faturados.cota_c";
$proto35["m_srcTableName"] = "tb_provisao_caixa";
$proto35["m_expr"]=$obj;
$proto35["m_alias"] = "";
$obj = new SQLFieldListItem($proto35);

$proto0["m_fieldlist"][]=$obj;
						$proto37=array();
			$obj = new SQLField(array(
	"m_strName" => "cota_d",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto37["m_sql"] = "dbw_faturados.cota_d";
$proto37["m_srcTableName"] = "tb_provisao_caixa";
$proto37["m_expr"]=$obj;
$proto37["m_alias"] = "";
$obj = new SQLFieldListItem($proto37);

$proto0["m_fieldlist"][]=$obj;
						$proto39=array();
			$obj = new SQLField(array(
	"m_strName" => "faturado",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto39["m_sql"] = "dbw_faturados.faturado";
$proto39["m_srcTableName"] = "tb_provisao_caixa";
$proto39["m_expr"]=$obj;
$proto39["m_alias"] = "";
$obj = new SQLFieldListItem($proto39);

$proto0["m_fieldlist"][]=$obj;
						$proto41=array();
			$obj = new SQLField(array(
	"m_strName" => "data_fatura",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto41["m_sql"] = "dbw_faturados.data_fatura";
$proto41["m_srcTableName"] = "tb_provisao_caixa";
$proto41["m_expr"]=$obj;
$proto41["m_alias"] = "";
$obj = new SQLFieldListItem($proto41);

$proto0["m_fieldlist"][]=$obj;
						$proto43=array();
			$obj = new SQLField(array(
	"m_strName" => "CMat",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto43["m_sql"] = "dbw_resumo_calculo.CMat";
$proto43["m_srcTableName"] = "tb_provisao_caixa";
$proto43["m_expr"]=$obj;
$proto43["m_alias"] = "";
$obj = new SQLFieldListItem($proto43);

$proto0["m_fieldlist"][]=$obj;
						$proto45=array();
			$obj = new SQLField(array(
	"m_strName" => "CMO",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto45["m_sql"] = "dbw_resumo_calculo.CMO";
$proto45["m_srcTableName"] = "tb_provisao_caixa";
$proto45["m_expr"]=$obj;
$proto45["m_alias"] = "";
$obj = new SQLFieldListItem($proto45);

$proto0["m_fieldlist"][]=$obj;
						$proto47=array();
			$obj = new SQLField(array(
	"m_strName" => "GGF",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto47["m_sql"] = "dbw_resumo_calculo.GGF";
$proto47["m_srcTableName"] = "tb_provisao_caixa";
$proto47["m_expr"]=$obj;
$proto47["m_alias"] = "";
$obj = new SQLFieldListItem($proto47);

$proto0["m_fieldlist"][]=$obj;
						$proto49=array();
			$obj = new SQLField(array(
	"m_strName" => "RModel",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto49["m_sql"] = "dbw_resumo_calculo.RModel";
$proto49["m_srcTableName"] = "tb_provisao_caixa";
$proto49["m_expr"]=$obj;
$proto49["m_alias"] = "";
$obj = new SQLFieldListItem($proto49);

$proto0["m_fieldlist"][]=$obj;
						$proto51=array();
			$obj = new SQLField(array(
	"m_strName" => "referencia",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto51["m_sql"] = "dbw_resumo_calculo.referencia";
$proto51["m_srcTableName"] = "tb_provisao_caixa";
$proto51["m_expr"]=$obj;
$proto51["m_alias"] = "";
$obj = new SQLFieldListItem($proto51);

$proto0["m_fieldlist"][]=$obj;
						$proto53=array();
			$obj = new SQLField(array(
	"m_strName" => "CBruto",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto53["m_sql"] = "dbw_resumo_calculo.CBruto";
$proto53["m_srcTableName"] = "tb_provisao_caixa";
$proto53["m_expr"]=$obj;
$proto53["m_alias"] = "";
$obj = new SQLFieldListItem($proto53);

$proto0["m_fieldlist"][]=$obj;
						$proto55=array();
			$obj = new SQLField(array(
	"m_strName" => "PVenda",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto55["m_sql"] = "dbw_resumo_calculo.PVenda";
$proto55["m_srcTableName"] = "tb_provisao_caixa";
$proto55["m_expr"]=$obj;
$proto55["m_alias"] = "";
$obj = new SQLFieldListItem($proto55);

$proto0["m_fieldlist"][]=$obj;
						$proto57=array();
			$obj = new SQLField(array(
	"m_strName" => "MKP",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto57["m_sql"] = "dbw_resumo_calculo.MKP";
$proto57["m_srcTableName"] = "tb_provisao_caixa";
$proto57["m_expr"]=$obj;
$proto57["m_alias"] = "";
$obj = new SQLFieldListItem($proto57);

$proto0["m_fieldlist"][]=$obj;
						$proto59=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_resumo_calculo.PVenda-dbw_resumo_calculo.CBruto)*dbw_faturados.qtd"
));

$proto59["m_sql"] = "(dbw_resumo_calculo.PVenda-dbw_resumo_calculo.CBruto)*dbw_faturados.qtd";
$proto59["m_srcTableName"] = "tb_provisao_caixa";
$proto59["m_expr"]=$obj;
$proto59["m_alias"] = "LPrev";
$obj = new SQLFieldListItem($proto59);

$proto0["m_fieldlist"][]=$obj;
						$proto61=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd"
));

$proto61["m_sql"] = "(dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd";
$proto61["m_srcTableName"] = "tb_provisao_caixa";
$proto61["m_expr"]=$obj;
$proto61["m_alias"] = "LReal";
$obj = new SQLFieldListItem($proto61);

$proto0["m_fieldlist"][]=$obj;
						$proto63=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.qtd * dbw_resumo_calculo.CMat)"
));

$proto63["m_sql"] = "(dbw_faturados.qtd * dbw_resumo_calculo.CMat)";
$proto63["m_srcTableName"] = "tb_provisao_caixa";
$proto63["m_expr"]=$obj;
$proto63["m_alias"] = "Prov_material";
$obj = new SQLFieldListItem($proto63);

$proto0["m_fieldlist"][]=$obj;
						$proto65=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.qtd * dbw_resumo_calculo.GGF)"
));

$proto65["m_sql"] = "(dbw_faturados.qtd * dbw_resumo_calculo.GGF)";
$proto65["m_srcTableName"] = "tb_provisao_caixa";
$proto65["m_expr"]=$obj;
$proto65["m_alias"] = "Prov_GGF";
$obj = new SQLFieldListItem($proto65);

$proto0["m_fieldlist"][]=$obj;
						$proto67=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.qtd * dbw_resumo_calculo.CMO)"
));

$proto67["m_sql"] = "(dbw_faturados.qtd * dbw_resumo_calculo.CMO)";
$proto67["m_srcTableName"] = "tb_provisao_caixa";
$proto67["m_expr"]=$obj;
$proto67["m_alias"] = "Prov_TMO";
$obj = new SQLFieldListItem($proto67);

$proto0["m_fieldlist"][]=$obj;
						$proto69=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "(dbw_faturados.qtd * dbw_resumo_calculo.RModel)"
));

$proto69["m_sql"] = "(dbw_faturados.qtd * dbw_resumo_calculo.RModel)";
$proto69["m_srcTableName"] = "tb_provisao_caixa";
$proto69["m_expr"]=$obj;
$proto69["m_alias"] = "Prov_model";
$obj = new SQLFieldListItem($proto69);

$proto0["m_fieldlist"][]=$obj;
						$proto71=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "((dbw_faturados.qtd * dbw_resumo_calculo.CMat)+(dbw_faturados.qtd * dbw_resumo_calculo.GGF))+((dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd)"
));

$proto71["m_sql"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMat)+(dbw_faturados.qtd * dbw_resumo_calculo.GGF))+((dbw_faturados.v_unit-dbw_resumo_calculo.CBruto)* dbw_faturados.qtd)";
$proto71["m_srcTableName"] = "tb_provisao_caixa";
$proto71["m_expr"]=$obj;
$proto71["m_alias"] = "retencao";
$obj = new SQLFieldListItem($proto71);

$proto0["m_fieldlist"][]=$obj;
						$proto73=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_a/100))"
));

$proto73["m_sql"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_a/100))";
$proto73["m_srcTableName"] = "tb_provisao_caixa";
$proto73["m_expr"]=$obj;
$proto73["m_alias"] = "CA";
$obj = new SQLFieldListItem($proto73);

$proto0["m_fieldlist"][]=$obj;
						$proto75=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_b/100))+ (dbw_faturados.qtd * dbw_resumo_calculo.RModel)"
));

$proto75["m_sql"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_b/100))+ (dbw_faturados.qtd * dbw_resumo_calculo.RModel)";
$proto75["m_srcTableName"] = "tb_provisao_caixa";
$proto75["m_expr"]=$obj;
$proto75["m_alias"] = "CB";
$obj = new SQLFieldListItem($proto75);

$proto0["m_fieldlist"][]=$obj;
						$proto77=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_c/100))"
));

$proto77["m_sql"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_c/100))";
$proto77["m_srcTableName"] = "tb_provisao_caixa";
$proto77["m_expr"]=$obj;
$proto77["m_alias"] = "CC";
$obj = new SQLFieldListItem($proto77);

$proto0["m_fieldlist"][]=$obj;
						$proto79=array();
			$obj = new SQLNonParsed(array(
	"m_sql" => "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_d/100))"
));

$proto79["m_sql"] = "((dbw_faturados.qtd * dbw_resumo_calculo.CMO)* (dbw_faturados.cota_d/100))";
$proto79["m_srcTableName"] = "tb_provisao_caixa";
$proto79["m_expr"]=$obj;
$proto79["m_alias"] = "CD";
$obj = new SQLFieldListItem($proto79);

$proto0["m_fieldlist"][]=$obj;
						$proto81=array();
			$obj = new SQLField(array(
	"m_strName" => "Faturamento",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto81["m_sql"] = "dbw_faturados.Faturamento";
$proto81["m_srcTableName"] = "tb_provisao_caixa";
$proto81["m_expr"]=$obj;
$proto81["m_alias"] = "";
$obj = new SQLFieldListItem($proto81);

$proto0["m_fieldlist"][]=$obj;
						$proto83=array();
			$obj = new SQLField(array(
	"m_strName" => "v_unit",
	"m_strTable" => "dbw_faturados",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto83["m_sql"] = "dbw_faturados.v_unit";
$proto83["m_srcTableName"] = "tb_provisao_caixa";
$proto83["m_expr"]=$obj;
$proto83["m_alias"] = "";
$obj = new SQLFieldListItem($proto83);

$proto0["m_fieldlist"][]=$obj;
$proto0["m_fromlist"] = array();
												$proto85=array();
$proto85["m_link"] = "SQLL_MAIN";
			$proto86=array();
$proto86["m_strName"] = "tb_provisao_caixa";
$proto86["m_srcTableName"] = "tb_provisao_caixa";
$proto86["m_columns"] = array();
$proto86["m_columns"][] = "ID";
$proto86["m_columns"][] = "data";
$proto86["m_columns"][] = "dt_inicial";
$proto86["m_columns"][] = "dt_final";
$proto86["m_columns"][] = "fechacxID";
$obj = new SQLTable($proto86);

$proto85["m_table"] = $obj;
$proto85["m_sql"] = "tb_provisao_caixa";
$proto85["m_alias"] = "";
$proto85["m_srcTableName"] = "tb_provisao_caixa";
$proto87=array();
$proto87["m_sql"] = "";
$proto87["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

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

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

$proto0["m_fromlist"][]=$obj;
												$proto89=array();
$proto89["m_link"] = "SQLL_CROSSJOIN";
			$proto90=array();
$proto90["m_strName"] = "dbw_faturados";
$proto90["m_srcTableName"] = "tb_provisao_caixa";
$proto90["m_columns"] = array();
$proto90["m_columns"][] = "itemID";
$proto90["m_columns"][] = "pedID";
$proto90["m_columns"][] = "pdtoID";
$proto90["m_columns"][] = "v_unit";
$proto90["m_columns"][] = "entrega";
$proto90["m_columns"][] = "incluir";
$proto90["m_columns"][] = "t0";
$proto90["m_columns"][] = "t1";
$proto90["m_columns"][] = "t2";
$proto90["m_columns"][] = "t3";
$proto90["m_columns"][] = "t4";
$proto90["m_columns"][] = "t5";
$proto90["m_columns"][] = "qtd";
$proto90["m_columns"][] = "Subtotal";
$proto90["m_columns"][] = "Faturamento";
$proto90["m_columns"][] = "cota_a";
$proto90["m_columns"][] = "cota_b";
$proto90["m_columns"][] = "cota_c";
$proto90["m_columns"][] = "cota_d";
$proto90["m_columns"][] = "categoria";
$proto90["m_columns"][] = "componente";
$proto90["m_columns"][] = "status_item";
$proto90["m_columns"][] = "faturado";
$proto90["m_columns"][] = "data_fatura";
$obj = new SQLTable($proto90);

$proto89["m_table"] = $obj;
$proto89["m_sql"] = "dbw_faturados";
$proto89["m_alias"] = "";
$proto89["m_srcTableName"] = "tb_provisao_caixa";
$proto91=array();
$proto91["m_sql"] = "";
$proto91["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

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

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

$proto0["m_fromlist"][]=$obj;
												$proto93=array();
$proto93["m_link"] = "SQLL_RIGHTJOIN";
			$proto94=array();
$proto94["m_strName"] = "dbw_resumo_calculo";
$proto94["m_srcTableName"] = "tb_provisao_caixa";
$proto94["m_columns"] = array();
$proto94["m_columns"][] = "mcalcID";
$proto94["m_columns"][] = "pdtoID";
$proto94["m_columns"][] = "data";
$proto94["m_columns"][] = "versao";
$proto94["m_columns"][] = "componente";
$proto94["m_columns"][] = "material";
$proto94["m_columns"][] = "consumo";
$proto94["m_columns"][] = "quebra";
$proto94["m_columns"][] = "tempo";
$proto94["m_columns"][] = "txo";
$proto94["m_columns"][] = "divisao";
$proto94["m_columns"][] = "CMO";
$proto94["m_columns"][] = "CMat";
$proto94["m_columns"][] = "vigente";
$proto94["m_columns"][] = "GGF";
$proto94["m_columns"][] = "RModel";
$proto94["m_columns"][] = "markup";
$proto94["m_columns"][] = "Mlucro";
$proto94["m_columns"][] = "MKP";
$proto94["m_columns"][] = "CBruto";
$proto94["m_columns"][] = "PVenda";
$proto94["m_columns"][] = "referencia";
$proto94["m_columns"][] = "nome_aux";
$proto94["m_columns"][] = "categoria";
$proto94["m_columns"][] = "status";
$proto94["m_columns"][] = "foto";
$proto94["m_columns"][] = "pdtoiD1";
$proto94["m_columns"][] = "Rat_modelagem";
$proto94["m_columns"][] = "vigente1";
$obj = new SQLTable($proto94);

$proto93["m_table"] = $obj;
$proto93["m_sql"] = "RIGHT OUTER JOIN dbw_resumo_calculo ON dbw_resumo_calculo.pdtoID = dbw_faturados.pdtoID";
$proto93["m_alias"] = "";
$proto93["m_srcTableName"] = "tb_provisao_caixa";
$proto95=array();
$proto95["m_sql"] = "dbw_resumo_calculo.pdtoID = dbw_faturados.pdtoID";
$proto95["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "pdtoID",
	"m_strTable" => "dbw_resumo_calculo",
	"m_srcTableName" => "tb_provisao_caixa"
));

$proto95["m_column"]=$obj;
$proto95["m_contained"] = array();
$proto95["m_strCase"] = "= dbw_faturados.pdtoID";
$proto95["m_havingmode"] = false;
$proto95["m_inBrackets"] = false;
$proto95["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto95);

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

$proto0["m_fromlist"][]=$obj;
$proto0["m_groupby"] = array();
$proto0["m_orderby"] = array();
$proto0["m_srcTableName"]="tb_provisao_caixa";		
$obj = new SQLQuery($proto0);

	return $obj;
}
$queryData_tb_provisao_caixa = createSqlQuery_tb_provisao_caixa();


	
		;

																																		

$tdatatb_provisao_caixa[".sqlquery"] = $queryData_tb_provisao_caixa;

$tableEvents["tb_provisao_caixa"] = new eventsBase;
$tdatatb_provisao_caixa[".hasEvents"] = false;

?>