customer

2279 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('customer_id_seq'::regclass)
acc_ar_faktur.id_customer acc_ar_faktur_id_customer_customer_id_fk R
ar_value.id_customer ar_value_id_customer_customer_id_fk R
customer_foto.id customer_foto_id_customer_id_fk R
customer_kontak.id customer_kontak_id_customer_id_fk R
customer_legalitas.id customer_legalitas_id_customer_id_fk R
invoice.id_customer invoice_id_customer_customer_id_fk R
kontrak_loyalty.id_customer kontrak_loyalty_id_customer_customer_id_fk R
mapping_customer.id_customer mapping_customer_id_customer_customer_id_fk R
mapping_target_salesman_detail.id_customer mapping_target_salesman_detail_id_customer_customer_id_fk R
packing.id_customer packing_id_customer_customer_id_fk R
payment_ar.id_customer payment_ar_id_customer_customer_id_fk R
penawaran_tender.id_customer penawaran_tender_id_customer_customer_id_fk R
pengajuan_perubahan_limit.id_customer pengajuan_perubahan_limit_id_customer_customer_id_fk R
pengajuan_retur_penjualan.id_customer pengajuan_retur_penjualan_id_customer_customer_id_fk R
proposal_ar_detail.id_customer proposal_ar_detail_id_customer_customer_id_fk R
rencana_kunjungan_salesman_detail.id_customer rencana_kunjungan_salesman_detail_id_customer_customer_id_fk R
stok_opname_invoice.id_customer stok_opname_invoice_id_customer_customer_id_fk R
surat_penolakan_penjualan.id_customer surat_penolakan_penjualan_id_customer_customer_id_fk R
tanda_terima_invoice.id_customer tanda_terima_invoice_id_customer_customer_id_fk R
urut_kunjungan.id_customer urut_kunjungan_id_customer_customer_id_fk R
urut_pengantaran.id_customer urut_pengantaran_id_customer_customer_id_fk R
id_customer_jenis int4 10 √ null
customer_jenis.id customer_id_customer_jenis_customer_jenis_id_fk R
id_customer_kategori int4 10 √ null
customer_kategori.id customer_id_customer_kategori_customer_kategori_id_fk R
kode varchar 2147483647 null
e_report_code varchar 2147483647 √ null
nama varchar 2147483647 √ null
inisial varchar 2147483647 √ null
tanggal date 13 √ null
email varchar 2147483647 √ null
telepon varchar 2147483647 √ null
kode_seri_faktur varchar 2147483647 √ null
nama_faktur_pajak varchar 2147483647 √ null
alamat_faktur_pajak text 2147483647 √ null
no_npwp varchar 2147483647 √ null
pemegang_pkp varchar 2147483647 √ null
alamat_npwp text 2147483647 √ null
id_status_pajak int4 10 √ null
status_pajak.id customer_id_status_pajak_status_pajak_id_fk R
alamat text 2147483647 √ null
id_area int4 10 null
area.id customer_id_area_area_id_fk R
id_area_delivery int4 10 √ null
area.id customer_id_area_delivery_area_id_fk R
alamat_delivery text 2147483647 √ null
jam_buka time 15,6 √ null
jam_tutup time 15,6 √ null
keterangan text 2147483647 √ null
top int4 10 √ null
status bool 1 √ null
verification_status bool 1 √ null
is_include_ppn bool 1 √ true
is_luar_kota bool 1 √ false
is_print_faktur_pajak bool 1 √ false
is_titip_faktur bool 1 √ false
is_lampirkan_cheklist bool 1 √ false
created_by int4 10 null
pegawai.id customer_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id customer_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
file_stempel varchar 2147483647 √ null
file_npwp varchar 2147483647 √ null
id_area_penagihan int4 10 √ null
area.id customer_id_area_penagihan_area_id_fk R
alamat_penagihan text 2147483647 √ null
is_export_ke_e_faktur_pajak bool 1 √ false
id_kode_harga int4 10 √ null
plafon_umur_piutang numeric 0 √ null
plafon_per_faktur numeric 0 √ null
plafon_saldo_piutang numeric 0 √ null
max_nilai_faktur_baru numeric 0 √ null
id_salesman int4 10 null
pegawai.id customer_id_salesman_pegawai_id_fk R
id_kolektor int4 10 null
pegawai.id customer_id_kolektor_pegawai_id_fk R
no_npwp_16_digit varchar 2147483647 √ null
is_npwp_16_digit bool 1 √ false
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
province_id bpchar 12 √ null
regency_id bpchar 12 √ null
district_id bpchar 12 √ null
village_id bpchar 12 √ null
map text 2147483647 √ null
nomor_bank_garansi varchar 2147483647 √ null
nilai_bank_garansi numeric 0 √ null
masa_berlaku_bank_garansi date 13 √ null
file_bank_garansi varchar 2147483647 √ null
nomor_kontrak_kerja_sama varchar 2147483647 √ null
masa_berlaku_kontrak_kerja_sama date 13 √ null
file_kontrak_kerja_sama varchar 2147483647 √ null
id_divisi_sales int4 10 √ null
divisi_sales.id customer_id_divisi_sales_divisi_sales_id_fk R
is_tender bool 1 √ false
is_surat_pesanan bool 1 √ false
file_data varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
customer_pkey Primary key Asc id
customer_index Performance Asc id_divisi_sales
customer_inisial_unique Must be unique Asc inisial

Relationships

Close relationships within degrees of separation