Table core.income_tax_setup
Tax setup.
# Column Name Nullable Data Type Max Length Description
1income_tax_setup_idinteger0The primary key of this table, which is also a serial field.
2office_idinteger0
3effective_fromdate0The effective date of the tax rate.
4tax_ratedecimal_strict20The tax rate applicable.
5tax_authority_idinteger0
6audit_user_idinteger0Contains the id of the user who last inserted or updated the corresponding row.
7audit_tstimestamp with time zone0Contains the date and timestamp of the last insert or update action.

Foreign Keys

# Column Name Key Name References
2 office_id income_tax_setup_office_id_fkey office.offices.office_id
5 tax_authority_id income_tax_setup_tax_authority_id_fkey core.tax_authorities.tax_authority_id
6 audit_user_id income_tax_setup_audit_user_id_fkey office.users.user_id

Indices

Index Name Owner Access Method Definition Description
income_tax_setup_pkey postgres btree income_tax_setup_id
income_tax_setup_office_id_inx postgres btree office_id

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 income_tax_setup_id nextval('core.income_tax_setup_income_tax_setup_id_seq'::regclass)
7 audit_ts now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description