retur_pembelian

554 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('retur_pembelian_id_seq'::regclass)
nota_retur_pajak.id_retur_pembelian nota_retur_pajak_id_retur_pembelian_retur_pembelian_id_fk R
retur_pembelian_detail.id retur_pembelian_detail_id_retur_pembelian_id_fk R
retur_pembelian_hpp.id retur_pembelian_hpp_id_fkey R
retur_pembelian_persetujuan.id retur_pembelian_persetujuan_id_retur_pembelian_id_fk R
id_supplier int4 10 √ null
supplier.id retur_pembelian_id_supplier_supplier_id_fk R
nomor varchar 50 null
tanggal date 13 null
tanggal_faktur date 13 null
nomor_faktur varchar 2147483647 null
jatuh_tempo int4 10 null
id_bukti_barang_masuk int4 10 √ null
bukti_barang_masuk.id retur_pembelian_id_bukti_barang_masuk_bukti_barang_masuk_id_fk R
status bpchar 1 null
catatan text 2147483647 √ null
subtotal numeric 20,3 null
total_diskon numeric 20,3 null
dpp numeric 20,3 null
is_ppn bool 1 null
total_ppn numeric 20,3 null
grandtotal numeric 20,3 null
created_by int4 10 null
pegawai.id retur_pembelian_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id retur_pembelian_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
nomor_seri_faktur_pajak varchar 2147483647 √ null
is_upload_nrp bool 1 null
nomor_faktur_pajak varchar 2147483647 √ null
file_faktur_pajak varchar 2147483647 √ null
id_alasan_retur int4 10 null
alasan_retur.id retur_pembelian_id_alasan_retur_alasan_retur_id_fk R
id_penerima int4 10 √ null
pegawai.id retur_pembelian_id_penerima_pegawai_id_fk R
waktu_diterima timestamp 29,6 √ null
reff varchar 2147483647 'REGULER'::character varying
is_bukti_barang_masuk bool 1 null
nomor_bukti_barang_masuk varchar 2147483647 √ null
persen_ppn numeric 0 0
id_ppn int4 10 √ null
pajak.id retur_pembelian_id_ppn_fkey R

Indexes

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

Relationships

Close relationships within degrees of separation