Facturas comerciales y líneas — Pro
Periodo y empresa; facturas/abonos, importes y estado contable; líneas con cantidades, unidades y precios.
NO OFICIAL — NO VALIDADO EN UNA INSTALACIÓN ERP REAL.
Para ventas, atención al cliente, contabilidad y responsables de empresa: elige periodo contable, empresa y categoría; consulta cliente, documento, centro, moneda, importes sin/con impuestos y estado contable. Abre la ficha con las dos líneas de nombre, referencias, condiciones de pago y cinco observaciones. El sub-botón muestra productos o servicios de esa factura: cantidades y unidades de venta/stock, precios netos sin/con impuestos, importes nativos y documentos de origen.
¿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. El periodo contable y la empresa se aplican con filtros nativos de apertura antes del límite de lectura; no hay parámetros de periodo obligatorios que bloqueen descubrir las empresas antes de elegir fechas. Se leen solo las líneas del documento y empresa seleccionados, con moneda obtenida de su cabecera única. Máximo 2.000 filas por lista, sin refresco programado; reduce el periodo si alcanzas el límite. El límite de filas y el filtro no garantizan una consulta barata ni resultados completos; verifica índices, tiempos y permisos.
ALCANCE: documentos del módulo Ventas (ORIMOD=5), incluidas factura, abono, nota de débito, nota de crédito y proforma. Las facturas contables de terceros (ORIMOD=3) usan otras tablas de detalle y no se mezclan. El estado significa sin contabilizar/no utilizado/contabilizado, nunca pagado o pendiente de cobro. La fecha base de vencimientos no es una fecha de vencimiento efectiva. Los términos son códigos, no días calculados. Los importes son los valores almacenados en la moneda del documento; no se aplican signos, conversiones, compensaciones ni sumas entre monedas. Las cantidades de venta y stock conservan su unidad. Los precios sin y con impuestos son columnas explícitas; no se calcula el importe como precio × cantidad. La cabecera puede incluir impuestos, descuentos, redondeos o elementos de valoración no representados como productos; no se afirma que su total sea siempre la suma de estas líneas. Este paquete no incluye liquidaciones, vencimientos, saldos, valoración detallada SINVOICEV, ficha actual de producto ni acciones de escritura.
REQUISITO: Sage X3 v12 SQL Server con acceso autorizado. El administrador confirma la base/carpeta empresarial y prepara un usuario dedicado con esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. SQL Pro directo comprueba OBJECT_ID frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no usa descubrimiento automático de tablas. Un test de estructura vacío no demuestra la carpeta correcta. Confirma el esquema y una vista previa real al importar. Los filtros no son control de acceso y SQL no hereda automáticamente los permisos de rol/centro de X3. No cambia usuarios, permisos, esquemas ni tablas.
Diccionario v12, regla SQL oficial campo_indice y dimensiones completas; nombres físicos documentados por esa regla, no DDL/metadatos de una instalación. La nota de soporte sobre tablas de líneas es de 2018, contrastada con diccionario y menús v12. Códigos desconocidos se muestran como Código N. Verifica versión, tipos, permisos, 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. El paquete 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/SINVOICE.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/SINVOICED.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/MEN00645.htm
https://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02261.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESSIH.htm
https://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm
https://communityhub.sage.com/sage-global-solutions/sage_x3/b/sageerp_x3_product_support_blog/posts/excuse-me-have-you-seen-my-invoice-lines
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Facturas comerciales
- Details: Líneas de factura
- Sub-button: Líneas de factura
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.INVTYP_0=1 THEN N'Factura' WHEN h.INVTYP_0=2 THEN N'Abono' WHEN h.INVTYP_0=3 THEN N'Nota de débito' WHEN h.INVTYP_0=4 THEN N'Nota de crédito' WHEN h.INVTYP_0=5 THEN N'Proforma' WHEN h.INVTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVTYP_0) END AS INVTYP_0, CASE WHEN h.STA_0=1 THEN N'Sin contabilizar' WHEN h.STA_0=2 THEN N'No utilizado' WHEN h.STA_0=3 THEN N'Contabilizado' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, h.PTE_0, h.STRDUDDAT_0, h.DES_0, h.DES_1, h.DES_2, h.DES_3, h.DES_4 FROM SINVOICE h WHERE h.ORIMOD_0=5 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICE',N'U') AND OBJECT_ID(N'SINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICED',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.SIDLIN_0) AS LineKey, RTRIM(l.NUM_0) AS NUM_0, l.SIDLIN_0, l.ITMREF_0, l.ITMDES_0, l.ITMDES1_0, RTRIM(l.CPY_0) AS CPY_0, l.BPCINV_0, h.CUR_0 AS CUR_0, l.QTY_0, l.SAU_0, l.QTYSTU_0, l.STU_0, l.NETPRINOT_0, l.NETPRIATI_0, l.AMTNOTLIN_0, l.AMTATILIN_0, l.STOFCY_0, l.SOHNUM_0, l.SDHNUM_0 FROM SINVOICED l JOIN SINVOICE h ON h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.ORIMOD_0=5 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'SINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICE',N'U') AND OBJECT_ID(N'SINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICED',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": "83B2573A-81B3-5634-80A5-C97B398FDE5A",
"kind": "sqlServer",
"requiredObjects": [
"SINVOICE",
"SINVOICED"
],
"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": "B2EAA67F-D769-576E-9432-FE2765570F47",
"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": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRNAM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRNAM_1",
"label": "Cliente (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRNAM_1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPR_0",
"label": "Código de tercero",
"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 del documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPRDAT_0",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BPRVCR_0",
"label": "Referencia del documento origen",
"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": "INVTYP_0",
"label": "Categoría",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVTYP_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STA_0",
"label": "Estado contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STA_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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 comerciales",
"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",
"INVTYP_0",
"STA_0",
"PTE_0",
"STRDUDDAT_0",
"DES_0",
"DES_1",
"DES_2",
"DES_3",
"DES_4"
],
"sourceID": "83B2573A-81B3-5634-80A5-C97B398FDE5A",
"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.INVTYP_0=1 THEN N'Factura' WHEN h.INVTYP_0=2 THEN N'Abono' WHEN h.INVTYP_0=3 THEN N'Nota de débito' WHEN h.INVTYP_0=4 THEN N'Nota de crédito' WHEN h.INVTYP_0=5 THEN N'Proforma' WHEN h.INVTYP_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.INVTYP_0) END AS INVTYP_0, CASE WHEN h.STA_0=1 THEN N'Sin contabilizar' WHEN h.STA_0=2 THEN N'No utilizado' WHEN h.STA_0=3 THEN N'Contabilizado' WHEN h.STA_0 IS NULL THEN N'' ELSE CONCAT(N'Código ',h.STA_0) END AS STA_0, h.PTE_0, h.STRDUDDAT_0, h.DES_0, h.DES_1, h.DES_2, h.DES_3, h.DES_4 FROM SINVOICE h WHERE h.ORIMOD_0=5 AND SCHEMA_NAME() NOT IN (N'dbo',N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICE',N'U') AND OBJECT_ID(N'SINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICED',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8A84D3A8-1B04-539C-AB19-2887F1066BDA",
"key": "SIDLIN_0",
"type": "number"
}
],
"id": "7F14A1B4-0C0A-5D7F-B0EC-9764040BF8F9",
"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": "SIDLIN_0",
"label": "Clave interna de línea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SIDLIN_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": "BPCINV_0",
"label": "Cliente facturado (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BPCINV_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": "QTY_0",
"label": "Cantidad facturada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTY_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SAU_0",
"label": "Unidad de venta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SAU_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": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRINOT_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NETPRIATI_0",
"label": "Precio neto con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NETPRIATI_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"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": "AMTATILIN_0",
"label": "Importe línea con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTATILIN_0",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOFCY_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SOHNUM_0",
"label": "Pedido origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SOHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SDHNUM_0",
"label": "Entrega origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SDHNUM_0",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Líneas de factura",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NUM_0",
"id": "FEB2C258-8CB6-5BB3-A6A5-B05B942AFB75",
"name": "invoice",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CPY_0",
"id": "98E0443A-43BE-5909-917A-DEDB0775FEF7",
"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",
"BPCINV_0",
"CUR_0",
"QTY_0",
"SAU_0",
"QTYSTU_0",
"STU_0",
"NETPRINOT_0",
"NETPRIATI_0",
"AMTNOTLIN_0",
"AMTATILIN_0",
"STOFCY_0",
"SOHNUM_0",
"SDHNUM_0"
],
"sourceID": "83B2573A-81B3-5634-80A5-C97B398FDE5A",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(l.NUM_0)),N':',RTRIM(l.NUM_0),N':',l.SIDLIN_0) AS LineKey, RTRIM(l.NUM_0) AS NUM_0, l.SIDLIN_0, l.ITMREF_0, l.ITMDES_0, l.ITMDES1_0, RTRIM(l.CPY_0) AS CPY_0, l.BPCINV_0, h.CUR_0 AS CUR_0, l.QTY_0, l.SAU_0, l.QTYSTU_0, l.STU_0, l.NETPRINOT_0, l.NETPRIATI_0, l.AMTNOTLIN_0, l.AMTATILIN_0, l.STOFCY_0, l.SOHNUM_0, l.SDHNUM_0 FROM SINVOICED l JOIN SINVOICE h ON h.NUM_0=l.NUM_0 AND h.CPY_0=l.CPY_0 WHERE h.ORIMOD_0=5 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'SINVOICE',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICE',N'U') AND OBJECT_ID(N'SINVOICED',N'U') = OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SINVOICED',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "024AEE94-4C8A-5B6D-BE93-D5E143E725F4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6B11C0D3-C23A-5F66-8281-2F0FDB75B733",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7F14A1B4-0C0A-5D7F-B0EC-9764040BF8F9",
"title": "Líneas de factura",
"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": "INVTYP_0",
"label": "Categoría",
"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": "STA_0",
"label": "Estado contable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B2EAA67F-D769-576E-9432-FE2765570F47",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "NUM_0",
"label": "Número de documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_0",
"label": "Cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPRNAM_1",
"label": "Cliente (continuación)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "BPR_0",
"label": "Código de tercero",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "CPY_0",
"label": "Empresa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "FCY_0",
"label": "Centro",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "INVTYP_0",
"label": "Categoría",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento y cliente",
"detailRole": "information",
"isVisible": true,
"key": "STA_0",
"label": "Estado contable",
"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 del documento origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fechas y referencia",
"detailRole": "information",
"isVisible": true,
"key": "BPRVCR_0",
"label": "Referencia del documento origen",
"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": "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": "CC342088-AD74-556C-B966-3695AEC4C52C",
"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": "D7511453-2DFC-55A6-A00C-F460AE1078E4",
"includeAllOption": true,
"key": "INVTYP_0",
"title": "Categoría",
"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 comerciales",
"titleKey": "BPRNAM_0"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTY_0",
"label": "Cantidad facturada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SAU_0",
"label": "Unidad de venta",
"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": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"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": "AMTATILIN_0",
"label": "Importe línea con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "7F14A1B4-0C0A-5D7F-B0EC-9764040BF8F9",
"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": "BPCINV_0",
"label": "Cliente facturado (código)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "QTY_0",
"label": "Cantidad facturada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantidades y unidades",
"detailRole": "information",
"isVisible": true,
"key": "SAU_0",
"label": "Unidad de venta",
"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": "Precios e importes",
"detailRole": "information",
"isVisible": true,
"key": "CUR_0",
"label": "Moneda del documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Precios e importes",
"detailRole": "information",
"isVisible": true,
"key": "NETPRINOT_0",
"label": "Precio neto sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Precios e importes",
"detailRole": "information",
"isVisible": true,
"key": "NETPRIATI_0",
"label": "Precio neto con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Precios e importes",
"detailRole": "information",
"isVisible": true,
"key": "AMTNOTLIN_0",
"label": "Importe línea sin impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Precios e importes",
"detailRole": "information",
"isVisible": true,
"key": "AMTATILIN_0",
"label": "Importe línea con impuestos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y logística",
"detailRole": "information",
"isVisible": true,
"key": "STOFCY_0",
"label": "Centro de expedición",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y logística",
"detailRole": "information",
"isVisible": true,
"key": "SOHNUM_0",
"label": "Pedido origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Origen y logística",
"detailRole": "information",
"isVisible": true,
"key": "SDHNUM_0",
"label": "Entrega origen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BB73CFBE-D82D-5B7A-8B88-1B491571317C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "8A84D3A8-1B04-539C-AB19-2887F1066BDA",
"key": "SIDLIN_0",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "ITMREF_0",
"systemImage": "shippingbox",
"title": "Líneas de factura",
"titleKey": "ITMDES_0"
}
],
"relations": [
{
"childDatasetID": "7F14A1B4-0C0A-5D7F-B0EC-9764040BF8F9",
"childKey": "NUM_0",
"id": "6B11C0D3-C23A-5F66-8281-2F0FDB75B733",
"name": "Líneas de factura",
"parentDatasetID": "B2EAA67F-D769-576E-9432-FE2765570F47",
"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 ventas, atención al cliente, contabilidad y responsables de empresa: elige periodo contable, empresa y categoría; consulta cliente, documento, centro, moneda, importes sin/con impuestos y estado contable. Abre la ficha con las dos líneas de nombre, referencias, condiciones de pago y cinco observaciones. El sub-botón muestra productos o servicios de esa factura: cantidades y unidades de venta/stock, precios netos sin/con impuestos, importes nativos y documentos de origen.\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. El periodo contable y la empresa se aplican con filtros nativos de apertura antes del límite de lectura; no hay parámetros de periodo obligatorios que bloqueen descubrir las empresas antes de elegir fechas. Se leen solo las líneas del documento y empresa seleccionados, con moneda obtenida de su cabecera única. Máximo 2.000 filas por lista, sin refresco programado; reduce el periodo si alcanzas el límite. El límite de filas y el filtro no garantizan una consulta barata ni resultados completos; verifica índices, tiempos y permisos.\n\nALCANCE: documentos del módulo Ventas (ORIMOD=5), incluidas factura, abono, nota de débito, nota de crédito y proforma. Las facturas contables de terceros (ORIMOD=3) usan otras tablas de detalle y no se mezclan. El estado significa sin contabilizar/no utilizado/contabilizado, nunca pagado o pendiente de cobro. La fecha base de vencimientos no es una fecha de vencimiento efectiva. Los términos son códigos, no días calculados. Los importes son los valores almacenados en la moneda del documento; no se aplican signos, conversiones, compensaciones ni sumas entre monedas. Las cantidades de venta y stock conservan su unidad. Los precios sin y con impuestos son columnas explícitas; no se calcula el importe como precio × cantidad. La cabecera puede incluir impuestos, descuentos, redondeos o elementos de valoración no representados como productos; no se afirma que su total sea siempre la suma de estas líneas. Este paquete no incluye liquidaciones, vencimientos, saldos, valoración detallada SINVOICEV, ficha actual de producto ni acciones de escritura.\n\nREQUISITO: Sage X3 v12 SQL Server con acceso autorizado. El administrador confirma la base/carpeta empresarial y prepara un usuario dedicado con esquema predeterminado igual a esa carpeta y solo SELECT sobre datos autorizados. No se presupone dbo/SEED ni se usa sa/sysadmin. SQL Pro directo comprueba OBJECT_ID frente al esquema predeterminado y rechaza dbo, guest, sys e INFORMATION_SCHEMA; no usa descubrimiento automático de tablas. Un test de estructura vacío no demuestra la carpeta correcta. Confirma el esquema y una vista previa real al importar. Los filtros no son control de acceso y SQL no hereda automáticamente los permisos de rol/centro de X3. No cambia usuarios, permisos, esquemas ni tablas.\n\nDiccionario v12, regla SQL oficial campo_indice y dimensiones completas; nombres físicos documentados por esa regla, no DDL/metadatos de una instalación. La nota de soporte sobre tablas de líneas es de 2018, contrastada con diccionario y menús v12. Códigos desconocidos se muestran como Código N. Verifica versión, tipos, permisos, 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. El paquete 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/SINVOICE.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/SINVOICED.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/MEN00645.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/MCD/MEN02261.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESSIH.htm\nhttps://online-help.sagex3.com/erp/12/en-us/Content/FCT/GESALQ.htm\nhttps://communityhub.sage.com/sage-global-solutions/sage_x3/b/sageerp_x3_product_support_blog/posts/excuse-me-have-you-seen-my-invoice-lines",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "B506BD6D-84A3-5C68-AED4-E4DA2C5B6D02",
"rootButtonCount": 1,
"summary": "Periodo y empresa; facturas/abonos, importes y estado contable; líneas con cantidades, unidades y precios.",
"tags": [
"Sage X3",
"SQL Server",
"Facturas",
"Ventas",
"Contabilidad",
"Pro"
],
"title": "Facturas comerciales y líneas — Pro"
}
}