permintaan_penawaran

1014 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('permintaan_penawaran_id_seq'::regclass)
permintaan_penawaran_detail.id permintaan_penawaran_detail_id_permintaan_penawaran_id_fk R
permintaan_penawaran_persetujuan.id permintaan_penawaran_persetujuan_id_permintaan_penawaran_id_fk R
permintaan_penawaran_program.id permintaan_penawaran_program_id_permintaan_penawaran_id_fk R
surat_pesanan.id_permintaan_penawaran surat_pesanan_id_permintaan_penawaran_permintaan_penawaran_id_f R
nomor varchar 2147483647 null
tanggal date 13 null
catatan text 2147483647 null
subtotal numeric 0 null
total_diskon numeric 0 null
dpp numeric 0 null
is_ppn bool 1 null
total_ppn numeric 0 null
is_pph_22 bool 1 null
total_pph_22 numeric 0 null
is_materai bool 1 null
materai numeric 0 null
grandtotal numeric 0 null
id_supplier int4 10 null
supplier.id permintaan_penawaran_id_supplier_supplier_id_fk R
status bpchar 1 null
created_by int4 10 null
pegawai.id permintaan_penawaran_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id permintaan_penawaran_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_estimasi_order int4 10 √ null
estimasi_order.id permintaan_penawaran_id_estimasi_order_estimasi_order_id_fk R
persen_ppn numeric 0 null
persen_pph_22 numeric 0 null

Indexes

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

Relationships

Close relationships within degrees of separation