supplier

134 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('supplier_id_seq'::regclass)
acc_ap_faktur.id_supplier acc_ap_faktur_id_supplier_supplier_id_fk R
ap_value.id_supplier ap_value_id_supplier_supplier_id_fk R
barang_dekat_ed.id_supplier barang_dekat_ed_id_supplier_supplier_id_fk R
barang_supplier.id_supplier barang_supplier_id_supplier_supplier_id_fk R
bukti_barang_masuk.id_supplier bukti_barang_masuk_id_supplier_supplier_id_fk R
klaim_diskon_3.id_supplier klaim_diskon_3_id_supplier_supplier_id_fk R
nota_retur_pajak.id_supplier nota_retur_pajak_id_supplier_supplier_id_fk R
payment_ap.id_supplier payment_ap_id_supplier_supplier_id_fk R
penawaran_tender_detail.id_supplier penawaran_tender_detail_id_supplier_supplier_id_fk R
penerimaan_barang.id_supplier penerimaan_barang_id_supplier_supplier_id_fk R
permintaan_penawaran.id_supplier permintaan_penawaran_id_supplier_supplier_id_fk R
retur_pembelian.id_supplier retur_pembelian_id_supplier_supplier_id_fk R
stok_awal_barang.id_supplier stok_awal_barang_id_supplier_supplier_id_fk R
stok_barang.id_supplier stok_barang_id_supplier_supplier_id_fk R
supplier_bank.id supplier_bank_id_supplier_id_fk R
supplier_kontak.id supplier_kontak_id_supplier_id_fk R
supplier_legalitas.id supplier_legalitas_id_supplier_id_fk R
surat_pesanan.id_supplier surat_pesanan_id_supplier_supplier_id_fk R
id_type_supplier int4 10 √ null
type_supplier.id supplier_id_type_supplier_type_supplier_id_fk R
id_group_supplier int4 10 √ null
group_supplier.id supplier_id_group_supplier_group_supplier_id_fk R
id_location_supplier int4 10 √ null
location_supplier.id supplier_id_location_supplier_location_supplier_id_fk R
registration_date date 13 √ null
code varchar 20 null
e_report_code varchar 20 √ null
inisial varchar 5 √ null
name varchar 100 √ null
city varchar 50 √ null
address text 2147483647 √ null
email varchar 50 √ null
phone_number varchar 20 √ null
npwp_number varchar 30 √ null
npwp_file varchar 2147483647 √ null
pkp_name varchar 100 √ null
npwp_address text 2147483647 √ null
notes text 2147483647 √ null
stempel varchar 255 √ null
top int4 10 √ null
tax_invoice_capability bool 1 √ null
tax_invoice_delivery varchar 20 √ null
expedition_cost int4 10 √ null
outstanding_debt int4 10 √ null
status bool 1 √ null
verification_status bool 1 √ null
created_by int4 10 null
pegawai.id supplier_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id supplier_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
id_biaya_expedisi int4 10 null
biaya_expedisi.id supplier_id_biaya_expedisi_biaya_expedisi_id_fk R
telephone_number varchar 20 √ null
purchase_limit numeric 0 √ null
id_regency bpchar 4 √ null
reg_regencies.id supplier_id_regency_reg_regencies_id_fk R
regency varchar 50 √ null
id_province bpchar 2 √ null
reg_provinces.id supplier_id_province_reg_provinces_id_fk R
province varchar 50 √ null
npwp_number_16_digits varchar 2147483647 √ null
is_npwp_16_digits bool 1 √ false
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
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
is_ppn bool 1 √ false
is_pph bool 1 √ false
is_materai bool 1 √ false
is_faktur_pajak bool 1 √ false
province_id bpchar 12 √ null
regency_id bpchar 12 √ null
district_id bpchar 12 √ null
village_id bpchar 12 √ null

Indexes

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

Relationships

Close relationships within degrees of separation