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