stg_dsf_annual

-1 rows


Description

Table de staging des déclarations statistiques et fiscales (DSF) annuelles ITAS. Elle représente la situation économique et fiscale annuelle déclarée par les contribuables, incluant les revenus, achats, exportations, TVA, résultat fiscal, IS/IR, informations d’activité, régime fiscal et données administratives associées.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
staging_id bigserial 19 √ nextval('staging.stg_dsf_annual_staging_id_seq'::regclass)
declaration_year int4 10 √ null
taxpayer_nif varchar 255 √ null
taxpayer_name varchar 255 √ null
legal_form varchar 255 √ null
capital_amount numeric 38,2 √ null
declared_revenue numeric 38,2 √ null
foreign_purchases numeric 38,2 √ null
local_purchases numeric 38,2 √ null
total_purchases numeric 38,2 √ null
export_sales numeric 38,2 √ null
vat_collected numeric 38,2 √ null
vat_import_deducted numeric 38,2 √ null
net_vat numeric 38,2 √ null
taxable_result numeric 38,2 √ null
income_tax_declared numeric 38,2 √ null
activity_label varchar 255 √ null
tax_regime varchar 255 √ null
managing_service varchar 255 √ null
city varchar 255 √ null
primary_bank varchar 255 √ null
accounting_firm varchar 255 √ null
dsf_status varchar 255 √ null
submission_date date 13 √ null
source_id int8 19 √ null
import_batch_id uuid 2147483647 null
import_batch.batch_id Implied Constraint R
source_system varchar 255 √ null
source_table varchar 255 √ null
row_hash varchar 255 √ null
quality_score numeric 38,2 √ null
validation_status varchar 255 √ 'PENDING'::character varying
error_message varchar 255 √ null
created_at timestamp 29,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
stg_dsf_annual_pkey Primary key Asc staging_id

Relationships

Close relationships within degrees of separation