Pedidos de compra, precios y recepciones — Pro
Periodo y empresa; proveedor, importes y estados, fichas de precio y recepciones con unidades y costes registrados a petición.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para compras, almacén, administración y dirección: elige periodo y empresa, consulta proveedor, centros, importes, moneda y estados separados de recepción, facturación, cierre y firma. La ficha incluye comprador, referencias, revisión y acuse del proveedor. Dos sub-botones a petición muestran las fichas de precio y vigencia, y las cantidades pedidas, recibidas, facturadas, necesarias y en expedición, con unidades explícitas. Las líneas incluyen importes nativos, fechas, estados y costes de compra registrados.
¿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 y SELECT explícito. Sin actualizaciones programadas, hasta 2.000 filas por lista. Filtros nativos de periodo/empresa antes del límite y sub-botones delimitados por pedido y empresa. Revisa índices, tiempos y truncamiento: el límite no garantiza rapidez ni resultados completos. No se cambia el plan de configuraciones existentes.
ALCANCE: pedidos POHTYP=1, no contratos. Se conserva modalidad comercial/general e indicadores interempresa y entre centros; no se mezcla su valoración. Recibido, facturado, firmado y cerrado son estados distintos, no significan pagado; No gestionada no se presenta como aprobada. Los códigos desconocidos siguen visibles.
IMPORTES: TOTLINAMT/TOTLINATI son importes de líneas; TOTORD integra elementos de facturación sin impuestos; TOTTAXAMT son impuestos. No se inventa la columna funcional TTVORD ni un total con impuestos. CUR del pedido y NETCUR de cada línea se muestran por separado. TOTORDL y los costes registrados utilizan moneda de empresa: ACCCUR del registro COMPANY es el código contable ACTUAL, no certificado histórico. Confirma su coherencia con los documentos; si falta, la moneda queda sin confirmar, nunca se sustituye por CUR. No se suman monedas, calculan cambios, pagos, saldos, margen o impuestos.
PRECIOS SIN SUPOSICIONES: cada registro POPSEQ y su vigencia se conserva. El precio bruto/neto está marcado Verificar UM en transacción: Sage determina su base por la transacción de entrada (UM pedido o UM compra). Las UM mostradas en contexto solo coinciden cuando todas las filas de cantidad del mismo pedido/línea/empresa/producto tienen el mismo código no vacío. No prueban la unidad histórica de una ficha de precio, ni se usa el maestro actual para inferirla. Discrepancias/ausencias mantienen el contexto sin confirmar. No se elige un precio efectivo ni se multiplica por cantidades.
CANTIDADES SIN DUPLICAR: claves completas POHNUM+POPLIN+POPSEQ y POHNUM+POPLIN+POQSEQ; POPSEQ no es POQSEQ. Dos listas independientes sin join que multiplique precios por recepciones. Números de línea visibles, claves técnicas y secuencias ocultas. UOM, PUU y STU son unidades nativas de pedido, compra y stock; las cantidades conservan signo, ceros y ausencias. RETQTYPUU/RETQTYSTU son NECESIDADES, no devoluciones ni saldo. UOMPUUCOE es conversión pedido/compra según ayuda funcional; no se aplica como conversión stock/compra a pesar del título divergente del diccionario. No se recalculan cantidades.
COSTES: LINCSTPUR es coste de compra registrado; CSTPUR es por UM stock y CPRAMT coste fijo por UM compra. Valores nativos en moneda de empresa, sin recalcular costes reales ni aplicar CPRCOE. Dependen de la configuración y se actualizan al guardar el documento en X3; cero/ausente no certifica coste completo.
REQUISITO: Sage X3 v12 SQL Server, carpeta empresarial y permisos confirmados por administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta, SELECT solo sobre datos autorizados, no sa/sysadmin. La comprobación OBJECT_ID rechaza resolución en dbo/guest/sys/INFORMATION_SCHEMA; no se presupone dbo/SEED. SQL no hereda permisos de rol/centro de X3; filtros no son control de acceso. Comprueba versión, carpeta, tipos, permisos, vista previa, moneda histórica y transacción. Diccionario y regla campo_indice no son DDL ni metadatos instalados. Se requiere CONCAT y las funciones usadas; prueba vacía no certifica compatibilidad.
Capturas nativas Cifru con datos DEMO ficticios y transporte sintético; no validadas en Sage X3/SQL Server reales. Máximo ocho imágenes representativas, no todas las continuaciones de fichas desplazables. Sin credenciales, servidor o filas reales. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDER.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDERP.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDERQ.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESPOH.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/COMPANY.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESCPY.htm
https://online-help.sagex3.com/erp/12/es-es/Content/MCD/PORDERQ.htm
https://online-help.sagex3.com/erp/12/fr-fr/Content/FCT/GESPOH.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/MEN00280.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00506.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00507.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00317.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00570.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00646.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Pedidos de compra
- Details: Precios de compra
- Details: Cantidades y recepciones
- Sub-button: Precios de compra
- Sub-button: Cantidades y recepciones
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.POHNUM_0) AS POHNUM_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.POHFCY_0) AS POHFCY_0, h.ORDDAT_0, RTRIM(h.BPSNUM_0) AS BPSNUM_0, RTRIM(h.BPRNAM_0) AS BPRNAM_0, RTRIM(h.BPRNAM_1) AS BPRNAM_1, RTRIM(h.CUR_0) AS CUR_0, h.TOTORD_0, h.TOTORDL_0, h.TOTLINAMT_0, h.TOTLINATI_0, h.TOTTAXAMT_0, CASE WHEN h.RCPFLG_0=1 THEN N'Sin recibir' WHEN h.RCPFLG_0=2 THEN N'Recepción parcial' WHEN h.RCPFLG_0=3 THEN N'Recibido completo' WHEN h.RCPFLG_0=4 THEN N'No gestionada' WHEN h.RCPFLG_0=5 THEN N'Automática' WHEN h.RCPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.RCPFLG_0) END AS RCPFLG_0, CASE WHEN h.INVFLG_0=1 THEN N'Sin facturar' WHEN h.INVFLG_0=2 THEN N'Facturación parcial' WHEN h.INVFLG_0=3 THEN N'Facturado completo' WHEN h.INVFLG_0=4 THEN N'No gestionada' WHEN h.INVFLG_0=5 THEN N'Automática' WHEN h.INVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVFLG_0) END AS INVFLG_0, CASE WHEN h.CLEFLG_0=1 THEN N'No' WHEN h.CLEFLG_0=2 THEN N'Sí' WHEN h.CLEFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CLEFLG_0) END AS CLEFLG_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.EXTRCPDAT1_0, RTRIM(h.BUY_0) AS BUY_0, CASE WHEN h.POHTYP_0=1 THEN N'Pedido' WHEN h.POHTYP_0=2 THEN N'Contrato' WHEN h.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.POHTYP_0) END AS POHTYP_0, CASE WHEN h.PURTYP_0=1 THEN N'Comercial' WHEN h.PURTYP_0=2 THEN N'General' WHEN h.PURTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PURTYP_0) END AS PURTYP_0, h.LINNBR_0, RTRIM(h.ORDREF_0) AS ORDREF_0, RTRIM(h.OCNNUM_0) AS OCNNUM_0, h.OCNDAT_0, RTRIM(h.OCNREM_0) AS OCNREM_0, RTRIM(h.BPRPAY_0) AS BPRPAY_0, RTRIM(h.BPSINV_0) AS BPSINV_0, RTRIM(h.RCPFCY_0) AS RCPFCY_0, CASE WHEN h.BETCPY_0=1 THEN N'No' WHEN h.BETCPY_0=2 THEN N'Sí' WHEN h.BETCPY_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.BETCPY_0) END AS BETCPY_0, CASE WHEN h.BETFCY_0=1 THEN N'No' WHEN h.BETFCY_0=2 THEN N'Sí' WHEN h.BETFCY_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.BETFCY_0) END AS BETFCY_0, h.REVNUM_0, RTRIM(c.CPYNAM_0) AS CompanyName, RTRIM(c.ACCCUR_0) AS CompanyCurrency FROM PORDER h LEFT JOIN COMPANY c ON c.CPY_0=h.CPY_0 WHERE h.POHTYP_0=1 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(RTRIM(p.POHNUM_0)),N':',RTRIM(p.POHNUM_0),N':',p.POPLIN_0,N':',p.POPSEQ_0) AS PriceKey, RTRIM(p.POHNUM_0) AS POHNUM_0, p.POPLIN_0, p.POPSEQ_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, p.GROPRI_0, p.NETPRI_0, p.STRDAT_0, p.POPDAT_0, RTRIM(p.LINBUY_0) AS LINBUY_0, RTRIM(p.PRHFCY_0) AS PRHFCY_0, RTRIM(p.PRIREN_0) AS PRIREN_0, p.LINREVNUM_0, CASE WHEN p.POHTYP_0=1 THEN N'Pedido' WHEN p.POHTYP_0=2 THEN N'Contrato' WHEN p.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.POHTYP_0) END AS POHTYP_0, h.CUR_0, N'Verificar UM en transacción' AS PriceBasis, u.OrderUnitContext, u.PurchaseUnitContext, CASE WHEN u.OrderUnitContext IS NOT NULL AND u.PurchaseUnitContext IS NOT NULL THEN N'Contexto actual, no histórico' ELSE N'UM de contexto no confirmadas' END AS UnitContext FROM PORDERP p JOIN PORDER h ON h.POHNUM_0=p.POHNUM_0 AND h.CPY_0=p.CPY_0 LEFT JOIN (SELECT q.POHNUM_0,q.POPLIN_0,q.CPY_0,q.ITMREF_0,CASE WHEN COUNT(NULLIF(RTRIM(q.UOM_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(q.UOM_0),N''))=1 THEN MIN(NULLIF(RTRIM(q.UOM_0),N'')) ELSE NULL END AS OrderUnitContext,CASE WHEN COUNT(NULLIF(RTRIM(q.PUU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(q.PUU_0),N''))=1 THEN MIN(NULLIF(RTRIM(q.PUU_0),N'')) ELSE NULL END AS PurchaseUnitContext FROM PORDERQ q WHERE q.POHNUM_0=:order AND q.CPY_0=:company GROUP BY q.POHNUM_0,q.POPLIN_0,q.CPY_0,q.ITMREF_0) u ON u.POHNUM_0=p.POHNUM_0 AND u.POPLIN_0=p.POPLIN_0 AND u.CPY_0=p.CPY_0 AND u.ITMREF_0=p.ITMREF_0 WHERE h.POHTYP_0=1 AND h.POHNUM_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'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(RTRIM(q.POHNUM_0)),N':',RTRIM(q.POHNUM_0),N':',q.POPLIN_0,N':',q.POQSEQ_0) AS QuantityKey, RTRIM(q.POHNUM_0) AS POHNUM_0, q.POPLIN_0, q.POQSEQ_0, RTRIM(q.CPY_0) AS CPY_0, RTRIM(q.ITMREF_0) AS ITMREF_0, RTRIM(q.UOM_0) AS UOM_0, RTRIM(q.PUU_0) AS PUU_0, RTRIM(q.STU_0) AS STU_0, q.QTYUOM_0, q.QTYPUU_0, q.QTYSTU_0, q.RCPQTYPUU_0, q.RCPQTYSTU_0, q.INVQTYPUU_0, q.INVQTYSTU_0, q.RETQTYPUU_0, q.RETQTYSTU_0, q.SHIQTYPUU_0, q.SHIQTYSTU_0, q.UOMPUUCOE_0, RTRIM(q.NETCUR_0) AS NETCUR_0, q.LINAMT_0, q.LINATI_0, q.EXTRCPDAT_0, q.DEMRCPDAT_0, q.RETRCPDAT_0, RTRIM(q.PRHFCY_0) AS PRHFCY_0, CASE WHEN q.LININVFLG_0=1 THEN N'No' WHEN q.LININVFLG_0=2 THEN N'Sí' WHEN q.LININVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LININVFLG_0) END AS LININVFLG_0, CASE WHEN q.LINCLEFLG_0=1 THEN N'No' WHEN q.LINCLEFLG_0=2 THEN N'Sí' WHEN q.LINCLEFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINCLEFLG_0) END AS LINCLEFLG_0, CASE WHEN q.WIPSTA_0=1 THEN N'Firme' WHEN q.WIPSTA_0=2 THEN N'Planificada' WHEN q.WIPSTA_0=3 THEN N'Sugerida' WHEN q.WIPSTA_0=4 THEN N'Cerrada' WHEN q.WIPSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.WIPSTA_0) END AS WIPSTA_0, CASE WHEN q.LINTYP_0=1 THEN N'Normal' WHEN q.LINTYP_0=2 THEN N'Producto padre de estructura' WHEN q.LINTYP_0=3 THEN N'Servicio subcontratado' WHEN q.LINTYP_0=4 THEN N'Material suministrado' WHEN q.LINTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINTYP_0) END AS LINTYP_0, CASE WHEN q.LINPURTYP_0=1 THEN N'Compra' WHEN q.LINPURTYP_0=2 THEN N'Inmovilizado' WHEN q.LINPURTYP_0=3 THEN N'Servicios' WHEN q.LINPURTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINPURTYP_0) END AS LINPURTYP_0, q.LINREVNUM_0, CASE WHEN q.POHTYP_0=1 THEN N'Pedido' WHEN q.POHTYP_0=2 THEN N'Contrato' WHEN q.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.POHTYP_0) END AS POHTYP_0, q.LINCSTPUR_0, q.CSTPUR_0, q.CPRAMT_0, q.CPRCOE_0, RTRIM(c.ACCCUR_0) AS CompanyCurrency FROM PORDERQ q JOIN PORDER h ON h.POHNUM_0=q.POHNUM_0 AND h.CPY_0=q.CPY_0 LEFT JOIN COMPANY c ON c.CPY_0=h.CPY_0 WHERE h.POHTYP_0=1 AND h.POHNUM_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'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage X3 — SQL Server, carpeta autorizada",
"id": "4AA4421F-3347-594A-9210-2228DC36838A",
"kind": "sqlServer",
"requiredObjects": [
"PORDER",
"PORDERP",
"PORDERQ",
"COMPANY"
],
"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": "4BC5EC7E-F0C3-59C8-949F-46C4978C46B0",
"key": "POHNUM_0",
"type": "text"
}
],
"id": "AD9B4839-AD72-52B8-94D6-43BB41B84511",
"mappings": [
{
"commonFieldKey": "",
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHNUM_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": "POHFCY_0",
"label": "Centro de compras",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHFCY_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": "BPSNUM_0",
"label": "Proveedor (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPSNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRNAM_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRNAM_1",
"label": "Proveedor, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRNAM_1",
"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": "TOTORD_0",
"label": "Total sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTORD_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TOTORDL_0",
"label": "Total sin impuestos (empresa)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTORDL_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TOTLINAMT_0",
"label": "Líneas sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTLINAMT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TOTLINATI_0",
"label": "Líneas con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTLINATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TOTTAXAMT_0",
"label": "Total de impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTTAXAMT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCPFLG_0",
"label": "Estado de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVFLG_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CLEFLG_0",
"label": "Pedido cerrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CLEFLG_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": true
},
{
"commonFieldKey": "",
"key": "EXTRCPDAT1_0",
"label": "Recepción prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTRCPDAT1_0",
"type": "date",
"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": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PURTYP_0",
"label": "Modalidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PURTYP_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": "ORDREF_0",
"label": "Referencia interna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OCNNUM_0",
"label": "Acuse del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OCNNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OCNDAT_0",
"label": "Fecha del acuse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OCNDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OCNREM_0",
"label": "Notas del acuse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OCNREM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRPAY_0",
"label": "Beneficiario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRPAY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPSINV_0",
"label": "Proveedor facturante (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPSINV_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCPFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BETCPY_0",
"label": "Interempresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BETCPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BETFCY_0",
"label": "Entre centros",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BETFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REVNUM_0",
"label": "Revisión del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REVNUM_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Nombre actual de empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCurrency",
"label": "Moneda contable actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pedidos de compra",
"primaryKey": "POHNUM_0",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"POHNUM_0",
"CPY_0",
"POHFCY_0",
"ORDDAT_0",
"BPSNUM_0",
"BPRNAM_0",
"BPRNAM_1",
"CUR_0",
"TOTORD_0",
"TOTORDL_0",
"TOTLINAMT_0",
"TOTLINATI_0",
"TOTTAXAMT_0",
"RCPFLG_0",
"INVFLG_0",
"CLEFLG_0",
"APPFLG_0",
"EXTRCPDAT1_0",
"BUY_0",
"POHTYP_0",
"PURTYP_0",
"LINNBR_0",
"ORDREF_0",
"OCNNUM_0",
"OCNDAT_0",
"OCNREM_0",
"BPRPAY_0",
"BPSINV_0",
"RCPFCY_0",
"BETCPY_0",
"BETFCY_0",
"REVNUM_0",
"CompanyName",
"CompanyCurrency"
],
"sourceID": "4AA4421F-3347-594A-9210-2228DC36838A",
"sqlQuery": "SELECT RTRIM(h.POHNUM_0) AS POHNUM_0, RTRIM(h.CPY_0) AS CPY_0, RTRIM(h.POHFCY_0) AS POHFCY_0, h.ORDDAT_0, RTRIM(h.BPSNUM_0) AS BPSNUM_0, RTRIM(h.BPRNAM_0) AS BPRNAM_0, RTRIM(h.BPRNAM_1) AS BPRNAM_1, RTRIM(h.CUR_0) AS CUR_0, h.TOTORD_0, h.TOTORDL_0, h.TOTLINAMT_0, h.TOTLINATI_0, h.TOTTAXAMT_0, CASE WHEN h.RCPFLG_0=1 THEN N'Sin recibir' WHEN h.RCPFLG_0=2 THEN N'Recepción parcial' WHEN h.RCPFLG_0=3 THEN N'Recibido completo' WHEN h.RCPFLG_0=4 THEN N'No gestionada' WHEN h.RCPFLG_0=5 THEN N'Automática' WHEN h.RCPFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.RCPFLG_0) END AS RCPFLG_0, CASE WHEN h.INVFLG_0=1 THEN N'Sin facturar' WHEN h.INVFLG_0=2 THEN N'Facturación parcial' WHEN h.INVFLG_0=3 THEN N'Facturado completo' WHEN h.INVFLG_0=4 THEN N'No gestionada' WHEN h.INVFLG_0=5 THEN N'Automática' WHEN h.INVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVFLG_0) END AS INVFLG_0, CASE WHEN h.CLEFLG_0=1 THEN N'No' WHEN h.CLEFLG_0=2 THEN N'Sí' WHEN h.CLEFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.CLEFLG_0) END AS CLEFLG_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.EXTRCPDAT1_0, RTRIM(h.BUY_0) AS BUY_0, CASE WHEN h.POHTYP_0=1 THEN N'Pedido' WHEN h.POHTYP_0=2 THEN N'Contrato' WHEN h.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.POHTYP_0) END AS POHTYP_0, CASE WHEN h.PURTYP_0=1 THEN N'Comercial' WHEN h.PURTYP_0=2 THEN N'General' WHEN h.PURTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PURTYP_0) END AS PURTYP_0, h.LINNBR_0, RTRIM(h.ORDREF_0) AS ORDREF_0, RTRIM(h.OCNNUM_0) AS OCNNUM_0, h.OCNDAT_0, RTRIM(h.OCNREM_0) AS OCNREM_0, RTRIM(h.BPRPAY_0) AS BPRPAY_0, RTRIM(h.BPSINV_0) AS BPSINV_0, RTRIM(h.RCPFCY_0) AS RCPFCY_0, CASE WHEN h.BETCPY_0=1 THEN N'No' WHEN h.BETCPY_0=2 THEN N'Sí' WHEN h.BETCPY_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.BETCPY_0) END AS BETCPY_0, CASE WHEN h.BETFCY_0=1 THEN N'No' WHEN h.BETFCY_0=2 THEN N'Sí' WHEN h.BETFCY_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.BETFCY_0) END AS BETFCY_0, h.REVNUM_0, RTRIM(c.CPYNAM_0) AS CompanyName, RTRIM(c.ACCCUR_0) AS CompanyCurrency FROM PORDER h LEFT JOIN COMPANY c ON c.CPY_0=h.CPY_0 WHERE h.POHTYP_0=1 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E5E92A40-257A-5E02-AC25-769E3E9CB9BF",
"key": "POPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "AD746F8C-9E3B-5447-9C22-5B2D5C454F4C",
"key": "POPSEQ_0",
"type": "number"
}
],
"id": "33A523E1-41D1-511B-8A5B-F0C12852E72D",
"mappings": [
{
"commonFieldKey": "",
"key": "PriceKey",
"label": "Clave interna completa de precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POPLIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "POPSEQ_0",
"label": "Secuencia interna de precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POPSEQ_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": "GROPRI_0",
"label": "Precio bruto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GROPRI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NETPRI_0",
"label": "Precio neto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRI_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": true
},
{
"commonFieldKey": "",
"key": "POPDAT_0",
"label": "Fin de aplicación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POPDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LINBUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINBUY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRHFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRHFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRIREN_0",
"label": "Motivo de precio (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRIREN_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINREVNUM_0",
"label": "Revisión de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINREVNUM_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHTYP_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": "PriceBasis",
"label": "Base del precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceBasis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderUnitContext",
"label": "UM pedido (contexto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderUnitContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseUnitContext",
"label": "UM compra (contexto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchaseUnitContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitContext",
"label": "Comprobación del contexto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Precios de compra",
"primaryKey": "PriceKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "POHNUM_0",
"id": "7EFD033E-9E54-5910-86DE-98EECA40CE39",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "DBB74B2E-8167-5D57-A334-0FC46D073801",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"POHNUM_0",
"POPLIN_0",
"CPY_0",
"ITMREF_0",
"ITMDES_0",
"ITMDES1_0",
"GROPRI_0",
"NETPRI_0",
"STRDAT_0",
"POPDAT_0",
"LINBUY_0",
"PRHFCY_0",
"PRIREN_0",
"LINREVNUM_0",
"POHTYP_0",
"CUR_0",
"PriceBasis",
"OrderUnitContext",
"PurchaseUnitContext",
"UnitContext"
],
"sourceID": "4AA4421F-3347-594A-9210-2228DC36838A",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(p.POHNUM_0)),N':',RTRIM(p.POHNUM_0),N':',p.POPLIN_0,N':',p.POPSEQ_0) AS PriceKey, RTRIM(p.POHNUM_0) AS POHNUM_0, p.POPLIN_0, p.POPSEQ_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, p.GROPRI_0, p.NETPRI_0, p.STRDAT_0, p.POPDAT_0, RTRIM(p.LINBUY_0) AS LINBUY_0, RTRIM(p.PRHFCY_0) AS PRHFCY_0, RTRIM(p.PRIREN_0) AS PRIREN_0, p.LINREVNUM_0, CASE WHEN p.POHTYP_0=1 THEN N'Pedido' WHEN p.POHTYP_0=2 THEN N'Contrato' WHEN p.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',p.POHTYP_0) END AS POHTYP_0, h.CUR_0, N'Verificar UM en transacción' AS PriceBasis, u.OrderUnitContext, u.PurchaseUnitContext, CASE WHEN u.OrderUnitContext IS NOT NULL AND u.PurchaseUnitContext IS NOT NULL THEN N'Contexto actual, no histórico' ELSE N'UM de contexto no confirmadas' END AS UnitContext FROM PORDERP p JOIN PORDER h ON h.POHNUM_0=p.POHNUM_0 AND h.CPY_0=p.CPY_0 LEFT JOIN (SELECT q.POHNUM_0,q.POPLIN_0,q.CPY_0,q.ITMREF_0,CASE WHEN COUNT(NULLIF(RTRIM(q.UOM_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(q.UOM_0),N''))=1 THEN MIN(NULLIF(RTRIM(q.UOM_0),N'')) ELSE NULL END AS OrderUnitContext,CASE WHEN COUNT(NULLIF(RTRIM(q.PUU_0),N''))=COUNT(*) AND COUNT(DISTINCT NULLIF(RTRIM(q.PUU_0),N''))=1 THEN MIN(NULLIF(RTRIM(q.PUU_0),N'')) ELSE NULL END AS PurchaseUnitContext FROM PORDERQ q WHERE q.POHNUM_0=:order AND q.CPY_0=:company GROUP BY q.POHNUM_0,q.POPLIN_0,q.CPY_0,q.ITMREF_0) u ON u.POHNUM_0=p.POHNUM_0 AND u.POPLIN_0=p.POPLIN_0 AND u.CPY_0=p.CPY_0 AND u.ITMREF_0=p.ITMREF_0 WHERE h.POHTYP_0=1 AND h.POHNUM_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'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E5E92A40-257A-5E02-AC25-769E3E9CB9BF",
"key": "POPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "4E904B4D-E97B-5805-A5AE-0D805CE4276D",
"key": "POQSEQ_0",
"type": "number"
}
],
"id": "4E6DCC44-15E8-535B-99A0-C758AA02DF6B",
"mappings": [
{
"commonFieldKey": "",
"key": "QuantityKey",
"label": "Clave interna completa de cantidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POPLIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "POQSEQ_0",
"label": "Secuencia interna de cantidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POQSEQ_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": "UOM_0",
"label": "UM de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UOM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PUU_0",
"label": "UM de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PUU_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": "QTYUOM_0",
"label": "Pedido en UM pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYUOM_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QTYPUU_0",
"label": "Pedido en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYPUU_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": "RCPQTYPUU_0",
"label": "Recibido en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPQTYPUU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCPQTYSTU_0",
"label": "Recibido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVQTYPUU_0",
"label": "Facturado en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVQTYPUU_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": true
},
{
"commonFieldKey": "",
"key": "RETQTYPUU_0",
"label": "Necesidad en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RETQTYPUU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RETQTYSTU_0",
"label": "Necesidad en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RETQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIQTYPUU_0",
"label": "En expedición, UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHIQTYPUU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIQTYSTU_0",
"label": "En expedición, UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHIQTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UOMPUUCOE_0",
"label": "Conversión pedido / compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UOMPUUCOE_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NETCUR_0",
"label": "Moneda de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETCUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINAMT_0",
"label": "Línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINAMT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINATI_0",
"label": "Línea con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXTRCPDAT_0",
"label": "Recepción prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTRCPDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DEMRCPDAT_0",
"label": "Recepción solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEMRCPDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RETRCPDAT_0",
"label": "Fecha de necesidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RETRCPDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRHFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRHFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LININVFLG_0",
"label": "Línea facturada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LININVFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINCLEFLG_0",
"label": "Línea cerrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINCLEFLG_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WIPSTA_0",
"label": "Estado WIP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WIPSTA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINTYP_0",
"label": "Tipo de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINPURTYP_0",
"label": "Naturaleza de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINPURTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINREVNUM_0",
"label": "Revisión de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINREVNUM_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LINCSTPUR_0",
"label": "Coste de compra registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LINCSTPUR_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CSTPUR_0",
"label": "Coste por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CSTPUR_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPRAMT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPRCOE_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCurrency",
"label": "Moneda contable actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Cantidades y recepciones",
"primaryKey": "QuantityKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "POHNUM_0",
"id": "7EFD033E-9E54-5910-86DE-98EECA40CE39",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "DBB74B2E-8167-5D57-A334-0FC46D073801",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"POHNUM_0",
"POPLIN_0",
"CPY_0",
"ITMREF_0",
"UOM_0",
"PUU_0",
"STU_0",
"QTYUOM_0",
"QTYPUU_0",
"QTYSTU_0",
"RCPQTYPUU_0",
"RCPQTYSTU_0",
"INVQTYPUU_0",
"INVQTYSTU_0",
"RETQTYPUU_0",
"RETQTYSTU_0",
"SHIQTYPUU_0",
"SHIQTYSTU_0",
"UOMPUUCOE_0",
"NETCUR_0",
"LINAMT_0",
"LINATI_0",
"EXTRCPDAT_0",
"DEMRCPDAT_0",
"RETRCPDAT_0",
"PRHFCY_0",
"LININVFLG_0",
"LINCLEFLG_0",
"WIPSTA_0",
"LINTYP_0",
"LINPURTYP_0",
"LINREVNUM_0",
"POHTYP_0",
"LINCSTPUR_0",
"CSTPUR_0",
"CPRAMT_0",
"CPRCOE_0",
"CompanyCurrency"
],
"sourceID": "4AA4421F-3347-594A-9210-2228DC36838A",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(q.POHNUM_0)),N':',RTRIM(q.POHNUM_0),N':',q.POPLIN_0,N':',q.POQSEQ_0) AS QuantityKey, RTRIM(q.POHNUM_0) AS POHNUM_0, q.POPLIN_0, q.POQSEQ_0, RTRIM(q.CPY_0) AS CPY_0, RTRIM(q.ITMREF_0) AS ITMREF_0, RTRIM(q.UOM_0) AS UOM_0, RTRIM(q.PUU_0) AS PUU_0, RTRIM(q.STU_0) AS STU_0, q.QTYUOM_0, q.QTYPUU_0, q.QTYSTU_0, q.RCPQTYPUU_0, q.RCPQTYSTU_0, q.INVQTYPUU_0, q.INVQTYSTU_0, q.RETQTYPUU_0, q.RETQTYSTU_0, q.SHIQTYPUU_0, q.SHIQTYSTU_0, q.UOMPUUCOE_0, RTRIM(q.NETCUR_0) AS NETCUR_0, q.LINAMT_0, q.LINATI_0, q.EXTRCPDAT_0, q.DEMRCPDAT_0, q.RETRCPDAT_0, RTRIM(q.PRHFCY_0) AS PRHFCY_0, CASE WHEN q.LININVFLG_0=1 THEN N'No' WHEN q.LININVFLG_0=2 THEN N'Sí' WHEN q.LININVFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LININVFLG_0) END AS LININVFLG_0, CASE WHEN q.LINCLEFLG_0=1 THEN N'No' WHEN q.LINCLEFLG_0=2 THEN N'Sí' WHEN q.LINCLEFLG_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINCLEFLG_0) END AS LINCLEFLG_0, CASE WHEN q.WIPSTA_0=1 THEN N'Firme' WHEN q.WIPSTA_0=2 THEN N'Planificada' WHEN q.WIPSTA_0=3 THEN N'Sugerida' WHEN q.WIPSTA_0=4 THEN N'Cerrada' WHEN q.WIPSTA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.WIPSTA_0) END AS WIPSTA_0, CASE WHEN q.LINTYP_0=1 THEN N'Normal' WHEN q.LINTYP_0=2 THEN N'Producto padre de estructura' WHEN q.LINTYP_0=3 THEN N'Servicio subcontratado' WHEN q.LINTYP_0=4 THEN N'Material suministrado' WHEN q.LINTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINTYP_0) END AS LINTYP_0, CASE WHEN q.LINPURTYP_0=1 THEN N'Compra' WHEN q.LINPURTYP_0=2 THEN N'Inmovilizado' WHEN q.LINPURTYP_0=3 THEN N'Servicios' WHEN q.LINPURTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.LINPURTYP_0) END AS LINPURTYP_0, q.LINREVNUM_0, CASE WHEN q.POHTYP_0=1 THEN N'Pedido' WHEN q.POHTYP_0=2 THEN N'Contrato' WHEN q.POHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',q.POHTYP_0) END AS POHTYP_0, q.LINCSTPUR_0, q.CSTPUR_0, q.CPRAMT_0, q.CPRCOE_0, RTRIM(c.ACCCUR_0) AS CompanyCurrency FROM PORDERQ q JOIN PORDER h ON h.POHNUM_0=q.POHNUM_0 AND h.CPY_0=q.CPY_0 LEFT JOIN COMPANY c ON c.CPY_0=h.CPY_0 WHERE h.POHTYP_0=1 AND h.POHNUM_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'PORDER',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDER',N'U') AND OBJECT_ID(N'PORDERP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERP',N'U') AND OBJECT_ID(N'PORDERQ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PORDERQ',N'U') AND OBJECT_ID(N'COMPANY',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.COMPANY',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "C39C2BB0-1D4F-52B8-85BC-611FCED1AFE0",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "494199C0-EFEC-5C58-BB72-B8298444FAF9",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "33A523E1-41D1-511B-8A5B-F0C12852E72D",
"title": "Precios de compra",
"urlKey": ""
},
{
"id": "035B7F49-A2CC-5A46-A8AD-0CEB4FFB0587",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "AF126ED1-FE35-5B2A-A823-38A0B9836724",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "4E6DCC44-15E8-535B-99A0-C758AA02DF6B",
"title": "Cantidades y recepciones",
"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": "TOTORD_0",
"label": "Total sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RCPFLG_0",
"label": "Estado de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INVFLG_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "APPFLG_0",
"label": "Firma / aprobación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "AD9B4839-AD72-52B8-94D6-43BB41B84511",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "PURTYP_0",
"label": "Modalidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_1",
"label": "Proveedor, segunda línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPSNUM_0",
"label": "Proveedor (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPSINV_0",
"label": "Proveedor facturante (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPRPAY_0",
"label": "Beneficiario (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "ORDREF_0",
"label": "Referencia interna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pedido y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "LINNBR_0",
"label": "Número de líneas",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Nombre actual de empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "POHFCY_0",
"label": "Centro de compras",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "RCPFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "ORDDAT_0",
"label": "Fecha de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "EXTRCPDAT1_0",
"label": "Recepción prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Empresa, centros y fechas",
"detailRole": "information",
"isVisible": true,
"key": "BUY_0",
"label": "Comprador (código)",
"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": "TOTLINAMT_0",
"label": "Líneas sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "TOTLINATI_0",
"label": "Líneas con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "TOTORD_0",
"label": "Total sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes en moneda del pedido",
"detailRole": "information",
"isVisible": true,
"key": "TOTTAXAMT_0",
"label": "Total de impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valoración en moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moneda contable actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valoración en moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "TOTORDL_0",
"label": "Total sin impuestos (empresa)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "RCPFLG_0",
"label": "Estado de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "INVFLG_0",
"label": "Estado de facturación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "CLEFLG_0",
"label": "Pedido cerrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "APPFLG_0",
"label": "Firma / aprobación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "BETCPY_0",
"label": "Interempresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "BETFCY_0",
"label": "Entre centros",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados independientes",
"detailRole": "information",
"isVisible": true,
"key": "REVNUM_0",
"label": "Revisión del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Acuse del proveedor",
"detailRole": "information",
"isVisible": true,
"key": "OCNNUM_0",
"label": "Acuse del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Acuse del proveedor",
"detailRole": "information",
"isVisible": true,
"key": "OCNDAT_0",
"label": "Fecha del acuse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Acuse del proveedor",
"detailRole": "information",
"isVisible": true,
"key": "OCNREM_0",
"label": "Notas del acuse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "09E3BDA6-4F16-5546-9D75-D2EB2D1CA37A",
"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": "97AB6D55-47AA-5B16-8FAD-522A5730C1B6",
"includeAllOption": true,
"key": "RCPFLG_0",
"title": "Estado de recepción",
"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": "4BC5EC7E-F0C3-59C8-949F-46C4978C46B0",
"key": "POHNUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "POHNUM_0",
"systemImage": "cart",
"title": "Pedidos de compra",
"titleKey": "BPRNAM_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "POPLIN_0",
"label": "Línea del 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": "NETPRI_0",
"label": "Precio neto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PriceBasis",
"label": "Base del precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STRDAT_0",
"label": "Inicio de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "POPDAT_0",
"label": "Fin de aplicación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "33A523E1-41D1-511B-8A5B-F0C12852E72D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES_0",
"label": "Producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES1_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "POPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "GROPRI_0",
"label": "Precio bruto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "NETPRI_0",
"label": "Precio neto registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y precio registrado",
"detailRole": "information",
"isVisible": true,
"key": "PriceBasis",
"label": "Base del precio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contexto actual, no unidad histórica",
"detailRole": "information",
"isVisible": true,
"key": "OrderUnitContext",
"label": "UM pedido (contexto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contexto actual, no unidad histórica",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseUnitContext",
"label": "UM compra (contexto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contexto actual, no unidad histórica",
"detailRole": "information",
"isVisible": true,
"key": "UnitContext",
"label": "Comprobación del contexto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "STRDAT_0",
"label": "Inicio de vigencia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "POPDAT_0",
"label": "Fin de aplicación",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "LINBUY_0",
"label": "Comprador (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "PRHFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "PRIREN_0",
"label": "Motivo de precio (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "LINREVNUM_0",
"label": "Revisión de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vigencia, comprador y destino",
"detailRole": "information",
"isVisible": true,
"key": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "CFC3EF0A-37B5-5304-ABDE-7419C2D07BC0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E5E92A40-257A-5E02-AC25-769E3E9CB9BF",
"key": "POPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "AD746F8C-9E3B-5447-9C22-5B2D5C454F4C",
"key": "POPSEQ_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "ITMREF_0",
"systemImage": "list.bullet",
"title": "Precios de compra",
"titleKey": "ITMDES_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "POPLIN_0",
"label": "Línea del pedido",
"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": "QTYSTU_0",
"label": "Pedido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RCPQTYSTU_0",
"label": "Recibido en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INVQTYSTU_0",
"label": "Facturado en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EXTRCPDAT_0",
"label": "Recepción prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "4E6DCC44-15E8-535B-99A0-C758AA02DF6B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Producto (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "POHNUM_0",
"label": "Pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "POPLIN_0",
"label": "Línea del pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "PRHFCY_0",
"label": "Centro de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "EXTRCPDAT_0",
"label": "Recepción prevista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "DEMRCPDAT_0",
"label": "Recepción solicitada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Línea y recepción",
"detailRole": "information",
"isVisible": true,
"key": "RETRCPDAT_0",
"label": "Fecha de necesidad",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidad de pedido",
"detailRole": "information",
"isVisible": true,
"key": "UOM_0",
"label": "UM de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidad de pedido",
"detailRole": "information",
"isVisible": true,
"key": "QTYUOM_0",
"label": "Pedido en UM pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unidad de pedido",
"detailRole": "information",
"isVisible": true,
"key": "UOMPUUCOE_0",
"label": "Conversión pedido / compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "UM de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "QTYPUU_0",
"label": "Pedido en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "RCPQTYPUU_0",
"label": "Recibido en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "INVQTYPUU_0",
"label": "Facturado en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "RETQTYPUU_0",
"label": "Necesidad en UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM compra",
"detailRole": "information",
"isVisible": true,
"key": "SHIQTYPUU_0",
"label": "En expedición, UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "STU_0",
"label": "UM de stock",
"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": "RCPQTYSTU_0",
"label": "Recibido 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": "RETQTYSTU_0",
"label": "Necesidad en UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades en UM stock",
"detailRole": "information",
"isVisible": true,
"key": "SHIQTYSTU_0",
"label": "En expedición, UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos de línea",
"detailRole": "information",
"isVisible": true,
"key": "NETCUR_0",
"label": "Moneda de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos de línea",
"detailRole": "information",
"isVisible": true,
"key": "LINAMT_0",
"label": "Línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes nativos de línea",
"detailRole": "information",
"isVisible": true,
"key": "LINATI_0",
"label": "Línea con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes registrados, moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCurrency",
"label": "Moneda contable actual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes registrados, moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "LINCSTPUR_0",
"label": "Coste de compra registrado",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes registrados, moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "CSTPUR_0",
"label": "Coste por UM stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes registrados, moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "CPRAMT_0",
"label": "Coste fijo por UM compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Costes registrados, moneda de empresa",
"detailRole": "information",
"isVisible": true,
"key": "CPRCOE_0",
"label": "Coeficiente de costes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "WIPSTA_0",
"label": "Estado WIP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "LININVFLG_0",
"label": "Línea facturada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "LINCLEFLG_0",
"label": "Línea cerrada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "LINTYP_0",
"label": "Tipo de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "LINPURTYP_0",
"label": "Naturaleza de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "POHTYP_0",
"label": "Tipo de pedido",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Estados y revisión",
"detailRole": "information",
"isVisible": true,
"key": "LINREVNUM_0",
"label": "Revisión de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0AE36978-FEE3-51D2-B812-8510B209F79B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E5E92A40-257A-5E02-AC25-769E3E9CB9BF",
"key": "POPLIN_0",
"type": "number"
},
{
"direction": "ascending",
"id": "4E904B4D-E97B-5805-A5AE-0D805CE4276D",
"key": "POQSEQ_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "PRHFCY_0",
"systemImage": "list.bullet",
"title": "Cantidades y recepciones",
"titleKey": "ITMREF_0"
}
],
"relations": [
{
"childDatasetID": "33A523E1-41D1-511B-8A5B-F0C12852E72D",
"childKey": "POHNUM_0",
"id": "494199C0-EFEC-5C58-BB72-B8298444FAF9",
"name": "Precios de compra",
"parentDatasetID": "AD9B4839-AD72-52B8-94D6-43BB41B84511",
"parentKey": "POHNUM_0"
},
{
"childDatasetID": "4E6DCC44-15E8-535B-99A0-C758AA02DF6B",
"childKey": "POHNUM_0",
"id": "AF126ED1-FE35-5B2A-A823-38A0B9836724",
"name": "Cantidades y recepciones",
"parentDatasetID": "AD9B4839-AD72-52B8-94D6-43BB41B84511",
"parentKey": "POHNUM_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, almacén, administración y dirección: elige periodo y empresa, consulta proveedor, centros, importes, moneda y estados separados de recepción, facturación, cierre y firma. La ficha incluye comprador, referencias, revisión y acuse del proveedor. Dos sub-botones a petición muestran las fichas de precio y vigencia, y las cantidades pedidas, recibidas, facturadas, necesarias y en expedición, con unidades explícitas. Las líneas incluyen importes nativos, fechas, estados y costes de compra registrados.\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 y SELECT explícito. Sin actualizaciones programadas, hasta 2.000 filas por lista. Filtros nativos de periodo/empresa antes del límite y sub-botones delimitados por pedido y empresa. Revisa índices, tiempos y truncamiento: el límite no garantiza rapidez ni resultados completos. No se cambia el plan de configuraciones existentes.\n\nALCANCE: pedidos POHTYP=1, no contratos. Se conserva modalidad comercial/general e indicadores interempresa y entre centros; no se mezcla su valoración. Recibido, facturado, firmado y cerrado son estados distintos, no significan pagado; No gestionada no se presenta como aprobada. Los códigos desconocidos siguen visibles.\n\nIMPORTES: TOTLINAMT/TOTLINATI son importes de líneas; TOTORD integra elementos de facturación sin impuestos; TOTTAXAMT son impuestos. No se inventa la columna funcional TTVORD ni un total con impuestos. CUR del pedido y NETCUR de cada línea se muestran por separado. TOTORDL y los costes registrados utilizan moneda de empresa: ACCCUR del registro COMPANY es el código contable ACTUAL, no certificado histórico. Confirma su coherencia con los documentos; si falta, la moneda queda sin confirmar, nunca se sustituye por CUR. No se suman monedas, calculan cambios, pagos, saldos, margen o impuestos.\n\nPRECIOS SIN SUPOSICIONES: cada registro POPSEQ y su vigencia se conserva. El precio bruto/neto está marcado Verificar UM en transacción: Sage determina su base por la transacción de entrada (UM pedido o UM compra). Las UM mostradas en contexto solo coinciden cuando todas las filas de cantidad del mismo pedido/línea/empresa/producto tienen el mismo código no vacío. No prueban la unidad histórica de una ficha de precio, ni se usa el maestro actual para inferirla. Discrepancias/ausencias mantienen el contexto sin confirmar. No se elige un precio efectivo ni se multiplica por cantidades.\n\nCANTIDADES SIN DUPLICAR: claves completas POHNUM+POPLIN+POPSEQ y POHNUM+POPLIN+POQSEQ; POPSEQ no es POQSEQ. Dos listas independientes sin join que multiplique precios por recepciones. Números de línea visibles, claves técnicas y secuencias ocultas. UOM, PUU y STU son unidades nativas de pedido, compra y stock; las cantidades conservan signo, ceros y ausencias. RETQTYPUU/RETQTYSTU son NECESIDADES, no devoluciones ni saldo. UOMPUUCOE es conversión pedido/compra según ayuda funcional; no se aplica como conversión stock/compra a pesar del título divergente del diccionario. No se recalculan cantidades.\n\nCOSTES: LINCSTPUR es coste de compra registrado; CSTPUR es por UM stock y CPRAMT coste fijo por UM compra. Valores nativos en moneda de empresa, sin recalcular costes reales ni aplicar CPRCOE. Dependen de la configuración y se actualizan al guardar el documento en X3; cero/ausente no certifica coste completo.\n\nREQUISITO: Sage X3 v12 SQL Server, carpeta empresarial y permisos confirmados por administrador. Usuario dedicado con esquema predeterminado igual a esa carpeta, SELECT solo sobre datos autorizados, no sa/sysadmin. La comprobación OBJECT_ID rechaza resolución en dbo/guest/sys/INFORMATION_SCHEMA; no se presupone dbo/SEED. SQL no hereda permisos de rol/centro de X3; filtros no son control de acceso. Comprueba versión, carpeta, tipos, permisos, vista previa, moneda histórica y transacción. Diccionario y regla campo_indice no son DDL ni metadatos instalados. Se requiere CONCAT y las funciones usadas; prueba vacía no certifica compatibilidad.\n\nCapturas nativas Cifru con datos DEMO ficticios y transporte sintético; no validadas en Sage X3/SQL Server reales. Máximo ocho imágenes representativas, no todas las continuaciones de fichas desplazables. Sin credenciales, servidor o filas reales. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDER.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDERP.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/PORDERQ.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESPOH.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/COMPANY.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESCPY.htm\nhttps://online-help.sagex3.com/erp/12/es-es/Content/MCD/PORDERQ.htm\nhttps://online-help.sagex3.com/erp/12/fr-fr/Content/FCT/GESPOH.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/MEN00280.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00506.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00507.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00317.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00570.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00646.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "B5ABDB29-78EC-52E1-AA60-57BE8AB2C452",
"rootButtonCount": 1,
"summary": "Periodo y empresa; proveedor, importes y estados, fichas de precio y recepciones con unidades y costes registrados a petición.",
"tags": [
"Sage X3",
"SQL Server",
"Compras",
"Proveedores",
"Recepciones",
"Almacén",
"Pro"
],
"title": "Pedidos de compra, precios y recepciones — Pro"
}
}