Catálogo de productos, proveedores y centros — Pro
Categoría y estado; ficha completa, unidades, compras/costes, proveedores y planificación por centro a petición.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para compras, ventas, almacén y dirección: elige categoría y, opcionalmente, estado. Consulta descripciones, UPC/EAN y GTIN, unidades y factores, peso/volumen, flujos de compra/venta/fabricación, lotes, series y caducidad configurada. La ficha muestra precio base de compra, costes nativos y responsables. Dos sub-botones a petición abren proveedores (referencias, prioridad, control, compra mínima, unidades, calidad y costes) y parámetros por centro (empresa actual, stock de seguridad, umbrales, lotes, plazos, horizontes, inventario y calidad).
¿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 relaciones independientes y SELECT explícito. Modo live, sin refrescos programados; hasta 2.000 filas/lista. Categoría/estado nativos antes del límite, hijos delimitados por producto con parámetros bound. Verifica índices, volumen y tiempos; el límite no garantiza rapidez ni resultados completos. No se cambia el plan de paquetes existentes.
PRECISIÓN: precios unitarios, costes fijos, cantidades de umbral, dimensiones y coeficientes se presentan como texto de origen para no perder decimales por el formato numérico de dos cifras de Cifru 1.1. Conservan el punto decimal de origen, sin conversión o redondeo de presentación; filtros locales automáticos de esos campos son de texto, no cálculos monetarios.
DATOS ACTUALES: maestro, proveedor-producto y producto-centro no son históricos. Precio base de compra por PUU del maestro; CPRAMT fijo por PUU del registro correspondiente, CPRCOE y estructuras nativos, sin coste real, precio efectivo por proveedor o conversiones calculadas. Las unidades y factores son actuales, no unidades históricas de pedidos/facturas. Stock de seguridad/umbral/máximo/lotes configurados se contextualizan en STU actual; no existencias, disponible, pedido sugerido ni cálculo MRP. Centro no equivale a depósito. DAYCOV son semanas; PRPLTI días laborables; horizontes y recontrol conservan sus unidades.
MONEDA POR VERIFICAR: importes maestros y CPRAMT de proveedor están almacenados en moneda del dossier, no en la moneda convertida que presenta la interfaz según perfil del usuario. SYSCUR es el parámetro documentado de carpeta. Su lectura candidata de ADOVAL con CMP/FCY vacíos es una inferencia de implementación del nivel sin código, no prueba del almacenamiento instalado. El código está SIEMPRE marcado para validar con el administrador; verifica valor, codificación y nivel antes de interpretar importes. Ausencia/ambigüedad deja moneda no confirmada; nunca se usa moneda de empresa/proveedor ni EUR por defecto. La consulta solo solicita SYSCUR, no otros parámetros. Sin conversión FX, suma entre monedas o valoración contable.
PROVEEDORES Y CALIDAD: prioridad cero es máxima; flags por defecto/contramarca se muestran como almacenados, no se recomputa o recomienda proveedor. DOUFLG conserva menú 516 No/Aviso/Bloqueante. Un párrafo funcional inglés/francés invierte el comportamiento de Aviso/Bloqueante: no se deduce elegibilidad a partir de él. Compra mínima en PUU específica; factor compra/stock y embalaje/compra separados. Calidad, grado, frecuencia y regla de conciliación nativos, no aprobación de factura o solvencia inferidas. Códigos desconocidos, signos, cero y ausencias conservados.
IDENTIDAD: ITMREF; producto+proveedor; producto+centro. Dos listas independientes sin join que multiplique proveedores por centros. Nombres actuales de BPARTNER/FACILITY por sus claves únicas; un maestro ausente no elimina la relación. Solo claves técnicas compuestas ocultas; códigos comerciales útiles visibles. No se inventan BASPRI/MINPRI/THEPRI, PHYSTO, ITMFACILIT.ITMSTA/STU ni dimensiones de campos opcionales NUC/STI/ANA/ECC/DEB/WRH/PJM a partir de nombres de pantalla.
REQUISITO: Sage X3 v12 SQL Server, carpeta y permisos confirmados por administrador. Usuario SELECT dedicado con esquema predeterminado de la carpeta, sin sa/sysadmin. Guard OBJECT_ID para los seis objetos, sin resolución dbo/guest/sys/INFORMATION_SCHEMA. SQL directo no hereda roles/centros X3; filtros no son ACL. Autoriza solo información pertinente, incluida lectura del parámetro monetario. Verifica versión, tablas/tipos, monedas, permisos y vista previa real; prueba vacía no certifica compatibilidad. Diccionario público/regla campo_indice no son DDL ni esquema instalado. No se escribe, crean objetos o cambian permisos en el ERP.
Capturas nativas Cifru con transporte sintético y datos DEMO íntegramente ficticios. Máximo ocho imágenes representativas, no todas las continuaciones; no se eliminan campos útiles para la galería. Sin servidor, credenciales ni datos reales. No validado en X3/SQL Server real, no oficial ni afiliado a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMMASTER.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMBPS.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMFACILIT.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESITM.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESITF.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/BPARTNER.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/ADOVAL.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESADS.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/ADPVAL.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESADP.htm
https://online-help.sagex3.com/erp/12/fr-fr/Content/FCT/GESITM.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/MEN00210.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00211.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00212.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00215.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00216.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00217.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00246.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00250.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00275.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00291.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00297.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00516.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00727.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02759.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02711.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Catálogo de productos
- Details: Proveedores del producto
- Details: Parámetros por centro
- Sub-button: Proveedores del producto
- Sub-button: Parámetros por centro
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 RTRIM(p.ITMREF_0) AS ITMREF_0, RTRIM(p.ITMDES1_0) AS ITMDES1_0, RTRIM(p.ITMDES2_0) AS ITMDES2_0, RTRIM(p.ITMDES3_0) AS ITMDES3_0, RTRIM(p.TCLCOD_0) AS TCLCOD_0, CASE WHEN p.ITMSTA_0=1 THEN N'Activo' WHEN p.ITMSTA_0=2 THEN N'En desarrollo' WHEN p.ITMSTA_0=3 THEN N'En escasez' WHEN p.ITMSTA_0=4 THEN N'No renovado' WHEN p.ITMSTA_0=5 THEN N'Obsoleto' WHEN p.ITMSTA_0=6 THEN N'No utilizable' WHEN p.ITMSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.ITMSTA_0) END AS ITMSTA_0, RTRIM(p.CPY_0) AS CPY_0, RTRIM(p.EANCOD_0) AS EANCOD_0, RTRIM(p.GTIN_0) AS GTIN_0, RTRIM(p.STU_0) AS STU_0, RTRIM(p.PUU_0) AS PUU_0, RTRIM(p.SAU_0) AS SAU_0, p.PUUSTUCOE_0, p.SAUSTUCOE_0, p.ITMWEI_0, RTRIM(p.WEU_0) AS WEU_0, p.ITMVOU_0, RTRIM(p.VOU_0) AS VOU_0, CASE WHEN p.SALFLG_0=1 THEN N'No' WHEN p.SALFLG_0=2 THEN N'Sí' WHEN p.SALFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SALFLG_0) END AS SALFLG_0, CASE WHEN p.PURFLG_0=1 THEN N'No' WHEN p.PURFLG_0=2 THEN N'Sí' WHEN p.PURFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.PURFLG_0) END AS PURFLG_0, CASE WHEN p.DLVFLG_0=1 THEN N'No' WHEN p.DLVFLG_0=2 THEN N'Sí' WHEN p.DLVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.DLVFLG_0) END AS DLVFLG_0, CASE WHEN p.MFGFLG_0=1 THEN N'No' WHEN p.MFGFLG_0=2 THEN N'Sí' WHEN p.MFGFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.MFGFLG_0) END AS MFGFLG_0, CASE WHEN p.SCPFLG_0=1 THEN N'No' WHEN p.SCPFLG_0=2 THEN N'Sí' WHEN p.SCPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SCPFLG_0) END AS SCPFLG_0, CASE WHEN p.SCSFLG_0=1 THEN N'No' WHEN p.SCSFLG_0=2 THEN N'Sí' WHEN p.SCSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SCSFLG_0) END AS SCSFLG_0, CASE WHEN p.NEGSTO_0=1 THEN N'No' WHEN p.NEGSTO_0=2 THEN N'Sí' WHEN p.NEGSTO_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.NEGSTO_0) END AS NEGSTO_0, CASE WHEN p.STOMGTCOD_0=1 THEN N'No gestionado' WHEN p.STOMGTCOD_0=2 THEN N'Gestionado' WHEN p.STOMGTCOD_0=3 THEN N'Potencia gestionada' WHEN p.STOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.STOMGTCOD_0) END AS STOMGTCOD_0, CASE WHEN p.STDFLG_0=1 THEN N'No gestionado' WHEN p.STDFLG_0=2 THEN N'Por proyecto' WHEN p.STDFLG_0=3 THEN N'Stock disponible' WHEN p.STDFLG_0=4 THEN N'Por pedido' WHEN p.STDFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.STDFLG_0) END AS STDFLG_0, CASE WHEN p.LOTMGTCOD_0=1 THEN N'No gestionados' WHEN p.LOTMGTCOD_0=2 THEN N'Lote opcional' WHEN p.LOTMGTCOD_0=3 THEN N'Lote obligatorio' WHEN p.LOTMGTCOD_0=4 THEN N'Lote y sublote' WHEN p.LOTMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.LOTMGTCOD_0) END AS LOTMGTCOD_0, CASE WHEN p.SERMGTCOD_0=1 THEN N'No gestionadas' WHEN p.SERMGTCOD_0=2 THEN N'Salida' WHEN p.SERMGTCOD_0=3 THEN N'Entrada y salida' WHEN p.SERMGTCOD_0=4 THEN N'Entrada y salida global' WHEN p.SERMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SERMGTCOD_0) END AS SERMGTCOD_0, CASE WHEN p.EXYMGTCOD_0=1 THEN N'No gestionada' WHEN p.EXYMGTCOD_0=2 THEN N'Sin redondeo' WHEN p.EXYMGTCOD_0=3 THEN N'Fin de mes' WHEN p.EXYMGTCOD_0=4 THEN N'Inicio del mes siguiente' WHEN p.EXYMGTCOD_0=5 THEN N'Entrada obligatoria' WHEN p.EXYMGTCOD_0=6 THEN N'Entrada manual' WHEN p.EXYMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.EXYMGTCOD_0) END AS EXYMGTCOD_0, RTRIM(p.EXYSTA_0) AS EXYSTA_0, p.SHL_0, CASE WHEN p.SHLUOM_0=1 THEN N'Días calendario' WHEN p.SHLUOM_0=2 THEN N'Mes' WHEN p.SHLUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SHLUOM_0) END AS SHLUOM_0, p.SHLLTI_0, CASE WHEN p.SHLLTIUOM_0=1 THEN N'Días calendario' WHEN p.SHLLTIUOM_0=2 THEN N'Mes' WHEN p.SHLLTIUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SHLLTIUOM_0) END AS SHLLTIUOM_0, p.DLU_0, RTRIM(p.BUY_0) AS BUY_0, RTRIM(p.PLANNER_0) AS PLANNER_0, p.OFS_0, p.PURBASPRI_0, p.CPRAMT_0, p.CPRCOE_0, RTRIM(p.STCNUM_0) AS STCNUM_0, RTRIM(p.RPLITM_0) AS RPLITM_0, fx.FolderCurrencyCandidate, CASE WHEN fx.FolderCurrencyCandidate IS NULL THEN N'Moneda carpeta no confirmada' ELSE N'Validar SYSCUR y nivel carpeta al importar' END AS CurrencyCheck FROM ITMMASTER p CROSS JOIN (SELECT CASE WHEN COUNT(*)=1 AND COUNT(NULLIF(RTRIM(v.VALEUR_0),N''))=1 THEN MAX(RTRIM(v.VALEUR_0)) ELSE NULL END AS FolderCurrencyCandidate FROM ADOVAL v WHERE v.PARAM_0=N'SYSCUR' AND RTRIM(v.CMP_0)=N'' AND RTRIM(v.FCY_0)=N'') fx WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(RTRIM(s.ITMREF_0)),N':',RTRIM(s.ITMREF_0),N':',RTRIM(s.BPSNUM_0)) AS SupplierKey, RTRIM(s.ITMREF_0) AS ITMREF_0, RTRIM(s.BPSNUM_0) AS BPSNUM_0, RTRIM(s.ITMREFBPS_0) AS ITMREFBPS_0, RTRIM(s.ITMDESBPS_0) AS ITMDESBPS_0, RTRIM(s.EANCODBPS_0) AS EANCODBPS_0, s.PIO_0, CASE WHEN s.DEFBPSFLG_0=1 THEN N'No' WHEN s.DEFBPSFLG_0=2 THEN N'Sí' WHEN s.DEFBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DEFBPSFLG_0) END AS DEFBPSFLG_0, CASE WHEN s.DOUFLG_0=1 THEN N'No' WHEN s.DOUFLG_0=2 THEN N'Aviso' WHEN s.DOUFLG_0=3 THEN N'Bloqueante' WHEN s.DOUFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DOUFLG_0) END AS DOUFLG_0, CASE WHEN s.CTMBPSFLG_0=1 THEN N'No' WHEN s.CTMBPSFLG_0=2 THEN N'Sí' WHEN s.CTMBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.CTMBPSFLG_0) END AS CTMBPSFLG_0, CASE WHEN s.DEFCTMBPSFLG_0=1 THEN N'No' WHEN s.DEFCTMBPSFLG_0=2 THEN N'Sí' WHEN s.DEFCTMBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DEFCTMBPSFLG_0) END AS DEFCTMBPSFLG_0, RTRIM(s.PUU_0) AS PUU_0, s.PUUSTUCOE_0, s.PURMINQTY_0, RTRIM(s.PCU_0) AS PCU_0, s.PCUPUUCOE_0, CASE WHEN s.QUAFLG_0=1 THEN N'Sin control' WHEN s.QUAFLG_0=2 THEN N'Control no modificable' WHEN s.QUAFLG_0=3 THEN N'Control modificable' WHEN s.QUAFLG_0=4 THEN N'Control periódico' WHEN s.QUAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.QUAFLG_0) END AS QUAFLG_0, s.QLYMRK_0, RTRIM(s.QLYCRD_0) AS QLYCRD_0, s.QUAFRY_0, s.SCOLTI_0, RTRIM(s.MATTOL_0) AS MATTOL_0, s.CPRAMT_0, s.CPRCOE_0, RTRIM(s.STCNUM_0) AS STCNUM_0, RTRIM(bp.BPRNAM_0) AS SupplierName, RTRIM(bp.BPRNAM_1) AS SupplierName2, RTRIM(p.STU_0) AS CurrentStockUnit, fx.FolderCurrencyCandidate, CASE WHEN fx.FolderCurrencyCandidate IS NULL THEN N'Moneda carpeta no confirmada' ELSE N'Validar SYSCUR y nivel carpeta al importar' END AS CurrencyCheck FROM ITMBPS s JOIN ITMMASTER p ON p.ITMREF_0=s.ITMREF_0 LEFT JOIN BPARTNER bp ON bp.BPRNUM_0=s.BPSNUM_0 CROSS JOIN (SELECT CASE WHEN COUNT(*)=1 AND COUNT(NULLIF(RTRIM(v.VALEUR_0),N''))=1 THEN MAX(RTRIM(v.VALEUR_0)) ELSE NULL END AS FolderCurrencyCandidate FROM ADOVAL v WHERE v.PARAM_0=N'SYSCUR' AND RTRIM(v.CMP_0)=N'' AND RTRIM(v.FCY_0)=N'') fx WHERE s.ITMREF_0=:product AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(RTRIM(s.ITMREF_0)),N':',RTRIM(s.ITMREF_0),N':',RTRIM(s.STOFCY_0)) AS SiteKey, RTRIM(s.ITMREF_0) AS ITMREF_0, RTRIM(s.STOFCY_0) AS STOFCY_0, CASE WHEN s.STOMGTCOD_0=1 THEN N'No gestionado' WHEN s.STOMGTCOD_0=2 THEN N'Gestionado' WHEN s.STOMGTCOD_0=3 THEN N'Potencia gestionada' WHEN s.STOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.STOMGTCOD_0) END AS STOMGTCOD_0, CASE WHEN s.LOCMGTCOD_0=1 THEN N'No' WHEN s.LOCMGTCOD_0=2 THEN N'Sí' WHEN s.LOCMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.LOCMGTCOD_0) END AS LOCMGTCOD_0, CASE WHEN s.ABCCLS_0=1 THEN N'Clase A' WHEN s.ABCCLS_0=2 THEN N'Clase B' WHEN s.ABCCLS_0=3 THEN N'Clase C' WHEN s.ABCCLS_0=4 THEN N'Clase D' WHEN s.ABCCLS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.ABCCLS_0) END AS ABCCLS_0, CASE WHEN s.CUNCOD_0=1 THEN N'Inventario cíclico' WHEN s.CUNCOD_0=2 THEN N'Inventario anual' WHEN s.CUNCOD_0=3 THEN N'Sin inventario' WHEN s.CUNCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.CUNCOD_0) END AS CUNCOD_0, CASE WHEN s.QUAFLG_0=1 THEN N'Sin control' WHEN s.QUAFLG_0=2 THEN N'Control no modificable' WHEN s.QUAFLG_0=3 THEN N'Control modificable' WHEN s.QUAFLG_0=4 THEN N'Control periódico' WHEN s.QUAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.QUAFLG_0) END AS QUAFLG_0, RTRIM(s.QLYCRD_0) AS QLYCRD_0, s.QUAFRY_0, s.QUALTI_0, RTRIM(s.PLANNER_0) AS PLANNER_0, RTRIM(s.BUY_0) AS BUY_0, CASE WHEN s.REOMGTCOD_0=1 THEN N'No gestionada' WHEN s.REOMGTCOD_0=2 THEN N'Por MRP' WHEN s.REOMGTCOD_0=3 THEN N'Por MPS' WHEN s.REOMGTCOD_0=4 THEN N'Por umbral' WHEN s.REOMGTCOD_0=5 THEN N'Por periodo' WHEN s.REOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.REOMGTCOD_0) END AS REOMGTCOD_0, s.REOPER_0, RTRIM(s.REOPOL_0) AS REOPOL_0, CASE WHEN s.REOCOD_0=1 THEN N'Sin sugerencia' WHEN s.REOCOD_0=2 THEN N'Compra' WHEN s.REOCOD_0=3 THEN N'Fabricación' WHEN s.REOCOD_0=4 THEN N'Entre centros' WHEN s.REOCOD_0=5 THEN N'Subcontratación' WHEN s.REOCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.REOCOD_0) END AS REOCOD_0, RTRIM(s.REOFCY_0) AS REOFCY_0, s.SAFSTO_0, s.REOTSD_0, s.MAXSTO_0, s.REOMINQTY_0, s.MFGLOTQTY_0, s.DAYCOV_0, s.OFS_0, s.MFGLTI_0, s.PRPLTI_0, s.TOTLTI_0, s.FOH_0, CASE WHEN s.FOHUOT_0=1 THEN N'Días calendario' WHEN s.FOHUOT_0=2 THEN N'Días laborables' WHEN s.FOHUOT_0=3 THEN N'Semanas' WHEN s.FOHUOT_0=4 THEN N'Quincenas' WHEN s.FOHUOT_0=5 THEN N'Meses' WHEN s.FOHUOT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.FOHUOT_0) END AS FOHUOT_0, s.PLH_0, CASE WHEN s.PLHUOT_0=1 THEN N'Días calendario' WHEN s.PLHUOT_0=2 THEN N'Días laborables' WHEN s.PLHUOT_0=3 THEN N'Semanas' WHEN s.PLHUOT_0=4 THEN N'Quincenas' WHEN s.PLHUOT_0=5 THEN N'Meses' WHEN s.PLHUOT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.PLHUOT_0) END AS PLHUOT_0, s.SHR_0, CASE WHEN s.STOCOD_0=1 THEN N'Inmediata' WHEN s.STOCOD_0=2 THEN N'Postconsumo' WHEN s.STOCOD_0=3 THEN N'No gestionada' WHEN s.STOCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.STOCOD_0) END AS STOCOD_0, s.SHLLTI_0, CASE WHEN s.SHLLTIUOM_0=1 THEN N'Días calendario' WHEN s.SHLLTIUOM_0=2 THEN N'Mes' WHEN s.SHLLTIUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.SHLLTIUOM_0) END AS SHLLTIUOM_0, s.DLU_0, RTRIM(s.VLTCOD_0) AS VLTCOD_0, CASE WHEN s.WIPPRO_0=1 THEN N'No' WHEN s.WIPPRO_0=2 THEN N'Sí' WHEN s.WIPPRO_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.WIPPRO_0) END AS WIPPRO_0, RTRIM(f.FCYNAM_0) AS SiteName, RTRIM(f.LEGCPY_0) AS SiteCompany, RTRIM(p.STU_0) AS CurrentStockUnit FROM ITMFACILIT s JOIN ITMMASTER p ON p.ITMREF_0=s.ITMREF_0 LEFT JOIN FACILITY f ON f.FCY_0=s.STOFCY_0 WHERE s.ITMREF_0=:product AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage X3 — SQL Server, carpeta autorizada",
"id": "1B1ABFA2-5AF7-5B16-982D-9E2D6B74AAD6",
"kind": "sqlServer",
"requiredObjects": [
"ITMMASTER",
"ITMBPS",
"ITMFACILIT",
"BPARTNER",
"FACILITY",
"ADOVAL"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "5DABC1F6-CF66-5E1B-8C0B-F65D21E6E363",
"key": "ITMREF_0",
"type": "text"
}
],
"id": "DDF42104-345B-5185-81D0-C9AE10383294",
"mappings": [
{
"commonFieldKey": "",
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMDES1_0",
"label": "Producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDES1_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMDES2_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDES2_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMDES3_0",
"label": "Descripción, tercera línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDES3_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TCLCOD_0",
"label": "Categoría (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TCLCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ITMSTA_0",
"label": "Estado del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa del maestro (si definida)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EANCOD_0",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EANCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "GTIN_0",
"label": "GTIN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GTIN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STU_0",
"label": "UM de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PUU_0",
"label": "UM de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PUU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SAU_0",
"label": "UM de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SAU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PUUSTUCOE_0",
"label": "Conversión compra / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PUUSTUCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAUSTUCOE_0",
"label": "Conversión venta / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SAUSTUCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMWEI_0",
"label": "Peso por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITMWEI_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEU_0",
"label": "Unidad de peso",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WEU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMVOU_0",
"label": "Volumen por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITMVOU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VOU_0",
"label": "Unidad de volumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VOU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SALFLG_0",
"label": "Vendido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SALFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PURFLG_0",
"label": "Comprado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PURFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DLVFLG_0",
"label": "Entregable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DLVFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MFGFLG_0",
"label": "Fabricado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MFGFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SCPFLG_0",
"label": "Subcontratado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SCPFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SCSFLG_0",
"label": "Subcontratación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SCSFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NEGSTO_0",
"label": "Stock negativo autorizado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NEGSTO_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOMGTCOD_0",
"label": "Gestión de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STDFLG_0",
"label": "Modo de gestión",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STDFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LOTMGTCOD_0",
"label": "Gestión de lotes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LOTMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SERMGTCOD_0",
"label": "Gestión de series",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SERMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXYMGTCOD_0",
"label": "Gestión de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXYMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXYSTA_0",
"label": "Estado al caducar (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXYSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHL_0",
"label": "Plazo de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHL_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHLUOM_0",
"label": "Unidad de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHLUOM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHLLTI_0",
"label": "Plazo de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHLLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHLLTIUOM_0",
"label": "Unidad de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHLLTIUOM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DLU_0",
"label": "Coeficiente de consumo preferente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DLU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BUY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PLANNER_0",
"label": "Planificador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PLANNER_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OFS_0",
"label": "Plazo reposición (días calendario)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OFS_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PURBASPRI_0",
"label": "Precio base compra por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PURBASPRI_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CPRAMT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CPRCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STCNUM_0",
"label": "Estructura de costes (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STCNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RPLITM_0",
"label": "Producto alternativo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RPLITM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FolderCurrencyCandidate",
"label": "SYSCUR actual (verificar)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FolderCurrencyCandidate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCheck",
"label": "Comprobación de moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrencyCheck",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Catálogo de productos",
"primaryKey": "ITMREF_0",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ITMREF_0",
"ITMDES1_0",
"ITMDES2_0",
"ITMDES3_0",
"TCLCOD_0",
"ITMSTA_0",
"CPY_0",
"EANCOD_0",
"GTIN_0",
"STU_0",
"PUU_0",
"SAU_0",
"PUUSTUCOE_0",
"SAUSTUCOE_0",
"ITMWEI_0",
"WEU_0",
"ITMVOU_0",
"VOU_0",
"SALFLG_0",
"PURFLG_0",
"DLVFLG_0",
"MFGFLG_0",
"SCPFLG_0",
"SCSFLG_0",
"NEGSTO_0",
"STOMGTCOD_0",
"STDFLG_0",
"LOTMGTCOD_0",
"SERMGTCOD_0",
"EXYMGTCOD_0",
"EXYSTA_0",
"SHL_0",
"SHLUOM_0",
"SHLLTI_0",
"SHLLTIUOM_0",
"DLU_0",
"BUY_0",
"PLANNER_0",
"OFS_0",
"PURBASPRI_0",
"CPRAMT_0",
"CPRCOE_0",
"STCNUM_0",
"RPLITM_0",
"FolderCurrencyCandidate",
"CurrencyCheck"
],
"sourceID": "1B1ABFA2-5AF7-5B16-982D-9E2D6B74AAD6",
"sqlQuery": "SELECT RTRIM(p.ITMREF_0) AS ITMREF_0, RTRIM(p.ITMDES1_0) AS ITMDES1_0, RTRIM(p.ITMDES2_0) AS ITMDES2_0, RTRIM(p.ITMDES3_0) AS ITMDES3_0, RTRIM(p.TCLCOD_0) AS TCLCOD_0, CASE WHEN p.ITMSTA_0=1 THEN N'Activo' WHEN p.ITMSTA_0=2 THEN N'En desarrollo' WHEN p.ITMSTA_0=3 THEN N'En escasez' WHEN p.ITMSTA_0=4 THEN N'No renovado' WHEN p.ITMSTA_0=5 THEN N'Obsoleto' WHEN p.ITMSTA_0=6 THEN N'No utilizable' WHEN p.ITMSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.ITMSTA_0) END AS ITMSTA_0, RTRIM(p.CPY_0) AS CPY_0, RTRIM(p.EANCOD_0) AS EANCOD_0, RTRIM(p.GTIN_0) AS GTIN_0, RTRIM(p.STU_0) AS STU_0, RTRIM(p.PUU_0) AS PUU_0, RTRIM(p.SAU_0) AS SAU_0, p.PUUSTUCOE_0, p.SAUSTUCOE_0, p.ITMWEI_0, RTRIM(p.WEU_0) AS WEU_0, p.ITMVOU_0, RTRIM(p.VOU_0) AS VOU_0, CASE WHEN p.SALFLG_0=1 THEN N'No' WHEN p.SALFLG_0=2 THEN N'Sí' WHEN p.SALFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SALFLG_0) END AS SALFLG_0, CASE WHEN p.PURFLG_0=1 THEN N'No' WHEN p.PURFLG_0=2 THEN N'Sí' WHEN p.PURFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.PURFLG_0) END AS PURFLG_0, CASE WHEN p.DLVFLG_0=1 THEN N'No' WHEN p.DLVFLG_0=2 THEN N'Sí' WHEN p.DLVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.DLVFLG_0) END AS DLVFLG_0, CASE WHEN p.MFGFLG_0=1 THEN N'No' WHEN p.MFGFLG_0=2 THEN N'Sí' WHEN p.MFGFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.MFGFLG_0) END AS MFGFLG_0, CASE WHEN p.SCPFLG_0=1 THEN N'No' WHEN p.SCPFLG_0=2 THEN N'Sí' WHEN p.SCPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SCPFLG_0) END AS SCPFLG_0, CASE WHEN p.SCSFLG_0=1 THEN N'No' WHEN p.SCSFLG_0=2 THEN N'Sí' WHEN p.SCSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SCSFLG_0) END AS SCSFLG_0, CASE WHEN p.NEGSTO_0=1 THEN N'No' WHEN p.NEGSTO_0=2 THEN N'Sí' WHEN p.NEGSTO_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.NEGSTO_0) END AS NEGSTO_0, CASE WHEN p.STOMGTCOD_0=1 THEN N'No gestionado' WHEN p.STOMGTCOD_0=2 THEN N'Gestionado' WHEN p.STOMGTCOD_0=3 THEN N'Potencia gestionada' WHEN p.STOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.STOMGTCOD_0) END AS STOMGTCOD_0, CASE WHEN p.STDFLG_0=1 THEN N'No gestionado' WHEN p.STDFLG_0=2 THEN N'Por proyecto' WHEN p.STDFLG_0=3 THEN N'Stock disponible' WHEN p.STDFLG_0=4 THEN N'Por pedido' WHEN p.STDFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.STDFLG_0) END AS STDFLG_0, CASE WHEN p.LOTMGTCOD_0=1 THEN N'No gestionados' WHEN p.LOTMGTCOD_0=2 THEN N'Lote opcional' WHEN p.LOTMGTCOD_0=3 THEN N'Lote obligatorio' WHEN p.LOTMGTCOD_0=4 THEN N'Lote y sublote' WHEN p.LOTMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.LOTMGTCOD_0) END AS LOTMGTCOD_0, CASE WHEN p.SERMGTCOD_0=1 THEN N'No gestionadas' WHEN p.SERMGTCOD_0=2 THEN N'Salida' WHEN p.SERMGTCOD_0=3 THEN N'Entrada y salida' WHEN p.SERMGTCOD_0=4 THEN N'Entrada y salida global' WHEN p.SERMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SERMGTCOD_0) END AS SERMGTCOD_0, CASE WHEN p.EXYMGTCOD_0=1 THEN N'No gestionada' WHEN p.EXYMGTCOD_0=2 THEN N'Sin redondeo' WHEN p.EXYMGTCOD_0=3 THEN N'Fin de mes' WHEN p.EXYMGTCOD_0=4 THEN N'Inicio del mes siguiente' WHEN p.EXYMGTCOD_0=5 THEN N'Entrada obligatoria' WHEN p.EXYMGTCOD_0=6 THEN N'Entrada manual' WHEN p.EXYMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.EXYMGTCOD_0) END AS EXYMGTCOD_0, RTRIM(p.EXYSTA_0) AS EXYSTA_0, p.SHL_0, CASE WHEN p.SHLUOM_0=1 THEN N'Días calendario' WHEN p.SHLUOM_0=2 THEN N'Mes' WHEN p.SHLUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SHLUOM_0) END AS SHLUOM_0, p.SHLLTI_0, CASE WHEN p.SHLLTIUOM_0=1 THEN N'Días calendario' WHEN p.SHLLTIUOM_0=2 THEN N'Mes' WHEN p.SHLLTIUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SHLLTIUOM_0) END AS SHLLTIUOM_0, p.DLU_0, RTRIM(p.BUY_0) AS BUY_0, RTRIM(p.PLANNER_0) AS PLANNER_0, p.OFS_0, p.PURBASPRI_0, p.CPRAMT_0, p.CPRCOE_0, RTRIM(p.STCNUM_0) AS STCNUM_0, RTRIM(p.RPLITM_0) AS RPLITM_0, fx.FolderCurrencyCandidate, CASE WHEN fx.FolderCurrencyCandidate IS NULL THEN N'Moneda carpeta no confirmada' ELSE N'Validar SYSCUR y nivel carpeta al importar' END AS CurrencyCheck FROM ITMMASTER p CROSS JOIN (SELECT CASE WHEN COUNT(*)=1 AND COUNT(NULLIF(RTRIM(v.VALEUR_0),N''))=1 THEN MAX(RTRIM(v.VALEUR_0)) ELSE NULL END AS FolderCurrencyCandidate FROM ADOVAL v WHERE v.PARAM_0=N'SYSCUR' AND RTRIM(v.CMP_0)=N'' AND RTRIM(v.FCY_0)=N'') fx WHERE SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "65B6570C-75B5-5BC4-8F5B-627F68A6070D",
"key": "PIO_0",
"type": "number"
},
{
"direction": "ascending",
"id": "CB19D284-F44B-59FF-AA57-A33F4F579104",
"key": "BPSNUM_0",
"type": "text"
}
],
"id": "A771619B-1F89-5FF5-966C-D30D0826650E",
"mappings": [
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Clave interna producto / proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPSNUM_0",
"label": "Proveedor (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPSNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName2",
"label": "Proveedor, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMREFBPS_0",
"label": "Referencia del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREFBPS_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ITMDESBPS_0",
"label": "Descripción del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDESBPS_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EANCODBPS_0",
"label": "UPC / EAN proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EANCODBPS_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PIO_0",
"label": "Prioridad (0 es máxima)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PIO_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DEFBPSFLG_0",
"label": "Proveedor por defecto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEFBPSFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DOUFLG_0",
"label": "Control del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DOUFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CTMBPSFLG_0",
"label": "Contramarca",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CTMBPSFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEFCTMBPSFLG_0",
"label": "Contramarca por defecto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEFCTMBPSFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PUU_0",
"label": "UM compra del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PUU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentStockUnit",
"label": "UM stock actual del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentStockUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PUUSTUCOE_0",
"label": "Conversión compra / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PUUSTUCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PURMINQTY_0",
"label": "Compra mínima en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PURMINQTY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PCU_0",
"label": "UM de embalaje",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PCU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PCUPUUCOE_0",
"label": "Conversión embalaje / compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PCUPUUCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUAFLG_0",
"label": "Control de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QUAFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QLYMRK_0",
"label": "Calificación de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QLYMRK_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QLYCRD_0",
"label": "Ficha de calidad (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QLYCRD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUAFRY_0",
"label": "Frecuencia del control",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QUAFRY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SCOLTI_0",
"label": "Plazo subcontratación (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SCOLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MATTOL_0",
"label": "Regla de conciliación (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MATTOL_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CPRAMT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CPRCOE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STCNUM_0",
"label": "Estructura de costes (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STCNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FolderCurrencyCandidate",
"label": "SYSCUR actual (verificar)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FolderCurrencyCandidate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCheck",
"label": "Comprobación de moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrencyCheck",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Proveedores del producto",
"primaryKey": "SupplierKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ITMREF_0",
"id": "5030EDE1-7533-5C00-AE3D-CA87BE0C0C32",
"name": "product",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ITMREF_0",
"BPSNUM_0",
"SupplierName",
"SupplierName2",
"ITMREFBPS_0",
"ITMDESBPS_0",
"EANCODBPS_0",
"PIO_0",
"DEFBPSFLG_0",
"DOUFLG_0",
"CTMBPSFLG_0",
"DEFCTMBPSFLG_0",
"PUU_0",
"CurrentStockUnit",
"PUUSTUCOE_0",
"PURMINQTY_0",
"PCU_0",
"PCUPUUCOE_0",
"QUAFLG_0",
"QLYMRK_0",
"QLYCRD_0",
"QUAFRY_0",
"SCOLTI_0",
"MATTOL_0",
"CPRAMT_0",
"CPRCOE_0",
"STCNUM_0",
"FolderCurrencyCandidate",
"CurrencyCheck"
],
"sourceID": "1B1ABFA2-5AF7-5B16-982D-9E2D6B74AAD6",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(s.ITMREF_0)),N':',RTRIM(s.ITMREF_0),N':',RTRIM(s.BPSNUM_0)) AS SupplierKey, RTRIM(s.ITMREF_0) AS ITMREF_0, RTRIM(s.BPSNUM_0) AS BPSNUM_0, RTRIM(s.ITMREFBPS_0) AS ITMREFBPS_0, RTRIM(s.ITMDESBPS_0) AS ITMDESBPS_0, RTRIM(s.EANCODBPS_0) AS EANCODBPS_0, s.PIO_0, CASE WHEN s.DEFBPSFLG_0=1 THEN N'No' WHEN s.DEFBPSFLG_0=2 THEN N'Sí' WHEN s.DEFBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DEFBPSFLG_0) END AS DEFBPSFLG_0, CASE WHEN s.DOUFLG_0=1 THEN N'No' WHEN s.DOUFLG_0=2 THEN N'Aviso' WHEN s.DOUFLG_0=3 THEN N'Bloqueante' WHEN s.DOUFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DOUFLG_0) END AS DOUFLG_0, CASE WHEN s.CTMBPSFLG_0=1 THEN N'No' WHEN s.CTMBPSFLG_0=2 THEN N'Sí' WHEN s.CTMBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.CTMBPSFLG_0) END AS CTMBPSFLG_0, CASE WHEN s.DEFCTMBPSFLG_0=1 THEN N'No' WHEN s.DEFCTMBPSFLG_0=2 THEN N'Sí' WHEN s.DEFCTMBPSFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.DEFCTMBPSFLG_0) END AS DEFCTMBPSFLG_0, RTRIM(s.PUU_0) AS PUU_0, s.PUUSTUCOE_0, s.PURMINQTY_0, RTRIM(s.PCU_0) AS PCU_0, s.PCUPUUCOE_0, CASE WHEN s.QUAFLG_0=1 THEN N'Sin control' WHEN s.QUAFLG_0=2 THEN N'Control no modificable' WHEN s.QUAFLG_0=3 THEN N'Control modificable' WHEN s.QUAFLG_0=4 THEN N'Control periódico' WHEN s.QUAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.QUAFLG_0) END AS QUAFLG_0, s.QLYMRK_0, RTRIM(s.QLYCRD_0) AS QLYCRD_0, s.QUAFRY_0, s.SCOLTI_0, RTRIM(s.MATTOL_0) AS MATTOL_0, s.CPRAMT_0, s.CPRCOE_0, RTRIM(s.STCNUM_0) AS STCNUM_0, RTRIM(bp.BPRNAM_0) AS SupplierName, RTRIM(bp.BPRNAM_1) AS SupplierName2, RTRIM(p.STU_0) AS CurrentStockUnit, fx.FolderCurrencyCandidate, CASE WHEN fx.FolderCurrencyCandidate IS NULL THEN N'Moneda carpeta no confirmada' ELSE N'Validar SYSCUR y nivel carpeta al importar' END AS CurrencyCheck FROM ITMBPS s JOIN ITMMASTER p ON p.ITMREF_0=s.ITMREF_0 LEFT JOIN BPARTNER bp ON bp.BPRNUM_0=s.BPSNUM_0 CROSS JOIN (SELECT CASE WHEN COUNT(*)=1 AND COUNT(NULLIF(RTRIM(v.VALEUR_0),N''))=1 THEN MAX(RTRIM(v.VALEUR_0)) ELSE NULL END AS FolderCurrencyCandidate FROM ADOVAL v WHERE v.PARAM_0=N'SYSCUR' AND RTRIM(v.CMP_0)=N'' AND RTRIM(v.FCY_0)=N'') fx WHERE s.ITMREF_0=:product AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "35204045-88D9-5003-9D4F-580F4CD24E0B",
"key": "STOFCY_0",
"type": "text"
}
],
"id": "721BAFDC-2050-5316-A7F2-1CA3C50D356F",
"mappings": [
{
"commonFieldKey": "",
"key": "SiteKey",
"label": "Clave interna producto / centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SiteKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOFCY_0",
"label": "Centro de stock (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SiteName",
"label": "Centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SiteName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SiteCompany",
"label": "Empresa actual del centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SiteCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentStockUnit",
"label": "UM stock actual del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentStockUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STOMGTCOD_0",
"label": "Gestión de stock en centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LOCMGTCOD_0",
"label": "Ubicaciones gestionadas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LOCMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ABCCLS_0",
"label": "Clase ABC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ABCCLS_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUNCOD_0",
"label": "Modo de inventario",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUNCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUAFLG_0",
"label": "Control de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QUAFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QLYCRD_0",
"label": "Ficha de calidad (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QLYCRD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUAFRY_0",
"label": "Frecuencia del control",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QUAFRY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUALTI_0",
"label": "Plazo calidad (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QUALTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PLANNER_0",
"label": "Planificador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PLANNER_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BUY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REOMGTCOD_0",
"label": "Modo de reposición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REOMGTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REOPER_0",
"label": "Frecuencia reposición (días calendario)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REOPER_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REOPOL_0",
"label": "Política de reposición (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REOPOL_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REOCOD_0",
"label": "Tipo de sugerencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REOCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REOFCY_0",
"label": "Centro de reposición (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REOFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAFSTO_0",
"label": "Seguridad en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SAFSTO_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REOTSD_0",
"label": "Umbral en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REOTSD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MAXSTO_0",
"label": "Máximo en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MAXSTO_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REOMINQTY_0",
"label": "Lote económico en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REOMINQTY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MFGLOTQTY_0",
"label": "Lote técnico en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MFGLOTQTY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DAYCOV_0",
"label": "Cobertura (semanas)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DAYCOV_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OFS_0",
"label": "Plazo reposición (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OFS_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MFGLTI_0",
"label": "Plazo producción (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MFGLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRPLTI_0",
"label": "Preparación (días laborables)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRPLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TOTLTI_0",
"label": "Plazo multinivel (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FOH_0",
"label": "Horizonte de demanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FOH_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FOHUOT_0",
"label": "Unidad horizonte demanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FOHUOT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PLH_0",
"label": "Horizonte firme",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PLH_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PLHUOT_0",
"label": "Unidad horizonte firme",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PLHUOT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHR_0",
"label": "Merma (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOCOD_0",
"label": "Modo de salida de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHLLTI_0",
"label": "Plazo de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHLLTI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHLLTIUOM_0",
"label": "Unidad de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHLLTIUOM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DLU_0",
"label": "Coeficiente de consumo preferente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DLU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VLTCOD_0",
"label": "Método de valoración (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VLTCOD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WIPPRO_0",
"label": "Protección de replanteo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WIPPRO_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Parámetros por centro",
"primaryKey": "SiteKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ITMREF_0",
"id": "5030EDE1-7533-5C00-AE3D-CA87BE0C0C32",
"name": "product",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ITMREF_0",
"STOFCY_0",
"SiteName",
"SiteCompany",
"CurrentStockUnit",
"STOMGTCOD_0",
"LOCMGTCOD_0",
"ABCCLS_0",
"CUNCOD_0",
"QUAFLG_0",
"QLYCRD_0",
"QUAFRY_0",
"QUALTI_0",
"PLANNER_0",
"BUY_0",
"REOMGTCOD_0",
"REOPER_0",
"REOPOL_0",
"REOCOD_0",
"REOFCY_0",
"SAFSTO_0",
"REOTSD_0",
"MAXSTO_0",
"REOMINQTY_0",
"MFGLOTQTY_0",
"DAYCOV_0",
"OFS_0",
"MFGLTI_0",
"PRPLTI_0",
"TOTLTI_0",
"FOH_0",
"FOHUOT_0",
"PLH_0",
"PLHUOT_0",
"SHR_0",
"STOCOD_0",
"SHLLTI_0",
"SHLLTIUOM_0",
"DLU_0",
"VLTCOD_0",
"WIPPRO_0"
],
"sourceID": "1B1ABFA2-5AF7-5B16-982D-9E2D6B74AAD6",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(s.ITMREF_0)),N':',RTRIM(s.ITMREF_0),N':',RTRIM(s.STOFCY_0)) AS SiteKey, RTRIM(s.ITMREF_0) AS ITMREF_0, RTRIM(s.STOFCY_0) AS STOFCY_0, CASE WHEN s.STOMGTCOD_0=1 THEN N'No gestionado' WHEN s.STOMGTCOD_0=2 THEN N'Gestionado' WHEN s.STOMGTCOD_0=3 THEN N'Potencia gestionada' WHEN s.STOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.STOMGTCOD_0) END AS STOMGTCOD_0, CASE WHEN s.LOCMGTCOD_0=1 THEN N'No' WHEN s.LOCMGTCOD_0=2 THEN N'Sí' WHEN s.LOCMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.LOCMGTCOD_0) END AS LOCMGTCOD_0, CASE WHEN s.ABCCLS_0=1 THEN N'Clase A' WHEN s.ABCCLS_0=2 THEN N'Clase B' WHEN s.ABCCLS_0=3 THEN N'Clase C' WHEN s.ABCCLS_0=4 THEN N'Clase D' WHEN s.ABCCLS_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.ABCCLS_0) END AS ABCCLS_0, CASE WHEN s.CUNCOD_0=1 THEN N'Inventario cíclico' WHEN s.CUNCOD_0=2 THEN N'Inventario anual' WHEN s.CUNCOD_0=3 THEN N'Sin inventario' WHEN s.CUNCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.CUNCOD_0) END AS CUNCOD_0, CASE WHEN s.QUAFLG_0=1 THEN N'Sin control' WHEN s.QUAFLG_0=2 THEN N'Control no modificable' WHEN s.QUAFLG_0=3 THEN N'Control modificable' WHEN s.QUAFLG_0=4 THEN N'Control periódico' WHEN s.QUAFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.QUAFLG_0) END AS QUAFLG_0, RTRIM(s.QLYCRD_0) AS QLYCRD_0, s.QUAFRY_0, s.QUALTI_0, RTRIM(s.PLANNER_0) AS PLANNER_0, RTRIM(s.BUY_0) AS BUY_0, CASE WHEN s.REOMGTCOD_0=1 THEN N'No gestionada' WHEN s.REOMGTCOD_0=2 THEN N'Por MRP' WHEN s.REOMGTCOD_0=3 THEN N'Por MPS' WHEN s.REOMGTCOD_0=4 THEN N'Por umbral' WHEN s.REOMGTCOD_0=5 THEN N'Por periodo' WHEN s.REOMGTCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.REOMGTCOD_0) END AS REOMGTCOD_0, s.REOPER_0, RTRIM(s.REOPOL_0) AS REOPOL_0, CASE WHEN s.REOCOD_0=1 THEN N'Sin sugerencia' WHEN s.REOCOD_0=2 THEN N'Compra' WHEN s.REOCOD_0=3 THEN N'Fabricación' WHEN s.REOCOD_0=4 THEN N'Entre centros' WHEN s.REOCOD_0=5 THEN N'Subcontratación' WHEN s.REOCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.REOCOD_0) END AS REOCOD_0, RTRIM(s.REOFCY_0) AS REOFCY_0, s.SAFSTO_0, s.REOTSD_0, s.MAXSTO_0, s.REOMINQTY_0, s.MFGLOTQTY_0, s.DAYCOV_0, s.OFS_0, s.MFGLTI_0, s.PRPLTI_0, s.TOTLTI_0, s.FOH_0, CASE WHEN s.FOHUOT_0=1 THEN N'Días calendario' WHEN s.FOHUOT_0=2 THEN N'Días laborables' WHEN s.FOHUOT_0=3 THEN N'Semanas' WHEN s.FOHUOT_0=4 THEN N'Quincenas' WHEN s.FOHUOT_0=5 THEN N'Meses' WHEN s.FOHUOT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.FOHUOT_0) END AS FOHUOT_0, s.PLH_0, CASE WHEN s.PLHUOT_0=1 THEN N'Días calendario' WHEN s.PLHUOT_0=2 THEN N'Días laborables' WHEN s.PLHUOT_0=3 THEN N'Semanas' WHEN s.PLHUOT_0=4 THEN N'Quincenas' WHEN s.PLHUOT_0=5 THEN N'Meses' WHEN s.PLHUOT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.PLHUOT_0) END AS PLHUOT_0, s.SHR_0, CASE WHEN s.STOCOD_0=1 THEN N'Inmediata' WHEN s.STOCOD_0=2 THEN N'Postconsumo' WHEN s.STOCOD_0=3 THEN N'No gestionada' WHEN s.STOCOD_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.STOCOD_0) END AS STOCOD_0, s.SHLLTI_0, CASE WHEN s.SHLLTIUOM_0=1 THEN N'Días calendario' WHEN s.SHLLTIUOM_0=2 THEN N'Mes' WHEN s.SHLLTIUOM_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.SHLLTIUOM_0) END AS SHLLTIUOM_0, s.DLU_0, RTRIM(s.VLTCOD_0) AS VLTCOD_0, CASE WHEN s.WIPPRO_0=1 THEN N'No' WHEN s.WIPPRO_0=2 THEN N'Sí' WHEN s.WIPPRO_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',s.WIPPRO_0) END AS WIPPRO_0, RTRIM(f.FCYNAM_0) AS SiteName, RTRIM(f.LEGCPY_0) AS SiteCompany, RTRIM(p.STU_0) AS CurrentStockUnit FROM ITMFACILIT s JOIN ITMMASTER p ON p.ITMREF_0=s.ITMREF_0 LEFT JOIN FACILITY f ON f.FCY_0=s.STOFCY_0 WHERE s.ITMREF_0=:product AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ITMMASTER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMMASTER',N'U') AND OBJECT_ID(N'ITMBPS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMBPS',N'U') AND OBJECT_ID(N'ITMFACILIT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ITMFACILIT',N'U') AND OBJECT_ID(N'BPARTNER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BPARTNER',N'U') AND OBJECT_ID(N'FACILITY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FACILITY',N'U') AND OBJECT_ID(N'ADOVAL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ADOVAL',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "159DAD7A-2815-5F82-9C87-AFDB26DA40EE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6610D721-1355-5477-B1BB-374F9A6102B1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A771619B-1F89-5FF5-966C-D30D0826650E",
"title": "Proveedores",
"urlKey": ""
},
{
"id": "B5D3B915-D5A1-5B62-9C49-C53930F4547A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "76B40530-23FB-504A-ADCB-43727DF8F1FF",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "721BAFDC-2050-5316-A7F2-1CA3C50D356F",
"title": "Centros",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TCLCOD_0",
"label": "Categoría (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ITMSTA_0",
"label": "Estado del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STU_0",
"label": "UM de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "UM de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SAU_0",
"label": "UM de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PURFLG_0",
"label": "Comprado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DDF42104-345B-5185-81D0-C9AE10383294",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES1_0",
"label": "Producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES2_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES3_0",
"label": "Descripción, tercera línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "TCLCOD_0",
"label": "Categoría (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "ITMSTA_0",
"label": "Estado del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa del maestro (si definida)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "EANCOD_0",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "GTIN_0",
"label": "GTIN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto e identidad",
"detailRole": "information",
"isVisible": true,
"key": "RPLITM_0",
"label": "Producto alternativo (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "STU_0",
"label": "UM de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "UM de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "SAU_0",
"label": "UM de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "PUUSTUCOE_0",
"label": "Conversión compra / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "SAUSTUCOE_0",
"label": "Conversión venta / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "ITMWEI_0",
"label": "Peso por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "WEU_0",
"label": "Unidad de peso",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "ITMVOU_0",
"label": "Volumen por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y dimensiones actuales",
"detailRole": "information",
"isVisible": true,
"key": "VOU_0",
"label": "Unidad de volumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "FolderCurrencyCandidate",
"label": "SYSCUR actual (verificar)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCheck",
"label": "Comprobación de moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "PURBASPRI_0",
"label": "Precio base compra por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "STCNUM_0",
"label": "Estructura de costes (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "BUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "PLANNER_0",
"label": "Planificador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Compra y costes, moneda de carpeta por verificar",
"detailRole": "information",
"isVisible": true,
"key": "OFS_0",
"label": "Plazo reposición (días calendario)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "SALFLG_0",
"label": "Vendido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "PURFLG_0",
"label": "Comprado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "DLVFLG_0",
"label": "Entregable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "MFGFLG_0",
"label": "Fabricado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "SCPFLG_0",
"label": "Subcontratado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "SCSFLG_0",
"label": "Subcontratación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "NEGSTO_0",
"label": "Stock negativo autorizado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "STOMGTCOD_0",
"label": "Gestión de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flujos y gestión",
"detailRole": "information",
"isVisible": true,
"key": "STDFLG_0",
"label": "Modo de gestión",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "LOTMGTCOD_0",
"label": "Gestión de lotes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "SERMGTCOD_0",
"label": "Gestión de series",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "EXYMGTCOD_0",
"label": "Gestión de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "EXYSTA_0",
"label": "Estado al caducar (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "SHL_0",
"label": "Plazo de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "SHLUOM_0",
"label": "Unidad de caducidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "SHLLTI_0",
"label": "Plazo de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "SHLLTIUOM_0",
"label": "Unidad de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lotes, series y caducidad configurada",
"detailRole": "information",
"isVisible": true,
"key": "DLU_0",
"label": "Coeficiente de consumo preferente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "EFE2521E-335B-53C1-BE0F-400B2E6E26BE",
"openFilters": [
{
"id": "936EA125-964B-5F3C-A522-28793BDB010C",
"includeAllOption": false,
"key": "TCLCOD_0",
"title": "Categoría",
"type": "text"
},
{
"id": "64F42390-4C0F-5BE1-8B5D-2F70D2AA4F44",
"includeAllOption": true,
"key": "ITMSTA_0",
"title": "Estado",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "5DABC1F6-CF66-5E1B-8C0B-F65D21E6E363",
"key": "ITMREF_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ITMREF_0",
"systemImage": "shippingbox",
"title": "Catálogo de productos",
"titleKey": "ITMDES1_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ITMREFBPS_0",
"label": "Referencia del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PIO_0",
"label": "Prioridad (0 es máxima)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DEFBPSFLG_0",
"label": "Proveedor por defecto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DOUFLG_0",
"label": "Control del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "UM compra del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PURMINQTY_0",
"label": "Compra mínima en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "A771619B-1F89-5FF5-966C-D30D0826650E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName2",
"label": "Proveedor, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "BPSNUM_0",
"label": "Proveedor (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "ITMREFBPS_0",
"label": "Referencia del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "ITMDESBPS_0",
"label": "Descripción del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Proveedor y referencias",
"detailRole": "information",
"isVisible": true,
"key": "EANCODBPS_0",
"label": "UPC / EAN proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prioridad y control nativos",
"detailRole": "information",
"isVisible": true,
"key": "PIO_0",
"label": "Prioridad (0 es máxima)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prioridad y control nativos",
"detailRole": "information",
"isVisible": true,
"key": "DEFBPSFLG_0",
"label": "Proveedor por defecto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prioridad y control nativos",
"detailRole": "information",
"isVisible": true,
"key": "DOUFLG_0",
"label": "Control del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prioridad y control nativos",
"detailRole": "information",
"isVisible": true,
"key": "CTMBPSFLG_0",
"label": "Contramarca",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prioridad y control nativos",
"detailRole": "information",
"isVisible": true,
"key": "DEFCTMBPSFLG_0",
"label": "Contramarca por defecto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "UM compra del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "PURMINQTY_0",
"label": "Compra mínima en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "CurrentStockUnit",
"label": "UM stock actual del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "PUUSTUCOE_0",
"label": "Conversión compra / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "PCU_0",
"label": "UM de embalaje",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y compra mínima",
"detailRole": "information",
"isVisible": true,
"key": "PCUPUUCOE_0",
"label": "Conversión embalaje / compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "QUAFLG_0",
"label": "Control de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "QLYMRK_0",
"label": "Calificación de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "QLYCRD_0",
"label": "Ficha de calidad (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "QUAFRY_0",
"label": "Frecuencia del control",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "SCOLTI_0",
"label": "Plazo subcontratación (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y conciliación",
"detailRole": "information",
"isVisible": true,
"key": "MATTOL_0",
"label": "Regla de conciliación (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes en carpeta, moneda por verificar",
"detailRole": "information",
"isVisible": true,
"key": "FolderCurrencyCandidate",
"label": "SYSCUR actual (verificar)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes en carpeta, moneda por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCheck",
"label": "Comprobación de moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes en carpeta, moneda por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Costes en carpeta, moneda por verificar",
"detailRole": "information",
"isVisible": true,
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Costes en carpeta, moneda por verificar",
"detailRole": "information",
"isVisible": true,
"key": "STCNUM_0",
"label": "Estructura de costes (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F5C5588A-72AA-5155-AF56-B95558A56C61",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "65B6570C-75B5-5BC4-8F5B-627F68A6070D",
"key": "PIO_0",
"type": "number"
},
{
"direction": "ascending",
"id": "CB19D284-F44B-59FF-AA57-A33F4F579104",
"key": "BPSNUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "BPSNUM_0",
"systemImage": "shippingbox",
"title": "Proveedores del producto",
"titleKey": "SupplierName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrentStockUnit",
"label": "UM stock actual del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABCCLS_0",
"label": "Clase ABC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "REOMGTCOD_0",
"label": "Modo de reposición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SAFSTO_0",
"label": "Seguridad en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "REOTSD_0",
"label": "Umbral en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MAXSTO_0",
"label": "Máximo en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "721BAFDC-2050-5316-A7F2-1CA3C50D356F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "SiteName",
"label": "Centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "STOFCY_0",
"label": "Centro de stock (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "SiteCompany",
"label": "Empresa actual del centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "CurrentStockUnit",
"label": "UM stock actual del producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "BUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Centro y contexto actuales",
"detailRole": "information",
"isVisible": true,
"key": "PLANNER_0",
"label": "Planificador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock e inventario, parámetros no existencias",
"detailRole": "information",
"isVisible": true,
"key": "STOMGTCOD_0",
"label": "Gestión de stock en centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock e inventario, parámetros no existencias",
"detailRole": "information",
"isVisible": true,
"key": "LOCMGTCOD_0",
"label": "Ubicaciones gestionadas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock e inventario, parámetros no existencias",
"detailRole": "information",
"isVisible": true,
"key": "ABCCLS_0",
"label": "Clase ABC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock e inventario, parámetros no existencias",
"detailRole": "information",
"isVisible": true,
"key": "CUNCOD_0",
"label": "Modo de inventario",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock e inventario, parámetros no existencias",
"detailRole": "information",
"isVisible": true,
"key": "STOCOD_0",
"label": "Modo de salida de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOMGTCOD_0",
"label": "Modo de reposición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOPER_0",
"label": "Frecuencia reposición (días calendario)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOPOL_0",
"label": "Política de reposición (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOCOD_0",
"label": "Tipo de sugerencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOFCY_0",
"label": "Centro de reposición (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "SAFSTO_0",
"label": "Seguridad en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOTSD_0",
"label": "Umbral en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "MAXSTO_0",
"label": "Máximo en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "REOMINQTY_0",
"label": "Lote económico en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "MFGLOTQTY_0",
"label": "Lote técnico en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reposición configurada en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "DAYCOV_0",
"label": "Cobertura (semanas)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "OFS_0",
"label": "Plazo reposición (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "MFGLTI_0",
"label": "Plazo producción (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "PRPLTI_0",
"label": "Preparación (días laborables)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "TOTLTI_0",
"label": "Plazo multinivel (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "FOH_0",
"label": "Horizonte de demanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "FOHUOT_0",
"label": "Unidad horizonte demanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "PLH_0",
"label": "Horizonte firme",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "PLHUOT_0",
"label": "Unidad horizonte firme",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "SHR_0",
"label": "Merma (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Plazos y horizontes nativos",
"detailRole": "information",
"isVisible": true,
"key": "WIPPRO_0",
"label": "Protección de replanteo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "QUAFLG_0",
"label": "Control de calidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "QLYCRD_0",
"label": "Ficha de calidad (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "QUAFRY_0",
"label": "Frecuencia del control",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "QUALTI_0",
"label": "Plazo calidad (días)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "SHLLTI_0",
"label": "Plazo de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "SHLLTIUOM_0",
"label": "Unidad de recontrol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "DLU_0",
"label": "Coeficiente de consumo preferente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Calidad y valoración configuradas",
"detailRole": "information",
"isVisible": true,
"key": "VLTCOD_0",
"label": "Método de valoración (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E51F2090-F5E4-534D-B74E-26740EF0F6E3",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "35204045-88D9-5003-9D4F-580F4CD24E0B",
"key": "STOFCY_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "STOFCY_0",
"systemImage": "shippingbox",
"title": "Parámetros por centro",
"titleKey": "SiteName"
}
],
"relations": [
{
"childDatasetID": "A771619B-1F89-5FF5-966C-D30D0826650E",
"childKey": "ITMREF_0",
"id": "6610D721-1355-5477-B1BB-374F9A6102B1",
"name": "Proveedores del producto",
"parentDatasetID": "DDF42104-345B-5185-81D0-C9AE10383294",
"parentKey": "ITMREF_0"
},
{
"childDatasetID": "721BAFDC-2050-5316-A7F2-1CA3C50D356F",
"childKey": "ITMREF_0",
"id": "76B40530-23FB-504A-ADCB-43727DF8F1FF",
"name": "Parámetros por centro",
"parentDatasetID": "DDF42104-345B-5185-81D0-C9AE10383294",
"parentKey": "ITMREF_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 compras, ventas, almacén y dirección: elige categoría y, opcionalmente, estado. Consulta descripciones, UPC/EAN y GTIN, unidades y factores, peso/volumen, flujos de compra/venta/fabricación, lotes, series y caducidad configurada. La ficha muestra precio base de compra, costes nativos y responsables. Dos sub-botones a petición abren proveedores (referencias, prioridad, control, compra mínima, unidades, calidad y costes) y parámetros por centro (empresa actual, stock de seguridad, umbrales, lotes, plazos, horizontes, inventario y calidad).\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 relaciones independientes y SELECT explícito. Modo live, sin refrescos programados; hasta 2.000 filas/lista. Categoría/estado nativos antes del límite, hijos delimitados por producto con parámetros bound. Verifica índices, volumen y tiempos; el límite no garantiza rapidez ni resultados completos. No se cambia el plan de paquetes existentes.\n\nPRECISIÓN: precios unitarios, costes fijos, cantidades de umbral, dimensiones y coeficientes se presentan como texto de origen para no perder decimales por el formato numérico de dos cifras de Cifru 1.1. Conservan el punto decimal de origen, sin conversión o redondeo de presentación; filtros locales automáticos de esos campos son de texto, no cálculos monetarios.\n\nDATOS ACTUALES: maestro, proveedor-producto y producto-centro no son históricos. Precio base de compra por PUU del maestro; CPRAMT fijo por PUU del registro correspondiente, CPRCOE y estructuras nativos, sin coste real, precio efectivo por proveedor o conversiones calculadas. Las unidades y factores son actuales, no unidades históricas de pedidos/facturas. Stock de seguridad/umbral/máximo/lotes configurados se contextualizan en STU actual; no existencias, disponible, pedido sugerido ni cálculo MRP. Centro no equivale a depósito. DAYCOV son semanas; PRPLTI días laborables; horizontes y recontrol conservan sus unidades.\n\nMONEDA POR VERIFICAR: importes maestros y CPRAMT de proveedor están almacenados en moneda del dossier, no en la moneda convertida que presenta la interfaz según perfil del usuario. SYSCUR es el parámetro documentado de carpeta. Su lectura candidata de ADOVAL con CMP/FCY vacíos es una inferencia de implementación del nivel sin código, no prueba del almacenamiento instalado. El código está SIEMPRE marcado para validar con el administrador; verifica valor, codificación y nivel antes de interpretar importes. Ausencia/ambigüedad deja moneda no confirmada; nunca se usa moneda de empresa/proveedor ni EUR por defecto. La consulta solo solicita SYSCUR, no otros parámetros. Sin conversión FX, suma entre monedas o valoración contable.\n\nPROVEEDORES Y CALIDAD: prioridad cero es máxima; flags por defecto/contramarca se muestran como almacenados, no se recomputa o recomienda proveedor. DOUFLG conserva menú 516 No/Aviso/Bloqueante. Un párrafo funcional inglés/francés invierte el comportamiento de Aviso/Bloqueante: no se deduce elegibilidad a partir de él. Compra mínima en PUU específica; factor compra/stock y embalaje/compra separados. Calidad, grado, frecuencia y regla de conciliación nativos, no aprobación de factura o solvencia inferidas. Códigos desconocidos, signos, cero y ausencias conservados.\n\nIDENTIDAD: ITMREF; producto+proveedor; producto+centro. Dos listas independientes sin join que multiplique proveedores por centros. Nombres actuales de BPARTNER/FACILITY por sus claves únicas; un maestro ausente no elimina la relación. Solo claves técnicas compuestas ocultas; códigos comerciales útiles visibles. No se inventan BASPRI/MINPRI/THEPRI, PHYSTO, ITMFACILIT.ITMSTA/STU ni dimensiones de campos opcionales NUC/STI/ANA/ECC/DEB/WRH/PJM a partir de nombres de pantalla.\n\nREQUISITO: Sage X3 v12 SQL Server, carpeta y permisos confirmados por administrador. Usuario SELECT dedicado con esquema predeterminado de la carpeta, sin sa/sysadmin. Guard OBJECT_ID para los seis objetos, sin resolución dbo/guest/sys/INFORMATION_SCHEMA. SQL directo no hereda roles/centros X3; filtros no son ACL. Autoriza solo información pertinente, incluida lectura del parámetro monetario. Verifica versión, tablas/tipos, monedas, permisos y vista previa real; prueba vacía no certifica compatibilidad. Diccionario público/regla campo_indice no son DDL ni esquema instalado. No se escribe, crean objetos o cambian permisos en el ERP.\n\nCapturas nativas Cifru con transporte sintético y datos DEMO íntegramente ficticios. Máximo ocho imágenes representativas, no todas las continuaciones; no se eliminan campos útiles para la galería. Sin servidor, credenciales ni datos reales. No validado en X3/SQL Server real, no oficial ni afiliado a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMMASTER.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMBPS.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/ITMFACILIT.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESITM.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESITF.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/BPARTNER.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/ADOVAL.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESADS.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/ADPVAL.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESADP.htm\nhttps://online-help.sagex3.com/erp/12/fr-fr/Content/FCT/GESITM.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/MEN00210.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00211.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00212.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00215.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00216.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00217.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00246.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00250.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00275.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00291.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00297.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00516.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00727.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02759.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02711.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "F9275EAC-2C42-59F2-84F4-2EDAA51C090B",
"rootButtonCount": 1,
"summary": "Categoría y estado; ficha completa, unidades, compras/costes, proveedores y planificación por centro a petición.",
"tags": [
"Sage X3",
"SQL Server",
"Productos",
"Compras",
"Proveedores",
"Almacén",
"Pro"
],
"title": "Catálogo de productos, proveedores y centros — Pro"
}
}