Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderAssemblyComponent

The Work Order Assemblies resource manages the assembly that the application issued as a component to the work order for rework.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponent
OrganizationId Long Value that uniquely identifies the inventory organization that's enabled for manufacturing. It is a primary key of the inventory organization.
WorkOrderId Long Value that uniquely identifies the reworked work order. It is a primary key of the rework work order.
WoOperationId Long Value that uniquely identifies the first count point operation of the rework that references this material. This material is an assembly that the work order will rework. It is a primary key of the work order operation.
OperationSequenceNumber Decimal OperationSequenceNumber of WorkOrdersWorkOrderAssemblyComponent
OperationName String OperationName of WorkOrdersWorkOrderAssemblyComponent
WoOperationMaterialId [KEY] Long Value that uniquely identifies the rework that references the material. This material is an assembly that the work order will rework. It is a primary key of the material.
InventoryItemId Long Value that uniquely identifies the item, product, or assembly in the inventory organization.
ItemNumber String ItemNumber of WorkOrdersWorkOrderAssemblyComponent
Quantity Decimal Planned quantity of the reworked assembly for the work order. This is equal to the work order quantity.
UnitOfMeasure String UnitOfMeasure of WorkOrdersWorkOrderAssemblyComponent
SupplySubinventory String Subinventory to use, by default, when the plant gets the material for rework.
SupplyLocatorId Long Value that uniquely identifies the locator. It is a primary key that the application generates when it creates the locator.
SupplyLocator String Locator in the subinventory to use, by default, when the plant gets the material for rework.
ReservedQuantity Decimal ReservedQuantity of WorkOrdersWorkOrderAssemblyComponent
IssuedQuantity Decimal Quantity of the reworked assembly that the application issues for the operation when it releases the work order.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderAssemblyComponent
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderAssemblyComponent
DueDays Int DueDays of WorkOrdersWorkOrderAssemblyComponent
Finder String Finder of WorkOrdersWorkOrderAssemblyComponent
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderAssemblyComponent
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderAssemblyComponent
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderAssemblyComponent
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderAssemblyComponent
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderAssemblyComponent
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderAssemblyComponent
ResourceId Long ResourceId of WorkOrdersWorkOrderAssemblyComponent
SerialNumber String SerialNumber of WorkOrdersWorkOrderAssemblyComponent
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderAssemblyComponent
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderAssemblyComponent
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderAssemblyComponent
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderAssemblyComponent
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderAssemblyComponent
Tolerance Int Tolerance of WorkOrdersWorkOrderAssemblyComponent
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderAssemblyComponent
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderAssemblyComponent
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderAssemblyComponent
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderAssemblyComponent
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderAssemblyComponent
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderAssemblyComponent

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