MIXERP-Table core.sales_tax

#	Column Name	Data Type	Max Length	Description
1	sales_tax_detail_id	integer	0
2	sales_tax_id	integer	0
3	sales_tax_type_id	integer	0
4	priority	smallint	0
5	sales_tax_detail_code	character varying	24
6	sales_tax_detail_name	character varying	50
7	based_on_shipping_address	boolean	0
8	check_nexus	boolean	0
9	applied_on_shipping_charge	boolean	0
10	state_sales_tax_id	integer	0
11	county_sales_tax_id	integer	0
12	tax_rate_type_code	character varying	12
13	rate	decimal_strict2	0
14	reporting_tax_authority_id	integer	0
15	collecting_tax_authority_id	integer	0
16	collecting_account_id	bigint	0
17	use_tax_collecting_account_id	bigint	0
18	rounding_method_code	character varying	4
19	rounding_decimal_places	integer_strict2	0
20	audit_user_id	integer	0	Contains the id of the user who last inserted or updated the corresponding row.
21	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	sales_tax_id	sales_tax_details_sales_tax_id_fkey	core.sales_taxes.sales_tax_id
3	sales_tax_type_id	sales_tax_details_sales_tax_type_id_fkey	core.sales_tax_types.sales_tax_type_id
10	state_sales_tax_id	sales_tax_details_state_sales_tax_id_fkey	core.state_sales_taxes.state_sales_tax_id
11	county_sales_tax_id	sales_tax_details_county_sales_tax_id_fkey	core.county_sales_taxes.county_sales_tax_id
12	tax_rate_type_code	sales_tax_details_tax_rate_type_code_fkey	core.tax_rate_types.tax_rate_type_code
14	reporting_tax_authority_id	sales_tax_details_reporting_tax_authority_id_fkey	core.tax_authorities.tax_authority_id
15	collecting_tax_authority_id	sales_tax_details_collecting_tax_authority_id_fkey	core.tax_authorities.tax_authority_id
16	collecting_account_id	sales_tax_details_collecting_account_id_fkey	core.accounts.account_id
17	use_tax_collecting_account_id	sales_tax_details_use_tax_collecting_account_id_fkey	core.accounts.account_id
18	rounding_method_code	sales_tax_details_rounding_method_code_fkey	core.rounding_methods.rounding_method_code
20	audit_user_id	sales_tax_details_audit_user_id_fkey	office.users.user_id

Index Name	Owner	Access Method	Definition
sales_tax_details_pkey	postgres	btree	sales_tax_detail_id
sales_tax_details_sales_tax_detail_name_uix	postgres	btree	upper(sales_tax_detail_name::text)
sales_tax_details_sales_tax_detail_code_uix	postgres	btree	upper(sales_tax_detail_code::text)

Constraint Name	Description
sales_tax_details_rate_chk CHECK ( CASE WHEN state_sales_tax_id IS NOT NULL OR county_sales_tax_id IS NOT NULL THEN rate::numeric = 0::numeric ELSE rate::numeric > 0::numeric END)

#	Column Name	Default
1	sales_tax_detail_id	nextval('core.sales_tax_details_sales_tax_detail_id_seq'::regclass)
4	priority	0
7	based_on_shipping_address	true
8	check_nexus	true
9	applied_on_shipping_charge	true
12	tax_rate_type_code	'P'::character varying
19	rounding_decimal_places	2
21	audit_ts	now()

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description