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