DW_TNL_TIMECARD_ENTRY_LINK_D (Preview)

This table requires activation of Time and Labor functional area. Holds the link between Day Time Card and Time entry

Details

Module: Time and Labor

Key Columns

TM_REC_GRP_USAGES_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TM_REC_GRP_USAGES_ID NUMBER 38 0 True Primary Key for Time rec group usage in Fusion Source.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
ENTERPRISE_ID NUMBER 38 0 Enterprise Identifier
DAY_TM_REC_GRP_ID NUMBER 38 0 Time card Identifier DW_TNL_TIMECARD_DAY_D DAY_TM_REC_GRP_ID
DAY_TM_REC_GRP_VERSION NUMBER 38 0 Timer card version number DW_TNL_TIMECARD_DAY_D DAY_TM_REC_GRP_VERSION
TM_REC_ID NUMBER 38 0 Time Entry Identifier DW_TNL_TIMEENTRY_F TM_REC_ID
TM_REC_VERSION NUMBER 38 0 Time Entry version number DW_TNL_TIMEENTRY_F TM_REC_VERSION
LATEST_VERSION VARCHAR2 16 Latest version