Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot

The Lots for Assemblies resource manages the lot that the application issued for the assembly that the rework work order uses.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkorderassemblycomponentWoOperationMaterialId [KEY] Long WorkorderassemblycomponentWoOperationMaterialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoOperationMaterialLotId [KEY] Long WoOperationMaterialLotId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
LotNumber String Lot number of the reworked assembly.
AssociatedQuantity Decimal Quantity for the lot number to issue for the reworked work order.
IssuedQuantity Decimal IssuedQuantity of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoOperationMaterialId Long Value that uniquely identifies the reworked assembly. It is a primary key that the application generates when it creates the item.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
DueDays Int DueDays of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
Finder String Finder of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
ItemNumber String ItemNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
OrganizationId Long OrganizationId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
ResourceId Long ResourceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SerialNumber String SerialNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
Tolerance Int Tolerance of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot

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