ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9539

ProcessWorkOrdersOperationMaterialMaterialAttachment

ProcessWorkOrdersOperationMaterialMaterialAttachment

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long Parent work order identifier (references process work order).
OperationWorkOrderOperationId [KEY] Long Parent operation identifier for the work order.
MaterialWorkOrderOperationMaterialId [KEY] Long Identifier of the material record within the operation (parent).
AttachedDocumentId [KEY] Long Unique identifier of the attached document.
LastUpdateDate Datetime Date/time when this attachment record was last updated (UTC).
LastUpdatedBy String User who last updated this attachment record.
DatatypeCode String Code indicating the attachment data type (e.g., file, URL).
FileName String Original file name of the attachment.
DmFolderPath String Document management folder path for the attachment.
DmDocumentId String Document ID from the document management system.
DmVersionNumber String Version number of the source document.
Url String URL of the attachment (for web link attachments).
CategoryName String The category of the attachment.
UserName String The login credentials of the user who created the attachment.
Uri String The URI of a Topology Manager type attachment.
FileUrl String The URI of the file.
UploadedText String The text content for a new text attachment.
UploadedFileContentType String The content type of the attachment.
UploadedFileLength Long The size of the attachment file.
UploadedFileName String The name to assign to a new attachment file.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared
Title String The title of the attachment.
Description String The description of the attachment.
ErrorStatusCode String The error code, if any, for the attachment.
ErrorStatusMessage String The error message, if any, for the attachment.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
FileContents String The contents of the attachment.
ExpirationDate Datetime The expiration date of the contents in the attachment.
LastUpdatedByUserName String The user name who last updated the record.
CreatedByUserName String The user name who created the record.
AsyncTrackerId String Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
FileWebImage String The base64 encoded image of the file displayed in .png format if the source is a convertible image.
DownloadInfo String JSON object represented as a string containing information used to programmatically retrieve a file attachment.
PostProcessingAction String The name of the action that can be performed after an attachment is uploaded.
BackToBackFlag String Indicates whether the work order is back-to-back (back-to-back flag).
ContractMfgFlag String Flag indicating contract manufacturing status.
DueDays Int Number of days until (or past) the due date for the work order.
Finder String Finder identifier used to select specific finder logic or view.
FirmPlannedFlag String Flag indicating whether the work order is firm planned.
InventoryItemId Long Identifier of the inventory item associated with the work order or material.
ItemNumber String Item number or SKU associated with the work order/material.
MaterialItemId Long Identifier of the material item used in the operation.
OrganizationId Long Identifier of the organization responsible for the work order.
PlannedCompletionDate Datetime Planned completion date/time for the work order (UTC).
PlannedStartDate Datetime Planned start date/time for the work order (UTC).
ProductSerialId Long Identifier for the product serial number associated with the work order.
ResourceId Long Identifier of the resource assigned to the operation/work order.
SerialNumber String Serial number of the product or component.
SourceHeaderReferenceId Long Reference identifier for the source header associated with this record.
SourceHeaderRefId Long Reference identifier for the source header (alternate field).
SourceLineReferenceId Long Reference identifier for the source line associated with this record.
SourceLineRefId Long Reference identifier for the source line (alternate field).
SourceSystemId Long Identifier of the source system that provided this record.
Tolerance Int Tolerance value for the work order/material (units depend on context).
WoProjectNumber String Project number associated with the work order.
WorkAreaId Long Identifier of the work area where the operation is scheduled.
WorkCenterId Long Identifier of the work center where the operation will be performed.
WorkOrderId Long Primary identifier of the work order.
WorkOrderNumber String Human-readable work order number/code.
WorkOrderStatusId Long Identifier representing the current status of the work order.
WoTaskNumber String Task number within the work order (if applicable).

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539