Factures fournisseurs — Pro
Période, tiers et montants ; lignes, articles et stocks à la demande.
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.
Factures fournisseurs de Gestion commerciale, types 16 et 17. Les devis, commandes, bons de livraison, avoirs et archives ne sont pas mélangés aux factures. Une facture comptabilisée ou validée ne signifie pas automatiquement payée. Les montants sont natifs et les remises ne sont pas appliquées une seconde fois. Le lien facture → lignes inclut le type et le numéro de pièce. Les prestations sans référence article restent visibles. Dossier tiers, dossier article et stocks se chargent seulement sur demande.
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, Gestion commerciale 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 Home5 Details5 lists1 sources to map
- Home: Factures achats
- Details: Lignes de facture
- Details: Dossier tiers
- Details: Dossier article
- Details: Stock par dépôt
- Details: Stock par dépôt
- Sub-button: Lignes de facture
- Sub-button: Dossier tiers
- Sub-button: Dossier article
- Sub-button: Stock dans les autres dépôts
Sources are mapped locally and verified before applying.
Custom queriesPRO5 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(CAST(h.DO_Type AS varchar(10)), N':', h.DO_Piece) AS document_key, h.[DO_Type], h.[DO_Domaine], h.[DO_Piece], h.[DO_Date], h.[DO_Ref], h.[DO_Tiers], h.[DO_Devise], h.[DO_Cours], h.[DO_DateLivr], h.[DO_Statut], h.[DO_Contact], h.[DO_FactureFrs], h.[DO_DateLivrRealisee], h.[DO_TotalHT], h.[DO_TotalHTNet], h.[DO_TotalTTC], h.[DO_NetAPayer], h.[DO_MontantRegle], h.[DO_Valide], COALESCE(p.CT_Intitule, h.DO_Tiers) AS CT_Intitule, d.DE_Intitule, CASE h.DO_Type WHEN 17 THEN N'Comptabilisée' ELSE N'Facture' END AS EtatDocument, CASE h.DO_Statut WHEN 0 THEN N'Saisie' WHEN 1 THEN N'Confirmé' WHEN 2 THEN N'Accepté' ELSE CASE WHEN h.DO_Statut IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(h.DO_Statut AS varchar(20)), N')') END END AS StatutDocument FROM dbo.F_DOCENTETE h LEFT JOIN dbo.F_COMPTET p ON p.CT_Num = h.DO_Tiers LEFT JOIN dbo.F_DEPOT d ON d.DE_No = h.DE_No WHERE h.DO_Domaine = 1 AND h.DO_Type IN (16, 17) AND h.DO_Date >= :date_from AND h.DO_Date < :date_untilstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CAST(l.DO_Type AS varchar(10)), N':', l.DO_Piece) AS document_key, l.[DL_No], l.[DL_Ligne], l.[DO_Type], l.[DO_Piece], l.[AR_Ref], l.[DL_Design], l.[DL_Qte], l.[DL_QteBC], l.[DL_QteBL], l.[DL_PrixUnitaire], l.[DL_PUDevise], l.[DL_PUTTC], l.[DL_PrixRU], l.[DL_CMUP], l.[DL_MontantHT], l.[DL_MontantTTC], l.[DL_Taxe1], l.[DL_TypeTaux1], l.[DL_TypeTaxe1], l.[DL_Valorise], l.[DL_NonLivre], l.[DE_No], l.[DL_MvtStock], l.[DL_PieceBC], l.[DL_PieceBL], l.[DO_DateLivr], l.[DL_TremPied], l.[DL_TremExep], d.DE_Intitule, CASE l.DL_TypeTaux1 WHEN 0 THEN N'Taux %' WHEN 1 THEN N'Montant' WHEN 2 THEN N'Quantité' ELSE CASE WHEN l.DL_TypeTaux1 IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_TypeTaux1 AS varchar(20)), N')') END END AS TypeTaux, CASE l.DL_TypeTaxe1 WHEN 0 THEN N'TVA/débit' WHEN 1 THEN N'TVA/Encaissement' WHEN 2 THEN N'TP/HT' WHEN 3 THEN N'TP/TTC' WHEN 4 THEN N'TP/Poids' WHEN 5 THEN N'TVA/CEE' WHEN 6 THEN N'Surtaxe' ELSE CASE WHEN l.DL_TypeTaxe1 IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_TypeTaxe1 AS varchar(20)), N')') END END AS NatureTaxe, CASE l.DL_MvtStock WHEN 0 THEN N'Aucun' WHEN 1 THEN N'Entrée Quantité' WHEN 2 THEN N'Entrée en valeur' WHEN 3 THEN N'Sortie Quantité' WHEN 4 THEN N'Sortie en valeur' ELSE CASE WHEN l.DL_MvtStock IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_MvtStock AS varchar(20)), N')') END END AS MouvementStock FROM dbo.F_DOCLIGNE l LEFT JOIN dbo.F_DEPOT d ON d.DE_No = l.DE_No WHERE l.DO_Type = :document_type AND l.DO_Piece = :document_numberstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT p.[CT_Num], p.[CT_Intitule], p.[CT_Contact], p.[CT_Ville], p.[CT_Pays], p.[CT_Telephone], p.[CT_EMail], p.[CT_Encours], p.[CT_Assurance], p.[CT_Commentaire], p.[CT_NumPayeur], p.[CT_Sommeil] FROM dbo.F_COMPTET p WHERE p.CT_Num = :tiers
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT a.[AR_Ref], a.[AR_Design], a.[AR_CodeBarre], a.[AR_PrixAch], a.[AR_PrixVen], a.[AR_PrixTTC], a.[AR_Sommeil], a.[AR_SuiviStock], a.[AR_UnitePoids], a.[AR_PoidsNet], a.[AR_PoidsBrut], f.FA_Intitule, CASE a.AR_PrixTTC WHEN 0 THEN N'HT' WHEN 1 THEN N'TTC' ELSE N'Non renseigné' END AS BaseTarif, CASE a.AR_Sommeil WHEN 0 THEN N'Actif' WHEN 1 THEN N'En sommeil' ELSE N'Non renseigné' END AS EtatArticle, CASE a.AR_UnitePoids WHEN 0 THEN N'Tonne' WHEN 1 THEN N'Quintal' WHEN 2 THEN N'Kilogramme' WHEN 3 THEN N'Gramme' WHEN 4 THEN N'Milligramme' ELSE CASE WHEN a.AR_UnitePoids IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(a.AR_UnitePoids AS varchar(20)), N')') END END AS UnitePoids, CASE a.AR_SuiviStock WHEN 0 THEN N'Aucun' WHEN 1 THEN N'Sérialisé' WHEN 2 THEN N'CMUP' WHEN 3 THEN N'FIFO' WHEN 4 THEN N'LIFO' WHEN 5 THEN N'Par lot' ELSE CASE WHEN a.AR_SuiviStock IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(a.AR_SuiviStock AS varchar(20)), N')') END END AS SuiviStock FROM dbo.F_ARTICLE a LEFT JOIN dbo.F_FAMILLE f ON f.FA_CodeFamille = a.FA_CodeFamille AND f.FA_Type = 0 WHERE a.AR_Ref = :articlestatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT CONCAT(DATALENGTH(s.AR_Ref), N':', s.AR_Ref, CAST(s.DE_No AS varchar(20))) AS row_id, s.[AR_Ref], s.[DE_No], s.[AS_QteSto], s.[AS_QteRes], s.[AS_QteCom], s.[AS_QteMini], s.[AS_QteMaxi], s.[AS_MontSto], s.[AS_QtePrepa], s.[AS_QteAControler], s.[AS_QteResCM], s.[AS_QteComCM], COALESCE(a.AR_Design, s.AR_Ref) AS AR_Design, d.DE_Intitule, d.DE_Ville FROM dbo.F_ARTSTOCK s LEFT JOIN dbo.F_ARTICLE a ON a.AR_Ref = s.AR_Ref LEFT JOIN dbo.F_DEPOT d ON d.DE_No = s.DE_No WHERE s.AR_Ref = :article
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 100 France — Gestion commerciale — SQL Server",
"id": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"kind": "sqlServer",
"requiredObjects": [
"dbo.F_ARTICLE",
"dbo.F_ARTSTOCK",
"dbo.F_COMPTET",
"dbo.F_DEPOT",
"dbo.F_DOCENTETE",
"dbo.F_DOCLIGNE",
"dbo.F_FAMILLE"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "8BCE86C9-6B0A-54EA-BA64-1C4DC74190DC",
"key": "document_key",
"type": "text"
}
],
"id": "BEA0FDA2-642D-56AE-B0F4-FD5F5D7806F5",
"mappings": [
{
"commonFieldKey": "",
"key": "document_key",
"label": "Clé du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Type",
"label": "Type interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Type",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Domaine",
"label": "Domaine interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Domaine",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Piece",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Tiers",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Devise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Cours",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Statut",
"label": "Statut natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Statut",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Contact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_FactureFrs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivrRealisee",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHTNet",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalTTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_NetAPayer",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_MontantRegle",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Valide",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EtatDocument",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EtatDocument",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StatutDocument",
"label": "Statut document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StatutDocument",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Factures fournisseurs",
"primaryKey": "document_key",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DO_Date",
"id": "51F15C46-C71C-5013-A60E-E9E09072387E",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DO_Date",
"id": "9E9AEA5C-FB9B-5FF9-9442-6BC17EBE908C",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DO_Piece",
"DO_Ref",
"DO_Tiers",
"DO_Contact",
"DO_FactureFrs",
"CT_Intitule",
"DE_Intitule",
"EtatDocument",
"StatutDocument"
],
"sourceID": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"sqlQuery": "SELECT CONCAT(CAST(h.DO_Type AS varchar(10)), N':', h.DO_Piece) AS document_key, h.[DO_Type], h.[DO_Domaine], h.[DO_Piece], h.[DO_Date], h.[DO_Ref], h.[DO_Tiers], h.[DO_Devise], h.[DO_Cours], h.[DO_DateLivr], h.[DO_Statut], h.[DO_Contact], h.[DO_FactureFrs], h.[DO_DateLivrRealisee], h.[DO_TotalHT], h.[DO_TotalHTNet], h.[DO_TotalTTC], h.[DO_NetAPayer], h.[DO_MontantRegle], h.[DO_Valide], COALESCE(p.CT_Intitule, h.DO_Tiers) AS CT_Intitule, d.DE_Intitule, CASE h.DO_Type WHEN 17 THEN N'Comptabilisée' ELSE N'Facture' END AS EtatDocument, CASE h.DO_Statut WHEN 0 THEN N'Saisie' WHEN 1 THEN N'Confirmé' WHEN 2 THEN N'Accepté' ELSE CASE WHEN h.DO_Statut IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(h.DO_Statut AS varchar(20)), N')') END END AS StatutDocument FROM dbo.F_DOCENTETE h LEFT JOIN dbo.F_COMPTET p ON p.CT_Num = h.DO_Tiers LEFT JOIN dbo.F_DEPOT d ON d.DE_No = h.DE_No WHERE h.DO_Domaine = 1 AND h.DO_Type IN (16, 17) AND h.DO_Date >= :date_from AND h.DO_Date < :date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "BD1E9424-D457-51FD-BD01-ECDAB6A823F9",
"key": "DL_Ligne",
"type": "number"
},
{
"direction": "ascending",
"id": "CD5EC6D4-7F90-5505-B06C-988B7644B543",
"key": "DL_No",
"type": "number"
}
],
"id": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"mappings": [
{
"commonFieldKey": "",
"key": "document_key",
"label": "Clé du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_No",
"label": "Clé ligne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_No",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_Ligne",
"label": "Ordre ligne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_Ligne",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Type",
"label": "Type interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Type",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Piece",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_Design",
"label": "Article / prestation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_Design",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_Qte",
"label": "Quantité",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_Qte",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_QteBC",
"label": "Quantité commandée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_QteBC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_QteBL",
"label": "Quantité livrée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_QteBL",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_PrixUnitaire",
"label": "Prix unitaire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PrixUnitaire",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_PUDevise",
"label": "Prix en devise",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PUDevise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_PUTTC",
"label": "Prix unitaire TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PUTTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_PrixRU",
"label": "Prix de revient",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PrixRU",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_CMUP",
"label": "Coût moyen pondéré",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_CMUP",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_MontantHT",
"label": "Montant HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_MontantHT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_MontantTTC",
"label": "Montant TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_MontantTTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_Taxe1",
"label": "Valeur taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_Taxe1",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_TypeTaux1",
"label": "Type taux natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_TypeTaux1",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_TypeTaxe1",
"label": "Type taxe natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_TypeTaxe1",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_Valorise",
"label": "Valorisée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_Valorise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_NonLivre",
"label": "Non livrée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_NonLivre",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DE_No",
"label": "Clé dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_No",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_MvtStock",
"label": "Mouvement stock natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_MvtStock",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_PieceBC",
"label": "Commande associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PieceBC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DL_PieceBL",
"label": "Livraison associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_PieceBL",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_TremPied",
"label": "Remise pied (0/1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_TremPied",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DL_TremExep",
"label": "Remise exception. (0/1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DL_TremExep",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TypeTaux",
"label": "Unité taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TypeTaux",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NatureTaxe",
"label": "Nature taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NatureTaxe",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MouvementStock",
"label": "Mouvement stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MouvementStock",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Lignes de facture",
"primaryKey": "DL_No",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DO_Type",
"id": "37070FD2-D6C8-55B4-88BA-F5DEAD804B94",
"name": "document_type",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DO_Piece",
"id": "7F8806BA-40E0-583F-B24C-597F8E4D5739",
"name": "document_number",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DO_Piece",
"AR_Ref",
"DL_Design",
"DL_PieceBC",
"DL_PieceBL",
"DE_Intitule",
"TypeTaux",
"NatureTaxe",
"MouvementStock"
],
"sourceID": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"sqlQuery": "SELECT CONCAT(CAST(l.DO_Type AS varchar(10)), N':', l.DO_Piece) AS document_key, l.[DL_No], l.[DL_Ligne], l.[DO_Type], l.[DO_Piece], l.[AR_Ref], l.[DL_Design], l.[DL_Qte], l.[DL_QteBC], l.[DL_QteBL], l.[DL_PrixUnitaire], l.[DL_PUDevise], l.[DL_PUTTC], l.[DL_PrixRU], l.[DL_CMUP], l.[DL_MontantHT], l.[DL_MontantTTC], l.[DL_Taxe1], l.[DL_TypeTaux1], l.[DL_TypeTaxe1], l.[DL_Valorise], l.[DL_NonLivre], l.[DE_No], l.[DL_MvtStock], l.[DL_PieceBC], l.[DL_PieceBL], l.[DO_DateLivr], l.[DL_TremPied], l.[DL_TremExep], d.DE_Intitule, CASE l.DL_TypeTaux1 WHEN 0 THEN N'Taux %' WHEN 1 THEN N'Montant' WHEN 2 THEN N'Quantité' ELSE CASE WHEN l.DL_TypeTaux1 IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_TypeTaux1 AS varchar(20)), N')') END END AS TypeTaux, CASE l.DL_TypeTaxe1 WHEN 0 THEN N'TVA/débit' WHEN 1 THEN N'TVA/Encaissement' WHEN 2 THEN N'TP/HT' WHEN 3 THEN N'TP/TTC' WHEN 4 THEN N'TP/Poids' WHEN 5 THEN N'TVA/CEE' WHEN 6 THEN N'Surtaxe' ELSE CASE WHEN l.DL_TypeTaxe1 IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_TypeTaxe1 AS varchar(20)), N')') END END AS NatureTaxe, CASE l.DL_MvtStock WHEN 0 THEN N'Aucun' WHEN 1 THEN N'Entrée Quantité' WHEN 2 THEN N'Entrée en valeur' WHEN 3 THEN N'Sortie Quantité' WHEN 4 THEN N'Sortie en valeur' ELSE CASE WHEN l.DL_MvtStock IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(l.DL_MvtStock AS varchar(20)), N')') END END AS MouvementStock FROM dbo.F_DOCLIGNE l LEFT JOIN dbo.F_DEPOT d ON d.DE_No = l.DE_No WHERE l.DO_Type = :document_type AND l.DO_Piece = :document_number",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B4CA48A1-3E59-5E19-A876-7F4759D6C943",
"key": "CT_Num",
"type": "text"
}
],
"id": "B5CA2EAF-A4AD-5D38-8CD5-41E7D0F9DACB",
"mappings": [
{
"commonFieldKey": "",
"key": "CT_Num",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Num",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Contact",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_Ville",
"label": "Ville",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Ville",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_Pays",
"label": "Pays",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Pays",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Telephone",
"label": "Téléphone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Telephone",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_EMail",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_EMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Encours",
"label": "Encours autorisé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Encours",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_Assurance",
"label": "Plafond assuré",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Assurance",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CT_Commentaire",
"label": "Commentaire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Commentaire",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_NumPayeur",
"label": "Code tiers payeur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_NumPayeur",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CT_Sommeil",
"label": "En sommeil (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CT_Sommeil",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Dossier tiers",
"primaryKey": "CT_Num",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DO_Tiers",
"id": "D5715F1C-4B34-5839-904D-7C614054E78E",
"name": "tiers",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CT_Num",
"CT_Intitule",
"CT_Contact",
"CT_Ville",
"CT_Pays",
"CT_Telephone",
"CT_EMail",
"CT_Commentaire",
"CT_NumPayeur"
],
"sourceID": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"sqlQuery": "SELECT p.[CT_Num], p.[CT_Intitule], p.[CT_Contact], p.[CT_Ville], p.[CT_Pays], p.[CT_Telephone], p.[CT_EMail], p.[CT_Encours], p.[CT_Assurance], p.[CT_Commentaire], p.[CT_NumPayeur], p.[CT_Sommeil] FROM dbo.F_COMPTET p WHERE p.CT_Num = :tiers",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "FD5E5E56-8A95-5844-AFA8-5A918232CF0C",
"key": "AR_Ref",
"type": "text"
}
],
"id": "F4788E17-7EC5-50BC-80AC-573A5E9B43A2",
"mappings": [
{
"commonFieldKey": "",
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_Design",
"label": "Article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Design",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_CodeBarre",
"label": "Code-barres",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_CodeBarre",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AR_PrixAch",
"label": "Prix d’achat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_PrixAch",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AR_PrixVen",
"label": "Prix de vente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_PrixVen",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AR_PrixTTC",
"label": "Tarif : 0 HT / 1 TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_PrixTTC",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_Sommeil",
"label": "Sommeil : 0 non / 1 oui",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Sommeil",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_SuiviStock",
"label": "Suivi stock (code)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_SuiviStock",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_UnitePoids",
"label": "Unité poids (code)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_UnitePoids",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_PoidsNet",
"label": "Poids net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_PoidsNet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_PoidsBrut",
"label": "Poids brut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_PoidsBrut",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FA_Intitule",
"label": "Famille",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FA_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BaseTarif",
"label": "Base tarif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BaseTarif",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EtatArticle",
"label": "État",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EtatArticle",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitePoids",
"label": "Unité de poids",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitePoids",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SuiviStock",
"label": "Suivi du stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SuiviStock",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Dossier article",
"primaryKey": "AR_Ref",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AR_Ref",
"id": "B2E7958B-F86F-5BAF-8B46-94BDE49D27A0",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AR_Ref",
"AR_Design",
"AR_CodeBarre",
"FA_Intitule",
"BaseTarif",
"EtatArticle",
"UnitePoids",
"SuiviStock"
],
"sourceID": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"sqlQuery": "SELECT a.[AR_Ref], a.[AR_Design], a.[AR_CodeBarre], a.[AR_PrixAch], a.[AR_PrixVen], a.[AR_PrixTTC], a.[AR_Sommeil], a.[AR_SuiviStock], a.[AR_UnitePoids], a.[AR_PoidsNet], a.[AR_PoidsBrut], f.FA_Intitule, CASE a.AR_PrixTTC WHEN 0 THEN N'HT' WHEN 1 THEN N'TTC' ELSE N'Non renseigné' END AS BaseTarif, CASE a.AR_Sommeil WHEN 0 THEN N'Actif' WHEN 1 THEN N'En sommeil' ELSE N'Non renseigné' END AS EtatArticle, CASE a.AR_UnitePoids WHEN 0 THEN N'Tonne' WHEN 1 THEN N'Quintal' WHEN 2 THEN N'Kilogramme' WHEN 3 THEN N'Gramme' WHEN 4 THEN N'Milligramme' ELSE CASE WHEN a.AR_UnitePoids IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(a.AR_UnitePoids AS varchar(20)), N')') END END AS UnitePoids, CASE a.AR_SuiviStock WHEN 0 THEN N'Aucun' WHEN 1 THEN N'Sérialisé' WHEN 2 THEN N'CMUP' WHEN 3 THEN N'FIFO' WHEN 4 THEN N'LIFO' WHEN 5 THEN N'Par lot' ELSE CASE WHEN a.AR_SuiviStock IS NULL THEN N'Non renseigné' ELSE CONCAT(N'Non reconnu (', CAST(a.AR_SuiviStock AS varchar(20)), N')') END END AS SuiviStock FROM dbo.F_ARTICLE a LEFT JOIN dbo.F_FAMILLE f ON f.FA_CodeFamille = a.FA_CodeFamille AND f.FA_Type = 0 WHERE a.AR_Ref = :article",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 France",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "84D1CC91-4CDB-59C1-ACE6-7022D048D355",
"key": "DE_Intitule",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Clé interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DE_No",
"label": "Clé dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_No",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AS_QteSto",
"label": "En stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteSto",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AS_QteRes",
"label": "Réservé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteRes",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QteCom",
"label": "Commandé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteCom",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QteMini",
"label": "Stock minimum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteMini",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QteMaxi",
"label": "Stock maximum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteMaxi",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_MontSto",
"label": "Valeur stock native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_MontSto",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QtePrepa",
"label": "En préparation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QtePrepa",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QteAControler",
"label": "À contrôler",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteAControler",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AS_QteResCM",
"label": "Réservé contremarque",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteResCM",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AS_QteComCM",
"label": "Commandé contremarque",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AS_QteComCM",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AR_Design",
"label": "Article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AR_Design",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_Intitule",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DE_Ville",
"label": "Ville du dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DE_Ville",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Stock dans les autres dépôts",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AR_Ref",
"id": "C9B0DE0A-5DE5-51D8-B9CC-F9C16CD2B6AF",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AR_Ref",
"AR_Design",
"DE_Intitule",
"DE_Ville"
],
"sourceID": "47027BA0-5D2A-5D0C-B157-D589887EF9BB",
"sqlQuery": "SELECT CONCAT(DATALENGTH(s.AR_Ref), N':', s.AR_Ref, CAST(s.DE_No AS varchar(20))) AS row_id, s.[AR_Ref], s.[DE_No], s.[AS_QteSto], s.[AS_QteRes], s.[AS_QteCom], s.[AS_QteMini], s.[AS_QteMaxi], s.[AS_MontSto], s.[AS_QtePrepa], s.[AS_QteAControler], s.[AS_QteResCM], s.[AS_QteComCM], COALESCE(a.AR_Design, s.AR_Ref) AS AR_Design, d.DE_Intitule, d.DE_Ville FROM dbo.F_ARTSTOCK s LEFT JOIN dbo.F_ARTICLE a ON a.AR_Ref = s.AR_Ref LEFT JOIN dbo.F_DEPOT d ON d.DE_No = s.DE_No WHERE s.AR_Ref = :article",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "2C2FA297-CFB0-51D5-BEA8-12AC169F4DEA",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D77280A7-55A6-5288-B0C8-E322FB89A60D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"title": "Lignes de facture",
"urlKey": ""
},
{
"id": "23E1D379-B4F9-5FF7-8309-8EEF350575AD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DD760A56-332F-5B6A-96F7-C2DB544F55FF",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B5CA2EAF-A4AD-5D38-8CD5-41E7D0F9DACB",
"title": "Dossier tiers",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EtatDocument",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "BEA0FDA2-642D-56AE-B0F4-FD5F5D7806F5",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EtatDocument",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StatutDocument",
"label": "Statut document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B98DEDFA-1CDD-5484-A6D2-3B6BE01E436D",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "568EDC05-448E-581B-A944-EB3239C9ECBA",
"includeAllOption": false,
"key": "DO_Date",
"title": "Période",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "8BCE86C9-6B0A-54EA-BA64-1C4DC74190DC",
"key": "document_key",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "DO_Piece",
"systemImage": "doc.text",
"title": "Factures achats",
"titleKey": "CT_Intitule"
},
{
"actions": [
{
"id": "C40971C0-22FD-5A1E-8717-FEA4E52F62E8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "CAD6F0BA-D57A-5488-8DBB-3AB1F6078DA9",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F4788E17-7EC5-50BC-80AC-573A5E9B43A2",
"title": "Dossier article",
"urlKey": ""
},
{
"id": "99319AA0-FB80-5A1D-8DB7-5E4933FEA77C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "8C3811DA-E36F-569C-82D1-013D8913F02C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"title": "Stock par dépôt",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_Qte",
"label": "Quantité",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_QteBC",
"label": "Quantité commandée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_QteBL",
"label": "Quantité livrée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PrixUnitaire",
"label": "Prix unitaire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PUTTC",
"label": "Prix unitaire TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_MontantHT",
"label": "Montant HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_MontantTTC",
"label": "Montant TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PieceBC",
"label": "Commande associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PieceBL",
"label": "Livraison associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_Design",
"label": "Article / prestation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_Qte",
"label": "Quantité",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_QteBC",
"label": "Quantité commandée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_QteBL",
"label": "Quantité livrée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PrixUnitaire",
"label": "Prix unitaire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PUDevise",
"label": "Prix en devise",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PUTTC",
"label": "Prix unitaire TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PrixRU",
"label": "Prix de revient",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_CMUP",
"label": "Coût moyen pondéré",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_MontantHT",
"label": "Montant HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_MontantTTC",
"label": "Montant TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_Taxe1",
"label": "Valeur taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_Valorise",
"label": "Valorisée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_NonLivre",
"label": "Non livrée (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PieceBC",
"label": "Commande associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_PieceBL",
"label": "Livraison associée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_TremPied",
"label": "Remise pied (0/1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DL_TremExep",
"label": "Remise exception. (0/1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TypeTaux",
"label": "Unité taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NatureTaxe",
"label": "Nature taxe 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MouvementStock",
"label": "Mouvement stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E0BF3908-5320-54A5-BA62-596F80A4482B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "BD1E9424-D457-51FD-BD01-ECDAB6A823F9",
"key": "DL_Ligne",
"type": "number"
},
{
"direction": "ascending",
"id": "CD5EC6D4-7F90-5505-B06C-988B7644B543",
"key": "DL_No",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "AR_Ref",
"systemImage": "tablecells",
"title": "Lignes de facture",
"titleKey": "DL_Design"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Ville",
"label": "Ville",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Telephone",
"label": "Téléphone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Encours",
"label": "Encours autorisé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Assurance",
"label": "Plafond assuré",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B5CA2EAF-A4AD-5D38-8CD5-41E7D0F9DACB",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Num",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Intitule",
"label": "Tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Ville",
"label": "Ville",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Pays",
"label": "Pays",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Telephone",
"label": "Téléphone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_EMail",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Encours",
"label": "Encours autorisé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Assurance",
"label": "Plafond assuré",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Commentaire",
"label": "Commentaire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_NumPayeur",
"label": "Code tiers payeur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CT_Sommeil",
"label": "En sommeil (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "20EC5FC1-45EB-5078-A8BD-23C3F61B4B48",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "B4CA48A1-3E59-5E19-A876-7F4759D6C943",
"key": "CT_Num",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CT_Num",
"systemImage": "tablecells",
"title": "Dossier tiers",
"titleKey": "CT_Intitule"
},
{
"actions": [
{
"id": "61967377-5CA4-557F-9D85-74623181F338",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "983B9F0E-6361-5ABB-A610-E6AA8DF4067F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"title": "Stock par dépôt",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_CodeBarre",
"label": "Code-barres",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PrixAch",
"label": "Prix d’achat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PrixVen",
"label": "Prix de vente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FA_Intitule",
"label": "Famille",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseTarif",
"label": "Base tarif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EtatArticle",
"label": "État",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "F4788E17-7EC5-50BC-80AC-573A5E9B43A2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_Design",
"label": "Article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_CodeBarre",
"label": "Code-barres",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PrixAch",
"label": "Prix d’achat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PrixVen",
"label": "Prix de vente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PoidsNet",
"label": "Poids net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_PoidsBrut",
"label": "Poids brut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FA_Intitule",
"label": "Famille",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseTarif",
"label": "Base tarif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EtatArticle",
"label": "État",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitePoids",
"label": "Unité de poids",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SuiviStock",
"label": "Suivi du stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0BF7C0B1-39D4-5620-A1FC-0BB1C063F484",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "FD5E5E56-8A95-5844-AFA8-5A918232CF0C",
"key": "AR_Ref",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AR_Ref",
"systemImage": "tablecells",
"title": "Dossier article",
"titleKey": "AR_Design"
},
{
"actions": [],
"badgeKey": "AS_QteSto",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteRes",
"label": "Réservé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteCom",
"label": "Commandé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteMini",
"label": "Stock minimum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteMaxi",
"label": "Stock maximum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_MontSto",
"label": "Valeur stock native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QtePrepa",
"label": "En préparation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteAControler",
"label": "À contrôler",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Ville",
"label": "Ville du dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_Ref",
"label": "Référence article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "AS_QteSto",
"label": "En stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteRes",
"label": "Réservé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteCom",
"label": "Commandé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteMini",
"label": "Stock minimum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteMaxi",
"label": "Stock maximum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_MontSto",
"label": "Valeur stock native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QtePrepa",
"label": "En préparation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteAControler",
"label": "À contrôler",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteResCM",
"label": "Réservé contremarque",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AS_QteComCM",
"label": "Commandé contremarque",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AR_Design",
"label": "Article",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Intitule",
"label": "Dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DE_Ville",
"label": "Ville du dépôt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B9FF9F2C-C51D-5BA8-A3F2-632B92E8CEFB",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "84D1CC91-4CDB-59C1-ACE6-7022D048D355",
"key": "DE_Intitule",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AR_Ref",
"systemImage": "tablecells",
"title": "Stock dans les autres dépôts",
"titleKey": "DE_Intitule"
}
],
"relations": [
{
"childDatasetID": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"childKey": "document_key",
"id": "D77280A7-55A6-5288-B0C8-E322FB89A60D",
"name": "Lignes de facture",
"parentDatasetID": "BEA0FDA2-642D-56AE-B0F4-FD5F5D7806F5",
"parentKey": "document_key"
},
{
"childDatasetID": "B5CA2EAF-A4AD-5D38-8CD5-41E7D0F9DACB",
"childKey": "CT_Num",
"id": "DD760A56-332F-5B6A-96F7-C2DB544F55FF",
"name": "Dossier tiers",
"parentDatasetID": "BEA0FDA2-642D-56AE-B0F4-FD5F5D7806F5",
"parentKey": "DO_Tiers"
},
{
"childDatasetID": "F4788E17-7EC5-50BC-80AC-573A5E9B43A2",
"childKey": "AR_Ref",
"id": "CAD6F0BA-D57A-5488-8DBB-3AB1F6078DA9",
"name": "Dossier article",
"parentDatasetID": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"parentKey": "AR_Ref"
},
{
"childDatasetID": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"childKey": "AR_Ref",
"id": "8C3811DA-E36F-569C-82D1-013D8913F02C",
"name": "Stock par dépôt",
"parentDatasetID": "B857AD92-8E12-5F1E-A389-4107E30F0587",
"parentKey": "AR_Ref"
},
{
"childDatasetID": "2C1F8736-93E5-5C65-816C-59D9301EA136",
"childKey": "AR_Ref",
"id": "983B9F0E-6361-5ABB-A610-E6AA8DF4067F",
"name": "Stock par dépôt",
"parentDatasetID": "F4788E17-7EC5-50BC-80AC-573A5E9B43A2",
"parentKey": "AR_Ref"
}
],
"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\nFactures fournisseurs de Gestion commerciale, types 16 et 17. Les devis, commandes, bons de livraison, avoirs et archives ne sont pas mélangés aux factures. Une facture comptabilisée ou validée ne signifie pas automatiquement payée. Les montants sont natifs et les remises ne sont pas appliquées une seconde fois. Le lien facture → lignes inclut le type et le numéro de pièce. Les prestations sans référence article restent visibles. Dossier tiers, dossier article et stocks se chargent seulement sur demande.\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, Gestion commerciale 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": "4CE31CA1-B0EF-56B2-B1DA-1DD7FD4913E4",
"rootButtonCount": 1,
"summary": "Période, tiers et montants ; lignes, articles et stocks à la demande.",
"tags": [
"Sage 100",
"SQL Server",
"Gestion commerciale",
"pro"
],
"title": "Factures fournisseurs — Pro"
}
}