ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderOperationWorkOrderOperationAttachment

Holds documents attached to specific work order operations, facilitating documentation and compliance.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier for the work order associated with this operation attachment. This identifier links the attachment to the correct work order for tracking and reference.
WorkorderoperationWorkOrderOperationId [KEY] Long The unique identifier for the work order operation to which this attachment belongs. This identifier ensures that each attachment is correctly linked to the appropriate operation step.
AttachedDocumentId [KEY] Long The unique identifier for the attached document. This identifier links it to the work order operation for easy retrieval and reference.
LastUpdateDate Datetime The date and time when this attachment record was last updated. These metrics help track changes and maintain an audit history.
LastUpdatedBy String The username or identifier of the individual who last updated this attachment, ensuring accountability and traceability.
DatatypeCode String The data type of the attached file (for example, 'text', 'image', or 'PDF'). This field helps categorize files for appropriate handling.
FileName String The name of the attached file as stored in the system. This name helps users identify the document by name.
DmFolderPath String The folder path in the document management system where the file is stored. This path provides the physical storage location for the attachment.
DmDocumentId String The unique identifier for the document in the document management system. This identifier enables quick retrieval.
DmVersionNumber String The version number of the document in the document management system. This number ensures access to the latest or specific document versions.
Url String The Uniform Resource Locator (URL) linking to the attached document. This URL allows quick access to the file in the system.
CategoryName String The category or classification of the attached document (for example, 'Work Instructions' or 'Quality Reports'). This classification helps organize documents systematically.
UserName String The username of the individual who uploaded or last interacted with this attachment. This name supports user-based tracking.
Uri String The Uniform Resource Identifier (URI) that uniquely identifies the location of the file. This URI provides precise referencing in the system.
FileUrl String The complete URL to the file, used for downloading or viewing the attachment in an external system or portal.
UploadedText String The text content extracted from the uploaded file. This extracted content allows for text-based searching and indexing.
UploadedFileContentType String The content type of the uploaded file. This content type ensures correct processing and display of the file.
UploadedFileLength Long The size of the uploaded file in bytes. This metric helps in storage management and prevents excessive file sizes.
UploadedFileName String The original name of the file when it was uploaded. This name helps maintain a reference to the source document.
ContentRepositoryFileShared Bool A flag indicating whether the file is shared within the content repository. This flag determines accessibility and permissions for the document.
Title String The title or subject of the attachment, often used for display purposes and quick identification.
Description String A brief description of the attached document. This description explains its purpose and relevance to the work order operation.
ErrorStatusCode String A system-generated code representing an error status if any issues occurred during file processing or attachment.
ErrorStatusMessage String A detailed error message describing any issues encountered during the attachment process. This error message aids in troubleshooting.
CreatedBy String The username or identifier of the individual who originally created this attachment record. This identifier ensures traceability of its source.
CreationDate Datetime The date and time when this attachment record was created. These metrics support compliance and data integrity.
FileContents String The raw or processed content of the uploaded file. This processed content is used for text extraction or archival purposes.
ExpirationDate Datetime The date when the document or attachment expires. This metric ensures controlled document lifecycle management.
LastUpdatedByUserName String The username of the person who most recently updated the record. This name ensures clear accountability.
CreatedByUserName String The username of the person who originally created the record. This name provides traceability for its origin.
AsyncTrackerId String A unique identifier used to track asynchronous processes related to file uploads or attachments. This identifier ensures proper system processing.
FileWebImage String A web-accessible image representation of the attached file, such as a thumbnail or preview. This representation helps users quickly identify the file without needing to download it.
DownloadInfo String Information or metadata about how and where the file can be downloaded, including links or download configurations for the attachment.
PostProcessingAction String The action triggered after processing the attached file, such as sending notifications, updating records, or initiating workflows.
BackToBackFlag String Indicates whether this attachment is associated with a back-to-back order process. Back-to-back orders tie the demand directly to supply orders, ensuring alignment between manufacturing and procurement.
ContractMfgFlag String Indicates whether the attachment is related to contract manufacturing. This flag supports tracking of files associated with outsourced production activities.
DueDays Int The number of days remaining until the work order operation or attachment is due. This metric helps in monitoring deadlines and ensuring timely completion.
Finder String A search key or identifier used to locate specific attachments or associated records in the system. This identifier improves efficiency in large datasets.
FirmPlannedFlag String Indicates whether the associated work order operation or attachment is firm-planned, meaning it is locked and not subject to changes or rescheduling.
InventoryItemId Long The unique identifier for the inventory item related to the work order operation. This identifier links the attachment to the relevant inventory records.
ItemNumber String The specific item number for the material associated with the work order operation. This number serves as a unique identifier in inventory and production tracking.
MaterialItemId Long The unique identifier for the material associated with the work order operation. This identifier ensures traceability for materials and attachments throughout production.
OrganizationId Long The identifier for the organization or business unit responsible for the work order operation or attachment. This identifier supports multi-organization operations.
PlannedCompletionDate Datetime The planned date and time for completing the work order operation or related activity. These metrics help in aligning the attachment timeline with production schedules.
PlannedStartDate Datetime The planned date and time for starting the work order operation or activity associated with the attachment. These metrics ensure alignment with the production workflow.
ProductSerialId Long The unique serial identifier for the product associated with the work order operation. This serial identifier supports detailed tracking of serialized products.
ResourceId Long The unique identifier for the resource (for example, 'machine', 'tool', or 'personnel') associated with the work order operation. This identifier helps link attachments to specific resources.
SerialNumber String The serial number of the material or product related to the work order operation. This serial number ensures traceability for serialized items.
SourceHeaderReferenceId Long The reference identifier linking the work order operation and attachment to the header of the source document, such as a sales order or project plan.
SourceHeaderRefId Long An alternate reference identifier for the source header, often used for legacy system compatibility or integrations.
SourceLineReferenceId Long The reference identifier linking the work order operation and attachment to a specific line in the source document, such as a sales order line.
SourceLineRefId Long An alternate reference identifier for the source line, used for integration or legacy system purposes.
SourceSystemId Long The identifier for the external system from which the work order operation and attachment data originate. This identifier supports traceability across integrated systems.
Tolerance Int The allowable tolerance for variations in material usage or specifications for the work order operation. This metric helps maintain quality while avoiding unnecessary rework.
WoProjectNumber String The project number associated with the work order operation. This number links the attachment to a broader project framework for tracking and reporting.
WorkAreaId Long The unique identifier for the work area where the operation is executed. This identifier helps organize attachments by the specific production area.
WorkCenterId Long The unique identifier for the work center associated with the work order operation. This identifier ensures attachments are correctly linked to the responsible production unit.
WorkOrderId Long The unique identifier for the work order associated with the attachment. This identifier links all relevant attachments to the overarching production job.
WorkOrderNumber String The user-friendly number assigned to the work order. This number helps reference the work order and its associated attachments in reports and workflows.
WorkOrderStatusId Long The identifier for the current status of the work order (for example, 'Planned,' 'In Progress,' or 'Completed'). This identifier ensures attachment status aligns with production progress.
WoTaskNumber String The specific task number within the work order associated with the operation or attachment. This number enables detailed tracking at the task level.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175