Table idempiere9.adempiere.a_asset_group
Group of Assets

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
a_asset_group_id numeric 10
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
Group of Assets
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
isowned bpchar 1 'Y'::bpchar The asset is owned by the organization
isdepreciated bpchar 1 'Y'::bpchar The asset will be depreciated
isoneassetperuom bpchar 1 'N'::bpchar Create one asset per UOM
iscreateasactive bpchar 1 'Y'::bpchar Create Asset and activate it
istrackissues bpchar 1 'N'::bpchar Enable tracking issues for this asset
a_asset_group_uu varchar 36  √  NULL::character varying A_Asset_Group_UU
a_asset_class_id numeric 10  √  NULL::numeric
a_asset_class.a_asset_class_id aassetclass_aassetgroup R
Asset class
isdefault bpchar 1 'N'::bpchar Default value
a_asset_type_id numeric 10  √  null
a_asset_type.a_asset_type_id aassettype_aassetgroup R
Asset Type
isfixedasset bpchar 1  √  'Y'::bpchar IsFixedAsset

Table contained 9 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.