a_asset_change

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_change_id numeric 10 null
a_asset_change_amt.a_asset_change_id aassetchange_aassetchangeamt R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
a_asset_id numeric 10 null
a_asset.a_asset_id aasset_aassetchange R
changetype varchar 3 null
changedate timestamp 29,6 √ null
changeamt numeric 0 √ null
uselifeyears numeric 0 √ null
uselifemonths numeric 10 √ null
lifeuseunits numeric 10 √ null
assetdepreciationdate timestamp 29,6 √ null
a_asset_retirement_id numeric 10 √ null
a_asset_retirement.a_asset_retirement_id aaretirement_aachange R
a_asset_addition_id numeric 10 √ null
a_asset_addition.a_asset_addition_id aaaddition_aachange R
serno varchar 40 √ null
lot varchar 40 √ null
versionno varchar 40 √ null
a_accumdepreciation_acct numeric 10 √ null
c_validcombination.c_validcombination_id aaccumdepreciation_aassetchang R
a_asset_createdate timestamp 29,6 √ null
a_asset_spread_type varchar 10 √ null
a_depreciation_calc_type varchar 10 √ null
a_depreciation_manual_period varchar 2 √ null
a_qty_original numeric 0 √ null
a_qty_current numeric 0 √ null
a_period_start numeric 10 √ null
a_period_end numeric 10 √ null
a_parent_asset_id numeric 10 √ null
a_asset.a_asset_id aparentasset_aassetchange R
a_disposal_revenue varchar 22 √ null
a_disposal_loss varchar 22 √ null
a_depreciation_variable_perc numeric 0 √ null
a_depreciation_table_header_id numeric 10 √ null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aass2 R
c_acctschema_id numeric 10 √ null
c_acctschema.c_acctschema_id cacctschema_aassetchange R
assetvalueamt numeric 0 (0)::numeric
assetservicedate timestamp 29,6 √ null
assetmarketvalueamt numeric 0 √ null
assetdisposaldate timestamp 29,6 √ null
assetbookvalueamt numeric 0 √ null
assetaccumdepreciationamt numeric 0 √ null
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_aassetchange R
isinposession bpchar 1 √ null
isfullydepreciated bpchar 1 √ null
isdisposed bpchar 1 √ null
isdepreciated bpchar 1 √ null
depreciationtype varchar 10 √ null
dateacct timestamp 29,6 √ null
useunits numeric 10 √ null
textdetails varchar 60 null
postingtype varchar 10 √ 'A'::character varying
isowned bpchar 1 √ null
conventiontype varchar 10 √ null
c_validcombination_id numeric 10 √ null
c_validcombination.c_validcombination_id cvalidcombinati_aassetchange R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_aassetchange R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_aassetchange R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_aassetchange R
a_split_percent numeric 0 √ (1)::numeric
a_salvage_value numeric 0 √ null
a_reval_depexp_offset numeric 10 √ null
a_reval_cost_offset_prior numeric 10 √ null
a_reval_cost_offset numeric 10 √ null
a_reval_cal_method varchar 3 √ null
a_reval_accumdep_offset_prior numeric 10 √ null
a_reval_accumdep_offset_cur numeric 10 √ null
a_depreciation_manual_amount numeric 0 √ null
a_depreciation_acct numeric 10 √ null
c_validcombination.c_validcombination_id adepreciation_aassetchange R
a_asset_revaldate timestamp 29,6 √ null
a_asset_acct numeric 10 √ null
c_validcombination.c_validcombination_id aassetvc_aassetchange R
a_asset_acct_id numeric 10 √ null
a_asset_acct.a_asset_acct_id Implied Constraint R
a_asset_change_uu varchar 36 √ NULL::character varying
a_disposal_revenue_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalrevenue_aassetchange R
a_disposal_loss_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalloss_aassetchange R
a_reval_depexp_offset_acct numeric 10 √ NULL::numeric
a_reval_cost_offset_prior_acct numeric 10 √ NULL::numeric
a_reval_cost_offset_acct numeric 10 √ NULL::numeric
a_reval_adep_offset_prior_acct numeric 10 √ NULL::numeric
a_reval_adep_offset_cur_acct numeric 10 √ NULL::numeric
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_aassetchange R
dateinvoiced timestamp 29,6 √ null
c_invoice_c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cinvoicecbpartner_aassetchange R
c_invoice_ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id cinvoiceaduser_aassetchange R
c_invoice_c_doctypetarget_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cinvoicecdoctypetarget_aassetc R
c_invoice_c_bpartnerloc_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cinvoicecbpartnerloc_aassetcha R
invoicedqty numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
a_asset_change_pkey Primary key Asc a_asset_change_id
a_asset_change_uu_idx Must be unique Asc a_asset_change_uu

Check Constraints

Constraint Name Constraint
a_asset_change_isdisposed_check ((isdisposed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_change_isowned_check ((isowned = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_change_isfullydepreciated_check ((isfullydepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_change_isdepreciated_check ((isdepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_change_isinposession_check ((isinposession = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_change_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation