SchemaSpy - Table idempiere9.adempiere.a_asset_change_amt

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_change_id

numeric

10

a_asset_change.a_asset_change_id

aassetchange_aassetchangeamt R

c_acctschema_id

numeric

10

c_acctschema.c_acctschema_id

cacctschema_aassetchangeamt R

ad_client_id

numeric

10

ad_org_id

numeric

10

isactive

bpchar

1

'Y'::bpchar

created

timestamp

29,6

now()

createdby

numeric

10

updated

timestamp

29,6

now()

updatedby

numeric

10

assetvalueamt

numeric

0

0

assetmarketvalueamt

numeric

0

0

assetbookvalueamt

numeric

0

0

assetaccumdepreciationamt

numeric

0

0

Table contained 0 rows at 2021-12-25 14:45 +0100

Indexes:

Column(s)	Type	Sort	Constraint Name
a_asset_change_id + c_acctschema_id	Primary key	Asc/Asc	a_asset_change_amt_pkey