payment_ar

23361 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('payment_ar_id_seq'::regclass)
payment_ar_detail.id payment_ar_detail_id_payment_ar_id_fk R
payment_ar_persetujuan.id payment_ar_persetujuan_id_payment_ar_id_fk R
number varchar 2147483647 null
date date 13 null
id_tipe_pembayaran int4 10 null
tipe_pembayaran.id payment_ar_id_tipe_pembayaran_tipe_pembayaran_id_fk R
id_customer int4 10 null
customer.id payment_ar_id_customer_customer_id_fk R
id_account int4 10 null
account.id payment_ar_id_account_account_id_fk R
no_cek_bg 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_ar_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id payment_ar_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
filename _text 2147483647 √ null
tanggal_cek_bg date 13 √ null
persen_biaya_transfer numeric 0 '0'::numeric
tanggal_verifikasi date 13 √ null
id_verifikasi int4 10 √ null
pegawai.id payment_ar_id_verifikasi_pegawai_id_fk R
waktu_verifikasi timestamp 29,6 √ null
grandtotal numeric 0 '0'::numeric
id_rejected int4 10 √ null
pegawai.id payment_ar_id_rejected_pegawai_id_fk R
waktu_rejected timestamp 29,6 √ null
keterangan_rejected text 2147483647 √ null
id_proposal int4 10 √ null
proposal_ar.id fk_payment_ar_id_proposal R

Indexes

Constraint Name Type Sort Column(s)
payment_ar_pkey Primary key Asc id
payment_ar_number_unique Must be unique Asc number

Relationships

Close relationships within degrees of separation