MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types
Table core.sales_tax_exempts
This table stores information on sales tax exemption and other information associated with it.
# Column Name Nullable Data Type Max Length Description
1sales_tax_exempt_idinteger0The primary key of the table, which is also a serial field.
2tax_master_idinteger0Foreign key to the table core.tax_master.
3sales_tax_exempt_codecharacter varying12Sakes tax exemption code.
4sales_tax_exempt_namecharacter varying100The name given to the sales tax exemption.
5tax_exempt_type_idinteger0Foreign key to the table core.tax_exempt_types.
6store_idinteger0Foreign key to the table office.stores.
7sales_tax_idinteger0Foreign key to the table core.sales_taxes.
8valid_fromdate0The effective date of the sales exemption cstegory.
9valid_tilldate0The last date of the sales exemption category.
10price_frommoney_strict20The minimum sales amount required to fall into the sales exemption category.
11price_tomoney_strict20The maximum sales amount that falls into the sales exemption category.
12audit_user_idinteger0Contains the id of the user who last inserted or updated the corresponding row.
13audit_tstimestamp with time zone0Contains the date and timestamp of the last insert or update action.

Foreign Keys

# Column Name Key Name References
2 tax_master_id sales_tax_exempts_tax_master_id_fkey core.tax_master.tax_master_id
5 tax_exempt_type_id sales_tax_exempts_tax_exempt_type_id_fkey core.tax_exempt_types.tax_exempt_type_id
6 store_id sales_tax_exempts_store_id_fkey office.stores.store_id
7 sales_tax_id sales_tax_exempts_sales_tax_id_fkey core.sales_taxes.sales_tax_id
12 audit_user_id sales_tax_exempts_audit_user_id_fkey office.users.user_id

Indices

Index Name Owner Access Method Definition Description
sales_tax_exempts_pkey postgres btree sales_tax_exempt_id
sales_tax_exempts_sales_tax_exempt_name_uix postgres btree upper(sales_tax_exempt_name::text)
sales_tax_exempts_sales_tax_exempt_code_uix postgres btree upper(sales_tax_exempt_code::text)

Check Constraints

Constraint Name Description
sales_tax_exempts_price_to_chk
CHECK (price_to::numeric >= price_from::numeric)
sales_tax_exempts_valid_till_chk
CHECK (valid_till >= valid_from)

Default Values

# Column Name Default
1 sales_tax_exempt_id nextval('core.sales_tax_exempts_sales_tax_exempt_id_seq'::regclass)
10 price_from 0
11 price_to 0
13 audit_ts now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description