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