Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF

The Flexfields for Operation Materials resource manages descriptive flexfields that contain details about the materials that the work order operation processes.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkorderoperationmaterialWorkOrderOperationMaterialId [KEY] Long WorkorderoperationmaterialWorkOrderOperationMaterialId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WoOperationMaterialId [KEY] Long Value that uniquely identifies the material for the work order operation. It is a primary key that the application generates when it creates the material for the work order operation.
_FLEX_Context String Descriptive flexfield context name for work order operation materials.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for work order operation materials.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
DueDays Int DueDays of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
Finder String Finder of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
ResourceId Long ResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
Tolerance Int Tolerance of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF

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