Terceros y direcciones — Pro
Ficha comercial, funciones de cliente/proveedor y direcciones completas bajo demanda.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL. Para ventas, compras, atención al cliente y administración: selecciona país y estado, busca un tercero y consulta su ficha agrupada. Incluye las dos líneas de razón social, contacto, preferencias y funciones como cliente, proveedor, transportista o representante. Abre sus direcciones solo cuando las necesites: ubicación completa, cinco teléfonos, móvil, fax, cinco correos y web. Un mismo tercero puede tener varias funciones.
¿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, dos listas y un sub-botón; SQL de solo lectura con selección explícita de 17 campos de tercero y 26 de dirección, más una clave oculta. Cada lista tiene un límite de 2.000 filas y no se actualiza de forma programada. Las direcciones se limitan al tercero seleccionado y al tipo 1 (tercero), sin confundir entidades de empresa, centro o usuario. Los límites pueden producir resultados incompletos; un filtro no garantiza una consulta barata. La ficha no contiene pedidos, facturas, saldos, cuentas bancarias, identificadores fiscales ni datos técnicos de auditoría.
IMPORTANTE: solo para la edición SQL Server de Sage X3 v12 con acceso autorizado. El administrador debe confirmar la base y la carpeta empresarial, y preparar un usuario SQL dedicado con esquema predeterminado igual a esa carpeta y SELECT únicamente sobre los datos autorizados. No uses sa, sysadmin ni un usuario con acceso general. No se presupone dbo, SEED ni el nombre de tu carpeta. Las consultas se ejecutan como SQL Pro, no mediante la selección automática de objetos. Las comprobaciones OBJECT_ID comparan cada tabla resuelta con la tabla del esquema predeterminado; si falta o se resolvería en dbo, no se devuelven filas. dbo, guest, sys e INFORMATION_SCHEMA se rechazan. Una comprobación de estructura vacía puede aprobar el formato sin demostrar que la carpeta sea correcta: confirma el esquema con el administrador y comprueba una vista previa real antes de utilizarlo. El resultado vacío también puede indicar falta de permisos o una carpeta incorrecta; no se debe interpretar como ausencia de terceros. Las restricciones de usuario, centro y rol de X3 no se heredan automáticamente por SQL; los filtros Cifru no son control de acceso. Este paquete no cambia usuarios, permisos, tablas ni esquemas.
Documentado con el diccionario público v12 y la regla física de nombres de Sage: campo_indice, desde 0 hasta dimensión-1. Se conservan ambas líneas del nombre, las tres líneas de dirección y los cinco teléfonos/correos. No se deducen tipos SQL físicos ni columnas opcionales. Los menús documentan 1=No, 2=Sí, no 0/1; códigos no reconocidos se muestran como Código N. La moneda, idioma y código contable son preferencias, no moneda de una factura, saldo ni cuenta bancaria. Se conserva el código comercial y los ceros iniciales; la clave oculta incluye tipo, tercero y dirección.
No se ha probado una instalación Sage X3 ni SQL Server real; la versión instalada, los permisos, los tipos, el rendimiento y la compatibilidad deben verificarse. Ejecuta la comprobación de lectura y compatibilidad al importar. Las capturas Cifru usan transporte sintético y datos DEMO totalmente ficticios, no una conexión ERP real. El paquete no incluye servidor, usuario, contraseña ni filas de negocio. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPARTNER.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPADDRESS.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/MEN00943.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESBPR.htm
https://online-help.sagex3.com/erp/12/en-us/Content/V7DEV/prerequisites_windows-sql-server.html
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/ownership-and-user-schema-separation?view=sql-server-ver17
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Terceros
- Details: Direcciones del tercero
- Sub-button: Direcciones
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 RTRIM(m.BPRNUM_0) AS BPRNUM_0, m.BPRNAM_0, m.BPRNAM_1, m.BPRSHO_0, m.CNTNAM_0, m.CRY_0, m.CUR_0, m.LAN_0, RTRIM(m.BPAADD_0) AS BPAADD_0, m.ACCCOD_0, CASE WHEN m.ENAFLG_0=1 THEN N'No' WHEN m.ENAFLG_0=2 THEN N'Sí' WHEN m.ENAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.ENAFLG_0) END AS ENAFLG_0, CASE WHEN m.BPCFLG_0=1 THEN N'No' WHEN m.BPCFLG_0=2 THEN N'Sí' WHEN m.BPCFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPCFLG_0) END AS BPCFLG_0, CASE WHEN m.BPSFLG_0=1 THEN N'No' WHEN m.BPSFLG_0=2 THEN N'Sí' WHEN m.BPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPSFLG_0) END AS BPSFLG_0, CASE WHEN m.PPTFLG_0=1 THEN N'No' WHEN m.PPTFLG_0=2 THEN N'Sí' WHEN m.PPTFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.PPTFLG_0) END AS PPTFLG_0, CASE WHEN m.BPTFLG_0=1 THEN N'No' WHEN m.BPTFLG_0=2 THEN N'Sí' WHEN m.BPTFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPTFLG_0) END AS BPTFLG_0, CASE WHEN m.REPFLG_0=1 THEN N'No' WHEN m.REPFLG_0=2 THEN N'Sí' WHEN m.REPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.REPFLG_0) END AS REPFLG_0, CASE WHEN m.PRVFLG_0=1 THEN N'No' WHEN m.PRVFLG_0=2 THEN N'Sí' WHEN m.PRVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.PRVFLG_0) END AS PRVFLG_0 FROM BPARTNER m WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'BPARTNER',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'BPADDRESS',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPADDRESS',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(a.BPATYP_0,N':',LEN(RTRIM(a.BPANUM_0)),N':',RTRIM(a.BPANUM_0),RTRIM(a.BPAADD_0)) AS AddressKey, a.BPATYP_0, RTRIM(a.BPANUM_0) AS BPANUM_0, RTRIM(a.BPAADD_0) AS BPAADD_0, a.BPADES_0, CASE WHEN a.BPAADDFLG_0=1 THEN N'No' WHEN a.BPAADDFLG_0=2 THEN N'Sí' WHEN a.BPAADDFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',a.BPAADDFLG_0) END AS BPAADDFLG_0, a.BPAADDLIG_0, a.BPAADDLIG_1, a.BPAADDLIG_2, a.CRY_0, a.CRYNAM_0, a.CTY_0, a.POSCOD_0, a.SAT_0, a.TEL_0, a.TEL_1, a.TEL_2, a.TEL_3, a.TEL_4, a.WEB_0, a.WEB_1, a.WEB_2, a.WEB_3, a.WEB_4, a.MOB_0, a.FAX_0, a.FCYWEB_0 FROM BPADDRESS a WHERE a.BPATYP_0=1 AND a.BPANUM_0=:partner AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'BPARTNER',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'BPADDRESS',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPADDRESS',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": "D7FAECFE-59C3-59BE-AB43-64B06F62C067",
"kind": "sqlServer",
"requiredObjects": [
"BPARTNER",
"BPADDRESS"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A51025B0-983D-5AB9-833E-CBE8D645BA61",
"key": "BPRNAM_0",
"type": "text"
},
{
"direction": "ascending",
"id": "6A2016CF-B737-512A-A1BB-A038DF98C054",
"key": "BPRNUM_0",
"type": "text"
}
],
"id": "CD05A293-E3C1-5310-8E7D-4CAFC8F2EA31",
"mappings": [
{
"commonFieldKey": "",
"key": "BPRNUM_0",
"label": "Código de tercero",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPRNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRNAM_0",
"label": "Razón social",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPRNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRNAM_1",
"label": "Razón social (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPRNAM_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRSHO_0",
"label": "Nombre corto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPRSHO_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CNTNAM_0",
"label": "Contacto predeterminado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CNTNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CRY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LAN_0",
"label": "Idioma",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LAN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPAADD_0",
"label": "Código de dirección predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCCOD_0",
"label": "Código contable predeterminado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACCCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ENAFLG_0",
"label": "Activo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ENAFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPCFLG_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPCFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPSFLG_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPSFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PPTFLG_0",
"label": "Cliente potencial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PPTFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPTFLG_0",
"label": "Transportista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPTFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REPFLG_0",
"label": "Representante",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REPFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRVFLG_0",
"label": "Proveedor de servicios",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRVFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Ficha de terceros",
"primaryKey": "BPRNUM_0",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"BPRNUM_0",
"BPRNAM_0",
"BPRNAM_1",
"BPRSHO_0",
"CNTNAM_0",
"CRY_0",
"CUR_0",
"LAN_0",
"BPAADD_0",
"ACCCOD_0",
"ENAFLG_0",
"BPCFLG_0",
"BPSFLG_0",
"PPTFLG_0",
"BPTFLG_0",
"REPFLG_0",
"PRVFLG_0"
],
"sourceID": "D7FAECFE-59C3-59BE-AB43-64B06F62C067",
"sqlQuery": "SELECT RTRIM(m.BPRNUM_0) AS BPRNUM_0, m.BPRNAM_0, m.BPRNAM_1, m.BPRSHO_0, m.CNTNAM_0, m.CRY_0, m.CUR_0, m.LAN_0, RTRIM(m.BPAADD_0) AS BPAADD_0, m.ACCCOD_0, CASE WHEN m.ENAFLG_0=1 THEN N'No' WHEN m.ENAFLG_0=2 THEN N'Sí' WHEN m.ENAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.ENAFLG_0) END AS ENAFLG_0, CASE WHEN m.BPCFLG_0=1 THEN N'No' WHEN m.BPCFLG_0=2 THEN N'Sí' WHEN m.BPCFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPCFLG_0) END AS BPCFLG_0, CASE WHEN m.BPSFLG_0=1 THEN N'No' WHEN m.BPSFLG_0=2 THEN N'Sí' WHEN m.BPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPSFLG_0) END AS BPSFLG_0, CASE WHEN m.PPTFLG_0=1 THEN N'No' WHEN m.PPTFLG_0=2 THEN N'Sí' WHEN m.PPTFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.PPTFLG_0) END AS PPTFLG_0, CASE WHEN m.BPTFLG_0=1 THEN N'No' WHEN m.BPTFLG_0=2 THEN N'Sí' WHEN m.BPTFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.BPTFLG_0) END AS BPTFLG_0, CASE WHEN m.REPFLG_0=1 THEN N'No' WHEN m.REPFLG_0=2 THEN N'Sí' WHEN m.REPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.REPFLG_0) END AS REPFLG_0, CASE WHEN m.PRVFLG_0=1 THEN N'No' WHEN m.PRVFLG_0=2 THEN N'Sí' WHEN m.PRVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',m.PRVFLG_0) END AS PRVFLG_0 FROM BPARTNER m WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'BPARTNER',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'BPADDRESS',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPADDRESS',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4C18E801-BE26-5076-9019-0E86BD708D9D",
"key": "BPAADD_0",
"type": "text"
}
],
"id": "9ECB58FC-3482-5161-A16A-E458E842BA86",
"mappings": [
{
"commonFieldKey": "",
"key": "AddressKey",
"label": "Clave interna completa de dirección",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPATYP_0",
"label": "Tipo de entidad interno",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPATYP_0",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPANUM_0",
"label": "Código de tercero",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPANUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPAADD_0",
"label": "Código de dirección",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPADES_0",
"label": "Descripción de dirección",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPADES_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPAADDFLG_0",
"label": "Dirección predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADDFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPAADDLIG_0",
"label": "Dirección, línea 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADDLIG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPAADDLIG_1",
"label": "Dirección, línea 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADDLIG_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPAADDLIG_2",
"label": "Dirección, línea 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BPAADDLIG_2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CRY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CRYNAM_0",
"label": "Nombre del país",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CRYNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CTY_0",
"label": "Ciudad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CTY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "POSCOD_0",
"label": "Código postal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POSCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAT_0",
"label": "Provincia / región",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SAT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEL_0",
"label": "Teléfono 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TEL_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TEL_1",
"label": "Teléfono 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TEL_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEL_2",
"label": "Teléfono 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TEL_2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEL_3",
"label": "Teléfono 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TEL_3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEL_4",
"label": "Teléfono 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TEL_4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEB_0",
"label": "Correo electrónico 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEB_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WEB_1",
"label": "Correo electrónico 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEB_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEB_2",
"label": "Correo electrónico 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEB_2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEB_3",
"label": "Correo electrónico 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEB_3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEB_4",
"label": "Correo electrónico 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEB_4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MOB_0",
"label": "Teléfono móvil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MOB_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAX_0",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAX_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FCYWEB_0",
"label": "Sitio web",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FCYWEB_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Direcciones del tercero",
"primaryKey": "AddressKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BPRNUM_0",
"id": "5A89D525-0F3A-5CCB-A18A-2994AB5BA89C",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"BPANUM_0",
"BPAADD_0",
"BPADES_0",
"BPAADDFLG_0",
"BPAADDLIG_0",
"BPAADDLIG_1",
"BPAADDLIG_2",
"CRY_0",
"CRYNAM_0",
"CTY_0",
"POSCOD_0",
"SAT_0",
"TEL_0",
"TEL_1",
"TEL_2",
"TEL_3",
"TEL_4",
"WEB_0",
"WEB_1",
"WEB_2",
"WEB_3",
"WEB_4",
"MOB_0",
"FAX_0",
"FCYWEB_0"
],
"sourceID": "D7FAECFE-59C3-59BE-AB43-64B06F62C067",
"sqlQuery": "SELECT CONCAT(a.BPATYP_0,N':',LEN(RTRIM(a.BPANUM_0)),N':',RTRIM(a.BPANUM_0),RTRIM(a.BPAADD_0)) AS AddressKey, a.BPATYP_0, RTRIM(a.BPANUM_0) AS BPANUM_0, RTRIM(a.BPAADD_0) AS BPAADD_0, a.BPADES_0, CASE WHEN a.BPAADDFLG_0=1 THEN N'No' WHEN a.BPAADDFLG_0=2 THEN N'Sí' WHEN a.BPAADDFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',a.BPAADDFLG_0) END AS BPAADDFLG_0, a.BPAADDLIG_0, a.BPAADDLIG_1, a.BPAADDLIG_2, a.CRY_0, a.CRYNAM_0, a.CTY_0, a.POSCOD_0, a.SAT_0, a.TEL_0, a.TEL_1, a.TEL_2, a.TEL_3, a.TEL_4, a.WEB_0, a.WEB_1, a.WEB_2, a.WEB_3, a.WEB_4, a.MOB_0, a.FAX_0, a.FCYWEB_0 FROM BPADDRESS a WHERE a.BPATYP_0=1 AND a.BPANUM_0=:partner AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'BPARTNER',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'BPADDRESS',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPADDRESS',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "FBCF84A7-1235-5E40-BA2E-89EE027CB43D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "71F30C9E-9152-5A59-9577-F6B15005C3DA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9ECB58FC-3482-5161-A16A-E458E842BA86",
"title": "Direcciones del tercero",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CNTNAM_0",
"label": "Contacto predeterminado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ENAFLG_0",
"label": "Activo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BPCFLG_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BPSFLG_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "CD05A293-E3C1-5310-8E7D-4CAFC8F2EA31",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identidad",
"detailRole": "information",
"isVisible": true,
"key": "BPRNUM_0",
"label": "Código de tercero",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_0",
"label": "Razón social",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_1",
"label": "Razón social (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad",
"detailRole": "information",
"isVisible": true,
"key": "BPRSHO_0",
"label": "Nombre corto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "CNTNAM_0",
"label": "Contacto predeterminado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "BPAADD_0",
"label": "Código de dirección predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "LAN_0",
"label": "Idioma",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contacto y preferencias",
"detailRole": "information",
"isVisible": true,
"key": "ACCCOD_0",
"label": "Código contable predeterminado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "ENAFLG_0",
"label": "Activo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "BPCFLG_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "BPSFLG_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "PPTFLG_0",
"label": "Cliente potencial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "BPTFLG_0",
"label": "Transportista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "REPFLG_0",
"label": "Representante",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Estado y funciones comerciales",
"detailRole": "information",
"isVisible": true,
"key": "PRVFLG_0",
"label": "Proveedor de servicios",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "31F2086F-F2B0-52A5-9C99-ED0C2962B973",
"openFilters": [
{
"id": "5331615F-E58C-50F2-AFFB-E7A831FD6BE5",
"includeAllOption": true,
"key": "CRY_0",
"title": "País",
"type": "text"
},
{
"id": "1F6C1CB5-A820-5592-8B71-C06DEC38491B",
"includeAllOption": true,
"key": "ENAFLG_0",
"title": "Activo",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "A51025B0-983D-5AB9-833E-CBE8D645BA61",
"key": "BPRNAM_0",
"type": "text"
},
{
"direction": "ascending",
"id": "6A2016CF-B737-512A-A1BB-A038DF98C054",
"key": "BPRNUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "BPRNUM_0",
"systemImage": "person.2",
"title": "Terceros",
"titleKey": "BPRNAM_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CTY_0",
"label": "Ciudad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEL_0",
"label": "Teléfono 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WEB_0",
"label": "Correo electrónico 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDFLG_0",
"label": "Dirección predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDLIG_0",
"label": "Dirección, línea 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "9ECB58FC-3482-5161-A16A-E458E842BA86",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identidad de la dirección",
"detailRole": "information",
"isVisible": true,
"key": "BPAADD_0",
"label": "Código de dirección",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad de la dirección",
"detailRole": "information",
"isVisible": true,
"key": "BPANUM_0",
"label": "Código de tercero",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad de la dirección",
"detailRole": "information",
"isVisible": true,
"key": "BPADES_0",
"label": "Descripción de dirección",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identidad de la dirección",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDFLG_0",
"label": "Dirección predeterminada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDLIG_0",
"label": "Dirección, línea 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDLIG_1",
"label": "Dirección, línea 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "BPAADDLIG_2",
"label": "Dirección, línea 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "CTY_0",
"label": "Ciudad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "SAT_0",
"label": "Provincia / región",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "POSCOD_0",
"label": "Código postal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "CRY_0",
"label": "País",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ubicación",
"detailRole": "information",
"isVisible": true,
"key": "CRYNAM_0",
"label": "Nombre del país",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "TEL_0",
"label": "Teléfono 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "TEL_1",
"label": "Teléfono 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "TEL_2",
"label": "Teléfono 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "TEL_3",
"label": "Teléfono 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "TEL_4",
"label": "Teléfono 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "MOB_0",
"label": "Teléfono móvil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teléfonos",
"detailRole": "information",
"isVisible": true,
"key": "FAX_0",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "WEB_0",
"label": "Correo electrónico 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "WEB_1",
"label": "Correo electrónico 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "WEB_2",
"label": "Correo electrónico 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "WEB_3",
"label": "Correo electrónico 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "WEB_4",
"label": "Correo electrónico 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Correo y web",
"detailRole": "information",
"isVisible": true,
"key": "FCYWEB_0",
"label": "Sitio web",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6AB068C6-3088-5E48-A6A2-ECDD53BB719A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "4C18E801-BE26-5076-9019-0E86BD708D9D",
"key": "BPAADD_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "BPAADD_0",
"systemImage": "map",
"title": "Direcciones",
"titleKey": "BPADES_0"
}
],
"relations": [
{
"childDatasetID": "9ECB58FC-3482-5161-A16A-E458E842BA86",
"childKey": "BPANUM_0",
"id": "71F30C9E-9152-5A59-9577-F6B15005C3DA",
"name": "Direcciones del tercero",
"parentDatasetID": "CD05A293-E3C1-5310-8E7D-4CAFC8F2EA31",
"parentKey": "BPRNUM_0"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage X3",
"configurationLanguages": [
"es"
],
"countries": [
"ES"
],
"createdAt": "2026-10-07T00:00:00Z",
"description": "NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL. Para ventas, compras, atención al cliente y administración: selecciona país y estado, busca un tercero y consulta su ficha agrupada. Incluye las dos líneas de razón social, contacto, preferencias y funciones como cliente, proveedor, transportista o representante. Abre sus direcciones solo cuando las necesites: ubicación completa, cinco teléfonos, móvil, fax, cinco correos y web. Un mismo tercero puede tener varias funciones.\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, dos listas y un sub-botón; SQL de solo lectura con selección explícita de 17 campos de tercero y 26 de dirección, más una clave oculta. Cada lista tiene un límite de 2.000 filas y no se actualiza de forma programada. Las direcciones se limitan al tercero seleccionado y al tipo 1 (tercero), sin confundir entidades de empresa, centro o usuario. Los límites pueden producir resultados incompletos; un filtro no garantiza una consulta barata. La ficha no contiene pedidos, facturas, saldos, cuentas bancarias, identificadores fiscales ni datos técnicos de auditoría.\n\nIMPORTANTE: solo para la edición SQL Server de Sage X3 v12 con acceso autorizado. El administrador debe confirmar la base y la carpeta empresarial, y preparar un usuario SQL dedicado con esquema predeterminado igual a esa carpeta y SELECT únicamente sobre los datos autorizados. No uses sa, sysadmin ni un usuario con acceso general. No se presupone dbo, SEED ni el nombre de tu carpeta. Las consultas se ejecutan como SQL Pro, no mediante la selección automática de objetos. Las comprobaciones OBJECT_ID comparan cada tabla resuelta con la tabla del esquema predeterminado; si falta o se resolvería en dbo, no se devuelven filas. dbo, guest, sys e INFORMATION_SCHEMA se rechazan. Una comprobación de estructura vacía puede aprobar el formato sin demostrar que la carpeta sea correcta: confirma el esquema con el administrador y comprueba una vista previa real antes de utilizarlo. El resultado vacío también puede indicar falta de permisos o una carpeta incorrecta; no se debe interpretar como ausencia de terceros. Las restricciones de usuario, centro y rol de X3 no se heredan automáticamente por SQL; los filtros Cifru no son control de acceso. Este paquete no cambia usuarios, permisos, tablas ni esquemas.\n\nDocumentado con el diccionario público v12 y la regla física de nombres de Sage: campo_indice, desde 0 hasta dimensión-1. Se conservan ambas líneas del nombre, las tres líneas de dirección y los cinco teléfonos/correos. No se deducen tipos SQL físicos ni columnas opcionales. Los menús documentan 1=No, 2=Sí, no 0/1; códigos no reconocidos se muestran como Código N. La moneda, idioma y código contable son preferencias, no moneda de una factura, saldo ni cuenta bancaria. Se conserva el código comercial y los ceros iniciales; la clave oculta incluye tipo, tercero y dirección.\n\nNo se ha probado una instalación Sage X3 ni SQL Server real; la versión instalada, los permisos, los tipos, el rendimiento y la compatibilidad deben verificarse. Ejecuta la comprobación de lectura y compatibilidad al importar. Las capturas Cifru usan transporte sintético y datos DEMO totalmente ficticios, no una conexión ERP real. El paquete no incluye servidor, usuario, contraseña ni filas de negocio. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPARTNER.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/BPADDRESS.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/MEN00943.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESBPR.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/V7DEV/prerequisites_windows-sql-server.html\nhttps://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/ownership-and-user-schema-separation?view=sql-server-ver17",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "3ECC3A1C-D05F-524F-B1B9-5492A618586F",
"rootButtonCount": 1,
"summary": "Ficha comercial, funciones de cliente/proveedor y direcciones completas bajo demanda.",
"tags": [
"Sage X3",
"SQL Server",
"Clientes",
"Proveedores",
"Direcciones",
"Ventas",
"Compras",
"Pro"
],
"title": "Terceros y direcciones — Pro"
}
}