a_asset_acct

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_id numeric 10 null
a_asset.a_asset_id aasset_aassetacct C
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_aassetacct 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_depreciation_id numeric 10 null
a_depreciation.a_depreciation_id adepreciation_aassetacct R
a_depreciation_acct numeric 10 null
c_validcombination.c_validcombination_id adepreciationvc_aassetacct R
a_accumdepreciation_acct numeric 10 null
c_validcombination.c_validcombination_id aaccumdepreciation_aassetacct R
a_disposal_loss varchar 40 √ null
a_disposal_gain varchar 10 √ null
a_asset_acct numeric 10 null
c_validcombination.c_validcombination_id aassetvc_aassetacct R
a_asset_acct_id numeric 10 null
a_asset_change.a_asset_acct_id Implied Constraint R
a_asset_split.a_asset_acct_id Implied Constraint R
a_asset_transfer.a_asset_acct_id Implied Constraint R
a_depreciation_manual_period varchar 2 √ null
a_depreciation_table_header_id numeric 10 √ null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aasse R
a_reval_cost_offset_prior varchar 22 √ null
a_reval_cost_offset varchar 22 √ null
a_reval_cal_method varchar 3 √ null
a_reval_accumdep_offset_prior varchar 22 √ null
a_reval_accumdep_offset_cur varchar 22 √ null
a_period_start numeric 10 null
a_period_end numeric 10 null
a_disposal_revenue varchar 40 √ null
processing bpchar 1 √ 'Y'::bpchar
postingtype bpchar 1 'A'::bpchar
a_split_percent numeric 0 (1)::numeric
a_salvage_value numeric 0 √ (0)::numeric
a_reval_depexp_offset varchar 22 √ null
a_depreciation_variable_perc numeric 0 √ null
a_depreciation_method_id numeric 10 √ null
a_depreciation_method.a_depreciation_method_id adepreciationmethod_aassetacct R
a_depreciation_manual_amount numeric 0 √ null
a_depreciation_conv_id numeric 10 √ null
a_depreciation_convention.a_depreciation_convention_id adepreciationconv_aassetacct R
a_asset_spread_id numeric 10 √ null
a_asset_spread.a_asset_spread_id aassetspread_aassetacct R
a_disposal_gain_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalgain_aassetacct R
a_reval_cost_offset_prior_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffsetprior_aassetac R
a_reval_cost_offset_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffset_aassetacct R
a_reval_adep_offset_prior_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetprior_aassetac R
a_reval_adep_offset_cur_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetcur_aassetacct R
a_disposal_revenue_acct numeric 10 null
c_validcombination.c_validcombination_id adisposalrevenue_aassetacct R
a_disposal_loss_acct numeric 10 null
c_validcombination.c_validcombination_id adisposalloss_aassetacct R
a_reval_depexp_offset_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaldepexpoffset_aassetacct R
a_depreciation_method_f_id numeric 10 √ null
a_depreciation_method.a_depreciation_method_id adepreciationmethodf_aassetacc R
a_depreciation_f_id numeric 10 null
a_depreciation.a_depreciation_id adepreciationf_aassetacct R
a_depreciation_conv_f_id numeric 10 √ null
a_depreciation_convention.a_depreciation_convention_id adepreciationconvf_aassetacct R
a_depreciation_variable_perc_f numeric 0 √ null
validfrom timestamp 29,6 √ null
a_asset_acct_uu varchar 36 √ NULL::character varying
cof_processing bpchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
a_asset_acct_pkey Primary key Asc a_asset_acct_id
a_asset_acct_uu_idx Must be unique Asc a_asset_acct_uu

Check Constraints

Constraint Name Constraint
a_asset_acct_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_acct_processing_check ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation