All Functions of MIXERP

Functions

#	Function	Owner	Description
1	localization. add_localized_resource(text, text, text) RETURNS void	postgres
2	public. add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _admin_name character varying, _user_name character varying, _password character varying) RETURNS void	postgres
3	localization. add_resource(path text, key text, value text) RETURNS void	postgres
4	core. append_if_not_null(text, text) RETURNS text	postgres
5	assert. are_equal(VARIADIC anyarray, OUT message text, OUT result boolean) RETURNS record	postgres
6	assert. are_not_equal(VARIADIC anyarray, OUT message text, OUT result boolean) RETURNS record	postgres
7	transactions. are_sales_orders_already_merged(VARIADIC arr bigint[]) RETURNS boolean	postgres
8	transactions. are_sales_quotations_already_merged(VARIADIC arr bigint[]) RETURNS boolean	postgres
9	audit. audit_table(target_table regclass) RETURNS void	postgres	Add auditing support to the given table. Row-level changes will be logged with full client query text. No cols are ignored.
10	audit. audit_table(target_table regclass, audit_rows boolean, audit_query_text boolean, ignored_cols text[]) RETURNS void	postgres	Add auditing support to a table. Arguments: target_table: Table name, schema qualified if not on search_path audit_rows: Record each row change, or only audit at a statement level audit_query_text: Record the text of the client query that triggered the audit event? ignored_cols: Columns to exclude from update diffs, ignore updates that change only ignored cols.
11	audit. audit_table(target_table regclass, audit_rows boolean, audit_query_text boolean) RETURNS void	postgres
12	transactions. auto_verify(_tran_id bigint, _office_id integer) RETURNS void	postgres
13	unit_tests. auto_verify_journal_test1() RETURNS test_result	postgres
14	unit_tests. auto_verify_journal_test2() RETURNS test_result	postgres
15	unit_tests. auto_verify_purchase_test1() RETURNS test_result	postgres
16	unit_tests. auto_verify_purchase_test2() RETURNS test_result	postgres
17	unit_tests. auto_verify_sales_test1() RETURNS test_result	postgres
18	unit_tests. auto_verify_sales_test2() RETURNS test_result	postgres
19	unit_tests. begin(v integer DEFAULT 9) RETURNS TABLE(message text, result character)	postgres
20	core. calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer) RETURNS numeric	postgres
21	core. calculate_interest(principal numeric, rate numeric, days integer, round_up integer) RETURNS numeric	postgres
22	office. can_login(user_id integer_strict, office_id integer_strict, OUT result boolean, OUT message text) RETURNS record	postgres
23	policy. can_post_transaction(_login_id bigint, _user_id integer, _office_id integer, transaction_book text, _value_date date) RETURNS boolean	postgres
24	policy. change_password(_admin_user_id integer, _user_name text, _new_password text) RETURNS void	postgres
25	policy. change_password(_user_name text, _current_password text, _new_password text) RETURNS boolean	postgres
26	unit_tests. check_party_currency_code_mismatch() RETURNS test_result	postgres
27	unit_tests. check_party_null_account_id() RETURNS test_result	postgres
28	transactions. contains_incompatible_taxes(VARIADIC arr bigint[]) RETURNS boolean	postgres
29	core. convert_unit(from_unit integer, to_unit integer) RETURNS numeric	postgres
30	core. count_item_in_stock(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric	postgres
31	office. count_item_in_stock(item_id_ integer, unit_id_ integer, office_id_ integer) RETURNS numeric	postgres
32	core. count_purchases(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric	postgres
33	core. count_sales(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric	postgres
34	unit_tests. create_dummy_accounts() RETURNS void	postgres
35	unit_tests. create_dummy_auto_verification_policy(_user_id integer, _verify_sales_transactions boolean, _sales_verification_limit money_strict2, _verify_purchase_transactions boolean, _purchase_verification_limit money_strict2, _verify_gl_transactions boolean, _gl_verification_limit money_strict2, _effective_from date, _ends_on date, _is_active boolean) RETURNS void	postgres
36	unit_tests. create_dummy_brands() RETURNS void	postgres
37	unit_tests. create_dummy_cash_repositories() RETURNS void	postgres
38	unit_tests. create_dummy_cost_centers() RETURNS void	postgres
39	unit_tests. create_dummy_countries() RETURNS void	postgres
40	unit_tests. create_dummy_item_groups() RETURNS void	postgres
41	unit_tests. create_dummy_item_types() RETURNS void	postgres
42	unit_tests. create_dummy_items() RETURNS void	postgres
43	unit_tests. create_dummy_late_fees() RETURNS void	postgres
44	unit_tests. create_dummy_offices() RETURNS void	postgres
45	unit_tests. create_dummy_parties() RETURNS void	postgres
46	unit_tests. create_dummy_party_types() RETURNS void	postgres
47	unit_tests. create_dummy_payment_terms() RETURNS void	postgres
48	unit_tests. create_dummy_sales_taxes() RETURNS void	postgres
49	unit_tests. create_dummy_sales_teams() RETURNS void	postgres
50	unit_tests. create_dummy_salespersons() RETURNS void	postgres
51	unit_tests. create_dummy_shippers() RETURNS void	postgres
52	unit_tests. create_dummy_states() RETURNS void	postgres
53	unit_tests. create_dummy_store_types() RETURNS void	postgres
54	unit_tests. create_dummy_stores() RETURNS void	postgres
55	unit_tests. create_dummy_units() RETURNS void	postgres
56	unit_tests. create_dummy_users() RETURNS void	postgres
57	core. create_flag(user_id_ integer, flag_type_id_ integer, resource_ text, resource_key_ text, resource_id_ text) RETURNS void	postgres
58	unit_tests. create_mock() RETURNS void	postgres
59	transactions. create_routine(_routine_code character varying, _routine regproc, _order integer) RETURNS void	postgres
60	office. create_user(role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false) RETURNS void	postgres
61	public. explode_array(in_array anyarray) RETURNS SETOF anyelement	postgres
62	assert. fail(message text) RETURNS text	postgres
63	assert. function_exists(function_name text, OUT message text, OUT result boolean) RETURNS record	postgres
64	core. get_account_id_by_account_number(text) RETURNS bigint	postgres
65	core. get_account_id_by_party_code(party_code text) RETURNS bigint	postgres
66	core. get_account_id_by_party_id(party_id bigint) RETURNS bigint	postgres
67	core. get_account_id_by_party_type_id(_party_type_id integer) RETURNS integer	postgres
68	core. get_account_id_by_shipper_id(integer) RETURNS bigint	postgres
69	core. get_account_ids(root_account_id bigint) RETURNS SETOF bigint	postgres
70	core. get_account_master_id_by_account_id(bigint) RETURNS integer	postgres
71	core. get_account_master_id_by_account_master_code(text) RETURNS integer	postgres
72	core. get_account_name(bigint) RETURNS text	postgres
73	core. get_account_name_by_account_id(bigint) RETURNS text	postgres
74	transactions. get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id bigint, _office_id integer) RETURNS TABLE(id integer, value_date date, tran_code text, statement_reference text, debit numeric, credit numeric, balance numeric, office text, book text, account_id integer, account_number text, account text, posted_on timestamp with time zone, posted_by text, approved_by text, verification_status integer, flag_bg text, flag_fg text)	postgres
75	core. get_account_view_by_account_master_id(_account_master_id integer, _row_number integer) RETURNS TABLE(id bigint, account_id bigint, account_name text)	postgres
76	transactions. get_accrued_interest(office_id integer, party_id bigint) RETURNS money_strict2	postgres
77	core. get_associated_units(integer) RETURNS TABLE(unit_id integer, unit_code text, unit_name text)	postgres
78	core. get_associated_units_from_item_code(text) RETURNS TABLE(unit_id integer, unit_code text, unit_name text)	postgres
79	core. get_associated_units_from_item_id(integer) RETURNS TABLE(unit_id integer, unit_code text, unit_name text)	postgres
80	core. get_attachment_lookup_info(character varying) RETURNS text	postgres
81	transactions. get_average_party_transaction(party_id bigint, office_id integer) RETURNS money_strict2	postgres
82	transactions. get_average_party_transaction(party_id bigint) RETURNS money_strict2	postgres
83	transactions. get_balance_sheet(_previous_period date, _current_period date, _user_id integer, _office_id integer, _factor integer) RETURNS TABLE(id bigint, item text, previous_period numeric, current_period numeric, account_id integer, account_number text, is_retained_earning boolean)	postgres
84	core. get_base_quantity_by_unit_id(integer, integer) RETURNS numeric	postgres
85	unit_tests. get_base_quantity_by_unit_id_test() RETURNS test_result	postgres
86	core. get_base_quantity_by_unit_name(text, integer) RETURNS numeric	postgres
87	core. get_base_unit_id_by_unit_name(text) RETURNS integer	postgres
88	core. get_brand_code_by_brand_id(integer) RETURNS text	postgres
89	core. get_brand_id_by_brand_code(text) RETURNS integer	postgres
90	core. get_brand_id_by_brand_name(text) RETURNS integer	postgres
91	core. get_brand_name_by_brand_id(integer) RETURNS text	postgres
92	core. get_cash_account_id() RETURNS bigint	postgres	This function is now obsolete, core.get_cash_account_id_by_store_id(_store_id integer) should be used instead.
93	core. get_cash_account_id_by_store_id(_store_id integer) RETURNS bigint	postgres
94	core. get_cash_flow_heading_id_by_cash_flow_heading_code(_cash_flow_heading_code character varying) RETURNS integer	postgres
95	transactions. get_cash_flow_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _factor integer) RETURNS json	postgres
96	transactions. get_cash_repository_balance(_cash_repository_id integer, _currency_code character varying) RETURNS money_strict2	postgres
97	transactions. get_cash_repository_balance(_cash_repository_id integer) RETURNS money_strict2	postgres
98	office. get_cash_repository_id_by_cash_repository_code(text) RETURNS integer	postgres
99	office. get_cash_repository_id_by_cash_repository_name(text) RETURNS integer	postgres
100	core. get_cash_repository_id_by_store_id(_store_id integer) RETURNS bigint	postgres
101	transactions. get_closing_stock(_on_date date, _office_id integer) RETURNS numeric	postgres
102	office. get_cost_center_id_by_cost_center_code(text) RETURNS integer	postgres
103	office. get_cost_of_good_method(_office_id integer) RETURNS text	postgres
104	transactions. get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity integer) RETURNS money_strict	postgres
105	core. get_cost_of_goods_sold_account_id(_item_id integer) RETURNS integer	postgres
106	core. get_country_id_by_country_code(character varying) RETURNS integer	postgres
107	core. get_country_name_by_country_id(integer) RETURNS text	postgres
108	core. get_county_id_by_county_code(character varying) RETURNS integer	postgres
109	core. get_county_id_by_county_name(text) RETURNS integer	postgres
110	core. get_county_sales_tax_rate(_county_sales_tax_id integer) RETURNS decimal_strict2	postgres
111	core. get_currency_code_by_office_id(office_id integer) RETURNS text	postgres
112	core. get_currency_code_by_party_code(_party_code character varying) RETURNS text	postgres
113	core. get_currency_code_by_party_id(party_id bigint) RETURNS text	postgres
114	core. get_current_year() RETURNS integer	postgres
115	core. get_date(_office_id integer) RETURNS date	postgres
116	transactions. get_default_currency_code(cash_repository_id integer) RETURNS character varying	postgres
117	transactions. get_default_currency_code_by_office_id(office_id integer) RETURNS character varying	postgres
118	core. get_email_address_by_party_id(bigint) RETURNS text	postgres
119	core. get_entity_id_by_party_id(_party_id bigint) RETURNS integer	postgres
120	transactions. get_exchange_rate(office_id integer, currency_code character varying) RETURNS decimal_strict2	postgres
121	transactions. get_exchange_rate(office_id integer, source_currency_code character varying, destination_currency_code character varying) RETURNS decimal_strict2	postgres
122	core. get_field(this hstore, _column_name text) RETURNS text	postgres
123	core. get_fiscal_half_end_date(_office_id integer) RETURNS date	postgres
124	core. get_fiscal_half_start_date(_office_id integer) RETURNS date	postgres
125	core. get_fiscal_year_end_date(_office_id integer) RETURNS date	postgres
126	core. get_fiscal_year_start_date(_office_id integer) RETURNS date	postgres
127	core. get_flag_background_color(flag_type_id_ integer) RETURNS text	postgres
128	core. get_flag_foreground_color(flag_type_id_ integer) RETURNS text	postgres
129	core. get_flag_type_id(user_id_ integer, resource_ text, resource_key_ text, resource_id_ text) RETURNS integer	postgres
130	core. get_frequency_code_by_frequency_id(integer) RETURNS text	postgres
131	core. get_frequency_setup_code_by_frequency_setup_id(_frequency_setup_id integer) RETURNS text	postgres
132	core. get_frequency_setup_end_date_frequency_setup_id(_frequency_setup_id integer) RETURNS date	postgres
133	core. get_frequency_setup_start_date_frequency_setup_id(_frequency_setup_id integer) RETURNS date	postgres
134	transactions. get_income_expenditure_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean) RETURNS TABLE(id integer, account_id integer, account_number text, account text, previous_debit numeric, previous_credit numeric, previous_balance numeric, debit numeric, credit numeric, balance numeric, closing_debit numeric, closing_credit numeric, closing_balance numeric)	postgres
135	core. get_income_tax_provison_amount(_office_id integer, _profit numeric, _balance numeric) RETURNS numeric	postgres
136	core. get_income_tax_rate(_office_id integer) RETURNS real	postgres
137	core. get_industry_id_by_party_id(_party_id bigint) RETURNS integer	postgres
138	core. get_inventory_account_id(_item_id integer) RETURNS integer	postgres
139	transactions. get_invoice_amount(transaction_master_id_ bigint) RETURNS money_strict2	postgres
140	core. get_item_code_by_item_id(integer) RETURNS text	postgres
141	core. get_item_cost_price(item_id_ integer, party_id_ bigint, unit_id_ integer) RETURNS money_strict2	postgres
142	core. get_item_cost_price(item_id_ integer, unit_id_ integer, party_id_ bigint) RETURNS money_strict2	postgres
143	core. get_item_group_code_by_item_group_id(integer) RETURNS text	postgres
144	core. get_item_group_id_by_item_group_code(text) RETURNS integer	postgres
145	core. get_item_group_id_by_item_group_name(text) RETURNS integer	postgres
146	core. get_item_group_id_by_item_id(integer) RETURNS integer	postgres
147	core. get_item_group_name_by_item_group_id(integer) RETURNS text	postgres
148	core. get_item_id_by_item_code(text) RETURNS integer	postgres
149	core. get_item_name_by_item_id(integer) RETURNS text	postgres
150	core. get_item_selling_price(item_id_ integer, party_type_id_ integer, price_type_id_ integer, unit_id_ integer) RETURNS money_strict2	postgres
151	core. get_item_tax_rate(_item_id integer) RETURNS numeric	postgres
152	core. get_item_type_id_by_item_type_code(text) RETURNS integer	postgres
153	transactions. get_journal_view(_user_id integer, _office_id integer, _from date, _to date, _tran_id bigint, _tran_code character varying, _book character varying, _reference_number character varying, _statement_reference character varying, _posted_by character varying, _office character varying, _status character varying, _verified_by character varying, _reason character varying) RETURNS TABLE(transaction_master_id bigint, transaction_code character varying, book character varying, value_date date, reference_number character varying, statement_reference text, posted_by text, office text, status text, verified_by text, verified_on timestamp with time zone, reason character varying, transaction_ts timestamp with time zone, flag_bg text, flag_fg text)	postgres
154	transactions. get_last_receipt_date(office_id integer, party_id bigint) RETURNS date	postgres
155	localization. get_localization_table(culture_code text) RETURNS TABLE(row_number bigint, key text, invariant_resource text, value text)	postgres
156	office. get_logged_in_culture(_user_id integer) RETURNS text	postgres
157	office. get_logged_in_office_id(_user_id integer) RETURNS integer	postgres
158	office. get_login_id(_user_id integer) RETURNS bigint	postgres
159	transactions. get_mavcogs(_item_id integer, _store_id integer, _base_quantity numeric, _factor numeric) RETURNS numeric	postgres
160	policy. get_menu(user_id_ integer, office_id_ integer, culture_ text) RETURNS TABLE(menu_id integer, menu_text character varying, url character varying, menu_code character varying, level smallint, parent_menu_id integer)	postgres
161	core. get_menu_id(menu_code text) RETURNS integer	postgres
162	policy. get_menu_policy(_user_id integer, _office_id integer, _culture text) RETURNS TABLE(row_number bigint, access boolean, menu_id integer, menu_code text, menu_text text, url text)	postgres
163	core. get_month_end_date(_office_id integer) RETURNS date	postgres
164	core. get_month_start_date(_office_id integer) RETURNS date	postgres
165	transactions. get_net_profit(_date_from date, _date_to date, _office_id integer, _factor integer, _no_provison boolean DEFAULT false) RETURNS numeric	postgres
166	transactions. get_new_transaction_counter(date) RETURNS integer	postgres
167	transactions. get_non_gl_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text) RETURNS TABLE(id bigint, value_date date, office character varying, party text, price_type text, amount numeric, transaction_ts timestamp with time zone, "user" character varying, reference_number character varying, statement_reference text, book text, flag_background_color text, flag_foreground_color text)	postgres
168	office. get_office_code_by_id(office_id integer_strict) RETURNS text	postgres
169	office. get_office_id_by_cash_repository_id(integer) RETURNS integer	postgres
170	office. get_office_id_by_office_code(office_code text) RETURNS integer	postgres
171	core. get_office_id_by_sales_tax_id(_sales_tax_id integer) RETURNS integer	postgres
172	office. get_office_id_by_store_id(integer) RETURNS integer	postgres
173	office. get_office_id_by_user_id(user_id integer_strict) RETURNS integer	postgres
174	office. get_office_ids(root_office_id integer) RETURNS SETOF integer	postgres
175	office. get_office_name_by_id(office_id integer_strict) RETURNS text	postgres
176	office. get_offices() RETURNS SETOF office.office_type	postgres
177	core. get_ordered_quantity(_item_id integer, _unit_id integer, _office_id integer) RETURNS numeric	postgres
178	core. get_party_code(text, text, text) RETURNS text	postgres
179	core. get_party_id_by_party_code(text) RETURNS bigint	postgres
180	transactions. get_party_transaction_summary(office_id integer, party_id bigint, OUT currency_code text, OUT currency_symbol text, OUT total_due_amount numeric, OUT office_due_amount numeric, OUT accrued_interest numeric, OUT last_receipt_date date, OUT transaction_value numeric) RETURNS record	postgres
181	core. get_party_type_id_by_party_code(text) RETURNS integer	postgres
182	core. get_party_type_id_by_party_id(_party_id bigint) RETURNS integer	postgres
183	core. get_party_type_id_by_party_type_code(text) RETURNS integer	postgres
184	core. get_payment_term_id_by_payment_term_code(text) RETURNS integer	postgres
185	core. get_periods(_date_from date, _date_to date) RETURNS core.period[]	postgres
186	core. get_price_type_id_by_price_type_code(text) RETURNS integer	postgres
187	core. get_price_type_name_by_price_type_id(integer) RETURNS text	postgres
188	transactions. get_product_view(user_id_ integer, book_ text, office_id_ integer, date_from_ date, date_to_ date, office_ character varying, party_ text, price_type_ text, user_ character varying, reference_number_ character varying, statement_reference_ text) RETURNS TABLE(id bigint, value_date date, office character varying, party text, price_type text, amount numeric, transaction_ts timestamp with time zone, "user" character varying, reference_number character varying, statement_reference text, book text, salesperson text, is_credit boolean, shipper text, shipping_address_code text, store text, flag_background_color text, flag_foreground_color text)	postgres
189	transactions. get_profit_and_loss_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _factor integer, _compact boolean DEFAULT true) RETURNS json	postgres
190	transactions. get_purchase(_date_from date, _date_to date, _office_id integer) RETURNS numeric	postgres
191	core. get_purchase_account_id(_item_id integer) RETURNS integer	postgres
192	core. get_purchase_discount_account_id(_item_id integer) RETURNS integer	postgres
193	core. get_quarter_end_date(_office_id integer) RETURNS date	postgres
194	core. get_quarter_start_date(_office_id integer) RETURNS date	postgres
195	transactions. get_receipt_view(_user_id integer, _office_id integer, _date_from date, _date_to date, _office character varying, _party text, _user character varying, _reference_number character varying, _statement_reference text) RETURNS TABLE(id bigint, value_date date, reference_number text, statement_reference text, office text, party text, "user" text, currency_code text, amount money_strict, transaction_ts timestamp with time zone, flag_background_color text, flag_foreground_color text)	postgres
196	core. get_recurring_amount_by_recurring_invoice_id(_recurring_invoice_id integer) RETURNS money_strict	postgres
197	transactions. get_reorder_view_function(office_id integer) RETURNS TABLE(item_id integer, item_code character varying, item_name character varying, unit_id integer, unit text, quantity_on_hand numeric, reorder_level integer, reorder_quantity integer, preferred_supplier_id bigint, preferred_supplier text, price money_strict2, tax character varying)	postgres
198	transactions. get_retained_earnings(_date_to date, _office_id integer, _factor integer) RETURNS numeric	postgres
199	transactions. get_retained_earnings_statement(_date_to date, _office_id integer, _factor integer) RETURNS TABLE(id integer, value_date date, tran_code text, statement_reference text, debit numeric, credit numeric, balance numeric, office text, book text, account_id integer, account_number text, account text, posted_on timestamp with time zone, posted_by text, approved_by text, verification_status integer)	postgres
200	office. get_role_code_by_user_name(user_name text) RETURNS text	postgres
201	office. get_role_id_by_role_code(text) RETURNS integer	postgres
202	office. get_role_id_by_role_name(text) RETURNS integer	postgres
203	office. get_role_id_by_use_id(user_id integer_strict) RETURNS integer	postgres
204	core. get_root_parent_menu_id(text) RETURNS integer	postgres
205	core. get_root_unit_id(integer) RETURNS integer	postgres
206	core. get_sales_account_id(_item_id integer) RETURNS integer	postgres
207	transactions. get_sales_by_offices(office_id integer, divide_by integer) RETURNS TABLE(office text, jan numeric, feb numeric, mar numeric, apr numeric, may numeric, jun numeric, jul numeric, aug numeric, sep numeric, oct numeric, nov numeric, "dec" numeric)	postgres
208	transactions. get_sales_by_offices(divide_by integer) RETURNS TABLE(office text, jan numeric, feb numeric, mar numeric, apr numeric, may numeric, jun numeric, jul numeric, aug numeric, sep numeric, oct numeric, nov numeric, "dec" numeric)	postgres
209	core. get_sales_discount_account_id(_item_id integer) RETURNS integer	postgres
210	core. get_sales_return_account_id(_item_id integer) RETURNS integer	postgres
211	transactions. get_sales_tax(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _price money_strict2, _quantity integer_strict2, _discount money_strict2, _shipping_charge money_strict2, _sales_tax_id integer) RETURNS SETOF transactions.sales_tax_type	postgres
212	core. get_sales_tax_code_by_sales_tax_id(_sales_tax_id integer) RETURNS character varying	postgres
213	transactions. get_sales_tax_id(_tran_book character varying, _store_id integer, _party_code character varying, _shipping_address_code character varying, _price_type_id integer, _item_code character varying, _unit_id integer, _price money_strict) RETURNS integer	postgres
214	core. get_sales_tax_id_by_sales_tax_code(_sales_tax_code character varying) RETURNS integer	postgres
215	core. get_sales_tax_name_by_sales_tax_id(_sales_tax_id integer) RETURNS character varying	postgres
216	core. get_sales_team_id_by_sales_team_code(text) RETURNS integer	postgres
217	core. get_salesperson_id_by_salesperson_code(text) RETURNS integer	postgres
218	core. get_salesperson_name_by_salesperson_id(integer) RETURNS text	postgres
219	core. get_second_root_account_id(_account_id bigint, _parent bigint DEFAULT 0) RETURNS integer	postgres
220	core. get_shipper_code(text) RETURNS text	postgres
221	core. get_shipper_id_by_shipper_code(text) RETURNS integer	postgres
222	core. get_shipper_name_by_shipper_id(integer) RETURNS text	postgres
223	core. get_shipping_address_by_shipping_address_id(bigint) RETURNS text	postgres
224	core. get_shipping_address_code_by_shipping_address_id(bigint) RETURNS text	postgres
225	core. get_shipping_address_id_by_shipping_address_code(text, bigint) RETURNS integer	postgres
226	core. get_state_id_by_shipping_address_code(text, bigint) RETURNS integer	postgres
227	core. get_state_id_by_state_code(character varying) RETURNS integer	postgres
228	core. get_state_id_by_state_name(text) RETURNS integer	postgres
229	core. get_state_name_by_state_id(integer) RETURNS text	postgres
230	core. get_state_sales_tax_rate(_state_sales_tax_id integer) RETURNS decimal_strict2	postgres
231	transactions. get_stock_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _item_code text, _store_id integer) RETURNS TABLE(id integer, value_date date, tran_code text, statement_reference text, debit numeric, credit numeric, balance numeric, book text, item_id integer, item_code text, item_name text, posted_on timestamp with time zone, posted_by text, approved_by text, verification_status integer, flag_bg text, flag_fg text)	postgres
232	transactions. get_stock_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _item_id integer, _store_id integer) RETURNS TABLE(id integer, value_date date, tran_code text, statement_reference text, debit numeric, credit numeric, balance numeric, book text, item_id integer, item_code text, item_name text, posted_on timestamp with time zone, posted_by text, approved_by text, verification_status integer, flag_bg text, flag_fg text)	postgres
233	transactions. get_stock_master_id_by_transaction_master_id(_stock_master_id bigint) RETURNS bigint	postgres
234	office. get_store_id_by_store_code(text) RETURNS integer	postgres
235	office. get_store_id_by_store_name(text) RETURNS integer	postgres
236	office. get_store_name_by_store_id(integer) RETURNS text	postgres
237	office. get_store_type_id_by_store_type_code(text) RETURNS integer	postgres
238	office. get_sys_user_id() RETURNS integer	postgres
239	core. get_tax_master_id_by_tax_master_code(text) RETURNS integer	postgres
240	transactions. get_top_selling_products_by_office(_office_id integer, top integer) RETURNS TABLE(id integer, office_id integer, office_code text, office_name text, item_id integer, item_code text, item_name text, total_sales numeric)	postgres
241	transactions. get_top_selling_products_by_office() RETURNS TABLE(id integer, office_id integer, office_code text, office_name text, item_id integer, item_code text, item_name text, total_sales numeric)	postgres
242	transactions. get_top_selling_products_of_all_time() RETURNS TABLE(id integer, item_id integer, item_code text, item_name text, total_sales numeric)	postgres
243	transactions. get_top_selling_products_of_all_time(top integer) RETURNS TABLE(id integer, item_id integer, item_code text, item_name text, total_sales numeric)	postgres
244	transactions. get_total_due(office_id integer, party_id bigint) RETURNS numeric	postgres
245	transactions. get_transaction_code(value_date date, office_id integer, user_id integer, login_id bigint) RETURNS text	postgres
246	transactions. get_transaction_master_id_by_stock_master_id(_stock_master_id bigint) RETURNS bigint	postgres
247	transactions. get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean DEFAULT true, _include_zero_balance_accounts boolean DEFAULT true) RETURNS TABLE(id integer, account_id integer, account_number text, account text, previous_debit numeric, previous_credit numeric, debit numeric, credit numeric, closing_debit numeric, closing_credit numeric)	postgres
248	core. get_unit_code_by_unit_id(integer) RETURNS text	postgres
249	core. get_unit_id_by_unit_code(text) RETURNS integer	postgres
250	core. get_unit_id_by_unit_name(text) RETURNS integer	postgres
251	core. get_unit_name_by_unit_id(integer) RETURNS text	postgres
252	office. get_user_id_by_user_name(user_name text) RETURNS integer	postgres
253	office. get_user_name_by_user_id(user_id integer) RETURNS text	postgres
254	transactions. get_value_date(_office_id integer) RETURNS date	postgres
255	core. get_verification_status_name_by_verification_status_id(integer) RETURNS text	postgres
256	transactions. get_write_off_cost_of_goods_sold(_stock_master_id bigint, _item_id integer, _unit_id integer, _quantity integer) RETURNS money_strict2	postgres
257	core. has_child_accounts(bigint) RETURNS boolean	postgres
258	office. has_child_offices(integer) RETURNS boolean	postgres
259	transactions. has_nexus(_state_id integer) RETURNS boolean	postgres
260	unit_tests. if_functions_compile() RETURNS test_result	postgres
261	assert. if_functions_compile(VARIADIC _schema_name text[], OUT message text, OUT result boolean) RETURNS record	postgres
262	assert. if_views_compile(VARIADIC _schema_name text[], OUT message text, OUT result boolean) RETURNS record	postgres
263	unit_tests. if_views_compile() RETURNS test_result	postgres
264	transactions. initialize_eod_operation(_user_id integer, _office_id integer, _value_date date) RETURNS void	postgres
265	office. is_admin(integer) RETURNS boolean	postgres
266	core. is_cash_account_id(_account_id bigint) RETURNS boolean	postgres
267	core. is_cash_equivalent(_account_id bigint) RETURNS boolean	postgres
268	policy. is_elevated_user(_user_id integer) RETURNS boolean	postgres
269	transactions. is_eod_initialized(_office_id integer, _value_date date) RETURNS boolean	postgres
270	assert. is_equal(have anyelement, want anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
271	assert. is_false(boolean, OUT message text, OUT result boolean) RETURNS record	postgres
272	assert. is_greater_than(x anyelement, y anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
273	core. is_leap_year() RETURNS boolean	postgres
274	core. is_leap_year(integer) RETURNS boolean	postgres
275	assert. is_less_than(x anyelement, y anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
276	policy. is_locked_out_till(user_id integer_strict) RETURNS timestamp without time zone	postgres
277	transactions. is_normally_debit(_account_id bigint) RETURNS boolean	postgres
278	assert. is_not_equal(already_have anyelement, dont_want anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
279	assert. is_not_null(anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
280	assert. is_null(anyelement, OUT message text, OUT result boolean) RETURNS record	postgres
281	office. is_parent_office(parent integer_strict, child integer_strict) RETURNS boolean	postgres
282	core. is_parent_unit(parent integer, child integer) RETURNS boolean	postgres
283	office. is_periodic_inventory(_office_id integer) RETURNS boolean	postgres
284	transactions. is_purchase(_transaction_master_id bigint) RETURNS boolean	postgres
285	policy. is_restricted_mode() RETURNS boolean	postgres
286	core. is_stock_item(item_id integer) RETURNS boolean	postgres
287	core. is_stock_item(item_code character varying) RETURNS boolean	postgres
288	core. is_supplier(bigint) RETURNS boolean	postgres
289	office. is_sys(integer) RETURNS boolean	postgres
290	office. is_sys_user(integer) RETURNS boolean	postgres
291	policy. is_transaction_restricted(_office_id integer) RETURNS boolean	postgres
292	assert. is_true(boolean, OUT message text, OUT result boolean) RETURNS record	postgres
293	core. is_valid_item_id(integer) RETURNS boolean	postgres
294	audit. is_valid_login_id(bigint) RETURNS boolean	postgres
295	office. is_valid_office_id(integer) RETURNS boolean	postgres
296	transactions. is_valid_party_by_stock_master_id(_stock_master_id bigint, _party_id bigint) RETURNS boolean	postgres
297	transactions. is_valid_party_by_transaction_master_id(_transaction_master_id bigint, _party_id bigint) RETURNS boolean	postgres
298	transactions. is_valid_stock_transaction_by_stock_master_id(_stock_master_id bigint) RETURNS boolean	postgres
299	transactions. is_valid_stock_transaction_by_transaction_master_id(_transaction_master_id bigint) RETURNS boolean	postgres
300	core. is_valid_unit(_item_id integer, _unit_id integer) RETURNS boolean	postgres
301	core. is_valid_unit_id(integer) RETURNS boolean	postgres
302	core. is_valid_unit_id(_unit_id integer, _item_id integer) RETURNS boolean	postgres
303	transactions. list_closing_stock(_store_id integer) RETURNS TABLE(item_id integer, item_code text, item_name text, unit_id integer, unit_name text, quantity integer)	postgres	Lists stock items, their respective base units, and closing stock quantity.
304	assert. ok(message text) RETURNS text	postgres
305	transactions. opening_inventory_exists(_office_id integer) RETURNS boolean	postgres
306	scrud. parse_default(text) RETURNS text	postgres	Parses default constraint column values.
307	assert. pass(message text) RETURNS text	postgres
308	transactions. perform_eod_operation(_login_id bigint) RETURNS boolean	postgres
309	transactions. perform_eod_operation(_user_id integer, _office_id integer, _value_date date) RETURNS boolean	postgres
310	public. poco_get_table_function_definition(_schema text, _name text) RETURNS TABLE(column_name text, is_nullable text, udt_name text, column_default text)	postgres
311	transactions. post_non_gl_transaction(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _party_code character varying, _price_type_id integer, _is_non_taxable_sales boolean, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _tran_ids bigint[], _details transactions.stock_detail_type[], _attachments core.attachment_type[]) RETURNS bigint	postgres
312	transactions. post_opening_inventory(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.opening_stock_type[]) RETURNS bigint	postgres
313	transactions. post_purchase(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _party_code character varying, _price_type_id integer, _shipper_id integer, _store_id integer, _tran_ids bigint[], _details transactions.stock_detail_type[], _attachments core.attachment_type[]) RETURNS bigint	postgres
314	transactions. post_purchase_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _store_id integer, _party_code character varying, _price_type_id integer, _reference_number character varying, _statement_reference text, _details transactions.stock_detail_type[], _attachments core.attachment_type[]) RETURNS bigint	postgres
315	transactions. post_purhcase_reorder(_value_date date, _login_id bigint, _user_id integer, _office_id integer, _details transactions.purchase_reorder_type[]) RETURNS boolean	postgres
316	transactions. post_receipt_function(_user_id integer, _office_id integer, _login_id bigint, _party_code character varying, _currency_code character varying, _amount money_strict, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference character varying, _cost_center_id integer, _cash_repository_id integer, _posted_date date, _bank_account_id integer, _bank_instrument_code character varying, _bank_tran_code character varying) RETURNS bigint	postgres
317	transactions. post_sales(_book_name character varying, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _is_credit boolean, _payment_term_id integer, _party_code character varying, _price_type_id integer, _salesperson_id integer, _shipper_id integer, _shipping_address_code character varying, _store_id integer, _is_non_taxable_sales boolean, _details transactions.stock_detail_type[], _attachments core.attachment_type[]) RETURNS bigint	postgres
318	transactions. post_sales_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _store_id integer, _party_code character varying, _price_type_id integer, _reference_number character varying, _statement_reference text, _details transactions.stock_detail_type[], _attachments core.attachment_type[]) RETURNS bigint	postgres
319	transactions. post_stock_adjustment(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.stock_adjustment_type[]) RETURNS bigint	postgres
320	transactions. post_stock_journal(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _statement_reference text, _details transactions.stock_adjustment_type[]) RETURNS bigint	postgres
321	transactions. refresh_materialized_views(_office_id integer) RETURNS void	postgres
322	policy. save_menu_policy(_user_id integer, _office_id integer, _menu_ids integer[]) RETURNS void	postgres
323	office. sign_in(office_id integer_strict, user_name text, password text, browser text, ip_address text, remote_user text, culture text, challenge text, OUT login_id bigint, OUT message text) RETURNS record	postgres
324	unit_tests. sign_in_test() RETURNS test_result	postgres
325	unit_tests. test_transactions_post_receipt_function() RETURNS test_result	postgres
326	transactions. validate_item_for_return(_transaction_master_id bigint, _store_id integer, _item_code character varying, _unit_name character varying, _quantity integer, _price money_strict) RETURNS boolean	postgres
327	office. validate_login(user_name text, password text, challenge text) RETURNS boolean	postgres
328	transactions. verify_transaction(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _verification_status_id smallint, _reason character varying) RETURNS void	postgres