a_asset_group

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_group_id numeric 10 null
a_asset.a_asset_group_id aassetgroup_aasset R
a_asset_group_acct.a_asset_group_id aassetgroup_aassetgroupacct C
a_asset_group_trl.a_asset_group_id aassetgroup_aassetgrouptrl C
c_invoiceline.a_asset_group_id aassetgroup_cinvoiceline R
gl_journalline.a_asset_group_id aassetgroup_gljournalline R
i_asset.a_asset_group_id aassetgroup_iasset R
i_fixedasset.a_asset_group_id aassetgroup_ifixedasset R
m_product_category.a_asset_group_id aassetgroup_mproductcategory R
mp_jobstandar.a_asset_group_id aassetgroup_mpjobstandar R
mp_maintain.a_asset_group_id aassetgroup_mpmaintain R
rv_asset_customer.a_asset_group_id Implied Constraint R
rv_asset_delivery.a_asset_group_id Implied Constraint R
rv_asset_summonth.a_asset_group_id Implied Constraint R
rv_cof_detailassetmaintain.a_asset_group_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
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
isowned bpchar 1 'Y'::bpchar
isdepreciated bpchar 1 'Y'::bpchar
isoneassetperuom bpchar 1 'N'::bpchar
iscreateasactive bpchar 1 'Y'::bpchar
istrackissues bpchar 1 'N'::bpchar
a_asset_group_uu varchar 36 √ NULL::character varying
a_asset_class_id numeric 10 √ NULL::numeric
a_asset_class.a_asset_class_id aassetclass_aassetgroup R
isdefault bpchar 1 'N'::bpchar
a_asset_type_id numeric 10 √ null
a_asset_type.a_asset_type_id aassettype_aassetgroup R
isfixedasset bpchar 1 √ 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
a_asset_group_pkey Primary key Asc a_asset_group_id
a_asset_group_uu_idx Must be unique Asc a_asset_group_uu

Check Constraints

Constraint Name Constraint
a_asset_group_isfixedasset_check ((isfixedasset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_group_isdefault_check ((isdefault = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_group_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_group_isowned_check ((isowned = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation