All Verbs | /Utilidades/Consultas/Cubos/Definicion |
---|
// @DataContract
export class Tabla
{
// @DataMember
public Codigo: number;
// @DataMember
public Propietario: string;
// @DataMember
public Tipo: string;
// @DataMember
public Nombre: string;
// @DataMember
public Alias: string;
// @DataMember
public Descripcion: string;
// @DataMember
public ParaReportes: string;
// @DataMember
public CrearAlIniciar: string;
// @DataMember
public CampoEmpresa: number;
// @DataMember
public CampoUnico: number;
public constructor(init?: Partial<Tabla>) { (Object as any).assign(this, init); }
}
// @DataContract
export class Columna
{
// @DataMember
public CodigoTabla: number;
// @DataMember
public Codigo: number;
// @DataMember
public Nombre: string;
// @DataMember
public Alias: string;
// @DataMember
public Descripcion: string;
// @DataMember
public TipoDato: string;
// @DataMember
public ObligatorioFormas: string;
// @DataMember
public Hint: string;
// @DataMember
public Mayuscula: string;
// @DataMember
public Tamano: number;
// @DataMember
public Escala: number;
// @DataMember
public Tipo: string;
// @DataMember
public VlrDefecto: string;
// @DataMember
public PermiteEditar: string;
// @DataMember
public Orden: number;
// @DataMember
public Dinamico: string;
// @DataMember
public ClaseControl: string;
// @DataMember
public JoinLookup: number;
// @DataMember
public EsID: string;
// @DataMember
public Mascara: string;
// @DataMember
public MostrarEnLista: string;
// @DataMember
public InfoAdicional: string;
// @DataMember
public WHEREDefecto: string;
// @DataMember
public TieneResumen: string;
// @DataMember
public FormatoResumen: string;
// @DataMember
public TipoResumen: string;
// @DataMember
public PosicionResumen: string;
// @DataMember
public ResumenEnGrupo: string;
// @DataMember
public ResumenEnTotal: string;
// @DataMember
public IndiceGrupo: number;
public constructor(init?: Partial<Columna>) { (Object as any).assign(this, init); }
}
// @DataContract
export class Frame
{
// @DataMember
public Codigo: number;
// @DataMember
public SQL: string;
// @DataMember
public Campos1: string[];
// @DataMember
public Campos2: string[];
// @DataMember
public TablaFrame: DefinicionTabla;
public constructor(init?: Partial<Frame>) { (Object as any).assign(this, init); }
}
// @DataContract
export class DetalleIndices
{
// @DataMember
public CodigoTabla: number;
// @DataMember
public NombreIndice: string;
// @DataMember
public CodigoColumna: number;
// @DataMember
public TipoCalculo: string;
// @DataMember
public Secuencia: string;
// @DataMember
public NombreColumna: string;
public constructor(init?: Partial<DetalleIndices>) { (Object as any).assign(this, init); }
}
export class ColCountByScreen
{
public lg: number;
public md: number;
public sm: number;
public xs: number;
public constructor(init?: Partial<ColCountByScreen>) { (Object as any).assign(this, init); }
}
export enum ItemTypeForm
{
simple = 'simple',
group = 'group',
tabbed = 'tabbed',
empty = 'empty',
}
export class EmptyItemForm
{
public itemType: ItemTypeForm;
public visibleIndex: number;
public constructor(init?: Partial<EmptyItemForm>) { (Object as any).assign(this, init); }
}
export class dxForm
{
public colCountByScreen: ColCountByScreen;
public labelLocation: string;
public readOnly: boolean;
public items: EmptyItemForm[];
public constructor(init?: Partial<dxForm>) { (Object as any).assign(this, init); }
}
export class ValidationRule
{
public type: string;
public message: string;
public constructor(init?: Partial<ValidationRule>) { (Object as any).assign(this, init); }
}
export class LookupGrid
{
public allowClearing: boolean;
public displayExpr: string;
public valueExpr: string;
public constructor(init?: Partial<LookupGrid>) { (Object as any).assign(this, init); }
}
export class ColumnGrid
{
public caption: string;
public dataField: string;
public dataType: string;
public visibleIndex: number;
public validationRules: ValidationRule[];
public lookup: LookupGrid;
public allowEditing: boolean;
public encodeHtml: boolean;
public editorOptions: { [index: string]: Object; };
public groupIndex?: number;
public constructor(init?: Partial<ColumnGrid>) { (Object as any).assign(this, init); }
}
export class EditingGrid
{
public allowAdding: boolean;
public allowDeleting: boolean;
public allowUpdating: boolean;
public mode: string;
public constructor(init?: Partial<EditingGrid>) { (Object as any).assign(this, init); }
}
export class gridSummaryGroupItems
{
public column: string;
public displayFormat: string;
public showInGroupFooter: boolean;
public summaryType: string;
public constructor(init?: Partial<gridSummaryGroupItems>) { (Object as any).assign(this, init); }
}
export class gridSummaryTotalItems
{
public column: string;
public displayFormat: string;
public summaryType: string;
public constructor(init?: Partial<gridSummaryTotalItems>) { (Object as any).assign(this, init); }
}
export class gridSummary
{
public groupItems: gridSummaryGroupItems[];
public totalItems: gridSummaryTotalItems[];
public constructor(init?: Partial<gridSummary>) { (Object as any).assign(this, init); }
}
export class dxDataGrid
{
public columns: ColumnGrid[];
public showColumnLines: boolean;
public showRowLines: boolean;
public rowAlternationEnabled: boolean;
public showBorders: boolean;
public editing: EditingGrid;
public summary: gridSummary;
public constructor(init?: Partial<dxDataGrid>) { (Object as any).assign(this, init); }
}
export class DefinicionTabla
{
public Tabla: Tabla;
public Columnas: Columna[];
public Lookups: DetalleJoinTabla[];
public Frames: Frame[];
public DetalleLlave: DetalleIndices[];
public Form: dxForm;
public DataGrid: dxDataGrid;
public constructor(init?: Partial<DefinicionTabla>) { (Object as any).assign(this, init); }
}
// @DataContract
export class Vista
{
// @DataMember
public Codigo: number;
// @DataMember
public CodigoBlob: number;
// @DataMember
public Nombre: string;
// @DataMember
public Descripcion: string;
// @DataMember
public SQL: string;
// @DataMember
public CodigoTabla: number;
// @DataMember
public GuardarBinario: string;
// @DataMember
public TipoConsulta: string;
// @DataMember
public ExportacionDefault: string;
// @DataMember
public TipoExportacion: string;
// @DataMember
public ParametrosExportacion: number;
// @DataMember
public CodigoAyuda: string;
// @DataMember
public EjecutarEnAdm: string;
// @DataMember
public InfoAdicional: string;
// @DataMember
public EjecMultiempresa: string;
public constructor(init?: Partial<Vista>) { (Object as any).assign(this, init); }
}
export class DetalleJoinTabla
{
public Codigo: number;
public CampoAMostrar: string;
public Campos1: string[];
public Campos2: string[];
public Operadores: string[];
public Datos: { [index:string]: Object; }[];
public CodigoTabla1: number;
public SQL: string;
public TablaDetalle: DefinicionTabla;
public Vista: Vista;
public Version: string;
public Ordenar: string;
public constructor(init?: Partial<DetalleJoinTabla>) { (Object as any).assign(this, init); }
}
export class PivotGridConf
{
public Codigo: number;
public Nombre: string;
public CrearChart: string;
public Configuration: string;
public Chart: string;
public Observaciones: string;
public IDVista: number;
public Usuario: string;
public FechaCreacion: string;
public constructor(init?: Partial<PivotGridConf>) { (Object as any).assign(this, init); }
}
export class DefinicionCuboRS
{
public Tabla: Tabla;
public Descripcion: string;
public Filtros: Columna[];
public Filas: Columna[];
public Columnas: Columna[];
public Calculos: Columna[];
public Parametros: Columna[];
public Lookups: DetalleJoinTabla[];
public dxPivotGrid: { [index: string]: Object; };
public dxChart: { [index: string]: Object; };
public FormaParametros: dxForm;
public PivotGridConf: PivotGridConf;
public Error: string;
public constructor(init?: Partial<DefinicionCuboRS>) { (Object as any).assign(this, init); }
}
export enum Lenguajes
{
ES = 'ES',
PT = 'PT',
EN = 'EN',
}
export class VersionLookup
{
public CodLookup: number;
public Version: string;
public constructor(init?: Partial<VersionLookup>) { (Object as any).assign(this, init); }
}
export class DefinicionCuboRQ
{
public IDVista: number;
public IDPivot: number;
public DatosLookups: boolean;
public Lenguaje: Lenguajes;
public VersionesLookupCliente: VersionLookup[];
public constructor(init?: Partial<DefinicionCuboRQ>) { (Object as any).assign(this, init); }
}
TypeScript DefinicionCuboRQ DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=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 }