invoice_retur

665 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('invoice_retur_id_seq'::regclass)
invoice_retur_detail.id invoice_retur_detail_id_invoice_retur_id_fk R
invoice_retur_persetujuan.id invoice_retur_persetujuan_id_invoice_retur_id_fk R
id_invoice int4 10 √ null
invoice.id invoice_retur_id_invoice_invoice_id_fk R
nomor varchar 2147483647 null
tanggal date 13 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
catatan text 2147483647 null
status bpchar 1 null
created_by int4 10 null
pegawai.id invoice_retur_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id invoice_retur_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
id_pengajuan_retur_penjualan int4 10 null
pengajuan_retur_penjualan.id invoice_retur_id_pengajuan_retur_penjualan_pengajuan_retur_penj R
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
persen_ppn numeric 0 '0'::numeric
persen_pph_22 numeric 0 '0'::numeric
id_gudang int4 10 √ null
gudang.id invoice_retur_id_gudang_gudang_id_fk R
id_rak_barang int4 10 √ null
rak_barang.id invoice_retur_id_rak_barang_rak_barang_id_fk R
invoice_number varchar 50 √ null
acc_ar_faktur.invoice_number Implied Constraint R
id_ppn int4 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation