| All Verbs | /Utilidades/Consultas/Cubos/DefinicionGrupo |
|---|
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| IDGrupo | query | int | No | |
| Lenguaje | query | Lenguajes | No |
| ES | |
| PT | |
| EN |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| GrupoPivotGrid | form | PivotGridGrupo | No | |
| Items | form | List<DefinicionCuboRS> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| Nombre | form | string | No | |
| Observaciones | form | string | No | |
| Usuario | form | string | No | |
| FechaCreacion | form | DateTime | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Tabla | form | Tabla | No | |
| Descripcion | form | string | No | |
| Filtros | form | List<Columna> | No | |
| Filas | form | List<Columna> | No | |
| Columnas | form | List<Columna> | No | |
| Calculos | form | List<Columna> | No | |
| Parametros | form | List<Columna> | No | |
| Lookups | form | List<DetalleJoinTabla> | No | |
| dxPivotGrid | form | Dictionary<string, Object> | No | |
| dxChart | form | Dictionary<string, Object> | No | |
| FormaParametros | form | dxForm | No | |
| PivotGridConf | form | PivotGridConf | No | |
| Error | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| Propietario | form | string | No | |
| Tipo | form | string | No | |
| Nombre | form | string | No | |
| Alias | form | string | No | |
| Descripcion | form | string | No | |
| ParaReportes | form | string | No | |
| CrearAlIniciar | form | string | No | |
| CampoEmpresa | form | int | No | |
| CampoUnico | form | int | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| CodigoTabla | form | decimal | No | |
| Codigo | form | decimal | No | |
| Nombre | form | string | No | |
| Alias | form | string | No | |
| Descripcion | form | string | No | |
| TipoDato | form | string | No | |
| ObligatorioFormas | form | string | No | |
| Hint | form | string | No | |
| Mayuscula | form | string | No | |
| Tamano | form | int | No | |
| Escala | form | int | No | |
| Tipo | form | string | No | |
| VlrDefecto | form | string | No | |
| PermiteEditar | form | string | No | |
| Orden | form | int | No | |
| Dinamico | form | string | No | |
| ClaseControl | form | string | No | |
| JoinLookup | form | decimal | No | |
| EsID | form | string | No | |
| Mascara | form | string | No | |
| MostrarEnLista | form | string | No | |
| InfoAdicional | form | string | No | |
| WHEREDefecto | form | string | No | |
| TieneResumen | form | string | No | |
| FormatoResumen | form | string | No | |
| TipoResumen | form | string | No | |
| PosicionResumen | form | string | No | |
| ResumenEnGrupo | form | string | No | |
| ResumenEnTotal | form | string | No | |
| IndiceGrupo | form | int | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| CampoAMostrar | form | string | No | |
| Campos1 | form | List<string> | No | |
| Campos2 | form | List<string> | No | |
| Operadores | form | List<string> | No | |
| Datos | form | List<Dictionary<String,Object>> | No | |
| CodigoTabla1 | form | decimal | No | |
| SQL | form | string | No | |
| TablaDetalle | form | DefinicionTabla | No | |
| Vista | form | Vista | No | |
| Version | form | string | No | |
| Ordenar | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Tabla | form | Tabla | No | |
| Columnas | form | List<Columna> | No | |
| Lookups | form | List<DetalleJoinTabla> | No | |
| Frames | form | List<Frame> | No | |
| DetalleLlave | form | List<DetalleIndices> | No | |
| Form | form | dxForm | No | |
| DataGrid | form | dxDataGrid | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| SQL | form | string | No | |
| Campos1 | form | List<string> | No | |
| Campos2 | form | List<string> | No | |
| TablaFrame | form | DefinicionTabla | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| CodigoTabla | form | decimal | No | |
| NombreIndice | form | string | No | |
| CodigoColumna | form | decimal | No | |
| TipoCalculo | form | string | No | |
| Secuencia | form | string | No | |
| NombreColumna | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| colCountByScreen | form | ColCountByScreen | No | |
| labelLocation | form | string | No | |
| readOnly | form | bool | No | |
| items | form | List<EmptyItemForm> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| lg | form | int | No | |
| md | form | int | No | |
| sm | form | int | No | |
| xs | form | int | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| itemType | form | ItemTypeForm | No | |
| visibleIndex | form | int | No |
| simple | |
| group | |
| tabbed | |
| empty |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| columns | form | List<ColumnGrid> | No | |
| showColumnLines | form | bool | No | |
| showRowLines | form | bool | No | |
| rowAlternationEnabled | form | bool | No | |
| showBorders | form | bool | No | |
| editing | form | EditingGrid | No | |
| summary | form | gridSummary | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| caption | form | string | No | |
| dataField | form | string | No | |
| dataType | form | string | No | |
| visibleIndex | form | int | No | |
| validationRules | form | List<ValidationRule> | No | |
| lookup | form | LookupGrid | No | |
| allowEditing | form | bool | No | |
| encodeHtml | form | bool | No | |
| editorOptions | form | Dictionary<string, Object> | No | |
| groupIndex | form | int? | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| type | form | string | No | |
| message | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| allowClearing | form | bool | No | |
| displayExpr | form | string | No | |
| valueExpr | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| allowAdding | form | bool | No | |
| allowDeleting | form | bool | No | |
| allowUpdating | form | bool | No | |
| mode | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| groupItems | form | List<gridSummaryGroupItems> | No | |
| totalItems | form | List<gridSummaryTotalItems> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| column | form | string | No | |
| displayFormat | form | string | No | |
| showInGroupFooter | form | bool | No | |
| summaryType | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| column | form | string | No | |
| displayFormat | form | string | No | |
| summaryType | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| CodigoBlob | form | decimal | No | |
| Nombre | form | string | No | |
| Descripcion | form | string | No | |
| SQL | form | string | No | |
| CodigoTabla | form | decimal | No | |
| GuardarBinario | form | string | No | |
| TipoConsulta | form | string | No | |
| ExportacionDefault | form | string | No | |
| TipoExportacion | form | string | No | |
| ParametrosExportacion | form | int | No | |
| CodigoAyuda | form | string | No | |
| EjecutarEnAdm | form | string | No | |
| InfoAdicional | form | string | No | |
| EjecMultiempresa | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Codigo | form | decimal | No | |
| Nombre | form | string | No | |
| CrearChart | form | string | No | |
| Configuration | form | string | No | |
| Chart | form | string | No | |
| Observaciones | form | string | No | |
| IDVista | form | decimal | No | |
| Usuario | form | string | No | |
| FechaCreacion | form | DateTime | No |
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/DefinicionGrupo HTTP/1.1
Host: soluser-recaudo.sgsas.co
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length
{
IDGrupo: 0,
Lenguaje: ES
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length
{
GrupoPivotGrid:
{
Codigo: 0,
Nombre: String,
Observaciones: String,
Usuario: String
},
Items:
[
{
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
}
]
}