sales_order_hpp

399458 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
surat_penolakan_penjualan_detail.id_sales_order_hpp surat_penolakan_penjualan_detail_id_sales_order_hpp_urut_sales_ R
sales_order_detail.id sales_order_hpp_sales_order_detail C
id_stok int4 10 null
stok_barang.id sales_order_hpp_id_stok_stok_barang_id_fk R
is_bonus bool 1 false
qty numeric 0 null
qty_disetujui numeric 0 null
qty_ditolak numeric 0 null
status bool 1 √ null
urut int4 10 null
surat_penolakan_penjualan_detail.urut_sales_order_hpp surat_penolakan_penjualan_detail_id_sales_order_hpp_urut_sales_ R
id_alasan_penolakan int4 10 √ null
alasan_penolakan.id sales_order_hpp_id_alasan_penolakan_alasan_penolakan_id_fk R
id_barang int4 10 null
sales_order_detail.id_barang sales_order_hpp_sales_order_detail C
barang.id sales_order_hpp_id_barang_barang_id_fk R
is_diskon bool 1 false
index_promotion int4 10 √ null
index_reward int4 10 √ null
harga_jual numeric 0 0

Indexes

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

Relationships

Close relationships within degrees of separation