payment_ap

628 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('payment_ap_id_seq'::regclass)
payment_ap_detail.id payment_ap_detail_id_payment_ap_id_fk R
payment_ap_persetujuan.id payment_ap_persetujuan_id_payment_ap_id_fk R
payment_ap_tambahan_diskon.id payment_ap_tambahan_diskon_id_payment_ap_id_fk R
number varchar 2147483647 null
date date 13 null
id_tipe_pembayaran int4 10 null
tipe_pembayaran.id payment_ap_id_tipe_pembayaran_tipe_pembayaran_id_fk R
id_supplier int4 10 null
supplier.id payment_ap_id_supplier_supplier_id_fk R
bank_account int4 10 null
account.id payment_ap_bank_account_account_id_fk R
no_bank varchar 2147483647 √ null
other_cost numeric 0 '0'::numeric
total_discount numeric 0 '0'::numeric
total numeric 0 '0'::numeric
pembulatan numeric 0 '0'::numeric
biaya_transfer numeric 0 '0'::numeric
nilai_transfer numeric 0 '0'::numeric
status bpchar 1 null
description text 2147483647 √ null
created_by int4 10 null
pegawai.id payment_ap_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id payment_ap_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
subtotal numeric 0 '0'::numeric
id_supplier_bank int4 10 √ null
bank.bank Implied Constraint R
urut_supplier_bank int4 10 √ null
bank.bank Implied Constraint R
nama_bank varchar 2147483647 √ null
no_rekening varchar 2147483647 √ null
nama_pemilik varchar 2147483647 √ null
cabang varchar 2147483647 √ null
saldo numeric 0 '0'::numeric

Indexes

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

Relationships

Close relationships within degrees of separation