Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderAssemblyComponent

WorkOrdersWorkOrderAssemblyComponent

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 Double 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 Double 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 Double ReservedQuantity of WorkOrdersWorkOrderAssemblyComponent
IssuedQuantity Double Quantity of the reworked assembly that the application issues for the operation when it releases the work order.

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
LastUpdateDate Datetime LastUpdateDate
MaterialItemId Long MaterialItemId
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
WorkOrderNumber String WorkOrderNumber
WorkOrderStatusId Long WorkOrderStatusId
Finder String finder

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