WorkOrdersWorkOrderLotNumber
WorkOrdersWorkOrderLotNumber
Columns
Name | Type | Description |
WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderLotNumber |
WorkOrderProductLotId [KEY] | Long | WorkOrderProductLotId of WorkOrdersWorkOrderLotNumber |
LotNumber | String | Number that identifies the lot used for the work order item. This attribute is associated with a feature that requires opt in. |
ParentLotNumber | String | Number that identifies the parent lot of the lot number used for the work order item. This attribute is applicable if the work order item is lot controlled. This attribute is associated with a feature that requires opt in. |
LotExpirationDate | Date | Date and time when the product lot expires. This attribute is associated with a feature that requires opt in. |
CreatedBy | String | CreatedBy of WorkOrdersWorkOrderLotNumber |
CreationDate | Datetime | CreationDate of WorkOrdersWorkOrderLotNumber |
LastUpdatedBy | String | LastUpdatedBy of WorkOrdersWorkOrderLotNumber |
LastUpdateDate | Datetime | LastUpdateDate of WorkOrdersWorkOrderLotNumber |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
BackToBackFlag | String | BackToBackFlag |
ContractMfgFlag | String | ContractMfgFlag |
DueDays | Int | DueDays |
FirmPlannedFlag | String | FirmPlannedFlag |
InventoryItemId | Long | InventoryItemId |
ItemNumber | String | ItemNumber |
MaterialItemId | Long | MaterialItemId |
OrganizationId | Long | OrganizationId |
PlannedCompletionDate | Datetime | PlannedCompletionDate |
PlannedStartDate | Datetime | PlannedStartDate |
ProductSerialId | Long | ProductSerialId |
ResourceId | Long | ResourceId |
SerialNumber | String | SerialNumber |
SourceHeaderRefId | Long | SourceHeaderRefId |
SourceHeaderReferenceId | Long | SourceHeaderReferenceId |
SourceLineRefId | Long | SourceLineRefId |
SourceLineReferenceId | Long | SourceLineReferenceId |
SourceSystemId | Long | SourceSystemId |
Tolerance | Int | Tolerance |
WoProjectNumber | String | WoProjectNumber |
WoTaskNumber | String | WoTaskNumber |
WorkAreaId | Long | WorkAreaId |
WorkCenterId | Long | WorkCenterId |
WorkOrderId | Long | WorkOrderId |
WorkOrderNumber | String | WorkOrderNumber |
WorkOrderStatusId | Long | WorkOrderStatusId |
Finder | String | finder |