{"module":"import_expenses","db":"/home/aofksaco/sgicr_erp/data/sgicr_erp.db","count":3,"rows":[{"id":4,"international_purchase_invoice_id":2,"shipment_ref":"Draft","expense_type":"Local Transport","payee_type":"Local Transporter","payee_name":"","reference_number":"","expense_date":"","currency":"MAD","exchange_rate":1.0,"amount_foreign":0.0,"amount_mad":0.0,"vat_amount":0.0,"recoverable_vat":0,"include_in_landed_cost":1,"paid_status":"Unpaid","payment_date":null,"payment_method":null,"payment_bank_account_id":null,"notes":"","created_at":"2026-06-24 18:42:40"},{"id":3,"international_purchase_invoice_id":2,"shipment_ref":"Draft","expense_type":"Supplier Freight","payee_type":"Foreign Supplier / Same Supplier","payee_name":"Hijaz Fiberglass Wll - Bahrain / USD","reference_number":"","expense_date":"2026-03-23","currency":"MAD","exchange_rate":1.0,"amount_foreign":60000.0,"amount_mad":60000.0,"vat_amount":0.0,"recoverable_vat":0,"include_in_landed_cost":1,"paid_status":"Unpaid","payment_date":null,"payment_method":null,"payment_bank_account_id":null,"notes":"","created_at":"2026-06-24 18:42:40"},{"id":1,"international_purchase_invoice_id":1,"shipment_ref":"Received","expense_type":"International Freight","payee_type":"Customs / Government","payee_name":"","reference_number":"","expense_date":"","currency":"MAD","exchange_rate":1.0,"amount_foreign":0.0,"amount_mad":0.0,"vat_amount":0.0,"recoverable_vat":0,"include_in_landed_cost":1,"paid_status":"Unpaid","payment_date":null,"payment_method":null,"payment_bank_account_id":null,"notes":"","created_at":"2026-06-22 23:03:41"}]}