Asientos contables y líneas por libro — Pro
Periodo y empresa; dossier del asiento, cuentas y libros, Debe/Haber, monedas separadas y marcaje a petición.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para contabilidad, administración y responsables de empresa: selecciona periodo contable y empresa; puedes filtrar diario y categoría. Consulta descripción, tipo y número del asiento, centro, fechas, ejercicio/periodo fiscal, referencia y documento origen. El sub-botón abre sus líneas por libro: cuenta y plan contable, tercero, centro de la línea, sentido Debe/Haber, importes y monedas separados, marcaje y cantidades no financieras. Las fichas agrupan el contexto completo, sin identificadores técnicos visibles.
¿Por qué Cifru? Adapta las configuraciones a tu forma de trabajar. Elige los campos, filtros y detalles que necesitas y lleva al móvil información que quizá no esté disponible en la aplicación móvil de tu software de gestión. Las opciones dependen de los datos accesibles en tu fuente autorizada y de tu plan Cifru.
Pro: una fuente SQL Server, dos listas y una relación a petición, con SELECT explícito. Periodo/empresa se eligen con los filtros nativos antes del límite de lectura; no se calcula un informe agregado. Las líneas se delimitan por tipo, número y empresa del asiento. Máximo 2.000 filas por lista, sin refresco programado. Reduce el periodo si alcanzas el límite; los filtros y el límite no garantizan una consulta barata ni resultados completos. Revisa índices, tiempos, permisos y la información de truncamiento de Cifru.
CONTEXTO CONTABLE: el número solo no identifica un asiento. La clave documental completa es TYP+NUM; la de línea es TYP+NUM+LIN+LEDTYP. Una misma línea puede existir en varios libros; se conserva cada ocurrencia y se muestra su tipo/libro, sin duplicarla por un join incompleto ni sumarla como si fueran operaciones diferentes. Estado provisional/definitivo (menú 617) no significa pendiente/pagado. Categorías (menú 618): real, simulación activa, simulación inactiva, fuera de balance y plantilla; no se presentan todas como movimientos reales. El código de cuenta se mantiene junto a su plan contable COA; no se inventa el nombre de cuenta ni se une solo por ACC. Ejercicio y periodo son códigos internos fiscales, no necesariamente un año calendario y un mes.
IMPORTES: AMTCUR se muestra con CUR y AMTLED con CURLED de la propia línea, no del primer libro de cabecera. SNS=+1 se muestra como Debe y SNS=-1 como Haber según la documentación Sage; otros códigos siguen visibles. Se conservan los importes nativos, incluidos negativos, ceros y valores ausentes: no ABS, conversiones, neteo ni totales entre libros/monedas. Marcaje MTC es un código y una fecha de emparejamiento contable, no conciliación bancaria CHK, ni un saldo pagado; SAC es el código de cuenta de control, no el tercero auxiliar. cantidad/unidad son no financieras, no stock físico. No es balance de sumas y saldos, informe de deuda, exportación FEC ni certificación fiscal/legal; no permite contabilizar, pagar ni modificar asientos.
REQUISITO: Sage X3 v12 SQL Server y acceso autorizado. El administrador confirma base/carpeta empresarial y prepara un usuario dedicado, esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. OBJECT_ID comprueba tablas frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no hay descubrimiento automático de objetos. Un test de estructura vacío no demuestra la carpeta correcta. Confirma esquema y una vista previa real al importar. Los filtros no son control de acceso; SQL no hereda automáticamente permisos de rol/centro de X3. El paquete no cambia usuarios, permisos, esquemas ni tablas.
Diccionario v12, claves únicas completas, menús y regla SQL oficial campo_indice: nombres documentados por esa regla, no DDL ni metadatos de una instalación. Requiere las funciones SQL usadas, incluida CONCAT; confirma versión y tipos. Capturas nativas Cifru con transporte sintético y datos DEMO ficticios: no validadas en Sage X3/SQL Server reales. No contiene servidor, credenciales ni filas empresariales. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCENTRY.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCENTRYD.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00617.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00618.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02644.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESGAS.htm
https://online-help.sagex3.com/erp/12/howtoguides/en-US/financials/DGI-IFRS%20Compliance/Content/How-to%20guides/Financials/DGI-IFRS%20Compliance/T10_Accounting%20entry%20file.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Asientos contables
- Details: Líneas por libro
- Sub-button: Líneas por libro
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(RTRIM(h.TYP_0)),N':',RTRIM(h.TYP_0),LEN(RTRIM(h.NUM_0)),N':',RTRIM(h.NUM_0)) AS EntryKey, RTRIM(h.TYP_0) AS TYP_0, RTRIM(h.NUM_0) AS NUM_0, h.DESVCR_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.FCY_0) AS FCY_0, RTRIM(h.JOU_0) AS JOU_0, h.ACCDAT_0, h.CUR_0, CASE WHEN h.STA_0=1 THEN N'Provisional' WHEN h.STA_0=2 THEN N'Definitivo' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, CASE WHEN h.CAT_0=1 THEN N'Real' WHEN h.CAT_0=2 THEN N'Simulación activa' WHEN h.CAT_0=3 THEN N'Simulación inactiva' WHEN h.CAT_0=4 THEN N'Fuera de balance' WHEN h.CAT_0=5 THEN N'Plantilla' WHEN h.CAT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CAT_0) END AS CAT_0, h.REF_0, h.BPRVCR_0, h.BPRDATVCR_0, h.ENTDAT_0, h.FIY_0, h.PER_0, h.ORICOD_0, h.VALDAT_0, h.VATDAT_0 FROM GACCENTRY h WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCENTRY',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRY',N'U') AND OBJECT_ID(N'GACCENTRYD',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRYD',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(RTRIM(l.TYP_0)),N':',RTRIM(l.TYP_0),LEN(RTRIM(l.NUM_0)),N':',RTRIM(l.NUM_0)),N':',l.LIN_0,N':',l.LEDTYP_0) AS LineKey, RTRIM(l.TYP_0) AS TYP_0, RTRIM(l.NUM_0) AS NUM_0, l.LIN_0, CASE WHEN l.LEDTYP_0=1 THEN N'Legal' WHEN l.LEDTYP_0=2 THEN N'Analítico' WHEN l.LEDTYP_0=3 THEN N'IAS' WHEN l.LEDTYP_0=4 THEN N'Libro mayor 4' WHEN l.LEDTYP_0=5 THEN N'Libro mayor 5' WHEN l.LEDTYP_0=6 THEN N'Libro mayor 6' WHEN l.LEDTYP_0=7 THEN N'Libro mayor 7' WHEN l.LEDTYP_0=8 THEN N'Libro mayor 8' WHEN l.LEDTYP_0=9 THEN N'Libro mayor 9' WHEN l.LEDTYP_0=10 THEN N'Libro mayor 10' WHEN l.LEDTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',l.LEDTYP_0) END AS LEDTYP_0, RTRIM(l.LED_0) AS LED_0, l.DES_0, RTRIM(l.CPY_0) AS CPY_0, RTRIM(l.FCYLIN_0) AS FCYLIN_0, RTRIM(l.COA_0) AS COA_0, RTRIM(l.ACC_0) AS ACC_0, RTRIM(l.BPR_0) AS BPR_0, l.ACCDAT_0, CASE WHEN l.SNS_0=1 THEN N'Debe' WHEN l.SNS_0=-1 THEN N'Haber' WHEN l.SNS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',l.SNS_0) END AS SNS_0, l.CUR_0, l.AMTCUR_0, l.CURLED_0, l.AMTLED_0, l.MTC_0, l.MTCDAT_0, l.QTY_0, l.UOM_0, l.SAC_0 FROM GACCENTRYD l JOIN GACCENTRY h ON h.TYP_0=l.TYP_0 AND h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.TYP_0=:entry_type AND h.NUM_0=:document AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCENTRY',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRY',N'U') AND OBJECT_ID(N'GACCENTRYD',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRYD',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage X3 — SQL Server, carpeta autorizada del usuario",
"id": "7A4A5E40-E93E-537C-8727-052E3879B733",
"kind": "sqlServer",
"requiredObjects": [
"GACCENTRY",
"GACCENTRYD"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "75CB272A-7DC6-5F90-8D6D-7BEE18C162B9",
"key": "ACCDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "AA7D4A2E-9784-5041-B511-39459D6DB356",
"key": "TYP_0",
"type": "text"
},
{
"direction": "ascending",
"id": "0D12EED2-00E8-5F16-87CE-A6B7F515FBD3",
"key": "NUM_0",
"type": "text"
}
],
"id": "B5C5E73C-9316-5124-8F2D-69238FB13AB3",
"mappings": [
{
"commonFieldKey": "",
"key": "EntryKey",
"label": "Clave interna completa del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TYP_0",
"label": "Tipo de asiento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DESVCR_0",
"label": "Descripción del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DESVCR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FCY_0",
"label": "Centro del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JOU_0",
"label": "Diario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JOU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STA_0",
"label": "Estado del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CAT_0",
"label": "Categoría del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CAT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REF_0",
"label": "Referencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRVCR_0",
"label": "Documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRVCR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRDATVCR_0",
"label": "Fecha del documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRDATVCR_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ENTDAT_0",
"label": "Fecha de entrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ENTDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FIY_0",
"label": "Ejercicio fiscal (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FIY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PER_0",
"label": "Periodo fiscal (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PER_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORICOD_0",
"label": "Transacción origen (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORICOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VALDAT_0",
"label": "Fecha valor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VALDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VATDAT_0",
"label": "Fecha fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VATDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Asientos contables",
"primaryKey": "EntryKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"TYP_0",
"NUM_0",
"DESVCR_0",
"CPY_0",
"FCY_0",
"JOU_0",
"ACCDAT_0",
"CUR_0",
"STA_0",
"CAT_0",
"REF_0",
"BPRVCR_0",
"BPRDATVCR_0",
"ENTDAT_0",
"FIY_0",
"PER_0",
"ORICOD_0",
"VALDAT_0",
"VATDAT_0"
],
"sourceID": "7A4A5E40-E93E-537C-8727-052E3879B733",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(h.TYP_0)),N':',RTRIM(h.TYP_0),LEN(RTRIM(h.NUM_0)),N':',RTRIM(h.NUM_0)) AS EntryKey, RTRIM(h.TYP_0) AS TYP_0, RTRIM(h.NUM_0) AS NUM_0, h.DESVCR_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.FCY_0) AS FCY_0, RTRIM(h.JOU_0) AS JOU_0, h.ACCDAT_0, h.CUR_0, CASE WHEN h.STA_0=1 THEN N'Provisional' WHEN h.STA_0=2 THEN N'Definitivo' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, CASE WHEN h.CAT_0=1 THEN N'Real' WHEN h.CAT_0=2 THEN N'Simulación activa' WHEN h.CAT_0=3 THEN N'Simulación inactiva' WHEN h.CAT_0=4 THEN N'Fuera de balance' WHEN h.CAT_0=5 THEN N'Plantilla' WHEN h.CAT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CAT_0) END AS CAT_0, h.REF_0, h.BPRVCR_0, h.BPRDATVCR_0, h.ENTDAT_0, h.FIY_0, h.PER_0, h.ORICOD_0, h.VALDAT_0, h.VATDAT_0 FROM GACCENTRY h WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCENTRY',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRY',N'U') AND OBJECT_ID(N'GACCENTRYD',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRYD',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "6D5998B1-9190-51EE-8FE4-26AD730D5452",
"key": "LIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "90AB959A-A74A-59FF-891C-D3AA71EC0C89",
"key": "LEDTYP_0",
"type": "text"
}
],
"id": "7EBECA65-99D4-56C0-855C-B43BC8598C42",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Clave interna completa de línea y libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TYP_0",
"label": "Tipo de asiento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LIN_0",
"label": "Clave interna de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LIN_0",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LEDTYP_0",
"label": "Tipo de libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LEDTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LED_0",
"label": "Libro contable (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LED_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_0",
"label": "Descripción de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FCYLIN_0",
"label": "Centro de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCYLIN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COA_0",
"label": "Plan contable (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "COA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACC_0",
"label": "Cuenta contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACC_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPR_0",
"label": "Tercero (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SNS_0",
"label": "Sentido contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SNS_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTCUR_0",
"label": "Importe en moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTCUR_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CURLED_0",
"label": "Moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CURLED_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTLED_0",
"label": "Importe en moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTLED_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MTC_0",
"label": "Marcaje (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MTC_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MTCDAT_0",
"label": "Fecha de marcaje",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MTCDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QTY_0",
"label": "Cantidad no financiera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UOM_0",
"label": "Unidad no financiera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UOM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAC_0",
"label": "Cuenta de control (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SAC_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Líneas por libro",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TYP_0",
"id": "AB96994C-78E2-5A54-8BCB-7C962705D53A",
"name": "entry_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NUM_0",
"id": "97E722EC-01BD-5E3C-B7D3-E93DB5BD846E",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "D68AE0F2-25C6-5322-85C4-B724F161CACC",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"TYP_0",
"NUM_0",
"LEDTYP_0",
"LED_0",
"DES_0",
"CPY_0",
"FCYLIN_0",
"COA_0",
"ACC_0",
"BPR_0",
"ACCDAT_0",
"SNS_0",
"CUR_0",
"AMTCUR_0",
"CURLED_0",
"AMTLED_0",
"MTC_0",
"MTCDAT_0",
"QTY_0",
"UOM_0",
"SAC_0"
],
"sourceID": "7A4A5E40-E93E-537C-8727-052E3879B733",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(RTRIM(l.TYP_0)),N':',RTRIM(l.TYP_0),LEN(RTRIM(l.NUM_0)),N':',RTRIM(l.NUM_0)),N':',l.LIN_0,N':',l.LEDTYP_0) AS LineKey, RTRIM(l.TYP_0) AS TYP_0, RTRIM(l.NUM_0) AS NUM_0, l.LIN_0, CASE WHEN l.LEDTYP_0=1 THEN N'Legal' WHEN l.LEDTYP_0=2 THEN N'Analítico' WHEN l.LEDTYP_0=3 THEN N'IAS' WHEN l.LEDTYP_0=4 THEN N'Libro mayor 4' WHEN l.LEDTYP_0=5 THEN N'Libro mayor 5' WHEN l.LEDTYP_0=6 THEN N'Libro mayor 6' WHEN l.LEDTYP_0=7 THEN N'Libro mayor 7' WHEN l.LEDTYP_0=8 THEN N'Libro mayor 8' WHEN l.LEDTYP_0=9 THEN N'Libro mayor 9' WHEN l.LEDTYP_0=10 THEN N'Libro mayor 10' WHEN l.LEDTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',l.LEDTYP_0) END AS LEDTYP_0, RTRIM(l.LED_0) AS LED_0, l.DES_0, RTRIM(l.CPY_0) AS CPY_0, RTRIM(l.FCYLIN_0) AS FCYLIN_0, RTRIM(l.COA_0) AS COA_0, RTRIM(l.ACC_0) AS ACC_0, RTRIM(l.BPR_0) AS BPR_0, l.ACCDAT_0, CASE WHEN l.SNS_0=1 THEN N'Debe' WHEN l.SNS_0=-1 THEN N'Haber' WHEN l.SNS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',l.SNS_0) END AS SNS_0, l.CUR_0, l.AMTCUR_0, l.CURLED_0, l.AMTLED_0, l.MTC_0, l.MTCDAT_0, l.QTY_0, l.UOM_0, l.SAC_0 FROM GACCENTRYD l JOIN GACCENTRY h ON h.TYP_0=l.TYP_0 AND h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.TYP_0=:entry_type AND h.NUM_0=:document AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCENTRY',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRY',N'U') AND OBJECT_ID(N'GACCENTRYD',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCENTRYD',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "572F86F8-7905-5FC4-8236-A8CD782BD49A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DB18FBEE-DF82-532B-BA3E-B6B47C8DACC3",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7EBECA65-99D4-56C0-855C-B43BC8598C42",
"title": "Líneas por libro",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TYP_0",
"label": "Tipo de asiento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JOU_0",
"label": "Diario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STA_0",
"label": "Estado del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CAT_0",
"label": "Categoría del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B5C5E73C-9316-5124-8F2D-69238FB13AB3",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "DESVCR_0",
"label": "Descripción del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "TYP_0",
"label": "Tipo de asiento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "FCY_0",
"label": "Centro del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "JOU_0",
"label": "Diario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "STA_0",
"label": "Estado del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento contable",
"detailRole": "information",
"isVisible": true,
"key": "CAT_0",
"label": "Categoría del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "ENTDAT_0",
"label": "Fecha de entrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "FIY_0",
"label": "Ejercicio fiscal (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "PER_0",
"label": "Periodo fiscal (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "VALDAT_0",
"label": "Fecha valor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y periodo",
"detailRole": "information",
"isVisible": true,
"key": "VATDAT_0",
"label": "Fecha fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Moneda y origen",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Moneda y origen",
"detailRole": "information",
"isVisible": true,
"key": "REF_0",
"label": "Referencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Moneda y origen",
"detailRole": "information",
"isVisible": true,
"key": "BPRVCR_0",
"label": "Documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Moneda y origen",
"detailRole": "information",
"isVisible": true,
"key": "BPRDATVCR_0",
"label": "Fecha del documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Moneda y origen",
"detailRole": "information",
"isVisible": true,
"key": "ORICOD_0",
"label": "Transacción origen (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5F4335A6-D91C-5ACD-B605-6D04781972A6",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "2CB0BD08-DC54-56DF-A434-CDCE51AE7E97",
"includeAllOption": false,
"key": "ACCDAT_0",
"title": "Periodo contable",
"type": "date"
},
{
"id": "41FD5B3B-9362-501B-96F5-252D4324538A",
"includeAllOption": false,
"key": "CPY_0",
"title": "Empresa",
"type": "text"
},
{
"id": "AADB45C8-44D2-5ED4-A04C-B28F5FDE2848",
"includeAllOption": true,
"key": "JOU_0",
"title": "Diario (código)",
"type": "text"
},
{
"id": "D78440A3-FD53-5D14-A7D0-F113B43BAC2F",
"includeAllOption": true,
"key": "CAT_0",
"title": "Categoría del asiento",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "75CB272A-7DC6-5F90-8D6D-7BEE18C162B9",
"key": "ACCDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "AA7D4A2E-9784-5041-B511-39459D6DB356",
"key": "TYP_0",
"type": "text"
},
{
"direction": "ascending",
"id": "0D12EED2-00E8-5F16-87CE-A6B7F515FBD3",
"key": "NUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "NUM_0",
"systemImage": "doc.text",
"title": "Asientos contables",
"titleKey": "DESVCR_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LEDTYP_0",
"label": "Tipo de libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SNS_0",
"label": "Sentido contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTCUR_0",
"label": "Importe en moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURLED_0",
"label": "Moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTLED_0",
"label": "Importe en moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "7EBECA65-99D4-56C0-855C-B43BC8598C42",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "DES_0",
"label": "Descripción de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "ACC_0",
"label": "Cuenta contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "COA_0",
"label": "Plan contable (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "BPR_0",
"label": "Tercero (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "SAC_0",
"label": "Cuenta de control (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cuenta y contexto",
"detailRole": "information",
"isVisible": true,
"key": "FCYLIN_0",
"label": "Centro de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y libro",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y libro",
"detailRole": "information",
"isVisible": true,
"key": "TYP_0",
"label": "Tipo de asiento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y libro",
"detailRole": "information",
"isVisible": true,
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y libro",
"detailRole": "information",
"isVisible": true,
"key": "LEDTYP_0",
"label": "Tipo de libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y libro",
"detailRole": "information",
"isVisible": true,
"key": "LED_0",
"label": "Libro contable (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sentido y monedas",
"detailRole": "information",
"isVisible": true,
"key": "SNS_0",
"label": "Sentido contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sentido y monedas",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sentido y monedas",
"detailRole": "information",
"isVisible": true,
"key": "AMTCUR_0",
"label": "Importe en moneda del asiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sentido y monedas",
"detailRole": "information",
"isVisible": true,
"key": "CURLED_0",
"label": "Moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sentido y monedas",
"detailRole": "information",
"isVisible": true,
"key": "AMTLED_0",
"label": "Importe en moneda del libro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Marcaje y cantidad",
"detailRole": "information",
"isVisible": true,
"key": "MTC_0",
"label": "Marcaje (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Marcaje y cantidad",
"detailRole": "information",
"isVisible": true,
"key": "MTCDAT_0",
"label": "Fecha de marcaje",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Marcaje y cantidad",
"detailRole": "information",
"isVisible": true,
"key": "QTY_0",
"label": "Cantidad no financiera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Marcaje y cantidad",
"detailRole": "information",
"isVisible": true,
"key": "UOM_0",
"label": "Unidad no financiera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6C429343-D2F6-5466-9C93-6C8FAE6CE7F5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6D5998B1-9190-51EE-8FE4-26AD730D5452",
"key": "LIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "90AB959A-A74A-59FF-891C-D3AA71EC0C89",
"key": "LEDTYP_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ACC_0",
"systemImage": "list.bullet",
"title": "Líneas por libro",
"titleKey": "DES_0"
}
],
"relations": [
{
"childDatasetID": "7EBECA65-99D4-56C0-855C-B43BC8598C42",
"childKey": "NUM_0",
"id": "DB18FBEE-DF82-532B-BA3E-B6B47C8DACC3",
"name": "Líneas por libro",
"parentDatasetID": "B5C5E73C-9316-5124-8F2D-69238FB13AB3",
"parentKey": "NUM_0"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage X3",
"configurationLanguages": [
"es"
],
"countries": [
"ES"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.\n\nPara contabilidad, administración y responsables de empresa: selecciona periodo contable y empresa; puedes filtrar diario y categoría. Consulta descripción, tipo y número del asiento, centro, fechas, ejercicio/periodo fiscal, referencia y documento origen. El sub-botón abre sus líneas por libro: cuenta y plan contable, tercero, centro de la línea, sentido Debe/Haber, importes y monedas separados, marcaje y cantidades no financieras. Las fichas agrupan el contexto completo, sin identificadores técnicos visibles.\n\n¿Por qué Cifru? Adapta las configuraciones a tu forma de trabajar. Elige los campos, filtros y detalles que necesitas y lleva al móvil información que quizá no esté disponible en la aplicación móvil de tu software de gestión. Las opciones dependen de los datos accesibles en tu fuente autorizada y de tu plan Cifru.\n\nPro: una fuente SQL Server, dos listas y una relación a petición, con SELECT explícito. Periodo/empresa se eligen con los filtros nativos antes del límite de lectura; no se calcula un informe agregado. Las líneas se delimitan por tipo, número y empresa del asiento. Máximo 2.000 filas por lista, sin refresco programado. Reduce el periodo si alcanzas el límite; los filtros y el límite no garantizan una consulta barata ni resultados completos. Revisa índices, tiempos, permisos y la información de truncamiento de Cifru.\n\nCONTEXTO CONTABLE: el número solo no identifica un asiento. La clave documental completa es TYP+NUM; la de línea es TYP+NUM+LIN+LEDTYP. Una misma línea puede existir en varios libros; se conserva cada ocurrencia y se muestra su tipo/libro, sin duplicarla por un join incompleto ni sumarla como si fueran operaciones diferentes. Estado provisional/definitivo (menú 617) no significa pendiente/pagado. Categorías (menú 618): real, simulación activa, simulación inactiva, fuera de balance y plantilla; no se presentan todas como movimientos reales. El código de cuenta se mantiene junto a su plan contable COA; no se inventa el nombre de cuenta ni se une solo por ACC. Ejercicio y periodo son códigos internos fiscales, no necesariamente un año calendario y un mes.\n\nIMPORTES: AMTCUR se muestra con CUR y AMTLED con CURLED de la propia línea, no del primer libro de cabecera. SNS=+1 se muestra como Debe y SNS=-1 como Haber según la documentación Sage; otros códigos siguen visibles. Se conservan los importes nativos, incluidos negativos, ceros y valores ausentes: no ABS, conversiones, neteo ni totales entre libros/monedas. Marcaje MTC es un código y una fecha de emparejamiento contable, no conciliación bancaria CHK, ni un saldo pagado; SAC es el código de cuenta de control, no el tercero auxiliar. cantidad/unidad son no financieras, no stock físico. No es balance de sumas y saldos, informe de deuda, exportación FEC ni certificación fiscal/legal; no permite contabilizar, pagar ni modificar asientos.\n\nREQUISITO: Sage X3 v12 SQL Server y acceso autorizado. El administrador confirma base/carpeta empresarial y prepara un usuario dedicado, esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. OBJECT_ID comprueba tablas frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no hay descubrimiento automático de objetos. Un test de estructura vacío no demuestra la carpeta correcta. Confirma esquema y una vista previa real al importar. Los filtros no son control de acceso; SQL no hereda automáticamente permisos de rol/centro de X3. El paquete no cambia usuarios, permisos, esquemas ni tablas.\n\nDiccionario v12, claves únicas completas, menús y regla SQL oficial campo_indice: nombres documentados por esa regla, no DDL ni metadatos de una instalación. Requiere las funciones SQL usadas, incluida CONCAT; confirma versión y tipos. Capturas nativas Cifru con transporte sintético y datos DEMO ficticios: no validadas en Sage X3/SQL Server reales. No contiene servidor, credenciales ni filas empresariales. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCENTRY.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCENTRYD.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00617.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00618.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02644.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESGAS.htm\nhttps://online-help.sagex3.com/erp/12/howtoguides/en-US/financials/DGI-IFRS%20Compliance/Content/How-to%20guides/Financials/DGI-IFRS%20Compliance/T10_Accounting%20entry%20file.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4C3020B3-DDA5-5FF4-9215-A9D6F1D22133",
"rootButtonCount": 1,
"summary": "Periodo y empresa; dossier del asiento, cuentas y libros, Debe/Haber, monedas separadas y marcaje a petición.",
"tags": [
"Sage X3",
"SQL Server",
"Asientos",
"Contabilidad",
"Libro mayor",
"Finanzas",
"Pro"
],
"title": "Asientos contables y líneas por libro — Pro"
}
}