| All Verbs | /Utilidades/Consultas/Cubos/Definicion |
|---|
namespace Administrador.Modelo.Contexto
open System
open System.Collections
open System.Collections.Generic
open System.Runtime.Serialization
open ServiceStack
open ServiceStack.DataAnnotations
[<DataContract>]
[<AllowNullLiteral>]
type Tabla() =
[<DataMember>]
member val Codigo:Decimal = new Decimal() with get,set
[<DataMember>]
member val Propietario:String = null with get,set
[<DataMember>]
member val Tipo:String = null with get,set
[<DataMember>]
member val Nombre:String = null with get,set
[<DataMember>]
member val Alias:String = null with get,set
[<DataMember>]
member val Descripcion:String = null with get,set
[<DataMember>]
member val ParaReportes:String = null with get,set
[<DataMember>]
member val CrearAlIniciar:String = null with get,set
[<DataMember>]
member val CampoEmpresa:Int32 = new Int32() with get,set
[<DataMember>]
member val CampoUnico:Int32 = new Int32() with get,set
[<DataContract>]
[<AllowNullLiteral>]
type Columna() =
[<DataMember>]
member val CodigoTabla:Decimal = new Decimal() with get,set
[<DataMember>]
member val Codigo:Decimal = new Decimal() with get,set
[<DataMember>]
member val Nombre:String = null with get,set
[<DataMember>]
member val Alias:String = null with get,set
[<DataMember>]
member val Descripcion:String = null with get,set
[<DataMember>]
member val TipoDato:String = null with get,set
[<DataMember>]
member val ObligatorioFormas:String = null with get,set
[<DataMember>]
member val Hint:String = null with get,set
[<DataMember>]
member val Mayuscula:String = null with get,set
[<DataMember>]
member val Tamano:Int32 = new Int32() with get,set
[<DataMember>]
member val Escala:Int32 = new Int32() with get,set
[<DataMember>]
member val Tipo:String = null with get,set
[<DataMember>]
member val VlrDefecto:String = null with get,set
[<DataMember>]
member val PermiteEditar:String = null with get,set
[<DataMember>]
member val Orden:Int32 = new Int32() with get,set
[<DataMember>]
member val Dinamico:String = null with get,set
[<DataMember>]
member val ClaseControl:String = null with get,set
[<DataMember>]
member val JoinLookup:Decimal = new Decimal() with get,set
[<DataMember>]
member val EsID:String = null with get,set
[<DataMember>]
member val Mascara:String = null with get,set
[<DataMember>]
member val MostrarEnLista:String = null with get,set
[<DataMember>]
member val InfoAdicional:String = null with get,set
[<DataMember>]
member val WHEREDefecto:String = null with get,set
[<DataMember>]
member val TieneResumen:String = null with get,set
[<DataMember>]
member val FormatoResumen:String = null with get,set
[<DataMember>]
member val TipoResumen:String = null with get,set
[<DataMember>]
member val PosicionResumen:String = null with get,set
[<DataMember>]
member val ResumenEnGrupo:String = null with get,set
[<DataMember>]
member val ResumenEnTotal:String = null with get,set
[<DataMember>]
member val IndiceGrupo:Int32 = new Int32() with get,set
[<DataContract>]
[<AllowNullLiteral>]
type Frame() =
[<DataMember>]
member val Codigo:Decimal = new Decimal() with get,set
[<DataMember>]
member val SQL:String = null with get,set
[<DataMember>]
member val Campos1:ResizeArray<String> = new ResizeArray<String>() with get,set
[<DataMember>]
member val Campos2:ResizeArray<String> = new ResizeArray<String>() with get,set
[<DataMember>]
member val TablaFrame:DefinicionTabla = null with get,set
[<DataContract>]
[<AllowNullLiteral>]
type DetalleIndices() =
[<DataMember>]
member val CodigoTabla:Decimal = new Decimal() with get,set
[<DataMember>]
member val NombreIndice:String = null with get,set
[<DataMember>]
member val CodigoColumna:Decimal = new Decimal() with get,set
[<DataMember>]
member val TipoCalculo:String = null with get,set
[<DataMember>]
member val Secuencia:String = null with get,set
[<DataMember>]
member val NombreColumna:String = null with get,set
[<AllowNullLiteral>]
type ColCountByScreen() =
member val lg:Int32 = new Int32() with get,set
member val md:Int32 = new Int32() with get,set
member val sm:Int32 = new Int32() with get,set
member val xs:Int32 = new Int32() with get,set
type ItemTypeForm =
| simple = 0
| group = 1
| tabbed = 2
| empty = 3
[<AllowNullLiteral>]
type EmptyItemForm() =
member val itemType:ItemTypeForm = new ItemTypeForm() with get,set
member val visibleIndex:Int32 = new Int32() with get,set
[<AllowNullLiteral>]
type dxForm() =
member val colCountByScreen:ColCountByScreen = null with get,set
member val labelLocation:String = null with get,set
member val readOnly:Boolean = new Boolean() with get,set
member val items:ResizeArray<EmptyItemForm> = new ResizeArray<EmptyItemForm>() with get,set
[<AllowNullLiteral>]
type ValidationRule() =
member val type:String = null with get,set
member val message:String = null with get,set
[<AllowNullLiteral>]
type LookupGrid() =
member val allowClearing:Boolean = new Boolean() with get,set
member val displayExpr:String = null with get,set
member val valueExpr:String = null with get,set
[<AllowNullLiteral>]
type ColumnGrid() =
member val caption:String = null with get,set
member val dataField:String = null with get,set
member val dataType:String = null with get,set
member val visibleIndex:Int32 = new Int32() with get,set
member val validationRules:ResizeArray<ValidationRule> = new ResizeArray<ValidationRule>() with get,set
member val lookup:LookupGrid = null with get,set
member val allowEditing:Boolean = new Boolean() with get,set
member val encodeHtml:Boolean = new Boolean() with get,set
member val editorOptions:Dictionary<String, Object> = new Dictionary<String, Object>() with get,set
member val groupIndex:Nullable<Int32> = new Nullable<Int32>() with get,set
[<AllowNullLiteral>]
type EditingGrid() =
member val allowAdding:Boolean = new Boolean() with get,set
member val allowDeleting:Boolean = new Boolean() with get,set
member val allowUpdating:Boolean = new Boolean() with get,set
member val mode:String = null with get,set
[<AllowNullLiteral>]
type gridSummaryGroupItems() =
member val column:String = null with get,set
member val displayFormat:String = null with get,set
member val showInGroupFooter:Boolean = new Boolean() with get,set
member val summaryType:String = null with get,set
[<AllowNullLiteral>]
type gridSummaryTotalItems() =
member val column:String = null with get,set
member val displayFormat:String = null with get,set
member val summaryType:String = null with get,set
[<AllowNullLiteral>]
type gridSummary() =
member val groupItems:ResizeArray<gridSummaryGroupItems> = new ResizeArray<gridSummaryGroupItems>() with get,set
member val totalItems:ResizeArray<gridSummaryTotalItems> = new ResizeArray<gridSummaryTotalItems>() with get,set
[<AllowNullLiteral>]
type dxDataGrid() =
member val columns:ResizeArray<ColumnGrid> = new ResizeArray<ColumnGrid>() with get,set
member val showColumnLines:Boolean = new Boolean() with get,set
member val showRowLines:Boolean = new Boolean() with get,set
member val rowAlternationEnabled:Boolean = new Boolean() with get,set
member val showBorders:Boolean = new Boolean() with get,set
member val editing:EditingGrid = null with get,set
member val summary:gridSummary = null with get,set
[<AllowNullLiteral>]
type DefinicionTabla() =
member val Tabla:Tabla = null with get,set
member val Columnas:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Lookups:ResizeArray<DetalleJoinTabla> = new ResizeArray<DetalleJoinTabla>() with get,set
member val Frames:ResizeArray<Frame> = new ResizeArray<Frame>() with get,set
member val DetalleLlave:ResizeArray<DetalleIndices> = new ResizeArray<DetalleIndices>() with get,set
member val Form:dxForm = null with get,set
member val DataGrid:dxDataGrid = null with get,set
[<DataContract>]
[<AllowNullLiteral>]
type Vista() =
[<DataMember>]
member val Codigo:Decimal = new Decimal() with get,set
[<DataMember>]
member val CodigoBlob:Decimal = new Decimal() with get,set
[<DataMember>]
member val Nombre:String = null with get,set
[<DataMember>]
member val Descripcion:String = null with get,set
[<DataMember>]
member val SQL:String = null with get,set
[<DataMember>]
member val CodigoTabla:Decimal = new Decimal() with get,set
[<DataMember>]
member val GuardarBinario:String = null with get,set
[<DataMember>]
member val TipoConsulta:String = null with get,set
[<DataMember>]
member val ExportacionDefault:String = null with get,set
[<DataMember>]
member val TipoExportacion:String = null with get,set
[<DataMember>]
member val ParametrosExportacion:Int32 = new Int32() with get,set
[<DataMember>]
member val CodigoAyuda:String = null with get,set
[<DataMember>]
member val EjecutarEnAdm:String = null with get,set
[<DataMember>]
member val InfoAdicional:String = null with get,set
[<DataMember>]
member val EjecMultiempresa:String = null with get,set
[<AllowNullLiteral>]
type DetalleJoinTabla() =
member val Codigo:Decimal = new Decimal() with get,set
member val CampoAMostrar:String = null with get,set
member val Campos1:ResizeArray<String> = new ResizeArray<String>() with get,set
member val Campos2:ResizeArray<String> = new ResizeArray<String>() with get,set
member val Operadores:ResizeArray<String> = new ResizeArray<String>() with get,set
member val Datos:ResizeArray<Dictionary<String,Object>> = new ResizeArray<Dictionary<String,Object>>() with get,set
member val CodigoTabla1:Decimal = new Decimal() with get,set
member val SQL:String = null with get,set
member val TablaDetalle:DefinicionTabla = null with get,set
member val Vista:Vista = null with get,set
member val Version:String = null with get,set
member val Ordenar:String = null with get,set
[<AllowNullLiteral>]
type PivotGridConf() =
member val Codigo:Decimal = new Decimal() with get,set
member val Nombre:String = null with get,set
member val CrearChart:String = null with get,set
member val Configuration:String = null with get,set
member val Chart:String = null with get,set
member val Observaciones:String = null with get,set
member val IDVista:Decimal = new Decimal() with get,set
member val Usuario:String = null with get,set
member val FechaCreacion:DateTime = new DateTime() with get,set
[<AllowNullLiteral>]
type DefinicionCuboRS() =
member val Tabla:Tabla = null with get,set
member val Descripcion:String = null with get,set
member val Filtros:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Filas:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Columnas:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Calculos:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Parametros:ResizeArray<Columna> = new ResizeArray<Columna>() with get,set
member val Lookups:ResizeArray<DetalleJoinTabla> = new ResizeArray<DetalleJoinTabla>() with get,set
member val dxPivotGrid:Dictionary<String, Object> = new Dictionary<String, Object>() with get,set
member val dxChart:Dictionary<String, Object> = new Dictionary<String, Object>() with get,set
member val FormaParametros:dxForm = null with get,set
member val PivotGridConf:PivotGridConf = null with get,set
member val Error:String = null with get,set
type Lenguajes =
| ES = 0
| PT = 1
| EN = 2
[<AllowNullLiteral>]
type VersionLookup() =
member val CodLookup:Decimal = new Decimal() with get,set
member val Version:String = null with get,set
[<AllowNullLiteral>]
type DefinicionCuboRQ() =
member val IDVista:Int32 = new Int32() with get,set
member val IDPivot:Int32 = new Int32() with get,set
member val DatosLookups:Boolean = new Boolean() with get,set
member val Lenguaje:Lenguajes = new Lenguajes() with get,set
member val VersionesLookupCliente:ResizeArray<VersionLookup> = new ResizeArray<VersionLookup>() with get,set
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
}