faktur_pajak_pembelian

1526 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('faktur_pajak_pembelian_id_seq'::regclass)
nomor_seri_faktur_pajak varchar 30 null
tanggal_faktur_pajak date 13 now()
id_bukti_barang_masuk int4 10 null
bukti_barang_masuk.id faktur_pajak_pembelian_id_bukti_barang_masuk_bukti_barang_masuk R
tanggal_terima_invoice date 13 null
is_verified bool 1 false
tanggal_verified timestamp 29,6 √ null
nomor_h1_pph_22 varchar 2147483647 √ null
masa_pajak_b1_pph_22 date 13 √ null
id_verified int4 10 √ null
pegawai.id faktur_pajak_pembelian_id_verified_pegawai_id_fk R
created_by int4 10 null
pegawai.id faktur_pajak_pembelian_created_by_pegawai_id_fk R
updated_by int4 10 null
pegawai.id faktur_pajak_pembelian_updated_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
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)
faktur_pajak_pembelian_id_id_bukti_barang_masuk_pk Primary key Asc/Asc id + id_bukti_barang_masuk
faktur_pajak_pembelian_id_bukti_barang_masuk_unique Must be unique Asc id_bukti_barang_masuk

Relationships

Close relationships within degrees of separation