penawaran_tender

251 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('penawaran_tender_id_seq'::regclass)
penawaran_tender_persetujuan.id penawaran_tender_persetujuan_id_penawaran_tender_id_fk R
penolakan_penawaran_tender.id_penawaran_tender penolakan_penawaran_tender_id_penawaran_tender_penawaran_tender R
sales_order.id_penawaran_tender sales_order_id_penawaran_tender_penawaran_tender_id_fk R
surat_jalan.id_penawaran_tender surat_jalan_id_penawaran_tender_penawaran_tender_id_fk R
id_salesman int4 10 √ null
id_customer int4 10 null
customer.id penawaran_tender_id_customer_customer_id_fk R
nomor varchar 2147483647 null
nomor_sp varchar 2147483647 √ null
tanggal date 13 null
filename text 2147483647 √ null
subtotal numeric 0 '0'::numeric
total_diskon numeric 0 '0'::numeric
dpp numeric 0 '0'::numeric
is_ppn bool 1 false
persen_ppn numeric 0 '11'::numeric
total_ppn numeric 0 '0'::numeric
is_pph_22 bool 1 false
persen_pph_22 numeric 0 1.5
total_pph_22 numeric 0 '0'::numeric
is_materai bool 1 false
materai numeric 0 '0'::numeric
grandtotal numeric 0 '0'::numeric
catatan text 2147483647 null
status bpchar 1 null
created_by int4 10 null
pegawai.id penawaran_tender_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id penawaran_tender_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
id_spv int4 10 √ null
nama_salesman varchar 2147483647 √ null
nama_spv varchar 2147483647 √ null
min_expired_date date 13 √ null
top int4 10 0

Indexes

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

Relationships

Close relationships within degrees of separation