s_expensetype

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
s_expensetype_id numeric 10 null
c_project_details_v.s_expensetype_id Implied Constraint R
c_project_details_vt.s_expensetype_id Implied Constraint R
cof_rv_productsmanufacturedandsold.s_expensetype_id Implied Constraint R
m_inout_line_v.s_expensetype_id Implied Constraint R
m_inout_line_vt.s_expensetype_id Implied Constraint R
m_product.s_expensetype_id sexpensetype_mproduct R
rv_c_invoiceline.s_expensetype_id Implied Constraint R
rv_cost.s_expensetype_id Implied Constraint R
rv_costdetail.s_expensetype_id Implied Constraint R
rv_fact_acct.s_expensetype_id Implied Constraint R
rv_m_transaction.s_expensetype_id Implied Constraint R
rv_storage.s_expensetype_id Implied Constraint R
rv_transaction.s_expensetype_id Implied Constraint R
t_rv_reconciliation.s_expensetype_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
isinvoiced bpchar 1 'Y'::bpchar
c_uom_id numeric 10 null
c_uom.c_uom_id cuom_sexpensetype R
m_product_category_id numeric 10 null
m_product_category.m_product_category_id mproductcategory_sexpensetype R
c_taxcategory_id numeric 10 null
c_taxcategory.c_taxcategory_id ctaxcategory_sexpensetype R
s_expensetype_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
s_expensetype_pkey Primary key Asc s_expensetype_id
s_expensetype_uu_idx Must be unique Asc s_expensetype_uu

Check Constraints

Constraint Name Constraint
s_expensetype_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
s_expensetype_isinvoiced_check ((isinvoiced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation