FrameAppWS

DefinicionCuboRQ

The following routes are available for this service:
All Verbs	/Utilidades/Consultas/Cubos/Definicion

using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using Administrador.Modelo.Tipos;
using Administrador.Modelo.Contexto;
using Administrador.Modelo.DevExtreme;

namespace Administrador.Modelo.Contexto
{
    [DataContract]
    public partial class Columna
    {
        [DataMember]
        public virtual decimal CodigoTabla { get; set; }

        [DataMember]
        public virtual decimal Codigo { get; set; }

        [DataMember]
        public virtual string Nombre { get; set; }

        [DataMember]
        public virtual string Alias { get; set; }

        [DataMember]
        public virtual string Descripcion { get; set; }

        [DataMember]
        public virtual string TipoDato { get; set; }

        [DataMember]
        public virtual string ObligatorioFormas { get; set; }

        [DataMember]
        public virtual string Hint { get; set; }

        [DataMember]
        public virtual string Mayuscula { get; set; }

        [DataMember]
        public virtual int Tamano { get; set; }

        [DataMember]
        public virtual int Escala { get; set; }

        [DataMember]
        public virtual string Tipo { get; set; }

        [DataMember]
        public virtual string VlrDefecto { get; set; }

        [DataMember]
        public virtual string PermiteEditar { get; set; }

        [DataMember]
        public virtual int Orden { get; set; }

        [DataMember]
        public virtual string Dinamico { get; set; }

        [DataMember]
        public virtual string ClaseControl { get; set; }

        [DataMember]
        public virtual decimal JoinLookup { get; set; }

        [DataMember]
        public virtual string EsID { get; set; }

        [DataMember]
        public virtual string Mascara { get; set; }

        [DataMember]
        public virtual string MostrarEnLista { get; set; }

        [DataMember]
        public virtual string InfoAdicional { get; set; }

        [DataMember]
        public virtual string WHEREDefecto { get; set; }

        [DataMember]
        public virtual string TieneResumen { get; set; }

        [DataMember]
        public virtual string FormatoResumen { get; set; }

        [DataMember]
        public virtual string TipoResumen { get; set; }

        [DataMember]
        public virtual string PosicionResumen { get; set; }

        [DataMember]
        public virtual string ResumenEnGrupo { get; set; }

        [DataMember]
        public virtual string ResumenEnTotal { get; set; }

        [DataMember]
        public virtual int IndiceGrupo { get; set; }
    }

    [DataContract]
    public partial class DetalleIndices
    {
        [DataMember]
        public virtual decimal CodigoTabla { get; set; }

        [DataMember]
        public virtual string NombreIndice { get; set; }

        [DataMember]
        public virtual decimal CodigoColumna { get; set; }

        [DataMember]
        public virtual string TipoCalculo { get; set; }

        [DataMember]
        public virtual string Secuencia { get; set; }

        [DataMember]
        public virtual string NombreColumna { get; set; }
    }

    public partial class PivotGridConf
    {
        public virtual decimal Codigo { get; set; }
        public virtual string Nombre { get; set; }
        public virtual string CrearChart { get; set; }
        public virtual string Configuration { get; set; }
        public virtual string Chart { get; set; }
        public virtual string Observaciones { get; set; }
        public virtual decimal IDVista { get; set; }
        public virtual string Usuario { get; set; }
        public virtual DateTime FechaCreacion { get; set; }
    }

    [DataContract]
    public partial class Tabla
    {
        [DataMember]
        public virtual decimal Codigo { get; set; }

        [DataMember]
        public virtual string Propietario { get; set; }

        [DataMember]
        public virtual string Tipo { get; set; }

        [DataMember]
        public virtual string Nombre { get; set; }

        [DataMember]
        public virtual string Alias { get; set; }

        [DataMember]
        public virtual string Descripcion { get; set; }

        [DataMember]
        public virtual string ParaReportes { get; set; }

        [DataMember]
        public virtual string CrearAlIniciar { get; set; }

        [DataMember]
        public virtual int CampoEmpresa { get; set; }

        [DataMember]
        public virtual int CampoUnico { get; set; }
    }

    [DataContract]
    public partial class Vista
    {
        [DataMember]
        public virtual decimal Codigo { get; set; }

        [DataMember]
        public virtual decimal CodigoBlob { get; set; }

        [DataMember]
        public virtual string Nombre { get; set; }

        [DataMember]
        public virtual string Descripcion { get; set; }

        [DataMember]
        public virtual string SQL { get; set; }

        [DataMember]
        public virtual decimal CodigoTabla { get; set; }

        [DataMember]
        public virtual string GuardarBinario { get; set; }

        [DataMember]
        public virtual string TipoConsulta { get; set; }

        [DataMember]
        public virtual string ExportacionDefault { get; set; }

        [DataMember]
        public virtual string TipoExportacion { get; set; }

        [DataMember]
        public virtual int ParametrosExportacion { get; set; }

        [DataMember]
        public virtual string CodigoAyuda { get; set; }

        [DataMember]
        public virtual string EjecutarEnAdm { get; set; }

        [DataMember]
        public virtual string InfoAdicional { get; set; }

        [DataMember]
        public virtual string EjecMultiempresa { get; set; }
    }

}

namespace Administrador.Modelo.DevExtreme
{
    public partial class ColCountByScreen
    {
        public virtual int lg { get; set; }
        public virtual int md { get; set; }
        public virtual int sm { get; set; }
        public virtual int xs { get; set; }
    }

    public partial class ColumnGrid
    {
        public ColumnGrid()
        {
            validationRules = new List<ValidationRule>{};
            editorOptions = new Dictionary<string, Object>{};
        }

        public virtual string caption { get; set; }
        public virtual string dataField { get; set; }
        public virtual string dataType { get; set; }
        public virtual int visibleIndex { get; set; }
        public virtual List<ValidationRule> validationRules { get; set; }
        public virtual LookupGrid lookup { get; set; }
        public virtual bool allowEditing { get; set; }
        public virtual bool encodeHtml { get; set; }
        public virtual Dictionary<string, Object> editorOptions { get; set; }
        public virtual int? groupIndex { get; set; }
    }

    public partial class dxDataGrid
    {
        public dxDataGrid()
        {
            columns = new List<ColumnGrid>{};
        }

        public virtual List<ColumnGrid> columns { get; set; }
        public virtual bool showColumnLines { get; set; }
        public virtual bool showRowLines { get; set; }
        public virtual bool rowAlternationEnabled { get; set; }
        public virtual bool showBorders { get; set; }
        public virtual EditingGrid editing { get; set; }
        public virtual gridSummary summary { get; set; }
    }

    public partial class dxForm
    {
        public dxForm()
        {
            items = new List<EmptyItemForm>{};
        }

        public virtual ColCountByScreen colCountByScreen { get; set; }
        public virtual string labelLocation { get; set; }
        public virtual bool readOnly { get; set; }
        public virtual List<EmptyItemForm> items { get; set; }
    }

    public partial class EditingGrid
    {
        public virtual bool allowAdding { get; set; }
        public virtual bool allowDeleting { get; set; }
        public virtual bool allowUpdating { get; set; }
        public virtual string mode { get; set; }
    }

    public partial class EmptyItemForm
    {
        public virtual ItemTypeForm itemType { get; set; }
        public virtual int visibleIndex { get; set; }
    }

    public partial class gridSummary
    {
        public gridSummary()
        {
            groupItems = new List<gridSummaryGroupItems>{};
            totalItems = new List<gridSummaryTotalItems>{};
        }

        public virtual List<gridSummaryGroupItems> groupItems { get; set; }
        public virtual List<gridSummaryTotalItems> totalItems { get; set; }
    }

    public partial class gridSummaryGroupItems
    {
        public virtual string column { get; set; }
        public virtual string displayFormat { get; set; }
        public virtual bool showInGroupFooter { get; set; }
        public virtual string summaryType { get; set; }
    }

    public partial class gridSummaryTotalItems
    {
        public virtual string column { get; set; }
        public virtual string displayFormat { get; set; }
        public virtual string summaryType { get; set; }
    }

    public enum ItemTypeForm
    {
        simple,
        group,
        tabbed,
        empty,
    }

    public partial class LookupGrid
    {
        public virtual bool allowClearing { get; set; }
        public virtual string displayExpr { get; set; }
        public virtual string valueExpr { get; set; }
    }

    public partial class ValidationRule
    {
        public virtual string type { get; set; }
        public virtual string message { get; set; }
    }

}

namespace Administrador.Modelo.Tipos
{
    public partial class DefinicionCuboRQ
    {
        public DefinicionCuboRQ()
        {
            VersionesLookupCliente = new List<VersionLookup>{};
        }

        public virtual int IDVista { get; set; }
        public virtual int IDPivot { get; set; }
        public virtual bool DatosLookups { get; set; }
        public virtual Lenguajes Lenguaje { get; set; }
        public virtual List<VersionLookup> VersionesLookupCliente { get; set; }
    }

    public partial class DefinicionCuboRS
    {
        public DefinicionCuboRS()
        {
            Filtros = new List<Columna>{};
            Filas = new List<Columna>{};
            Columnas = new List<Columna>{};
            Calculos = new List<Columna>{};
            Parametros = new List<Columna>{};
            Lookups = new List<DetalleJoinTabla>{};
            dxPivotGrid = new Dictionary<string, Object>{};
            dxChart = new Dictionary<string, Object>{};
        }

        public virtual Tabla Tabla { get; set; }
        public virtual string Descripcion { get; set; }
        public virtual List<Columna> Filtros { get; set; }
        public virtual List<Columna> Filas { get; set; }
        public virtual List<Columna> Columnas { get; set; }
        public virtual List<Columna> Calculos { get; set; }
        public virtual List<Columna> Parametros { get; set; }
        public virtual List<DetalleJoinTabla> Lookups { get; set; }
        public virtual Dictionary<string, Object> dxPivotGrid { get; set; }
        public virtual Dictionary<string, Object> dxChart { get; set; }
        public virtual dxForm FormaParametros { get; set; }
        public virtual PivotGridConf PivotGridConf { get; set; }
        public virtual string Error { get; set; }
    }

    public partial class DefinicionTabla
    {
        public DefinicionTabla()
        {
            Columnas = new List<Columna>{};
            Lookups = new List<DetalleJoinTabla>{};
            Frames = new List<Frame>{};
            DetalleLlave = new List<DetalleIndices>{};
        }

        public virtual Tabla Tabla { get; set; }
        public virtual List<Columna> Columnas { get; set; }
        public virtual List<DetalleJoinTabla> Lookups { get; set; }
        public virtual List<Frame> Frames { get; set; }
        public virtual List<DetalleIndices> DetalleLlave { get; set; }
        public virtual dxForm Form { get; set; }
        public virtual dxDataGrid DataGrid { get; set; }
    }

    public partial class DetalleJoinTabla
    {
        public DetalleJoinTabla()
        {
            Campos1 = new List<string>{};
            Campos2 = new List<string>{};
            Operadores = new List<string>{};
            Datos = new List<Dictionary<String,Object>>{};
        }

        public virtual decimal Codigo { get; set; }
        public virtual string CampoAMostrar { get; set; }
        public virtual List<string> Campos1 { get; set; }
        public virtual List<string> Campos2 { get; set; }
        public virtual List<string> Operadores { get; set; }
        public virtual List<Dictionary<String,Object>> Datos { get; set; }
        public virtual decimal CodigoTabla1 { get; set; }
        public virtual string SQL { get; set; }
        public virtual DefinicionTabla TablaDetalle { get; set; }
        public virtual Vista Vista { get; set; }
        public virtual string Version { get; set; }
        public virtual string Ordenar { get; set; }
    }

    [DataContract]
    public partial class Frame
    {
        public Frame()
        {
            Campos1 = new List<string>{};
            Campos2 = new List<string>{};
        }

        [DataMember]
        public virtual decimal Codigo { get; set; }

        [DataMember]
        public virtual string SQL { get; set; }

        [DataMember]
        public virtual List<string> Campos1 { get; set; }

        [DataMember]
        public virtual List<string> Campos2 { get; set; }

        [DataMember]
        public virtual DefinicionTabla TablaFrame { get; set; }
    }

    public enum Lenguajes
    {
        ES,
        PT,
        EN,
    }

    public partial class VersionLookup
    {
        public virtual decimal CodLookup { get; set; }
        public virtual string Version { get; set; }
    }

}

C# DefinicionCuboRQ 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/Consultas/Cubos/Definicion HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	IDVista: 0,
	IDPivot: 0,
	DatosLookups: False,
	Lenguaje: ES,
	VersionesLookupCliente: 
	[
		{
			CodLookup: 0,
			Version: String
		}
	]
}

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

{
	Tabla: 
	{
		Codigo: 0,
		Propietario: String,
		Tipo: String,
		Nombre: String,
		Alias: String,
		Descripcion: String,
		ParaReportes: String,
		CrearAlIniciar: String,
		CampoEmpresa: 0,
		CampoUnico: 0
	},
	Descripcion: String,
	Filtros: 
	[
		{
			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
		}
	],
	Filas: 
	[
		{
			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
		}
	],
	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
		}
	],
	Calculos: 
	[
		{
			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
		}
	],
	Parametros: 
	[
		{
			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,
									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
											}
										],
										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"
							}
						]
					}
				}
			},
			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
		}
	],
	dxPivotGrid: 
	{
		String: {}
	},
	dxChart: 
	{
		String: {}
	},
	FormaParametros: 
	{
		colCountByScreen: 
		{
			lg: 0,
			md: 0,
			sm: 0,
			xs: 0
		},
		labelLocation: String,
		readOnly: False,
		items: 
		[
			{
				itemType: simple,
				visibleIndex: 0
			}
		]
	},
	PivotGridConf: 
	{
		Codigo: 0,
		Nombre: String,
		CrearChart: String,
		Configuration: String,
		Chart: String,
		Observaciones: String,
		IDVista: 0,
		Usuario: String
	},
	Error: String
}