WorkOrdersWorkOrderStatusHistory

Columns


Name	Type	Description
WorkOrdersWorkOrderId [KEY]	Long	WorkOrdersWorkOrderId of WorkOrdersWorkOrderStatusHistory
WoStatusHistoryId [KEY]	Long	WoStatusHistoryId of WorkOrdersWorkOrderStatusHistory
OrganizationId	Long	OrganizationId of WorkOrdersWorkOrderStatusHistory
WorkOrderId [KEY]	Long	WorkOrderId of WorkOrdersWorkOrderStatusHistory
StatusChangeDate	Datetime	StatusChangeDate of WorkOrdersWorkOrderStatusHistory
FromStatusId	Long	FromStatusId of WorkOrdersWorkOrderStatusHistory
FromStatusCode	String	FromStatusCode of WorkOrdersWorkOrderStatusHistory
FromSystemStatusCode	String	FromSystemStatusCode of WorkOrdersWorkOrderStatusHistory
FromStatusName	String	FromStatusName of WorkOrdersWorkOrderStatusHistory
ToStatusId	Long	ToStatusId of WorkOrdersWorkOrderStatusHistory
ToStatusCode	String	ToStatusCode of WorkOrdersWorkOrderStatusHistory
ToSystemStatusCode	String	ToSystemStatusCode of WorkOrdersWorkOrderStatusHistory
ToStatusName	String	ToStatusName of WorkOrdersWorkOrderStatusHistory
Reason	String	Reason of WorkOrdersWorkOrderStatusHistory
User	String	User of WorkOrdersWorkOrderStatusHistory

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。