MIXERP-Table core.parties

#	Column Name	Data Type	Max Length	Description
1	party_id	bigint	0	The primary key of this table, which is also a serial field.
2	party_type_id	integer	0	Foreign key to the table core.party_types.
3	party_code	character varying	12	Code given to the party.
4	first_name	character varying	50	First name of the party.
5	middle_name	character varying	50	Middle name of the party.
6	last_name	character varying	50	Family name of the party.
7	party_name	text	0	Full-name of the party.
8	date_of_birth	date	0	Date of birth of the party.
9	entity_id	integer	0	Foreign key to the table core.entities.
10	industry_id	integer	0	Foreign key to the table core.industries.
11	country_id	integer	0	Foreign key to the table core.countries.
12	state_id	integer	0	Foreign key to the table core.states.
13	zip_code	character varying	12	Zip code of the party.
14	address_line_1	character varying	128	The address of the party.
15	address_line_2	character varying	128	The address of the party.
16	street	character varying	50	The street name where the party is located.
17	city	character varying	50	The city name where the party is located.
18	phone	character varying	24	The phone number of the party.
19	fax	character varying	24	The fax number of the party.
20	cell	character varying	24	Cell-phone number of the party.
21	email	character varying	128	E-mail address of the party.
22	url	character varying	50	Web address of the party.
23	pan_number	character varying	50	Permanent Address Number of the party.
24	sst_number	character varying	50
25	cst_number	character varying	50
26	currency_code	character varying	12	Foreign key to the table core.currencies.
27	allow_credit	boolean	0	Select "Yes" if you want to allow credit to the party.
28	maximum_credit_period	smallint	0	Maximum credit period
29	maximum_credit_amount	money_strict2	0
30	account_id	bigint	0	Foreign key to the table core.accounts.
31	audit_user_id	integer	0	Contains the id of the user who last inserted or updated the corresponding row.
32	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	party_type_id	parties_party_type_id_fkey	core.party_types.party_type_id
9	entity_id	parties_entity_id_fkey	core.entities.entity_id
10	industry_id	parties_industry_id_fkey	core.industries.industry_id
11	country_id	parties_country_id_fkey	core.countries.country_id
12	state_id	parties_state_id_fkey	core.states.state_id
26	currency_code	parties_currency_code_fkey	core.currencies.currency_code
30	account_id	parties_account_id_fkey	core.accounts.account_id
31	audit_user_id	parties_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
parties_pkey	postgres	btree	party_id
parties_party_code_uix	postgres	btree	upper(party_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	party_id	nextval('core.parties_party_id_seq'::regclass)
32	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
core.party_after_insert_trigger	core.party_after_insert_trigger	INSERT	AFTER		0	ROW
core.party_before_update_trigger	core.party_before_update_trigger	UPDATE	BEFORE		0	ROW