Pedidos de venta, precios y entregas — Pro
Periodo y empresa; ficha completa del pedido, importes y estados separados, precios y cantidades/entregas a petición.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para ventas, atención al cliente, logística y dirección: elige periodo y empresa y consulta pedidos normales, cliente y referencia, centros, importes, moneda, fechas y estados separados de pedido, asignación, entrega, facturación, crédito y aprobación. La ficha incluye últimos documentos y cierre. Dos sub-botones a petición abren los precios por producto con unidades, conversión y vigencia, y las cantidades de cada entrega: pedidas, entregadas, asignadas, facturadas, preparadas y en falta, tanto en UM venta como en UM stock.
¿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 a petición, SELECT explícito y sin actualizaciones programadas. Hasta 2.000 filas por lista; periodo/empresa se eligen con filtros nativos antes del límite. Cada sub-botón está delimitado por pedido y empresa. Revisa índices, tiempos y truncamiento: un límite o filtro no garantiza una consulta barata ni resultados completos. No se modifican las configuraciones Free/Starter existentes.
PEDIDOS NORMALES: solo categoría 1, no contratos, préstamos ni facturación directa. Los estados abierto/cerrado, entregado y facturado no significan pagado. Firma no gestionada no se presenta como aprobada. Los códigos no reconocidos siguen visibles. ORDNOT/ORDATI son importes de líneas; ORDINVNOT/ORDINVATI son la valoración con elementos de facturación. Se muestran los valores nativos con CUR del pedido, sin sumarlos entre monedas ni calcular impuestos, saldo, margen, pagos o deuda. Los precios son por UM de venta; PRITYP indica su base fiscal.
LÍNEAS SIN DUPLICACIONES: precios y cantidades se consultan por separado. La clave de precio es SOHNUM+SOPLIN+SOPSEQ; la de cantidad SOHNUM+SOPLIN+SOQSEQ. SOPSEQ no es SOQSEQ y pedido+línea no es una clave única de precio. Se conservan todas las ocurrencias, no se elige un precio efectivo por vigencia ni se multiplica cantidad por un precio arbitrario. Los números de línea son útiles; claves técnicas y secuencias permanecen ocultas. Las cantidades se mantienen con signo, ceros y ausencias.
UNIDADES: para cada pedido/línea/empresa/producto, las UM solo se muestran cuando todas sus fichas de precio contienen el mismo código no vacío. Una ficha ausente, unidad vacía o discrepancia mantiene la UM sin confirmar. Este contexto no asigna una versión de precio a una entrega, no usa el maestro actual como unidad histórica ni convierte/recalcula cantidades o stock disponible. Revisa los casos no confirmados en X3.
REQUISITO: Sage X3 v12 SQL Server, carpeta empresarial y permisos confirmados por el administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta y SELECT solo sobre datos autorizados; no sa/sysadmin. OBJECT_ID rechaza resolución en dbo/guest/sys/INFORMATION_SCHEMA; no se presupone dbo/SEED ni se descubren objetos automáticamente. Los filtros no son control de acceso; SQL no hereda los permisos de rol/centro de X3. Comprueba carpeta, tipos, vista previa e índices al importar; una prueba vacía no certifica compatibilidad. Requiere CONCAT y las funciones SQL utilizadas. Diccionario, claves, menús y nombres según regla oficial campo_indice, no DDL ni metadatos instalados.
Capturas nativas Cifru con datos DEMO ficticios y transporte sintético; no validadas en Sage X3/SQL Server reales. Galería de máximo ocho pantallas representativas; las fichas extensas pueden requerir desplazamiento. Sin servidor, credenciales o filas reales. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDER.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDERP.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDERQ.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00243.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00279.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00280.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00412.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00415.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00416.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00417.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00418.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00419.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00423.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00439.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00491.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESSOH.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Pedidos de venta
- Details: Precios de las líneas
- Details: Cantidades y entregas
- Sub-button: Precios de las líneas
- Sub-button: Cantidades y entregas
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(h.SOHNUM_0) AS SOHNUM_0, RTRIM(h.SOHTYP_0) AS SOHTYP_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.SALFCY_0) AS SALFCY_0, RTRIM(h.STOFCY_0) AS STOFCY_0, h.ORDDAT_0, RTRIM(h.BPCORD_0) AS BPCORD_0, RTRIM(h.BPCNAM_0) AS BPCNAM_0, RTRIM(h.BPCNAM_1) AS BPCNAM_1, RTRIM(h.BPCINV_0) AS BPCINV_0, RTRIM(h.CUSORDREF_0) AS CUSORDREF_0, RTRIM(h.CUR_0) AS CUR_0, CASE WHEN h.PRITYP_0=1 THEN N'Sin impuestos' WHEN h.PRITYP_0=2 THEN N'Con impuestos' WHEN h.PRITYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PRITYP_0) END AS PRITYP_0, h.ORDNOT_0, h.ORDATI_0, h.ORDINVNOT_0, h.ORDINVATI_0, h.DEMDLVDAT_0, h.SHIDAT_0, CASE WHEN h.ORDSTA_0=1 THEN N'Abierto' WHEN h.ORDSTA_0=2 THEN N'Cerrado' WHEN h.ORDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.ORDSTA_0) END AS ORDSTA_0, CASE WHEN h.ALLSTA_0=1 THEN N'Sin asignar' WHEN h.ALLSTA_0=2 THEN N'Asignado en parte' WHEN h.ALLSTA_0=3 THEN N'Asignado' WHEN h.ALLSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.ALLSTA_0) END AS ALLSTA_0, CASE WHEN h.DLVSTA_0=1 THEN N'Sin entregar' WHEN h.DLVSTA_0=2 THEN N'Entregado en parte' WHEN h.DLVSTA_0=3 THEN N'Entregado' WHEN h.DLVSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.DLVSTA_0) END AS DLVSTA_0, CASE WHEN h.INVSTA_0=1 THEN N'Sin facturar' WHEN h.INVSTA_0=2 THEN N'Facturado en parte' WHEN h.INVSTA_0=3 THEN N'Facturado' WHEN h.INVSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVSTA_0) END AS INVSTA_0, CASE WHEN h.HLDSTA_0=1 THEN N'Sin bloqueo' WHEN h.HLDSTA_0=2 THEN N'Bloqueado' WHEN h.HLDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.HLDSTA_0) END AS HLDSTA_0, CASE WHEN h.CDTSTA_0=1 THEN N'Correcta' WHEN h.CDTSTA_0=2 THEN N'Bloqueado' WHEN h.CDTSTA_0=3 THEN N'Límite superado' WHEN h.CDTSTA_0=4 THEN N'Anticipo no pagado' WHEN h.CDTSTA_0=5 THEN N'Tarjeta de crédito' WHEN h.CDTSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CDTSTA_0) END AS CDTSTA_0, CASE WHEN h.APPFLG_0=1 THEN N'Sin firma' WHEN h.APPFLG_0=2 THEN N'Firma parcial' WHEN h.APPFLG_0=3 THEN N'Firma completa' WHEN h.APPFLG_0=4 THEN N'No gestionada' WHEN h.APPFLG_0=5 THEN N'Automática' WHEN h.APPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.APPFLG_0) END AS APPFLG_0, h.LINNBR_0, RTRIM(h.LASDLVNUM_0) AS LASDLVNUM_0, h.LASDLVDAT_0, RTRIM(h.LASINVNUM_0) AS LASINVNUM_0, h.LASINVDAT_0, h.CCLDAT_0, RTRIM(h.CCLREN_0) AS CCLREN_0, CASE WHEN h.SOHCAT_0=1 THEN N'Normal' WHEN h.SOHCAT_0=2 THEN N'Préstamo' WHEN h.SOHCAT_0=3 THEN N'Facturación directa' WHEN h.SOHCAT_0=4 THEN N'Contrato' WHEN h.SOHCAT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.SOHCAT_0) END AS SOHCAT_0 FROM SORDER h WHERE h.SOHCAT_0=1 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(RTRIM(p.SOHNUM_0)),N':',RTRIM(p.SOHNUM_0),N':',p.SOPLIN_0,N':',p.SOPSEQ_0) AS PriceKey, RTRIM(p.SOHNUM_0) AS SOHNUM_0, p.SOPLIN_0, p.SOPSEQ_0, RTRIM(p.CPY_0) AS CPY_0, RTRIM(p.ITMREF_0) AS ITMREF_0, RTRIM(p.ITMDES_0) AS ITMDES_0, RTRIM(p.ITMDES1_0) AS ITMDES1_0, RTRIM(p.ITMREFBPC_0) AS ITMREFBPC_0, RTRIM(p.SAU_0) AS SAU_0, RTRIM(p.STU_0) AS STU_0, p.SAUSTUCOE_0, p.GROPRI_0, p.NETPRI_0, p.NETPRINOT_0, p.NETPRIATI_0, p.STRDAT_0, p.ENDDAT_0, CASE WHEN p.SOQSTA_0=1 THEN N'Pendiente' WHEN p.SOQSTA_0=2 THEN N'Retrasada' WHEN p.SOQSTA_0=3 THEN N'Cerrada' WHEN p.SOQSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SOQSTA_0) END AS SOQSTA_0, CASE WHEN p.LINTYP_0=1 THEN N'Normal' WHEN p.LINTYP_0=2 THEN N'Kit fijo' WHEN p.LINTYP_0=3 THEN N'Componente de kit' WHEN p.LINTYP_0=4 THEN N'Opción de kit' WHEN p.LINTYP_0=5 THEN N'Variante de kit' WHEN p.LINTYP_0=6 THEN N'Kit flexible' WHEN p.LINTYP_0=7 THEN N'Componente de estructura' WHEN p.LINTYP_0=8 THEN N'Opción de estructura' WHEN p.LINTYP_0=9 THEN N'Variante de estructura' WHEN p.LINTYP_0=10 THEN N'Subcontratado' WHEN p.LINTYP_0=11 THEN N'Servicio' WHEN p.LINTYP_0=12 THEN N'Material suministrado' WHEN p.LINTYP_0=13 THEN N'Servicio a tanto alzado' WHEN p.LINTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.LINTYP_0) END AS LINTYP_0, CASE WHEN p.FOCFLG_0=1 THEN N'No' WHEN p.FOCFLG_0=2 THEN N'Origen' WHEN p.FOCFLG_0=3 THEN N'Sí' WHEN p.FOCFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.FOCFLG_0) END AS FOCFLG_0, h.CUR_0, CASE WHEN h.PRITYP_0=1 THEN N'Sin impuestos' WHEN h.PRITYP_0=2 THEN N'Con impuestos' WHEN h.PRITYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PRITYP_0) END AS PRITYP_0 FROM SORDERP p JOIN SORDER h ON h.SOHNUM_0=p.SOHNUM_0 AND h.CPY_0=p.CPY_0 WHERE h.SOHCAT_0=1 AND h.SOHNUM_0=:order AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(RTRIM(q.SOHNUM_0)),N':',RTRIM(q.SOHNUM_0),N':',q.SOPLIN_0,N':',q.SOQSEQ_0) AS QuantityKey, RTRIM(q.SOHNUM_0) AS SOHNUM_0, q.SOPLIN_0, q.SOQSEQ_0, RTRIM(q.CPY_0) AS CPY_0, RTRIM(q.ITMREF_0) AS ITMREF_0, q.QTY_0, q.QTYSTU_0, q.DLVQTY_0, q.DLVQTYSTU_0, q.ALLQTY_0, q.ALLQTYSTU_0, q.INVQTY_0, q.INVQTYSTU_0, q.PREQTY_0, q.PREQTYSTU_0, q.SHTQTY_0, q.SHTQTYSTU_0, q.DEMDLVDAT_0, q.EXTDLVDAT_0, q.SHIDAT_0, CASE WHEN q.SOQSTA_0=1 THEN N'Pendiente' WHEN q.SOQSTA_0=2 THEN N'Retrasada' WHEN q.SOQSTA_0=3 THEN N'Cerrada' WHEN q.SOQSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.SOQSTA_0) END AS SOQSTA_0, RTRIM(q.STOFCY_0) AS STOFCY_0, q.CCLDAT_0, RTRIM(q.CCLREN_0) AS CCLREN_0, RTRIM(q.BPAADD_0) AS BPAADD_0, u.SalesUnit, u.StockUnit, CASE WHEN u.SalesUnit IS NOT NULL AND u.StockUnit IS NOT NULL THEN N'UM coincidentes en todas las fichas de línea' ELSE N'UM sin confirmar: falta ficha o hay valores distintos' END AS UnitContext FROM SORDERQ q JOIN SORDER h ON h.SOHNUM_0=q.SOHNUM_0 AND h.CPY_0=q.CPY_0 LEFT JOIN (SELECT p.SOHNUM_0,p.SOPLIN_0,p.CPY_0,p.ITMREF_0,CASE WHEN COUNT(NULLIF(RTRIM(p.SAU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(p.SAU_0),N''))=1 THEN MIN(NULLIF(RTRIM(p.SAU_0),N'')) ELSE NULL END AS SalesUnit,CASE WHEN COUNT(NULLIF(RTRIM(p.STU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(p.STU_0),N''))=1 THEN MIN(NULLIF(RTRIM(p.STU_0),N'')) ELSE NULL END AS StockUnit FROM SORDERP p WHERE p.SOHNUM_0=:order AND p.CPY_0=:company GROUP BY p.SOHNUM_0,p.SOPLIN_0,p.CPY_0,p.ITMREF_0) u ON u.SOHNUM_0=q.SOHNUM_0 AND u.SOPLIN_0=q.SOPLIN_0 AND u.CPY_0=q.CPY_0 AND u.ITMREF_0=q.ITMREF_0 WHERE h.SOHCAT_0=1 AND h.SOHNUM_0=:order AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage X3 — SQL Server, carpeta autorizada",
"id": "737F1CFB-9102-515A-AAF5-0CBFE0ED711B",
"kind": "sqlServer",
"requiredObjects": [
"SORDER",
"SORDERP",
"SORDERQ"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "1299A0E8-4059-5544-B570-2D5CB0CD0F4B",
"key": "ORDDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "E23627B5-E6D0-57ED-BAA5-A01E34C24FCB",
"key": "SOHNUM_0",
"type": "text"
}
],
"id": "9F37688F-91F0-51E8-8650-4A1FC3E704F1",
"mappings": [
{
"commonFieldKey": "",
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SALFCY_0",
"label": "Centro de ventas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SALFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDDAT_0",
"label": "Fecha de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPCORD_0",
"label": "Cliente (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPCORD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPCNAM_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPCNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPCNAM_1",
"label": "Cliente, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPCNAM_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPCINV_0",
"label": "Cliente facturado (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPCINV_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUSORDREF_0",
"label": "Referencia del cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUSORDREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PRITYP_0",
"label": "Base fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRITYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDNOT_0",
"label": "Importe líneas sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDNOT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDATI_0",
"label": "Importe líneas con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDINVNOT_0",
"label": "Total valorado sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDINVNOT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDINVATI_0",
"label": "Total valorado con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDINVATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DEMDLVDAT_0",
"label": "Entrega solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEMDLVDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIDAT_0",
"label": "Expedición prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHIDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDSTA_0",
"label": "Estado del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ALLSTA_0",
"label": "Asignación de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ALLSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DLVSTA_0",
"label": "Estado de entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DLVSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVSTA_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HLDSTA_0",
"label": "Bloqueo del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HLDSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CDTSTA_0",
"label": "Situación de crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CDTSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "APPFLG_0",
"label": "Firma / aprobación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "APPFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINNBR_0",
"label": "Número de líneas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINNBR_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LASDLVNUM_0",
"label": "Última entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LASDLVNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LASDLVDAT_0",
"label": "Fecha última entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LASDLVDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LASINVNUM_0",
"label": "Última factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LASINVNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LASINVDAT_0",
"label": "Fecha última factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LASINVDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CCLDAT_0",
"label": "Fecha de cierre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CCLDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CCLREN_0",
"label": "Motivo de cierre (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CCLREN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOHCAT_0",
"label": "Categoría del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHCAT_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pedidos de venta",
"primaryKey": "SOHNUM_0",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SOHNUM_0",
"SOHTYP_0",
"CPY_0",
"SALFCY_0",
"STOFCY_0",
"ORDDAT_0",
"BPCORD_0",
"BPCNAM_0",
"BPCNAM_1",
"BPCINV_0",
"CUSORDREF_0",
"CUR_0",
"PRITYP_0",
"ORDNOT_0",
"ORDATI_0",
"ORDINVNOT_0",
"ORDINVATI_0",
"DEMDLVDAT_0",
"SHIDAT_0",
"ORDSTA_0",
"ALLSTA_0",
"DLVSTA_0",
"INVSTA_0",
"HLDSTA_0",
"CDTSTA_0",
"APPFLG_0",
"LINNBR_0",
"LASDLVNUM_0",
"LASDLVDAT_0",
"LASINVNUM_0",
"LASINVDAT_0",
"CCLDAT_0",
"CCLREN_0",
"SOHCAT_0"
],
"sourceID": "737F1CFB-9102-515A-AAF5-0CBFE0ED711B",
"sqlQuery": "SELECT RTRIM(h.SOHNUM_0) AS SOHNUM_0, RTRIM(h.SOHTYP_0) AS SOHTYP_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.SALFCY_0) AS SALFCY_0, RTRIM(h.STOFCY_0) AS STOFCY_0, h.ORDDAT_0, RTRIM(h.BPCORD_0) AS BPCORD_0, RTRIM(h.BPCNAM_0) AS BPCNAM_0, RTRIM(h.BPCNAM_1) AS BPCNAM_1, RTRIM(h.BPCINV_0) AS BPCINV_0, RTRIM(h.CUSORDREF_0) AS CUSORDREF_0, RTRIM(h.CUR_0) AS CUR_0, CASE WHEN h.PRITYP_0=1 THEN N'Sin impuestos' WHEN h.PRITYP_0=2 THEN N'Con impuestos' WHEN h.PRITYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PRITYP_0) END AS PRITYP_0, h.ORDNOT_0, h.ORDATI_0, h.ORDINVNOT_0, h.ORDINVATI_0, h.DEMDLVDAT_0, h.SHIDAT_0, CASE WHEN h.ORDSTA_0=1 THEN N'Abierto' WHEN h.ORDSTA_0=2 THEN N'Cerrado' WHEN h.ORDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.ORDSTA_0) END AS ORDSTA_0, CASE WHEN h.ALLSTA_0=1 THEN N'Sin asignar' WHEN h.ALLSTA_0=2 THEN N'Asignado en parte' WHEN h.ALLSTA_0=3 THEN N'Asignado' WHEN h.ALLSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.ALLSTA_0) END AS ALLSTA_0, CASE WHEN h.DLVSTA_0=1 THEN N'Sin entregar' WHEN h.DLVSTA_0=2 THEN N'Entregado en parte' WHEN h.DLVSTA_0=3 THEN N'Entregado' WHEN h.DLVSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.DLVSTA_0) END AS DLVSTA_0, CASE WHEN h.INVSTA_0=1 THEN N'Sin facturar' WHEN h.INVSTA_0=2 THEN N'Facturado en parte' WHEN h.INVSTA_0=3 THEN N'Facturado' WHEN h.INVSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVSTA_0) END AS INVSTA_0, CASE WHEN h.HLDSTA_0=1 THEN N'Sin bloqueo' WHEN h.HLDSTA_0=2 THEN N'Bloqueado' WHEN h.HLDSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.HLDSTA_0) END AS HLDSTA_0, CASE WHEN h.CDTSTA_0=1 THEN N'Correcta' WHEN h.CDTSTA_0=2 THEN N'Bloqueado' WHEN h.CDTSTA_0=3 THEN N'Límite superado' WHEN h.CDTSTA_0=4 THEN N'Anticipo no pagado' WHEN h.CDTSTA_0=5 THEN N'Tarjeta de crédito' WHEN h.CDTSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CDTSTA_0) END AS CDTSTA_0, CASE WHEN h.APPFLG_0=1 THEN N'Sin firma' WHEN h.APPFLG_0=2 THEN N'Firma parcial' WHEN h.APPFLG_0=3 THEN N'Firma completa' WHEN h.APPFLG_0=4 THEN N'No gestionada' WHEN h.APPFLG_0=5 THEN N'Automática' WHEN h.APPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.APPFLG_0) END AS APPFLG_0, h.LINNBR_0, RTRIM(h.LASDLVNUM_0) AS LASDLVNUM_0, h.LASDLVDAT_0, RTRIM(h.LASINVNUM_0) AS LASINVNUM_0, h.LASINVDAT_0, h.CCLDAT_0, RTRIM(h.CCLREN_0) AS CCLREN_0, CASE WHEN h.SOHCAT_0=1 THEN N'Normal' WHEN h.SOHCAT_0=2 THEN N'Préstamo' WHEN h.SOHCAT_0=3 THEN N'Facturación directa' WHEN h.SOHCAT_0=4 THEN N'Contrato' WHEN h.SOHCAT_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.SOHCAT_0) END AS SOHCAT_0 FROM SORDER h WHERE h.SOHCAT_0=1 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "DE24B91F-B78E-5961-BA8F-75FA0E059AE8",
"key": "SOPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "43DF78B8-0ED3-5EF9-AF3B-9424050B136F",
"key": "SOPSEQ_0",
"type": "number"
}
],
"id": "8387EFA4-2019-54B0-AE84-0E6B364ED1D2",
"mappings": [
{
"commonFieldKey": "",
"key": "PriceKey",
"label": "Clave interna completa de precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOPLIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SOPSEQ_0",
"label": "Secuencia interna de precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOPSEQ_0",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"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": "ITMDES_0",
"label": "Producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDES_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMDES1_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMDES1_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMREFBPC_0",
"label": "Referencia del cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREFBPC_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAU_0",
"label": "UM de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SAU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STU_0",
"label": "UM de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SAUSTUCOE_0",
"label": "Conversión venta / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SAUSTUCOE_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "GROPRI_0",
"label": "Precio bruto por UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GROPRI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NETPRI_0",
"label": "Precio neto por UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRINOT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NETPRIATI_0",
"label": "Precio neto con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRIATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STRDAT_0",
"label": "Inicio de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STRDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ENDDAT_0",
"label": "Fin de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ENDDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOQSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LINTYP_0",
"label": "Tipo de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FOCFLG_0",
"label": "Artículo gratuito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FOCFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PRITYP_0",
"label": "Base fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRITYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Precios de las líneas",
"primaryKey": "PriceKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SOHNUM_0",
"id": "4228F035-741D-5434-A5B4-428F0C3C242E",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "F9F05DA9-5712-55C8-99CC-908FE5DDD1CC",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SOHNUM_0",
"SOPLIN_0",
"CPY_0",
"ITMREF_0",
"ITMDES_0",
"ITMDES1_0",
"ITMREFBPC_0",
"SAU_0",
"STU_0",
"SAUSTUCOE_0",
"GROPRI_0",
"NETPRI_0",
"NETPRINOT_0",
"NETPRIATI_0",
"STRDAT_0",
"ENDDAT_0",
"SOQSTA_0",
"LINTYP_0",
"FOCFLG_0",
"CUR_0",
"PRITYP_0"
],
"sourceID": "737F1CFB-9102-515A-AAF5-0CBFE0ED711B",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(p.SOHNUM_0)),N':',RTRIM(p.SOHNUM_0),N':',p.SOPLIN_0,N':',p.SOPSEQ_0) AS PriceKey, RTRIM(p.SOHNUM_0) AS SOHNUM_0, p.SOPLIN_0, p.SOPSEQ_0, RTRIM(p.CPY_0) AS CPY_0, RTRIM(p.ITMREF_0) AS ITMREF_0, RTRIM(p.ITMDES_0) AS ITMDES_0, RTRIM(p.ITMDES1_0) AS ITMDES1_0, RTRIM(p.ITMREFBPC_0) AS ITMREFBPC_0, RTRIM(p.SAU_0) AS SAU_0, RTRIM(p.STU_0) AS STU_0, p.SAUSTUCOE_0, p.GROPRI_0, p.NETPRI_0, p.NETPRINOT_0, p.NETPRIATI_0, p.STRDAT_0, p.ENDDAT_0, CASE WHEN p.SOQSTA_0=1 THEN N'Pendiente' WHEN p.SOQSTA_0=2 THEN N'Retrasada' WHEN p.SOQSTA_0=3 THEN N'Cerrada' WHEN p.SOQSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.SOQSTA_0) END AS SOQSTA_0, CASE WHEN p.LINTYP_0=1 THEN N'Normal' WHEN p.LINTYP_0=2 THEN N'Kit fijo' WHEN p.LINTYP_0=3 THEN N'Componente de kit' WHEN p.LINTYP_0=4 THEN N'Opción de kit' WHEN p.LINTYP_0=5 THEN N'Variante de kit' WHEN p.LINTYP_0=6 THEN N'Kit flexible' WHEN p.LINTYP_0=7 THEN N'Componente de estructura' WHEN p.LINTYP_0=8 THEN N'Opción de estructura' WHEN p.LINTYP_0=9 THEN N'Variante de estructura' WHEN p.LINTYP_0=10 THEN N'Subcontratado' WHEN p.LINTYP_0=11 THEN N'Servicio' WHEN p.LINTYP_0=12 THEN N'Material suministrado' WHEN p.LINTYP_0=13 THEN N'Servicio a tanto alzado' WHEN p.LINTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.LINTYP_0) END AS LINTYP_0, CASE WHEN p.FOCFLG_0=1 THEN N'No' WHEN p.FOCFLG_0=2 THEN N'Origen' WHEN p.FOCFLG_0=3 THEN N'Sí' WHEN p.FOCFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.FOCFLG_0) END AS FOCFLG_0, h.CUR_0, CASE WHEN h.PRITYP_0=1 THEN N'Sin impuestos' WHEN h.PRITYP_0=2 THEN N'Con impuestos' WHEN h.PRITYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PRITYP_0) END AS PRITYP_0 FROM SORDERP p JOIN SORDER h ON h.SOHNUM_0=p.SOHNUM_0 AND h.CPY_0=p.CPY_0 WHERE h.SOHCAT_0=1 AND h.SOHNUM_0=:order AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "DE24B91F-B78E-5961-BA8F-75FA0E059AE8",
"key": "SOPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "D469B452-6883-5928-8487-4A6F1FAAA3D4",
"key": "SOQSEQ_0",
"type": "number"
}
],
"id": "A35B3009-0714-55DF-ABFD-334F96411073",
"mappings": [
{
"commonFieldKey": "",
"key": "QuantityKey",
"label": "Clave interna completa de cantidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOPLIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SOQSEQ_0",
"label": "Secuencia interna de cantidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOQSEQ_0",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"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": "QTY_0",
"label": "Pedido en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QTYSTU_0",
"label": "Pedido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DLVQTY_0",
"label": "Entregado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DLVQTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DLVQTYSTU_0",
"label": "Entregado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DLVQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ALLQTY_0",
"label": "Asignado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ALLQTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ALLQTYSTU_0",
"label": "Asignado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ALLQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVQTY_0",
"label": "Facturado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVQTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVQTYSTU_0",
"label": "Facturado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PREQTY_0",
"label": "Preparado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PREQTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PREQTYSTU_0",
"label": "Preparado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PREQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHTQTY_0",
"label": "Falta en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHTQTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHTQTYSTU_0",
"label": "Falta en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHTQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEMDLVDAT_0",
"label": "Entrega solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEMDLVDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXTDLVDAT_0",
"label": "Entrega prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTDLVDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIDAT_0",
"label": "Expedición prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHIDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOQSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CCLDAT_0",
"label": "Fecha de cierre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CCLDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CCLREN_0",
"label": "Motivo de cierre (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CCLREN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPAADD_0",
"label": "Dirección de entrega (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPAADD_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesUnit",
"label": "UM venta coincidente en fichas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockUnit",
"label": "UM stock coincidente en fichas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitContext",
"label": "Comprobación de unidades",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Cantidades y entregas",
"primaryKey": "QuantityKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SOHNUM_0",
"id": "4228F035-741D-5434-A5B4-428F0C3C242E",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "F9F05DA9-5712-55C8-99CC-908FE5DDD1CC",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SOHNUM_0",
"SOPLIN_0",
"CPY_0",
"ITMREF_0",
"QTY_0",
"QTYSTU_0",
"DLVQTY_0",
"DLVQTYSTU_0",
"ALLQTY_0",
"ALLQTYSTU_0",
"INVQTY_0",
"INVQTYSTU_0",
"PREQTY_0",
"PREQTYSTU_0",
"SHTQTY_0",
"SHTQTYSTU_0",
"DEMDLVDAT_0",
"EXTDLVDAT_0",
"SHIDAT_0",
"SOQSTA_0",
"STOFCY_0",
"CCLDAT_0",
"CCLREN_0",
"BPAADD_0",
"SalesUnit",
"StockUnit",
"UnitContext"
],
"sourceID": "737F1CFB-9102-515A-AAF5-0CBFE0ED711B",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(q.SOHNUM_0)),N':',RTRIM(q.SOHNUM_0),N':',q.SOPLIN_0,N':',q.SOQSEQ_0) AS QuantityKey, RTRIM(q.SOHNUM_0) AS SOHNUM_0, q.SOPLIN_0, q.SOQSEQ_0, RTRIM(q.CPY_0) AS CPY_0, RTRIM(q.ITMREF_0) AS ITMREF_0, q.QTY_0, q.QTYSTU_0, q.DLVQTY_0, q.DLVQTYSTU_0, q.ALLQTY_0, q.ALLQTYSTU_0, q.INVQTY_0, q.INVQTYSTU_0, q.PREQTY_0, q.PREQTYSTU_0, q.SHTQTY_0, q.SHTQTYSTU_0, q.DEMDLVDAT_0, q.EXTDLVDAT_0, q.SHIDAT_0, CASE WHEN q.SOQSTA_0=1 THEN N'Pendiente' WHEN q.SOQSTA_0=2 THEN N'Retrasada' WHEN q.SOQSTA_0=3 THEN N'Cerrada' WHEN q.SOQSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.SOQSTA_0) END AS SOQSTA_0, RTRIM(q.STOFCY_0) AS STOFCY_0, q.CCLDAT_0, RTRIM(q.CCLREN_0) AS CCLREN_0, RTRIM(q.BPAADD_0) AS BPAADD_0, u.SalesUnit, u.StockUnit, CASE WHEN u.SalesUnit IS NOT NULL AND u.StockUnit IS NOT NULL THEN N'UM coincidentes en todas las fichas de línea' ELSE N'UM sin confirmar: falta ficha o hay valores distintos' END AS UnitContext FROM SORDERQ q JOIN SORDER h ON h.SOHNUM_0=q.SOHNUM_0 AND h.CPY_0=q.CPY_0 LEFT JOIN (SELECT p.SOHNUM_0,p.SOPLIN_0,p.CPY_0,p.ITMREF_0,CASE WHEN COUNT(NULLIF(RTRIM(p.SAU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(p.SAU_0),N''))=1 THEN MIN(NULLIF(RTRIM(p.SAU_0),N'')) ELSE NULL END AS SalesUnit,CASE WHEN COUNT(NULLIF(RTRIM(p.STU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(p.STU_0),N''))=1 THEN MIN(NULLIF(RTRIM(p.STU_0),N'')) ELSE NULL END AS StockUnit FROM SORDERP p WHERE p.SOHNUM_0=:order AND p.CPY_0=:company GROUP BY p.SOHNUM_0,p.SOPLIN_0,p.CPY_0,p.ITMREF_0) u ON u.SOHNUM_0=q.SOHNUM_0 AND u.SOPLIN_0=q.SOPLIN_0 AND u.CPY_0=q.CPY_0 AND u.ITMREF_0=q.ITMREF_0 WHERE h.SOHCAT_0=1 AND h.SOHNUM_0=:order AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDER',N'U') AND OBJECT_ID(N'SORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERP',N'U') AND OBJECT_ID(N'SORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SORDERQ',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "FD9F2BF2-B1E6-5B3F-873B-5DD5E9DFB61C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DC16FCD2-32E6-5166-B874-82292C40FB71",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8387EFA4-2019-54B0-AE84-0E6B364ED1D2",
"title": "Precios de las líneas",
"urlKey": ""
},
{
"id": "E77B55CF-A3A9-53E5-A691-8A1DFBD5DBBC",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "0F133E8F-4350-56CF-9CC3-F49E49DCA689",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A35B3009-0714-55DF-ABFD-334F96411073",
"title": "Cantidades y entregas",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDDAT_0",
"label": "Fecha de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDINVATI_0",
"label": "Total valorado con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDSTA_0",
"label": "Estado del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DLVSTA_0",
"label": "Estado de entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INVSTA_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "9F37688F-91F0-51E8-8650-4A1FC3E704F1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "SOHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "SOHCAT_0",
"label": "Categoría del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPCNAM_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPCNAM_1",
"label": "Cliente, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPCORD_0",
"label": "Cliente (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPCINV_0",
"label": "Cliente facturado (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "CUSORDREF_0",
"label": "Referencia del cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y cliente",
"detailRole": "information",
"isVisible": true,
"key": "LINNBR_0",
"label": "Número de líneas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "SALFCY_0",
"label": "Centro de ventas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "ORDDAT_0",
"label": "Fecha de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "DEMDLVDAT_0",
"label": "Entrega solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa y fechas",
"detailRole": "information",
"isVisible": true,
"key": "SHIDAT_0",
"label": "Expedición prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "PRITYP_0",
"label": "Base fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "ORDNOT_0",
"label": "Importe líneas sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "ORDATI_0",
"label": "Importe líneas con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "ORDINVNOT_0",
"label": "Total valorado sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "ORDINVATI_0",
"label": "Total valorado con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "ORDSTA_0",
"label": "Estado del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "ALLSTA_0",
"label": "Asignación de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "DLVSTA_0",
"label": "Estado de entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "INVSTA_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "HLDSTA_0",
"label": "Bloqueo del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "CDTSTA_0",
"label": "Situación de crédito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados separados",
"detailRole": "information",
"isVisible": true,
"key": "APPFLG_0",
"label": "Firma / aprobación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "LASDLVNUM_0",
"label": "Última entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "LASDLVDAT_0",
"label": "Fecha última entrega",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "LASINVNUM_0",
"label": "Última factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "LASINVDAT_0",
"label": "Fecha última factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "CCLDAT_0",
"label": "Fecha de cierre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Últimos documentos y cierre",
"detailRole": "information",
"isVisible": true,
"key": "CCLREN_0",
"label": "Motivo de cierre (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "60BDA16C-8A81-59B8-B126-C835B69F100A",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "F5C9D0CA-DECA-5410-A9DB-FD4CFB5BC3C5",
"includeAllOption": false,
"key": "ORDDAT_0",
"title": "Periodo del pedido",
"type": "date"
},
{
"id": "41FD5B3B-9362-501B-96F5-252D4324538A",
"includeAllOption": false,
"key": "CPY_0",
"title": "Empresa",
"type": "text"
},
{
"id": "372284C9-D1EA-574E-AE84-426695FBC7E5",
"includeAllOption": true,
"key": "ORDSTA_0",
"title": "Estado del pedido",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "1299A0E8-4059-5544-B570-2D5CB0CD0F4B",
"key": "ORDDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "E23627B5-E6D0-57ED-BAA5-A01E34C24FCB",
"key": "SOHNUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SOHNUM_0",
"systemImage": "cart",
"title": "Pedidos de venta",
"titleKey": "BPCNAM_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SOPLIN_0",
"label": "Línea del pedido",
"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": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NETPRIATI_0",
"label": "Precio neto con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8387EFA4-2019-54B0-AE84-0E6B364ED1D2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES_0",
"label": "Producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES1_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "ITMREFBPC_0",
"label": "Referencia del cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "SOPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "LINTYP_0",
"label": "Tipo de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "FOCFLG_0",
"label": "Artículo gratuito",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y línea",
"detailRole": "information",
"isVisible": true,
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "SAU_0",
"label": "UM de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "STU_0",
"label": "UM de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "SAUSTUCOE_0",
"label": "Conversión venta / stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "PRITYP_0",
"label": "Base fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "GROPRI_0",
"label": "Precio bruto por UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "NETPRI_0",
"label": "Precio neto por UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades y precios",
"detailRole": "information",
"isVisible": true,
"key": "NETPRIATI_0",
"label": "Precio neto con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia registrada",
"detailRole": "information",
"isVisible": true,
"key": "STRDAT_0",
"label": "Inicio de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia registrada",
"detailRole": "information",
"isVisible": true,
"key": "ENDDAT_0",
"label": "Fin de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "66CA5996-54EF-5D25-AA50-DF0188523C8A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "DE24B91F-B78E-5961-BA8F-75FA0E059AE8",
"key": "SOPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "43DF78B8-0ED3-5EF9-AF3B-9424050B136F",
"key": "SOPSEQ_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "ITMREF_0",
"systemImage": "list.bullet",
"title": "Precios de las líneas",
"titleKey": "ITMDES_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SOPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUnit",
"label": "UM stock coincidente en fichas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYSTU_0",
"label": "Pedido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DLVQTYSTU_0",
"label": "Entregado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ALLQTYSTU_0",
"label": "Asignado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A35B3009-0714-55DF-ABFD-334F96411073",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "SOHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "SOPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "BPAADD_0",
"label": "Dirección de entrega (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y destino",
"detailRole": "information",
"isVisible": true,
"key": "SOQSTA_0",
"label": "Estado de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades comprobadas",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnit",
"label": "UM venta coincidente en fichas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades comprobadas",
"detailRole": "information",
"isVisible": true,
"key": "StockUnit",
"label": "UM stock coincidente en fichas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidades comprobadas",
"detailRole": "information",
"isVisible": true,
"key": "UnitContext",
"label": "Comprobación de unidades",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "QTY_0",
"label": "Pedido en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "DLVQTY_0",
"label": "Entregado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "ALLQTY_0",
"label": "Asignado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "INVQTY_0",
"label": "Facturado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "PREQTY_0",
"label": "Preparado en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM venta",
"detailRole": "information",
"isVisible": true,
"key": "SHTQTY_0",
"label": "Falta en UM venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "QTYSTU_0",
"label": "Pedido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "DLVQTYSTU_0",
"label": "Entregado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "ALLQTYSTU_0",
"label": "Asignado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "INVQTYSTU_0",
"label": "Facturado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "PREQTYSTU_0",
"label": "Preparado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "SHTQTYSTU_0",
"label": "Falta en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y cierre",
"detailRole": "information",
"isVisible": true,
"key": "DEMDLVDAT_0",
"label": "Entrega solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y cierre",
"detailRole": "information",
"isVisible": true,
"key": "EXTDLVDAT_0",
"label": "Entrega prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y cierre",
"detailRole": "information",
"isVisible": true,
"key": "SHIDAT_0",
"label": "Expedición prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y cierre",
"detailRole": "information",
"isVisible": true,
"key": "CCLDAT_0",
"label": "Fecha de cierre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y cierre",
"detailRole": "information",
"isVisible": true,
"key": "CCLREN_0",
"label": "Motivo de cierre (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "17F374B7-69B3-5051-BBF3-62D1A8E521A1",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "DE24B91F-B78E-5961-BA8F-75FA0E059AE8",
"key": "SOPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "D469B452-6883-5928-8487-4A6F1FAAA3D4",
"key": "SOQSEQ_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "STOFCY_0",
"systemImage": "list.bullet",
"title": "Cantidades y entregas",
"titleKey": "ITMREF_0"
}
],
"relations": [
{
"childDatasetID": "8387EFA4-2019-54B0-AE84-0E6B364ED1D2",
"childKey": "SOHNUM_0",
"id": "DC16FCD2-32E6-5166-B874-82292C40FB71",
"name": "Precios de las líneas",
"parentDatasetID": "9F37688F-91F0-51E8-8650-4A1FC3E704F1",
"parentKey": "SOHNUM_0"
},
{
"childDatasetID": "A35B3009-0714-55DF-ABFD-334F96411073",
"childKey": "SOHNUM_0",
"id": "0F133E8F-4350-56CF-9CC3-F49E49DCA689",
"name": "Cantidades y entregas",
"parentDatasetID": "9F37688F-91F0-51E8-8650-4A1FC3E704F1",
"parentKey": "SOHNUM_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 ventas, atención al cliente, logística y dirección: elige periodo y empresa y consulta pedidos normales, cliente y referencia, centros, importes, moneda, fechas y estados separados de pedido, asignación, entrega, facturación, crédito y aprobación. La ficha incluye últimos documentos y cierre. Dos sub-botones a petición abren los precios por producto con unidades, conversión y vigencia, y las cantidades de cada entrega: pedidas, entregadas, asignadas, facturadas, preparadas y en falta, tanto en UM venta como en UM stock.\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 a petición, SELECT explícito y sin actualizaciones programadas. Hasta 2.000 filas por lista; periodo/empresa se eligen con filtros nativos antes del límite. Cada sub-botón está delimitado por pedido y empresa. Revisa índices, tiempos y truncamiento: un límite o filtro no garantiza una consulta barata ni resultados completos. No se modifican las configuraciones Free/Starter existentes.\n\nPEDIDOS NORMALES: solo categoría 1, no contratos, préstamos ni facturación directa. Los estados abierto/cerrado, entregado y facturado no significan pagado. Firma no gestionada no se presenta como aprobada. Los códigos no reconocidos siguen visibles. ORDNOT/ORDATI son importes de líneas; ORDINVNOT/ORDINVATI son la valoración con elementos de facturación. Se muestran los valores nativos con CUR del pedido, sin sumarlos entre monedas ni calcular impuestos, saldo, margen, pagos o deuda. Los precios son por UM de venta; PRITYP indica su base fiscal.\n\nLÍNEAS SIN DUPLICACIONES: precios y cantidades se consultan por separado. La clave de precio es SOHNUM+SOPLIN+SOPSEQ; la de cantidad SOHNUM+SOPLIN+SOQSEQ. SOPSEQ no es SOQSEQ y pedido+línea no es una clave única de precio. Se conservan todas las ocurrencias, no se elige un precio efectivo por vigencia ni se multiplica cantidad por un precio arbitrario. Los números de línea son útiles; claves técnicas y secuencias permanecen ocultas. Las cantidades se mantienen con signo, ceros y ausencias.\n\nUNIDADES: para cada pedido/línea/empresa/producto, las UM solo se muestran cuando todas sus fichas de precio contienen el mismo código no vacío. Una ficha ausente, unidad vacía o discrepancia mantiene la UM sin confirmar. Este contexto no asigna una versión de precio a una entrega, no usa el maestro actual como unidad histórica ni convierte/recalcula cantidades o stock disponible. Revisa los casos no confirmados en X3.\n\nREQUISITO: Sage X3 v12 SQL Server, carpeta empresarial y permisos confirmados por el administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta y SELECT solo sobre datos autorizados; no sa/sysadmin. OBJECT_ID rechaza resolución en dbo/guest/sys/INFORMATION_SCHEMA; no se presupone dbo/SEED ni se descubren objetos automáticamente. Los filtros no son control de acceso; SQL no hereda los permisos de rol/centro de X3. Comprueba carpeta, tipos, vista previa e índices al importar; una prueba vacía no certifica compatibilidad. Requiere CONCAT y las funciones SQL utilizadas. Diccionario, claves, menús y nombres según regla oficial campo_indice, no DDL ni metadatos instalados.\n\nCapturas nativas Cifru con datos DEMO ficticios y transporte sintético; no validadas en Sage X3/SQL Server reales. Galería de máximo ocho pantallas representativas; las fichas extensas pueden requerir desplazamiento. Sin servidor, credenciales o filas reales. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDER.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDERP.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/SORDERQ.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00243.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00279.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00280.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00412.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00415.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00416.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00417.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00418.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00419.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00423.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00439.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00491.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESSOH.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "1EBC8D8B-F856-52BA-A1F4-5B781EC4B083",
"rootButtonCount": 1,
"summary": "Periodo y empresa; ficha completa del pedido, importes y estados separados, precios y cantidades/entregas a petición.",
"tags": [
"Sage X3",
"SQL Server",
"Pedidos",
"Ventas",
"Logística",
"Entregas",
"Pro"
],
"title": "Pedidos de venta, precios y entregas — Pro"
}
}