XERPIUM COAL

Ringkasan

Ekosistem Tambang Batubara Enterprise

XERPIUM COAL adalah solusi ERP lengkap untuk tambang batubara — dari mine site & block, produksi per shift, quality lab, heavy equipment, HSE, stockpile, delivery, hingga pelaporan ESDM & akuntansi.

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

Master Data Tambang Batubara

Data master terstruktur untuk seluruh entitas tambang batubara — site, block, seam, cost center, shift.

🏛

coal.mine.site — Site Tambang

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 ton (computed from blocks)

🏢

coal.mine.block — Blok Tambang

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 — Lapisan Batubara

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 dengan permit timeline, seam quality parameters, reserve estimation

Production

Produksi Batubara per Shift

Alur produksi tambang dari perencanaan hingga stockpile — shift-based, equipment tracking, quality parameters langsung di MO.

Draft

→

In Progress

→

Done → Stockpile

🚚

coal.production.order — MO Batubara

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 ton vs actual ton, achievement % computed
Quality at Extraction — Actual CV (kcal/kg), actual ash %, actual moisture % langsung di MO
Fuel — Total fuel liter computed from production lines
Stockpile Link — Target stockpile, auto-add ton saat done

📄

coal.production.line — Detail Produksi

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 — Stockpile Batubara

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

🚗

coal.equipment — Alat Berat

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 — Dari Perencanaan ke 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 dengan inline editing lines, quality parameters, fuel summary

Quality

Quality Lab & Coal Analysis

Laboratorium quality batubara — sampling, proximate/ultimate analysis, calorific value, quality certification.

Draft

→

Submitted

→

Analyzed

→

Reported

🔬

coal.sample — Sample Batubara

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 — Hasil Lab

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 — Sertifikat Kualitas

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 cert
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 & Penjualan

Manajemen delivery batubara dari stockpile ke 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 untuk quality cert
Schedule — Dispatch date, delivery date
State — Draft → Dispatched → Delivered

💰

coal.sale.order + coal.vessel

Sale Order — Customer contract, pricing 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 dengan gross/tare/net weight, quality fields, dispatch tracking

HSE

Health, Safety & Environment

Sistem HSE terintegrasi untuk tambang batubara — 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

Pelaporan Pemerintah (ESDM)

Sistem pelaporan otomatis untuk ESDM — produksi, penjualan, lingkungan, royalti, ekspor — dengan format JSON dan attachment management.

Draft

→

Confirmed

→

Submitted

→

Approved

📄

coal.govt.report — Laporan ESDM

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 — Tarif Royalti

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 dengan period selector, auto-computed summaries, JSON data, attachment upload

Analytics

Dashboard & KPI Tambang Batubara

Dashboard analytics real-time untuk monitoring produksi, quality, equipment, HSE, dan 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 — "Buat dashboard produksi batubara" → full dashboard
NL → SQL — "Produksi bulan Januari per site" → SQL query
Chart Insight — AI analisis tren produksi, penurunan CV
Copilot Chat — SSE-streamed chat dengan konteks dashboard tambang

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

Akuntansi Tambang Batubara

Chart of Account khusus tambang batubara dengan alur jurnal otomatis dari produksi, stockpile, hingga penjualan.

Akun Penting — Tambang Batubara

Akun	Tipe	Fungsi
Coal Stockpile — ROM	Asset	Nilai batubara di stockpile
Coal Inventory — Ready	Asset	Batubara siap jual
Mining Revenue — Coal	Revenue	Pendapatan penjualan batubara
Overburden Removal Cost	Expense	Biaya pengupasan lapisan tanah
Coal Production Cost	Expense	Biaya produksi batubara
Hauling Cost	Expense	Biaya pengangkutan
Royalty Expense	Expense	Royalti ke pemerintah
Reclamation Reserve	Liability	Cadangan reklamasi

Fitur Akuntansi Tambang

Cost Center per Site — Analytic account per site/block
Auto-Journal Production — Jurnal otomatis saat coal dipindah ke stockpile
Revenue Matching — Revenue recognition saat delivery terkonfirmasi
Royalty Accrual — Royalti di-accrue per periode produksi
Asset Depletion — Depletion sumber daya batubara
Multi-Company — Operasi multi-site dengan company terpisah

💰

Chart of Accounts — Coal Mining

COA dengan group: Coal Inventory, Mining Revenue, Production Cost, Royalty & Tax

CEISA & Export

CEISA, Ekspor & Impor

Integrasi CEISA 4.0 untuk ekspor batubara — PEB, Packing List, Certificate of Origin, LC/TT, landed cost.

🚚

Export Operations

Export DO — Delivery order export: container, vessel, port loading/discharge, incoterm
PEB — Pemberitahuan Ekspor Barang: nomor pendaftaran DJBC, 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

Integrasi Cross-Module

Coal Mining terintegrasi penuh dengan seluruh ekosistem XERPIUM.

💰

Coal ↔ Accounting

COA tambang batubara, GL otomatis produksi & delivery
Revenue penjualan, royalty accrual, cost matching
Analytic per site/block untuk cost tracking

📦

Coal ↔ Inventory

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

🔗

Coal ↔ Purchase

PO untuk solar, spare part, bahan peledak
Purchase requisition dari 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

Cek produksi: "Produksi hari ini berapa ton?"
Cek quality: "Rata-rata CV bulan ini"
Generate report: "Buat laporan ESDM produksi"

📄

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 untuk 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 produksi, quality, delivery
Python hooks, server actions, RBAC
Auto-sync stage ↔ native state

Comparison

Mengapa XERPIUM Coal Mining?

Aspek	Manual / Spreadsheet	XERPIUM Coal Mining
Site & Block Data	✗ File Excel terpisah	✓ Terstruktur, GPS, permit tracking, reserve calibration
Daily Production	✗ Laporan harian manual	✓ Shift-based, planned vs actual, equipment & quality
Quality Lab	✗ Hasil lab di kertas	✓ Proximate/ultimate, CV auto, certificate generation
Stockpile	✗ Manual perhitungan ton & CV	✓ Weighted avg CV, auto-update from production
Heavy Equipment	✗ Logbook manual	✓ Registry, maintenance, fuel, hours, operator
Delivery	✗ DO manual	✓ Gross/tare/net weight, quality, vessel/truck
HSE	✗ Buku kecelakaan	✓ Incident, inspection, permit to work digital
ESDM Reporting	✗ Rekap manual, rentan error	✓ Auto-computed reports, JSON data, multi-type
Dashboard & KPI	✗ Tidak ada	✓ Real-time 8+ KPI, AI-powered dashboard
CEISA & Export	✗ Manual, sering reject	✓ PEB, Packing List, CoO, CEISA integration
LC/TT	✗ Buku bank, spreadsheet	✓ Sight/usance, import/export, status tracking
AI Assistant	✗ Not available	✓ Natural language queries & actions
Lisensi	Berbayar per modul	SaaS / On Premise — all included

Portfolio

Portofolio Industri XERPIUM

Industri	Modul	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	✓	✓
Travel Haji & Umroh	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	✓	✓
Sawit / Palm Oil	1	✓	✓
Feedmill	1	✓	✓
Building Management	1	✓	✓
Auditor	1	✓	✓

XERPIUMCOAL

Ekosistem Tambang Batubara Enterprise

Master Data Tambang Batubara

coal.mine.site — Site Tambang

coal.mine.block — Blok Tambang

coal.seam — Lapisan Batubara

coal.cost.center + coal.shift

Produksi Batubara per Shift

coal.production.order — MO Batubara

coal.production.line — Detail Produksi

coal.stockpile — Stockpile Batubara

coal.equipment — Alat Berat

Production Workflow — Dari Perencanaan ke Stockpile

Quality Lab & Coal Analysis

coal.sample — Sample Batubara

coal.lab.result — Hasil Lab

coal.quality.certificate — Sertifikat Kualitas

Coal Quality Parameters

Delivery Order & Penjualan

coal.delivery.order — Delivery Order

coal.sale.order + coal.vessel

Health, Safety & Environment

coal.hse.incident — Incident Report

coal.safety.inspection + Permit to Work

Pelaporan Pemerintah (ESDM)

coal.govt.report — Laporan ESDM

coal.royalty.rate — Tarif Royalti

Government Report — Auto-Generated Structure

Dashboard & KPI Tambang Batubara

Coal Mining KPI Widgets

AI Dashboard Features

Chart Types Available

Akuntansi Tambang Batubara

Akun Penting — Tambang Batubara

Fitur Akuntansi Tambang

CEISA, Ekspor & Impor

Export Operations

Trade & Finance

Integrasi Cross-Module

Coal ↔ Accounting

Coal ↔ Inventory

Coal ↔ Purchase

Coal ↔ HR

Coal ↔ Dashboard

Coal ↔ AI Assistant

Coal ↔ Quality

Coal ↔ Export

Coal ↔ Trade

Coal ↔ Dynamic Stage

Mengapa XERPIUM Coal Mining?

Portofolio Industri XERPIUM