sales_order

39452 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sales_order_id_seq'::regclass)
sales_order.id_sebelumnya sales_order_id_sebelumnya_sales_order_id_fk R
sales_order_detail.id sales_order_detail_id_sales_order_id_fk R
sales_order_persetujuan.id sales_order_persetujuan_id_sales_order_id_fk R
surat_jalan.id_sales_order surat_jalan_id_sales_order_sales_order_id_fk R
surat_penolakan_penjualan.id_sales_order surat_penolakan_penjualan_id_sales_order_sales_order_id_fk R
verifikasi_persetujuan.id verifikasi_persetujuan_id_sales_order_id_fk R
nomor varchar 2147483647 null
referensi varchar 2147483647 √ null
tanggal date 13 null
id_salesman int4 10 null
id_customer int4 10 null
id_kategori _int4 10 √ null
is_ttd_digital bool 1 false
subtotal numeric 0 null
total_diskon numeric 0 null
dpp numeric 0 null
is_ppn bool 1 null
total_ppn numeric 0 null
grandtotal numeric 18,2 null
catatan text 2147483647 '-'::text
status bpchar 1 null
filename _text 2147483647 √ null
created_by int4 10 null
pegawai.id sales_order_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id sales_order_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
expired_date date 13 √ null
is_customer bool 1 false
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
tanggal_referensi date 13 √ null
is_pph_22 bool 1 null
total_pph_22 numeric 0 null
is_materai bool 1 null
materai numeric 0 null
tanggal_jatuh_tempo date 13 √ null
is_sp_outlet bool 1 false
reff varchar 2147483647 'REGULER'::character varying
id_sebelumnya int4 10 √ null
sales_order.id sales_order_id_sebelumnya_sales_order_id_fk R
persen_ppn numeric 0 null
persen_pph_22 numeric 0 null
id_penawaran_tender int4 10 √ null
penawaran_tender.id sales_order_id_penawaran_tender_penawaran_tender_id_fk R
id_spv int4 10 √ null
nama_salesman varchar 2147483647 √ null
nama_spv varchar 2147483647 √ null
catatan_dari_atas text 2147483647 '-'::text
reject_by int4 10 √ null
pegawai.id sales_order_reject_by_pegawai_id_fk R
reject_at timestamp 29,6 √ null
alasan_penolakan text 2147483647 √ null
is_salesman bool 1 √ true
is_verifikasi bool 1 false
id_verifikasi int4 10 √ null
pegawai.id sales_order_id_verifikasi_pegawai_id_fk R
waktu_verifikasi timestamp 29,6 √ null
waktu_generate timestamp 29,6 √ null
no_spb varchar 2147483647 √ null
id_area int4 10 null
area.id sales_order_id_area_area_id_fk R

Indexes

Constraint Name Type Sort Column(s)
sales_order_pkey Primary key Asc id
sales_order_id_customer_index Performance Asc id_customer
sales_order_id_customer_tanggal_status_index Performance Asc/Asc/Asc id_customer + tanggal + status
sales_order_id_index Performance Asc id
sales_order_nomor_unique Must be unique Asc nomor
sales_order_status_index Performance Asc status

Relationships

Close relationships within degrees of separation