MIXERP-Table core.cash_flow_headings

#	Column Name	Nullable	Data Type	Max Length	Description
1	cash_flow_heading_id		integer	0	The primary key of this table, which is also a serial field.
2	cash_flow_heading_code		character varying	12	The code given to the Cash Flow heading.
3	cash_flow_heading_name		character varying	100	The name of the Cash Flow heading, which is also a unique field,
4	cash_flow_heading_type		character	1	A single character assigned to Cash Flow heading, which define its type.
5	is_debit		boolean	0
6	is_sales		boolean	0
7	is_purchase		boolean	0
8	audit_user_id		integer	0
9	audit_ts		timestamp with time zone	0

Foreign Keys

#	Column Name	Key Name	References
8	audit_user_id	cash_flow_headings_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
cash_flow_headings_pkey	postgres	btree	cash_flow_heading_id
cash_flow_headings_cash_flow_heading_name_uix	postgres	btree	upper(cash_flow_heading_code::text)
cash_flow_headings_cash_flow_heading_code_uix	postgres	btree	upper(cash_flow_heading_code::text)

Check Constraints

Constraint Name	Description
cash_flow_heading_cash_flow_heading_type_chk CHECK (cash_flow_heading_type = ANY (ARRAY['O'::bpchar, 'I'::bpchar, 'F'::bpchar]))

Default Values

#	Column Name	Default
5	is_debit	false
6	is_sales	false
7	is_purchase	false
9	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description