Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF

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

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