Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
a_depreciation_workfile_id | numeric | 10 | null |
|
|
||||||
ad_client_id | numeric | 10 | null |
|
|
||||||
ad_org_id | numeric | 10 | null |
|
|
||||||
a_accumulated_depr | numeric | 0 | (0)::numeric |
|
|
||||||
a_asset_cost | numeric | 0 | (0)::numeric |
|
|
||||||
a_asset_id | numeric | 10 | null |
|
|
||||||
a_asset_life_current_year | numeric | 0 | (0)::numeric |
|
|
||||||
a_period_forecast | numeric | 0 | √ | null |
|
|
|||||
a_prior_year_accumulated_depr | numeric | 0 | √ | null |
|
|
|||||
postingtype | bpchar | 1 | √ | 'A'::bpchar |
|
|
Constraint Name | Constraint |
---|---|
a_depreciation_workfile_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
a_depreciation_workfile_isdepreciated_check | ((isdepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
a_depreciation_workfile_processing_check | ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
a_depreciation_workfile_processed_check | ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |