All Tables of MIXERP

#	Schema Name	Table Name	Owner	Tablespace	Description
1	audit	failed_logins	postgres	DEFAULT
2	audit	logged_actions	postgres	DEFAULT
3	audit	logins	postgres	DEFAULT
4	core	account_masters	postgres	DEFAULT	This table contains categories in which General Ledger (G.L) Account belongs to & collectively they form the Chart of Accounts. The category in this table cannot be edited by users. Thus, a user-interface for this table is not available. This table facilitates creating useful reports such as Profit & Loss A/c. and Balance Sheet.
5	core	accounts	postgres	DEFAULT	This table stores information on General Ledger (G.L) Account.
6	core	ageing_slabs	postgres	DEFAULT
7	core	attachment_lookup	postgres	DEFAULT
8	core	attachments	postgres	DEFAULT
9	core	bank_accounts	postgres	DEFAULT	This table stores information on various Bank A/cs and other associated information.
10	core	bonus_slab_details	postgres	DEFAULT	This table stores information on various rate of bonus.
11	core	bonus_slabs	postgres	DEFAULT	This table stores information on bonus slabs.
12	core	brands	postgres	DEFAULT	This table stores information on various brands the entity is dealing.
13	core	cash_flow_headings	postgres	DEFAULT	This table stores information on various categories in the Cash Flow Statement.
14	core	cash_flow_setup	postgres	DEFAULT
15	core	compound_item_details	postgres	DEFAULT	This table stores information on compound item and combination of items which composites compound item.
16	core	compound_items	postgres	DEFAULT	This table stores information on combination on compund items and other associated information to it.
17	core	compound_units	postgres	DEFAULT	This table stores information on the units, value of the items that forms the compound items.
18	core	config	postgres	DEFAULT
19	core	counties	postgres	DEFAULT	This table stores information on counties, their code, the state they belong etc.
20	core	countries	postgres	DEFAULT	This table stores information on list of countries and their their code.
21	core	county_sales_taxes	postgres	DEFAULT	This table stores information on sales tax of the county.
22	core	currencies	postgres	DEFAULT	This table stores information on currency.
23	core	entities	postgres	DEFAULT	List of entities.
24	core	exchange_rate_details	postgres	DEFAULT	Details on exchange rate.
25	core	exchange_rates	postgres	DEFAULT	Update exchange rates.
26	core	fiscal_year	postgres	DEFAULT	Information on fiscal year.
27	core	flag_types	postgres	DEFAULT	Mark rows of a table with difernt color, so that viewing is easier.
28	core	flags	postgres	DEFAULT	Flags are used by users to mark transactions. The flags created by a user is not visible to others.
29	core	frequencies	postgres	DEFAULT	Interval of time for posting a transaction.
30	core	frequency_setups	postgres	DEFAULT	Setup time interval of posting a transaction automatically.
31	core	income_tax_setup	postgres	DEFAULT	Tax setup.
32	core	industries	postgres	DEFAULT	Details on industry the firm belongs.
33	core	item_cost_prices	postgres	DEFAULT	This table stores information on cost price of a item and other associated informations.
34	core	item_groups	postgres	DEFAULT
35	core	item_opening_inventory	postgres	DEFAULT	This table stores information on opening inventory and other associated information.
36	core	item_selling_prices	postgres	DEFAULT	This table stores information on selling price of an item and other information. PLEASE NOTE : THESE ARE THE MOST EFFECTIVE STOCK ITEM PRICES. THE PRICE IN THIS CATALOG IS ACTUALLY PICKED UP AT THE TIME OF PURCHASE AND SALES. A STOCK ITEM PRICE MAY BE DIFFERENT FOR DIFFERENT UNITS. FURTHER, A STOCK ITEM WOULD BE SOLD AT A HIGHER PRICE WHEN SOLD LOOSE THAN WHAT IT WOULD ACTUALLY COST IN A COMPOUND UNIT. EXAMPLE, ONE CARTOON (20 BOTTLES) OF BEER BOUGHT AS A UNIT WOULD COST 25% LESS FROM THE SAME STORE.
37	core	item_types	postgres	DEFAULT
38	core	items	postgres	DEFAULT	This table stores information on items and other associated information.
39	core	late_fee	postgres	DEFAULT	This table stores information on late fees and other associated information.
40	core	menu_locale	postgres	DEFAULT
41	core	menus	postgres	DEFAULT	This table stores information on the easy to use menu of MixERP.
42	core	parties	postgres	DEFAULT	This table stores information on parties and information associated with them.
43	core	party_types	postgres	DEFAULT	This table stores information on types of parties and other infornation associated with it like weather a party is Agent/Customer/Dealer/Supplier..
44	core	payment_terms	postgres	DEFAULT	This table stores information on terms of payment like due date, grace period and information associated with it.
45	core	price_types	postgres	DEFAULT
46	core	recurring_invoice_setup	postgres	DEFAULT
47	core	recurring_invoices	postgres	DEFAULT
48	core	rounding_methods	postgres	DEFAULT	This table stores information on rounding off the amount.
49	core	sales_tax_details	postgres	DEFAULT	This table stores information on sales tax and other information associated with it.
50	core	sales_tax_exempt_details	postgres	DEFAULT	This table stores information on sales tax exemption and other information associated with it.
51	core	sales_tax_exempts	postgres	DEFAULT	This table stores information on sales tax exemption and other information associated with it.
52	core	sales_tax_types	postgres	DEFAULT	Type of sales tax and information associated with it.
53	core	sales_taxes	postgres	DEFAULT	Details on sales tax.
54	core	sales_teams	postgres	DEFAULT	Details on sales team.
55	core	salesperson_bonus_setups	postgres	DEFAULT	Setup bonuses to salespersons.
56	core	salespersons	postgres	DEFAULT	Details on sales person and other information associated with it.
57	core	shippers	postgres	DEFAULT	Details on shippers (shipping company) and other information associated with it.
58	core	shipping_addresses	postgres	DEFAULT	Details on shipping address and other information associated with it.
59	core	shipping_mail_types	postgres	DEFAULT	Details on shipping mail type (Express, priority mail, parcel post etc.).
60	core	shipping_package_shapes	postgres	DEFAULT	Details on shipping package and other information assiciated with it.
61	core	state_sales_taxes	postgres	DEFAULT	Details on sales tax of the state in the U.S.A and other information associated with it.
62	core	states	postgres	DEFAULT	Information on the states of the U.S.A.
63	core	tax_authorities	postgres	DEFAULT	Details on tax authorities, its address and other information associated with it.
64	core	tax_base_amount_types	postgres	DEFAULT	Information on various tax base that are applicable.
65	core	tax_exempt_types	postgres	DEFAULT	Various kinds of tax exemptions that are applicable.
66	core	tax_master	postgres	DEFAULT	Information on the applicable tax rates of various countries (tax master)supported by the software.
67	core	tax_rate_types	postgres	DEFAULT	The code and the name given to various types tax rates (flat rate or percentage basis).
68	core	transaction_types	postgres	DEFAULT
69	core	units	postgres	DEFAULT	Contains units of measure.
70	core	verification_statuses	postgres	DEFAULT	Verification statuses are integer values used to represent the state of a transaction. For example, a verification status of value "0" would mean that the transaction has not yet been verified. A negative value indicates that the transaction was rejected, whereas a positive value means approved. Remember: 1. Only approved transactions appear on ledgers and final reports. 2. Cash repository balance is maintained on the basis of LIFO principle. This means that cash balance is affected (reduced) on your repository as soon as a credit transaction is posted, without the transaction being approved on the first place. If you reject the transaction, the cash balance then increases. This also means that the cash balance is not affected (increased) on your repository as soon as a debit transaction is posted. You will need to approve the transaction. It should however be noted that the cash repository balance might be less than the total cash shown on your balance sheet, if you have pending transactions to verify. You cannot perform EOD operation if you have pending verifications.
71	core	zip_code_types	postgres	DEFAULT	Types of ZIP code.
72	core	zip_codes	postgres	DEFAULT	This table stores information on the ZIP code.
73	crm	lead_sources	postgres	DEFAULT
74	crm	lead_statuses	postgres	DEFAULT
75	crm	opportunity_stages	postgres	DEFAULT
76	localization	cultures	postgres	DEFAULT
77	localization	localized_resources	postgres	DEFAULT
78	localization	resources	postgres	DEFAULT
79	office	cash_repositories	postgres	DEFAULT	This table stores information related to cash repositories.
80	office	cashiers	postgres	DEFAULT	This table stores information related to cashier.
81	office	configuration	postgres	DEFAULT
82	office	cost_centers	postgres	DEFAULT
83	office	counters	postgres	DEFAULT
84	office	departments	postgres	DEFAULT	This table stores information on lists of deparments and other associated information.
85	office	offices	postgres	DEFAULT	This table stores information on various braches of the entity.
86	office	roles	postgres	DEFAULT
87	office	store_types	postgres	DEFAULT
88	office	stores	postgres	DEFAULT
89	office	users	postgres	DEFAULT	The users table contains users accounts and their login information. It also contains a sys user account which does not have a password. The sys user account is a special account used by the MixERP workflow to perform routine tasks. The sys user cannot have a valid password or cannot be allowed to log in interactively.
90	office	work_centers	postgres	DEFAULT
91	policy	auto_verification_policy	postgres	DEFAULT
92	policy	lock_outs	postgres	DEFAULT
93	policy	menu_access	postgres	DEFAULT
94	policy	menu_policy	postgres	DEFAULT
95	policy	store_policies	postgres	DEFAULT	STORE POLICY DEFINES THE RIGHT OF USERS TO ACCESS A STORE. AN ADMINISTRATOR CAN ACCESS ALL THE stores, BY DEFAULT.
96	policy	store_policy_details	postgres	DEFAULT
97	policy	voucher_verification_policy	postgres	DEFAULT
98	transactions	customer_receipts	postgres	DEFAULT	This table stores information on receipts from customers.
99	transactions	day_operation	postgres	DEFAULT	This table stores information on the transaction, date & time of its occurance.
100	transactions	day_operation_routines	postgres	DEFAULT
101	transactions	non_gl_stock_details	postgres	DEFAULT
102	transactions	non_gl_stock_master	postgres	DEFAULT	This table stores information of quotations which were upgraded to order(s).
103	transactions	non_gl_stock_master_relations	postgres	DEFAULT
104	transactions	non_gl_stock_tax_details	postgres	DEFAULT
105	transactions	routines	postgres	DEFAULT
106	transactions	stock_details	postgres	DEFAULT
107	transactions	stock_master	postgres	DEFAULT
108	transactions	stock_master_non_gl_relations	postgres	DEFAULT	This table stores information of Non GL Stock Transactions such as orders and quotations which were upgraded to deliveries or invoices.
109	transactions	stock_return	postgres	DEFAULT
110	transactions	stock_tax_details	postgres	DEFAULT
111	transactions	transaction_details	postgres	DEFAULT
112	transactions	transaction_master	postgres	DEFAULT
113	unit_tests	test_details	postgres	DEFAULT
114	unit_tests	tests	postgres	DEFAULT