<?php
global $runnerTableSettings;
$runnerTableSettings['socio1_biometric'] = array(
	'name' => 'socio1_biometric',
	'type' => 1,
	'shortName' => 'socio1_biometric',
	'pagesByType' => array(
		'add' => array( 
			'add' 
		),
		'edit' => array( 
			'edit' 
		),
		'export' => array( 
			'export' 
		),
		'import' => array( 
			'import' 
		),
		'list' => array( 
			'list' 
		),
		'masterlist' => array( 
			'masterlist' 
		),
		'masterprint' => array( 
			'masterprint' 
		),
		'print' => array( 
			'print' 
		),
		'search' => array( 
			'search' 
		),
		'view' => array( 
			'view' 
		) 
	),
	'pageTypes' => array(
		'add' => 'add',
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'defaultPages' => array(
		'add' => 'add',
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'tableOwnerIdField' => 'apellido_Materno',
	'usersOwnerIdField' => 'active',
	'audit' => true,
	'locking' => true,
	'detailsBadgeColor' => '3CB371',
	'pageSizeSelectorRecords' => array( 
		'10',
		'20',
		'30',
		'50',
		'100',
		'500',
		'-1' 
	),
	'pageSizeSelectorGroups' => array( 
		'1',
		'3',
		'5',
		'10',
		'50',
		'100',
		'-1' 
	),
	'warnLeavingEdit' => true,
	'sql' => 'SELECT
	id_Socio,
concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres) AS socio,
	ci,
	ci_complemento,
	ci_procedencia,
	nombres,
	apellido_Paterno,
	apellido_Materno,
	fecha_Nacimiento,
	lugar_Nacimiento,
	depto_Nacimiento,
	direccion,
	profesion,
	telefono,
	celular,
	foto_actual,
	foto_Ci,
	estado,
	tipo_Doc,
	pais_Nacimiento,
	sexo,
	estado_Civil,
	apellido_Casada,
	tipo_accionista,
	id_dp,
	id_gestion,
	id_constitucion
FROM socio',
	'keyFields' => array( 
		'id_Socio' 
	),
	'deviceHideFields' => array(
		'1' => array( 
			 
		),
		'5' => array( 
			 
		) 
	),
	'fields' => array(
		'id_Socio' => array(
			'name' => 'id_Socio',
			'goodName' => 'id_Socio',
			'strField' => 'id_Socio',
			'sourceSingle' => 'id_Socio',
			'index' => 1,
			'type' => 3,
			'autoinc' => true,
			'sqlExpression' => 'id_Socio',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'required' => true,
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'socio' => array(
			'name' => 'socio',
			'goodName' => 'socio',
			'strField' => 'socio',
			'index' => 2,
			'sqlExpression' => 'concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres)',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'searchOptions' => array( 
				'Contains' 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'ci' => array(
			'name' => 'ci',
			'goodName' => 'ci',
			'strField' => 'ci',
			'sourceSingle' => 'ci',
			'index' => 3,
			'type' => 14,
			'sqlExpression' => 'ci',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'denyDuplicate' => true,
					'denyDuplicateMessage' => array(
						'text' => 'C.I.%value% ya fue registrado',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'api_biometrico',
					'lookupTableConnection' => 'rest',
					'lookupLinkField' => 'empleadoID',
					'lookupDisplayField' => 'empleadoID',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'ci_complemento' => array(
			'name' => 'ci_complemento',
			'goodName' => 'ci_complemento',
			'strField' => 'ci_complemento',
			'sourceSingle' => 'ci_complemento',
			'index' => 4,
			'sqlExpression' => 'ci_complemento',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'ci_procedencia' => array(
			'name' => 'ci_procedencia',
			'goodName' => 'ci_procedencia',
			'strField' => 'ci_procedencia',
			'sourceSingle' => 'ci_procedencia',
			'index' => 5,
			'type' => 3,
			'sqlExpression' => 'ci_procedencia',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'alias',
					'lookupWhere' => 'valor like \'DEPARTAMENTO\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'nombres' => array(
			'name' => 'nombres',
			'goodName' => 'nombres',
			'strField' => 'nombres',
			'sourceSingle' => 'nombres',
			'index' => 6,
			'sqlExpression' => 'nombres',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'apellido_Paterno' => array(
			'name' => 'apellido_Paterno',
			'goodName' => 'apellido_Paterno',
			'strField' => 'apellido_Paterno',
			'sourceSingle' => 'apellido_Paterno',
			'index' => 7,
			'sqlExpression' => 'apellido_Paterno',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'apellido_Materno' => array(
			'name' => 'apellido_Materno',
			'goodName' => 'apellido_Materno',
			'strField' => 'apellido_Materno',
			'sourceSingle' => 'apellido_Materno',
			'index' => 8,
			'sqlExpression' => 'apellido_Materno',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'fecha_Nacimiento' => array(
			'name' => 'fecha_Nacimiento',
			'goodName' => 'fecha_Nacimiento',
			'strField' => 'fecha_Nacimiento',
			'sourceSingle' => 'fecha_Nacimiento',
			'index' => 9,
			'type' => 7,
			'sqlExpression' => 'fecha_Nacimiento',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Short Date',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Date',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'dateEditType' => 13,
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'lugar_Nacimiento' => array(
			'name' => 'lugar_Nacimiento',
			'goodName' => 'lugar_Nacimiento',
			'strField' => 'lugar_Nacimiento',
			'sourceSingle' => 'lugar_Nacimiento',
			'index' => 10,
			'sqlExpression' => 'lugar_Nacimiento',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'depto_Nacimiento' => array(
			'name' => 'depto_Nacimiento',
			'goodName' => 'depto_Nacimiento',
			'strField' => 'depto_Nacimiento',
			'sourceSingle' => 'depto_Nacimiento',
			'index' => 11,
			'type' => 3,
			'sqlExpression' => 'depto_Nacimiento',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'VALOR LIKE \'DEPARTAMENTO\'',
					'lookupDependent' => true,
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'pais_Nacimiento',
							'lookupField' => 'aux' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'direccion' => array(
			'name' => 'direccion',
			'goodName' => 'direccion',
			'strField' => 'direccion',
			'sourceSingle' => 'direccion',
			'index' => 12,
			'sqlExpression' => 'direccion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'profesion' => array(
			'name' => 'profesion',
			'goodName' => 'profesion',
			'strField' => 'profesion',
			'sourceSingle' => 'profesion',
			'index' => 13,
			'sqlExpression' => 'profesion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'telefono' => array(
			'name' => 'telefono',
			'goodName' => 'telefono',
			'strField' => 'telefono',
			'sourceSingle' => 'telefono',
			'index' => 14,
			'type' => 14,
			'sqlExpression' => 'telefono',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'celular' => array(
			'name' => 'celular',
			'goodName' => 'celular',
			'strField' => 'celular',
			'sourceSingle' => 'celular',
			'index' => 15,
			'type' => 14,
			'sqlExpression' => 'celular',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'foto_actual' => array(
			'name' => 'foto_actual',
			'goodName' => 'foto_actual',
			'strField' => 'foto_actual',
			'sourceSingle' => 'foto_actual',
			'index' => 16,
			'sqlExpression' => 'foto_actual',
			'codeUploadFolder' => '$folder = "files/imagen_cliente";
',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Document Download',
					'imageWidth' => 280,
					'imageHeight' => 140,
					'imageUrl' => true,
					'imageShowThumbnail' => true,
					'linkNewWindow' => true,
					'linkDisplay' => 2,
					'linkDisplayField' => 'foto_actual',
					'linkDisplayText' => array(
						'text' => 'Ver foto',
						'type' => 0 
					),
					'numberFractionalDigits' => 0 
				),
				'list' => array(
					'format' => 'File-based Image',
					'pageType' => 'list',
					'imageWidth' => 220,
					'imageHeight' => 100,
					'linkNewWindow' => true,
					'linkDisplay' => 2,
					'linkDisplayField' => 'foto_actual',
					'linkDisplayText' => array(
						'text' => 'Ver foto',
						'type' => 0 
					),
					'numberFractionalDigits' => 0 
				),
				'print' => array(
					'format' => 'File-based Image',
					'pageType' => 'print',
					'imageWidth' => 280,
					'imageHeight' => 140,
					'imageShowThumbnail' => true,
					'linkNewWindow' => true,
					'linkDisplay' => 2,
					'linkDisplayField' => 'foto_actual',
					'linkDisplayText' => array(
						'text' => 'Ver foto',
						'type' => 0 
					),
					'numberFractionalDigits' => 0 
				),
				'export' => array(
					'format' => 'File-based Image',
					'pageType' => 'export',
					'imageWidth' => 280,
					'imageHeight' => 140,
					'imageShowThumbnail' => true,
					'linkNewWindow' => true,
					'linkDisplay' => 2,
					'linkDisplayField' => 'foto_actual',
					'linkDisplayText' => array(
						'text' => 'Ver foto',
						'type' => 0 
					),
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Document upload',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileCreateThumbnail' => true,
					'fileThumbnailSize' => 1200,
					'fileMaxNumber' => 1,
					'fileSizeLimit' => 2500,
					'fileTypes' => array( 
						'gif',
						'jpeg',
						'jpg',
						'png' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				),
				'add' => array(
					'format' => 'Document upload',
					'pageType' => 'add',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileThumbnailSize' => 300,
					'fileMaxNumber' => 1,
					'fileSizeLimit' => 3500,
					'fileTypes' => array( 
						'jpeg',
						'jpg' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				),
				'search' => array(
					'format' => 'Document upload',
					'pageType' => 'search',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileResize' => true,
					'fileCreateThumbnail' => true,
					'fileMaxNumber' => 1,
					'fileSizeLimit' => 2500,
					'fileTypes' => array( 
						'jpg',
						'png' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'separateEditViewFormats' => true,
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list',
				'filterTotalsField' => 'celular' 
			) 
		),
		'foto_Ci' => array(
			'name' => 'foto_Ci',
			'goodName' => 'foto_Ci',
			'strField' => 'foto_Ci',
			'sourceSingle' => 'foto_Ci',
			'index' => 17,
			'sqlExpression' => 'foto_Ci',
			'codeUploadFolder' => '$folder = "files/ci";
',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Document Download',
					'numberFractionalDigits' => 0 
				),
				'list' => array(
					'format' => 'Document Download',
					'pageType' => 'list',
					'fileShowPdf' => true,
					'numberFractionalDigits' => 0 
				),
				'print' => array(
					'format' => 'Document Download',
					'pageType' => 'print',
					'numberFractionalDigits' => 0 
				),
				'export' => array(
					'format' => 'Document Download',
					'pageType' => 'export',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Document upload',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileTypes' => array( 
						'pdf' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				),
				'add' => array(
					'format' => 'Document upload',
					'pageType' => 'add',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileTypes' => array( 
						'pdf' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				),
				'search' => array(
					'format' => 'Document upload',
					'pageType' => 'search',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileTypes' => array( 
						'pdf' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'separateEditViewFormats' => true,
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'estado' => array(
			'name' => 'estado',
			'goodName' => 'estado',
			'strField' => 'estado',
			'sourceSingle' => 'estado',
			'index' => 18,
			'type' => 3,
			'sqlExpression' => 'estado',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor like \'ESTADO\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'tipo_Doc' => array(
			'name' => 'tipo_Doc',
			'goodName' => 'tipo_Doc',
			'strField' => 'tipo_Doc',
			'sourceSingle' => 'tipo_Doc',
			'index' => 19,
			'type' => 3,
			'sqlExpression' => 'tipo_Doc',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor like \'TIPO_DOC\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'pais_Nacimiento' => array(
			'name' => 'pais_Nacimiento',
			'goodName' => 'pais_Nacimiento',
			'strField' => 'pais_Nacimiento',
			'sourceSingle' => 'pais_Nacimiento',
			'index' => 20,
			'type' => 3,
			'sqlExpression' => 'pais_Nacimiento',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor like \'PAIS\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'sexo' => array(
			'name' => 'sexo',
			'goodName' => 'sexo',
			'strField' => 'sexo',
			'sourceSingle' => 'sexo',
			'index' => 21,
			'type' => 3,
			'sqlExpression' => 'sexo',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor  like \'sexo\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'estado_Civil' => array(
			'name' => 'estado_Civil',
			'goodName' => 'estado_Civil',
			'strField' => 'estado_Civil',
			'sourceSingle' => 'estado_Civil',
			'index' => 22,
			'type' => 3,
			'sqlExpression' => 'estado_Civil',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor like \'civil\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'apellido_Casada' => array(
			'name' => 'apellido_Casada',
			'goodName' => 'apellido_Casada',
			'strField' => 'apellido_Casada',
			'sourceSingle' => 'apellido_Casada',
			'index' => 23,
			'sqlExpression' => 'apellido_Casada',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'tipo_accionista' => array(
			'name' => 'tipo_accionista',
			'goodName' => 'tipo_accionista',
			'strField' => 'tipo_accionista',
			'sourceSingle' => 'tipo_accionista',
			'index' => 24,
			'type' => 3,
			'sqlExpression' => 'tipo_accionista',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'aux',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_aux',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'valor  like \'TIPO_SOCIO\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'id_dp' => array(
			'name' => 'id_dp',
			'goodName' => 'id_dp',
			'strField' => 'id_dp',
			'sourceSingle' => 'id_dp',
			'index' => 25,
			'type' => 3,
			'sqlExpression' => 'id_dp',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'id_gestion' => array(
			'name' => 'id_gestion',
			'goodName' => 'id_gestion',
			'strField' => 'id_gestion',
			'sourceSingle' => 'id_gestion',
			'index' => 26,
			'type' => 3,
			'sqlExpression' => 'id_gestion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'id_constitucion' => array(
			'name' => 'id_constitucion',
			'goodName' => 'id_constitucion',
			'strField' => 'id_constitucion',
			'sourceSingle' => 'id_constitucion',
			'index' => 27,
			'type' => 3,
			'sqlExpression' => 'id_constitucion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'denyDuplicateMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		) 
	),
	'query' => array(
		'sql' => 'SELECT
	id_Socio,
concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres) AS socio,
	ci,
	ci_complemento,
	ci_procedencia,
	nombres,
	apellido_Paterno,
	apellido_Materno,
	fecha_Nacimiento,
	lugar_Nacimiento,
	depto_Nacimiento,
	direccion,
	profesion,
	telefono,
	celular,
	foto_actual,
	foto_Ci,
	estado,
	tipo_Doc,
	pais_Nacimiento,
	sexo,
	estado_Civil,
	apellido_Casada,
	tipo_accionista,
	id_dp,
	id_gestion,
	id_constitucion
FROM socio',
		'parsed' => true,
		'type' => 'SQLQuery',
		'fieldList' => array( 
			array(
				'sql' => 'id_Socio',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'id_Socio' 
				),
				'encrypted' => false,
				'columnName' => 'id_Socio' 
			),
			array(
				'sql' => 'concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres)',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => 'socio',
				'expression' => array(
					'sql' => 'concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres)',
					'parsed' => true,
					'type' => 'FunctionCall',
					'arguments' => array( 
						array(
							'sql' => 'ci',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' - \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'apellido_Paterno',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'apellido_Materno',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'apellido_Casada',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'nombres',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						) 
					),
					'functionName' => 'concat',
					'functionType' => 5 
				),
				'encrypted' => false,
				'columnName' => 'socio' 
			),
			array(
				'sql' => 'ci',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'ci' 
				),
				'encrypted' => false,
				'columnName' => 'ci' 
			),
			array(
				'sql' => 'ci_complemento',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'ci_complemento' 
				),
				'encrypted' => false,
				'columnName' => 'ci_complemento' 
			),
			array(
				'sql' => 'ci_procedencia',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'ci_procedencia' 
				),
				'encrypted' => false,
				'columnName' => 'ci_procedencia' 
			),
			array(
				'sql' => 'nombres',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'nombres' 
				),
				'encrypted' => false,
				'columnName' => 'nombres' 
			),
			array(
				'sql' => 'apellido_Paterno',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'apellido_Paterno' 
				),
				'encrypted' => false,
				'columnName' => 'apellido_Paterno' 
			),
			array(
				'sql' => 'apellido_Materno',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'apellido_Materno' 
				),
				'encrypted' => false,
				'columnName' => 'apellido_Materno' 
			),
			array(
				'sql' => 'fecha_Nacimiento',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'fecha_Nacimiento' 
				),
				'encrypted' => false,
				'columnName' => 'fecha_Nacimiento' 
			),
			array(
				'sql' => 'lugar_Nacimiento',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'lugar_Nacimiento' 
				),
				'encrypted' => false,
				'columnName' => 'lugar_Nacimiento' 
			),
			array(
				'sql' => 'depto_Nacimiento',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'depto_Nacimiento' 
				),
				'encrypted' => false,
				'columnName' => 'depto_Nacimiento' 
			),
			array(
				'sql' => 'direccion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'direccion' 
				),
				'encrypted' => false,
				'columnName' => 'direccion' 
			),
			array(
				'sql' => 'profesion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'profesion' 
				),
				'encrypted' => false,
				'columnName' => 'profesion' 
			),
			array(
				'sql' => 'telefono',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'telefono' 
				),
				'encrypted' => false,
				'columnName' => 'telefono' 
			),
			array(
				'sql' => 'celular',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'celular' 
				),
				'encrypted' => false,
				'columnName' => 'celular' 
			),
			array(
				'sql' => 'foto_actual',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'foto_actual' 
				),
				'encrypted' => false,
				'columnName' => 'foto_actual' 
			),
			array(
				'sql' => 'foto_Ci',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'foto_Ci' 
				),
				'encrypted' => false,
				'columnName' => 'foto_Ci' 
			),
			array(
				'sql' => 'estado',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'estado' 
				),
				'encrypted' => false,
				'columnName' => 'estado' 
			),
			array(
				'sql' => 'tipo_Doc',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'tipo_Doc' 
				),
				'encrypted' => false,
				'columnName' => 'tipo_Doc' 
			),
			array(
				'sql' => 'pais_Nacimiento',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'pais_Nacimiento' 
				),
				'encrypted' => false,
				'columnName' => 'pais_Nacimiento' 
			),
			array(
				'sql' => 'sexo',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'sexo' 
				),
				'encrypted' => false,
				'columnName' => 'sexo' 
			),
			array(
				'sql' => 'estado_Civil',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'estado_Civil' 
				),
				'encrypted' => false,
				'columnName' => 'estado_Civil' 
			),
			array(
				'sql' => 'apellido_Casada',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'apellido_Casada' 
				),
				'encrypted' => false,
				'columnName' => 'apellido_Casada' 
			),
			array(
				'sql' => 'tipo_accionista',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'tipo_accionista' 
				),
				'encrypted' => false,
				'columnName' => 'tipo_accionista' 
			),
			array(
				'sql' => 'id_dp',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'id_dp' 
				),
				'encrypted' => false,
				'columnName' => 'id_dp' 
			),
			array(
				'sql' => 'id_gestion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'id_gestion' 
				),
				'encrypted' => false,
				'columnName' => 'id_gestion' 
			),
			array(
				'sql' => 'id_constitucion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'socio',
					'name' => 'id_constitucion' 
				),
				'encrypted' => false,
				'columnName' => 'id_constitucion' 
			) 
		),
		'fromList' => array( 
			array(
				'sql' => 'socio',
				'parsed' => true,
				'type' => 'FromListItem',
				'table' => array(
					'sql' => 'socio',
					'parsed' => true,
					'type' => 'SQLTable',
					'columns' => array( 
						'id_Socio',
						'ci',
						'ci_complemento',
						'ci_procedencia',
						'nombres',
						'apellido_Paterno',
						'apellido_Materno',
						'fecha_Nacimiento',
						'lugar_Nacimiento',
						'depto_Nacimiento',
						'direccion',
						'profesion',
						'telefono',
						'celular',
						'foto_actual',
						'foto_Ci',
						'estado',
						'tipo_Doc',
						'pais_Nacimiento',
						'sexo',
						'estado_Civil',
						'apellido_Casada',
						'tipo_accionista',
						'id_dp',
						'id_gestion',
						'id_constitucion' 
					),
					'name' => 'socio' 
				),
				'joinOn' => array(
					'sql' => '',
					'parsed' => false,
					'type' => 'LogicalExpression',
					'contained' => array( 
						 
					),
					'unionType' => 0,
					'column' => null 
				),
				'joinList' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'JoinOn',
					'field1' => array( 
						 
					),
					'field2' => array( 
						 
					) 
				),
				'link' => 0 
			) 
		),
		'where' => array(
			'sql' => '',
			'parsed' => false,
			'type' => 'LogicalExpression',
			'contained' => array( 
				 
			),
			'unionType' => 0,
			'column' => null 
		),
		'groupBy' => array( 
			 
		),
		'having' => array(
			'sql' => '',
			'parsed' => false,
			'type' => 'LogicalExpression',
			'contained' => array( 
				 
			),
			'unionType' => 0,
			'column' => null 
		),
		'orderBy' => array( 
			 
		),
		'colsIndex' => array( 
			array(
				'fieldIndex' => 0,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 1,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 2,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 3,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 4,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 5,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 6,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 7,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 8,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 9,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 10,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 11,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 12,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 13,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 14,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 15,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 16,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 17,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 18,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 19,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 20,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 21,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 22,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 23,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 24,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 25,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			),
			array(
				'fieldIndex' => 26,
				'orderByIndex' => -1,
				'groupByIndex' => -1,
				'whereIndex' => -1,
				'havingIndex' => -1 
			) 
		),
		'headSql' => 'SELECT',
		'fieldListSql' => 'id_Socio,
concat(ci, \' - \', apellido_Paterno, \' \', apellido_Materno, \' \', apellido_Casada, \' \', nombres) AS socio,
	ci,
	ci_complemento,
	ci_procedencia,
	nombres,
	apellido_Paterno,
	apellido_Materno,
	fecha_Nacimiento,
	lugar_Nacimiento,
	depto_Nacimiento,
	direccion,
	profesion,
	telefono,
	celular,
	foto_actual,
	foto_Ci,
	estado,
	tipo_Doc,
	pais_Nacimiento,
	sexo,
	estado_Civil,
	apellido_Casada,
	tipo_accionista,
	id_dp,
	id_gestion,
	id_constitucion',
		'fromListSql' => 'FROM socio',
		'orderBySql' => '',
		'tailSql' => '' 
	),
	'hasEvents' => true,
	'hasJsEvents' => true,
	'galleryMode' => 1,
	'originalTable' => 'socio',
	'originalPagesByType' => array(
		'add' => array( 
			'add' 
		),
		'edit' => array( 
			'edit' 
		),
		'export' => array( 
			'export' 
		),
		'import' => array( 
			'import' 
		),
		'list' => array( 
			'list' 
		),
		'masterlist' => array( 
			'masterlist' 
		),
		'masterprint' => array( 
			'masterprint' 
		),
		'print' => array( 
			'print' 
		),
		'search' => array( 
			'search' 
		),
		'view' => array( 
			'view' 
		) 
	),
	'originalPageTypes' => array(
		'add' => 'add',
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'originalDefaultPages' => array(
		'add' => 'add',
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'searchSettings' => array(
		'caseSensitiveSearch' => '',
		'searchableFields' => array( 
			'id_Socio',
			'socio',
			'ci',
			'ci_complemento',
			'ci_procedencia',
			'nombres',
			'apellido_Paterno',
			'apellido_Materno',
			'fecha_Nacimiento',
			'lugar_Nacimiento',
			'depto_Nacimiento',
			'direccion',
			'profesion',
			'telefono',
			'celular',
			'foto_actual',
			'foto_Ci',
			'estado',
			'tipo_Doc',
			'pais_Nacimiento',
			'sexo',
			'estado_Civil',
			'apellido_Casada',
			'tipo_accionista',
			'id_dp',
			'id_gestion',
			'id_constitucion' 
		),
		'searchSuggest' => true,
		'highlightSearchResults' => true,
		'hideDataUntilSearch' => false,
		'hideFilterUntilSearch' => false,
		'googleLikeSearchFields' => array( 
			'id_Socio',
			'socio',
			'ci',
			'ci_complemento',
			'ci_procedencia',
			'nombres',
			'apellido_Paterno',
			'apellido_Materno',
			'fecha_Nacimiento',
			'lugar_Nacimiento',
			'depto_Nacimiento',
			'direccion',
			'profesion',
			'telefono',
			'celular',
			'foto_actual',
			'foto_Ci',
			'estado',
			'tipo_Doc',
			'pais_Nacimiento',
			'sexo',
			'estado_Civil',
			'apellido_Casada',
			'tipo_accionista',
			'id_dp',
			'id_gestion',
			'id_constitucion' 
		) 
	),
	'connId' => 'bsn_dividendos_at_localhost',
	'sortByFields' => array(
		'sortOrder' => array( 
			 
		) 
	),
	'clickActions' => array(
		'row' => array(
			'action' => 'noaction' 
		),
		'fields' => array(
			 
		) 
	),
	'geoCoding' => array(
		'enabled' => false,
		'latField' => '',
		'lonField' => '',
		'addressFields' => array( 
			 
		) 
	),
	'whereTabs' => array( 
		 
	),
	'labels' => array(
		 
	),
	'chartSettings' => array(
		 
	),
	'dataSourceOperations' => array(
		 
	) 
);

global $runnerTableLabels;
if( mlang_getcurrentlang() === 'Spanish' ) {
	$runnerTableLabels['socio1_biometric'] = array(
	'tableCaption' => 'Socio1 Biometric',
	'fieldLabels' => array(
		'id_Socio' => 'Id Accionista',
		'socio' => 'Socio',
		'ci' => 'Numero C.I.',
		'ci_complemento' => 'Complemento',
		'ci_procedencia' => 'Procedencia',
		'nombres' => 'Nombres',
		'apellido_Paterno' => 'Apellido Paterno',
		'apellido_Materno' => 'Apellido Materno',
		'fecha_Nacimiento' => 'Fecha',
		'lugar_Nacimiento' => 'Lugar',
		'depto_Nacimiento' => 'Departamento',
		'direccion' => 'Direccion',
		'profesion' => 'Ocupacion/Profesion',
		'telefono' => 'Telefono',
		'celular' => 'Celular',
		'foto_actual' => 'Foto Actual',
		'foto_Ci' => 'PDF CI',
		'estado' => 'Estado',
		'tipo_Doc' => 'Tipo Documento',
		'pais_Nacimiento' => 'Pais',
		'sexo' => 'Sexo',
		'estado_Civil' => 'Estado Civil',
		'apellido_Casada' => 'Apellido Casada',
		'tipo_accionista' => 'Tipo Accionista',
		'id_dp' => 'Derecho Propietario',
		'id_gestion' => 'Id Gestion',
		'id_constitucion' => 'Id Constitucion' 
	),
	'fieldTooltips' => array(
		'id_Socio' => '',
		'socio' => '',
		'ci' => '',
		'ci_complemento' => '',
		'ci_procedencia' => '',
		'nombres' => '',
		'apellido_Paterno' => '',
		'apellido_Materno' => '',
		'fecha_Nacimiento' => '',
		'lugar_Nacimiento' => '',
		'depto_Nacimiento' => '',
		'direccion' => '',
		'profesion' => '',
		'telefono' => '',
		'celular' => '',
		'foto_actual' => '',
		'foto_Ci' => '',
		'estado' => '',
		'tipo_Doc' => '',
		'pais_Nacimiento' => '',
		'sexo' => '',
		'estado_Civil' => '',
		'apellido_Casada' => '',
		'tipo_accionista' => '',
		'id_dp' => '',
		'id_gestion' => '',
		'id_constitucion' => '' 
	),
	'fieldPlaceholders' => array(
		'id_Socio' => '',
		'socio' => '',
		'ci' => '',
		'ci_complemento' => '',
		'ci_procedencia' => '',
		'nombres' => '',
		'apellido_Paterno' => '',
		'apellido_Materno' => '',
		'fecha_Nacimiento' => '',
		'lugar_Nacimiento' => '',
		'depto_Nacimiento' => '',
		'direccion' => '',
		'profesion' => '',
		'telefono' => '',
		'celular' => '',
		'foto_actual' => '',
		'foto_Ci' => '',
		'estado' => '',
		'tipo_Doc' => '',
		'pais_Nacimiento' => '',
		'sexo' => '',
		'estado_Civil' => '',
		'apellido_Casada' => '',
		'tipo_accionista' => '',
		'id_dp' => '',
		'id_gestion' => '',
		'id_constitucion' => '' 
	),
	'pageTitles' => array(
		 
	) 
);
}
?>