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    

Copyright © 2019, 2024, Oracle and/or its affiliates.