surat_jalan

56753 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('surat_jalan_id_seq'::regclass)
checking.id_surat_jalan checking_id_surat_jalan_surat_jalan_id_fk R
invoice_surat_jalan.id_surat_jalan invoice_surat_jalan_id_surat_jalan_surat_jalan_id_fk R
packing_detail.id_surat_jalan packing_detail_id_surat_jalan_surat_jalan_id_fk R
retur_konsinyasi.id_surat_jalan retur_konsinyasi_id_surat_jalan_surat_jalan_id_fk R
surat_jalan_detail.id surat_jalan_detail_id_surat_jalan_id_fk R
surat_tanda_terima_detail.id_surat_jalan surat_tanda_terima_detail_id_surat_jalan_surat_jalan_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
id_tipe_transaksi int4 10 null
tipe_transaksi.id surat_jalan_id_tipe_transaksi_tipe_transaksi_id_fk R
id_sales_order int4 10 null
sales_order.id surat_jalan_id_sales_order_sales_order_id_fk R
id_customer int4 10 null
id_salesman int4 10 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 18,2 null
catatan varchar 2147483647 null
status bpchar 1 null
created_by int4 10 null
pegawai.id surat_jalan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id surat_jalan_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
is_picking bool 1 √ false
tanggal_picking timestamptz 35,6 √ null
tanggal_terima_kembali timestamptz 35,6 √ null
revisian_ke int4 10 √ 0
id_picking int4 10 √ null
pegawai.id surat_jalan_id_picking_pegawai_id_fk R
id_kategori_surat_pesanan int4 10 √ null
kategori_surat_pesanan.id surat_jalan_id_kategori_surat_pesanan_kategori_surat_pesanan_id R
top int4 10 0
tanggal_jatuh_tempo date 13 √ null
id_area int4 10 √ null
area.id surat_jalan_id_area_area_id_fk R
id_area_delivery int4 10 √ null
area.id surat_jalan_id_area_delivery_area_id_fk R
persen_ppn numeric 0 '11'::numeric
persen_pph_22 numeric 0 1.5
id_penawaran_tender int4 10 √ null
penawaran_tender.id surat_jalan_id_penawaran_tender_penawaran_tender_id_fk R
id_spv int4 10 √ null
nama_salesman varchar 2147483647 √ null
nama_spv varchar 2147483647 √ null
tanggal_terima_barang timestamp 29,6 √ null
catatan_dari_atas text 2147483647 '-'::text
is_salesman bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
surat_jalan_pkey Primary key Asc id
surat_jalan_id_sales_order_index Performance Asc id_sales_order
surat_jalan_nomor_unique Must be unique Asc nomor

Relationships

Close relationships within degrees of separation