JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

WorkOrdersWorkOrderLotNumber

The Work Order Lots resource manages the product lots for the work order item. This resource is associated with a feature that requires opt in.

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
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderLotNumber
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderLotNumber
DueDays Int DueDays of WorkOrdersWorkOrderLotNumber
Finder String Finder of WorkOrdersWorkOrderLotNumber
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderLotNumber
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderLotNumber
ItemNumber String ItemNumber of WorkOrdersWorkOrderLotNumber
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderLotNumber
OrganizationId Long OrganizationId of WorkOrdersWorkOrderLotNumber
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderLotNumber
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderLotNumber
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderLotNumber
ResourceId Long ResourceId of WorkOrdersWorkOrderLotNumber
SerialNumber String SerialNumber of WorkOrdersWorkOrderLotNumber
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderLotNumber
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderLotNumber
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderLotNumber
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderLotNumber
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderLotNumber
Tolerance Int Tolerance of WorkOrdersWorkOrderLotNumber
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderLotNumber
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderLotNumber
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderLotNumber
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderLotNumber
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderLotNumber
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderLotNumber
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderLotNumber

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062