Duta Mode • Integration Layer

POS DBF → REST API Proof of Concept

Synthetic data, real pipeline. File DBF legacy dibaca dari hosting, dinormalisasi, di-upsert ke database pusat dan dicatat ke sync log. Struktur field produksi tinggal dimapping setelah DBF asli tersedia.

● CONNECTED

DBF Records

Transactions in API DB

Customers

Gross Synced

Rp906.000

Visual FoxPro / DBF

→

DBF Reader

→

Duta REST API

→

Central Database

→

CRM

Last sync: 2026-08-27T09:51:19+00:00

DBF → API Mapping

DBF	API Contract
TRX_ID	trx_id
STORE_ID	branch_code
CUST_ID	customer_id
CUST_NAME	customer_name
SKU	sku
PRODUCT	product_name
QTY	qty
TOTAL	gross_amount

API Contract

GET /api/health
POST /api/transactions
POST /api/proof-sync
GET /api/customers

Header:
X-Duta-POS-Key: <secret>

Endpoint ini siap dipanggil connector Windows/cabang nanti. PoC server-side memakai DBF sample yang sama untuk menunjukkan parsing dan idempotency.

Customer CRM Summary

Customer ID	Nama	Transaksi	Total Belanja
C0001001	Andi Saputra	2	Rp677.000
C0001002	Rina Wulandari	1	Rp229.000

Sync Logs

Waktu	Source	Status	Read	Insert	Update	Message
2026-08-27T09:51:19+00:00	POS_SALES.DBF	SUCCESS	3	0	3	DBF parsed and synchronized through Duta Mode integration layer.
2026-08-27T09:51:17+00:00	POS_SALES.DBF	SUCCESS	3	0	3	DBF parsed and synchronized through Duta Mode integration layer.
2026-08-27T09:51:15+00:00	POS_SALES.DBF	SUCCESS	3	0	3	DBF parsed and synchronized through Duta Mode integration layer.
2026-08-27T09:50:58+00:00	POS_SALES.DBF	SUCCESS	3	3	0	DBF parsed and synchronized through Duta Mode integration layer.

Synced Transactions

TRX ID	Cabang	Customer	SKU	Produk	Qty	Amount
TRX000003	SMG002	Andi Saputra	DM-CEL-007	Celana Chino Pria	1	Rp279.000
TRX000002	SLO001	Rina Wulandari	DM-WAN-014	Blouse Wanita Casual	1	Rp229.000
TRX000001	SLO001	Andi Saputra	DM-KMJ-001	Kemeja Pria Regular Fit	2	Rp398.000