MIXERP-Table core.tax_authorities

#	Column Name	Nullable	Data Type	Max Length	Description
1	tax_authority_id		integer	0	The primary key of the table.
2	tax_master_id		integer	0	Foreign key to the table core.tax_master.
3	tax_authority_code		character varying	12	The code given to the tax authority.
4	tax_authority_name		character varying	100	The name of the tax authority, which is a unique field.
5	country_id		integer	0	Foreign key to the table core.countries.
6	state_id		integer	0	Foreign key to the table core.states.
7	zip_code		character varying	12	ZIP code of the tax office.
8	address_line_1		character varying	128	Address 1.
9	address_line_2		character varying	128	Address 2.
10	street		character varying	50	Street address.
11	city		character varying	50	Name of the city.
12	phone		character varying	100	Phone number of the tax office.
13	fax		character varying	24	Fax number of the tax office.
14	cell		character varying	24	Cell phone number of the tax office.
15	email		character varying	128	E-mail address of the tax office.
16	url		character varying	50	Web address of the tax office.
17	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
18	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
2	tax_master_id	tax_authorities_tax_master_id_fkey	core.tax_master.tax_master_id
5	country_id	tax_authorities_country_id_fkey	core.countries.country_id
6	state_id	tax_authorities_state_id_fkey	core.states.state_id
17	audit_user_id	tax_authorities_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
tax_authorities_pkey	postgres	btree	tax_authority_id
tax_authorities_tax_authority_name_uix	postgres	btree	upper(tax_authority_name::text)
tax_authorities_tax_authority_code_uix	postgres	btree	upper(tax_authority_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	tax_authority_id	nextval('core.tax_authorities_tax_authority_id_seq'::regclass)
18	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description