JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationslinesattachments

Manages line-level attachments (drawings, product sheets) for negotiation lines, ensuring clarity in requested goods or services.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long Unique identifier for the auction header, linking the attachment data to a specific auction event in the negotiation process.
LinesAuctionHeaderId [KEY] Long Unique identifier for the auction header related to the specific negotiation line attachment, helping to track the attachment in the context of the line.
LinesLineId [KEY] Decimal Unique identifier for the negotiation line associated with the attachment, helping to link the document to a specific line in the negotiation.
AttachedDocumentId [KEY] Long Primary key identifying the attachment, uniquely assigned by the system when the user attaches a document to a negotiation line.
LastUpdateDate Datetime The date and time when the attachment record was last updated, providing a timestamp for the most recent change to the record.
LastUpdatedBy String The username or identifier of the user who last updated the attachment record, ensuring accountability for changes made.
DatatypeCode String Abbreviation identifying the data type of the attachment. Accepted values include 'FILE', 'FOLDER', 'TEXT', or 'WEB_PAGE', specifying the format or type of the attachment.
FileName String The name of the file associated with the attachment, providing a reference to the document.
DmFolderPath String The folder path in the document management system (DMS) where the attachment is stored, helping to locate the document within the system.
DmDocumentId String Unique identifier for the document in the document management system, ensuring precise tracking and retrieval of the attached file.
DmVersionNumber String Version number of the attached document, used for version control and to track different versions of the same document.
Url String URI (Uniform Resource Identifier) linking to the attachment, providing a consistent reference for accessing the document.
CategoryName String The category to which the attachment belongs, providing a way to classify and group related documents.
UserName String The login credentials of the user who created the attachment record, tracking who uploaded the file.
Uri String URI (Uniform Resource Identifier) that uniquely identifies the attachment, offering a consistent reference for the document across systems.
FileUrl String The URL of the attachment, used to access or download the file directly from the system.
UploadedText String Text content associated with the attachment, often used to describe the document or provide additional context.
UploadedFileContentType String The content type of the uploaded file, indicating its format.
UploadedFileLength Long The length of the attached file in bytes, providing information on the file size.
UploadedFileName String The original file name when the attachment was uploaded, typically retained for reference.
ContentRepositoryFileShared Bool Flag indicating whether the attachment is shared within the content repository. If true, the file is shared; if false, it is not.
Title String The title of the attachment, summarizing the contents or purpose of the document.
Description String A description of the attachment, providing additional context or details about the content of the document.
ErrorStatusCode String Code identifying any errors associated with the attachment, helping to track issues during the attachment process.
ErrorStatusMessage String Message providing details about the error, if any, encountered during the attachment process.
CreatedBy String The name or identifier of the user who created the attachment record, ensuring accountability for the data entry.
CreationDate Datetime The date and time when the attachment record was created, marking when the document was initially added to the system.
FileContents String The contents of the attachment, typically used for text-based documents to store raw text data.
ExpirationDate Datetime The date when the contents of the attachment expire, indicating when the document is no longer valid or accessible.
LastUpdatedByUserName String The username of the person who last updated the attachment record, providing visibility into who made the most recent changes.
CreatedByUserName String The username of the person who created the attachment record, indicating who initially uploaded the document.
AsyncTrackerId String An identifier used to track the status of asynchronous tasks related to the attachment, such as file processing or conversion.
FileWebImage String Base64 encoded image of the file, displayed in .png format if the attachment is a convertible image, providing a visual preview of the document.
DownloadInfo String JSON object represented as a string, containing metadata and information used to programmatically retrieve the file attachment.
PostProcessingAction String Name of the action that can be performed after the attachment is uploaded, such as categorization or further processing.
AuctionHeaderId Long Unique identifier for the auction header, linking the attachment data to a specific auction event.
Finder String Search or query reference used for locating or filtering specific attachment records within the system.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified date, ensuring that only relevant data for the given period is retrieved.

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