c_currency

175 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_currency_id numeric 10 null
a_asset_addition.c_currency_id ccurrency_aassetaddition R
a_asset_reval_entry.c_currency_id ccurrency_aassetrevalentry R
a_depreciation_entry.c_currency_id ccurrency_adepreciationentry R
ad_registration.c_currency_id ccurrency_adregistration R
ad_role.c_currency_id c_currency_ad_role R
c_acctschema.c_currency_id c_currency_c_acctschema R
c_allocationhdr.c_currency_id ccurrency_callocation R
c_bankaccount.c_currency_id ccurrency_cbankaccount R
c_bankaccount_processor.c_currency_id ccurrency_cbankaccountprocesso R
c_bankstatementline.c_currency_id ccurrency_cbankstmtline R
c_banktransfer.from_c_currency_id fromccurrency_cbanktransfer R
c_banktransfer.to_c_currency_id toccurrency_cbanktransfer R
c_cashbook.c_currency_id ccurrency_ccashbook R
c_cashline.c_currency_id ccurrency_ccashline R
c_commission.c_currency_id ccurrency_ccommission R
c_commissiondetail.c_currency_id ccurrency_ccommissiondetail R
c_conversion_rate.c_currency_id ccurrency_cconversionrate R
c_conversion_rate.c_currency_id_to c_currencyconvrateto R
c_country.c_currency_id ccurrency_ccountry R
c_currency_acct.c_currency_id ccurrency_ccurrencyacct C
c_currency_trl.c_currency_id ccurrency_ccurrencytrl C
c_cycle.c_currency_id ccurrency_ccycle R
c_dunning_header_v.c_currency_id Implied Constraint R
c_dunning_header_vt.c_currency_id Implied Constraint R
c_dunning_line_v.c_currency_id Implied Constraint R
c_dunning_line_vt.c_currency_id Implied Constraint R
c_dunningrunentry.c_currency_id ccurrency_cdunningrunentry R
c_elementvalue.c_currency_id ccurrency_celementvalue R
c_invoice.c_currency_id ccurrency_cinvoice R
c_invoice_header_v.c_currency_id Implied Constraint R
c_invoice_header_vt.c_currency_id Implied Constraint R
c_invoice_v.c_currency_id Implied Constraint R
c_invoice_v1.c_currency_id Implied Constraint R
c_invoicebatch.c_currency_id ccurrency_cinvoicebatch R
c_opportunity.c_currency_id ccurrency_copportunity R
c_order.c_currency_id ccurrency_corder R
c_order_header_v.c_currency_id Implied Constraint R
c_order_header_vt.c_currency_id Implied Constraint R
c_orderline.c_currency_id ccurrency_corderline R
c_payment.c_currency_id ccurrency_cpayment R
c_payment_v.c_currency_id Implied Constraint R
c_paymentprocessor.c_currency_id ccurrency_cpaymentprocessor R
c_paymenttransaction.c_currency_id ccurrency_cpaymenttransaction R
c_payselection_check_v.c_currency_id Implied Constraint R
c_payselection_check_vt.c_currency_id Implied Constraint R
c_payselection_remittance_v.c_currency_id Implied Constraint R
c_payselection_remittance_vt.c_currency_id Implied Constraint R
c_project.c_currency_id ccurrency_cproject R
c_project_details_v.c_currency_id Implied Constraint R
c_project_details_vt.c_currency_id Implied Constraint R
c_project_header_v.c_currency_id Implied Constraint R
c_project_header_vt.c_currency_id Implied Constraint R
c_revenuerecognition_plan.c_currency_id ccurrency_crevenuerecplan R
c_rfq.c_currency_id ccurrency_crfq R
c_rfqresponse.c_currency_id ccurrency_crfqresponse R
c_rfqresponse_v.c_currency_id Implied Constraint R
c_rfqresponse_vt.c_currency_id Implied Constraint R
c_taxdeclarationline.c_currency_id ccurrency_ctaxdeclline R
cof_dunningdetails_v.c_currency_id Implied Constraint R
cof_rps.c_currency_id ccurrency_cofrps R
cof_rv_detalheslocalizacao.c_currency_id Implied Constraint R
cof_rv_docfiscal.c_currency_id Implied Constraint R
cof_rv_itenspago.c_currency_id Implied Constraint R
cof_rv_oportunidadevenda.c_currency_id Implied Constraint R
fact_acct.c_currency_id c_currency_fact_acct R
gl_journal.c_currency_id ccurrency_gljournal R
gl_journalbatch.c_currency_id ccurrency_gljournalbatch R
gl_journalline.c_currency_id ccurrency_gljournalline R
gl_journalline_acct_v.c_currency_id Implied Constraint R
i_bankstatement.c_currency_id ccurrency_ibankstatement N
i_conversion_rate.c_currency_id ccurrency_iconvrate N
i_conversion_rate.c_currency_id_to ccurrency_iconvrateto N
i_fajournal.c_currency_id ccurrency_ifajournal R
i_fixedasset.c_currency_id ccurrency_ifixedasset R
i_gljournal.c_currency_id ccurrency_igljournal N
i_invoice.c_currency_id ccurrency_iinvoice N
i_order.c_currency_id ccurrency_iorder N
i_payment.c_currency_id ccurrency_ipayment R
i_pricelist.c_currency_id ccurrency_ipricelist R
i_product.c_currency_id ccurrency_iproduct N
lbr_di.c_currency_id ccurrency_lbrdi R
lbr_docfiscal.c_currency_id ccurrency_lbrdocfiscal R
m_bp_price.c_currency_id ccurrency_mbpprice R
m_freight.c_currency_id ccurrency_mfreight R
m_inventory.c_currency_id ccurrency_minventory R
m_package.c_currency_id ccurrency_mpackage R
m_pricelist.c_currency_id ccurrency_mpricelist R
m_product_po.c_currency_id ccurrency_mproductpo R
m_rma.c_currency_id ccurrency_mrma R
m_shippingtransaction.c_currency_id ccurrency_mshippingtransaction R
pa_reportcolumn.c_currency_id ccurrency_pareportcolumn R
rv_allocation.c_currency_id Implied Constraint R
rv_bpartner.c_country_c_currency_id Implied Constraint R
rv_bpartneropen.c_currency_id Implied Constraint R
rv_c_invoice.c_currency_id Implied Constraint R
rv_c_invoicetax.c_currency_id Implied Constraint R
rv_c_rfq_unanswered.c_currency_id Implied Constraint R
rv_c_rfqresponse.c_currency_id Implied Constraint R
rv_cash_detail.c_currency_id Implied Constraint R
rv_commissionrundetail.c_commission_c_currency_id Implied Constraint R
rv_commissionrundetail.c_currency_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_currency_id Implied Constraint R
rv_commissionrundetail.c_order_c_currency_id Implied Constraint R
rv_commissionrundetail.c_orderline_c_currency_id Implied Constraint R
rv_cost.c_currency_id Implied Constraint R
rv_costdetail.c_currency_id Implied Constraint R
rv_costsummary.c_currency_id Implied Constraint R
rv_fact_acct.c_currency_id Implied Constraint R
rv_fact_acct.c_elementvalue_c_currency_id Implied Constraint R
rv_fact_acct_day.c_currency_id Implied Constraint R
rv_fact_acct_period.c_currency_id Implied Constraint R
rv_invoicepayschedule.c_currency_id Implied Constraint R
rv_m_transaction.m_product_po_c_currency_id Implied Constraint R
rv_openitem.c_currency_id Implied Constraint R
rv_openitemtodate.c_currency_id Implied Constraint R
rv_orderdetail.c_currency_id Implied Constraint R
rv_orderdetail.c_orderline_c_currency_id Implied Constraint R
rv_payment.c_currency_id Implied Constraint R
rv_projectcycle.c_currency_id Implied Constraint R
s_timeexpenseline.c_currency_id ccurrency_stimeexpenseline R
t_aging.c_currency_id ccurrency_taging C
t_inventoryvalue.c_currency_id ccurrency_tinventoryvalue C
t_invoicegl_v.c_currency_id Implied Constraint R
t_invoicegl_v.fact_acct_c_currency_id Implied Constraint R
t_rv_reconciliation.c_currency_id Implied Constraint R
t_rv_reconciliation.c_elementvalue_c_currency_id Implied Constraint R
t_trialbalance.c_currency_id Implied Constraint R
test.c_currency_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id c_currencyclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_currencyorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
iso_code bpchar 3 null
cursymbol varchar 10 √ null
description varchar 255 null
stdprecision numeric 10 null
costingprecision numeric 10 null
iseuro bpchar 1 'N'::bpchar
isemumember bpchar 1 'N'::bpchar
emuentrydate timestamp 29,6 √ null
emurate numeric 0 √ 0
roundofffactor numeric 0 √ null
c_currency_uu varchar 36 √ NULL::character varying
cof_bacemcompra numeric 10 √ NULL::numeric
cof_bacemvenda numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
c_currency_pkey Primary key Asc c_currency_id
c_currency_uu_idx Must be unique Asc c_currency_uu
c_currencyisocode Must be unique Asc iso_code

Check Constraints

Constraint Name Constraint
c_currency_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_currency_isemumember_check ((isemumember = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_currency_iseuro_check ((iseuro = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation