Journaux, comptes et écritures — Pro
Période comptable → journal → compte → écritures.
NON OFFICIEL — NON VALIDÉ SUR UNE INSTALLATION ERP RÉELLE. Configuration issue de la documentation publique et testée avec des données synthétiques. À l’import, vérifier la version, les tables, les champs et les résultats avec votre administrateur Sage. Les captures natives Cifru montrent uniquement des données DEMO fictives.
Totaux débit/crédit par journal sur la période comptable choisie, puis comptes et écritures à la demande. La date comptable est reconstruite à partir du mois JM_Date et du jour EC_Jour, pas de EC_Date. Les dates comptables invalides restent sans date et sont exclues des totaux de période, sans décalage automatique au mois suivant. Les montants négatifs conservent leur signe. Ceci ne remplace pas une balance légale.
Pourquoi Cifru ? Adaptez les configurations à votre façon de travailler. Choisissez les champs, filtres et détails utiles, et retrouvez sur votre téléphone des informations qui peuvent manquer dans l’application mobile de votre logiciel de gestion. Les possibilités dépendent des données accessibles dans votre source autorisée et de votre offre Cifru.
Sage 100 France 12.20, Comptabilité sur Microsoft SQL Server. Une base société autorisée et un compte de lecture seulement sont nécessaires. Aucun accès fourni par le développeur. Aucun mot de passe ni donnée métier dans ce paquet. Les montants sont les valeurs natives Sage : aucun taux inventé, aucune conversion ni somme entre sociétés ou devises différentes. Vérifier la devise de tenue et les paramètres de devise de la société. Les indices de devise Sage ne sont pas des codes ISO. Les tarifs article ne remplacent pas un prix négocié client/fournisseur. Lecture à la demande, sans rafraîchissement périodique ; maximum 2 000 lignes par lecture. Réduire la période ou les filtres si la limite est atteinte. Les identifiants internes servent aux liens et ne sont pas affichés.
Structure issue du manuel public 12.20 ; pas encore testé sur une base Sage sous licence. Les tables, colonnes, cbMarq, droits et performances doivent être vérifiés sur la version cible. Les modules et personnalisations peuvent différer. Les exemples DEMO ne certifient pas la compatibilité réelle. Documentation officielle : https://fr-kb.sage.com/
Lecture des champs : « Encours autorisé » est le plafond saisi sur la fiche tiers, pas le solde dû. Les indicateurs 0/1 signifient non/oui. Sur Free, suivi stock : 0 aucun, 1 série, 2 CMUP, 3 FIFO, 4 LIFO, 5 lot ; unité poids : 0 tonne, 1 quintal, 2 kilogramme, 3 gramme, 4 milligramme ; statut document : 0 saisie, 1 confirmé, 2 accepté. Un statut de document ne prouve ni paiement ni livraison. Sur Pro, les modes de taxe sont explicités : la valeur se lit avec son unité et sa nature, sans calculer une taxe supplémentaire.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Journaux
- Details: Comptes et totaux
- Details: Écritures détaillées
- Sub-button: Comptes du journal
- Sub-button: Écritures du compte
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 CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)) AS journal_context, :date_from AS period_start, :date_until AS period_until, e.JO_Num, COALESCE(j.JO_Intitule, e.JO_Num) AS JO_Intitule, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant ELSE 0 END) AS Debit, SUM(CASE WHEN e.EC_Sens = 1 THEN e.EC_Montant ELSE 0 END) AS Credit, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant WHEN e.EC_Sens = 1 THEN -e.EC_Montant ELSE 0 END) AS Balance, COUNT(e.EC_No) AS LineCount FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_JOURNAUX j ON j.JO_Num = e.JO_Num WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until GROUP BY e.JO_Num, j.JO_Intitule
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)), N':', DATALENGTH(e.CG_Num), N':', e.CG_Num) AS account_context, CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)) AS journal_context, :date_from AS period_start, :date_until AS period_until, e.JO_Num, e.CG_Num, COALESCE(g.CG_Intitule, e.CG_Num) AS CG_Intitule, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant ELSE 0 END) AS Debit, SUM(CASE WHEN e.EC_Sens = 1 THEN e.EC_Montant ELSE 0 END) AS Credit, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant WHEN e.EC_Sens = 1 THEN -e.EC_Montant ELSE 0 END) AS Balance, COUNT(e.EC_No) AS LineCount FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_COMPTEG g ON g.CG_Num = e.CG_Num AND g.CG_Type = 0 WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until AND e.JO_Num = :journal GROUP BY e.JO_Num, e.CG_Num, g.CG_Intitule
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)), N':', DATALENGTH(e.CG_Num), N':', e.CG_Num) AS account_context, (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) AS PostingDate, CASE e.EC_Sens WHEN 0 THEN N'Débit' WHEN 1 THEN N'Crédit' ELSE N'Indéterminé' END AS Sens, e.[EC_No], e.[JO_Num], e.[JM_Date], e.[EC_Jour], e.[EC_Date], e.[EC_Piece], e.[EC_RefPiece], e.[CG_Num], e.[CG_NumCont], e.[CT_Num], e.[EC_Intitule], e.[EC_Echeance], e.[EC_Sens], e.[EC_Montant], e.[N_Devise], e.[EC_Parite], e.[EC_Lettre], e.[EC_Lettrage], e.[EC_Cloture], e.[EC_CType], e.[EC_Quantite], g.CG_Intitule, t.CT_Intitule FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_COMPTEG g ON g.CG_Num = e.CG_Num AND g.CG_Type = 0 LEFT JOIN dbo.F_COMPTET t ON t.CT_Num = e.CT_Num WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until AND e.JO_Num = :journal AND e.CG_Num = :account
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 100 France — Comptabilité — SQL Server",
"id": "2180270D-321E-50B9-AD49-B0A7E50D5379",
"kind": "sqlServer",
"requiredObjects": [
"dbo.F_COMPTEG",
"dbo.F_COMPTET",
"dbo.F_ECRITUREC",
"dbo.F_JOURNAUX"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "DCA9207F-7321-5DD4-82AF-1FD4266F0348",
"key": "JO_Num",
"type": "text"
},
{
"direction": "ascending",
"id": "4925EA3D-081F-5290-AEB9-75DAE18998F5",
"key": "journal_context",
"type": "text"
}
],
"id": "22F5B8AB-4806-5F9B-B246-EDFB17F0BDBF",
"mappings": [
{
"commonFieldKey": "",
"key": "journal_context",
"label": "Contexte journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "journal_context",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_start",
"label": "Début de période",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_start",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Fin exclusive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JO_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JO_Intitule",
"label": "Journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JO_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Debit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Credit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Balance",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Journaux — période comptable",
"primaryKey": "journal_context",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_start",
"id": "5967F330-6C35-5D5C-AF42-E7B5A2D449C7",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_start",
"id": "749B6DE8-2A7B-554E-8841-AF6BF4AF04DC",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"JO_Num",
"JO_Intitule"
],
"sourceID": "2180270D-321E-50B9-AD49-B0A7E50D5379",
"sqlQuery": "SELECT CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)) AS journal_context, :date_from AS period_start, :date_until AS period_until, e.JO_Num, COALESCE(j.JO_Intitule, e.JO_Num) AS JO_Intitule, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant ELSE 0 END) AS Debit, SUM(CASE WHEN e.EC_Sens = 1 THEN e.EC_Montant ELSE 0 END) AS Credit, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant WHEN e.EC_Sens = 1 THEN -e.EC_Montant ELSE 0 END) AS Balance, COUNT(e.EC_No) AS LineCount FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_JOURNAUX j ON j.JO_Num = e.JO_Num WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until GROUP BY e.JO_Num, j.JO_Intitule",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "12690316-52EB-5D70-9504-833F10FD68E5",
"key": "CG_Num",
"type": "text"
},
{
"direction": "ascending",
"id": "F74DD256-A455-5634-A8BD-4930E6E45A12",
"key": "account_context",
"type": "text"
}
],
"id": "03A3A814-8BFB-5C95-A80A-7E7F957EE5F0",
"mappings": [
{
"commonFieldKey": "",
"key": "account_context",
"label": "Contexte compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "account_context",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "journal_context",
"label": "Contexte journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "journal_context",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_start",
"label": "Début de période",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_start",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "Fin exclusive",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JO_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CG_Num",
"label": "Compte général",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CG_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CG_Intitule",
"label": "Compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CG_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Debit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Credit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Balance",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Comptes du journal",
"primaryKey": "account_context",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_start",
"id": "F12B3D31-7635-5EAE-A645-C8401B9189D8",
"name": "date_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "52E73F24-8640-5260-9AFE-30B6997DC9B7",
"name": "date_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "JO_Num",
"id": "54A14D32-E768-5862-BDEE-203C39A73FD9",
"name": "journal",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"JO_Num",
"CG_Num",
"CG_Intitule"
],
"sourceID": "2180270D-321E-50B9-AD49-B0A7E50D5379",
"sqlQuery": "SELECT CONCAT(CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)), N':', DATALENGTH(e.CG_Num), N':', e.CG_Num) AS account_context, CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)) AS journal_context, :date_from AS period_start, :date_until AS period_until, e.JO_Num, e.CG_Num, COALESCE(g.CG_Intitule, e.CG_Num) AS CG_Intitule, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant ELSE 0 END) AS Debit, SUM(CASE WHEN e.EC_Sens = 1 THEN e.EC_Montant ELSE 0 END) AS Credit, SUM(CASE WHEN e.EC_Sens = 0 THEN e.EC_Montant WHEN e.EC_Sens = 1 THEN -e.EC_Montant ELSE 0 END) AS Balance, COUNT(e.EC_No) AS LineCount FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_COMPTEG g ON g.CG_Num = e.CG_Num AND g.CG_Type = 0 WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until AND e.JO_Num = :journal GROUP BY e.JO_Num, e.CG_Num, g.CG_Intitule",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "812134CB-FF51-5295-821E-A69E0102937E",
"key": "PostingDate",
"type": "date"
},
{
"direction": "ascending",
"id": "40F3F83C-2624-53F4-A5AB-1652AC9C003C",
"key": "EC_No",
"type": "number"
}
],
"id": "A21C943F-1A29-5D82-A976-A8AD89CD7B06",
"mappings": [
{
"commonFieldKey": "",
"key": "account_context",
"label": "Contexte compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "account_context",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingDate",
"label": "Date comptable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Sens",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EC_No",
"label": "Clé écriture",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_No",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JO_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JM_Date",
"label": "Mois comptable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JM_Date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Jour",
"label": "Jour comptable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Jour",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Date",
"label": "Date de saisie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Date",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Piece",
"label": "Pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Piece",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_RefPiece",
"label": "Référence facture",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_RefPiece",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CG_Num",
"label": "Compte général",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CG_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CG_NumCont",
"label": "Compte contrepartie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CG_NumCont",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Num",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Intitule",
"label": "Libellé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Echeance",
"label": "Échéance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Echeance",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EC_Sens",
"label": "Sens (0 débit, 1 crédit)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Sens",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Montant",
"label": "Montant natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Montant",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "N_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "N_Devise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Parite",
"label": "Parité",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Parite",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Lettre",
"label": "Lettrée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Lettre",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Lettrage",
"label": "Lettrage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Lettrage",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EC_Cloture",
"label": "Clôturée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Cloture",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_CType",
"label": "Centralisée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_CType",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EC_Quantite",
"label": "Quantité native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EC_Quantite",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CG_Intitule",
"label": "Compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CG_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Écritures du compte",
"primaryKey": "EC_No",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_start",
"id": "C081F565-2F52-5884-8548-9CF53AF86C5D",
"name": "date_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "82961FCA-9CA0-5503-9D6C-14B37E994E6B",
"name": "date_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "JO_Num",
"id": "F71C21F6-5E36-5D49-A4CA-593BCBDC86B8",
"name": "journal",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CG_Num",
"id": "6919F16D-AA82-57BB-B09C-DFC50731C372",
"name": "account",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Sens",
"JO_Num",
"EC_Piece",
"EC_RefPiece",
"CG_Num",
"CG_NumCont",
"CT_Num",
"EC_Intitule",
"EC_Lettrage",
"CG_Intitule",
"CT_Intitule"
],
"sourceID": "2180270D-321E-50B9-AD49-B0A7E50D5379",
"sqlQuery": "SELECT CONCAT(CONCAT(DATALENGTH(e.JO_Num), N':', e.JO_Num, N':', CONVERT(varchar(10), :date_from, 23), N':', CONVERT(varchar(10), :date_until, 23)), N':', DATALENGTH(e.CG_Num), N':', e.CG_Num) AS account_context, (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) AS PostingDate, CASE e.EC_Sens WHEN 0 THEN N'Débit' WHEN 1 THEN N'Crédit' ELSE N'Indéterminé' END AS Sens, e.[EC_No], e.[JO_Num], e.[JM_Date], e.[EC_Jour], e.[EC_Date], e.[EC_Piece], e.[EC_RefPiece], e.[CG_Num], e.[CG_NumCont], e.[CT_Num], e.[EC_Intitule], e.[EC_Echeance], e.[EC_Sens], e.[EC_Montant], e.[N_Devise], e.[EC_Parite], e.[EC_Lettre], e.[EC_Lettrage], e.[EC_Cloture], e.[EC_CType], e.[EC_Quantite], g.CG_Intitule, t.CT_Intitule FROM dbo.F_ECRITUREC e LEFT JOIN dbo.F_COMPTEG g ON g.CG_Num = e.CG_Num AND g.CG_Type = 0 LEFT JOIN dbo.F_COMPTET t ON t.CT_Num = e.CT_Num WHERE e.JM_Date >= DATEFROMPARTS(YEAR(:date_from), MONTH(:date_from), 1) AND e.JM_Date < DATEADD(month, 1, DATEFROMPARTS(YEAR(:date_until), MONTH(:date_until), 1)) AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) >= :date_from AND (CASE WHEN e.EC_Jour BETWEEN 1 AND DAY(EOMONTH(e.JM_Date)) THEN DATEFROMPARTS(YEAR(e.JM_Date), MONTH(e.JM_Date), e.EC_Jour) ELSE NULL END) < :date_until AND e.JO_Num = :journal AND e.CG_Num = :account",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "5A2C78E6-A5C8-52EB-BC30-64A1E0B3060D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D01705CF-A1C5-5615-954A-763D74914F2F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "03A3A814-8BFB-5C95-A80A-7E7F957EE5F0",
"title": "Comptes et totaux",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "22F5B8AB-4806-5F9B-B246-EDFB17F0BDBF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JO_Intitule",
"label": "Journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "534C7AB9-819A-5075-A642-0203A1126BF9",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "E16102F8-4C1F-543F-A2A9-7B7932D92663",
"includeAllOption": false,
"key": "period_start",
"title": "Période comptable",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "DCA9207F-7321-5DD4-82AF-1FD4266F0348",
"key": "JO_Num",
"type": "text"
},
{
"direction": "ascending",
"id": "4925EA3D-081F-5290-AEB9-75DAE18998F5",
"key": "journal_context",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "JO_Num",
"systemImage": "tablecells",
"title": "Journaux",
"titleKey": "JO_Intitule"
},
{
"actions": [
{
"id": "9E069ADC-0ADE-5074-8F04-FBB64DA98861",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "B465AC05-43CA-5A20-B455-27F738F48E77",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A21C943F-1A29-5D82-A976-A8AD89CD7B06",
"title": "Écritures détaillées",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "03A3A814-8BFB-5C95-A80A-7E7F957EE5F0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_Num",
"label": "Compte général",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_Intitule",
"label": "Compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Débit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Débit − crédit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Nombre d’écritures",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6F6A6029-EE67-5273-B252-9983F9516B6D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "12690316-52EB-5D70-9504-833F10FD68E5",
"key": "CG_Num",
"type": "text"
},
{
"direction": "ascending",
"id": "F74DD256-A455-5634-A8BD-4930E6E45A12",
"key": "account_context",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CG_Num",
"systemImage": "tablecells",
"title": "Comptes du journal",
"titleKey": "CG_Intitule"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Date comptable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_RefPiece",
"label": "Référence facture",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Echeance",
"label": "Échéance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Montant",
"label": "Montant natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Lettrage",
"label": "Lettrage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_Intitule",
"label": "Compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A21C943F-1A29-5D82-A976-A8AD89CD7B06",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Date comptable",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JO_Num",
"label": "Code journal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Date",
"label": "Date de saisie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Piece",
"label": "Pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_RefPiece",
"label": "Référence facture",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_Num",
"label": "Compte général",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_NumCont",
"label": "Compte contrepartie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Num",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Intitule",
"label": "Libellé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Echeance",
"label": "Échéance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Montant",
"label": "Montant natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "N_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Parite",
"label": "Parité",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Lettre",
"label": "Lettrée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Lettrage",
"label": "Lettrage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Cloture",
"label": "Clôturée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_CType",
"label": "Centralisée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EC_Quantite",
"label": "Quantité native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CG_Intitule",
"label": "Compte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7AAA7C3D-661A-5AED-9450-50C17CF5E3EC",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "812134CB-FF51-5295-821E-A69E0102937E",
"key": "PostingDate",
"type": "date"
},
{
"direction": "ascending",
"id": "40F3F83C-2624-53F4-A5AB-1652AC9C003C",
"key": "EC_No",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "EC_Piece",
"systemImage": "tablecells",
"title": "Écritures du compte",
"titleKey": "EC_Intitule"
}
],
"relations": [
{
"childDatasetID": "03A3A814-8BFB-5C95-A80A-7E7F957EE5F0",
"childKey": "journal_context",
"id": "D01705CF-A1C5-5615-954A-763D74914F2F",
"name": "Comptes et totaux",
"parentDatasetID": "22F5B8AB-4806-5F9B-B246-EDFB17F0BDBF",
"parentKey": "journal_context"
},
{
"childDatasetID": "A21C943F-1A29-5D82-A976-A8AD89CD7B06",
"childKey": "account_context",
"id": "B465AC05-43CA-5A20-B455-27F738F48E77",
"name": "Écritures détaillées",
"parentDatasetID": "03A3A814-8BFB-5C95-A80A-7E7F957EE5F0",
"parentKey": "account_context"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 100 France",
"configurationLanguages": [
"fr"
],
"countries": [
"FR"
],
"createdAt": "2026-10-02T00:00:00Z",
"description": "NON OFFICIEL — NON VALIDÉ SUR UNE INSTALLATION ERP RÉELLE. Configuration issue de la documentation publique et testée avec des données synthétiques. À l’import, vérifier la version, les tables, les champs et les résultats avec votre administrateur Sage. Les captures natives Cifru montrent uniquement des données DEMO fictives.\n\nTotaux débit/crédit par journal sur la période comptable choisie, puis comptes et écritures à la demande. La date comptable est reconstruite à partir du mois JM_Date et du jour EC_Jour, pas de EC_Date. Les dates comptables invalides restent sans date et sont exclues des totaux de période, sans décalage automatique au mois suivant. Les montants négatifs conservent leur signe. Ceci ne remplace pas une balance légale.\n\nPourquoi Cifru ? Adaptez les configurations à votre façon de travailler. Choisissez les champs, filtres et détails utiles, et retrouvez sur votre téléphone des informations qui peuvent manquer dans l’application mobile de votre logiciel de gestion. Les possibilités dépendent des données accessibles dans votre source autorisée et de votre offre Cifru.\n\nSage 100 France 12.20, Comptabilité sur Microsoft SQL Server. Une base société autorisée et un compte de lecture seulement sont nécessaires. Aucun accès fourni par le développeur. Aucun mot de passe ni donnée métier dans ce paquet. Les montants sont les valeurs natives Sage : aucun taux inventé, aucune conversion ni somme entre sociétés ou devises différentes. Vérifier la devise de tenue et les paramètres de devise de la société. Les indices de devise Sage ne sont pas des codes ISO. Les tarifs article ne remplacent pas un prix négocié client/fournisseur. Lecture à la demande, sans rafraîchissement périodique ; maximum 2 000 lignes par lecture. Réduire la période ou les filtres si la limite est atteinte. Les identifiants internes servent aux liens et ne sont pas affichés.\n\nStructure issue du manuel public 12.20 ; pas encore testé sur une base Sage sous licence. Les tables, colonnes, cbMarq, droits et performances doivent être vérifiés sur la version cible. Les modules et personnalisations peuvent différer. Les exemples DEMO ne certifient pas la compatibilité réelle. Documentation officielle : https://fr-kb.sage.com/\n\nLecture des champs : « Encours autorisé » est le plafond saisi sur la fiche tiers, pas le solde dû. Les indicateurs 0/1 signifient non/oui. Sur Free, suivi stock : 0 aucun, 1 série, 2 CMUP, 3 FIFO, 4 LIFO, 5 lot ; unité poids : 0 tonne, 1 quintal, 2 kilogramme, 3 gramme, 4 milligramme ; statut document : 0 saisie, 1 confirmé, 2 accepté. Un statut de document ne prouve ni paiement ni livraison. Sur Pro, les modes de taxe sont explicités : la valeur se lit avec son unité et sa nature, sans calculer une taxe supplémentaire.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "23180CC1-FA4A-5AF4-A789-9848B4E62B1E",
"rootButtonCount": 1,
"summary": "Période comptable → journal → compte → écritures.",
"tags": [
"Sage 100",
"SQL Server",
"Comptabilité",
"pro"
],
"title": "Journaux, comptes et écritures — Pro"
}
}