i_hr_movement

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_hr_movement_id numeric 10 null
ad_client_id numeric 10 √ NULL::numeric
ad_org_id numeric 10 √ NULL::numeric
amount numeric 0 √ null
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_ihrmovement R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ NULL::numeric
hr_concept_id numeric 10 √ NULL::numeric
hr_concept.hr_concept_id hrconcept_ihrmovement R
hr_process_id numeric 10 √ NULL::numeric
hr_process.hr_process_id hrprocess_ihrmovement R
isactive bpchar 1 √ NULL::bpchar
processed bpchar 1 √ NULL::bpchar
qty numeric 0 √ null
servicedate timestamp 29,6 √ null
textmsg varchar 255 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ NULL::numeric
validfrom timestamp 29,6 √ null
i_isimported varchar 1 'N'::character varying
i_errormsg varchar 2000 √ NULL::character varying
processing bpchar 1 √ NULL::bpchar
bpartner_value varchar 40 √ NULL::character varying
conceptvalue varchar 40 √ NULL::character varying
hr_movement_id numeric 10 √ NULL::numeric
hr_movement.hr_movement_id hrmovement_ihrmovement R
processname varchar 60 √ NULL::character varying
description varchar 255 √ NULL::character varying
i_hr_movement_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
i_hr_movement_key Primary key Asc i_hr_movement_id
i_hr_movement_uu_idx Must be unique Asc i_hr_movement_uu

Check Constraints

Constraint Name Constraint
i_hr_movement_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_hr_movement_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation