ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptTransactionRequestsattachments

Manages the attachments associated with post-receipt transactions, linking them to the receiving transaction entity.

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long The unique identifier for the receiving receipt transaction request in the system. This identifier is used to associate attachment data with the corresponding transaction.
AttachedDocumentId [KEY] Long A unique identifier for the attachment linked to a shipment line. This value is automatically generated when a document is associated with a receipt transaction request.
LastUpdateDate Datetime The timestamp of the most recent update made to the attachment information for the receiving receipt transaction request.
LastUpdatedBy String The user responsible for making the most recent update to the attachment information.
DatatypeCode String An abbreviation used to specify the type of data stored in the attachment. This helps categorize the nature of the data for processing or display.
FileName String The name of the attachment file, which may reflect the document's title or content.
DmFolderPath String The file path within the document management system where the attachment is stored.
DmDocumentId String A unique identifier assigned to the attached document within the document management system.
DmVersionNumber String The version number of the attached document, used to distinguish between different revisions of the same file.
Url String The URL (Uniform Resource Locator) pointing to the location of the attachment in the system or on a web server.
CategoryName String The category or type of the attachment, helping to classify its relevance or purpose (for example, invoice, packing slip, etc.).
UserName String The user who uploaded or last interacted with the attachment in the receiving receipt transaction request.
Uri String A Uniform Resource Identifier that uniquely identifies the attachment across the system, offering a more specific reference than the URL.
FileUrl String A web-accessible URL that directly points to the file, allowing it to be downloaded or viewed.
UploadedText String The textual content of the attachment, if applicable, such as scanned text or metadata.
UploadedFileContentType String The content type of the uploaded file, such as 'application/pdf' or 'image/jpeg', indicating its format.
UploadedFileLength Long The size of the attachment file, in bytes.
UploadedFileName String The actual name of the file uploaded as an attachment, potentially different from the 'FileName' stored in the system.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared within the content repository. A value of 'true' means it is shared, while 'false' means it is private. The default value is 'true'.
Title String A brief, descriptive title for the attachment, which may be automatically derived from the document's metadata or provided by the user.
Description String A detailed description of the attachment's contents or purpose, providing context to its relevance.
ErrorStatusCode String An abbreviation representing the error code encountered during processing of the attachment, if any.
ErrorStatusMessage String A descriptive error message explaining the issue encountered with the attachment, if any.
CreatedBy String The user who initially created the attachment record in the system.
CreationDate Datetime The timestamp indicating when the attachment record was first created in the system.
FileContents String The content of the file in text form, if available or applicable, such as for document-based attachments.
ExpirationDate Datetime The date and time after which the attachment is considered expired and may no longer be valid or accessible.
LastUpdatedByUserName String The username of the individual who last updated the attachment's details.
CreatedByUserName String The username of the individual who initially created the attachment's record.
AsyncTrackerId String A unique identifier used to track the attachment's upload process, particularly for handling asynchronous file uploads.
FileWebImage String An image representation of the file, typically a thumbnail or preview image that provides a visual summary of the attachment.
DownloadInfo String A JSON-formatted string containing all the necessary information to programmatically retrieve a large attachment, such as authentication tokens or download links.
PostProcessingAction String The name of the action that can be performed once the attachment has been uploaded, such as validating, processing, or categorizing the document.
DocumentNumber String A reference number or identifier associated with the attachment document, used for cross-referencing within the organization.
ExternalSystemTransactionReference String A reference to a transaction in an external system, providing context for integration with other business processes.
Finder String A key or identifier used for searching or finding specific attachments within the system, often used in querying the attachment database.
FromDate Datetime The starting date range for the attachment's validity or relevance, indicating the period during which it should be considered active.
GroupId Long A unique identifier used to group related attachments together, often used in batch processing or organizing multiple documents tied to the same request.
InterfaceTransactionId Long The identifier of the interface transaction related to the attachment, used for integration purposes.
ItemId String The identifier of the item associated with the attachment, typically referring to an inventory item, product, or part number.
ItemNumber String The item number corresponding to the product or part linked to the attachment, often used to reference a specific SKU or catalog entry.
OrganizationCode String The code representing the organization that is associated with the attachment, typically used to identify the relevant business unit or department.
OrganizationId String A unique identifier for the organization linked to the attachment, providing a specific reference within the system.
POHeaderId Long The identifier of the purchase order header associated with the attachment, used to link the document to a specific order.
ProcessingStatusCode String A code indicating the current processing status of the attachment, such as 'pending', 'completed', or 'error'.
ReceiptAdviceHeaderId Long The identifier of the receipt advice header, linking the attachment to the corresponding receipt advice transaction.
RMANumber String The return merchandise authorization number associated with the attachment, typically used for processing returns or exchanges.
ShipmentHeaderId Long The identifier of the shipment header, linking the attachment to a specific shipment within the system.
ShipmentNumber String The shipment number associated with the attachment, often used to track the movement of goods or materials.
SourceDocumentCode String A code indicating the type of source document from which the attachment originated, such as 'invoice' or 'packing slip'.
ToDate Datetime The ending date range for the attachment's validity or relevance, specifying when the attachment should no longer be considered active.
TransactionStatusCode String A code representing the status of the transaction related to the attachment, indicating whether it is completed, pending, or failed.
TransactionType String The type of transaction associated with the attachment, such as 'receipt', 'shipment', or 'return'.
TransferOrderHeaderId Long The identifier of the transfer order header associated with the attachment, used to link the document to a specific transfer order.

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