| 1 |
production.abort_manufacturing(_order_id bigint) RETURNS boolean |
frapid_db_user |
|
| 2 |
forums.about_user(_user_id integer) RETURNS TABLE(user_id integer, name text, created_on date, joined_year integer, total_answers bigint, total_questions bigint, received_thanks bigint, given_thanks bigint, current_rank text, rank_css_color text, next_rank text, remaining_posts integer, last_sign_in_timestamp timestamp with time zone, last_sign_in_browser text, last_sign_in_ip text, profile_hits bigint, post_hits bigint, signature text, website text, blog text, twitter text, linkedin text, facebook text) |
frapid_db_user |
|
| 3 |
cinesys.add_bod_cash(_user_id integer, _transaction_date date, _amount numeric, _provided_by character varying, _memo character varying) RETURNS void |
frapid_db_user |
|
| 4 |
foodcourt.add_bod_cash(_user_id integer, _transaction_date date, _amount numeric, _provided_by character varying, _memo character varying) RETURNS void |
frapid_db_user |
|
| 5 |
cafesys.add_checkout_detail(_checkout_id bigint, _checkout_detail_id bigint, _food_course_id integer, _dining_option_id integer, _chair character varying, _item_id integer, _unit_id integer, _rate money_strict2, _quantity decimal_strict, _tax decimal_strict2, _service_charge decimal_strict2, _discount_rate decimal_strict2, _special_instructions character varying, _modifiers character varying) RETURNS bigint |
frapid_db_user |
|
| 6 |
website.add_email_subscription(_email text) RETURNS boolean |
frapid_db_user |
|
| 7 |
sales.add_gift_card_fund(_user_id integer, _office_id integer, _login_id bigint, _gift_card_id integer, _value_date date, _book_date date, _debit_account_id integer, _amount money_strict, _cost_center_id integer, _reference_number character varying, _statement_reference character varying) RETURNS bigint |
frapid_db_user |
|
| 8 |
website.add_hit(_category_alias character varying, _alias character varying) RETURNS void |
frapid_db_user |
|
| 9 |
account.add_installed_domain(_domain_name text, _admin_email text) RETURNS void |
frapid_db_user |
|
| 10 |
sales.add_opening_cash(_user_id integer, _transaction_date timestamp without time zone, _amount numeric, _provided_by character varying, _memo character varying) RETURNS void |
frapid_db_user |
|
| 11 |
production.add_or_edit_bom(_bom_id integer, _bom_code character varying, _bom_name character varying, _description character varying, _revision_code character varying, _bom_type_id integer, _raw_material_store_id integer, _work_in_progress_store_id integer, _finished_good_store_id integer, _is_phantom boolean, _components production.bom_component_type[], _finish_goods production.bom_finish_good_type[], _user_id integer) RETURNS integer |
frapid_db_user |
|
| 12 |
forums.add_post(_topic_id bigint, _title text, _message text, _browser text, _ip_address text, _country text, _user_agent text, _posted_by integer) RETURNS bigint |
frapid_db_user |
|
| 13 |
production.add_scraps(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _reference_number character varying, _details production.scrap_type[]) RETURNS bigint |
frapid_db_user |
|
| 14 |
cinesys.alter_login(_userid integer, _password character varying) RETURNS void |
frapid_db_user |
|
| 15 |
finance.auto_verify(_tran_id bigint, _office_id integer) RETURNS void |
frapid_db_user |
|
| 16 |
production.book_expenses_in_progress(order_id_ bigint) RETURNS boolean |
frapid_db_user |
|
| 17 |
account.can_confirm_registration(_token uuid) RETURNS boolean |
frapid_db_user |
|
| 18 |
finance.can_post_transaction(_login_id bigint, _user_id integer, _office_id integer, transaction_book text, _value_date date) RETURNS boolean |
frapid_db_user |
|
| 19 |
finance.can_post_transaction(_login_id bigint, _user_id integer, _office_id integer, transaction_book text, _value_date timestamp without time zone) RETURNS boolean |
frapid_db_user |
|
| 20 |
account.can_register_with_facebook() RETURNS boolean |
frapid_db_user |
|
| 21 |
account.can_register_with_google() RETURNS boolean |
frapid_db_user |
|
| 22 |
gatekeeper.commmit_check_ins(_access_setup_id integer) RETURNS void |
frapid_db_user |
|
| 23 |
production.complete_manufacturing(_office_id integer, _login_id bigint, _user_id integer, _manufacturing_id bigint, _value_date timestamp without time zone, _reference_number character varying, _statement_reference text, _details production.manufacturing_summary_type[]) RETURNS bigint |
frapid_db_user |
|
| 24 |
account.complete_reset(_request_id uuid, _password text) RETURNS void |
frapid_db_user |
|
| 25 |
account.confirm_registration(_token uuid) RETURNS boolean |
frapid_db_user |
|
| 26 |
finance.convert_exchange_rate(_office_id integer, _source_currency_code character varying, _destination_currency_code character varying) RETURNS decimal_strict2 |
frapid_db_user |
|
| 27 |
inventory.convert_unit(from_unit integer, to_unit integer) RETURNS numeric |
frapid_db_user |
|
| 28 |
social.count_comments(_feed_id bigint) RETURNS bigint |
frapid_db_user |
|
| 29 |
inventory.count_item_in_stock(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric |
frapid_db_user |
|
| 30 |
forums.count_posts(_category_id integer) RETURNS bigint |
frapid_db_user |
|
| 31 |
forums.count_posts_by_topic_id(_topic_id bigint) RETURNS bigint |
frapid_db_user |
|
| 32 |
forums.count_posts_by_user_id(_user_id integer) RETURNS bigint |
frapid_db_user |
|
| 33 |
inventory.count_purchases(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric |
frapid_db_user |
|
| 34 |
inventory.count_sales(_item_id integer, _unit_id integer, _store_id integer) RETURNS numeric |
frapid_db_user |
|
| 35 |
forums.count_thank_yous_by_user_id(_user_id integer) RETURNS bigint |
frapid_db_user |
|
| 36 |
forums.count_topics(_category_id integer) RETURNS bigint |
frapid_db_user |
|
| 37 |
auth.create_api_access_policy(_role_names text[], _office_id integer, _entity_name text, _access_types text[], _allow_access boolean) RETURNS void |
frapid_db_user |
|
| 38 |
core.create_app(_app_name text, _i18n_key character varying, _name text, _version_number text, _publisher text, _published_on date, _icon text, _landing_url text, _dependencies text[]) RETURNS void |
frapid_db_user |
|
| 39 |
auth.create_app_menu_policy(_role_name text, _office_id integer, _app_name text, _menu_names text[]) RETURNS void |
frapid_db_user |
|
| 40 |
finance.create_card_type(_card_type_id integer, _card_type_code character varying, _card_type_name character varying) RETURNS void |
frapid_db_user |
|
| 41 |
config.create_custom_field(_form_name character varying, _before_field character varying, _field_order integer, _after_field character varying, _field_name character varying, _field_label character varying, _data_type character varying, _description character varying) RETURNS void |
frapid_db_user |
|
| 42 |
inventory.create_item_variant(_variant_of integer, _item_id integer, _item_code character varying, _item_name character varying, _variants text, _user_id integer) RETURNS integer |
frapid_db_user |
|
| 43 |
cinesys.create_login(_username character varying, _password character varying) RETURNS void |
frapid_db_user |
|
| 44 |
core.create_menu(_sort integer, _app_name text, _i18n_key character varying, _menu_name text, _url text, _icon text, _parent_menu_name text) RETURNS integer |
frapid_db_user |
|
| 45 |
core.create_menu(_sort integer, _app_name text, _i18n_key character varying, _menu_name text, _url text, _icon text, _parent_menu_id integer) RETURNS integer |
frapid_db_user |
|
| 46 |
core.create_menu(_app_name text, _i18n_key character varying, _menu_name text, _url text, _icon text, _parent_menu_name text) RETURNS integer |
frapid_db_user |
|
| 47 |
finance.create_payment_card(_payment_card_code character varying, _payment_card_name character varying, _card_type_id integer) RETURNS void |
frapid_db_user |
|
| 48 |
finance.create_routine(_routine_code character varying, _routine regproc, _order integer) RETURNS void |
frapid_db_user |
|
| 49 |
helpdesk.create_ticket(_subject character varying, _opened_by integer, _opened_for integer, _product_id integer, _ticket_priority_id integer, _department_id integer, _message text, _attachments text) RETURNS bigint |
frapid_db_user |
|
| 50 |
helpdesk.create_ticket_reply(_support_ticket_id bigint, _posted_by integer, _message text, _attachments text) RETURNS bigint |
frapid_db_user |
|
| 51 |
forums.create_topic(_category_id integer, _subject text, _message text, _browser text, _ip_address text, _country text, _user_agent text, _created_by integer) RETURNS bigint |
frapid_db_user |
|
| 52 |
production.delete_bom(_bom_id integer) RETURNS void |
frapid_db_user |
|
| 53 |
forums.delete_post(_topic_id bigint, _post_id bigint, _user_id integer) RETURNS void |
frapid_db_user |
|
| 54 |
inventory.delete_variant_item(_item_id integer) RETURNS boolean |
frapid_db_user |
|
| 55 |
account.email_exists(_email character varying) RETURNS boolean |
frapid_db_user |
|
| 56 |
finance.eod_required(_office_id integer) RETURNS boolean |
frapid_db_user |
|
| 57 |
public.explode_array(in_array anyarray) RETURNS SETOF anyelement |
frapid_db_user |
|
| 58 |
account.fb_sign_in(_fb_user_id text, _email text, _office_id integer, _name text, _token text, _browser text, _ip_address text, _culture text) RETURNS TABLE(login_id bigint, status boolean, message text) |
frapid_db_user |
|
| 59 |
account.fb_user_exists(_user_id integer) RETURNS boolean |
frapid_db_user |
|
| 60 |
helpdesk.follow_question(_user_id integer, _knowledgebase_request_id bigint, _browser character varying, _ip_address character varying, _user_agent character varying, _country character varying) RETURNS uuid |
frapid_db_user |
|
| 61 |
finance.get_account_id_by_account_name(text) RETURNS integer |
frapid_db_user |
|
| 62 |
finance.get_account_id_by_account_number(text) RETURNS integer |
frapid_db_user |
|
| 63 |
inventory.get_account_id_by_customer_id(_customer_id integer) RETURNS integer |
frapid_db_user |
|
| 64 |
inventory.get_account_id_by_customer_type_id(_customer_type_id integer) RETURNS integer |
frapid_db_user |
|
| 65 |
inventory.get_account_id_by_shipper_id(_shipper_id integer) RETURNS integer |
frapid_db_user |
|
| 66 |
inventory.get_account_id_by_supplier_id(_supplier_id integer) RETURNS integer |
frapid_db_user |
|
| 67 |
inventory.get_account_id_by_supplier_type_id(_supplier_type_id integer) RETURNS integer |
frapid_db_user |
|
| 68 |
finance.get_account_ids(root_account_id integer) RETURNS SETOF integer |
frapid_db_user |
|
| 69 |
finance.get_account_master_id_by_account_id(bigint) RETURNS integer |
frapid_db_user |
|
| 70 |
finance.get_account_master_id_by_account_master_code(_account_master_code text) RETURNS integer |
frapid_db_user |
|
| 71 |
finance.get_account_master_ids(root_account_master_id integer) RETURNS SETOF smallint |
frapid_db_user |
|
| 72 |
finance.get_account_name_by_account_id(_account_id integer) RETURNS text |
frapid_db_user |
|
| 73 |
purchase.get_account_payables_report(_office_id integer, _from date) RETURNS TABLE(office_id integer, office_name character varying, account_id integer, account_number character varying, account_name character varying, previous_period numeric, current_period numeric, total_amount numeric) |
frapid_db_user |
|
| 74 |
sales.get_account_receivables_report(_office_id integer, _from date) RETURNS TABLE(office_id integer, office_name character varying, account_id integer, account_number character varying, account_name character varying, previous_period numeric, current_period numeric, total_amount numeric) |
frapid_db_user |
|
| 75 |
inventory.get_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, book_date date, store_name text, 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) |
frapid_db_user |
|
| 76 |
finance.get_account_statement(_value_date_from date, _value_date_to date, _user_id integer, _account_id integer, _office_id integer) RETURNS TABLE(id integer, transaction_id bigint, transaction_detail_id bigint, value_date date, book_date date, tran_code text, reference_number text, statement_reference text, reconciliation_memo 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) |
frapid_db_user |
|
| 77 |
finance.get_account_view_by_account_master_id(_account_master_id integer, _row_number integer) RETURNS TABLE(id bigint, account_id integer, account_name text) |
frapid_db_user |
|
| 78 |
sales.get_active_coupon_id_by_coupon_code(_coupon_code character varying) RETURNS integer |
frapid_db_user |
|
| 79 |
helpdesk.get_all_questions(user_id integer, top integer, skip integer, type text) RETURNS TABLE(total_views bigint, total_questions bigint, total_answered bigint, total_accepted bigint, total_results bigint, knowledgebase_request_id bigint, votes bigint, my_vote smallint, requested_by integer, request_by_user_name text, requested_on timestamp with time zone, category_id integer, category_name text, title text, accepted boolean, declined boolean) |
frapid_db_user |
|
| 80 |
public.get_app_data_type(_nullable text, _db_data_type text) RETURNS text |
frapid_db_user |
|
| 81 |
auth.get_apps(_user_id integer, _office_id integer) RETURNS TABLE(app_id integer, app_name text, i18n_key text, name text, version_number text, publisher text, published_on date, icon text, landing_url text) |
frapid_db_user |
|
| 82 |
inventory.get_associated_unit_list(_any_unit_id integer) RETURNS integer[] |
frapid_db_user |
|
| 83 |
inventory.get_associated_units(_any_unit_id integer) RETURNS TABLE(unit_id integer, unit_code text, unit_name text) |
frapid_db_user |
|
| 84 |
inventory.get_associated_units_by_item_code(_item_code text) RETURNS TABLE(unit_id integer, unit_code text, unit_name text) |
frapid_db_user |
|
| 85 |
inventory.get_associated_units_by_item_id(_item_id integer) RETURNS TABLE(unit_id integer, unit_code text, unit_name text) |
frapid_db_user |
|
| 86 |
sales.get_avaiable_coupons_to_print(_tran_id bigint) RETURNS TABLE(coupon_id integer) |
frapid_db_user |
|
| 87 |
finance.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) |
frapid_db_user |
|
| 88 |
inventory.get_base_quantity_by_unit_id(integer, numeric) RETURNS numeric |
frapid_db_user |
|
| 89 |
inventory.get_base_quantity_by_unit_name(text, numeric) RETURNS numeric |
frapid_db_user |
|
| 90 |
inventory.get_base_unit_id_by_unit_name(text) RETURNS integer |
frapid_db_user |
|
| 91 |
production.get_bom_id_by_bom_code(_bom_code character varying) RETURNS integer |
frapid_db_user |
|
| 92 |
production.get_bom_type_id_by_bom_type_code(_bom_type_code character varying) RETURNS integer |
frapid_db_user |
|
| 93 |
foodcourt.get_brand_id_by_brand_code(_brand_code character varying) RETURNS integer |
frapid_db_user |
|
| 94 |
inventory.get_brand_id_by_brand_code(text) RETURNS integer |
frapid_db_user |
|
| 95 |
inventory.get_cash_account_id_by_store_id(_store_id integer) RETURNS bigint |
frapid_db_user |
|
| 96 |
finance.get_cash_flow_heading_id_by_cash_flow_heading_code(_cash_flow_heading_code character varying) RETURNS integer |
frapid_db_user |
|
| 97 |
finance.get_cash_flow_statement(_date_from date, _date_to date, _user_id integer, _office_id integer, _factor integer) RETURNS json |
frapid_db_user |
|
| 98 |
finance.get_cash_repository_balance(_cash_repository_id integer, _currency_code character varying) RETURNS money_strict2 |
frapid_db_user |
|
| 99 |
finance.get_cash_repository_id_by_cash_repository_code(text) RETURNS integer |
frapid_db_user |
|
| 100 |
finance.get_cash_repository_id_by_cash_repository_name(text) RETURNS integer |
frapid_db_user |
|
| 101 |
inventory.get_cash_repository_id_by_store_id(_store_id integer) RETURNS bigint |
frapid_db_user |
|
| 102 |
forums.get_category_breadcrumb(_category_id integer, _level integer DEFAULT NULL::integer) RETURNS TABLE(id integer, name text, alias text, level integer) |
frapid_db_user |
|
| 103 |
forums.get_category_family(_category_id integer) RETURNS TABLE(category_id integer) |
frapid_db_user |
|
| 104 |
website.get_category_id_by_category_alias(_alias text) RETURNS integer |
frapid_db_user |
|
| 105 |
website.get_category_id_by_category_name(_category_name text) RETURNS integer |
frapid_db_user |
|
| 106 |
forums.get_category_subscriber_emails(_category_id bigint) RETURNS text |
frapid_db_user |
|
| 107 |
forums.get_chat_buddies(_user_id integer) RETURNS TABLE(user_id integer, name text, email text, event_time timestamp with time zone, unread_messages integer) |
frapid_db_user |
|
| 108 |
inventory.get_checkout_id_by_transaction_master_id(_checkout_id bigint) RETURNS bigint |
frapid_db_user |
|
| 109 |
finance.get_cost_center_id_by_cost_center_code(text) RETURNS integer |
frapid_db_user |
|
| 110 |
inventory.get_cost_of_good_method(_office_id integer) RETURNS text |
frapid_db_user |
|
| 111 |
inventory.get_cost_of_goods_sold(_item_id integer, _unit_id integer, _store_id integer, _quantity numeric) RETURNS money_strict |
frapid_db_user |
|
| 112 |
inventory.get_cost_of_goods_sold_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 113 |
helpdesk.get_coupon_info(_coupon_code text) RETURNS SETOF helpdesk.coupons |
frapid_db_user |
|
| 114 |
inventory.get_currency_code_by_customer_id(_customer_id integer) RETURNS character varying |
frapid_db_user |
|
| 115 |
core.get_currency_code_by_office_id(_office_id integer) RETURNS character varying |
frapid_db_user |
|
| 116 |
inventory.get_currency_code_by_supplier_id(_supplier_id integer) RETURNS character varying |
frapid_db_user |
|
| 117 |
config.get_custom_field_form_name(_table_name character varying) RETURNS character varying |
frapid_db_user |
|
| 118 |
config.get_custom_field_setup_id_by_table_name(_schema_name character varying, _table_name character varying, _field_name character varying) RETURNS integer |
frapid_db_user |
|
| 119 |
inventory.get_customer_code_by_customer_id(_customer_id integer) RETURNS character varying |
frapid_db_user |
|
| 120 |
inventory.get_customer_id_by_customer_code(text) RETURNS integer |
frapid_db_user |
|
| 121 |
helpdesk.get_customer_name_by_customer_id(_customer_id integer) RETURNS text |
frapid_db_user |
|
| 122 |
inventory.get_customer_name_by_customer_id(_customer_id integer) RETURNS character varying |
frapid_db_user |
|
| 123 |
inventory.get_customer_transaction_summary(office_id integer, customer_id integer) RETURNS TABLE(currency_code character varying, currency_symbol character varying, total_due_amount numeric, office_due_amount numeric) |
frapid_db_user |
|
| 124 |
inventory.get_customer_type_id_by_customer_id(_customer_id integer) RETURNS integer |
frapid_db_user |
|
| 125 |
inventory.get_customer_type_id_by_customer_type_code(text) RETURNS integer |
frapid_db_user |
|
| 126 |
finance.get_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 127 |
finance.get_default_currency_code(cash_repository_id integer) RETURNS character varying |
frapid_db_user |
|
| 128 |
finance.get_default_currency_code_by_office_id(office_id integer) RETURNS character varying |
frapid_db_user |
|
| 129 |
helpdesk.get_department_name_by_department_id(_department_id integer) RETURNS text |
frapid_db_user |
|
| 130 |
cafesys.get_dining_option_id_by_dining_option_code(text) RETURNS integer |
frapid_db_user |
|
| 131 |
cafesys.get_dining_option_id_by_dining_option_name(text) RETURNS integer |
frapid_db_user |
|
| 132 |
account.get_email_by_user_id(_user_id integer) RETURNS text |
frapid_db_user |
|
| 133 |
helpdesk.get_email_by_user_id(_user_id integer) RETURNS text |
frapid_db_user |
|
| 134 |
hrm.get_employee_by_employee_id(_employee_id integer) RETURNS text |
frapid_db_user |
|
| 135 |
hrm.get_employee_code_by_employee_id(_employee_id integer) RETURNS text |
frapid_db_user |
|
| 136 |
hrm.get_employee_name_by_employee_id(_employee_id integer) RETURNS text |
frapid_db_user |
|
| 137 |
finance.get_exchange_rate(office_id integer, currency_code character varying) RETURNS decimal_strict2 |
frapid_db_user |
|
| 138 |
finance.get_fiscal_half_end_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 139 |
finance.get_fiscal_half_start_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 140 |
finance.get_fiscal_year_end_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 141 |
finance.get_fiscal_year_start_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 142 |
social.get_followers(_feed_id bigint, _me integer) RETURNS text |
frapid_db_user |
|
| 143 |
cafesys.get_food_course_id_by_food_course_code(text) RETURNS integer |
frapid_db_user |
|
| 144 |
cafesys.get_food_course_id_by_food_course_name(text) RETURNS integer |
frapid_db_user |
|
| 145 |
finance.get_frequencies(_frequency_id integer) RETURNS integer[] |
frapid_db_user |
|
| 146 |
finance.get_frequency_end_date(_frequency_id integer, _value_date date) RETURNS date |
frapid_db_user |
|
| 147 |
finance.get_frequency_setup_code_by_frequency_setup_id(_frequency_setup_id integer) RETURNS text |
frapid_db_user |
|
| 148 |
finance.get_frequency_setup_end_date_by_frequency_setup_id(_frequency_setup_id integer) RETURNS date |
frapid_db_user |
|
| 149 |
finance.get_frequency_setup_start_date_by_frequency_setup_id(_frequency_setup_id integer) RETURNS date |
frapid_db_user |
|
| 150 |
finance.get_frequency_setup_start_date_frequency_setup_id(_frequency_setup_id integer) RETURNS date |
frapid_db_user |
|
| 151 |
sales.get_gift_card_balance(_gift_card_id integer, _value_date date) RETURNS numeric |
frapid_db_user |
|
| 152 |
sales.get_gift_card_id_by_gift_card_number(_gift_card_number character varying) RETURNS integer |
frapid_db_user |
|
| 153 |
auth.get_group_menu_policy(_role_id integer, _office_id integer) RETURNS TABLE(row_number integer, menu_id integer, app_name text, i18n_key text, menu_name text, allowed boolean, url text, sort integer, icon character varying, parent_menu_id integer) |
frapid_db_user |
|
| 154 |
core.get_hstore_field(_hstore hstore, _column_name text) RETURNS text |
frapid_db_user |
|
| 155 |
finance.get_income_tax_provison_amount(_office_id integer, _profit numeric, _balance numeric) RETURNS numeric |
frapid_db_user |
|
| 156 |
finance.get_income_tax_rate(_office_id integer) RETURNS decimal_strict |
frapid_db_user |
|
| 157 |
cafesys.get_ingredient_id_by_ingredient_code(text) RETURNS integer |
frapid_db_user |
|
| 158 |
cafesys.get_ingredient_id_by_ingredient_name(text) RETURNS integer |
frapid_db_user |
|
| 159 |
inventory.get_inventory_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 160 |
cinesys.get_invoice_number() RETURNS bigint |
frapid_db_user |
|
| 161 |
production.get_issue_method_id_by_issue_method_code(_issue_method_code character varying) RETURNS integer |
frapid_db_user |
|
| 162 |
inventory.get_item_code_by_item_id(item_id_ integer) RETURNS character varying |
frapid_db_user |
|
| 163 |
purchase.get_item_cost_price(_item_id integer, _supplier_id bigint, _unit_id integer) RETURNS money_strict2 |
frapid_db_user |
|
| 164 |
inventory.get_item_cost_price(_item_id integer, _unit_id integer) RETURNS money_strict2 |
frapid_db_user |
|
| 165 |
inventory.get_item_group_id_by_item_group_code(text) RETURNS integer |
frapid_db_user |
|
| 166 |
foodcourt.get_item_group_id_by_item_group_code(_item_group_code character varying) RETURNS integer |
frapid_db_user |
|
| 167 |
inventory.get_item_id_by_item_code(_item_code text) RETURNS integer |
frapid_db_user |
|
| 168 |
cafesys.get_item_id_by_modifier_detail_id(_modifier_detail_id bigint) RETURNS integer |
frapid_db_user |
|
| 169 |
cafesys.get_item_id_by_modifier_id(_modifier_id integer) RETURNS integer |
frapid_db_user |
|
| 170 |
inventory.get_item_name_by_item_id(item_id_ integer) RETURNS character varying |
frapid_db_user |
|
| 171 |
sales.get_item_selling_price(_item_id integer, _customer_type_id integer, _price_type_id integer, _unit_id integer) RETURNS money_strict2 |
frapid_db_user |
|
| 172 |
foodcourt.get_item_stock(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 173 |
inventory.get_item_type_id_by_item_type_code(text) RETURNS integer |
frapid_db_user |
|
| 174 |
finance.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 text, book text, value_date date, book_date date, reference_number text, statement_reference text, posted_by text, office text, status text, verified_by text, verified_on timestamp with time zone, reason text, transaction_ts timestamp with time zone) |
frapid_db_user |
|
| 175 |
production.get_kanban_id_by_kanban_code(_kanban_code character varying) RETURNS integer |
frapid_db_user |
|
| 176 |
forums.get_karma_id(total_posts bigint) RETURNS integer |
frapid_db_user |
|
| 177 |
forums.get_karma_id_by_user_id(_user_id integer) RETURNS integer |
frapid_db_user |
|
| 178 |
helpdesk.get_knowledgebase_category_name_by_knowledgebase_category_id(_knowledgebase_category_id integer) RETURNS text |
frapid_db_user |
|
| 179 |
helpdesk.get_knowledgebase_request_summary(_user_id integer, _knowledgebase_request_id bigint) RETURNS TABLE(knowledgebase_request_id bigint, knowledgebase_id integer, answered boolean, followed boolean, followers bigint, upvotes bigint, downvotes bigint, requested_by integer, requested_by_user_name text, requested_by_user_email text, requested_on timestamp with time zone, accepted boolean, accepted_on timestamp with time zone, accepted_by integer, accepted_by_user_name text, declined boolean, declined_on timestamp with time zone, declined_by integer, declined_by_user_name text, title character varying, category_id integer, category_name text, hits bigint, notify boolean, country character varying, ip_address character varying) |
frapid_db_user |
|
| 180 |
foodcourt.get_last_invoice_print_date(_checkout_id bigint) RETURNS timestamp with time zone |
frapid_db_user |
|
| 181 |
cinesys.get_last_invoice_print_date(_checkout_id bigint) RETURNS timestamp with time zone |
frapid_db_user |
|
| 182 |
cinesys.get_last_invoice_printed_by(_checkout_id bigint) RETURNS character varying |
frapid_db_user |
|
| 183 |
foodcourt.get_last_invoice_printed_by(_checkout_id bigint) RETURNS character varying |
frapid_db_user |
|
| 184 |
forums.get_last_post_id_by_category_id(_category_id integer) RETURNS bigint |
frapid_db_user |
|
| 185 |
forums.get_last_post_id_by_topic_id(_topic_id bigint) RETURNS bigint |
frapid_db_user |
|
| 186 |
helpdesk.get_last_support_ticket_message_id(_support_ticket_id bigint) RETURNS bigint |
frapid_db_user |
|
| 187 |
forums.get_last_topic_id(_category_id integer) RETURNS bigint |
frapid_db_user |
|
| 188 |
sales.get_late_fee_id_by_late_fee_code(_late_fee_code character varying) RETURNS integer |
frapid_db_user |
|
| 189 |
production.get_manufacturing_id_by_order_id(bigint) RETURNS bigint |
frapid_db_user |
|
| 190 |
inventory.get_mavcogs(_item_id integer, _store_id integer, _base_quantity numeric, _factor numeric) RETURNS numeric |
frapid_db_user |
|
| 191 |
auth.get_menu(_user_id integer, _office_id integer) RETURNS TABLE(menu_id integer, app_name character varying, app_i18n_key character varying, menu_name character varying, i18n_key character varying, url text, sort integer, icon character varying, parent_menu_id integer) |
frapid_db_user |
|
| 192 |
cafesys.get_menu_id_by_menu_code(text) RETURNS integer |
frapid_db_user |
|
| 193 |
website.get_menu_id_by_menu_name(_menu_name character varying) RETURNS integer |
frapid_db_user |
|
| 194 |
cafesys.get_menu_id_by_menu_name(text) RETURNS integer |
frapid_db_user |
|
| 195 |
cafesys.get_modifier_detail_id(_item_id integer, _modifier_name text, _modifier_detail_name text) RETURNS bigint |
frapid_db_user |
|
| 196 |
cafesys.get_modifier_id_by_item_id_modifier_name(_item_id integer, _modifier_name text) RETURNS integer |
frapid_db_user |
|
| 197 |
cafesys.get_modifier_id_by_modifier_code(text) RETURNS integer |
frapid_db_user |
|
| 198 |
cafesys.get_modifier_id_by_modifier_name(text) RETURNS integer |
frapid_db_user |
|
| 199 |
finance.get_month_end_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 200 |
finance.get_month_start_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 201 |
cinesys.get_movie_id_by_show_id(_show_id bigint) RETURNS integer |
frapid_db_user |
|
| 202 |
core.get_my_notifications(_login_id bigint) RETURNS TABLE(notification_id uuid, associated_app character varying, associated_menu_id integer, url character varying, formatted_text character varying, icon character varying, seen boolean, event_date timestamp with time zone) |
frapid_db_user |
|
| 203 |
helpdesk.get_my_unreplied_message_ids(_user_id integer) RETURNS SETOF bigint |
frapid_db_user |
|
| 204 |
helpdesk.get_name_by_user_id(_user_id integer) RETURNS text |
frapid_db_user |
|
| 205 |
account.get_name_by_user_id(_user_id integer) RETURNS character varying |
frapid_db_user |
|
| 206 |
finance.get_net_profit(_date_from date, _date_to date, _office_id integer, _factor integer, _no_provison boolean DEFAULT false) RETURNS numeric |
frapid_db_user |
|
| 207 |
finance.get_new_transaction_counter(date) RETURNS integer |
frapid_db_user |
|
| 208 |
cinesys.get_next_show_info(_screen_id integer, _movie_id bigint) RETURNS TABLE(show_id bigint, show_time integer) |
frapid_db_user |
|
| 209 |
social.get_next_top_feeds(_user_id integer, _last_feed_id bigint, _parent_feed_id bigint) RETURNS TABLE(row_number bigint, feed_id bigint, event_timestamp timestamp with time zone, audit_ts timestamp with time zone, formatted_text character varying, created_by integer, created_by_name character varying, attachments text, scope character varying, is_public boolean, parent_feed_id bigint, child_count bigint) |
frapid_db_user |
|
| 210 |
core.get_office_code_by_office_id(_office_id integer) RETURNS character varying |
frapid_db_user |
|
| 211 |
finance.get_office_id_by_cash_repository_id(integer) RETURNS integer |
frapid_db_user |
|
| 212 |
account.get_office_id_by_login_id(_login_id bigint) RETURNS integer |
frapid_db_user |
|
| 213 |
core.get_office_id_by_office_name(_office_name text) RETURNS integer |
frapid_db_user |
|
| 214 |
cinesys.get_office_id_by_screen_id(_screen_id integer) RETURNS integer |
frapid_db_user |
|
| 215 |
inventory.get_office_id_by_store_id(integer) RETURNS integer |
frapid_db_user |
|
| 216 |
core.get_office_ids(root_office_id integer) RETURNS SETOF integer |
frapid_db_user |
|
| 217 |
core.get_office_name_by_office_id(_office_id integer) RETURNS text |
frapid_db_user |
|
| 218 |
inventory.get_opening_inventory_status(_office_id integer) RETURNS TABLE(office_id integer, multiple_inventory_allowed boolean, has_opening_inventory boolean) |
frapid_db_user |
|
| 219 |
production.get_order_action_id_by_order_action_code(_order_action_code character varying) RETURNS integer |
frapid_db_user |
|
| 220 |
production.get_order_status_id_by_order_status_code(_kanban_code character varying) RETURNS integer |
frapid_db_user |
|
| 221 |
sales.get_order_view(_user_id integer, _office_id integer, _customer character varying, _from date, _to date, _expected_from date, _expected_to date, _id bigint, _reference_number character varying, _internal_memo character varying, _terms character varying, _posted_by character varying, _office character varying) RETURNS TABLE(id bigint, customer character varying, value_date date, expected_date date, reference_number character varying, terms character varying, internal_memo character varying, posted_by character varying, office character varying, transaction_ts timestamp with time zone) |
frapid_db_user |
|
| 222 |
purchase.get_order_view(_user_id integer, _office_id integer, _supplier character varying, _from date, _to date, _expected_from date, _expected_to date, _id bigint, _reference_number character varying, _internal_memo character varying, _terms character varying, _posted_by character varying, _office character varying) RETURNS TABLE(id bigint, supplier character varying, value_date date, expected_date date, reference_number character varying, terms character varying, internal_memo character varying, posted_by character varying, office character varying, transaction_ts timestamp with time zone) |
frapid_db_user |
|
| 223 |
helpdesk.get_participants(_knowledgebase_request_id bigint) RETURNS TABLE(user_id integer, email text, name text) |
frapid_db_user |
|
| 224 |
sales.get_payable_account_for_gift_card(_gift_card_id integer) RETURNS integer |
frapid_db_user |
|
| 225 |
sales.get_payable_account_id_by_gift_card_id(_gift_card_id integer) RETURNS integer |
frapid_db_user |
|
| 226 |
finance.get_periods(_date_from date, _date_to date) RETURNS finance.period[] |
frapid_db_user |
|
| 227 |
production.get_plant_id_by_plant_code(_plant_code character varying) RETURNS integer |
frapid_db_user |
|
| 228 |
cafesys.get_pos_area_id_by_pos_area_code(text) RETURNS integer |
frapid_db_user |
|
| 229 |
cafesys.get_pos_area_id_by_pos_area_name(text) RETURNS integer |
frapid_db_user |
|
| 230 |
forums.get_posts_by_me(_me integer, _limit integer, _offset integer) RETURNS TABLE(id integer, topic_id bigint, subject text, created_on timestamp with time zone, icon text, locked boolean, resolved boolean, resolved_by_user_id integer, resolved_by_user_name text, resolved_by_user_email text, created_by_user_id integer, created_by_user_name text, created_by_user_email text, replies bigint, post_id bigint, post_title text, post_message_bbcode text, post_message_markdown text, post_icon text, post_locked boolean, poster_id integer, poster_name text, poster_email text, posted_on timestamp with time zone, total_pages integer) |
frapid_db_user |
|
| 231 |
purchase.get_price_type_id_by_price_type_code(_price_type_code character varying) RETURNS integer |
frapid_db_user |
|
| 232 |
purchase.get_price_type_id_by_price_type_name(_price_type_name character varying) RETURNS integer |
frapid_db_user |
|
| 233 |
helpdesk.get_product_name_by_product_id(_product_id integer) RETURNS text |
frapid_db_user |
|
| 234 |
finance.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 |
frapid_db_user |
|
| 235 |
inventory.get_purchase_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 236 |
inventory.get_purchase_discount_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 237 |
finance.get_quarter_end_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 238 |
finance.get_quarter_start_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 239 |
helpdesk.get_question_stats() RETURNS TABLE(total_views bigint, total_questions bigint, total_answered bigint, total_accepted bigint) |
frapid_db_user |
|
| 240 |
sales.get_quotation_view(_user_id integer, _office_id integer, _customer character varying, _from date, _to date, _expected_from date, _expected_to date, _id bigint, _reference_number character varying, _internal_memo character varying, _terms character varying, _posted_by character varying, _office character varying) RETURNS TABLE(id bigint, customer character varying, value_date date, expected_date date, reference_number character varying, terms character varying, internal_memo character varying, posted_by character varying, office character varying, transaction_ts timestamp with time zone) |
frapid_db_user |
|
| 241 |
purchase.get_quotation_view(_user_id integer, _office_id integer, _supplier character varying, _from date, _to date, _expected_from date, _expected_to date, _id bigint, _reference_number character varying, _internal_memo character varying, _terms character varying, _posted_by character varying, _office character varying) RETURNS TABLE(id bigint, supplier character varying, value_date date, expected_date date, reference_number character varying, terms character varying, internal_memo character varying, posted_by character varying, office character varying, transaction_ts timestamp with time zone) |
frapid_db_user |
|
| 242 |
forums.get_rank(total_posts bigint) RETURNS text |
frapid_db_user |
|
| 243 |
forums.get_rank_by_user_id(_user_id integer) RETURNS text |
frapid_db_user |
|
| 244 |
forums.get_rank_id_by_posts(total_posts bigint) RETURNS integer |
frapid_db_user |
|
| 245 |
forums.get_rank_id_by_user_id(_user_id integer) RETURNS integer |
frapid_db_user |
|
| 246 |
production.get_raw_material_details(order_id_ bigint) RETURNS TABLE(raw_material_store_id integer, work_in_progress_store_id integer, bom_name character varying, item_id integer, unit_id integer, quantity integer_strict, rate money_strict2, amount money_strict2) |
frapid_db_user |
|
| 247 |
sales.get_receivable_account_for_check_receipts(_store_id integer) RETURNS integer |
frapid_db_user |
|
| 248 |
account.get_registration_office_id() RETURNS integer |
frapid_db_user |
|
| 249 |
account.get_registration_role_id(_email text) RETURNS integer |
frapid_db_user |
|
| 250 |
finance.get_retained_earnings(_date_to date, _office_id integer, _factor integer) RETURNS numeric |
frapid_db_user |
|
| 251 |
finance.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) |
frapid_db_user |
|
| 252 |
account.get_role_name_by_role_id(_role_id integer) RETURNS character varying |
frapid_db_user |
|
| 253 |
finance.get_root_account_id(_account_id integer, _parent integer DEFAULT 0) RETURNS integer |
frapid_db_user |
|
| 254 |
social.get_root_feed_id(_feed_id bigint) RETURNS bigint |
frapid_db_user |
|
| 255 |
inventory.get_root_unit_id(_any_unit_id integer) RETURNS integer |
frapid_db_user |
|
| 256 |
production.get_routing_id_by_routing_code(routing_id_ character varying) RETURNS integer |
frapid_db_user |
|
| 257 |
inventory.get_sales_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 258 |
inventory.get_sales_discount_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 259 |
inventory.get_sales_return_account_id(_item_id integer) RETURNS integer |
frapid_db_user |
|
| 260 |
foodcourt.get_sales_summary(_user_id integer, _start_date date, _end_date date) RETURNS TABLE(counter_id integer, counter_code character varying, item_code character varying, item_name character varying, total_quantity bigint) |
frapid_db_user |
|
| 261 |
finance.get_sales_tax_account_id_by_office_id(_office_id integer) RETURNS integer |
frapid_db_user |
|
| 262 |
cinesys.get_screen_id_by_screen_code(_screen_code character varying) RETURNS integer |
frapid_db_user |
|
| 263 |
cinesys.get_screen_id_by_show_id(_show_id bigint) RETURNS integer |
frapid_db_user |
|
| 264 |
cinesys.get_seat_type_id_by_seat_type_code(_seat_type_code character varying) RETURNS integer |
frapid_db_user |
|
| 265 |
cinesys.get_seating_arrangement_info(_show_id bigint) RETURNS TABLE(seating_arrangement_id integer, seating_arrangement_code text, seating_arrangement_name text, row_order integer, seat_type_id integer, seat_type_code text, seat_type_name text, total_seats integer, passage_seat_position integer, price numeric) |
frapid_db_user |
|
| 266 |
finance.get_second_root_account_id(_account_id integer, _parent bigint DEFAULT 0) RETURNS integer |
frapid_db_user |
|
| 267 |
production.get_sequence_completion_datetime(_manufacturing_id bigint, _routing_sequence_id integer) RETURNS timestamp without time zone |
frapid_db_user |
|
| 268 |
production.get_sequence_running_total_time(_manufacturing_id bigint, _routing_sequence_id integer) RETURNS integer |
frapid_db_user |
|
| 269 |
config.get_server_timezone() RETURNS character varying |
frapid_db_user |
|
| 270 |
cinesys.get_server_timezone() RETURNS text |
frapid_db_user |
|
| 271 |
inventory.get_shipper_id_by_shipper_code(_shipper_code character varying) RETURNS integer |
frapid_db_user |
|
| 272 |
inventory.get_shipper_id_by_shipper_name(_shipper_name character varying) RETURNS integer |
frapid_db_user |
|
| 273 |
cinesys.get_show_info(_show_id bigint) RETURNS TABLE(screen_id integer, screen_code character varying, screen_name character varying, office_id character varying, show_id integer, show_code character varying, show_name character varying, show_date date, start_hour smallint, start_minute smallint, regular_ticket_charge numeric, movie_id bigint, movie_code character varying, movie_name character varying, title character varying, also_known_as character varying, short_name character varying, banner character varying, is_foreign_movie boolean, movie_rating_id integer, movie_rating_code character varying, movie_rating_name character varying, movie_category_id integer, movie_category_code character varying, movie_category_name character varying, genre_id integer, genre_code character varying, genre_name character varying, storyline character varying, is_adult boolean, release_date date, distributor_id integer, distributor_code character varying, distributor_name character varying, production_company character varying, countries character varying, original_language character varying, audio_language character varying, runtime_in_minutes character varying, writers character varying, producers character varying, directors character varying, stars character varying, official_website character varying) |
frapid_db_user |
|
| 274 |
forums.get_statistics() RETURNS TABLE(total_categories bigint, total_topics bigint, total_posts bigint, registered_users bigint, newest_user_id integer, newest_user_name text, newest_user_email text) |
frapid_db_user |
|
| 275 |
inventory.get_store_id_by_store_code(_store_code text) RETURNS integer |
frapid_db_user |
|
| 276 |
inventory.get_store_id_by_store_name(_store_name text) RETURNS integer |
frapid_db_user |
|
| 277 |
inventory.get_store_name_by_store_id(integer) RETURNS text |
frapid_db_user |
|
| 278 |
inventory.get_store_type_id_by_store_type_code(text) RETURNS integer |
frapid_db_user |
|
| 279 |
inventory.get_supplier_id_by_supplier_code(text) RETURNS integer |
frapid_db_user |
|
| 280 |
purchase.get_supplier_id_by_supplier_code(text) RETURNS bigint |
frapid_db_user |
|
| 281 |
inventory.get_supplier_name_by_supplier_id(_supplier_id integer) RETURNS character varying |
frapid_db_user |
|
| 282 |
inventory.get_supplier_type_id_by_supplier_type_code(text) RETURNS integer |
frapid_db_user |
|
| 283 |
cinesys.get_ticket_price(_show_id bigint, _seat_type_id integer) RETURNS numeric |
frapid_db_user |
|
| 284 |
helpdesk.get_ticket_priority_name_by_ticket_priority_id(_ticket_priority_id integer) RETURNS text |
frapid_db_user |
|
| 285 |
sales.get_top_selling_products_of_all_time(_office_id integer) RETURNS TABLE(id integer, item_id integer, item_code text, item_name text, total_sales numeric) |
frapid_db_user |
|
| 286 |
forums.get_topic_breadcrumb(_topic_id bigint) RETURNS TABLE(id bigint, name text, alias text, level integer) |
frapid_db_user |
|
| 287 |
forums.get_topic_subscriber_emails(_topic_id bigint) RETURNS text |
frapid_db_user |
|
| 288 |
inventory.get_total_customer_due(office_id integer, customer_id integer) RETURNS numeric |
frapid_db_user |
|
| 289 |
production.get_total_expenses(_manufacturing_id bigint) RETURNS numeric |
frapid_db_user |
|
| 290 |
finance.get_transaction_code(value_date date, office_id integer, user_id integer, login_id bigint) RETURNS text |
frapid_db_user |
|
| 291 |
finance.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) |
frapid_db_user |
|
| 292 |
inventory.get_unit_id_by_unit_code(text) RETURNS integer |
frapid_db_user |
|
| 293 |
inventory.get_unit_id_by_unit_name(_unit_name text) RETURNS integer |
frapid_db_user |
|
| 294 |
inventory.get_unit_name_by_unit_id(_unit_id integer) RETURNS character varying |
frapid_db_user |
|
| 295 |
account.get_user_id_by_email(_email character varying) RETURNS integer |
frapid_db_user |
|
| 296 |
config.get_user_id_by_login_id(_login_id bigint) RETURNS integer |
frapid_db_user |
|
| 297 |
account.get_user_id_by_login_id(_login_id bigint) RETURNS integer |
frapid_db_user |
|
| 298 |
auth.get_user_menu_policy(_user_id integer, _office_id integer) RETURNS TABLE(row_number integer, menu_id integer, app_name text, app_i18n_key text, menu_name text, i18n_key text, allowed boolean, disallowed boolean, url text, sort integer, icon character varying, parent_menu_id integer) |
frapid_db_user |
|
| 299 |
finance.get_value_date(_office_id integer) RETURNS date |
frapid_db_user |
|
| 300 |
finance.get_verification_status_name_by_verification_status_id(_verification_status_id integer) RETURNS text |
frapid_db_user |
|
| 301 |
production.get_wip_details(_manufacturing_id bigint) RETURNS TABLE(title character varying, item_name character varying, store_name character varying, debit numeric, credit numeric) |
frapid_db_user |
|
| 302 |
production.get_work_center_department_id_by_work_center_department_code(_work_center_department_code character varying) RETURNS integer |
frapid_db_user |
|
| 303 |
production.get_work_center_id_by_work_center_code(_work_center_code character varying) RETURNS integer |
frapid_db_user |
|
| 304 |
inventory.get_write_off_cost_of_goods_sold(_checkout_id bigint, _item_id integer, _unit_id integer, _quantity integer) RETURNS money_strict2 |
frapid_db_user |
|
| 305 |
account.google_sign_in(_email text, _office_id integer, _name text, _token text, _browser text, _ip_address text, _culture text) RETURNS TABLE(login_id bigint, status boolean, message text) |
frapid_db_user |
|
| 306 |
account.google_user_exists(_user_id integer) RETURNS boolean |
frapid_db_user |
|
| 307 |
auth.has_access(_login_id bigint, _entity text, _access_type_id integer) RETURNS boolean |
frapid_db_user |
|
| 308 |
account.has_account(_email character varying) RETURNS boolean |
frapid_db_user |
|
| 309 |
account.has_active_reset_request(_email text) RETURNS boolean |
frapid_db_user |
|
| 310 |
finance.has_child_accounts(bigint) RETURNS boolean |
frapid_db_user |
|
| 311 |
finance.initialize_eod_operation(_user_id integer, _office_id integer, _value_date date) RETURNS void |
frapid_db_user |
|
| 312 |
account.is_admin(_user_id integer) RETURNS boolean |
frapid_db_user |
|
| 313 |
finance.is_cash_account_id(_account_id integer) RETURNS boolean |
frapid_db_user |
|
| 314 |
finance.is_eod_initialized(_office_id integer, _value_date date) RETURNS boolean |
frapid_db_user |
|
| 315 |
finance.is_new_day_started(_office_id integer) RETURNS boolean |
frapid_db_user |
|
| 316 |
finance.is_normally_debit(_account_id integer) RETURNS boolean |
frapid_db_user |
|
| 317 |
inventory.is_parent_unit(parent integer, child integer) RETURNS boolean |
frapid_db_user |
|
| 318 |
inventory.is_periodic_inventory(_office_id integer) RETURNS boolean |
frapid_db_user |
|
| 319 |
finance.is_periodic_inventory(_office_id integer) RETURNS boolean |
frapid_db_user |
|
| 320 |
inventory.is_purchase(_transaction_master_id bigint) RETURNS boolean |
frapid_db_user |
|
| 321 |
finance.is_restricted_mode() RETURNS boolean |
frapid_db_user |
|
| 322 |
account.is_restricted_user(_email character varying) RETURNS boolean |
frapid_db_user |
|
| 323 |
finance.is_transaction_restricted(_office_id integer) RETURNS boolean |
frapid_db_user |
|
| 324 |
account.is_valid_client_token(_client_token text, _ip_address text, _user_agent text) RETURNS boolean |
frapid_db_user |
|
| 325 |
account.is_valid_login_id(bigint) RETURNS boolean |
frapid_db_user |
|
| 326 |
core.is_valid_office_id(integer) RETURNS boolean |
frapid_db_user |
|
| 327 |
inventory.is_valid_unit_id(_unit_id integer, _item_id integer) RETURNS boolean |
frapid_db_user |
|
| 328 |
social.like(_user_id integer, _feed_id bigint) RETURNS void |
frapid_db_user |
|
| 329 |
forums.list_categories(_category_id integer) RETURNS TABLE(category_id integer, category_name character varying, category_alias character varying, description text, locked boolean, icon character varying, total_topics bigint, total_posts bigint, last_topic_id bigint, last_post_id bigint, is_root boolean, last_topic_subject character varying, last_topic_first_post_id bigint, last_topic_created_by_user_id integer, last_topic_created_on timestamp with time zone, last_topic_locked boolean, last_topic_resolved boolean, last_topic_resolved_by_user_id integer, last_post_title character varying, last_post_message_bbcode text, last_post_message_markdown text, last_post_icon character varying, last_post_locked boolean, last_post_user_id integer, last_post_on timestamp with time zone, last_topic_message_bbcode text, last_topic_message_markdown text, last_topic_created_by_user_name character varying, last_topic_created_by_user_email character varying, last_topic_resolved_by_user_name character varying, last_topic_resolved_by_user_email character varying, last_post_user_name character varying, last_post_user_email character varying, last_post_is_topic boolean) |
frapid_db_user |
|
| 330 |
inventory.list_closing_stock(_store_id integer) RETURNS TABLE(item_id integer, item_code text, item_name text, unit_id integer, unit_name text, quantity numeric) |
frapid_db_user |
|
| 331 |
forums.list_posts(_topic_id bigint, _limit integer, _offset integer) RETURNS TABLE(id integer, post_id integer, title text, message_bbcode text, message_markdown text, ip_address text, browser text, country text, icon text, posted_on timestamp with time zone, poster_id integer, poster_name text, poster_email text, poster_posts bigint, poster_rank text, poster_thank_yous bigint, thanked_by text, poster_signature text, poster_joined_on date, locked boolean, is_question boolean, is_answer boolean, can_delete boolean, total_pages integer) |
frapid_db_user |
|
| 332 |
forums.list_topics(_category_id integer, _limit integer, _offset integer) RETURNS TABLE(id integer, category_id integer, category_name text, topic_id bigint, first_post_id bigint, subject text, message_bbcode text, message_markdown text, created_on timestamp with time zone, icon text, locked boolean, hidden boolean, hits bigint, resolved boolean, resolved_by_user_id integer, resolved_by_user_name text, resolved_by_user_email text, created_by_user_id integer, created_by_user_name text, created_by_user_email text, replies bigint, last_post_id bigint, last_post_title text, last_post_message_bbcode text, last_post_message_markdown text, last_post_icon text, last_post_locked boolean, last_post_user_id integer, last_post_user_name text, last_post_user_email text, last_post_on timestamp with time zone, total_pages integer) |
frapid_db_user |
|
| 333 |
core.mark_notification_as_seen(_notification_id uuid, _user_id integer) RETURNS void |
frapid_db_user |
|
| 334 |
helpdesk.my_departments(_user_id integer) RETURNS SETOF integer |
frapid_db_user |
|
| 335 |
public.parse_default(text) RETURNS text |
frapid_db_user |
|
| 336 |
finance.perform_eod_operation(_login_id bigint) RETURNS boolean |
frapid_db_user |
|
| 337 |
finance.perform_eod_operation(_user_id integer, _login_id bigint, _office_id integer, _value_date date) RETURNS boolean |
frapid_db_user |
|
| 338 |
public.poco_get_table_function_annotation(_schema_name text, _table_name text) RETURNS TABLE(id integer, column_name text, nullable text, db_data_type text, value text, max_length integer, primary_key text) |
frapid_db_user |
|
| 339 |
public.poco_get_table_function_definition(_schema character varying, _name character varying) RETURNS TABLE(id bigint, column_name text, nullable text, db_data_type text, value text, max_length integer, primary_key text, data_type text) |
frapid_db_user |
|
| 340 |
public.poco_get_tables(_schema text) RETURNS TABLE(table_schema name, table_name name, table_type text, has_duplicate boolean) |
frapid_db_user |
|
| 341 |
inventory.post_adjustment(_office_id integer, _user_id integer, _login_id bigint, _store_id integer, _value_date date, _book_date date, _reference_number character varying, _statement_reference text, _details inventory.adjustment_type[]) RETURNS bigint |
frapid_db_user |
|
| 342 |
sales.post_cash_receipt(_user_id integer, _office_id integer, _login_id bigint, _customer_id integer, _customer_account_id integer, _currency_code character varying, _local_currency_code character varying, _base_currency_code character varying, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference character varying, _cost_center_id integer, _cash_account_id integer, _cash_repository_id integer, _value_date date, _book_date date, _receivable money_strict2, _tender money_strict2, _change money_strict2, _cascading_tran_id bigint) RETURNS bigint |
frapid_db_user |
|
| 343 |
sales.post_check_receipt(_user_id integer, _office_id integer, _login_id bigint, _customer_id integer, _customer_account_id integer, _receivable_account_id integer, _currency_code character varying, _local_currency_code character varying, _base_currency_code character varying, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference character varying, _cost_center_id integer, _value_date date, _book_date date, _check_amount money_strict2, _check_bank_name character varying, _check_number character varying, _check_date date, _cascading_tran_id bigint) RETURNS bigint |
frapid_db_user |
|
| 344 |
sales.post_customer_receipt(_user_id integer, _office_id integer, _login_id bigint, _customer_id integer, _currency_code character varying, _cash_account_id integer, _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, _payment_card_id integer, _bank_instrument_code character varying, _bank_tran_code character varying) RETURNS bigint |
frapid_db_user |
|
| 345 |
production.post_inventory_transaction(_login_id bigint, _order_id integer, _value_date date, _details inventory.transfer_type[], _reference_number character varying) RETURNS bigint |
frapid_db_user |
|
| 346 |
sales.post_late_fee(_user_id integer, _login_id bigint, _office_id integer, _value_date date) RETURNS void |
frapid_db_user |
|
| 347 |
inventory.post_opening_inventory(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _book_date date, _reference_number character varying, _statement_reference text, _details inventory.opening_stock_type[]) RETURNS bigint |
frapid_db_user |
|
| 348 |
purchase.post_purchase(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _book_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _supplier_id integer, _price_type_id integer, _shipper_id integer, _details purchase.purchase_detail_type[]) RETURNS bigint |
frapid_db_user |
|
| 349 |
sales.post_receipt(_user_id integer, _office_id integer, _login_id bigint, _customer_id integer, _currency_code character varying, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference text, _cost_center_id integer, _cash_account_id integer, _cash_repository_id integer, _value_date date, _book_date date, _receipt_amount money_strict, _tender money_strict2, _change money_strict2, _check_amount money_strict2, _check_bank_name character varying, _check_number character varying, _check_date date, _gift_card_number character varying, _store_id integer DEFAULT NULL::integer, _cascading_tran_id bigint DEFAULT NULL::bigint) RETURNS bigint |
frapid_db_user |
|
| 350 |
sales.post_receipt_by_gift_card(_user_id integer, _office_id integer, _login_id bigint, _customer_id integer, _customer_account_id integer, _currency_code character varying, _local_currency_code character varying, _base_currency_code character varying, _exchange_rate_debit decimal_strict, _exchange_rate_credit decimal_strict, _reference_number character varying, _statement_reference character varying, _cost_center_id integer, _value_date date, _book_date date, _gift_card_id integer, _gift_card_number character varying, _amount money_strict, _cascading_tran_id bigint) RETURNS bigint |
frapid_db_user |
|
| 351 |
sales.post_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _book_date date, _store_id integer, _counter_id integer, _customer_id integer, _price_type_id integer, _reference_number character varying, _statement_reference text, _details sales.sales_detail_type[]) RETURNS bigint |
frapid_db_user |
|
| 352 |
purchase.post_return(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _value_date date, _book_date date, _cost_center_id integer, _supplier_id integer, _price_type_id integer, _shipper_id integer, _reference_number character varying, _statement_reference text, _details purchase.purchase_detail_type[]) RETURNS bigint |
frapid_db_user |
|
| 353 |
sales.post_sales(_office_id integer, _user_id integer, _login_id bigint, _counter_id integer, _value_date date, _book_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _tender money_strict2, _change money_strict2, _payment_term_id integer, _check_amount money_strict2, _check_bank_name character varying, _check_number character varying, _check_date date, _gift_card_number character varying, _customer_id integer, _price_type_id integer, _shipper_id integer, _store_id integer, _coupon_code character varying, _is_flat_discount boolean, _discount money_strict2, _details sales.sales_detail_type[], _sales_quotation_id bigint, _sales_order_id bigint) RETURNS bigint |
frapid_db_user |
|
| 354 |
cafesys.post_sales(_checkout_id bigint, _office_id integer, _user_id integer, _login_id bigint) RETURNS bigint |
frapid_db_user |
|
| 355 |
ird.post_sales(_office_id integer, _user_id integer, _login_id bigint, _counter_id integer, _value_date date, _book_date date, _cost_center_id integer, _reference_number character varying, _statement_reference text, _tender money_strict2, _change money_strict2, _payment_term_id integer, _check_amount money_strict2, _check_bank_name character varying, _check_number character varying, _check_date date, _gift_card_number character varying, _customer_id integer, _price_type_id integer, _shipper_id integer, _store_id integer, _coupon_code character varying, _is_flat_discount boolean, _discount money_strict2, _details sales.sales_detail_type[], _sales_quotation_id bigint, _sales_order_id bigint) RETURNS bigint |
frapid_db_user |
|
| 356 |
inventory.post_transfer(_office_id integer, _user_id integer, _login_id bigint, _value_date date, _book_date date, _reference_number character varying, _statement_reference text, _details inventory.transfer_type[]) RETURNS bigint |
frapid_db_user |
|
| 357 |
finance.reconcile_account(_transaction_detail_id bigint, _user_id integer, _new_book_date date, _reconciliation_memo text) RETURNS void |
frapid_db_user |
|
| 358 |
sales.refresh_materialized_views(_user_id integer, _login_id bigint, _office_id integer, _value_date date) RETURNS void |
frapid_db_user |
|
| 359 |
website.remove_email_subscription(_email text) RETURNS boolean |
frapid_db_user |
|
| 360 |
account.reset_account(_email text, _browser text, _ip_address text) RETURNS SETOF account.reset_requests |
frapid_db_user |
|
| 361 |
auth.save_api_group_policy(_role_id integer, _entity_name character varying, _office_id integer, _access_type_ids integer[], _allow_access boolean) RETURNS void |
frapid_db_user |
|
| 362 |
auth.save_group_menu_policy(_role_id integer, _office_id integer, _menus text, _app_name text) RETURNS void |
frapid_db_user |
|
| 363 |
auth.save_user_menu_policy(_user_id integer, _office_id integer, _allowed text, _disallowed text) RETURNS void |
frapid_db_user |
|
| 364 |
forums.search_topics(_like character varying, _user integer, _limit integer, _offset integer) RETURNS TABLE(id integer, topic_id bigint, subject text, created_on timestamp with time zone, icon text, locked boolean, resolved boolean, resolved_by_user_id integer, resolved_by_user_name text, resolved_by_user_email text, created_by_user_id integer, created_by_user_name text, created_by_user_email text, replies bigint, post_id bigint, post_title text, post_message_bbcode text, post_message_markdown text, post_icon text, post_locked boolean, poster_id integer, poster_name text, poster_email text, posted_on timestamp with time zone, total_pages integer) |
frapid_db_user |
|
| 365 |
forums.set_answer(_topic_id bigint, _post_id bigint, _user_id integer) RETURNS void |
frapid_db_user |
|
| 366 |
cafesys.set_area_diagram(_office_id integer, _user_id integer, _login_id bigint, _pos_area_id integer, _details cafesys.area_diagram_type[]) RETURNS void |
frapid_db_user |
|
| 367 |
sales.settle_customer_due(_customer_id integer, _office_id integer) RETURNS void |
frapid_db_user |
|
| 368 |
account.sign_in(_email text, _office_id integer, _browser text, _ip_address text, _culture text) RETURNS TABLE(login_id bigint, status boolean, message text) |
frapid_db_user |
|
| 369 |
production.start_manufacturing(_user_id integer, _login_id bigint, _order_id bigint, _start_date timestamp without time zone, _reference_number character varying, _description text) RETURNS TABLE(order_id bigint, tran_id bigint, manufacturing_id bigint, started_on timestamp without time zone, started_by integer, started_by_name character varying, description character varying, bom_id integer, bom_name character varying, routing_id integer, routing_name character varying, managed_by integer, supervised_by integer, total_minutes integer) |
frapid_db_user |
|
| 370 |
public.text_to_bigint(text) RETURNS bigint |
frapid_db_user |
|
| 371 |
public.text_to_int_array(_input text, _remove_nulls boolean DEFAULT true) RETURNS integer[] |
frapid_db_user |
|
| 372 |
helpdesk.unfollow_question(_user_id integer, _knowledgebase_request_id bigint, _browser character varying, _ip_address character varying, _user_agent character varying, _country character varying) RETURNS boolean |
frapid_db_user |
|
| 373 |
social.unlike(_user_id integer, _feed_id bigint) RETURNS void |
frapid_db_user |
|
| 374 |
cafesys.update_table(_checkout_detail_ids bigint[], _new_table_id integer) RETURNS void |
frapid_db_user |
|
| 375 |
account.user_exists(_email character varying) RETURNS boolean |
frapid_db_user |
|
| 376 |
sales.validate_items_for_return(_transaction_master_id bigint, _details sales.sales_detail_type[]) RETURNS boolean |
frapid_db_user |
|
| 377 |
cinesys.validate_pin_and_login(_user_id integer, _counter_code character varying, _cashier_code character varying, _pin character varying, _browser character varying DEFAULT ''::character varying, _ip_address character varying DEFAULT ''::character varying, _user_agent character varying DEFAULT ''::character varying) RETURNS boolean |
frapid_db_user |
|
| 378 |
foodcourt.validate_pin_and_login(_user_id integer, _counter_code character varying, _cashier_code character varying, _pin character varying, _browser character varying DEFAULT ''::character varying, _ip_address character varying DEFAULT ''::character varying, _user_agent character varying DEFAULT ''::character varying) RETURNS boolean |
frapid_db_user |
|
| 379 |
gatekeeper.validate_pin_and_login(_user_id integer, _terminal_code character varying, _access_code character varying, _pin character varying, _browser character varying DEFAULT ''::character varying, _ip_address character varying DEFAULT ''::character varying, _user_agent character varying DEFAULT ''::character varying) RETURNS boolean |
frapid_db_user |
|
| 380 |
finance.verify_transaction(_transaction_master_id bigint, _office_id integer, _user_id integer, _login_id bigint, _verification_status_id smallint, _reason character varying) RETURNS bigint |
frapid_db_user |
|
| 381 |
helpdesk.vote(_user_id integer, _knowledgebase_request_id bigint, _vote integer, _browser text, _ip_address text, _user_agent text, _country text) RETURNS bigint |
frapid_db_user |
|