nota_retur_pajak

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('nota_retur_pajak_id_seq'::regclass)
nota_retur_pajak_detail.id nota_retur_pajak_detail_id_nota_retur_pajak_id_fk R
id_supplier int4 10 null
supplier.id nota_retur_pajak_id_supplier_supplier_id_fk R
id_retur_pembelian int4 10 null
retur_pembelian.id nota_retur_pajak_id_retur_pembelian_retur_pembelian_id_fk R
id_bukti_barang_masuk int4 10 null
bukti_barang_masuk.id nota_retur_pajak_id_bukti_barang_masuk_bukti_barang_masuk_id_fk R
npwp_supplier varchar 2147483647 null
alamat_supplier varchar 2147483647 null
nomor varchar 50 null
tanggal date 13 null
nomor_seri_pajak varchar 50 √ null
tanggal_seri_pajak date 13 √ null
status bpchar 1 null
catatan text 2147483647 √ null
subtotal numeric 20,3 null
total_diskon numeric 20,3 null
dpp numeric 20,3 null
total_ppn numeric 20,3 null
grandtotal numeric 20,3 null
created_by int4 10 null
pegawai.id nota_retur_pajak_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id nota_retur_pajak_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

Indexes

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

Relationships

Close relationships within degrees of separation