surat_pesanan

1505 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('surat_pesanan_id_seq'::regclass)
checklist_penerimaan_barang.id_surat_pesanan checklist_penerimaan_barang_id_surat_pesanan_surat_pesanan_id_f R
penerimaan_barang.id_surat_pesanan penerimaan_barang_id_surat_pesanan_surat_pesanan_id_fk R
surat_penolakan_pembelian.id_surat_pesanan surat_penolakan_pembelian_id_surat_pesanan_surat_pesanan_id_fk R
surat_pesanan_detail.id surat_pesanan_detail_id_surat_pesanan_id_fk R
surat_pesanan_persetujuan.id surat_pesanan_persetujuan_id_surat_pesanan_id_fk R
surat_pesanan_program.id surat_pesanan_program_id_surat_pesanan_id_fk R
uang_muka_pembelian.id_surat_pesanan uang_muka_pembelian_id_surat_pesanan_surat_pesanan_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
id_kategori _int4 10 √ null
id_permintaan_penawaran int4 10 √ null
permintaan_penawaran.id surat_pesanan_id_permintaan_penawaran_permintaan_penawaran_id_f R
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 surat_pesanan_id_supplier_supplier_id_fk R
status bpchar 1 null
created_by int4 10 null
pegawai.id surat_pesanan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id surat_pesanan_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
tambahan_diskon_rp numeric 0 '0'::numeric
tambahan_diskon_persen numeric 0 '0'::numeric
is_sudah_diambil bool 1 false
diambil_oleh varchar 2147483647 √ null
waktu_diambil timestamp 29,6 √ null
is_loco bool 1 false
id_ekspedisi int4 10 √ null
ekspedisi.id surat_pesanan_id_ekspedisi_ekspedisi_id_fk R
id_yang_menyerahkan int4 10 √ null
pegawai.id surat_pesanan_id_yang_menyerahkan_pegawai_id_fk R
id_tipe_transaksi int4 10 2
tipe_transaksi.id surat_pesanan_id_tipe_transaksi_tipe_transaksi_id_fk R
uang_muka numeric 0 '0'::numeric
persen_ppn numeric 0 null
persen_pph_22 numeric 0 null
id_area int4 10 √ null
area.id surat_pesanan_id_area_area_id_fk R
reff varchar 2147483647 'REGULER'::character varying

Indexes

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

Relationships

Close relationships within degrees of separation