Facturas de compra y líneas — Pro
Periodo y empresa; proveedor, importes, validación y aprobación del pago; líneas con unidades, monedas y recepción.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para compras, administración, contabilidad y responsables de empresa: elige periodo contable y empresa; puedes filtrar también categoría de compra y aprobación del pago. Consulta proveedor, referencia de su factura, centro, moneda e importes sin/con impuestos. La ficha separa validación de la factura y aprobación del pago, muestra destinatario del pago, condiciones, fecha base de vencimientos y cinco observaciones. El sub-botón abre solo sus líneas: producto/servicio, cantidades y unidades de compra/stock, precio neto e importe sin impuestos nativos, moneda propia de la línea, pedido, recepción y fecha de recepció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.
Pro: una fuente SQL Server, dos listas, una relación y consultas SELECT con proyección explícita. Filtros nativos de apertura antes del límite de lectura; no hay parámetros SQL de periodo obligatorios que bloqueen descubrir empresas/categorías antes de elegir fechas. Líneas delimitadas por documento y empresa. Máximo 2.000 filas por lista, sin refresco programado. Reduce el periodo si alcanzas el límite; los filtros y el límite no garantizan una consulta barata ni resultados completos. Verifica índices, tiempos y permisos.
ALCANCE: módulo Compras (ORIMOD=6). Categorías: factura, factura adicional, abono y abono por devolución (PIHTYP, menú 533). No se mezclan las facturas contables de terceros (ORIMOD=3), que usan otros detalles. Estado de factura (STA, menú 509): pendiente/por validar/validada, distinto del estado de ventas. Aprobación del pago (PAZ, menú 510): pendiente/en conflicto/aplazado/autorizado al pago; autorizado no significa pagado. No se deduce saldo o deuda ni se ofrecen acciones para aprobar, contabilizar o pagar. BPRPAY es el tercero destinatario del pago, no una cuenta bancaria. PIVTYP y PTE son códigos de configuración. La fecha base de vencimientos no es una fecha de vencimiento efectiva.
MONEDAS: la cabecera conserva importes nativos en CUR. La línea conserva NETCUR de su documento origen, que puede diferir de CUR; se muestran ambas sin sustituir ni convertir. Precio neto y importe sin impuestos son valores almacenados, no se recalculan como precio × cantidad. Se conservan cantidades y unidades de compra y stock separadas; puede haber líneas financieras sin producto o cantidad y ajustes de redondeo. No se suman ni compensan monedas, no se aplican signos de abonos y no se presupone que el total de cabecera sea la suma de las líneas. No incluye desglose fiscal, valoración de costes, saldos, vencimientos ni liquidaciones.
REQUISITO: Sage X3 v12 SQL Server y acceso autorizado. El administrador confirma base/carpeta empresarial y prepara un usuario dedicado, esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. OBJECT_ID comprueba tablas frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no hay descubrimiento automático de objetos. Un test de estructura vacío no demuestra la carpeta correcta. Confirma esquema y una vista previa real al importar. Los filtros no son control de acceso; SQL no hereda automáticamente permisos de rol/centro de X3. El paquete no cambia usuarios, permisos, esquemas ni tablas.
Diccionario v12, claves únicas completas, menús de compra y regla SQL oficial campo_indice con dimensiones completas; nombres documentados por esa regla, no DDL ni metadatos de una instalación. Los alias de pantalla LIBPAZ/DUDDAT1/UOM no se inventan como columnas de estas tablas. Códigos desconocidos se muestran como Código N. Verifica versión, tipos, permisos, moneda, rendimiento y lectura/compatibilidad antes de uso real. Capturas nativas Cifru con transporte sintético y datos DEMO ficticios: no validadas en Sage X3/SQL Server reales. No contiene servidor, credenciales ni filas empresariales. No oficial, sin afiliación a Sage.
Fuentes primarias:
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/PINVOICE.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/PINVOICED.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00014.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00533.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00509.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00510.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESPIH.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Facturas de compra
- Details: Líneas de compra
- Sub-button: Líneas de compra
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT RTRIM(h.NUM_0) AS NUM_0, h.BPRNAM_0, h.BPRNAM_1, RTRIM(h.BPR_0) AS BPR_0, RTRIM(h.CPY_0) AS CPY_0, h.FCY_0, h.ACCDAT_0, h.BPRDAT_0, h.BPRVCR_0, h.CUR_0, h.AMTNOT_0, h.AMTATI_0, CASE WHEN h.PIHTYP_0=1 THEN N'Factura' WHEN h.PIHTYP_0=2 THEN N'Factura adicional' WHEN h.PIHTYP_0=3 THEN N'Abono' WHEN h.PIHTYP_0=4 THEN N'Abono por devolución' WHEN h.PIHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PIHTYP_0) END AS PIHTYP_0, CASE WHEN h.STA_0=1 THEN N'Pendiente' WHEN h.STA_0=2 THEN N'Por validar' WHEN h.STA_0=3 THEN N'Validada' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, CASE WHEN h.PAZ_0=1 THEN N'Pendiente' WHEN h.PAZ_0=2 THEN N'En conflicto' WHEN h.PAZ_0=3 THEN N'Aplazado' WHEN h.PAZ_0=4 THEN N'Autorizado al pago' WHEN h.PAZ_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PAZ_0) END AS PAZ_0, h.PIVTYP_0, RTRIM(h.BPRPAY_0) AS BPRPAY_0, h.PTE_0, h.STRDUDDAT_0, h.DES_0, h.DES_1, h.DES_2, h.DES_3, h.DES_4 FROM PINVOICE h WHERE h.ORIMOD_0=6 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICE',N'U') AND OBJECT_ID(N'PINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICED',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(RTRIM(l.NUM_0)),N':',RTRIM(l.NUM_0),N':',l.PIDLIN_0) AS LineKey, RTRIM(l.NUM_0) AS NUM_0, l.PIDLIN_0, l.ITMREF_0, l.ITMDES_0, l.ITMDES1_0, RTRIM(l.CPY_0) AS CPY_0, l.BPR_0, h.CUR_0 AS CUR_0, l.QTYPUU_0, l.PUU_0, l.QTYSTU_0, l.STU_0, l.NETCUR_0, l.NETPRI_0, l.AMTNOTLIN_0, l.POHNUM_0, l.PTHNUM_0, l.RCPDAT_0 FROM PINVOICED l JOIN PINVOICE h ON h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.ORIMOD_0=6 AND h.NUM_0=:invoice AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICE',N'U') AND OBJECT_ID(N'PINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICED',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage X3 — SQL Server, carpeta autorizada del usuario",
"id": "8E048244-1699-58B4-857D-0EE6BC993916",
"kind": "sqlServer",
"requiredObjects": [
"PINVOICE",
"PINVOICED"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "75CB272A-7DC6-5F90-8D6D-7BEE18C162B9",
"key": "ACCDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "0D12EED2-00E8-5F16-87CE-A6B7F515FBD3",
"key": "NUM_0",
"type": "text"
}
],
"id": "FC53E536-45B0-585E-B0EF-C39198F2B63D",
"mappings": [
{
"commonFieldKey": "",
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NUM_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 (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRNAM_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPR_0",
"label": "Código de proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FCY_0",
"label": "Centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BPRDAT_0",
"label": "Fecha factura del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRVCR_0",
"label": "Número factura del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRVCR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTNOT_0",
"label": "Importe sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTNOT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTATI_0",
"label": "Importe con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PIHTYP_0",
"label": "Categoría de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PIHTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STA_0",
"label": "Estado de la factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PAZ_0",
"label": "Aprobación del pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PAZ_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PIVTYP_0",
"label": "Tipo de factura (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PIVTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRPAY_0",
"label": "Destinatario del pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRPAY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PTE_0",
"label": "Condiciones de pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PTE_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STRDUDDAT_0",
"label": "Fecha base de vencimientos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STRDUDDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_0",
"label": "Observación 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_1",
"label": "Observación 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_2",
"label": "Observación 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_3",
"label": "Observación 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DES_4",
"label": "Observación 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DES_4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Facturas de compra",
"primaryKey": "NUM_0",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"NUM_0",
"BPRNAM_0",
"BPRNAM_1",
"BPR_0",
"CPY_0",
"FCY_0",
"ACCDAT_0",
"BPRDAT_0",
"BPRVCR_0",
"CUR_0",
"AMTNOT_0",
"AMTATI_0",
"PIHTYP_0",
"STA_0",
"PAZ_0",
"PIVTYP_0",
"BPRPAY_0",
"PTE_0",
"STRDUDDAT_0",
"DES_0",
"DES_1",
"DES_2",
"DES_3",
"DES_4"
],
"sourceID": "8E048244-1699-58B4-857D-0EE6BC993916",
"sqlQuery": "SELECT RTRIM(h.NUM_0) AS NUM_0, h.BPRNAM_0, h.BPRNAM_1, RTRIM(h.BPR_0) AS BPR_0, RTRIM(h.CPY_0) AS CPY_0, h.FCY_0, h.ACCDAT_0, h.BPRDAT_0, h.BPRVCR_0, h.CUR_0, h.AMTNOT_0, h.AMTATI_0, CASE WHEN h.PIHTYP_0=1 THEN N'Factura' WHEN h.PIHTYP_0=2 THEN N'Factura adicional' WHEN h.PIHTYP_0=3 THEN N'Abono' WHEN h.PIHTYP_0=4 THEN N'Abono por devolución' WHEN h.PIHTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PIHTYP_0) END AS PIHTYP_0, CASE WHEN h.STA_0=1 THEN N'Pendiente' WHEN h.STA_0=2 THEN N'Por validar' WHEN h.STA_0=3 THEN N'Validada' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, CASE WHEN h.PAZ_0=1 THEN N'Pendiente' WHEN h.PAZ_0=2 THEN N'En conflicto' WHEN h.PAZ_0=3 THEN N'Aplazado' WHEN h.PAZ_0=4 THEN N'Autorizado al pago' WHEN h.PAZ_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.PAZ_0) END AS PAZ_0, h.PIVTYP_0, RTRIM(h.BPRPAY_0) AS BPRPAY_0, h.PTE_0, h.STRDUDDAT_0, h.DES_0, h.DES_1, h.DES_2, h.DES_3, h.DES_4 FROM PINVOICE h WHERE h.ORIMOD_0=6 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICE',N'U') AND OBJECT_ID(N'PINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICED',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "961168CA-075E-582A-97EF-799612A38285",
"key": "PIDLIN_0",
"type": "number"
}
],
"id": "A1AFA403-15BA-518B-B203-FF3216867819",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Clave interna completa de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NUM_0",
"label": "Documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PIDLIN_0",
"label": "Clave interna de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PIDLIN_0",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMREF_0",
"label": "Código de producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITMREF_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITMDES_0",
"label": "Producto / servicio",
"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": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CPY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPR_0",
"label": "Tercero de la línea (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QTYPUU_0",
"label": "Cantidad en unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYPUU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PUU_0",
"label": "Unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PUU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYSTU_0",
"label": "Cantidad en unidad de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYSTU_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STU_0",
"label": "Unidad de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STU_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NETCUR_0",
"label": "Moneda de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETCUR_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NETPRI_0",
"label": "Precio neto de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTNOTLIN_0",
"label": "Importe línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTNOTLIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "POHNUM_0",
"label": "Pedido origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "POHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PTHNUM_0",
"label": "Recepción origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PTHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCPDAT_0",
"label": "Fecha de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Líneas de compra",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NUM_0",
"id": "059926AD-B7C4-518B-AD08-A61A138E38B7",
"name": "invoice",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "5EAB4D00-D7EE-5765-A5B4-3A1C17F2D4AC",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"NUM_0",
"ITMREF_0",
"ITMDES_0",
"ITMDES1_0",
"CPY_0",
"BPR_0",
"CUR_0",
"QTYPUU_0",
"PUU_0",
"QTYSTU_0",
"STU_0",
"NETCUR_0",
"NETPRI_0",
"AMTNOTLIN_0",
"POHNUM_0",
"PTHNUM_0",
"RCPDAT_0"
],
"sourceID": "8E048244-1699-58B4-857D-0EE6BC993916",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(l.NUM_0)),N':',RTRIM(l.NUM_0),N':',l.PIDLIN_0) AS LineKey, RTRIM(l.NUM_0) AS NUM_0, l.PIDLIN_0, l.ITMREF_0, l.ITMDES_0, l.ITMDES1_0, RTRIM(l.CPY_0) AS CPY_0, l.BPR_0, h.CUR_0 AS CUR_0, l.QTYPUU_0, l.PUU_0, l.QTYSTU_0, l.STU_0, l.NETCUR_0, l.NETPRI_0, l.AMTNOTLIN_0, l.POHNUM_0, l.PTHNUM_0, l.RCPDAT_0 FROM PINVOICED l JOIN PINVOICE h ON h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.ORIMOD_0=6 AND h.NUM_0=:invoice AND h.CPY_0=:company AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICE',N'U') AND OBJECT_ID(N'PINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PINVOICED',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "6A637024-F876-55F4-B756-427589CA9B55",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DDB0BCF6-9699-5AA7-A1CE-ABAF760D7B7D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A1AFA403-15BA-518B-B203-FF3216867819",
"title": "Líneas de compra",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PIHTYP_0",
"label": "Categoría de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTNOT_0",
"label": "Importe sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTATI_0",
"label": "Importe con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PAZ_0",
"label": "Aprobación del pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "FC53E536-45B0-585E-B0EF-C39198F2B63D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_0",
"label": "Proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_1",
"label": "Proveedor (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "BPR_0",
"label": "Código de proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "FCY_0",
"label": "Centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "PIHTYP_0",
"label": "Categoría de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "PIVTYP_0",
"label": "Tipo de factura (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y proveedor",
"detailRole": "information",
"isVisible": true,
"key": "STA_0",
"label": "Estado de la factura",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y referencia",
"detailRole": "information",
"isVisible": true,
"key": "ACCDAT_0",
"label": "Fecha contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y referencia",
"detailRole": "information",
"isVisible": true,
"key": "BPRDAT_0",
"label": "Fecha factura del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y referencia",
"detailRole": "information",
"isVisible": true,
"key": "BPRVCR_0",
"label": "Número factura del proveedor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "AMTNOT_0",
"label": "Importe sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "AMTATI_0",
"label": "Importe con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "PAZ_0",
"label": "Aprobación del pago",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "BPRPAY_0",
"label": "Destinatario del pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "PTE_0",
"label": "Condiciones de pago (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Importes y pago",
"detailRole": "information",
"isVisible": true,
"key": "STRDUDDAT_0",
"label": "Fecha base de vencimientos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Observaciones",
"detailRole": "information",
"isVisible": true,
"key": "DES_0",
"label": "Observación 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Observaciones",
"detailRole": "information",
"isVisible": true,
"key": "DES_1",
"label": "Observación 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Observaciones",
"detailRole": "information",
"isVisible": true,
"key": "DES_2",
"label": "Observación 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Observaciones",
"detailRole": "information",
"isVisible": true,
"key": "DES_3",
"label": "Observación 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Observaciones",
"detailRole": "information",
"isVisible": true,
"key": "DES_4",
"label": "Observación 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "569E148E-D598-5A9B-8E91-4EE19121BF05",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "2CB0BD08-DC54-56DF-A434-CDCE51AE7E97",
"includeAllOption": false,
"key": "ACCDAT_0",
"title": "Periodo contable",
"type": "date"
},
{
"id": "41FD5B3B-9362-501B-96F5-252D4324538A",
"includeAllOption": false,
"key": "CPY_0",
"title": "Empresa",
"type": "text"
},
{
"id": "B83E8F30-F33C-5600-AAD7-A46183C9B94C",
"includeAllOption": true,
"key": "PIHTYP_0",
"title": "Categoría de compra",
"type": "text"
},
{
"id": "3E327232-D9B5-5691-A94E-AA8838F8881D",
"includeAllOption": true,
"key": "PAZ_0",
"title": "Aprobación del pago",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "75CB272A-7DC6-5F90-8D6D-7BEE18C162B9",
"key": "ACCDAT_0",
"type": "date"
},
{
"direction": "ascending",
"id": "0D12EED2-00E8-5F16-87CE-A6B7F515FBD3",
"key": "NUM_0",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "NUM_0",
"systemImage": "doc.text",
"title": "Facturas de compra",
"titleKey": "BPRNAM_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYPUU_0",
"label": "Cantidad en unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "Unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NETCUR_0",
"label": "Moneda de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NETPRI_0",
"label": "Precio neto de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTNOTLIN_0",
"label": "Importe línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RCPDAT_0",
"label": "Fecha de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A1AFA403-15BA-518B-B203-FF3216867819",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES_0",
"label": "Producto / servicio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "ITMDES1_0",
"label": "Descripción adicional",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "ITMREF_0",
"label": "Código de producto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Producto y documento",
"detailRole": "information",
"isVisible": true,
"key": "BPR_0",
"label": "Tercero de la línea (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "QTYPUU_0",
"label": "Cantidad en unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "PUU_0",
"label": "Unidad de compra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "QTYSTU_0",
"label": "Cantidad en unidad de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "STU_0",
"label": "Unidad de stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Monedas e importes",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Monedas e importes",
"detailRole": "information",
"isVisible": true,
"key": "NETCUR_0",
"label": "Moneda de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Monedas e importes",
"detailRole": "information",
"isVisible": true,
"key": "NETPRI_0",
"label": "Precio neto de la línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Monedas e importes",
"detailRole": "information",
"isVisible": true,
"key": "AMTNOTLIN_0",
"label": "Importe línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y recepción",
"detailRole": "information",
"isVisible": true,
"key": "POHNUM_0",
"label": "Pedido origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y recepción",
"detailRole": "information",
"isVisible": true,
"key": "PTHNUM_0",
"label": "Recepción origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y recepción",
"detailRole": "information",
"isVisible": true,
"key": "RCPDAT_0",
"label": "Fecha de recepción",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "889D0EB9-B326-5F06-9701-783145A38C85",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "961168CA-075E-582A-97EF-799612A38285",
"key": "PIDLIN_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "ITMREF_0",
"systemImage": "shippingbox",
"title": "Líneas de compra",
"titleKey": "ITMDES_0"
}
],
"relations": [
{
"childDatasetID": "A1AFA403-15BA-518B-B203-FF3216867819",
"childKey": "NUM_0",
"id": "DDB0BCF6-9699-5AA7-A1CE-ABAF760D7B7D",
"name": "Líneas de compra",
"parentDatasetID": "FC53E536-45B0-585E-B0EF-C39198F2B63D",
"parentKey": "NUM_0"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage X3",
"configurationLanguages": [
"es"
],
"countries": [
"ES"
],
"createdAt": "2026-10-07T00:00:00Z",
"description": "NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.\n\nPara compras, administración, contabilidad y responsables de empresa: elige periodo contable y empresa; puedes filtrar también categoría de compra y aprobación del pago. Consulta proveedor, referencia de su factura, centro, moneda e importes sin/con impuestos. La ficha separa validación de la factura y aprobación del pago, muestra destinatario del pago, condiciones, fecha base de vencimientos y cinco observaciones. El sub-botón abre solo sus líneas: producto/servicio, cantidades y unidades de compra/stock, precio neto e importe sin impuestos nativos, moneda propia de la línea, pedido, recepción y fecha de recepción.\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, dos listas, una relación y consultas SELECT con proyección explícita. Filtros nativos de apertura antes del límite de lectura; no hay parámetros SQL de periodo obligatorios que bloqueen descubrir empresas/categorías antes de elegir fechas. Líneas delimitadas por documento y empresa. Máximo 2.000 filas por lista, sin refresco programado. Reduce el periodo si alcanzas el límite; los filtros y el límite no garantizan una consulta barata ni resultados completos. Verifica índices, tiempos y permisos.\n\nALCANCE: módulo Compras (ORIMOD=6). Categorías: factura, factura adicional, abono y abono por devolución (PIHTYP, menú 533). No se mezclan las facturas contables de terceros (ORIMOD=3), que usan otros detalles. Estado de factura (STA, menú 509): pendiente/por validar/validada, distinto del estado de ventas. Aprobación del pago (PAZ, menú 510): pendiente/en conflicto/aplazado/autorizado al pago; autorizado no significa pagado. No se deduce saldo o deuda ni se ofrecen acciones para aprobar, contabilizar o pagar. BPRPAY es el tercero destinatario del pago, no una cuenta bancaria. PIVTYP y PTE son códigos de configuración. La fecha base de vencimientos no es una fecha de vencimiento efectiva.\n\nMONEDAS: la cabecera conserva importes nativos en CUR. La línea conserva NETCUR de su documento origen, que puede diferir de CUR; se muestran ambas sin sustituir ni convertir. Precio neto y importe sin impuestos son valores almacenados, no se recalculan como precio × cantidad. Se conservan cantidades y unidades de compra y stock separadas; puede haber líneas financieras sin producto o cantidad y ajustes de redondeo. No se suman ni compensan monedas, no se aplican signos de abonos y no se presupone que el total de cabecera sea la suma de las líneas. No incluye desglose fiscal, valoración de costes, saldos, vencimientos ni liquidaciones.\n\nREQUISITO: Sage X3 v12 SQL Server y acceso autorizado. El administrador confirma base/carpeta empresarial y prepara un usuario dedicado, esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. OBJECT_ID comprueba tablas frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no hay descubrimiento automático de objetos. Un test de estructura vacío no demuestra la carpeta correcta. Confirma esquema y una vista previa real al importar. Los filtros no son control de acceso; SQL no hereda automáticamente permisos de rol/centro de X3. El paquete no cambia usuarios, permisos, esquemas ni tablas.\n\nDiccionario v12, claves únicas completas, menús de compra y regla SQL oficial campo_indice con dimensiones completas; nombres documentados por esa regla, no DDL ni metadatos de una instalación. Los alias de pantalla LIBPAZ/DUDDAT1/UOM no se inventan como columnas de estas tablas. Códigos desconocidos se muestran como Código N. Verifica versión, tipos, permisos, moneda, rendimiento y lectura/compatibilidad antes de uso real. Capturas nativas Cifru con transporte sintético y datos DEMO ficticios: no validadas en Sage X3/SQL Server reales. No contiene servidor, credenciales ni filas empresariales. No oficial, sin afiliación a Sage.\n\nFuentes primarias:\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/PINVOICE.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/PINVOICED.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00014.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00533.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00509.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN00510.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESPIH.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": "BCFFBD44-E82C-5758-9B1E-0DF9CD40F885",
"rootButtonCount": 1,
"summary": "Periodo y empresa; proveedor, importes, validación y aprobación del pago; líneas con unidades, monedas y recepción.",
"tags": [
"Sage X3",
"SQL Server",
"Facturas",
"Compras",
"Proveedores",
"Contabilidad",
"Pro"
],
"title": "Facturas de compra y líneas — Pro"
}
}