invoice_retur_detail

1118 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
invoice_retur.id invoice_retur_detail_id_invoice_retur_id_fk R
urut int4 10 null
id_invoice_detail int4 10 √ null
urut_invoice_detail int4 10 √ null
id_barang int4 10 null
barang.id invoice_retur_detail_id_barang_barang_id_fk R
id_satuan int4 10 null
satuan.id invoice_retur_detail_id_satuan_satuan_id_fk R
id_stok int4 10 √ null
stok_barang.id invoice_retur_detail_id_stok_stok_barang_id_fk R
qty numeric 0 null
diskon_persen numeric 0 null
diskon_rp numeric 0 null
total numeric 0 null
id_pengajuan int4 10 null
urut_pengajuan int4 10 null
id_stok_baru int4 10 √ null
stok_barang.id invoice_retur_detail_id_stok_baru_stok_barang_id_fk R
harga_beli numeric 0 '0'::numeric
harga_jual numeric 0 '0'::numeric
batch varchar 2147483647 null
expired_date date 13 null

Indexes

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

Relationships

Close relationships within degrees of separation