Dictionary > Module Time management > Table Temporary table (planning) 

TableAbbreviationTitleModuleActivity code
TMPPLNTPLTemporary table (planning)Time management 

KeyDescriptionDuplicatesActivity code
TPL0USR+NUMREQ+REFNUM+CTRNUM+DATNo 

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
BRKTIMRest break3DCB2.2    
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRUser AUS  [AUS]CODUSR=[TPL]CREUSROther 
CTRNUMContract CTR     
DATDate D     
DAYNGTDay/night3M15402   
ENDTIMEnd time3HM     
NATCODNature of activity3NAT  [NAT]NAT0=[TPL]NATCODBlock 
NBRDAYDays NDY     
NBRHOUHours NDY     
NUMREQQuery no. L8    
NUMWEKWeek no. C2    
REFNUMEmployee ID MAT  [ID]ID0=[TPL]REFNUMDelete 
STRTIMStart time3HM     
TYPDAYDay type M15401   
UPDDATTIMDate time ADATIM     
UPDUSRUser AUS  [AUS]CODUSR=[TPL]UPDUSROther 
USROperator AUS  [AUS]CODUSR=[TPL]USRDelete