MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types

Schema "core"

Tables

# Table Name Owner Tablespace Description
1 account_masters postgres DEFAULT This table contains categories in which General Ledger (G.L) Account belongs to & collectively they form the Chart of Accounts. The category in this table cannot be edited by users. Thus, a user-interface for this table is not available. This table facilitates creating useful reports such as Profit & Loss A/c. and Balance Sheet.
2 accounts postgres DEFAULT This table stores information on General Ledger (G.L) Account.
3 ageing_slabs postgres DEFAULT
4 attachment_lookup postgres DEFAULT
5 attachments postgres DEFAULT
6 bank_accounts postgres DEFAULT This table stores information on various Bank A/cs and other associated information.
7 bonus_slab_details postgres DEFAULT This table stores information on various rate of bonus.
8 bonus_slabs postgres DEFAULT This table stores information on bonus slabs.
9 brands postgres DEFAULT This table stores information on various brands the entity is dealing.
10 cash_flow_headings postgres DEFAULT This table stores information on various categories in the Cash Flow Statement.
11 cash_flow_setup postgres DEFAULT
12 compound_item_details postgres DEFAULT This table stores information on compound item and combination of items which composites compound item.
13 compound_items postgres DEFAULT This table stores information on combination on compund items and other associated information to it.
14 compound_units postgres DEFAULT This table stores information on the units, value of the items that forms the compound items.
15 config postgres DEFAULT
16 counties postgres DEFAULT This table stores information on counties, their code, the state they belong etc.
17 countries postgres DEFAULT This table stores information on list of countries and their their code.
18 county_sales_taxes postgres DEFAULT This table stores information on sales tax of the county.
19 currencies postgres DEFAULT This table stores information on currency.
20 entities postgres DEFAULT List of entities.
21 exchange_rate_details postgres DEFAULT Details on exchange rate.
22 exchange_rates postgres DEFAULT Update exchange rates.
23 fiscal_year postgres DEFAULT Information on fiscal year.
24 flag_types postgres DEFAULT Mark rows of a table with difernt color, so that viewing is easier.
25 flags postgres DEFAULT Flags are used by users to mark transactions. The flags created by a user is not visible to others.
26 frequencies postgres DEFAULT Interval of time for posting a transaction.
27 frequency_setups postgres DEFAULT Setup time interval of posting a transaction automatically.
28 income_tax_setup postgres DEFAULT Tax setup.
29 industries postgres DEFAULT Details on industry the firm belongs.
30 item_cost_prices postgres DEFAULT This table stores information on cost price of a item and other associated informations.
31 item_groups postgres DEFAULT
32 item_opening_inventory postgres DEFAULT This table stores information on opening inventory and other associated information.
33 item_selling_prices postgres DEFAULT This table stores information on selling price of an item and other information. PLEASE NOTE : THESE ARE THE MOST EFFECTIVE STOCK ITEM PRICES. THE PRICE IN THIS CATALOG IS ACTUALLY PICKED UP AT THE TIME OF PURCHASE AND SALES. A STOCK ITEM PRICE MAY BE DIFFERENT FOR DIFFERENT UNITS. FURTHER, A STOCK ITEM WOULD BE SOLD AT A HIGHER PRICE WHEN SOLD LOOSE THAN WHAT IT WOULD ACTUALLY COST IN A COMPOUND UNIT. EXAMPLE, ONE CARTOON (20 BOTTLES) OF BEER BOUGHT AS A UNIT WOULD COST 25% LESS FROM THE SAME STORE.
34 item_types postgres DEFAULT
35 items postgres DEFAULT This table stores information on items and other associated information.
36 late_fee postgres DEFAULT This table stores information on late fees and other associated information.
37 menu_locale postgres DEFAULT
38 menus postgres DEFAULT This table stores information on the easy to use menu of MixERP.
39 parties postgres DEFAULT This table stores information on parties and information associated with them.
40 party_types postgres DEFAULT This table stores information on types of parties and other infornation associated with it like weather a party is Agent/Customer/Dealer/Supplier..
41 payment_terms postgres DEFAULT This table stores information on terms of payment like due date, grace period and information associated with it.
42 price_types postgres DEFAULT
43 recurring_invoice_setup postgres DEFAULT
44 recurring_invoices postgres DEFAULT
45 rounding_methods postgres DEFAULT This table stores information on rounding off the amount.
46 sales_tax_details postgres DEFAULT This table stores information on sales tax and other information associated with it.
47 sales_tax_exempt_details postgres DEFAULT This table stores information on sales tax exemption and other information associated with it.
48 sales_tax_exempts postgres DEFAULT This table stores information on sales tax exemption and other information associated with it.
49 sales_tax_types postgres DEFAULT Type of sales tax and information associated with it.
50 sales_taxes postgres DEFAULT Details on sales tax.
51 sales_teams postgres DEFAULT Details on sales team.
52 salesperson_bonus_setups postgres DEFAULT Setup bonuses to salespersons.
53 salespersons postgres DEFAULT Details on sales person and other information associated with it.
54 shippers postgres DEFAULT Details on shippers (shipping company) and other information associated with it.
55 shipping_addresses postgres DEFAULT Details on shipping address and other information associated with it.
56 shipping_mail_types postgres DEFAULT Details on shipping mail type (Express, priority mail, parcel post etc.).
57 shipping_package_shapes postgres DEFAULT Details on shipping package and other information assiciated with it.
58 state_sales_taxes postgres DEFAULT Details on sales tax of the state in the U.S.A and other information associated with it.
59 states postgres DEFAULT Information on the states of the U.S.A.
60 tax_authorities postgres DEFAULT Details on tax authorities, its address and other information associated with it.
61 tax_base_amount_types postgres DEFAULT Information on various tax base that are applicable.
62 tax_exempt_types postgres DEFAULT Various kinds of tax exemptions that are applicable.
63 tax_master postgres DEFAULT Information on the applicable tax rates of various countries (tax master)supported by the software.
64 tax_rate_types postgres DEFAULT The code and the name given to various types tax rates (flat rate or percentage basis).
65 transaction_types postgres DEFAULT
66 units postgres DEFAULT Contains units of measure.
67 verification_statuses postgres DEFAULT Verification statuses are integer values used to represent the state of a transaction. For example, a verification status of value "0" would mean that the transaction has not yet been verified. A negative value indicates that the transaction was rejected, whereas a positive value means approved. Remember: 1. Only approved transactions appear on ledgers and final reports. 2. Cash repository balance is maintained on the basis of LIFO principle. This means that cash balance is affected (reduced) on your repository as soon as a credit transaction is posted, without the transaction being approved on the first place. If you reject the transaction, the cash balance then increases. This also means that the cash balance is not affected (increased) on your repository as soon as a debit transaction is posted. You will need to approve the transaction. It should however be noted that the cash repository balance might be less than the total cash shown on your balance sheet, if you have pending transactions to verify. You cannot perform EOD operation if you have pending verifications.
68 zip_code_types postgres DEFAULT Types of ZIP code.
69 zip_codes postgres DEFAULT This table stores information on the ZIP code.

Sequences

# Sequence Name Owner Data Type Start Value Increment Description
1 accounts_account_id_seq postgres bigint 1 1
2 ageing_slabs_ageing_slab_id_seq postgres bigint 1 1
3 attachment_lookup_attachment_lookup_id_seq postgres bigint 1 1
4 attachments_attachment_id_seq postgres bigint 1 1
5 bonus_slab_details_bonus_slab_detail_id_seq postgres bigint 1 1
6 bonus_slabs_bonus_slab_id_seq postgres bigint 1 1
7 brands_brand_id_seq postgres bigint 1 1
8 cash_flow_setup_cash_flow_setup_id_seq postgres bigint 1 1
9 compound_item_details_compound_item_detail_id_seq postgres bigint 1 1
10 compound_items_compound_item_id_seq postgres bigint 1 1
11 compound_units_compound_unit_id_seq postgres bigint 1 1
12 counties_county_id_seq postgres bigint 1 1
13 countries_country_id_seq postgres bigint 1 1
14 county_sales_taxes_county_sales_tax_id_seq postgres bigint 1 1
15 entities_entity_id_seq postgres bigint 1 1
16 exchange_rate_details_exchange_rate_detail_id_seq postgres bigint 1 1
17 exchange_rates_exchange_rate_id_seq postgres bigint 1 1
18 flag_types_flag_type_id_seq postgres bigint 1 1
19 flags_flag_id_seq postgres bigint 1 1
20 frequencies_frequency_id_seq postgres bigint 1 1
21 frequency_setups_frequency_setup_id_seq postgres bigint 1 1
22 income_tax_setup_income_tax_setup_id_seq postgres bigint 1 1
23 industries_industry_id_seq postgres bigint 1 1
24 item_cost_prices_item_cost_price_id_seq postgres bigint 1 1
25 item_groups_item_group_id_seq postgres bigint 1 1
26 item_opening_inventory_item_opening_inventory_id_seq postgres bigint 1 1
27 item_selling_prices_item_selling_price_id_seq postgres bigint 1 1
28 item_types_item_type_id_seq postgres bigint 1 1
29 items_item_id_seq postgres bigint 1 1
30 late_fee_late_fee_id_seq postgres bigint 1 1
31 menu_locale_menu_locale_id_seq postgres bigint 1 1
32 menus_menu_id_seq postgres bigint 1 1
33 parties_party_id_seq postgres bigint 1 1
34 party_types_party_type_id_seq postgres bigint 1 1
35 payment_terms_payment_term_id_seq postgres bigint 1 1
36 price_types_price_type_id_seq postgres bigint 1 1
37 recurring_invoice_setup_recurring_invoice_setup_id_seq postgres bigint 1 1
38 recurring_invoices_recurring_invoice_id_seq postgres bigint 1 1
39 sales_tax_details_sales_tax_detail_id_seq postgres bigint 1 1
40 sales_tax_exempt_details_sales_tax_exempt_detail_id_seq postgres bigint 1 1
41 sales_tax_exempts_sales_tax_exempt_id_seq postgres bigint 1 1
42 sales_tax_types_sales_tax_type_id_seq postgres bigint 1 1
43 sales_taxes_sales_tax_id_seq postgres bigint 1 1
44 sales_teams_sales_team_id_seq postgres bigint 1 1
45 salesperson_bonus_setups_salesperson_bonus_setup_id_seq postgres bigint 1 1
46 salespersons_salesperson_id_seq postgres bigint 1 1
47 shippers_shipper_id_seq postgres bigint 1 1
48 shipping_addresses_shipping_address_id_seq postgres bigint 1 1
49 shipping_mail_types_shipping_mail_type_id_seq postgres bigint 1 1
50 shipping_package_shapes_shipping_package_shape_id_seq postgres bigint 1 1
51 state_sales_taxes_state_sales_tax_id_seq postgres bigint 1 1
52 states_state_id_seq postgres bigint 1 1
53 tax_authorities_tax_authority_id_seq postgres bigint 1 1
54 tax_exempt_types_tax_exempt_type_id_seq postgres bigint 1 1
55 tax_master_tax_master_id_seq postgres bigint 1 1
56 units_unit_id_seq postgres bigint 1 1
57 zip_code_types_zip_code_type_id_seq postgres bigint 1 1
58 zip_codes_zip_code_id_seq postgres bigint 1 1

Views

# View Name Owner Tablespace Description
1 account_master_selector_view postgres DEFAULT
2 account_scrud_view postgres DEFAULT
3 account_selector_view postgres DEFAULT
4 account_view postgres DEFAULT
5 ageing_slab_scrud_view postgres DEFAULT
6 bank_account_view postgres DEFAULT
7 bonus_slab_detail_scrud_view postgres DEFAULT
8 bonus_slab_scrud_view postgres DEFAULT
9 bonus_slab_selector_view postgres DEFAULT
10 brand_scrud_view postgres DEFAULT
11 brand_selector_view postgres DEFAULT
12 cash_flow_heading_scrud_view postgres DEFAULT
13 cash_flow_setup_scrud_view postgres DEFAULT
14 compound_item_detail_scrud_view postgres DEFAULT
15 compound_item_scrud_view postgres DEFAULT
16 compound_item_selector_view postgres DEFAULT
17 compound_unit_scrud_view postgres DEFAULT
18 country_scrud_view postgres DEFAULT
19 county_sales_tax_scrud_view postgres DEFAULT
20 county_scrud_view postgres DEFAULT
21 currency_scrud_view postgres DEFAULT
22 currency_selector_view postgres DEFAULT
23 entity_scrud_view postgres DEFAULT
24 fiscal_year_scrud_view postgres DEFAULT
25 fiscal_year_selector_view postgres DEFAULT
26 flag_type_scrud_view postgres DEFAULT
27 frequency_selector_view postgres DEFAULT
28 frequency_setup_scrud_view postgres DEFAULT
29 industry_scrud_view postgres DEFAULT
30 item_cost_price_scrud_view postgres DEFAULT
31 item_group_scrud_view postgres DEFAULT
32 item_group_selector_view postgres DEFAULT
33 item_scrud_view postgres DEFAULT
34 item_selector_view postgres DEFAULT
35 item_selling_price_scrud_view postgres DEFAULT
36 item_type_scrud_view postgres DEFAULT
37 item_view postgres DEFAULT
38 late_fee_scrud_view postgres DEFAULT
39 party_scrud_view postgres DEFAULT
40 party_selector_view postgres DEFAULT
41 party_type_scrud_view postgres DEFAULT
42 party_type_selector_view postgres DEFAULT
43 party_user_control_view postgres DEFAULT
44 party_view postgres DEFAULT
45 payment_term_scrud_view postgres DEFAULT
46 price_type_selector_view postgres DEFAULT
47 recurring_invoice_scrud_view postgres DEFAULT
48 recurring_invoice_setup_scrud_view postgres DEFAULT
49 rounding_method_selector_view postgres DEFAULT
50 sales_tax_detail_scrud_view postgres DEFAULT
51 sales_tax_exempt_detail_scrud_view postgres DEFAULT
52 sales_tax_exempt_scrud_view postgres DEFAULT
53 sales_tax_scrud_view postgres DEFAULT
54 sales_tax_selector_view postgres DEFAULT
55 sales_tax_type_scrud_view postgres DEFAULT
56 sales_team_scrud_view postgres DEFAULT
57 sales_team_selector_view postgres DEFAULT
58 salesperson_bonus_setup_scrud_view postgres DEFAULT
59 salesperson_scrud_view postgres DEFAULT
60 salesperson_selector_view postgres DEFAULT
61 shipper_scrud_view postgres DEFAULT
62 shipping_address_scrud_view postgres DEFAULT
63 shipping_address_view postgres DEFAULT
64 shipping_mail_type_selector_view postgres DEFAULT
65 shipping_package_shape_selector_view postgres DEFAULT
66 state_sales_tax_scrud_view postgres DEFAULT
67 state_scrud_view postgres DEFAULT
68 supplier_selector_view postgres DEFAULT
69 supplier_view postgres DEFAULT
70 tax_authority_scrud_view postgres DEFAULT
71 tax_base_amount_type_selector_view postgres DEFAULT
72 tax_exempt_type_scrud_view postgres DEFAULT
73 tax_master_scrud_view postgres DEFAULT
74 tax_rate_type_selector_view postgres DEFAULT
75 unit_scrud_view postgres DEFAULT
76 unit_selector_view postgres DEFAULT
77 unit_view postgres DEFAULT

Materialized Views

# Matview Name Owner Tablespace Description

Functions

# Function Owner Description
1 append_if_not_null(text, text)
RETURNS text 		postgres
2 calculate_interest(principal numeric, rate numeric, days integer, round_up integer, num_of_days_in_year integer)
RETURNS numeric 		postgres
3 calculate_interest(principal numeric, rate numeric, days integer, round_up integer)
RETURNS numeric 		postgres
4 convert_unit(from_unit integer, to_unit integer)
RETURNS numeric 		postgres
5 count_item_in_stock(_item_id integer, _unit_id integer, _store_id integer)
RETURNS numeric 		postgres
6 count_purchases(_item_id integer, _unit_id integer, _store_id integer)
RETURNS numeric 		postgres
7 count_sales(_item_id integer, _unit_id integer, _store_id integer)
RETURNS numeric 		postgres
8 create_flag(user_id_ integer, flag_type_id_ integer, resource_ text, resource_key_ text, resource_id_ text)
RETURNS void 		postgres
9 get_account_id_by_account_number(text)
RETURNS bigint 		postgres
10 get_account_id_by_party_code(party_code text)
RETURNS bigint 		postgres
11 get_account_id_by_party_id(party_id bigint)
RETURNS bigint 		postgres
12 get_account_id_by_party_type_id(_party_type_id integer)
RETURNS integer 		postgres
13 get_account_id_by_shipper_id(integer)
RETURNS bigint 		postgres
14 get_account_ids(root_account_id bigint)
RETURNS SETOF bigint 		postgres
15 get_account_master_id_by_account_id(bigint)
RETURNS integer 		postgres
16 get_account_master_id_by_account_master_code(text)
RETURNS integer 		postgres
17 get_account_name(bigint)
RETURNS text 		postgres
18 get_account_name_by_account_id(bigint)
RETURNS text 		postgres
19 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
20 get_associated_units(integer)
RETURNS TABLE(unit_id integer, unit_code text, unit_name text) 		postgres
21 get_associated_units_from_item_code(text)
RETURNS TABLE(unit_id integer, unit_code text, unit_name text) 		postgres
22 get_associated_units_from_item_id(integer)
RETURNS TABLE(unit_id integer, unit_code text, unit_name text) 		postgres
23 get_attachment_lookup_info(character varying)
RETURNS text 		postgres
24 get_base_quantity_by_unit_id(integer, integer)
RETURNS numeric 		postgres
25 get_base_quantity_by_unit_name(text, integer)
RETURNS numeric 		postgres
26 get_base_unit_id_by_unit_name(text)
RETURNS integer 		postgres
27 get_brand_code_by_brand_id(integer)
RETURNS text 		postgres
28 get_brand_id_by_brand_code(text)
RETURNS integer 		postgres
29 get_brand_id_by_brand_name(text)
RETURNS integer 		postgres
30 get_brand_name_by_brand_id(integer)
RETURNS text 		postgres
31 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.
32 get_cash_account_id_by_store_id(_store_id integer)
RETURNS bigint 		postgres
33 get_cash_flow_heading_id_by_cash_flow_heading_code(_cash_flow_heading_code character varying)
RETURNS integer 		postgres
34 get_cash_repository_id_by_store_id(_store_id integer)
RETURNS bigint 		postgres
35 get_cost_of_goods_sold_account_id(_item_id integer)
RETURNS integer 		postgres
36 get_country_id_by_country_code(character varying)
RETURNS integer 		postgres
37 get_country_name_by_country_id(integer)
RETURNS text 		postgres
38 get_county_id_by_county_code(character varying)
RETURNS integer 		postgres
39 get_county_id_by_county_name(text)
RETURNS integer 		postgres
40 get_county_sales_tax_rate(_county_sales_tax_id integer)
RETURNS decimal_strict2 		postgres
41 get_currency_code_by_office_id(office_id integer)
RETURNS text 		postgres
42 get_currency_code_by_party_code(_party_code character varying)
RETURNS text 		postgres
43 get_currency_code_by_party_id(party_id bigint)
RETURNS text 		postgres
44 get_current_year()
RETURNS integer 		postgres
45 get_date(_office_id integer)
RETURNS date 		postgres
46 get_email_address_by_party_id(bigint)
RETURNS text 		postgres
47 get_entity_id_by_party_id(_party_id bigint)
RETURNS integer 		postgres
48 get_field(this hstore, _column_name text)
RETURNS text 		postgres
49 get_fiscal_half_end_date(_office_id integer)
RETURNS date 		postgres
50 get_fiscal_half_start_date(_office_id integer)
RETURNS date 		postgres
51 get_fiscal_year_end_date(_office_id integer)
RETURNS date 		postgres
52 get_fiscal_year_start_date(_office_id integer)
RETURNS date 		postgres
53 get_flag_background_color(flag_type_id_ integer)
RETURNS text 		postgres
54 get_flag_foreground_color(flag_type_id_ integer)
RETURNS text 		postgres
55 get_flag_type_id(user_id_ integer, resource_ text, resource_key_ text, resource_id_ text)
RETURNS integer 		postgres
56 get_frequency_code_by_frequency_id(integer)
RETURNS text 		postgres
57 get_frequency_setup_code_by_frequency_setup_id(_frequency_setup_id integer)
RETURNS text 		postgres
58 get_frequency_setup_end_date_frequency_setup_id(_frequency_setup_id integer)
RETURNS date 		postgres
59 get_frequency_setup_start_date_frequency_setup_id(_frequency_setup_id integer)
RETURNS date 		postgres
60 get_income_tax_provison_amount(_office_id integer, _profit numeric, _balance numeric)
RETURNS numeric 		postgres
61 get_income_tax_rate(_office_id integer)
RETURNS real 		postgres
62 get_industry_id_by_party_id(_party_id bigint)
RETURNS integer 		postgres
63 get_inventory_account_id(_item_id integer)
RETURNS integer 		postgres
64 get_item_code_by_item_id(integer)
RETURNS text 		postgres
65 get_item_cost_price(item_id_ integer, party_id_ bigint, unit_id_ integer)
RETURNS money_strict2 		postgres
66 get_item_cost_price(item_id_ integer, unit_id_ integer, party_id_ bigint)
RETURNS money_strict2 		postgres
67 get_item_group_code_by_item_group_id(integer)
RETURNS text 		postgres
68 get_item_group_id_by_item_group_code(text)
RETURNS integer 		postgres
69 get_item_group_id_by_item_group_name(text)
RETURNS integer 		postgres
70 get_item_group_id_by_item_id(integer)
RETURNS integer 		postgres
71 get_item_group_name_by_item_group_id(integer)
RETURNS text 		postgres
72 get_item_id_by_item_code(text)
RETURNS integer 		postgres
73 get_item_name_by_item_id(integer)
RETURNS text 		postgres
74 get_item_selling_price(item_id_ integer, party_type_id_ integer, price_type_id_ integer, unit_id_ integer)
RETURNS money_strict2 		postgres
75 get_item_tax_rate(_item_id integer)
RETURNS numeric 		postgres
76 get_item_type_id_by_item_type_code(text)
RETURNS integer 		postgres
77 get_menu_id(menu_code text)
RETURNS integer 		postgres
78 get_month_end_date(_office_id integer)
RETURNS date 		postgres
79 get_month_start_date(_office_id integer)
RETURNS date 		postgres
80 get_office_id_by_sales_tax_id(_sales_tax_id integer)
RETURNS integer 		postgres
81 get_ordered_quantity(_item_id integer, _unit_id integer, _office_id integer)
RETURNS numeric 		postgres
82 get_party_code(text, text, text)
RETURNS text 		postgres
83 get_party_id_by_party_code(text)
RETURNS bigint 		postgres
84 get_party_type_id_by_party_code(text)
RETURNS integer 		postgres
85 get_party_type_id_by_party_id(_party_id bigint)
RETURNS integer 		postgres
86 get_party_type_id_by_party_type_code(text)
RETURNS integer 		postgres
87 get_payment_term_id_by_payment_term_code(text)
RETURNS integer 		postgres
88 get_periods(_date_from date, _date_to date)
RETURNS core.period[] 		postgres
89 get_price_type_id_by_price_type_code(text)
RETURNS integer 		postgres
90 get_price_type_name_by_price_type_id(integer)
RETURNS text 		postgres
91 get_purchase_account_id(_item_id integer)
RETURNS integer 		postgres
92 get_purchase_discount_account_id(_item_id integer)
RETURNS integer 		postgres
93 get_quarter_end_date(_office_id integer)
RETURNS date 		postgres
94 get_quarter_start_date(_office_id integer)
RETURNS date 		postgres
95 get_recurring_amount_by_recurring_invoice_id(_recurring_invoice_id integer)
RETURNS money_strict 		postgres
96 get_root_parent_menu_id(text)
RETURNS integer 		postgres
97 get_root_unit_id(integer)
RETURNS integer 		postgres
98 get_sales_account_id(_item_id integer)
RETURNS integer 		postgres
99 get_sales_discount_account_id(_item_id integer)
RETURNS integer 		postgres
100 get_sales_return_account_id(_item_id integer)
RETURNS integer 		postgres
101 get_sales_tax_code_by_sales_tax_id(_sales_tax_id integer)
RETURNS character varying 		postgres
102 get_sales_tax_id_by_sales_tax_code(_sales_tax_code character varying)
RETURNS integer 		postgres
103 get_sales_tax_name_by_sales_tax_id(_sales_tax_id integer)
RETURNS character varying 		postgres
104 get_sales_team_id_by_sales_team_code(text)
RETURNS integer 		postgres
105 get_salesperson_id_by_salesperson_code(text)
RETURNS integer 		postgres
106 get_salesperson_name_by_salesperson_id(integer)
RETURNS text 		postgres
107 get_second_root_account_id(_account_id bigint, _parent bigint DEFAULT 0)
RETURNS integer 		postgres
108 get_shipper_code(text)
RETURNS text 		postgres
109 get_shipper_id_by_shipper_code(text)
RETURNS integer 		postgres
110 get_shipper_name_by_shipper_id(integer)
RETURNS text 		postgres
111 get_shipping_address_by_shipping_address_id(bigint)
RETURNS text 		postgres
112 get_shipping_address_code_by_shipping_address_id(bigint)
RETURNS text 		postgres
113 get_shipping_address_id_by_shipping_address_code(text, bigint)
RETURNS integer 		postgres
114 get_state_id_by_shipping_address_code(text, bigint)
RETURNS integer 		postgres
115 get_state_id_by_state_code(character varying)
RETURNS integer 		postgres
116 get_state_id_by_state_name(text)
RETURNS integer 		postgres
117 get_state_name_by_state_id(integer)
RETURNS text 		postgres
118 get_state_sales_tax_rate(_state_sales_tax_id integer)
RETURNS decimal_strict2 		postgres
119 get_tax_master_id_by_tax_master_code(text)
RETURNS integer 		postgres
120 get_unit_code_by_unit_id(integer)
RETURNS text 		postgres
121 get_unit_id_by_unit_code(text)
RETURNS integer 		postgres
122 get_unit_id_by_unit_name(text)
RETURNS integer 		postgres
123 get_unit_name_by_unit_id(integer)
RETURNS text 		postgres
124 get_verification_status_name_by_verification_status_id(integer)
RETURNS text 		postgres
125 has_child_accounts(bigint)
RETURNS boolean 		postgres
126 is_cash_account_id(_account_id bigint)
RETURNS boolean 		postgres
127 is_cash_equivalent(_account_id bigint)
RETURNS boolean 		postgres
128 is_leap_year(integer)
RETURNS boolean 		postgres
129 is_leap_year()
RETURNS boolean 		postgres
130 is_parent_unit(parent integer, child integer)
RETURNS boolean 		postgres
131 is_stock_item(item_id integer)
RETURNS boolean 		postgres
132 is_stock_item(item_code character varying)
RETURNS boolean 		postgres
133 is_supplier(bigint)
RETURNS boolean 		postgres
134 is_valid_item_id(integer)
RETURNS boolean 		postgres
135 is_valid_unit(_item_id integer, _unit_id integer)
RETURNS boolean 		postgres
136 is_valid_unit_id(_unit_id integer, _item_id integer)
RETURNS boolean 		postgres
137 is_valid_unit_id(integer)
RETURNS boolean 		postgres

Triggers

# Trigger Owner Description
1 disable_editing_sys_type()
RETURNS TRIGGER 		postgres
2 items_unit_check_trigger()
RETURNS TRIGGER 		postgres
3 party_after_insert_trigger()
RETURNS TRIGGER 		postgres
4 party_before_update_trigger()
RETURNS TRIGGER 		postgres
5 shippers_after_insert_trigger()
RETURNS TRIGGER 		postgres
6 update_shipping_address_code_trigger()
RETURNS TRIGGER 		postgres

Types

# Type Base Type Owner Collation Default Type StoreType NotNull Description
1 attachment_type - postgres Composite Type Compressed Inline/Seconary False
2 period - postgres Composite Type Compressed Inline/Seconary False