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
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 Asset class
isdefault bpchar 1 'N'::bpchar Default value
a_asset_type_id numeric 10  √  null Asset Type
isfixedasset bpchar 1  √  'Y'::bpchar IsFixedAsset

Table contained 9 rows at 2021-12-25 14:48 +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

Close relationships  within of separation: