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_invoice.c_conversiontype_id cconversiontype_cinvoice R
c_invoicebatch.c_conversiontype_id cconventiontype_cinvoicebatch R
c_order.c_conversiontype_id cconversiontype_corder R
c_payment.c_conversiontype_id cconversiontype_cpayment R
c_paymenttransaction.c_conversiontype_id cconversiontype_cpaymenttransa R
gl_journal.c_conversiontype_id cconversiontype_gljournal R
gl_journalline.c_conversiontype_id cconversiontype_gljournalline R
i_conversion_rate.c_conversiontype_id cconvtype_iconvrate N
i_gljournal.c_conversiontype_id cconversiontype_igljournal N
m_discountschemaline.c_conversiontype_id cconversiontype_mdiscschline R
m_inventory.c_conversiontype_id cconversiontype_minventory R
t_invoicegl.c_conversiontypereval_id cconversiontype_tinvoicegl C
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