* id kode_akun nama_akun jenis kategori parent_id level is_active created_at updated_at

* id nomor_biaya tanggal akun_id jumlah deskripsi bukti status created_by approved_by created_at updated_at

* id name description is_active created_at updated_at

* id nama_perusahaan alamat telepon email npwp info_bank nama_direktur logo_path signature_path updated_at

* id customer_code name email phone address city province postal_code customer_type credit_limit is_active created_at updated_at payment_term_days

* id nomor_hutang supplier_id tanggal jumlah jumlah_terbayar jatuh_tempo status notes created_by created_at updated_at

* id hutang_id tanggal jumlah metode referensi notes created_by created_at

* id sku name category_id unit_id min_stock max_stock price cost description image is_active created_at updated_at

* id item_id batch_number expiry_date quantity remaining_quantity warehouse_id purchase_order_id received_date is_active created_at updated_at

* id item_id unit_id conversion_factor is_primary is_purchase is_sales created_at

* id jurnal_id akun_id debet kredit referensi

* id nomor_jurnal tanggal deskripsi status created_by created_at updated_at

* id setting_key setting_value description updated_at

* id nomor_piutang customer_id tanggal jumlah jumlah_terbayar jatuh_tempo status notes created_by created_at updated_at

* id piutang_id tanggal jumlah metode referensi notes created_by created_at

* id order_number supplier_id order_date due_date total_amount discount_amount tax_amount paid_amount status notes created_by created_at updated_at

* id order_id item_id quantity unit_cost total_cost created_at unit_id conversion_factor

* id order_number customer_id order_date due_date total_amount discount_amount discount_type discount_percent tax_amount paid_amount status payment_type payment_status paid_date notes created_by created_at updated_at

* id order_id item_id quantity unit_price price_override total_price created_at unit_id conversion_factor

* id item_id quantity warehouse_id created_at updated_at

* id opname_number opname_date notes status total_items total_plus total_minus created_by created_at updated_at

* id opname_id item_id book_stock physical_count difference created_at

* id supplier_code name email phone address city province postal_code is_active created_at updated_at credit_limit payment_term_days

* id toko_code nama_toko alamat kecamatan kota telepon email is_active created_at updated_at

* id item_id transaction_type quantity reference_type reference_id notes created_by created_at

* id nomor_transaksi tanggal jenis kategori akun_id jumlah deskripsi referensi referensi_id created_by created_at updated_at

* id name abbreviation created_at updated_at

* id username password name email role is_active last_login created_at updated_at

* id name address city is_active created_at updated_at

select table akun_keuangan biaya_operasional categories company_profile customers hutang_keuangan hutang_pembayaran items item_batches item_units jurnal_detail jurnal_umum keuangan_settings piutang_keuangan piutang_pembayaran purchase_orders purchase_order_details sales_orders sales_order_details stock stock_opnames stock_opname_details suppliers tokos transactions transaksi_kas units users warehouses . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table akun_keuangan biaya_operasional categories company_profile customers hutang_keuangan hutang_pembayaran items item_batches item_units jurnal_detail jurnal_umum keuangan_settings piutang_keuangan piutang_pembayaran purchase_orders purchase_order_details sales_orders sales_order_details stock stock_opnames stock_opname_details suppliers tokos transactions transaksi_kas units users warehouses .	select column