retur_pembelian_detail

1007 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
retur_pembelian.id retur_pembelian_detail_id_retur_pembelian_id_fk R
urut int4 10 null
id_barang int4 10 null
barang.id retur_pembelian_detail_id_barang_barang_id_fk R
qty numeric 10,5 null
harga_beli numeric 20,3 null
harga_jual numeric 20,3 null
diskon_persen_1 numeric 5,2 null
diskon_rp_1 numeric 20,3 null
diskon_persen_2 numeric 5,2 null
diskon_rp_2 numeric 20,3 null
diskon_persen_3 numeric 20,3 null
diskon_rp_3 numeric 20,3 null
total numeric 20,3 null
id_bukti_barang_masuk_detail int4 10 √ null
bukti_barang_masuk.id retur_pembelian_detail_id_bukti_barang_masuk_bukti_barang_masuk R
id_tipe_diskon int4 10 √ null
tipe_diskon.id retur_pembelian_detail_id_tipe_diskon_tipe_diskon_id_fk R
qty_max numeric 10,5 '0'::numeric
urut_bukti_barang_masuk_detail int4 10 √ null
batch varchar 2147483647 null
expired_date date 13 null

Indexes

Constraint Name Type Sort Column(s)
retur_pembelian_detail_id_urut_pk Primary key Asc/Asc id + urut

Relationships

Close relationships within degrees of separation