TM_ACTUALS

This table stores the actuals for each time sheet item including cost information and associated Activities. A single time sheet item will contain a row in this table for each Activity associated with the item (a single row if no Activities are used), and an additional row for the total, which is indicated by the TOTALS_FLAG.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
ITG_ACTIVITIES_NLS	ACTIVITY_ID	ACTIVITY_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
TM_TIME_SHEET_LINES	TIME_SHEET_LINE_ID	TIME_SHEET_LINE_ID
KNTA_USERS	USER_ID	CREATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
ACTUALS_ID	NOT NULL	NUMBER	System-generated identifier
VERSION	NOT NULL	NUMBER	System-generated version for the entity. This column must not be updated manually.
ACTIVITY_ID	NULLABLE	NUMBER	Indicates an associated Activity to time sheet item.
ACT_CAP_LABOR_BSE	NULLABLE	NUMBER	Captures the actual capitalized labor costs in the system's base currency.
ACT_CAP_LABOR_LCL	NULLABLE	NUMBER	Captures the actual capitalized labor costs in the local currency.
ACT_CAP_LABOR_CUR_LCL	NULLABLE	VARCHAR2(255)	Captures the currency code for the local currency used by the actual capitalized labor costs.
ACT_CAP_NON_LABOR_BSE	NULLABLE	NUMBER	Captures the actual capitalized non-labor costs in the system's base currency.
ACT_CAP_NON_LABOR_LCL	NULLABLE	NUMBER	Captures the actual capitalized non-labor costs in the local currency.
ACT_CAP_NON_LABOR_CUR_LCL	NULLABLE	VARCHAR2(255)	Captures the currency code for the local currency used by the actual capitalized non-labor costs.
ACT_OP_LABOR_BSE	NULLABLE	NUMBER	Captures the actual operational labor costs in the system's base currency.
ACT_OP_LABOR_LCL	NULLABLE	NUMBER	Captures the actual operational labor costs in the local currency.
ACT_OP_LABOR_CUR_LCL	NULLABLE	VARCHAR2(255)	Captures the currency code for the local currency used by the actual operational labor costs.
ACT_OP_NON_LABOR_BSE	NULLABLE	NUMBER	Captures the actual operational non-labor costs in the system's base currency.
ACT_OP_NON_LABOR_LCL	NULLABLE	NUMBER	Captures the actual operational non-labor costs in the local currency.
ACT_OP_NON_LABOR_CUR_LCL	NULLABLE	VARCHAR2(255)	Captures the currency code for the local currency used by the actual operational non-labor costs.
TOTALS_FLAG	NULLABLE	VARCHAR2(1)	Indicates whether the row represents a total for a single time sheet item, as opposed to an Activity. Y = Total, N = Non-Total.
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
TIME_SHEET_LINE_ID	NULLABLE	NUMBER	References the TIME_SHEET_LINE_ID in TM_TIME_SHEET_LINES.
TIME_ACTUALS_SEQ	NULLABLE	NUMBER	Captures the internal ordering of the rows for each time sheet item.

Indexes

Index Name	Index Type	Sequence	Column Name
FK19BFB4DFA2C1EF93_I	NONUNIQUE	1	ACTIVITY_ID
FK19BFB4DFE2408E7_I	NONUNIQUE	1	TIME_SHEET_LINE_ID
SYS_C005201593	UNIQUE	1	ACTUALS_ID

Sequences

Sequence Name	Sequence Type
TM_ACTUALS_S	ACTUALS_ID