FrameAppWS

ConsultaDatosDetalleRQ

The following routes are available for this service:
All Verbs	/Utilidades/Formas/DatosDetalle

import datetime
import decimal
from marshmallow.fields import *
from servicestack import *
from typing import *
from dataclasses import dataclass, field
from dataclasses_json import dataclass_json, LetterCase, Undefined, config
from enum import Enum, IntEnum


class Lenguajes(str, Enum):
    ES = 'ES'
    PT = 'PT'
    EN = 'EN'


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSortOptions:
    selector: Optional[str] = None
    desc: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridGroupOptions:
    selector: Optional[str] = None
    desc: bool = False
    is_expanded: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ConsultaDatosDetalleRQ:
    forma: int = 0
    detalle: int = 0
    llave_maestro: Optional[Dict[str, Object]] = None
    lenguaje: Optional[Lenguajes] = None
    record_skip: int = 0
    record_take: int = 0
    filter: Optional[List[Object]] = None
    sort: Optional[gridSortOptions] = None
    group: Optional[gridGroupOptions] = None
    summary_group_items: Optional[List[gridSummaryOptions]] = None
    summary_total_items: Optional[List[gridSummaryOptions]] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryOptions:
    selector: Optional[str] = None
    summary_type: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Tabla:
    codigo: Decimal = decimal.Decimal(0)
    propietario: Optional[str] = None
    tipo: Optional[str] = None
    nombre: Optional[str] = None
    alias: Optional[str] = None
    descripcion: Optional[str] = None
    para_reportes: Optional[str] = None
    crear_al_iniciar: Optional[str] = None
    campo_empresa: int = 0
    campo_unico: int = 0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Columna:
    codigo_tabla: Decimal = decimal.Decimal(0)
    codigo: Decimal = decimal.Decimal(0)
    nombre: Optional[str] = None
    alias: Optional[str] = None
    descripcion: Optional[str] = None
    tipo_dato: Optional[str] = None
    obligatorio_formas: Optional[str] = None
    hint: Optional[str] = None
    mayuscula: Optional[str] = None
    tamano: int = 0
    escala: int = 0
    tipo: Optional[str] = None
    vlr_defecto: Optional[str] = None
    permite_editar: Optional[str] = None
    orden: int = 0
    dinamico: Optional[str] = None
    clase_control: Optional[str] = None
    join_lookup: Decimal = decimal.Decimal(0)
    es_i_d: Optional[str] = None
    mascara: Optional[str] = None
    mostrar_en_lista: Optional[str] = None
    info_adicional: Optional[str] = None
    where_defecto: Optional[str] = None
    tiene_resumen: Optional[str] = None
    formato_resumen: Optional[str] = None
    tipo_resumen: Optional[str] = None
    posicion_resumen: Optional[str] = None
    resumen_en_grupo: Optional[str] = None
    resumen_en_total: Optional[str] = None
    indice_grupo: int = 0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Vista:
    codigo: Decimal = decimal.Decimal(0)
    codigo_blob: Decimal = decimal.Decimal(0)
    nombre: Optional[str] = None
    descripcion: Optional[str] = None
    sql: Optional[str] = None
    codigo_tabla: Decimal = decimal.Decimal(0)
    guardar_binario: Optional[str] = None
    tipo_consulta: Optional[str] = None
    exportacion_default: Optional[str] = None
    tipo_exportacion: Optional[str] = None
    parametros_exportacion: int = 0
    codigo_ayuda: Optional[str] = None
    ejecutar_en_adm: Optional[str] = None
    info_adicional: Optional[str] = None
    ejec_multiempresa: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DetalleJoinTabla:
    codigo: Decimal = decimal.Decimal(0)
    campo_a_mostrar: Optional[str] = None
    campos1: Optional[List[str]] = None
    campos2: Optional[List[str]] = None
    operadores: Optional[List[str]] = None
    datos: Optional[List[Dict[str, Object]]] = None
    codigo_tabla1: Decimal = decimal.Decimal(0)
    sql: Optional[str] = None
    tabla_detalle: Optional[DefinicionTabla] = None
    vista: Optional[Vista] = None
    version: Optional[str] = None
    ordenar: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Frame:
    codigo: Decimal = decimal.Decimal(0)
    sql: Optional[str] = None
    campos1: Optional[List[str]] = None
    campos2: Optional[List[str]] = None
    tabla_frame: Optional[DefinicionTabla] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DetalleIndices:
    codigo_tabla: Decimal = decimal.Decimal(0)
    nombre_indice: Optional[str] = None
    codigo_columna: Decimal = decimal.Decimal(0)
    tipo_calculo: Optional[str] = None
    secuencia: Optional[str] = None
    nombre_columna: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ColCountByScreen:
    lg: int = 0
    md: int = 0
    sm: int = 0
    xs: int = 0


class ItemTypeForm(str, Enum):
    SIMPLE = 'simple'
    GROUP = 'group'
    TABBED = 'tabbed'
    EMPTY = 'empty'


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EmptyItemForm:
    item_type: Optional[ItemTypeForm] = None
    visible_index: int = 0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class dxForm:
    col_count_by_screen: Optional[ColCountByScreen] = None
    label_location: Optional[str] = None
    read_only: bool = False
    items: Optional[List[EmptyItemForm]] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ValidationRule:
    type: Optional[str] = None
    message: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class LookupGrid:
    allow_clearing: bool = False
    display_expr: Optional[str] = None
    value_expr: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ColumnGrid:
    caption: Optional[str] = None
    data_field: Optional[str] = None
    data_type: Optional[str] = None
    visible_index: int = 0
    validation_rules: Optional[List[ValidationRule]] = None
    lookup: Optional[LookupGrid] = None
    allow_editing: bool = False
    encode_html: bool = False
    editor_options: Optional[Dict[str, Object]] = None
    group_index: Optional[int] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EditingGrid:
    allow_adding: bool = False
    allow_deleting: bool = False
    allow_updating: bool = False
    mode: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryGroupItems:
    column: Optional[str] = None
    display_format: Optional[str] = None
    show_in_group_footer: bool = False
    summary_type: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryTotalItems:
    column: Optional[str] = None
    display_format: Optional[str] = None
    summary_type: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummary:
    group_items: Optional[List[gridSummaryGroupItems]] = None
    total_items: Optional[List[gridSummaryTotalItems]] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class dxDataGrid:
    columns: Optional[List[ColumnGrid]] = None
    show_column_lines: bool = False
    show_row_lines: bool = False
    row_alternation_enabled: bool = False
    show_borders: bool = False
    editing: Optional[EditingGrid] = None
    summary: Optional[gridSummary] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DefinicionTabla:
    tabla: Optional[Tabla] = None
    columnas: Optional[List[Columna]] = None
    lookups: Optional[List[DetalleJoinTabla]] = None
    frames: Optional[List[Frame]] = None
    detalle_llave: Optional[List[DetalleIndices]] = None
    form: Optional[dxForm] = None
    data_grid: Optional[dxDataGrid] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ConsultaDatosDetalleRS:
    definicion: Optional[DefinicionTabla] = None
    datos_consulta: Optional[List[Dict[str, Object]]] = None
    total_registros: int = 0
    total_grupos: int = 0
    summary_list: Optional[List[Object]] = None

Python ConsultaDatosDetalleRQ DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + JSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /Utilidades/Formas/DatosDetalle HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	Forma: 0,
	Detalle: 0,
	LlaveMaestro: 
	{
		String: {}
	},
	Lenguaje: ES,
	RecordSkip: 0,
	RecordTake: 0,
	Filter: 
	[
		{
			
		}
	],
	Sort: 
	{
		selector: String,
		desc: False
	},
	Group: 
	{
		selector: String,
		desc: False,
		isExpanded: False
	},
	SummaryGroupItems: 
	[
		{
			selector: String,
			summaryType: String
		}
	],
	SummaryTotalItems: 
	[
		{
			selector: String,
			summaryType: String
		}
	]
}

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	Definicion: 
	{
		Tabla: 
		{
			Codigo: 0,
			Propietario: String,
			Tipo: String,
			Nombre: String,
			Alias: String,
			Descripcion: String,
			ParaReportes: String,
			CrearAlIniciar: String,
			CampoEmpresa: 0,
			CampoUnico: 0
		},
		Columnas: 
		[
			{
				CodigoTabla: 0,
				Codigo: 0,
				Nombre: String,
				Alias: String,
				Descripcion: String,
				TipoDato: String,
				ObligatorioFormas: String,
				Hint: String,
				Mayuscula: String,
				Tamano: 0,
				Escala: 0,
				Tipo: String,
				VlrDefecto: String,
				PermiteEditar: String,
				Orden: 0,
				Dinamico: String,
				ClaseControl: String,
				JoinLookup: 0,
				EsID: String,
				Mascara: String,
				MostrarEnLista: String,
				InfoAdicional: String,
				WHEREDefecto: String,
				TieneResumen: String,
				FormatoResumen: String,
				TipoResumen: String,
				PosicionResumen: String,
				ResumenEnGrupo: String,
				ResumenEnTotal: String,
				IndiceGrupo: 0
			}
		],
		Lookups: 
		[
			{
				Codigo: 0,
				CampoAMostrar: String,
				Campos1: 
				[
					String
				],
				Campos2: 
				[
					String
				],
				Operadores: 
				[
					String
				],
				Datos: 
				[
					{
						String: {}
					}
				],
				CodigoTabla1: 0,
				SQL: String,
				TablaDetalle: 
				{
					Tabla: 
					{
						Codigo: 0,
						Propietario: String,
						Tipo: String,
						Nombre: String,
						Alias: String,
						Descripcion: String,
						ParaReportes: String,
						CrearAlIniciar: String,
						CampoEmpresa: 0,
						CampoUnico: 0
					},
					Columnas: 
					[
						{
							CodigoTabla: 0,
							Codigo: 0,
							Nombre: String,
							Alias: String,
							Descripcion: String,
							TipoDato: String,
							ObligatorioFormas: String,
							Hint: String,
							Mayuscula: String,
							Tamano: 0,
							Escala: 0,
							Tipo: String,
							VlrDefecto: String,
							PermiteEditar: String,
							Orden: 0,
							Dinamico: String,
							ClaseControl: String,
							JoinLookup: 0,
							EsID: String,
							Mascara: String,
							MostrarEnLista: String,
							InfoAdicional: String,
							WHEREDefecto: String,
							TieneResumen: String,
							FormatoResumen: String,
							TipoResumen: String,
							PosicionResumen: String,
							ResumenEnGrupo: String,
							ResumenEnTotal: String,
							IndiceGrupo: 0
						}
					],
					Lookups: 
					[
						{
							Codigo: 0,
							CampoAMostrar: String,
							Campos1: 
							[
								String
							],
							Campos2: 
							[
								String
							],
							Operadores: 
							[
								String
							],
							Datos: 
							[
								{
									String: {}
								}
							],
							CodigoTabla1: 0,
							SQL: String,
							TablaDetalle: 
							{
								Tabla: 
								{
									Codigo: 0,
									Propietario: String,
									Tipo: String,
									Nombre: String,
									Alias: String,
									Descripcion: String,
									ParaReportes: String,
									CrearAlIniciar: String,
									CampoEmpresa: 0,
									CampoUnico: 0
								},
								Columnas: 
								[
									{
										CodigoTabla: 0,
										Codigo: 0,
										Nombre: String,
										Alias: String,
										Descripcion: String,
										TipoDato: String,
										ObligatorioFormas: String,
										Hint: String,
										Mayuscula: String,
										Tamano: 0,
										Escala: 0,
										Tipo: String,
										VlrDefecto: String,
										PermiteEditar: String,
										Orden: 0,
										Dinamico: String,
										ClaseControl: String,
										JoinLookup: 0,
										EsID: String,
										Mascara: String,
										MostrarEnLista: String,
										InfoAdicional: String,
										WHEREDefecto: String,
										TieneResumen: String,
										FormatoResumen: String,
										TipoResumen: String,
										PosicionResumen: String,
										ResumenEnGrupo: String,
										ResumenEnTotal: String,
										IndiceGrupo: 0
									}
								],
								Lookups: 
								[
									{
										Codigo: 0,
										CampoAMostrar: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										],
										Operadores: 
										[
											String
										],
										Datos: 
										[
											{
												String: {}
											}
										],
										CodigoTabla1: 0,
										SQL: String,
										Vista: 
										{
											Codigo: 0,
											CodigoBlob: 0,
											Nombre: String,
											Descripcion: String,
											SQL: String,
											CodigoTabla: 0,
											GuardarBinario: String,
											TipoConsulta: String,
											ExportacionDefault: String,
											TipoExportacion: String,
											ParametrosExportacion: 0,
											CodigoAyuda: String,
											EjecutarEnAdm: String,
											InfoAdicional: String,
											EjecMultiempresa: String
										},
										Version: String,
										Ordenar: String
									}
								],
								Frames: 
								[
									{
										Codigo: 0,
										SQL: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										]
									}
								],
								DetalleLlave: 
								[
									{
										CodigoTabla: 0,
										NombreIndice: String,
										CodigoColumna: 0,
										TipoCalculo: String,
										Secuencia: String,
										NombreColumna: String
									}
								],
								Form: 
								{
									colCountByScreen: 
									{
										lg: 0,
										md: 0,
										sm: 0,
										xs: 0
									},
									labelLocation: String,
									readOnly: False,
									items: 
									[
										{
											itemType: simple,
											visibleIndex: 0
										}
									]
								},
								DataGrid: 
								{
									"columns": 
									[
										{
											"caption": "String",
											"dataField": "String",
											"dataType": "String",
											"visibleIndex": 0,
											"validationRules": 
											[
												{
													"type": "String",
													"message": "String"
												}
											],
											"lookup": 
											{
												"allowClearing": false,
												"displayExpr": "String",
												"valueExpr": "String"
											},
											"allowEditing": false,
											"encodeHtml": false,
											"editorOptions": 
											{
												"String": {}
											},
											"groupIndex": 0
										}
									],
									"showColumnLines": false,
									"showRowLines": false,
									"rowAlternationEnabled": false,
									"showBorders": false,
									"editing": 
									{
										"allowAdding": false,
										"allowDeleting": false,
										"allowUpdating": false,
										"mode": "String"
									},
									"summary": 
									{
										"groupItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"showInGroupFooter": false,
												"summaryType": "String"
											}
										],
										"totalItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"summaryType": "String"
											}
										]
									}
								}
							},
							Vista: 
							{
								Codigo: 0,
								CodigoBlob: 0,
								Nombre: String,
								Descripcion: String,
								SQL: String,
								CodigoTabla: 0,
								GuardarBinario: String,
								TipoConsulta: String,
								ExportacionDefault: String,
								TipoExportacion: String,
								ParametrosExportacion: 0,
								CodigoAyuda: String,
								EjecutarEnAdm: String,
								InfoAdicional: String,
								EjecMultiempresa: String
							},
							Version: String,
							Ordenar: String
						}
					],
					Frames: 
					[
						{
							Codigo: 0,
							SQL: String,
							Campos1: 
							[
								String
							],
							Campos2: 
							[
								String
							],
							TablaFrame: 
							{
								Tabla: 
								{
									Codigo: 0,
									Propietario: String,
									Tipo: String,
									Nombre: String,
									Alias: String,
									Descripcion: String,
									ParaReportes: String,
									CrearAlIniciar: String,
									CampoEmpresa: 0,
									CampoUnico: 0
								},
								Columnas: 
								[
									{
										CodigoTabla: 0,
										Codigo: 0,
										Nombre: String,
										Alias: String,
										Descripcion: String,
										TipoDato: String,
										ObligatorioFormas: String,
										Hint: String,
										Mayuscula: String,
										Tamano: 0,
										Escala: 0,
										Tipo: String,
										VlrDefecto: String,
										PermiteEditar: String,
										Orden: 0,
										Dinamico: String,
										ClaseControl: String,
										JoinLookup: 0,
										EsID: String,
										Mascara: String,
										MostrarEnLista: String,
										InfoAdicional: String,
										WHEREDefecto: String,
										TieneResumen: String,
										FormatoResumen: String,
										TipoResumen: String,
										PosicionResumen: String,
										ResumenEnGrupo: String,
										ResumenEnTotal: String,
										IndiceGrupo: 0
									}
								],
								Lookups: 
								[
									{
										Codigo: 0,
										CampoAMostrar: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										],
										Operadores: 
										[
											String
										],
										Datos: 
										[
											{
												String: {}
											}
										],
										CodigoTabla1: 0,
										SQL: String,
										Vista: 
										{
											Codigo: 0,
											CodigoBlob: 0,
											Nombre: String,
											Descripcion: String,
											SQL: String,
											CodigoTabla: 0,
											GuardarBinario: String,
											TipoConsulta: String,
											ExportacionDefault: String,
											TipoExportacion: String,
											ParametrosExportacion: 0,
											CodigoAyuda: String,
											EjecutarEnAdm: String,
											InfoAdicional: String,
											EjecMultiempresa: String
										},
										Version: String,
										Ordenar: String
									}
								],
								Frames: 
								[
									{
										Codigo: 0,
										SQL: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										]
									}
								],
								DetalleLlave: 
								[
									{
										CodigoTabla: 0,
										NombreIndice: String,
										CodigoColumna: 0,
										TipoCalculo: String,
										Secuencia: String,
										NombreColumna: String
									}
								],
								Form: 
								{
									colCountByScreen: 
									{
										lg: 0,
										md: 0,
										sm: 0,
										xs: 0
									},
									labelLocation: String,
									readOnly: False,
									items: 
									[
										{
											itemType: simple,
											visibleIndex: 0
										}
									]
								},
								DataGrid: 
								{
									"columns": 
									[
										{
											"caption": "String",
											"dataField": "String",
											"dataType": "String",
											"visibleIndex": 0,
											"validationRules": 
											[
												{
													"type": "String",
													"message": "String"
												}
											],
											"lookup": 
											{
												"allowClearing": false,
												"displayExpr": "String",
												"valueExpr": "String"
											},
											"allowEditing": false,
											"encodeHtml": false,
											"editorOptions": 
											{
												"String": {}
											},
											"groupIndex": 0
										}
									],
									"showColumnLines": false,
									"showRowLines": false,
									"rowAlternationEnabled": false,
									"showBorders": false,
									"editing": 
									{
										"allowAdding": false,
										"allowDeleting": false,
										"allowUpdating": false,
										"mode": "String"
									},
									"summary": 
									{
										"groupItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"showInGroupFooter": false,
												"summaryType": "String"
											}
										],
										"totalItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"summaryType": "String"
											}
										]
									}
								}
							}
						}
					],
					DetalleLlave: 
					[
						{
							CodigoTabla: 0,
							NombreIndice: String,
							CodigoColumna: 0,
							TipoCalculo: String,
							Secuencia: String,
							NombreColumna: String
						}
					],
					Form: 
					{
						colCountByScreen: 
						{
							lg: 0,
							md: 0,
							sm: 0,
							xs: 0
						},
						labelLocation: String,
						readOnly: False,
						items: 
						[
							{
								itemType: simple,
								visibleIndex: 0
							}
						]
					},
					DataGrid: 
					{
						"columns": 
						[
							{
								"caption": "String",
								"dataField": "String",
								"dataType": "String",
								"visibleIndex": 0,
								"validationRules": 
								[
									{
										"type": "String",
										"message": "String"
									}
								],
								"lookup": 
								{
									"allowClearing": false,
									"displayExpr": "String",
									"valueExpr": "String"
								},
								"allowEditing": false,
								"encodeHtml": false,
								"editorOptions": 
								{
									"String": {}
								},
								"groupIndex": 0
							}
						],
						"showColumnLines": false,
						"showRowLines": false,
						"rowAlternationEnabled": false,
						"showBorders": false,
						"editing": 
						{
							"allowAdding": false,
							"allowDeleting": false,
							"allowUpdating": false,
							"mode": "String"
						},
						"summary": 
						{
							"groupItems": 
							[
								{
									"column": "String",
									"displayFormat": "String",
									"showInGroupFooter": false,
									"summaryType": "String"
								}
							],
							"totalItems": 
							[
								{
									"column": "String",
									"displayFormat": "String",
									"summaryType": "String"
								}
							]
						}
					}
				},
				Vista: 
				{
					Codigo: 0,
					CodigoBlob: 0,
					Nombre: String,
					Descripcion: String,
					SQL: String,
					CodigoTabla: 0,
					GuardarBinario: String,
					TipoConsulta: String,
					ExportacionDefault: String,
					TipoExportacion: String,
					ParametrosExportacion: 0,
					CodigoAyuda: String,
					EjecutarEnAdm: String,
					InfoAdicional: String,
					EjecMultiempresa: String
				},
				Version: String,
				Ordenar: String
			}
		],
		Frames: 
		[
			{
				Codigo: 0,
				SQL: String,
				Campos1: 
				[
					String
				],
				Campos2: 
				[
					String
				],
				TablaFrame: 
				{
					Tabla: 
					{
						Codigo: 0,
						Propietario: String,
						Tipo: String,
						Nombre: String,
						Alias: String,
						Descripcion: String,
						ParaReportes: String,
						CrearAlIniciar: String,
						CampoEmpresa: 0,
						CampoUnico: 0
					},
					Columnas: 
					[
						{
							CodigoTabla: 0,
							Codigo: 0,
							Nombre: String,
							Alias: String,
							Descripcion: String,
							TipoDato: String,
							ObligatorioFormas: String,
							Hint: String,
							Mayuscula: String,
							Tamano: 0,
							Escala: 0,
							Tipo: String,
							VlrDefecto: String,
							PermiteEditar: String,
							Orden: 0,
							Dinamico: String,
							ClaseControl: String,
							JoinLookup: 0,
							EsID: String,
							Mascara: String,
							MostrarEnLista: String,
							InfoAdicional: String,
							WHEREDefecto: String,
							TieneResumen: String,
							FormatoResumen: String,
							TipoResumen: String,
							PosicionResumen: String,
							ResumenEnGrupo: String,
							ResumenEnTotal: String,
							IndiceGrupo: 0
						}
					],
					Lookups: 
					[
						{
							Codigo: 0,
							CampoAMostrar: String,
							Campos1: 
							[
								String
							],
							Campos2: 
							[
								String
							],
							Operadores: 
							[
								String
							],
							Datos: 
							[
								{
									String: {}
								}
							],
							CodigoTabla1: 0,
							SQL: String,
							TablaDetalle: 
							{
								Tabla: 
								{
									Codigo: 0,
									Propietario: String,
									Tipo: String,
									Nombre: String,
									Alias: String,
									Descripcion: String,
									ParaReportes: String,
									CrearAlIniciar: String,
									CampoEmpresa: 0,
									CampoUnico: 0
								},
								Columnas: 
								[
									{
										CodigoTabla: 0,
										Codigo: 0,
										Nombre: String,
										Alias: String,
										Descripcion: String,
										TipoDato: String,
										ObligatorioFormas: String,
										Hint: String,
										Mayuscula: String,
										Tamano: 0,
										Escala: 0,
										Tipo: String,
										VlrDefecto: String,
										PermiteEditar: String,
										Orden: 0,
										Dinamico: String,
										ClaseControl: String,
										JoinLookup: 0,
										EsID: String,
										Mascara: String,
										MostrarEnLista: String,
										InfoAdicional: String,
										WHEREDefecto: String,
										TieneResumen: String,
										FormatoResumen: String,
										TipoResumen: String,
										PosicionResumen: String,
										ResumenEnGrupo: String,
										ResumenEnTotal: String,
										IndiceGrupo: 0
									}
								],
								Lookups: 
								[
									{
										Codigo: 0,
										CampoAMostrar: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										],
										Operadores: 
										[
											String
										],
										Datos: 
										[
											{
												String: {}
											}
										],
										CodigoTabla1: 0,
										SQL: String,
										Vista: 
										{
											Codigo: 0,
											CodigoBlob: 0,
											Nombre: String,
											Descripcion: String,
											SQL: String,
											CodigoTabla: 0,
											GuardarBinario: String,
											TipoConsulta: String,
											ExportacionDefault: String,
											TipoExportacion: String,
											ParametrosExportacion: 0,
											CodigoAyuda: String,
											EjecutarEnAdm: String,
											InfoAdicional: String,
											EjecMultiempresa: String
										},
										Version: String,
										Ordenar: String
									}
								],
								Frames: 
								[
									{
										Codigo: 0,
										SQL: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										]
									}
								],
								DetalleLlave: 
								[
									{
										CodigoTabla: 0,
										NombreIndice: String,
										CodigoColumna: 0,
										TipoCalculo: String,
										Secuencia: String,
										NombreColumna: String
									}
								],
								Form: 
								{
									colCountByScreen: 
									{
										lg: 0,
										md: 0,
										sm: 0,
										xs: 0
									},
									labelLocation: String,
									readOnly: False,
									items: 
									[
										{
											itemType: simple,
											visibleIndex: 0
										}
									]
								},
								DataGrid: 
								{
									"columns": 
									[
										{
											"caption": "String",
											"dataField": "String",
											"dataType": "String",
											"visibleIndex": 0,
											"validationRules": 
											[
												{
													"type": "String",
													"message": "String"
												}
											],
											"lookup": 
											{
												"allowClearing": false,
												"displayExpr": "String",
												"valueExpr": "String"
											},
											"allowEditing": false,
											"encodeHtml": false,
											"editorOptions": 
											{
												"String": {}
											},
											"groupIndex": 0
										}
									],
									"showColumnLines": false,
									"showRowLines": false,
									"rowAlternationEnabled": false,
									"showBorders": false,
									"editing": 
									{
										"allowAdding": false,
										"allowDeleting": false,
										"allowUpdating": false,
										"mode": "String"
									},
									"summary": 
									{
										"groupItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"showInGroupFooter": false,
												"summaryType": "String"
											}
										],
										"totalItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"summaryType": "String"
											}
										]
									}
								}
							},
							Vista: 
							{
								Codigo: 0,
								CodigoBlob: 0,
								Nombre: String,
								Descripcion: String,
								SQL: String,
								CodigoTabla: 0,
								GuardarBinario: String,
								TipoConsulta: String,
								ExportacionDefault: String,
								TipoExportacion: String,
								ParametrosExportacion: 0,
								CodigoAyuda: String,
								EjecutarEnAdm: String,
								InfoAdicional: String,
								EjecMultiempresa: String
							},
							Version: String,
							Ordenar: String
						}
					],
					Frames: 
					[
						{
							Codigo: 0,
							SQL: String,
							Campos1: 
							[
								String
							],
							Campos2: 
							[
								String
							],
							TablaFrame: 
							{
								Tabla: 
								{
									Codigo: 0,
									Propietario: String,
									Tipo: String,
									Nombre: String,
									Alias: String,
									Descripcion: String,
									ParaReportes: String,
									CrearAlIniciar: String,
									CampoEmpresa: 0,
									CampoUnico: 0
								},
								Columnas: 
								[
									{
										CodigoTabla: 0,
										Codigo: 0,
										Nombre: String,
										Alias: String,
										Descripcion: String,
										TipoDato: String,
										ObligatorioFormas: String,
										Hint: String,
										Mayuscula: String,
										Tamano: 0,
										Escala: 0,
										Tipo: String,
										VlrDefecto: String,
										PermiteEditar: String,
										Orden: 0,
										Dinamico: String,
										ClaseControl: String,
										JoinLookup: 0,
										EsID: String,
										Mascara: String,
										MostrarEnLista: String,
										InfoAdicional: String,
										WHEREDefecto: String,
										TieneResumen: String,
										FormatoResumen: String,
										TipoResumen: String,
										PosicionResumen: String,
										ResumenEnGrupo: String,
										ResumenEnTotal: String,
										IndiceGrupo: 0
									}
								],
								Lookups: 
								[
									{
										Codigo: 0,
										CampoAMostrar: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										],
										Operadores: 
										[
											String
										],
										Datos: 
										[
											{
												String: {}
											}
										],
										CodigoTabla1: 0,
										SQL: String,
										Vista: 
										{
											Codigo: 0,
											CodigoBlob: 0,
											Nombre: String,
											Descripcion: String,
											SQL: String,
											CodigoTabla: 0,
											GuardarBinario: String,
											TipoConsulta: String,
											ExportacionDefault: String,
											TipoExportacion: String,
											ParametrosExportacion: 0,
											CodigoAyuda: String,
											EjecutarEnAdm: String,
											InfoAdicional: String,
											EjecMultiempresa: String
										},
										Version: String,
										Ordenar: String
									}
								],
								Frames: 
								[
									{
										Codigo: 0,
										SQL: String,
										Campos1: 
										[
											String
										],
										Campos2: 
										[
											String
										]
									}
								],
								DetalleLlave: 
								[
									{
										CodigoTabla: 0,
										NombreIndice: String,
										CodigoColumna: 0,
										TipoCalculo: String,
										Secuencia: String,
										NombreColumna: String
									}
								],
								Form: 
								{
									colCountByScreen: 
									{
										lg: 0,
										md: 0,
										sm: 0,
										xs: 0
									},
									labelLocation: String,
									readOnly: False,
									items: 
									[
										{
											itemType: simple,
											visibleIndex: 0
										}
									]
								},
								DataGrid: 
								{
									"columns": 
									[
										{
											"caption": "String",
											"dataField": "String",
											"dataType": "String",
											"visibleIndex": 0,
											"validationRules": 
											[
												{
													"type": "String",
													"message": "String"
												}
											],
											"lookup": 
											{
												"allowClearing": false,
												"displayExpr": "String",
												"valueExpr": "String"
											},
											"allowEditing": false,
											"encodeHtml": false,
											"editorOptions": 
											{
												"String": {}
											},
											"groupIndex": 0
										}
									],
									"showColumnLines": false,
									"showRowLines": false,
									"rowAlternationEnabled": false,
									"showBorders": false,
									"editing": 
									{
										"allowAdding": false,
										"allowDeleting": false,
										"allowUpdating": false,
										"mode": "String"
									},
									"summary": 
									{
										"groupItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"showInGroupFooter": false,
												"summaryType": "String"
											}
										],
										"totalItems": 
										[
											{
												"column": "String",
												"displayFormat": "String",
												"summaryType": "String"
											}
										]
									}
								}
							}
						}
					],
					DetalleLlave: 
					[
						{
							CodigoTabla: 0,
							NombreIndice: String,
							CodigoColumna: 0,
							TipoCalculo: String,
							Secuencia: String,
							NombreColumna: String
						}
					],
					Form: 
					{
						colCountByScreen: 
						{
							lg: 0,
							md: 0,
							sm: 0,
							xs: 0
						},
						labelLocation: String,
						readOnly: False,
						items: 
						[
							{
								itemType: simple,
								visibleIndex: 0
							}
						]
					},
					DataGrid: 
					{
						"columns": 
						[
							{
								"caption": "String",
								"dataField": "String",
								"dataType": "String",
								"visibleIndex": 0,
								"validationRules": 
								[
									{
										"type": "String",
										"message": "String"
									}
								],
								"lookup": 
								{
									"allowClearing": false,
									"displayExpr": "String",
									"valueExpr": "String"
								},
								"allowEditing": false,
								"encodeHtml": false,
								"editorOptions": 
								{
									"String": {}
								},
								"groupIndex": 0
							}
						],
						"showColumnLines": false,
						"showRowLines": false,
						"rowAlternationEnabled": false,
						"showBorders": false,
						"editing": 
						{
							"allowAdding": false,
							"allowDeleting": false,
							"allowUpdating": false,
							"mode": "String"
						},
						"summary": 
						{
							"groupItems": 
							[
								{
									"column": "String",
									"displayFormat": "String",
									"showInGroupFooter": false,
									"summaryType": "String"
								}
							],
							"totalItems": 
							[
								{
									"column": "String",
									"displayFormat": "String",
									"summaryType": "String"
								}
							]
						}
					}
				}
			}
		],
		DetalleLlave: 
		[
			{
				CodigoTabla: 0,
				NombreIndice: String,
				CodigoColumna: 0,
				TipoCalculo: String,
				Secuencia: String,
				NombreColumna: String
			}
		],
		Form: 
		{
			colCountByScreen: 
			{
				lg: 0,
				md: 0,
				sm: 0,
				xs: 0
			},
			labelLocation: String,
			readOnly: False,
			items: 
			[
				{
					itemType: simple,
					visibleIndex: 0
				}
			]
		},
		DataGrid: 
		{
			"columns": 
			[
				{
					"caption": "String",
					"dataField": "String",
					"dataType": "String",
					"visibleIndex": 0,
					"validationRules": 
					[
						{
							"type": "String",
							"message": "String"
						}
					],
					"lookup": 
					{
						"allowClearing": false,
						"displayExpr": "String",
						"valueExpr": "String"
					},
					"allowEditing": false,
					"encodeHtml": false,
					"editorOptions": 
					{
						"String": {}
					},
					"groupIndex": 0
				}
			],
			"showColumnLines": false,
			"showRowLines": false,
			"rowAlternationEnabled": false,
			"showBorders": false,
			"editing": 
			{
				"allowAdding": false,
				"allowDeleting": false,
				"allowUpdating": false,
				"mode": "String"
			},
			"summary": 
			{
				"groupItems": 
				[
					{
						"column": "String",
						"displayFormat": "String",
						"showInGroupFooter": false,
						"summaryType": "String"
					}
				],
				"totalItems": 
				[
					{
						"column": "String",
						"displayFormat": "String",
						"summaryType": "String"
					}
				]
			}
		}
	},
	DatosConsulta: 
	[
		{
			String: {}
		}
	],
	TotalRegistros: 0,
	TotalGrupos: 0,
	SummaryList: 
	[
		{
			
		}
	]
}