Time Codes
Field Name |
Caption |
Mask |
Description |
Field Type |
TC_CRT_BY |
Created By |
25x |
Created By |
Text |
TC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TC_HOURTY |
Financial Hour Type |
30x |
Hour Type from Existing Financial Package |
Text |
TC_ID |
Time Cost Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
TC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
TC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TC_MPUNITS |
Multiplier Units |
nnn.nnn |
Rate Multiplier |
Double |
TC_OID |
|
|
Visual CE Linking Field |
Long Integer |
TC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TC_STUNITS |
Straight Time Units |
nnn.nnn |
Straight Hourly Rate |
Double |
TC_TIME_CD |
Time Code |
nnn |
Time Cost |
Integer |
TC_TIME_TY |
Time Code Text |
25x |
Time Cost Text |
Text |
TC_UTYPE |
Time Type |
n |
Type of Rate used, Multiplier or Straight |
Integer |