| daysbetween(p_date1 timestamp with time zone, p_date2 timestamp with time zone) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| currencyrate(p_curfrom_id numeric, p_curto_id numeric, p_convdate timestamp with time zone, p_conversiontype_id numeric, p_client_id numeric, p_org_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| nvl(text, text) |
FUNCTION |
plpgsql |
true |
text |
INVOKER |
|
| trunc(datetime timestamp with time zone) |
FUNCTION |
plpgsql |
true |
timestamp with time zone |
INVOKER |
|
| cof_prazomedio(order_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| currencyround(p_amount numeric, p_curto_id numeric, p_costing character varying) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| cof_qtyfiscal(product_id numeric, warehouse_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| uuid_generate_v5(namespace uuid, name text) |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| nvl(anyelement, anyelement) |
FUNCTION |
plpgsql |
true |
anyelement |
INVOKER |
|
| uuid_ns_dns() |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| invoicepaidtodate(p_c_invoice_id numeric, p_c_currency_id numeric, p_multiplierap numeric, p_dateacct timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| cof_get_taxcode(client_id numeric, org_id numeric, taxname character varying, taxstatus character varying, cfop_id numeric, tpoperation character varying) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| bompricelimit(product_id numeric, pricelist_version_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| subtractdays(inter interval, days numeric) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| connectby(text, text, text, text, text, integer) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| uuid_generate_v3(namespace uuid, name text) |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| migr_fix_payment_cashline() |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| uuid_generate_v1mc() |
FUNCTION |
c |
false |
uuid |
INVOKER |
|
| getprojecaoparcela(order_id integer, p_bill_bpartner_id integer) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| crosstab2(text) |
FUNCTION |
c |
false |
SETOF tablefunc_crosstab_2 |
INVOKER |
|
| cof_qtyfiscalbyorg(product_id numeric, org_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| currencyconvertinvoice(p_c_invoice_id numeric, p_currency_to_id numeric, p_amt numeric DEFAULT NULL::numeric, p_conversiondate timestamp with time zone DEFAULT NULL::timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| register_migration_script(p_script character varying) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| getdate() |
FUNCTION |
plpgsql |
false |
timestamp with time zone |
INVOKER |
|
| cof_getcheckallocate(invoice_id numeric, invoicepayschedule_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| ismemberofacctschema(p_ad_client_id numeric, p_ad_org_id numeric, p_c_acctschema_id numeric) |
FUNCTION |
plpgsql |
false |
boolean |
INVOKER |
|
| bomqtyordered(p_product_id numeric, p_warehouse_id numeric, p_locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| invoiceduedates(p_c_invoice_id numeric) |
FUNCTION |
plpgsql |
false |
text |
INVOKER |
|
| cof_request_history(request_id integer, internaluser boolean) |
FUNCTION |
plpgsql |
false |
text |
INVOKER |
|
| forbid_multiple_rows_in_dbreplicasyncverifier() |
FUNCTION |
plpgsql |
false |
trigger |
INVOKER |
|
| uuid_nil() |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| deps_restore_dependencies(p_view_schema name, p_view_name name) |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| adddays(datetime timestamp with time zone, days numeric) |
FUNCTION |
plpgsql |
true |
timestamp with time zone |
INVOKER |
|
| firstof(timestamp with time zone, character varying) |
FUNCTION |
plpgsql |
true |
date |
INVOKER |
|
| cof_linhassemfiscal(order_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| cof_receber_leitura_em_massa(p_inout_id integer, p_leituraemmassa character varying) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| trunc(i interval) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| cof_getcheckallocateamt(invoice_id numeric, invoicepayschedule_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| uuid_ns_oid() |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| crosstab4(text) |
FUNCTION |
c |
false |
SETOF tablefunc_crosstab_4 |
INVOKER |
|
| nvl(integer, numeric) |
FUNCTION |
plpgsql |
true |
numeric |
INVOKER |
|
| connectby(text, text, text, text, integer, text) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| trunc(datetime timestamp without time zone) |
FUNCTION |
plpgsql |
true |
timestamp without time zone |
INVOKER |
|
| invoiceopentodate(p_c_invoice_id numeric, p_c_invoicepayschedule_id numeric, p_dateacct date) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| altercolumn(tablename name, columnname name, datatype name, nullclause character varying, defaultclause character varying) |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| instr(string character varying, string_to_search character varying, beg_index integer) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| role_access_update() |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| qtyondate(product_id integer, indate timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| uuid_ns_url() |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| getperiod(p_ad_client_id numeric, p_startdate date) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| delete_ad_image_binary() |
FUNCTION |
plpgsql |
false |
trigger |
INVOKER |
|
| bomqtyreserved(p_product_id numeric, p_warehouse_id numeric, p_locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| uuid_generate_v4() |
FUNCTION |
c |
false |
uuid |
INVOKER |
|
| invoicewriteoff(p_c_invoice_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| bomqtyonhandwithkit(product_id numeric, warehouse_id numeric, locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| paymenttermduedate(paymentterm_id numeric, docdate timestamp with time zone) |
FUNCTION |
plpgsql |
false |
timestamp with time zone |
INVOKER |
|
| get_sysconfig(sysconfig_name character varying, defaultvalue character varying, client_id numeric, org_id numeric) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| cof_evaluatenfstatus(nfestatus character varying, returntrue character varying, returnfalse character varying) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| deps_save_and_drop_dependencies(p_view_schema name, p_view_name name) |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| currencybase(p_amount numeric, p_curfrom_id numeric, p_convdate timestamp with time zone, p_client_id numeric, p_org_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| paymenttermduedays(paymentterm_id numeric, docdate timestamp with time zone, paydate timestamp with time zone) |
FUNCTION |
plpgsql |
false |
integer |
INVOKER |
|
| delete_ad_attachment_binary() |
FUNCTION |
plpgsql |
false |
trigger |
INVOKER |
|
| productattribute(p_m_attributesetinstance_id numeric) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| nextidfunc(p_ad_sequence_id integer, p_system character varying) |
FUNCTION |
plpgsql |
false |
integer |
INVOKER |
|
| invoiceopen(p_c_invoice_id numeric, p_c_invoicepayschedule_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| bomqtyavailable(product_id numeric, warehouse_id numeric, locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| subtractdays(day timestamp with time zone, days numeric) |
FUNCTION |
plpgsql |
true |
timestamp with time zone |
INVOKER |
|
| crosstab3(text) |
FUNCTION |
c |
false |
SETOF tablefunc_crosstab_3 |
INVOKER |
|
| cof_valormedioprod(product_id numeric, org_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| bomqtyonhandforreservation(product_id numeric, warehouse_id numeric, locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| invoicediscount(p_c_invoice_id numeric, p_paydate timestamp with time zone, p_c_invoicepayschedule_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| torecordid(p_tablename character varying, p_uu_value character varying) |
FUNCTION |
plpgsql |
false |
integer |
INVOKER |
|
| prodqtyordered(p_product_id numeric, p_warehouse_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| nextid(p_ad_sequence_id integer, p_system character varying, OUT o_nextid integer) |
FUNCTION |
plpgsql |
false |
integer |
INVOKER |
|
| nextbusinessday(p_date timestamp with time zone, p_ad_client_id numeric) |
FUNCTION |
plpgsql |
false |
timestamp with time zone |
INVOKER |
|
| currencyconvert(p_amount numeric, p_curfrom_id numeric, p_curto_id numeric, p_convdate timestamp with time zone, p_conversiontype_id numeric, p_client_id numeric, p_org_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| round(numeric, numeric) |
FUNCTION |
plpgsql |
true |
numeric |
INVOKER |
|
| charat(character varying, integer) |
FUNCTION |
plpgsql |
true |
character varying |
INVOKER |
|
| currencyconvertpayment(p_c_payment_id numeric, p_currency_to_id numeric, p_amt numeric DEFAULT NULL::numeric, p_conversiondate timestamp with time zone DEFAULT NULL::timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| uuid_generate_v1() |
FUNCTION |
c |
false |
uuid |
INVOKER |
|
| cof_getreflistvalue(table_name character varying, column_name character varying, value_list character varying) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| invoiceopentodate(p_c_invoice_id numeric, p_c_invoicepayschedule_id numeric, p_dateacct timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| acctbalance(p_account_id numeric, p_amtdr numeric, p_amtcr numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| paymentallocated(p_c_payment_id numeric, p_c_currency_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| drop_client(client_id integer) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| trunc(datetime timestamp without time zone, format character varying) |
FUNCTION |
plpgsql |
true |
date |
INVOKER |
|
| cof_formulaformacaopreco(cof_valormercadoria numeric, cof_freightamt numeric, cof_otheramt numeric, cof_insuranceamt numeric, imposto_icms_picmsst numeric, imposto_icms_picms numeric, imposto_ipi_pipi numeric, imposto_icms_vicms numeric, imposto_pis_ppis numeric, imposto_cofins_pcofins numeric, imposto_ipi_vipi numeric, cof_mvarate numeric, cof_imposto_icms_picmsstant numeric, imposto_icms_vicmsst numeric, cof_vanf numeric, cof_despesasadicionais numeric, cof_fretesadicionais numeric, cof_bonificacao numeric, cof_imposto_icms_vicmsstant numeric, cof_creditoimpostos numeric, cof_custogerencial numeric, imposto_pis_vpis numeric, imposto_cofins_vcofins numeric, cof_vagerencial numeric, cof_custonf numeric, cof_percjuros numeric, cof_perccf numeric, cof_percinflacao numeric, cof_percmarketing numeric, cof_perccapex numeric, cof_percopex numeric, cof_percdf numeric, cof_percmargem numeric, cof_percimpsaida numeric, cof_markup numeric, cof_customedio numeric, cof_precosugerido numeric, cof_percpis numeric, cof_perccofins numeric, cof_percipi numeric, cof_percst numeric, cof_aliqefetivaicms numeric, imposto_icms_predbc numeric, cof_fretevalor numeric, cof_maovalor numeric, cof_despesasvalor numeric) |
FUNCTION |
plpgsql |
false |
text |
INVOKER |
|
| isintersectcsv(p_csv1 character varying, p_csv2 character varying) |
FUNCTION |
plpgsql |
false |
character |
INVOKER |
|
| previousbusinessday(p_date timestamp with time zone, p_ad_client_id numeric) |
FUNCTION |
plpgsql |
false |
timestamp with time zone |
INVOKER |
|
| connectby(text, text, text, text, integer) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| crosstab(text) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| crosstab(text, integer) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| generate_uuid() |
FUNCTION |
plpgsql |
false |
character |
INVOKER |
|
| bomqtyonhandreposicao(product_id numeric, warehouse_id numeric, locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| invoicepaid(p_c_invoice_id numeric, p_c_currency_id numeric, p_multiplierap numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| instr(string character varying, string_to_search character varying, beg_index integer, occur_index integer) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| trunc(datetime timestamp with time zone, format character varying) |
FUNCTION |
plpgsql |
true |
date |
INVOKER |
|
| add_months(datetime timestamp with time zone, months numeric) |
FUNCTION |
plpgsql |
true |
timestamp with time zone |
INVOKER |
|
| connectby(text, text, text, text, text, integer, text) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| paymentavailable(p_c_payment_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| bomqtyonhand(product_id numeric, warehouse_id numeric, locator_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| nvl(numeric, integer) |
FUNCTION |
plpgsql |
true |
numeric |
INVOKER |
|
| uuid_ns_x500() |
FUNCTION |
c |
true |
uuid |
INVOKER |
|
| prodqtyreserved(p_product_id numeric, p_warehouse_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| instr(character varying, character varying) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| qtyondate(product_id numeric, indate timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| crosstab(text, text) |
FUNCTION |
c |
false |
SETOF record |
INVOKER |
|
| normal_rand(integer, double precision, double precision) |
FUNCTION |
c |
false |
SETOF double precision |
INVOKER |
|
| cof_get_determination_group(client_id numeric, org_id numeric, taxname_id numeric, taxstatus character varying, cfop_id numeric, tpoperation character varying) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| bpartnerremitlocation(p_c_bpartner_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| cof_estadoestoqueov(order_id numeric, warehouse_id numeric) |
FUNCTION |
plpgsql |
false |
text |
INVOKER |
|
| paymenttermdiscount(amount numeric, currency_id numeric, paymentterm_id numeric, docdate timestamp with time zone, paydate timestamp with time zone) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| update_sequences() |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| bompricestd(product_id numeric, pricelist_version_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| delete_ad_archive_binary() |
FUNCTION |
plpgsql |
false |
trigger |
INVOKER |
|
| add_missing_translations() |
FUNCTION |
plpgsql |
false |
void |
INVOKER |
|
| adddays(inter interval, days numeric) |
FUNCTION |
plpgsql |
true |
integer |
INVOKER |
|
| get1099bucket(p_cbpartner_id numeric, p_cut_date timestamp with time zone, p_bucket numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|
| documentno(p_pp_mrp_id numeric) |
FUNCTION |
plpgsql |
false |
character varying |
INVOKER |
|
| bompricelist(product_id numeric, pricelist_version_id numeric) |
FUNCTION |
plpgsql |
false |
numeric |
INVOKER |
|