supervision_finance.ledger

table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
line	integer		YES
finance_client_id	integer		YES
parent_id	integer		YES
fee_reduction_id	integer		YES
confirmeddate	date		YES
bankdate	date		YES
batchnumber	integer		YES
id	integer		NO
datetime	timestamp without time zone		NO
amount	integer		NO
reference	character varying	50	NO
bankaccount	character varying	255	YES	NULL::character varying
method	character varying	255	NO
source	character varying	20	YES	NULL::character varying
notes	text		YES
type	character varying	255	NO
status	character varying	255	NO	NULL::character varying