a_asset_group_id |
numeric |
10 |
|
|
|
|
|
c_acctschema_id |
numeric |
10 |
|
|
|
|
|
ad_client_id |
numeric |
10 |
|
|
|
|
|
ad_org_id |
numeric |
10 |
|
|
|
|
|
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_acct |
numeric |
10 |
|
|
|
|
|
a_depreciation_acct |
numeric |
10 |
|
|
|
|
|
a_accumdepreciation_acct |
numeric |
10 |
|
|
|
|
|
a_disposal_loss |
varchar |
22 |
√ |
|
null |
|
|
a_disposal_gain |
varchar |
10 |
√ |
|
null |
|
|
a_depreciation_id |
numeric |
10 |
|
|
|
|
|
a_asset_group_acct_id |
numeric |
10 |
|
|
|
|
|
a_depreciation_manual_period |
varchar |
2 |
√ |
|
null |
|
|
a_depreciation_variable_perc |
numeric |
0 |
√ |
|
null |
|
|
a_split_percent |
numeric |
0 |
|
|
(1)::numeric |
|
|
a_reval_depexp_offset |
varchar |
22 |
√ |
|
null |
|
|
a_reval_cost_offset_prior |
varchar |
22 |
√ |
|
null |
|
|
a_reval_cost_offset |
varchar |
22 |
√ |
|
null |
|
|
a_reval_cal_method |
varchar |
22 |
√ |
|
null |
|
|
a_reval_accumdep_offset_prior |
varchar |
22 |
√ |
|
null |
|
|
a_reval_accumdep_offset_cur |
varchar |
22 |
√ |
|
null |
|
|
a_disposal_revenue |
varchar |
22 |
√ |
|
null |
|
|
uselifeyears |
numeric |
0 |
√ |
|
null |
|
|
uselifemonths |
numeric |
10 |
√ |
|
(0)::numeric |
|
|
processing |
bpchar |
1 |
√ |
|
null |
|
|
postingtype |
bpchar |
1 |
|
|
'A'::bpchar |
|
|
depreciationtype |
varchar |
10 |
√ |
|
null |
|
|
conventiontype |
varchar |
10 |
√ |
|
null |
|
|
a_depreciation_table_header_id |
numeric |
10 |
√ |
|
null |
|
|
a_depreciation_manual_amount |
numeric |
0 |
√ |
|
null |
|
|
a_depreciation_calc_type |
varchar |
10 |
√ |
|
null |
|
|
a_asset_spread_type |
varchar |
10 |
√ |
|
null |
|
|
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 |
|
|
a_disposal_gain_acct |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
a_depreciation_method_id |
numeric |
10 |
√ |
|
null |
|
|
a_depreciation_conv_f_id |
numeric |
10 |
√ |
|
null |
|
|
a_depreciation_conv_id |
numeric |
10 |
√ |
|
null |
|
|
a_depreciation_method_f_id |
numeric |
10 |
√ |
|
null |
|
|
a_depreciation_variable_perc_f |
numeric |
0 |
√ |
|
null |
|
|
a_depreciation_f_id |
numeric |
10 |
|
|
|
|
|
uselifeyears_f |
numeric |
0 |
|
|
'0'::numeric |
|
|
uselifemonths_f |
numeric |
10 |
|
|
(0)::numeric |
|
|
a_disposal_revenue_acct |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
a_disposal_loss_acct |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
a_asset_group_acct_uu |
varchar |
36 |
√ |
|
NULL::character varying |
|
|