a_asset_split

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_split_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
a_amount_split numeric 0 √ null
a_asset_acct_id numeric 10 null
a_asset_acct.a_asset_acct_id Implied Constraint R
a_percent_original numeric 0 √ null
a_qty_current numeric 0 null
a_split_type varchar 3 null
c_period_id numeric 10 null
c_period.c_period_id cperiod_aassetsplit R
updatedby numeric 10 null
updated timestamp 29,6 statement_timestamp()
processing bpchar 1 null
processed bpchar 1 null
postingtype bpchar 1 null
isactive bpchar 1 null
dateacct timestamp 29,6 null
createdby numeric 10 null
created timestamp 29,6 statement_timestamp()
a_transfer_balance_is bpchar 1 null
a_qty_split numeric 0 √ null
a_percent_split numeric 0 √ null
a_depreciation_workfile_id numeric 10 null
a_depreciation_workfile.a_depreciation_workfile_id Implied Constraint R
a_asset_cost numeric 0 √ null
a_asset_id numeric 10 null
a_asset.a_asset_id Implied Constraint R
a_asset_id_to numeric 10 √ null
a_asset.a_asset_id aassetid_aassetsplit R
a_asset_split_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
a_asset_split_key Primary key Asc a_asset_split_id
a_asset_split_uu_idx Must be unique Asc a_asset_split_uu

Check Constraints

Constraint Name Constraint
a_asset_split_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_split_a_transfer_balance_is_check ((a_transfer_balance_is = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_split_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation