invoice

54971 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('invoice_id_seq'::regclass)
invoice_detail.id invoice_detail_id_invoice_id_fk R
invoice_persetujuan.id invoice_persetujuan_id_invoice_id_fk R
invoice_retur.id_invoice invoice_retur_id_invoice_invoice_id_fk R
invoice_surat_jalan.id_invoice invoice_surat_jalan_id_invoice_invoice_id_fk R
klaim_loyalty_detail.id_invoice klaim_loyalty_detail_id_invoice_invoice_id_fk R
pengajuan_retur_penjualan.id_invoice pengajuan_retur_penjualan_id_invoice_invoice_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
referensi varchar 2147483647 √ null
nomor_seri_pajak varchar 2147483647 √ null
tanggal_jatuh_tempo date 13 null
id_customer int4 10 null
customer.id invoice_id_customer_customer_id_fk R
top int4 10 0
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 invoice_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id invoice_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
id_tipe_transaksi int4 10 null
tipe_transaksi.id invoice_id_tipe_transaksi_tipe_transaksi_id_fk R
revisian_ke int4 10 √ 0
id_salesman int4 10 null
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
id_no_faktur int4 10 √ null
no_faktur.id invoice_id_no_faktur_no_faktur_id_fk R
no_faktur varchar 2147483647 √ null
tanggal_terima_kembali timestamptz 35,6 √ null
hpp numeric 0 null
persen_ppn numeric 0 null
persen_pph_22 numeric 0 null
reff varchar 2147483647 'REGULER'::character varying
id_reff int4 10 null
id_spv int4 10 √ null
nama_salesman varchar 2147483647 √ null
nama_spv varchar 2147483647 √ null
is_export_coretax bool 1 false
exported_by int4 10 √ null
pegawai.id invoice_exported_by_pegawai_id_fk R
exported_at timestamp 29,6 √ null
waktu_serah_terima_1 timestamptz 35,6 √ null
waktu_serah_terima_2 timestamptz 35,6 √ null
id_serah_terima_1 int4 10 √ null
pegawai.id invoice_id_serah_terima_1_pegawai_id_fk R
id_serah_terima_2 int4 10 √ null
pegawai.id invoice_id_serah_terima_2_pegawai_id_fk R
tanggal_rencana_bayar date 13 √ null
kode_seri_pajak varchar 2147483647 √ null
tanggal_seri_pajak date 13 √ null
tanggal_hitung_insentif date 13 √ null
is_salesman bool 1 √ true
id_area int4 10 null
area.id invoice_id_area_area_id_fk R

Indexes

Constraint Name Type Sort Column(s)
invoice_pkey Primary key Asc id
invoice_id_reff_index Performance Asc id_reff
invoice_nomor_unique Must be unique Asc nomor

Relationships

Close relationships within degrees of separation