| All Verbs | /Utilidades/Consultas/Cubos/Definicion |
|---|
import java.math.*
import java.util.*
import net.servicestack.client.*
import com.google.gson.annotations.*
import com.google.gson.reflect.*
open class DefinicionCuboRQ
{
var IDVista:Int? = null
var IDPivot:Int? = null
var DatosLookups:Boolean? = null
var Lenguaje:Lenguajes? = null
var VersionesLookupCliente:ArrayList<VersionLookup> = ArrayList<VersionLookup>()
}
enum class Lenguajes
{
Es,
Pt,
En,
}
open class VersionLookup
{
var CodLookup:BigDecimal? = null
var Version:String? = null
}
open class DefinicionCuboRS
{
var Tabla:Tabla? = null
var Descripcion:String? = null
var Filtros:ArrayList<Columna> = ArrayList<Columna>()
var Filas:ArrayList<Columna> = ArrayList<Columna>()
var Columnas:ArrayList<Columna> = ArrayList<Columna>()
var Calculos:ArrayList<Columna> = ArrayList<Columna>()
var Parametros:ArrayList<Columna> = ArrayList<Columna>()
var Lookups:ArrayList<DetalleJoinTabla> = ArrayList<DetalleJoinTabla>()
var dxPivotGrid:HashMap<String,Object> = HashMap<String,Object>()
var dxChart:HashMap<String,Object> = HashMap<String,Object>()
var FormaParametros:dxForm? = null
var PivotGridConf:PivotGridConf? = null
var Error:String? = null
}
@DataContract
open class Tabla
{
@DataMember
var Codigo:BigDecimal? = null
@DataMember
var Propietario:String? = null
@DataMember
var Tipo:String? = null
@DataMember
var Nombre:String? = null
@DataMember
var Alias:String? = null
@DataMember
var Descripcion:String? = null
@DataMember
var ParaReportes:String? = null
@DataMember
var CrearAlIniciar:String? = null
@DataMember
var CampoEmpresa:Int? = null
@DataMember
var CampoUnico:Int? = null
}
@DataContract
open class Columna
{
@DataMember
var CodigoTabla:BigDecimal? = null
@DataMember
var Codigo:BigDecimal? = null
@DataMember
var Nombre:String? = null
@DataMember
var Alias:String? = null
@DataMember
var Descripcion:String? = null
@DataMember
var TipoDato:String? = null
@DataMember
var ObligatorioFormas:String? = null
@DataMember
var Hint:String? = null
@DataMember
var Mayuscula:String? = null
@DataMember
var Tamano:Int? = null
@DataMember
var Escala:Int? = null
@DataMember
var Tipo:String? = null
@DataMember
var VlrDefecto:String? = null
@DataMember
var PermiteEditar:String? = null
@DataMember
var Orden:Int? = null
@DataMember
var Dinamico:String? = null
@DataMember
var ClaseControl:String? = null
@DataMember
var JoinLookup:BigDecimal? = null
@DataMember
var EsID:String? = null
@DataMember
var Mascara:String? = null
@DataMember
var MostrarEnLista:String? = null
@DataMember
var InfoAdicional:String? = null
@DataMember
var WHEREDefecto:String? = null
@DataMember
var TieneResumen:String? = null
@DataMember
var FormatoResumen:String? = null
@DataMember
var TipoResumen:String? = null
@DataMember
var PosicionResumen:String? = null
@DataMember
var ResumenEnGrupo:String? = null
@DataMember
var ResumenEnTotal:String? = null
@DataMember
var IndiceGrupo:Int? = null
}
open class DetalleJoinTabla
{
var Codigo:BigDecimal? = null
var CampoAMostrar:String? = null
var Campos1:ArrayList<String> = ArrayList<String>()
var Campos2:ArrayList<String> = ArrayList<String>()
var Operadores:ArrayList<String> = ArrayList<String>()
var Datos:ArrayList<HashMap<String,Object>> = ArrayList<HashMap<String,Object>>()
var CodigoTabla1:BigDecimal? = null
var SQL:String? = null
var TablaDetalle:DefinicionTabla? = null
var Vista:Vista? = null
var Version:String? = null
var Ordenar:String? = null
}
open class DefinicionTabla
{
var Tabla:Tabla? = null
var Columnas:ArrayList<Columna> = ArrayList<Columna>()
var Lookups:ArrayList<DetalleJoinTabla> = ArrayList<DetalleJoinTabla>()
var Frames:ArrayList<Frame> = ArrayList<Frame>()
var DetalleLlave:ArrayList<DetalleIndices> = ArrayList<DetalleIndices>()
var Form:dxForm? = null
var DataGrid:dxDataGrid? = null
}
@DataContract
open class Frame
{
@DataMember
var Codigo:BigDecimal? = null
@DataMember
var SQL:String? = null
@DataMember
var Campos1:ArrayList<String> = ArrayList<String>()
@DataMember
var Campos2:ArrayList<String> = ArrayList<String>()
@DataMember
var TablaFrame:DefinicionTabla? = null
}
@DataContract
open class DetalleIndices
{
@DataMember
var CodigoTabla:BigDecimal? = null
@DataMember
var NombreIndice:String? = null
@DataMember
var CodigoColumna:BigDecimal? = null
@DataMember
var TipoCalculo:String? = null
@DataMember
var Secuencia:String? = null
@DataMember
var NombreColumna:String? = null
}
open class dxForm
{
var colCountByScreen:ColCountByScreen? = null
var labelLocation:String? = null
var readOnly:Boolean? = null
var items:ArrayList<EmptyItemForm> = ArrayList<EmptyItemForm>()
}
open class ColCountByScreen
{
var lg:Int? = null
var md:Int? = null
var sm:Int? = null
var xs:Int? = null
}
open class EmptyItemForm
{
var itemType:ItemTypeForm? = null
var visibleIndex:Int? = null
}
enum class ItemTypeForm
{
Simple,
Group,
Tabbed,
Empty,
}
open class dxDataGrid
{
var columns:ArrayList<ColumnGrid> = ArrayList<ColumnGrid>()
var showColumnLines:Boolean? = null
var showRowLines:Boolean? = null
var rowAlternationEnabled:Boolean? = null
var showBorders:Boolean? = null
var editing:EditingGrid? = null
var summary:gridSummary? = null
}
open class ColumnGrid
{
var caption:String? = null
var dataField:String? = null
var dataType:String? = null
var visibleIndex:Int? = null
var validationRules:ArrayList<ValidationRule> = ArrayList<ValidationRule>()
var lookup:LookupGrid? = null
var allowEditing:Boolean? = null
var encodeHtml:Boolean? = null
var editorOptions:HashMap<String,Object> = HashMap<String,Object>()
var groupIndex:Int? = null
}
open class ValidationRule
{
@SerializedName("type") var Type:String? = null
var message:String? = null
}
open class LookupGrid
{
var allowClearing:Boolean? = null
var displayExpr:String? = null
var valueExpr:String? = null
}
open class EditingGrid
{
var allowAdding:Boolean? = null
var allowDeleting:Boolean? = null
var allowUpdating:Boolean? = null
var mode:String? = null
}
open class gridSummary
{
var groupItems:ArrayList<gridSummaryGroupItems> = ArrayList<gridSummaryGroupItems>()
var totalItems:ArrayList<gridSummaryTotalItems> = ArrayList<gridSummaryTotalItems>()
}
open class gridSummaryGroupItems
{
var column:String? = null
var displayFormat:String? = null
var showInGroupFooter:Boolean? = null
var summaryType:String? = null
}
open class gridSummaryTotalItems
{
var column:String? = null
var displayFormat:String? = null
var summaryType:String? = null
}
@DataContract
open class Vista
{
@DataMember
var Codigo:BigDecimal? = null
@DataMember
var CodigoBlob:BigDecimal? = null
@DataMember
var Nombre:String? = null
@DataMember
var Descripcion:String? = null
@DataMember
var SQL:String? = null
@DataMember
var CodigoTabla:BigDecimal? = null
@DataMember
var GuardarBinario:String? = null
@DataMember
var TipoConsulta:String? = null
@DataMember
var ExportacionDefault:String? = null
@DataMember
var TipoExportacion:String? = null
@DataMember
var ParametrosExportacion:Int? = null
@DataMember
var CodigoAyuda:String? = null
@DataMember
var EjecutarEnAdm:String? = null
@DataMember
var InfoAdicional:String? = null
@DataMember
var EjecMultiempresa:String? = null
}
open class PivotGridConf
{
var Codigo:BigDecimal? = null
var Nombre:String? = null
var CrearChart:String? = null
var Configuration:String? = null
var Chart:String? = null
var Observaciones:String? = null
var IDVista:BigDecimal? = null
var Usuario:String? = null
var FechaCreacion:Date? = null
}
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
}