ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceivingReceiptRequestslinesASNLineAttachments

Handles attachments for advance shipment notice (ASN) line requests, ensuring all supporting documents are accessible.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long Unique identifier for the header of the Receiving Receipt Request in the ReceivingReceiptRequestslinesASNLineAttachments table. This identifier associates a specific request to its respective header record.
LinesInterfaceTransactionId [KEY] Long Unique identifier for the transaction related to the line item in the ReceivingReceiptRequestslinesASNLineAttachments table. This ID links the attachment to a specific transaction for processing.
AttachedDocumentId [KEY] Long Unique identifier for the attachment associated with a shipment line. This value is generated by the application when a document is attached to the Advanced Shipment Notice (ASN) line request.
LastUpdateDate Datetime Timestamp indicating when the record was last updated in the ReceivingReceiptRequestslinesASNLineAttachments table.
LastUpdatedBy String The username or identifier of the user who last updated the record in the ReceivingReceiptRequestslinesASNLineAttachments table.
DatatypeCode String Code representing the type of data for the attachment, such as file type or data format.
FileName String The name of the file attached to the Advanced Shipment Notice (ASN) line request.
DmFolderPath String Path within the document management system where the attachment is stored.
DmDocumentId String Identifier of the document in the document management system, which uniquely associates the attachment with its content in the system.
DmVersionNumber String Number indicating the version of the document within the document management system, useful for tracking changes or revisions.
Url String URL (Uniform Resource Locator) that points to the location of the attachment for the ASN line request, accessible over the web.
CategoryName String Category classification of the attachment, such as ‘Invoice,’ ‘Packing Slip,’ or ‘Shipping Label,’ for better organization.
UserName String Username of the person associated with the attachment in the ReceivingReceiptRequestslinesASNLineAttachments table.
Uri String URI (Uniform Resource Identifier) used to uniquely identify the attachment within the system, often used for integration purposes.
FileUrl String URL (Uniform Resource Locator) for directly accessing the attachment via the web.
UploadedText String Text content of the attachment, if it is a text-based document, included as part of the ASN line request.
UploadedFileContentType String MIME type that specifies the content format of the uploaded file.
UploadedFileLength Long Size in bytes of the uploaded file attached to the ASN line request.
UploadedFileName String Original name of the uploaded file, as provided when it was attached to the ASN line request.
ContentRepositoryFileShared Bool Indicates whether the attachment is shared within the content repository. 'True' means the file is shared, while 'False' means it is not.
Title String Title of the attachment that briefly describes or identifies its content, typically shown in UI interfaces.
Description String Detailed description of the attachment, explaining its contents or purpose in the context of the ASN line request.
ErrorStatusCode String Code representing the error status, if applicable, that occurred during processing of the attachment for the ASN line request.
ErrorStatusMessage String Message detailing the error, if any, that occurred when processing the attachment for the ASN line request.
CreatedBy String Username or identifier of the user who created the attachment record in the ReceivingReceiptRequestslinesASNLineAttachments table.
CreationDate Datetime Timestamp indicating when the attachment record was initially created in the ReceivingReceiptRequestslinesASNLineAttachments table.
FileContents String Text or metadata describing the contents of the file attached to the ASN line request, often used for data extraction or analysis.
ExpirationDate Datetime Date on which the attachment will expire, after which it may be archived or deleted based on the policy.
LastUpdatedByUserName String Username of the person who last updated the attachment record in the ReceivingReceiptRequestslinesASNLineAttachments table.
CreatedByUserName String Username of the person who originally created the attachment record in the ReceivingReceiptRequestslinesASNLineAttachments table.
AsyncTrackerId String Unique identifier used for tracking the asynchronous upload process of large file attachments in the UI.
FileWebImage String Reference to an image associated with the attachment that can be used to preview the file content in the web interface.
DownloadInfo String JSON-formatted data providing necessary details for programmatically retrieving large file attachments from the system.
PostProcessingAction String Defines the action that should be taken after an attachment is uploaded, such as processing or validation.
CustomerId Long Identifier of the customer related to the attachment in the ReceivingReceiptRequestslinesASNLineAttachments table.
CustomerPartyName String Name of the customer associated with the attachment, as identified in the ReceivingReceiptRequestslinesASNLineAttachments table.
DocumentNumber String Unique identifier for the document associated with the attachment, used for reference or tracking purposes.
ExternalSystemTransactionReference String Reference to a transaction in an external system that is related to the attachment, linking it to external processes.
Finder String Value used for finding or searching specific attachment records in the ReceivingReceiptRequestslinesASNLineAttachments table.
FromDate Datetime Start date of the period for which the attachment is relevant or applicable in the ReceivingReceiptRequestslinesASNLineAttachments table.
FromOrganizationCode String Code identifying the organization that the attachment is associated with in the ReceivingReceiptRequestslinesASNLineAttachments table.
FromOrganizationId Long Unique identifier for the organization associated with the attachment in the ReceivingReceiptRequestslinesASNLineAttachments table.
GroupId Long Identifier for the group of attachments to which the current attachment belongs.
HeaderInterfaceId Long Identifier for the header interface record, linking the attachment to a specific transaction header in the system.
ItemId Long Unique identifier for the item associated with the attachment, allowing linkage to the item in inventory or order systems.
ItemNumber String Unique number for the item associated with the attachment in the ReceivingReceiptRequestslinesASNLineAttachments table.
OrganizationCode String Code identifying the organization within which the attachment is stored or relevant.
OrganizationId Long Unique identifier for the organization associated with the attachment in the ReceivingReceiptRequestslinesASNLineAttachments table.
POHeaderId Long Unique identifier for the purchase order header, linking the attachment to a specific purchase order in the system.
ProcessingStatusCode String Code representing the processing status of the attachment.
ReceiptAdviceHeaderId Long Identifier for the receipt advice header that relates to the attachment, which provides information on received goods.
RMANumber String Number associated with the Return Merchandise Authorization (RMA) process, relating the attachment to an RMA record.
ShipmentHeaderId Long Unique identifier for the shipment header that associates the attachment with a specific shipment record.
ShipmentNumber String Shipment number associated with the attachment, used to track the specific shipment for the ASN line request.
SourceDocumentCode String Code identifying the source document for the attachment, helping to link it to its origin, such as an order or invoice.
ToDate Datetime End date of the period for which the attachment is relevant or applicable in the ReceivingReceiptRequestslinesASNLineAttachments table.
TransactionStatusCode String Code representing the current status of the transaction associated with the attachment, such as ‘In Progress’ or ‘Completed.’
TransactionType String Type of transaction associated with the attachment, such as ‘Receipt,’ ‘Return,’ or ‘Transfer.’
TransferOrderHeaderId Long Unique identifier for the transfer order header that associates the attachment with a specific transfer order.
VendorId Long Identifier for the vendor associated with the attachment, linking it to the vendor in the ReceivingReceiptRequestslinesASNLineAttachments table.
VendorName String Name of the vendor associated with the attachment, typically used to identify the source of goods or services.
VendorNumber String Vendor's unique number in the system, which is used to track and identify transactions with that vendor.

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