JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponseslinesattachments

Stores supporting documents for each line of a supplier’s draft response, such as technical specifications or proposals.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking the attachment to a specific response within the negotiation.
LinesLineId [KEY] Long The unique identifier for the negotiation response line, allowing the attachment to be linked to a specific line within the response.
LinesResponseNumber [KEY] Long The identifier for the negotiation response, linking the attachment to the relevant response in the negotiation.
AttachedDocumentId [KEY] Long The unique identifier for the attached document. This value is generated by the system when the document is uploaded, serving as the primary key for the attachment.
LastUpdateDate Datetime The date and time when the attachment was last updated by a user, helping to track when changes were made.
LastUpdatedBy String The user who most recently updated the attachment, providing accountability for any modifications made to the attachment record.
DatatypeCode String An abbreviation that identifies the type of attachment data, such as 'FILE', 'FOLDER', 'TEXT', or 'WEB_PAGE', specifying the format of the attachment.
FileName String The name of the attachment file, used to identify the document in the system and by users.
DmFolderPath String The folder path in the document management system where the attachment is stored, helping to locate the file within the system.
DmDocumentId String The unique identifier for the document in the document management system, used for retrieval and management of the attachment.
DmVersionNumber String The version number of the attached document, enabling version control and tracking changes made to the attachment.
Url String The URI (Uniform Resource Identifier) that directly identifies the attachment's location, providing a link to access the file.
CategoryName String The category assigned to the attachment, such as 'From Supplier', 'From Supplier: Technical', or 'From Supplier: Commercial', categorizing the attachment based on its stage in the negotiation.
UserName String The sign-in details (user login) of the person who added or modified the attachment, used for accountability and auditing purposes.
Uri String The URI (Uniform Resource Identifier) that identifies the attachment in the system, providing a link to access it.
FileUrl String The URL (Uniform Resource Locator) for the attachment, allowing users to access or download the document.
UploadedText String The textual content of the attachment, applicable when the attachment is a text-based document.
UploadedFileContentType String The content type of the uploaded file, indicating its format.
UploadedFileLength Long The length (size) of the attached file, typically measured in bytes, indicating how large the file is.
UploadedFileName String The name of the uploaded file, which may be different from the original file name if modified during upload.
ContentRepositoryFileShared Bool A flag indicating whether the attachment is shared in the content repository. If true, the attachment is shared; if false, it is not. The default value is false.
Title String The title of the attachment, providing a brief description or name for easy identification.
Description String A detailed description of the attachment, providing context and explanation for its contents and purpose within the negotiation.
ErrorStatusCode String An error code identifying any issues encountered during the attachment process, providing a quick way to diagnose problems.
ErrorStatusMessage String The error message associated with any issues encountered during the attachment process, providing detailed information about the error.
CreatedBy String The user who created the attachment record, offering transparency and accountability for the creation of the file.
CreationDate Datetime The date and time when the attachment record was created, establishing a timeline for the document.
FileContents String The contents of the attachment, typically stored as text or Base64-encoded data, enabling inspection or processing of the attachment.
ExpirationDate Datetime The date when the attachment expires, indicating when the document will no longer be considered valid or accessible.
LastUpdatedByUserName String The login details of the user who last updated the attachment, providing transparency on who made the most recent changes.
CreatedByUserName String The user name of the person who created the attachment, providing context for who initially uploaded the document.
AsyncTrackerId String An identifier used for tracking the status and progress of asynchronous file uploads, helpful for handling large files.
FileWebImage String A Base64-encoded image of the attachment, displayed in .png format if the file source is an image that can be converted for viewing.
DownloadInfo String A JSON-formatted string containing information needed to programmatically retrieve a large file attachment, used in automated systems.
PostProcessingAction String The name of the action that should be performed after the attachment is uploaded, such as validation or indexing for future use.
Finder String A search identifier used to locate specific attachment records related to the negotiation response.
ResponseNumber Long The unique identifier for the supplier's response, linking the attachment to the corresponding response in the negotiation process.
EffectiveDate Date The effective date of the attachment, marking when the document is considered valid for use or review in the negotiation.

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