account

164 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('account_id_seq'::regclass)
acc_kas.akun acc_kas_akun_account_id_fk R
acc_kas_detail.id_account acc_kas_detail_id_account_account_id_fk R
acc_value.id_account acc_value_id_account_account_id_fk R
account.id_category account_id_category_account_id_fk R
account.parent account_parent_account_id_fk R
biaya_transfer.id_account_bank biaya_transfer_id_account_bank_account_id_fk R
expense_type.id_account expense_type_id_account_account_id_fk R
gudang.account_persediaan gudang_account_persediaan_account_id_fk R
initial_account.id_account initial_account_id_account_account_id_fk R
pajak.akun_pembelian pajak_akun_pembelian_account_id_fk R
pajak.akun_penjualan pajak_akun_penjualan_account_id_fk R
payment_ap.bank_account payment_ap_bank_account_account_id_fk R
payment_ar.id_account payment_ar_id_account_account_id_fk R
pegawai_account.id_account pegawai_account_id_account_account_id_fk C
uang_muka_pembelian.id_akun uang_muka_pembelian_id_akun_account_id_fk R
id_category int4 10 null
account.id account_id_category_account_id_fk R
code varchar 15 null
name varchar 100 null
level int2 5 null
is_cash bool 1 false
is_active bool 1 true
parent int4 10 null
account.id account_parent_account_id_fk R

Indexes

Constraint Name Type Sort Column(s)
account_pkey Primary key Asc id

Relationships