የSmartERP መመሪያ የAshewa Technology Solutions መድረክ
ይህ ገጽ ገና ወደ አማርኛ አልተተረጎመም። የእንግሊዝኛው ጽሑፍ ቀርቧል።

Floriculture Data Model & Cold-Chain Schema Architecture

Technical specifications of database models, harvest tables, temperature logging schemas, and export logistics relationships.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Floriculture Data Model & Cold-Chain Schema Architecture within SmartERP.

የአበባ እርሻ ምርት መረጣ፣ ማቀዝቀዣ፣ የዕፅዋት ጤና ምርመራ እና የአየር ጭነት ስራ ፍሰት።
የአበባ ምርት ድህረ-ምርት አያያዝ፣ የቀዝቃዛ ሰንሰለት ቁጥጥር እና የአየር ጭነት ኤክስፖርት።

Technical specifications of database models, harvest tables, temperature logging schemas, and export logistics relationships.

2. Prerequisites & Security Access Groups#

  • Required Modules: smarterp_commodity_export, smarterp_agri_traceability
  • Security Groups:
    • Cold Chain & Packhouse Officer (Technical ID: smarterp_export.group_export_user)
    • Floriculture Quality Inspector (Technical ID: smarterp_export.group_export_qa)
    • Floriculture Export Manager (Technical ID: smarterp_export.group_export_manager)
  • Master Data Dependencies: Greenhouse greenhouse blocks, rose stem varieties, cold storage temperature telemetry (2°C–4°C), Ethiopian Airlines Bole Cargo space bookings, and European auction buyers.

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Interface#

  1. Log into your SmartERP instance at https://smarterp.et/odoo.
  2. Open the main App Switcher (grid icon in the top-left corner).
  3. Navigate to Floriculture → Cold Chain → Shipments.

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Farm General Manager, Packhouse Supervisor, Export Freight Agent).
  • Relational Integrity: Linked to upstream master records, approval requests, or transactional ledgers.
  • Statutory & Quality Controls: Verified against Ethiopian statutory regulations and corporate governance standards.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Audited to Confirmed / Certified.
  • Integrated System Impact: Automatically updates real-time operational states and posts financial/inventory journal moves.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Relational Entity Architecture#

SmartERP Floriculture connects greenhouse harvest batches, packhouse grading lines, cold room telemetry, and airfreight manifests:

የግብርና ኤክስፖርት ዳታ ሞዴል እና የሂደቶች ትስስር።
የSmartERP ቡና እና አበባ ኤክስፖርት ዋና የዳታ ሞዴል ስነ-ህንፃ።

Core Model Specifications#

1. Harvest Batch: flower.harvest.batch#

Captures greenhouse picking data:

  • block_id (Many2one -> greenhouse.block).
  • variety_id (Many2one -> flower.variety).
  • cut_stage (Selection): stage_1_5, stage_2_0, stage_2_5, stage_3_0.
  • stems_harvested (Integer), harvest_date (Datetime).
  • bucket_solution_id (Many2one -> flower.hydration.solution).

2. Packhouse Grading Run: flower.grading.run#

Tracks stem sorting and defect culling:

  • harvest_batch_id (Many2one -> flower.harvest.batch).
  • line_ids (One2many -> flower.grading.line):
    • stem_length (Selection): 40cm, 50cm, 60cm, 70cm, 80cm, 90cm.
    • stem_count (Integer), bunch_count (Integer).
  • culls_count (Integer), culled_reason (Selection).

3. Temperature Telemetry Log: flower.coldchain.log#

Logs automated IoT thermal sensor readings:

  • sensor_id (Char), location_type (Selection: precooler, coldroom, reefer_truck).
  • temperature_celsius (Float), humidity_pct (Float).
  • timestamp (Datetime, index).
  • alert_triggered (Boolean).

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • Cold Chain: Alert temperature breach above 4°C (smarterp_export.ir_cron_temp_monitor): Runs every 15 minutes checking IoT temperature telemetry
    • Air Cargo: Track Bole cargo flight departure (smarterp_export.ir_cron_flight_status): Runs hourly checking Ethiopian Airlines cargo flight tracking
  • Custom Print Templates & Reports:
    • Cold Chain Temperature Compliance Certificate
    • MoA Phytosanitary Export Inspection Dossier
    • Bole Cargo Air Waybill (e-AWB) & Pallet Manifest
    • Consignment Net Realization & Auction Settlement Summary
  • Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Cold Chain Alert: Pallet temperature exceeds 4.0°CPre-cooling incomplete or refrigerated truck cooling unit failure.Return consignment to forced-air blast cooling chamber before authorizing truck departure.
Air Cargo Booking Cancellation: Flight payload limitEthiopian Airlines cargo space bumped due to aircraft weight restrictions.Reschedule consignment to next scheduled cargo flight and maintain continuous cold room storage.
Phytosanitary Quarantine BlockInspection detected regulated pest (thrips, false codling moth).Quarantine affected pallet and perform authorized fumigation treatment under MoA supervision.
መጨረሻ የተሻሻለው: 2026-11-15