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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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 |