<?php
global $runnerTableSettings;
$runnerTableSettings['kardex_pago_bio'] = array(
	'name' => 'kardex_pago_bio',
	'type' => 1,
	'shortName' => 'kardex_pago_bio',
	'pagesByType' => array(
		'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(
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'defaultPages' => array(
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'audit' => true,
	'locking' => true,
	'afterEditAction' => 2,
	'afterAddAction' => 2,
	'detailsBadgeColor' => '6da5c8',
	'pageSizeSelectorRecords' => array( 
		'10',
		'20',
		'30',
		'50',
		'100',
		'500',
		'-1' 
	),
	'pageSizeSelectorGroups' => array( 
		'1',
		'3',
		'5',
		'10',
		'50',
		'100',
		'-1' 
	),
	'warnLeavingEdit' => true,
	'sql' => 'SELECT
id_Pago,
fecha_Pago,
derecho_Propietario,
accionista,
estado,
tipo_pago,
respaldo,
responsable,
fecha_creacion,
observacion,
total_bs,
total_bs_literal,
nro_Acciones,
utilidad_gestion,
id_constitucion,
concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre) AS socio,
gestion,
nro_derecho,
correlativo_pago,
ano
FROM pago_dp
',
	'keyFields' => array( 
		'id_Pago' 
	),
	'deviceHideFields' => array(
		'1' => array( 
			 
		),
		'5' => array( 
			 
		) 
	),
	'fields' => array(
		'id_Pago' => array(
			'name' => 'id_Pago',
			'goodName' => 'id_Pago',
			'strField' => 'id_Pago',
			'sourceSingle' => 'id_Pago',
			'index' => 1,
			'type' => 3,
			'autoinc' => true,
			'sqlExpression' => 'id_Pago',
			'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' 
			) 
		),
		'fecha_Pago' => array(
			'name' => 'fecha_Pago',
			'goodName' => 'fecha_Pago',
			'strField' => 'fecha_Pago',
			'sourceSingle' => 'fecha_Pago',
			'index' => 2,
			'type' => 135,
			'sqlExpression' => 'fecha_Pago',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Short Date',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Date',
					'required' => true,
					'defaultValue' => 'now()',
					'autoUpdateValue' => 'now()',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'dateEditType' => 2,
					'dateShowTime' => true,
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'derecho_Propietario' => array(
			'name' => 'derecho_Propietario',
			'goodName' => 'derecho_Propietario',
			'strField' => 'derecho_Propietario',
			'sourceSingle' => 'derecho_Propietario',
			'index' => 3,
			'type' => 3,
			'sqlExpression' => 'derecho_Propietario',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'denyDuplicateMessage' => array(
						'text' => 'Derecho %value% ya fue pagado',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'lookupTable' => 'derecho_constitucion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_derecho_Propietario',
					'lookupDisplayField' => 'Nro_derecho',
					'lookupDependent' => true,
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'id_constitucion',
							'lookupField' => 'id_constitucion' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'accionista' => array(
			'name' => 'accionista',
			'goodName' => 'accionista',
			'strField' => 'accionista',
			'sourceSingle' => 'accionista',
			'index' => 4,
			'type' => 3,
			'sqlExpression' => 'accionista',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'denyDuplicateMessage' => array(
						'text' => 'El Accionista %value% ya recibio pago',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'lookupTable' => 'derecho_constitucion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_Socio',
					'lookupDisplayField' => 'accionistas',
					'lookupDependent' => true,
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'id_constitucion',
							'lookupField' => 'id_constitucion' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'estado' => array(
			'name' => 'estado',
			'goodName' => 'estado',
			'strField' => 'estado',
			'sourceSingle' => 'estado',
			'index' => 5,
			'type' => 3,
			'sqlExpression' => 'estado',
			'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',
					'lookupOrderBy' => 'id_aux',
					'lookupWhere' => 'valor like \'ESTADO_PAGO\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'tipo_pago' => array(
			'name' => 'tipo_pago',
			'goodName' => 'tipo_pago',
			'strField' => 'tipo_pago',
			'sourceSingle' => 'tipo_pago',
			'index' => 6,
			'type' => 3,
			'sqlExpression' => 'tipo_pago',
			'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_PAGO\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'respaldo' => array(
			'name' => 'respaldo',
			'goodName' => 'respaldo',
			'strField' => 'respaldo',
			'sourceSingle' => 'respaldo',
			'index' => 7,
			'sqlExpression' => 'respaldo',
			'uploadFolder' => '$folder = "files/entrega";
',
			'codeUploadFolder' => '$folder = "files/pago";
',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Document Download',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Document upload',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileTypes' => array( 
						'pdf' 
					),
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'responsable' => array(
			'name' => 'responsable',
			'goodName' => 'responsable',
			'strField' => 'responsable',
			'sourceSingle' => 'responsable',
			'index' => 8,
			'sqlExpression' => 'responsable',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'defaultValue' => '$_SESSION[\'user_id\']',
					'autoUpdateValue' => '$_SESSION[\'user_id\']',
					'textboxMaxLenth' => 255,
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'sta_rosa_users',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'ID',
					'lookupDisplayField' => 'fullname',
					'lookupWhere' => 'ID = \':session.user_id\'',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'fecha_creacion' => array(
			'name' => 'fecha_creacion',
			'goodName' => 'fecha_creacion',
			'strField' => 'fecha_creacion',
			'sourceSingle' => 'fecha_creacion',
			'index' => 9,
			'type' => 135,
			'sqlExpression' => 'fecha_creacion',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Short Date',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Date',
					'defaultValue' => 'now()',
					'autoUpdateValue' => 'now()',
					'validateRegexMessage' => array(
						'text' => '',
						'type' => 0 
					),
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'dateEditType' => 2,
					'dateShowTime' => true,
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'observacion' => array(
			'name' => 'observacion',
			'goodName' => 'observacion',
			'strField' => 'observacion',
			'sourceSingle' => 'observacion',
			'index' => 10,
			'sqlExpression' => 'observacion',
			'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' 
			) 
		),
		'total_bs' => array(
			'name' => 'total_bs',
			'goodName' => 'total_bs',
			'strField' => 'total_bs',
			'sourceSingle' => 'total_bs',
			'index' => 11,
			'type' => 14,
			'sqlExpression' => 'total_bs',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number' 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'textHTML5Input' => '1',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'total_bs_literal' => array(
			'name' => 'total_bs_literal',
			'goodName' => 'total_bs_literal',
			'strField' => 'total_bs_literal',
			'sourceSingle' => 'total_bs_literal',
			'index' => 12,
			'sqlExpression' => 'total_bs_literal',
			'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' 
			) 
		),
		'nro_Acciones' => array(
			'name' => 'nro_Acciones',
			'goodName' => 'nro_Acciones',
			'strField' => 'nro_Acciones',
			'index' => 13,
			'type' => 14,
			'sqlExpression' => 'nro_Acciones',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'utilidad_gestion' => array(
			'name' => 'utilidad_gestion',
			'goodName' => 'utilidad_gestion',
			'strField' => 'utilidad_gestion',
			'sourceSingle' => 'utilidad_gestion',
			'index' => 14,
			'type' => 14,
			'sqlExpression' => 'utilidad_gestion',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number' 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'gestion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'utilidad_gestion',
					'lookupDisplayField' => 'utilidad_gestion',
					'lookupDependent' => true,
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'gestion',
							'lookupField' => 'id_Gestion' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'id_constitucion' => array(
			'name' => 'id_constitucion',
			'goodName' => 'id_constitucion',
			'strField' => 'id_constitucion',
			'sourceSingle' => 'id_constitucion',
			'index' => 15,
			'type' => 3,
			'sqlExpression' => 'id_constitucion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'constitucion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_constitucion',
					'lookupDisplayField' => 'id_constitucion',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'defaultSearchOption' => 'Contains',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'socio' => array(
			'name' => 'socio',
			'goodName' => 'socio',
			'strField' => 'socio',
			'index' => 16,
			'sqlExpression' => 'concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre)',
			'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',
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'gestion' => array(
			'name' => 'gestion',
			'goodName' => 'gestion',
			'strField' => 'gestion',
			'sourceSingle' => 'gestion',
			'index' => 17,
			'type' => 3,
			'sqlExpression' => 'gestion',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'gestion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'id_Gestion',
					'lookupDisplayField' => 'nombre',
					'lookupOrderBy' => 'id_Gestion',
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'id_constitucion',
							'lookupField' => 'id_constitucion' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'nro_derecho' => array(
			'name' => 'nro_derecho',
			'goodName' => 'nro_derecho',
			'strField' => 'nro_derecho',
			'sourceSingle' => 'nro_derecho',
			'index' => 18,
			'type' => 14,
			'sqlExpression' => 'nro_derecho',
			'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' 
			) 
		),
		'correlativo_pago' => array(
			'name' => 'correlativo_pago',
			'goodName' => 'correlativo_pago',
			'strField' => 'correlativo_pago',
			'sourceSingle' => 'correlativo_pago',
			'index' => 19,
			'type' => 3,
			'sqlExpression' => 'correlativo_pago',
			'viewFormats' => array(
				'view' => array(
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'pago_corelativo',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'Correlativo_pago',
					'lookupDisplayField' => 'Correlativo_pago',
					'lookupControlType' => 1,
					'lookupDependent' => true,
					'lookupDependentFields' => array( 
						array(
							'masterField' => 'ano',
							'lookupField' => 'nombre' 
						) 
					),
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		),
		'ano' => array(
			'name' => 'ano',
			'goodName' => 'ano',
			'strField' => 'ano',
			'sourceSingle' => 'ano',
			'index' => 20,
			'type' => 14,
			'sqlExpression' => 'ano',
			'viewFormats' => array(
				'view' => array(
					'format' => 'Number',
					'numberFractionalDigits' => 0 
				) 
			),
			'editFormats' => array(
				'edit' => array(
					'format' => 'Lookup wizard',
					'required' => true,
					'validateAs' => 'Number',
					'textHTML5Input' => '0',
					'lookupType' => 2,
					'lookupTable' => 'gestion',
					'lookupTableConnection' => 'bsn_dividendos_at_localhost',
					'lookupLinkField' => 'nombre',
					'lookupDisplayField' => 'nombre',
					'lookupWhere' => 'correlativo_pago= 1',
					'fileMaxNumber' => 1,
					'fileThumbnailField' => 'th',
					'timeConvention' => 1 
				) 
			),
			'filterFormat' => array(
				'format' => 'Values list' 
			) 
		) 
	),
	'masterTables' => array( 
		array(
			'table' => 'bio-socio',
			'detailsKeys' => array( 
				'accionista' 
			),
			'masterKeys' => array( 
				'id_Socio' 
			) 
		) 
	),
	'query' => array(
		'sql' => 'SELECT
id_Pago,
fecha_Pago,
derecho_Propietario,
accionista,
estado,
tipo_pago,
respaldo,
responsable,
fecha_creacion,
observacion,
total_bs,
total_bs_literal,
nro_Acciones,
utilidad_gestion,
id_constitucion,
concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre) AS socio,
gestion,
nro_derecho,
correlativo_pago,
ano
FROM pago_dp
',
		'parsed' => true,
		'type' => 'SQLQuery',
		'fieldList' => array( 
			array(
				'sql' => 'id_Pago',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'id_Pago' 
				),
				'encrypted' => false,
				'columnName' => 'id_Pago' 
			),
			array(
				'sql' => 'fecha_Pago',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'fecha_Pago' 
				),
				'encrypted' => false,
				'columnName' => 'fecha_Pago' 
			),
			array(
				'sql' => 'derecho_Propietario',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'derecho_Propietario' 
				),
				'encrypted' => false,
				'columnName' => 'derecho_Propietario' 
			),
			array(
				'sql' => 'accionista',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'accionista' 
				),
				'encrypted' => false,
				'columnName' => 'accionista' 
			),
			array(
				'sql' => 'estado',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'estado' 
				),
				'encrypted' => false,
				'columnName' => 'estado' 
			),
			array(
				'sql' => 'tipo_pago',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'tipo_pago' 
				),
				'encrypted' => false,
				'columnName' => 'tipo_pago' 
			),
			array(
				'sql' => 'respaldo',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'respaldo' 
				),
				'encrypted' => false,
				'columnName' => 'respaldo' 
			),
			array(
				'sql' => 'responsable',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'responsable' 
				),
				'encrypted' => false,
				'columnName' => 'responsable' 
			),
			array(
				'sql' => 'fecha_creacion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'fecha_creacion' 
				),
				'encrypted' => false,
				'columnName' => 'fecha_creacion' 
			),
			array(
				'sql' => 'observacion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'observacion' 
				),
				'encrypted' => false,
				'columnName' => 'observacion' 
			),
			array(
				'sql' => 'total_bs',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'total_bs' 
				),
				'encrypted' => false,
				'columnName' => 'total_bs' 
			),
			array(
				'sql' => 'total_bs_literal',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'total_bs_literal' 
				),
				'encrypted' => false,
				'columnName' => 'total_bs_literal' 
			),
			array(
				'sql' => 'nro_Acciones',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'nro_Acciones' 
				),
				'encrypted' => false,
				'columnName' => 'nro_Acciones' 
			),
			array(
				'sql' => 'utilidad_gestion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'utilidad_gestion' 
				),
				'encrypted' => false,
				'columnName' => 'utilidad_gestion' 
			),
			array(
				'sql' => 'id_constitucion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'id_constitucion' 
				),
				'encrypted' => false,
				'columnName' => 'id_constitucion' 
			),
			array(
				'sql' => 'concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre)',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => 'socio',
				'expression' => array(
					'sql' => 'concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre)',
					'parsed' => true,
					'type' => 'FunctionCall',
					'arguments' => array( 
						array(
							'sql' => 'ci',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' - \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'paterno',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'materno',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'casado',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => '\' \'',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						),
						array(
							'sql' => 'nombre',
							'parsed' => true,
							'type' => 'NonParsedEntity' 
						) 
					),
					'functionName' => 'concat',
					'functionType' => 5 
				),
				'encrypted' => false,
				'columnName' => 'socio' 
			),
			array(
				'sql' => 'gestion',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'gestion' 
				),
				'encrypted' => false,
				'columnName' => 'gestion' 
			),
			array(
				'sql' => 'nro_derecho',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'nro_derecho' 
				),
				'encrypted' => false,
				'columnName' => 'nro_derecho' 
			),
			array(
				'sql' => 'correlativo_pago',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'correlativo_pago' 
				),
				'encrypted' => false,
				'columnName' => 'correlativo_pago' 
			),
			array(
				'sql' => 'ano',
				'parsed' => true,
				'type' => 'FieldListItem',
				'alias' => '',
				'expression' => array(
					'sql' => '',
					'parsed' => true,
					'type' => 'SQLField',
					'table' => 'pago_dp',
					'name' => 'ano' 
				),
				'encrypted' => false,
				'columnName' => 'ano' 
			) 
		),
		'fromList' => array( 
			array(
				'sql' => 'pago_dp',
				'parsed' => true,
				'type' => 'FromListItem',
				'table' => array(
					'sql' => 'pago_dp',
					'parsed' => true,
					'type' => 'SQLTable',
					'columns' => array( 
						'id_Pago',
						'fecha_Pago',
						'derecho_Propietario',
						'accionista',
						'estado',
						'tipo_pago',
						'respaldo',
						'responsable',
						'fecha_creacion',
						'observacion',
						'total_bs',
						'total_bs_literal',
						'nro_Acciones',
						'utilidad_gestion',
						'id_constitucion',
						'gestion',
						'correlativo',
						'ci',
						'nombre',
						'paterno',
						'materno',
						'casado',
						'procedencia',
						'complemento',
						'nro_derecho',
						'correlativo_pago',
						'ano',
						'totol_decimal' 
					),
					'name' => 'pago_dp' 
				),
				'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 
			) 
		),
		'headSql' => 'SELECT',
		'fieldListSql' => 'id_Pago,
fecha_Pago,
derecho_Propietario,
accionista,
estado,
tipo_pago,
respaldo,
responsable,
fecha_creacion,
observacion,
total_bs,
total_bs_literal,
nro_Acciones,
utilidad_gestion,
id_constitucion,
concat(ci, \' - \', paterno, \' \', materno, \' \', casado, \' \', nombre) AS socio,
gestion,
nro_derecho,
correlativo_pago,
ano',
		'fromListSql' => 'FROM pago_dp',
		'orderBySql' => '',
		'tailSql' => '' 
	),
	'hasEvents' => true,
	'hasJsEvents' => true,
	'originalTable' => 'pago_dp',
	'originalPagesByType' => array(
		'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(
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'originalDefaultPages' => array(
		'edit' => 'edit',
		'export' => 'export',
		'import' => 'import',
		'list' => 'list',
		'masterlist' => 'masterlist',
		'masterprint' => 'masterprint',
		'print' => 'print',
		'search' => 'search',
		'view' => 'view' 
	),
	'searchSettings' => array(
		'caseSensitiveSearch' => '',
		'searchableFields' => array( 
			'id_Pago',
			'fecha_Pago',
			'derecho_Propietario',
			'accionista',
			'estado',
			'tipo_pago',
			'respaldo',
			'responsable',
			'fecha_creacion',
			'observacion',
			'total_bs',
			'total_bs_literal',
			'nro_Acciones',
			'utilidad_gestion',
			'id_constitucion',
			'socio',
			'gestion',
			'nro_derecho',
			'correlativo_pago',
			'ano' 
		),
		'searchSuggest' => true,
		'highlightSearchResults' => true,
		'hideDataUntilSearch' => false,
		'hideFilterUntilSearch' => false,
		'googleLikeSearchFields' => array( 
			'id_Pago',
			'fecha_Pago',
			'derecho_Propietario',
			'accionista',
			'estado',
			'tipo_pago',
			'respaldo',
			'responsable',
			'fecha_creacion',
			'observacion',
			'total_bs',
			'total_bs_literal',
			'nro_Acciones',
			'utilidad_gestion',
			'id_constitucion',
			'socio',
			'gestion',
			'nro_derecho',
			'correlativo_pago',
			'ano' 
		) 
	),
	'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['kardex_pago_bio'] = array(
	'tableCaption' => 'Kardex Pago Bio',
	'fieldLabels' => array(
		'id_Pago' => 'Id Pago',
		'fecha_Pago' => 'Fecha Pago',
		'derecho_Propietario' => 'Derecho Propietario',
		'accionista' => 'Accionista',
		'estado' => 'Estado',
		'tipo_pago' => 'Tipo Pago',
		'respaldo' => 'Respaldo',
		'responsable' => 'Responsable Pago',
		'fecha_creacion' => 'Fecha Creacion',
		'observacion' => 'Observacion',
		'total_bs' => 'Total Bs',
		'total_bs_literal' => 'Total Bs Literal',
		'nro_Acciones' => 'Nro Acciones',
		'utilidad_gestion' => 'Utilidad Gestion',
		'id_constitucion' => 'Id Constitucion',
		'socio' => 'Socio',
		'gestion' => 'Gestion a Pagar',
		'nro_derecho' => 'Nro Derecho Propietario',
		'correlativo_pago' => 'Correlativo Pago',
		'ano' => 'Periodo' 
	),
	'fieldTooltips' => array(
		'id_Pago' => '',
		'fecha_Pago' => '',
		'derecho_Propietario' => '',
		'accionista' => '',
		'estado' => '',
		'tipo_pago' => '',
		'respaldo' => '',
		'responsable' => '',
		'fecha_creacion' => '',
		'observacion' => '',
		'total_bs' => '',
		'total_bs_literal' => '',
		'nro_Acciones' => '',
		'utilidad_gestion' => '',
		'id_constitucion' => '',
		'socio' => '',
		'gestion' => '',
		'nro_derecho' => '',
		'correlativo_pago' => '',
		'ano' => '' 
	),
	'fieldPlaceholders' => array(
		'id_Pago' => '',
		'fecha_Pago' => '',
		'derecho_Propietario' => '',
		'accionista' => '',
		'estado' => '',
		'tipo_pago' => '',
		'respaldo' => '',
		'responsable' => '',
		'fecha_creacion' => '',
		'observacion' => '',
		'total_bs' => '',
		'total_bs_literal' => '',
		'nro_Acciones' => '',
		'utilidad_gestion' => '',
		'id_constitucion' => '',
		'socio' => '',
		'gestion' => '',
		'nro_derecho' => '',
		'correlativo_pago' => '',
		'ano' => '' 
	),
	'pageTitles' => array(
		 
	) 
);
}
?>