TimeRecords
TimeRecords
Columns
Name | Type | Description |
TimeRecordId [KEY] | Double | TimeRecordId of TimeRecords |
TimeRecordGroupId | Long | TimeRecordGroupId of TimeRecords |
StartTime | Datetime | StartTime of TimeRecords |
StopTime | Datetime | StopTime of TimeRecords |
GroupType | String | GroupType of TimeRecords |
RecordType | String | RecordType of TimeRecords |
Measure | Double | Measure of TimeRecords |
UnitOfMeasure | String | UnitOfMeasure of TimeRecords |
PersonNumber | String | PersonNumber of TimeRecords |
PersonId | Long | PersonId of TimeRecords |
Comment | String | Comment of TimeRecords |
AssignmentNumber | String | AssignmentNumber of TimeRecords |
TimeRecordGroupVersion | Int | TimeRecordGroupVersion of TimeRecords |
TimeRecordVersion | Int | TimeRecordVersion of TimeRecords |
OvertimeDate | Date | OvertimeDate of TimeRecords |
EarnedDate | Date | EarnedDate of TimeRecords |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |