c_conversiontype

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_conversiontype_id numeric 10 null
a_asset_addition.c_conversiontype_id cconversiontype_aassetaddition R
c_banktransfer.c_conversiontype_id cconversiontype_cbanktransfer R
c_conversion_rate.c_conversiontype_id cconversiontype_cconvrate R
c_dunning_line_v.c_conversiontype_id Implied Constraint R
c_dunning_line_vt.c_conversiontype_id Implied Constraint R
c_invoice.c_conversiontype_id cconversiontype_cinvoice R
c_invoice_header_v.c_conversiontype_id Implied Constraint R
c_invoice_header_vt.c_conversiontype_id Implied Constraint R
c_invoice_v.c_conversiontype_id Implied Constraint R
c_invoice_v1.c_conversiontype_id Implied Constraint R
c_invoicebatch.c_conversiontype_id cconventiontype_cinvoicebatch R
c_order.c_conversiontype_id cconversiontype_corder R
c_order_header_v.c_conversiontype_id Implied Constraint R
c_order_header_vt.c_conversiontype_id Implied Constraint R
c_payment.c_conversiontype_id cconversiontype_cpayment R
c_payment_v.c_conversiontype_id Implied Constraint R
c_paymenttransaction.c_conversiontype_id cconversiontype_cpaymenttransa R
c_payselection_check_v.c_conversiontype_id Implied Constraint R
c_payselection_check_vt.c_conversiontype_id Implied Constraint R
c_payselection_remittance_v.c_conversiontype_id Implied Constraint R
c_payselection_remittance_vt.c_conversiontype_id Implied Constraint R
cof_rv_itenspago.c_conversiontype_id Implied Constraint R
gl_journal.c_conversiontype_id cconversiontype_gljournal R
gl_journalline.c_conversiontype_id cconversiontype_gljournalline R
gl_journalline_acct_v.c_conversiontype_id Implied Constraint R
i_conversion_rate.c_conversiontype_id cconvtype_iconvrate N
i_fajournal.c_conversiontype_id Implied Constraint R
i_gljournal.c_conversiontype_id cconversiontype_igljournal N
m_discountschemaline.c_conversiontype_id cconversiontype_mdiscschline R
m_inventory.c_conversiontype_id cconversiontype_minventory R
rv_bpartneropen.c_conversiontype_id Implied Constraint R
rv_c_invoice.c_conversiontype_id Implied Constraint R
rv_c_invoice.c_invoice_c_conversiontype_id Implied Constraint R
rv_c_invoicetax.c_conversiontype_id Implied Constraint R
rv_commissionrundetail.c_conversiontype_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_conversiontype_id Implied Constraint R
rv_invoicepayschedule.c_conversiontype_id Implied Constraint R
rv_openitem.c_conversiontype_id Implied Constraint R
rv_openitemtodate.c_conversiontype_id Implied Constraint R
rv_orderdetail.c_conversiontype_id Implied Constraint R
rv_payment.c_conversiontype_id Implied Constraint R
t_invoicegl.c_conversiontypereval_id cconversiontype_tinvoicegl C
t_invoicegl_v.c_conversiontype_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
isdefault bpchar 1 'N'::bpchar
c_conversiontype_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_conversiontype_pkey Primary key Asc c_conversiontype_id
c_conversiontype_uu_idx Must be unique Asc c_conversiontype_uu

Check Constraints

Constraint Name Constraint
c_conversiontype_isdefault_check ((isdefault = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation