{"system":"Cegid Retail Y2","vendor":"Cegid","category":"POS / Retail","sector":"retail","company_target":"Maison Lumen SAS","openapi_url":"/openapi.json","endpoints":[{"path":"/aura/analytics/transactions","method":"GET","business_object":"POSTransaction","description":"Tickets POS sur les 30 derniers jours (8 magasins)","record_count_hint":200,"refresh_frequency":"HOURLY","fields":[{"name":"ticket_id","type":"string","example":"TKT-000042"},{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"date","type":"date","example":"2026-06-12"},{"name":"amount","type":"number","example":189.0},{"name":"qty","type":"number","example":2},{"name":"payment_method","type":"enum","example":"CB"},{"name":"discount_pct","type":"number","example":10},{"name":"staff_id","type":"string","example":"EMP-0012"}]},{"path":"/aura/analytics/articles","method":"GET","business_object":"Article","description":"Catalogue articles 30 SKUs (prix, catégorie, TVA)","record_count_hint":30,"refresh_frequency":"DAILY","fields":[{"name":"sku_id","type":"string","example":"ML-PE25-W-001"},{"name":"label","type":"string","example":"Footwear N°1"},{"name":"category","type":"enum","example":"FOOTWEAR"},{"name":"brand","type":"string","example":"Maison Lumen"},{"name":"selling_price","type":"number","example":189.0},{"name":"tax_rate","type":"number","example":20.0}]},{"path":"/aura/analytics/cegid-customers","method":"GET","business_object":"LoyaltyCustomer","description":"50 clients fidélité avec points et segment","record_count_hint":50,"refresh_frequency":"DAILY","fields":[{"name":"customer_id","type":"string","example":"CST-00012"},{"name":"fidelity_points","type":"number","example":8400},{"name":"segment","type":"enum","example":"VIP"},{"name":"last_purchase_date","type":"date","example":"2026-05-22"}]},{"path":"/aura/analytics/store-kpis","method":"GET","business_object":"StoreKPI","description":"KPIs quotidiens magasin sur 30 jours (CA, trafic, conversion, panier)","record_count_hint":240,"refresh_frequency":"DAILY","fields":[{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"period","type":"date","example":"2026-06-12"},{"name":"daily_revenue","type":"number","example":8420.0},{"name":"footfall","type":"number","example":642},{"name":"conversion_rate","type":"number","example":0.18},{"name":"avg_basket","type":"number","example":74.2}]},{"path":"/aura/analytics/staff-performance","method":"GET","business_object":"EmployeePerformance","description":"Objectif vs réel par vendeur sur le mois","record_count_hint":30,"refresh_frequency":"MONTHLY","fields":[{"name":"staff_id","type":"string","example":"EMP-0012"},{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"role","type":"enum","example":"SELLER"},{"name":"sales_target","type":"number","example":42000.0},{"name":"sales_actual","type":"number","example":39800.0},{"name":"achievement_pct","type":"number","example":94.7}]},{"path":"/aura/analytics/budget-vs-actual","method":"GET","business_object":"BudgetLine","description":"Budget vs réalisé par BU x trimestre (6 BUs x 4 quarters)","record_count_hint":24,"refresh_frequency":"QUARTERLY","fields":[{"name":"bu_code","type":"enum","example":"RETAIL_FR"},{"name":"period","type":"string","example":"2026-Q2"},{"name":"budget_eur","type":"number","example":1240000.0},{"name":"actual_eur","type":"number","example":1180000.0},{"name":"variance_pct","type":"number","example":-4.8},{"name":"status","type":"enum","example":"ON_TRACK"}]},{"path":"/aura/analytics/markdown-provisions","method":"GET","business_object":"BudgetLine","description":"Provisions markdown par catégorie x trimestre","record_count_hint":24,"refresh_frequency":"QUARTERLY","fields":[{"name":"category","type":"enum","example":"FOOTWEAR"},{"name":"period","type":"string","example":"2026-Q2"},{"name":"provision_eur","type":"number","example":48000.0},{"name":"expected_markdown_pct","type":"number","example":22.0},{"name":"aged_stock_value","type":"number","example":184000.0}]},{"path":"/aura/analytics/fixed-costs","method":"GET","business_object":"BudgetLine","description":"Coûts fixes mensuels par type (loyer, paie, IT, assurance, fluides)","record_count_hint":60,"refresh_frequency":"MONTHLY","fields":[{"name":"period","type":"string","example":"2026-05"},{"name":"cost_type","type":"enum","example":"RENT"},{"name":"amount_eur","type":"number","example":84000.0},{"name":"vs_budget_pct","type":"number","example":2.4}]},{"path":"/aura/analytics/wholesale-receivables","method":"GET","business_object":"WholesaleReceivable","description":"Créances wholesale par client (15 enseignes nommées)","record_count_hint":15,"refresh_frequency":"WEEKLY","fields":[{"name":"client_name","type":"string","example":"Galeries Lafayette"},{"name":"invoice_count","type":"number","example":8},{"name":"total_due_eur","type":"number","example":184000.0},{"name":"days_outstanding","type":"number","example":42},{"name":"risk_level","type":"enum","example":"LOW"}]},{"path":"/aura/analytics/foot-traffic","method":"GET","business_object":"StoreKPI","description":"Trafic magasin + conversion sur 30 jours (8 magasins)","record_count_hint":240,"refresh_frequency":"DAILY","fields":[{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"store_name","type":"string","example":"Paris Haussmann"},{"name":"date","type":"date","example":"2026-06-12"},{"name":"entries_count","type":"number","example":842},{"name":"conversion_to_purchase_pct","type":"number","example":18.4}]},{"path":"/aura/analytics/upt","method":"GET","business_object":"StoreKPI","description":"Units Per Transaction par magasin x 4 semaines","record_count_hint":32,"refresh_frequency":"WEEKLY","fields":[{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"week","type":"string","example":"2026-W22"},{"name":"units_per_transaction","type":"number","example":2.4},{"name":"transactions_count","type":"number","example":840},{"name":"top_combination_skus","type":"array","example":["ML-PE25-W-014"]}]},{"path":"/aura/analytics/returns-and-refunds","method":"GET","business_object":"POSTransaction","description":"Retours et remboursements par magasin sur 30 jours","record_count_hint":240,"refresh_frequency":"DAILY","fields":[{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"date","type":"date","example":"2026-06-12"},{"name":"returns_count","type":"number","example":12},{"name":"refund_amount_eur","type":"number","example":1840.0},{"name":"top_reason","type":"enum","example":"SIZE"}]},{"path":"/aura/analytics/top-references-per-store","method":"GET","business_object":"POSTransaction","description":"Top 10 SKUs par magasin (8 magasins x 10 SKUs)","record_count_hint":80,"refresh_frequency":"WEEKLY","fields":[{"name":"store_id","type":"string","example":"LUM-PAR-001"},{"name":"sku","type":"string","example":"ML-PE25-W-014"},{"name":"sku_name","type":"string","example":"Top SKU N°1"},{"name":"units_sold","type":"number","example":84},{"name":"revenue_eur","type":"number","example":12400.0}]}]}