XERPIUM COAL

Summary

Enterprise Coal Mining Ecosystem

XERPIUM COAL is a complete ERP solution for coal mining — from mine site & block, production per shift, quality lab, heavy equipment, HSE, stockpile, delivery, to ESDM reporting & accounting.

MINE

Site & Block

PROD

Shift & Tonnage

LAB

CV, Ash, Sulfur

FLEET

Equipment & Fuel

🛡

HSE

Safety & Permit

🚚

DELIVERY

Sales & Transport

📄

ESDM

Govt Reports

📈

DASHBOARD

KPI Real-time

Master Data

Coal Mining Master Data

Structured master data for all coal mining entities — site, block, seam, cost center, shift.

🏛

coal.mine.site — Mine Site

Site Code — Unique per company, GPS coordinates (lat/lon)
Area — Total area (hectares), province, district, address
Permit Management — Permit no, type (IUP/IUPK/IPR), issue date, expiry, days remaining (computed)
State — Active, Suspended, Closed (with workflow actions)
Stats — Block count, total reserve tons (computed from blocks)

🏢

coal.mine.block — Mine Block

Block Code — Unique per site, area (ha), depth (m)
Mining Type — Open Pit, Underground, Alluvial
Geological Zone — Geological zone reference
Reserve & Quality — Estimated reserve (ton), estimated CV (kcal/kg)
Linked Seam — coal.seam reference
Status — Exploration → Development → Production → Depleted

📦

coal.seam — Coal Seam

Seam Code — Unique, thickness (m), depth from/to
Quality Parameters — Typical CV (kcal/kg), ash %, moisture %, volatile matter %, sulfur %
Reference Data — Used in block estimation & production quality

💰

coal.cost.center + coal.shift

Cost Center — Analytic account per site/block, budget tracking
Shift Management — Day/Night/Evening for 24/7 operations
Linked — Cost center to production order, shift to daily operations

📈

Master Data Views — Mine Site, Block, Seam, Cost Center

Form with permit timeline, seam quality parameters, reserve estimation

Production

Coal Production per Shift

Mine production flow from planning to stockpile — shift-based, equipment tracking, quality parameters directly on the MO.

Draft

→

In Progress

→

Done → Stockpile

🚚

coal.production.order — Coal MO

Auto-sequence — CPO/2026/00001 format, unique per company
Site & Block — Linked to mine site + block (in production), seam reference
Shift & Date — Required shift, production date, responsible employee
Planning — Planned tons vs actual tons, achievement % computed
Quality at Extraction — Actual CV (kcal/kg), actual ash %, actual moisture % directly on the MO
Fuel — Total fuel liter computed from production lines
Stockpile Link — Stockpile target, auto-add tons when done

📄

coal.production.line — Production Detail

Equipment — coal.equipment linked, domain per site + active
Operator — hr.employee assignment, start/end time
Duration — Duration hours computed from start-end datetime
Output — Tons extracted (required), fuel used liter
Notes — Per-line operational notes

📦

coal.stockpile — Coal Stockpile

Capacity — Max capacity tons, current tonnage tracking
Quality — Weighted average CV, ash, moisture
Auto Update — _add_tons method called when production is done
Movement — In/out tracking with weighted average quality

🚗

coal.equipment — Heavy Equipment

Types — Excavator, Dump Truck, Loader, Bulldozer, Grader, Drill Rig, Compactor
Registry — Asset code, brand, model, year, plate no, serial/engine no
Status — Active, Under Maintenance, Idle, Retired
Metrics — Current hours, purchase value, residual, insurance
Maintenance — Schedule, history (one2many), total cost computed
Fuel — Total fuel liter, total operating hours computed

Production Workflow — From Planning to Stockpile

1 Create MO: coal.production.order → draft

2 Assign equipment: production lines → operator + equipment

3 Execute: action_start → in_progress

4 Complete: action_done → stockpile._add_tons(actual_ton, cv)

🚚

Production Order Form — Lines, Equipment, Quality CV/Ash/Moisture

coal.production.order with inline line editing, quality parameters, fuel summary

Quality

Quality Lab & Coal Analysis

Coal quality laboratory — sampling, proximate/ultimate analysis, calorific value, quality certification.

Draft

→

Submitted

→

Analyzed

→

Reported

🔬

coal.sample — Coal Sample

Auto-sequence — CS/2026/00001, source: mine face, stockpile, delivery, rehandle
Sample Types — Chip, Grab, Channel, Composite
Collection — Date collected, collected by (employee), location
Linked — To production order or stockpile
State — Draft → Submitted → Analyzed → Reported

📊

coal.lab.result — Lab Result

Proximate Analysis — Total moisture %, ash %, volatile matter %, fixed carbon %
Ultimate Analysis — Carbon %, hydrogen %, nitrogen %, oxygen %, sulfur %
Calorific Value — Gross CV (kcal/kg), Net CV (kcal/kg)
Analyst — Employee assigned, analysis date
State — Draft → Done → Verified

📄

coal.quality.certificate — Quality Certificate

Auto-sequence — Certificate no, linked to sample
Grade Classification — Grade A/B/C/Sub-bituminous/Lignite based on CV
Parameters — CV, ash, moisture, sulfur, weight ton
Customer — Customer linked for delivery certificate
State — Draft → Issued → Revoked

📝

Coal Quality Parameters

Parameter	Method	Unit
Total Moisture	Proximate	%
Ash Content	Proximate	%
Volatile Matter	Proximate	%
Fixed Carbon	Proximate (calc)	%
Sulfur Content	Ultimate	%
Gross Calorific Value	Bomb Calorimeter	kcal/kg
Net Calorific Value	Calculated	kcal/kg

🔬

Quality Lab Dashboard — Samples, Results, Certificates

coal.sample + coal.lab.result with proximate/ultimate analysis, CV calculation

Sales

Delivery Order & Sales

Coal delivery management from stockpile to customer — truck/vessel tracking, quality certificate, invoice integration.

Draft

→

Dispatched

→

Delivered

🚚

coal.delivery.order — Delivery Order

Auto-sequence — Unique DO number, linked to sale.order
Transport — Truck no, driver name, vessel (for barging)
Weight — Gross weight, tare weight, net weight (computed)
Quality at Delivery — CV, ash, moisture for quality certificate
Schedule — Dispatch date, delivery date
State — Draft → Dispatched → Delivered

💰

coal.sale.order + coal.vessel

Sale Order — Customer contract, price per ton, quality specs
Vessel Registry — Barge/vessel name, capacity, dimension
Invoice Integration — Account.move linked for billing
Quantity Tracking — Ordered vs delivered tonnage

🚚

Delivery Order Form — Weight, Quality, Truck/Vessel Info

coal.delivery.order with gross/tare/net weight, quality fields, dispatch tracking

HSE

Health, Safety & Environment

Integrated HSE system for coal mining — incident reporting, safety inspection, permit to work.

🛡

coal.hse.incident — Incident Report

Types — Personal Injury, Near Miss, Property Damage, Environmental, Fire, Vehicle, Chemical Spill, Structural
Severity — Low, Medium, High, Critical (with investigation tracking)
Root Cause — Analysis, corrective action, preventive action required before close
Impact — Lost time days (constraint >=0), first aid, hospitalization
Evidence — Witnesses, photos, attachments
State — Draft → Reported → Investigating → Closed

📝

coal.safety.inspection + Permit to Work

Inspections — Daily, weekly, monthly checklists, score % auto-compute
Permit Types — Hot Work, Confined Space, Working at Height, Excavation
PTW Details — Start/end datetime, area, responsible person
Environmental — Monitoring, waste management, reclamation tracking

Government

Government Reporting (ESDM)

Automatic reporting system for ESDM — production, sales, environment, royalties, exports — with JSON format and attachment management.

Draft

→

Confirmed

→

Submitted

→

Approved

📄

coal.govt.report — ESDM Report

Report Types — Production Report, Sales/PLN Report, Environmental Report, Royalty Report, Export Report
Period — Period start/end, site-specific, company
Auto-computed — Total production ton, delivery ton, revenue, avg CV/ash/moisture
Data Generation — _generate_report_json() method with structured data per type
Production Data — By block, tonnage, order count, quality averages
Sales/Export Data — By customer/vessel, tonnage, revenue
Environmental — Incident counts by type and severity
Royalty — Calculated from production x rate_per_ton

💰

coal.royalty.rate — Royalty Rate

Rate Configuration — Per coal type, rate per ton, effective date
Auto Calculation — Royalty amount computed in govt report
History — Rate changes tracked by effective date
Integration — Used in royalty report generation

Government Report — Auto-Generated Structure

        # Production Report JSON Structure

        {

          "report_name": "ESDM Production - Site A",

          "report_type": "production",

          "period": { "start": "2026-01-01", "end": "2026-01-31" },

          "site": { "name": "Site A", "code": "SA001" },

          "production": {

            "total_tonnage": 125000,

            "total_orders": 248,

            "blocks": { "Block-A": {"tonnage": 75000, "count": 150} },

            "quality": { "avg_cv": 5200, "avg_ash": 12.5, "avg_moisture": 8.2 }

          }

        }

📄

Government Report Form — ESDM Production, Sales, Royalty, Export

coal.govt.report with period selector, auto-computed summaries, JSON data, attachment upload

Analytics

Coal Mining Dashboard & KPIs

Real-time analytics dashboard to monitor production, quality, equipment, HSE, and delivery.

PROD

Orders Today

CV

Avg kcal/kg

FLEET

Active Equipment

ESDM

Govt Reports

Coal Mining KPI Widgets

Widget	Metric	Source
Production Orders	Count by state, by site	coal.production.order
Achievement %	Actual ton / planned ton gauge	coal.production.order
CV Trend	Avg calorific value per month (line)	coal.production.order
Stockpile Status	Current ton vs capacity (gauge)	coal.stockpile
Equipment Status	By state: active/maintenance/idle (pie)	coal.equipment
Delivery Performance	Dispatch vs delivered (funnel)	coal.delivery.order
HSE Incidents	By type, severity (stacked bar)	coal.hse.incident
ESDM Compliance	Reports submitted vs due (list)	coal.govt.report

AI Dashboard Features

Auto-Generate — "Create a coal production dashboard" → full dashboard
NL → SQL — "January production per site" → SQL query
Chart Insight — AI analysis of production trends, CV decline
Copilot Chat — SSE-streamed chat with mining dashboard context

Chart Types Available

tile line bar bar_h area pie doughnut scatter radar funnel gauge bullet map list stacked_bar waterfall

📈

Dashboard Studio — Coal Mining KPI

Production Achievement, CV Trend, Equipment Status, Delivery Funnel, HSE Incidents Bar

Accounting

Coal Mining Accounting

Coal mining-specific Chart of Accounts with automatic journal flow from production and stockpile to sales.

Key Accounts — Coal Mining

Account	Tipe	Function
Coal Stockpile — ROM	Asset	Value of coal in stockpile
Coal Inventory — Ready	Asset	Coal ready for sale
Mining Revenue — Coal	Revenue	Coal sales revenue
Overburden Removal Cost	Expense	Overburden stripping costs
Coal Production Cost	Expense	Coal production costs
Hauling Cost	Expense	Hauling costs
Royalty Expense	Expense	Royalty to the government
Reclamation Reserve	Liability	Reclamation reserve

Mining Accounting Features

Cost Center per Site — Analytic account per site/block
Auto-Journal Production — Automatic journal when coal is moved to stockpile
Revenue Matching — Revenue recognition when delivery is confirmed
Royalty Accrual — Royalty accrued per production period
Asset Depletion — Coal resource depletion
Multi-Company — Multi-site operations with separate companies

💰

Chart of Accounts — Coal Mining

COA with groups: Coal Inventory, Mining Revenue, Production Cost, Royalty & Tax

CEISA & Export

CEISA, Export & Import

CEISA 4.0 integration for coal exports — PEB, Packing List, Certificate of Origin, LC/TT, landed cost.

🚚

Export Operations

Export DO — Delivery order export: container, vessel, port loading/discharge, incoterm
PEB — Export Goods Notification: DJBC registration number, CEISA integration
Packing List — Total packages, gross/net weight, volume per product
Certificate of Origin — Form D (ASEAN), Non-ASEAN, preferential tariff
Export Invoice — Commercial invoice export in USD, FOB value, incoterm

💰

Trade & Finance

LC (Letter of Credit) — Sight/usance, import/export, issuance/expiry/shipping date
TT/Remittance — Outgoing/incoming payment, bank reference, status tracking
Landed Cost — FOB + freight + insurance + duty + tax + handling
Forex Tracking — USD/IDR rate, realized vs booking gain/loss
Bank Reconciliation — Auto-match payment ke LC/TT reference

Ecosystem

Cross-Module Integration

Coal Mining fully integrated with the entire XERPIUM ecosystem.

💰

Coal ↔ Accounting

Coal mining COA, automatic production & delivery GL
Sales revenue, royalty accrual, cost matching
Analytic per site/block for cost tracking

📦

Coal ↔ Inventory

Stockpile inventory with weighted avg CV
Spare part equipment inventory
Material request for consumables & explosives

🔗

Coal ↔ Purchase

PO for diesel, spare parts, explosives
Purchase requisition from equipment maintenance
Vendor management (contractor, supplier)

👥

Coal ↔ HR

Operator assignment, HSE officer, lab analyst
Shift scheduling, attendance for 24/7 ops
HSE training & certification tracking

📈

Coal ↔ Dashboard

vit_dashboard_coal_mining — KPI end-to-end
Dashboard Studio: 19 chart types
AI auto-generate dashboard & insight

🤖

Coal ↔ AI Assistant

Check production: "How many tons were produced today?"
Check quality: "Average CV this month"
Generate report: "Create the ESDM production report"

📄

Coal ↔ Quality

Lab results integration with production CV
Quality certificate for delivery
Grade classification per shipment

🚚

Coal ↔ Export

DO → Packing List → PEB → CoO → Invoice
CEISA integration for PEB submission
Container, vessel, port tracking

🏢

Coal ↔ Trade

LC sight/usance, TT/remittance
Landed cost calculation
Forex USD/IDR tracking

🔗

Coal ↔ Dynamic Stage

Configurable workflow for production, quality, delivery
Python hooks, server actions, RBAC
Auto-sync stage ↔ native state

Comparison

Why XERPIUM Coal Mining?

Aspect	Manual / Spreadsheet	XERPIUM Coal Mining
Site & Block Data	✗ Separate Excel files	✓ Structured, GPS, permit tracking, reserve calibration
Daily Production	✗ Manual daily reports	✓ Shift-based, planned vs actual, equipment & quality
Quality Lab	✗ Lab results on paper	✓ Proximate/ultimate, CV auto, certificate generation
Stockpile	✗ Manual ton & CV calculation	✓ Weighted avg CV, auto-update from production
Heavy Equipment	✗ Manual logbook	✓ Registry, maintenance, fuel, hours, operator
Delivery	✗ DO manual	✓ Gross/tare/net weight, quality, vessel/truck
HSE	✗ Accident log book	✓ Incident, inspection, permit to work digital
ESDM Reporting	✗ Manual recap, error-prone	✓ Auto-computed reports, JSON data, multi-type
Dashboard & KPI	✗ None	✓ Real-time 8+ KPI, AI-powered dashboard
CEISA & Export	✗ Manual, often rejected	✓ PEB, Packing List, CoO, CEISA integration
LC/TT	✗ Bank books, spreadsheets	✓ Sight/usance, import/export, status tracking
AI Assistant	✗ Not available	✓ Natural language queries & actions
License	Paid per module	SaaS / On Premise — all included

Portfolio

XERPIUM Industry Portfolio

Industry	Module	Dashboard	Report
Inventory & WMS	275+	✓	✓
Manufacturing	230+	✓	✓
Purchase	105	✓	✓
HR & Payroll	29	✓	✓
Aerospace	10	✓	✓
Accounting	9	✓	✓
University	9	✓	✓
Distribution	8	✓	✓
Koperasi	8	✓	✓
Retail & POS	7+	✓	✓
Gold Mining & Refinery	7	✓	✓
Aviation	6	✓	✓
Coal Mining	6	✓	✓
Hospital & Pharmacy	6	✓	✓
Hajj & Umrah Travel	6	✓	✓
Logistics	5	✓	✓
Hotel & Property	5	✓	✓
Beauty Clinic	5	✓	✓
Rental	4	✓	✓
Livestock	4	✓	✓
Fishery	4	✓	✓
Software House	4	✓	✓
Event Organizer	4	✓	✓
Satellite City	2	✓	✓
Education Foundation	2	✓	✓
Food & Beverage	1	✓	✓
Civil Construction	1	✓	✓
Garment	1	✓	✓
Agriculture	1	✓	✓
Theme Park	1	✓	✓
Data Center / IT	1	✓	✓
Palm Oil	1	✓	✓
Feedmill	1	✓	✓
Building Management	1	✓	✓
Auditor	1	✓	✓

XERPIUMCOAL

Enterprise Coal Mining Ecosystem

Coal Mining Master Data

coal.mine.site — Mine Site

coal.mine.block — Mine Block

coal.seam — Coal Seam

coal.cost.center + coal.shift

Coal Production per Shift

coal.production.order — Coal MO

coal.production.line — Production Detail

coal.stockpile — Coal Stockpile

coal.equipment — Heavy Equipment

Production Workflow — From Planning to Stockpile

Quality Lab & Coal Analysis

coal.sample — Coal Sample

coal.lab.result — Lab Result

coal.quality.certificate — Quality Certificate

Coal Quality Parameters

Delivery Order & Sales

coal.delivery.order — Delivery Order

coal.sale.order + coal.vessel

Health, Safety & Environment

coal.hse.incident — Incident Report

coal.safety.inspection + Permit to Work

Government Reporting (ESDM)

coal.govt.report — ESDM Report

coal.royalty.rate — Royalty Rate

Government Report — Auto-Generated Structure

Coal Mining Dashboard & KPIs

Coal Mining KPI Widgets

AI Dashboard Features

Chart Types Available

Coal Mining Accounting

Key Accounts — Coal Mining

Mining Accounting Features

CEISA, Export & Import

Export Operations

Trade & Finance

Cross-Module Integration

Coal ↔ Accounting

Coal ↔ Inventory

Coal ↔ Purchase

Coal ↔ HR

Coal ↔ Dashboard

Coal ↔ AI Assistant

Coal ↔ Quality

Coal ↔ Export

Coal ↔ Trade

Coal ↔ Dynamic Stage

Why XERPIUM Coal Mining?

XERPIUM Industry Portfolio