Inventory Service

Port: 8084 | DB: db_kesles_merchant_inventory | Status: Live (sole source of truth untuk katalog produk & purchasing).

Overview

Mengelola katalog produk, stok gudang, dan unit inventory perangkat (QRIS Plus).

Database Schema

Schema inventory (unit, catalog, stok) + schema purchasing (WAC, pengadaan):

Schema inventory — 12 tabel:

• warehouses — gudang
• product_categories + products + product_specs_payment_device
• product_inventory_items — unit perangkat per serial number
• terminal_unit_extensions — metadata operasional per unit (nmid, tid, firmware)
• product_inventory_stock — stok per warehouse
• product_purchase_cost_history — WAC cost history
• terminal_unit_status_logs + terminal_unit_activity_logs
• terminal_status_logs + terminal_activity_logs

Schema purchasing — 10 tabel:

• vendors + purchase_orders + purchase_order_items
• goods_receipts + goods_receipt_items + goods_receipt_serial_events
• purchase_invoices + purchase_invoice_items + vendor_payments + vendor_payment_applications

3 WAC views (schema inventory):

• inventory.v_product_current_wac, inventory.v_product_wac_breakdown, inventory.v_gr_landed_cost_status

Key Endpoints

• GET /internal/inventory/units/{id} — detail unit by ID
• GET /internal/inventory/units — list + filter units
• GET /internal/inventory/purchasing/wac/ — WAC summary dan breakdown
• GET /internal/inventory/purchasing/vendors — master vendor
• GET /internal/inventory/purchasing/purchase-orders — daftar PO
• GET /internal/inventory/purchasing/goods-receipts — daftar GR

Deployment

• Folder: merchant_inventory/
• Systemd: inventory-service.service
• Port: 8084