Direct Debits (including Fraud Data) - PDD

European Central Bank

@ecb.direct_debits_including_fraud_data_pdd

Table List

1 table(782.02 KB)

Table 1

@ecb.direct_debits_including_fraud_data_pdd.table_1

782.02 KB
77470 rows
31 columns

key KEY	freq FREQ	ref_area REF AREA	count_area COUNT AREA	rl_trnsctn RL TRNSCTN	inttn_chnnl INTTN CHNNL	pymnt_schm PYMNT SCHM	chnnl_cnsnt CHNNL CNSNT	frd_typ FRD TYP	transformation TRANSFORMATION	unit_measure UNIT MEASURE	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	time_per_collect TIME PER COLLECT	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
PDD.A.AT.BE.1._T.DDS_ALL._T._Z.N.EUR	A	AT	BE	1	_T	DDS_ALL	_T	_Z	N	EUR	2022	1770.72458345	A	F	P1Y	S	3	Value of direct debits , received - all, from: Belgium to: Austria	Value of direct debits , received - all, from: Belgium to: Austria	EUR	6
PDD.A.AT.BE.1._T.DDS_ALL._T._Z.N.EUR	A	AT	BE	1	_T	DDS_ALL	_T	_Z	N	EUR	2023	1636.23566043	A	F	P1Y	S	3	Value of direct debits , received - all, from: Belgium to: Austria	Value of direct debits , received - all, from: Belgium to: Austria	EUR	6
PDD.A.AT.BE.1._T.DDS_ALL._T._Z.N.PN	A	AT	BE	1	_T	DDS_ALL	_T	_Z	N	PN	2022	0.359162	A	F	P1Y	S	3	Number of direct debits , received - all, from: Belgium to: Austria	Number of direct debits , received - all, from: Belgium to: Austria	PN	6
PDD.A.AT.BE.1._T.DDS_ALL._T._Z.N.PN	A	AT	BE	1	_T	DDS_ALL	_T	_Z	N	PN	2023	0.421806	A	F	P1Y	S	3	Number of direct debits , received - all, from: Belgium to: Austria	Number of direct debits , received - all, from: Belgium to: Austria	PN	6
PDD.A.AT.BE.2.2100.DDS_ALL._T._Z.N.EUR	A	AT	BE	2	2100	DDS_ALL	_T	_Z	N	EUR	2022	50.5562515	A	F	P1Y	S	3	Value of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	Value of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	EUR	6
PDD.A.AT.BE.2.2100.DDS_ALL._T._Z.N.EUR	A	AT	BE	2	2100	DDS_ALL	_T	_Z	N	EUR	2023	60.868487130000005	A	F	P1Y	S	3	Value of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	Value of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	EUR	6
PDD.A.AT.BE.2.2100.DDS_ALL._T._Z.N.PN	A	AT	BE	2	2100	DDS_ALL	_T	_Z	N	PN	2022	0.042288	A	F	P1Y	S	3	Number of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	Number of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	PN	6
PDD.A.AT.BE.2.2100.DDS_ALL._T._Z.N.PN	A	AT	BE	2	2100	DDS_ALL	_T	_Z	N	PN	2023	0.054806	A	F	P1Y	S	3	Number of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	Number of direct debits initiated in a file/batch, sent - from: Austria to: Belgium	PN	6
PDD.A.AT.BE.2.2200.DDS_ALL._T._Z.N.EUR	A	AT	BE	2	2200	DDS_ALL	_T	_Z	N	EUR	2022	1.95580212	A	F	P1Y	S	3	Value of direct debits initiated on a single payment basis, sent - from: Austria to: Belgium	Value of direct debits initiated on a single payment basis, sent - from: Austria to: Belgium	EUR	6
PDD.A.AT.BE.2.2200.DDS_ALL._T._Z.N.EUR	A	AT	BE	2	2200	DDS_ALL	_T	_Z	N	EUR	2023	4.98217499	A	F	P1Y	S	3	Value of direct debits initiated on a single payment basis, sent - from: Austria to: Belgium	Value of direct debits initiated on a single payment basis, sent - from: Austria to: Belgium	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "count_area" VARCHAR,
  "rl_trnsctn" BIGINT,
  "inttn_chnnl" VARCHAR,
  "pymnt_schm" VARCHAR,
  "chnnl_cnsnt" VARCHAR,
  "frd_typ" VARCHAR,
  "transformation" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "time_per_collect" VARCHAR,
  "coverage" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "method_ref" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);