Vencimientos, cobros y pagos con documento y libros — Pro
Periodo y empresa; importes nativos, pagos provisionales, anticipos, terceros y reclamación; asiento y líneas a petición, sin saldos supuestos.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para tesorería, contabilidad, administración y responsables: selecciona periodo de vencimiento y empresa. Consulta facturas, pedidos, pagos u otros orígenes, con tipo vencimiento/anticipo/retención, tercero facturado y pagador/beneficiario distintos. Cada ficha muestra importes originales, pagos contabilizados y provisionales separados, forma/fecha de pago, anticipos, autorización nativa, litigio, reclamaciones y extracto. Documento y Líneas por libro abren a petición el asiento y sus cuentas, centros, monedas, Debe/Haber y marcaje. Los identificadores internos de línea y vencimiento quedan ocultos.
¿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, tres listas, dos sub-botones independientes y SELECT explícitos. Una factura con varias líneas/tramos conserva cada vencimiento: clave TYP+NUM+LIG+DUDLIG. Tipo+número+empresa delimitan ambos sub-botones, incluso si existen números iguales en tipos distintos. Líneas por libro muestra el documento completo, no presupone que LIG sea LIN y no inventa una relación con pagos. Un pedido, anticipo o documento no contabilizado puede no tener asiento; una lista vacía no prueba un error.
ALCANCE FINANCIERO: registro actual de la cohorte de fechas seleccionada, no balance histórico, aging, saldo pendiente calculado, lista exclusivamente abierta ni propuesta de pagos. Incluye tipos y estados nativos; no etiqueta automáticamente cada fila como deuda pendiente o pagada. AMTCUR, PAYCUR y TMPCUR se muestran por separado con CUR propio; no se restan anticipos dos veces, no ABS, FX, neteo ni totales entre monedas. DINAMT e IBDAMT son valores nativos distintos: valida su contexto en X3, no equivalen a un nuevo saldo. No se muestran importes en moneda de referencia ni se adivina esa moneda. PAYDAT es la fecha nativa, no un historial de todos los cobros. DUDSTA=2 indica origen contabilizado; otros códigos no se inventan. SNS del vencimiento y FLGCLE no se decodifican con reglas de otros módulos o de HISTODUD. FLGPAZ aparece como nivel numérico nativo: su menú es parametrizable en cada instalación, por lo que el 4 no se proclama automáticamente autorizado. Confirma su significado con el administrador.
El documento y las líneas mantienen categoría real/simulación/fuera de balance/plantilla y estado provisional/definitivo, no pendiente/pagado. SNS=+1/-1 se traduce Debe/Haber SOLO en líneas contables según su documentación; importes nativos preservados. Una línea puede aparecer en varios libros: clave TYP+NUM+LIN+LEDTYP, moneda del asiento CUR y moneda del libro CURLED separadas; no se suman. Cuenta junto a plan COA; no se inventa nombre de cuenta. Marcaje no es conciliación bancaria. Nombres de terceros, empresa y centro son actuales, no una foto histórica.
PRECISIÓN: importes y cantidades se presentan como texto exacto de origen para evitar el redondeo de Cifru 1.1; estos filtros/ordenaciones locales son de texto, no numéricos. Las fechas y niveles se tipan según su significado. Filtros nativos al abrir antes del límite; 2.000 filas por lista, sin refresco programado. Acota el periodo al llegar al límite. Los filtros/límites no garantizan consulta rápida ni resultados completos: revisa índices, truncamiento, permisos y tiempos en la instalación.
REQUISITO: Sage X3 v12 SQL Server, acceso autorizado y carpeta empresarial confirmada por el administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta y solo SELECT autorizado; no dbo/SEED supuestos ni sa/sysadmin. Guards OBJECT_ID verifican todas las tablas contra ese esquema y rechazan dbo/guest/sys/INFORMATION_SCHEMA, sin descubrimiento automático. La selección de empresa no es ACL y SQL no hereda permisos de roles/centros X3. Un test vacío no confirma carpeta correcta: verifica esquema, tipos, configuración local y lectura real al importar. No cambia tablas, permisos ni el ERP; no permite pagar.
Diccionarios v12, claves completas y regla oficial campo_indice; no DDL ni metadatos instalados. Capturas nativas con transporte sintético y datos DEMO totalmente ficticios, no una instalación X3/SQL Server real. Sin credenciales, servidor ni filas empresariales. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCDUDATE.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPARTNER.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/COMPANY.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/FACILITY.htm
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/FCT/MODECHE2.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/FUNPNS.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESGAS.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/MODECHE.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/CONSBAG.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00001.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00292.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00510.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00644.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02614.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/CONSBAH.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/RECHDU.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/HISTODUD.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Vencimientos, cobros y pagos
- Details: Documento contable
- Details: Líneas por libro
- Sub-button: Documento contable
- Sub-button: Líneas por libro
Sources are mapped locally and verified before applying.
Custom queriesPRO3 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(CONCAT(LEN(RTRIM(d.TYP_0)),N':',RTRIM(d.TYP_0),LEN(RTRIM(d.NUM_0)),N':',RTRIM(d.NUM_0)),N':',d.LIG_0,N':',d.DUDLIG_0) AS DueKey, d.LIG_0, d.DUDLIG_0, RTRIM(d.NUM_0) AS NUM_0, RTRIM(d.TYP_0) AS TYP_0, CASE WHEN d.TYPDUD_0=1 THEN N'Pedido' WHEN d.TYPDUD_0=2 THEN N'Factura' WHEN d.TYPDUD_0=3 THEN N'Pago' WHEN d.TYPDUD_0=4 THEN N'Otros' WHEN d.TYPDUD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.TYPDUD_0) END AS TYPDUD_0, CASE WHEN d.PAMTYP_0=1 THEN N'Vencimiento' WHEN d.PAMTYP_0=2 THEN N'Anticipo' WHEN d.PAMTYP_0=3 THEN N'Retención' WHEN d.PAMTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.PAMTYP_0) END AS PAMTYP_0, CASE WHEN d.BPRTYP_0=1 THEN N'Cliente' WHEN d.BPRTYP_0=2 THEN N'Proveedor' WHEN d.BPRTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.BPRTYP_0) END AS BPRTYP_0, RTRIM(d.BPR_0) AS BPR_0, RTRIM(d.BPRPAY_0) AS BPRPAY_0, RTRIM(d.CPY_0) AS CPY_0, RTRIM(d.FCY_0) AS FCY_0, d.DUDDAT_0, RTRIM(d.CUR_0) AS CUR_0, d.AMTCUR_0, d.PAYCUR_0, d.TMPCUR_0, d.PAYDAT_0, CASE WHEN d.DUDSTA_0=2 THEN N'Origen contabilizado' WHEN d.DUDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.DUDSTA_0) END AS DUDSTA_0, RTRIM(d.PAM_0) AS PAM_0, d.DINAMT_0, d.IBDAMT_0, RTRIM(d.DEP_0) AS DEP_0, d.FLGPAZ_0, RTRIM(d.DPTCOD_0) AS DPTCOD_0, CASE WHEN d.FLGFUP_0=1 THEN N'No' WHEN d.FLGFUP_0=2 THEN N'Sí' WHEN d.FLGFUP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.FLGFUP_0) END AS FLGFUP_0, d.LEVFUP_0, d.DATFUP_0, CASE WHEN d.SOI_0=1 THEN N'No' WHEN d.SOI_0=2 THEN N'Sí' WHEN d.SOI_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.SOI_0) END AS SOI_0, RTRIM(d.SOINUM_0) AS SOINUM_0, d.EXPSENDAT_0, d.SENDAT_0, CASE WHEN d.SENINS_0=1 THEN N'No' WHEN d.SENINS_0=2 THEN N'Sí' WHEN d.SENINS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.SENINS_0) END AS SENINS_0, RTRIM(d.SAC_0) AS SAC_0, RTRIM(d.VAT_0) AS VAT_0, RTRIM(b.BPRNAM_0) AS BilledName, RTRIM(b.BPRNAM_1) AS BilledName2, RTRIM(p.BPRNAM_0) AS PayName, RTRIM(p.BPRNAM_1) AS PayName2, RTRIM(c.CPYNAM_0) AS CompanyName, RTRIM(f.FCYNAM_0) AS SiteName FROM GACCDUDATE d LEFT JOIN BPARTNER b ON b.BPRNUM_0=d.BPR_0 LEFT JOIN BPARTNER p ON p.BPRNUM_0=d.BPRPAY_0 LEFT JOIN COMPANY c ON c.CPY_0=d.CPY_0 LEFT JOIN FACILITY f ON f.FCY_0=d.FCY_0 AND f.LEGCPY_0=d.CPY_0 WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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(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 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'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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.2.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'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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": "1AF5A04D-FC61-58F8-98FA-DFDDF496DE2D",
"kind": "sqlServer",
"requiredObjects": [
"GACCDUDATE",
"BPARTNER",
"COMPANY",
"FACILITY",
"GACCENTRY",
"GACCENTRYD"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "39ABF8CC-59B4-52BA-8FB3-DA7E9DB75BD1",
"key": "DUDDAT_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"
},
{
"direction": "ascending",
"id": "565AB7DC-4603-5F1B-8814-8E11FBE39CFD",
"key": "LIG_0",
"type": "number"
},
{
"direction": "ascending",
"id": "60F9160D-0CD8-53F2-B645-9149059F74C1",
"key": "DUDLIG_0",
"type": "number"
}
],
"id": "A2C10E7D-CE86-5FE8-9F8C-4914137D71EB",
"mappings": [
{
"commonFieldKey": "",
"key": "DueKey",
"label": "Clave interna completa del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LIG_0",
"label": "Clave interna de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LIG_0",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUDLIG_0",
"label": "Clave interna de vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUDLIG_0",
"type": "number",
"visibleInDetail": false,
"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": "TYP_0",
"label": "Tipo de documento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TYPDUD_0",
"label": "Origen del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TYPDUD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PAMTYP_0",
"label": "Tipo de pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PAMTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPRTYP_0",
"label": "Cliente / proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPR_0",
"label": "Tercero facturado / pedido (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledName",
"label": "Tercero facturado / pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BilledName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledName2",
"label": "Tercero, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BilledName2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRPAY_0",
"label": "Pagador / beneficiario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRPAY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayName",
"label": "Pagador / beneficiario",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayName2",
"label": "Pagador, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayName2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FCY_0",
"label": "Centro (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SiteName",
"label": "Centro actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SiteName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUDDAT_0",
"label": "Fecha de vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUDDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTCUR_0",
"label": "Importe original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTCUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PAYCUR_0",
"label": "Pago contabilizado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PAYCUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TMPCUR_0",
"label": "Pago provisional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TMPCUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PAYDAT_0",
"label": "Fecha de pago nativa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PAYDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUDSTA_0",
"label": "Contabilización del origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUDSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PAM_0",
"label": "Forma de pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DINAMT_0",
"label": "Anticipo deducido, valor nativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DINAMT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IBDAMT_0",
"label": "Anticipo por deducir, valor nativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IBDAMT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEP_0",
"label": "Descuento / recargo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FLGPAZ_0",
"label": "Nivel autorización de pago (X3)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FLGPAZ_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DPTCOD_0",
"label": "Litigio (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DPTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FLGFUP_0",
"label": "Reclamación activada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FLGFUP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LEVFUP_0",
"label": "Nivel de reclamación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LEVFUP_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DATFUP_0",
"label": "Fecha de reclamación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DATFUP_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOI_0",
"label": "Incluido en extracto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOI_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOINUM_0",
"label": "Número de extracto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOINUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXPSENDAT_0",
"label": "Emisión prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXPSENDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SENDAT_0",
"label": "Fecha de emisión",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SENDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SENINS_0",
"label": "Anticipo emitido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SENINS_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
},
{
"commonFieldKey": "",
"key": "VAT_0",
"label": "Impuesto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VAT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Vencimientos, cobros y pagos",
"primaryKey": "DueKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"NUM_0",
"TYP_0",
"TYPDUD_0",
"PAMTYP_0",
"BPRTYP_0",
"BPR_0",
"BilledName",
"BilledName2",
"BPRPAY_0",
"PayName",
"PayName2",
"CPY_0",
"CompanyName",
"FCY_0",
"SiteName",
"DUDDAT_0",
"CUR_0",
"AMTCUR_0",
"PAYCUR_0",
"TMPCUR_0",
"PAYDAT_0",
"DUDSTA_0",
"PAM_0",
"DINAMT_0",
"IBDAMT_0",
"DEP_0",
"FLGPAZ_0",
"DPTCOD_0",
"FLGFUP_0",
"LEVFUP_0",
"DATFUP_0",
"SOI_0",
"SOINUM_0",
"EXPSENDAT_0",
"SENDAT_0",
"SENINS_0",
"SAC_0",
"VAT_0"
],
"sourceID": "1AF5A04D-FC61-58F8-98FA-DFDDF496DE2D",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(RTRIM(d.TYP_0)),N':',RTRIM(d.TYP_0),LEN(RTRIM(d.NUM_0)),N':',RTRIM(d.NUM_0)),N':',d.LIG_0,N':',d.DUDLIG_0) AS DueKey, d.LIG_0, d.DUDLIG_0, RTRIM(d.NUM_0) AS NUM_0, RTRIM(d.TYP_0) AS TYP_0, CASE WHEN d.TYPDUD_0=1 THEN N'Pedido' WHEN d.TYPDUD_0=2 THEN N'Factura' WHEN d.TYPDUD_0=3 THEN N'Pago' WHEN d.TYPDUD_0=4 THEN N'Otros' WHEN d.TYPDUD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.TYPDUD_0) END AS TYPDUD_0, CASE WHEN d.PAMTYP_0=1 THEN N'Vencimiento' WHEN d.PAMTYP_0=2 THEN N'Anticipo' WHEN d.PAMTYP_0=3 THEN N'Retención' WHEN d.PAMTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.PAMTYP_0) END AS PAMTYP_0, CASE WHEN d.BPRTYP_0=1 THEN N'Cliente' WHEN d.BPRTYP_0=2 THEN N'Proveedor' WHEN d.BPRTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.BPRTYP_0) END AS BPRTYP_0, RTRIM(d.BPR_0) AS BPR_0, RTRIM(d.BPRPAY_0) AS BPRPAY_0, RTRIM(d.CPY_0) AS CPY_0, RTRIM(d.FCY_0) AS FCY_0, d.DUDDAT_0, RTRIM(d.CUR_0) AS CUR_0, d.AMTCUR_0, d.PAYCUR_0, d.TMPCUR_0, d.PAYDAT_0, CASE WHEN d.DUDSTA_0=2 THEN N'Origen contabilizado' WHEN d.DUDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.DUDSTA_0) END AS DUDSTA_0, RTRIM(d.PAM_0) AS PAM_0, d.DINAMT_0, d.IBDAMT_0, RTRIM(d.DEP_0) AS DEP_0, d.FLGPAZ_0, RTRIM(d.DPTCOD_0) AS DPTCOD_0, CASE WHEN d.FLGFUP_0=1 THEN N'No' WHEN d.FLGFUP_0=2 THEN N'Sí' WHEN d.FLGFUP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.FLGFUP_0) END AS FLGFUP_0, d.LEVFUP_0, d.DATFUP_0, CASE WHEN d.SOI_0=1 THEN N'No' WHEN d.SOI_0=2 THEN N'Sí' WHEN d.SOI_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.SOI_0) END AS SOI_0, RTRIM(d.SOINUM_0) AS SOINUM_0, d.EXPSENDAT_0, d.SENDAT_0, CASE WHEN d.SENINS_0=1 THEN N'No' WHEN d.SENINS_0=2 THEN N'Sí' WHEN d.SENINS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',d.SENINS_0) END AS SENINS_0, RTRIM(d.SAC_0) AS SAC_0, RTRIM(d.VAT_0) AS VAT_0, RTRIM(b.BPRNAM_0) AS BilledName, RTRIM(b.BPRNAM_1) AS BilledName2, RTRIM(p.BPRNAM_0) AS PayName, RTRIM(p.BPRNAM_1) AS PayName2, RTRIM(c.CPYNAM_0) AS CompanyName, RTRIM(f.FCYNAM_0) AS SiteName FROM GACCDUDATE d LEFT JOIN BPARTNER b ON b.BPRNUM_0=d.BPR_0 LEFT JOIN BPARTNER p ON p.BPRNUM_0=d.BPRPAY_0 LEFT JOIN COMPANY c ON c.CPY_0=d.CPY_0 LEFT JOIN FACILITY f ON f.FCY_0=d.FCY_0 AND f.LEGCPY_0=d.CPY_0 WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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": "AA7D4A2E-9784-5041-B511-39459D6DB356",
"key": "TYP_0",
"type": "text"
},
{
"direction": "ascending",
"id": "0D12EED2-00E8-5F16-87CE-A6B7F515FBD3",
"key": "NUM_0",
"type": "text"
}
],
"id": "0EA77B9F-6454-547E-A889-4CE7A6429BF5",
"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": "Documento contable",
"primaryKey": "EntryKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TYP_0",
"id": "EA7D2155-6A45-5D88-9112-0B9E20A0ABE1",
"name": "entry_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NUM_0",
"id": "7D0DAE4F-E24D-581E-BD10-0286FD6118B7",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "7885D6B4-4DD5-58F0-9756-A50BDB2B3E8A",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"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": "1AF5A04D-FC61-58F8-98FA-DFDDF496DE2D",
"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 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'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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": "C04B747F-23AF-5A1F-86FE-B689A84BFFDC",
"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": "text",
"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": "text",
"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": "text",
"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": "EA7D2155-6A45-5D88-9112-0B9E20A0ABE1",
"name": "entry_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NUM_0",
"id": "7D0DAE4F-E24D-581E-BD10-0286FD6118B7",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "7885D6B4-4DD5-58F0-9756-A50BDB2B3E8A",
"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": "1AF5A04D-FC61-58F8-98FA-DFDDF496DE2D",
"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'GACCDUDATE',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GACCDUDATE',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') 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": "49DD72D3-C856-5536-B193-7B472D07C5A2",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A2091148-1383-5A2B-BA16-DBAB69902499",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "0EA77B9F-6454-547E-A889-4CE7A6429BF5",
"title": "Documento",
"urlKey": ""
},
{
"id": "2737264B-BFCA-5C1B-B496-CBEC9F7C30CD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "57EA2E91-57C5-55CB-B169-3B0BC3C4C486",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C04B747F-23AF-5A1F-86FE-B689A84BFFDC",
"title": "Líneas por libro",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TYPDUD_0",
"label": "Origen del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PAMTYP_0",
"label": "Tipo de pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DUDDAT_0",
"label": "Fecha de vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTCUR_0",
"label": "Importe original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PAYCUR_0",
"label": "Pago contabilizado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TMPCUR_0",
"label": "Pago provisional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayName",
"label": "Pagador / beneficiario",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A2C10E7D-CE86-5FE8-9F8C-4914137D71EB",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "TYP_0",
"label": "Tipo de documento (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "TYPDUD_0",
"label": "Origen del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "PAMTYP_0",
"label": "Tipo de pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "BPRTYP_0",
"label": "Cliente / proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "BilledName",
"label": "Tercero facturado / pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "BilledName2",
"label": "Tercero, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "BPR_0",
"label": "Tercero facturado / pedido (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "PayName",
"label": "Pagador / beneficiario",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "PayName2",
"label": "Pagador, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Operación y terceros",
"detailRole": "information",
"isVisible": true,
"key": "BPRPAY_0",
"label": "Pagador / beneficiario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "SiteName",
"label": "Centro actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "FCY_0",
"label": "Centro (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "DUDDAT_0",
"label": "Fecha de vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "DUDSTA_0",
"label": "Contabilización del origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "SAC_0",
"label": "Cuenta de control (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centro y vencimiento",
"detailRole": "information",
"isVisible": true,
"key": "VAT_0",
"label": "Impuesto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del vencimiento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "AMTCUR_0",
"label": "Importe original",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "PAYCUR_0",
"label": "Pago contabilizado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "TMPCUR_0",
"label": "Pago provisional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "PAYDAT_0",
"label": "Fecha de pago nativa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos, no saldo calculado",
"detailRole": "information",
"isVisible": true,
"key": "PAM_0",
"label": "Forma de pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Anticipos y autorización nativa",
"detailRole": "information",
"isVisible": true,
"key": "DINAMT_0",
"label": "Anticipo deducido, valor nativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Anticipos y autorización nativa",
"detailRole": "information",
"isVisible": true,
"key": "IBDAMT_0",
"label": "Anticipo por deducir, valor nativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Anticipos y autorización nativa",
"detailRole": "information",
"isVisible": true,
"key": "DEP_0",
"label": "Descuento / recargo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Anticipos y autorización nativa",
"detailRole": "information",
"isVisible": true,
"key": "FLGPAZ_0",
"label": "Nivel autorización de pago (X3)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Anticipos y autorización nativa",
"detailRole": "information",
"isVisible": true,
"key": "DPTCOD_0",
"label": "Litigio (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reclamación y extracto",
"detailRole": "information",
"isVisible": true,
"key": "FLGFUP_0",
"label": "Reclamación activada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reclamación y extracto",
"detailRole": "information",
"isVisible": true,
"key": "LEVFUP_0",
"label": "Nivel de reclamación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reclamación y extracto",
"detailRole": "information",
"isVisible": true,
"key": "DATFUP_0",
"label": "Fecha de reclamación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reclamación y extracto",
"detailRole": "information",
"isVisible": true,
"key": "SOI_0",
"label": "Incluido en extracto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reclamación y extracto",
"detailRole": "information",
"isVisible": true,
"key": "SOINUM_0",
"label": "Número de extracto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Emisión del anticipo",
"detailRole": "information",
"isVisible": true,
"key": "EXPSENDAT_0",
"label": "Emisión prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Emisión del anticipo",
"detailRole": "information",
"isVisible": true,
"key": "SENDAT_0",
"label": "Fecha de emisión",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Emisión del anticipo",
"detailRole": "information",
"isVisible": true,
"key": "SENINS_0",
"label": "Anticipo emitido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "364DB511-CD05-5AE9-94A2-9B39C8480A87",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "B93075F4-89ED-5B89-89FD-32309FA3A104",
"includeAllOption": false,
"key": "DUDDAT_0",
"title": "Periodo de vencimiento",
"type": "date"
},
{
"id": "41FD5B3B-9362-501B-96F5-252D4324538A",
"includeAllOption": false,
"key": "CPY_0",
"title": "Empresa",
"type": "text"
},
{
"id": "D660C479-B13C-5666-9AE9-E0D08D6E0D9C",
"includeAllOption": true,
"key": "BPRTYP_0",
"title": "Cliente / proveedor",
"type": "text"
},
{
"id": "E5698E88-A744-5BE9-8F8A-5C09FCD97F14",
"includeAllOption": true,
"key": "TYPDUD_0",
"title": "Origen del vencimiento",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "39ABF8CC-59B4-52BA-8FB3-DA7E9DB75BD1",
"key": "DUDDAT_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"
},
{
"direction": "ascending",
"id": "565AB7DC-4603-5F1B-8814-8E11FBE39CFD",
"key": "LIG_0",
"type": "number"
},
{
"direction": "ascending",
"id": "60F9160D-0CD8-53F2-B645-9149059F74C1",
"key": "DUDLIG_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "NUM_0",
"systemImage": "calendar",
"title": "Vencimientos, cobros y pagos",
"titleKey": "BilledName"
},
{
"actions": [],
"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": "0EA77B9F-6454-547E-A889-4CE7A6429BF5",
"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": "0D61CCF0-6E0B-5AEB-B017-127721C3E8C9",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"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": "Documento contable",
"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": "C04B747F-23AF-5A1F-86FE-B689A84BFFDC",
"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": "82590558-D617-52E6-ACAC-3C40C0330A3C",
"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": "doc.text",
"title": "Líneas por libro",
"titleKey": "DES_0"
}
],
"relations": [
{
"childDatasetID": "0EA77B9F-6454-547E-A889-4CE7A6429BF5",
"childKey": "NUM_0",
"id": "A2091148-1383-5A2B-BA16-DBAB69902499",
"name": "Documento contable",
"parentDatasetID": "A2C10E7D-CE86-5FE8-9F8C-4914137D71EB",
"parentKey": "NUM_0"
},
{
"childDatasetID": "C04B747F-23AF-5A1F-86FE-B689A84BFFDC",
"childKey": "NUM_0",
"id": "57EA2E91-57C5-55CB-B169-3B0BC3C4C486",
"name": "Líneas por libro",
"parentDatasetID": "A2C10E7D-CE86-5FE8-9F8C-4914137D71EB",
"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 tesorería, contabilidad, administración y responsables: selecciona periodo de vencimiento y empresa. Consulta facturas, pedidos, pagos u otros orígenes, con tipo vencimiento/anticipo/retención, tercero facturado y pagador/beneficiario distintos. Cada ficha muestra importes originales, pagos contabilizados y provisionales separados, forma/fecha de pago, anticipos, autorización nativa, litigio, reclamaciones y extracto. Documento y Líneas por libro abren a petición el asiento y sus cuentas, centros, monedas, Debe/Haber y marcaje. Los identificadores internos de línea y vencimiento quedan ocultos.\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, tres listas, dos sub-botones independientes y SELECT explícitos. Una factura con varias líneas/tramos conserva cada vencimiento: clave TYP+NUM+LIG+DUDLIG. Tipo+número+empresa delimitan ambos sub-botones, incluso si existen números iguales en tipos distintos. Líneas por libro muestra el documento completo, no presupone que LIG sea LIN y no inventa una relación con pagos. Un pedido, anticipo o documento no contabilizado puede no tener asiento; una lista vacía no prueba un error.\n\nALCANCE FINANCIERO: registro actual de la cohorte de fechas seleccionada, no balance histórico, aging, saldo pendiente calculado, lista exclusivamente abierta ni propuesta de pagos. Incluye tipos y estados nativos; no etiqueta automáticamente cada fila como deuda pendiente o pagada. AMTCUR, PAYCUR y TMPCUR se muestran por separado con CUR propio; no se restan anticipos dos veces, no ABS, FX, neteo ni totales entre monedas. DINAMT e IBDAMT son valores nativos distintos: valida su contexto en X3, no equivalen a un nuevo saldo. No se muestran importes en moneda de referencia ni se adivina esa moneda. PAYDAT es la fecha nativa, no un historial de todos los cobros. DUDSTA=2 indica origen contabilizado; otros códigos no se inventan. SNS del vencimiento y FLGCLE no se decodifican con reglas de otros módulos o de HISTODUD. FLGPAZ aparece como nivel numérico nativo: su menú es parametrizable en cada instalación, por lo que el 4 no se proclama automáticamente autorizado. Confirma su significado con el administrador.\n\nEl documento y las líneas mantienen categoría real/simulación/fuera de balance/plantilla y estado provisional/definitivo, no pendiente/pagado. SNS=+1/-1 se traduce Debe/Haber SOLO en líneas contables según su documentación; importes nativos preservados. Una línea puede aparecer en varios libros: clave TYP+NUM+LIN+LEDTYP, moneda del asiento CUR y moneda del libro CURLED separadas; no se suman. Cuenta junto a plan COA; no se inventa nombre de cuenta. Marcaje no es conciliación bancaria. Nombres de terceros, empresa y centro son actuales, no una foto histórica.\n\nPRECISIÓN: importes y cantidades se presentan como texto exacto de origen para evitar el redondeo de Cifru 1.1; estos filtros/ordenaciones locales son de texto, no numéricos. Las fechas y niveles se tipan según su significado. Filtros nativos al abrir antes del límite; 2.000 filas por lista, sin refresco programado. Acota el periodo al llegar al límite. Los filtros/límites no garantizan consulta rápida ni resultados completos: revisa índices, truncamiento, permisos y tiempos en la instalación.\n\nREQUISITO: Sage X3 v12 SQL Server, acceso autorizado y carpeta empresarial confirmada por el administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta y solo SELECT autorizado; no dbo/SEED supuestos ni sa/sysadmin. Guards OBJECT_ID verifican todas las tablas contra ese esquema y rechazan dbo/guest/sys/INFORMATION_SCHEMA, sin descubrimiento automático. La selección de empresa no es ACL y SQL no hereda permisos de roles/centros X3. Un test vacío no confirma carpeta correcta: verifica esquema, tipos, configuración local y lectura real al importar. No cambia tablas, permisos ni el ERP; no permite pagar.\n\nDiccionarios v12, claves completas y regla oficial campo_indice; no DDL ni metadatos instalados. Capturas nativas con transporte sintético y datos DEMO totalmente ficticios, no una instalación X3/SQL Server real. Sin credenciales, servidor ni filas empresariales. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/GACCDUDATE.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPARTNER.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/COMPANY.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/FACILITY.htm\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/FCT/MODECHE2.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/FUNPNS.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESGAS.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/MODECHE.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/CONSBAG.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00001.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00292.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00510.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00644.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02614.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/CONSBAH.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/RECHDU.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/HISTODUD.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "0D5B16DD-632F-5B7D-AF94-04974E01388F",
"rootButtonCount": 1,
"summary": "Periodo y empresa; importes nativos, pagos provisionales, anticipos, terceros y reclamación; asiento y líneas a petición, sin saldos supuestos.",
"tags": [
"Sage X3",
"SQL Server",
"Vencimientos",
"Tesorería",
"Cobros",
"Pagos",
"Contabilidad",
"Pro"
],
"title": "Vencimientos, cobros y pagos con documento y libros — Pro"
}
}