ReceivingReceiptRequestslinestransactionAttachments
Facilitates the management of attachments associated with receipt line transaction requests.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the header of the receiving receipt request in the ReceivingReceiptRequestslinestransactionAttachments table. |
| LinesInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction of the receiving receipt request line within the ReceivingReceiptRequestslinestransactionAttachments table. |
| AttachedDocumentId [KEY] | Long | Primary key that uniquely identifies an attachment associated with a specific shipment line in the advanced shipment notice (ASN) line request. |
| LastUpdateDate | Datetime | Timestamp of the last update made to the ReceivingReceiptRequestslinestransactionAttachments record. |
| LastUpdatedBy | String | The username of the individual who last updated the record in the ReceivingReceiptRequestslinestransactionAttachments table. |
| DatatypeCode | String | A short code that indicates the type of data associated with the attachment, such as text or image. |
| FileName | String | The name of the file that was uploaded as an attachment to the ASN line request. |
| DmFolderPath | String | The directory or folder path within the document management system where the attachment is stored. |
| DmDocumentId | String | Unique identifier assigned to the document stored in the content management system (CMS). |
| DmVersionNumber | String | A version identifier for a document stored in the content management system, used to track different versions of a document. |
| Url | String | Web URL that links directly to the location of the attachment for the ASN line request. |
| CategoryName | String | A classification or category under which the attachment for the ASN line request is grouped. |
| UserName | String | The username of the individual associated with the specific entry in the ReceivingReceiptRequestslinestransactionAttachments table. |
| Uri | String | A unique identifier used for the attachment, typically in URI format, to locate and retrieve the attachment. |
| FileUrl | String | A direct URL link to access the attachment file for the ASN line request. |
| UploadedText | String | Text content extracted from or associated with the uploaded file for the ASN line request. |
| UploadedFileContentType | String | The MIME type that specifies the format of the uploaded attachment, such as PDF, image, etc. |
| UploadedFileLength | Long | The size, in bytes, of the uploaded file associated with the ASN line request. |
| UploadedFileName | String | The actual filename of the attachment uploaded to the system for the ASN line request. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared (true) or not shared (false) in the content repository. Default is true. |
| Title | String | The title or brief description of the attachment associated with the ASN line request. |
| Description | String | A detailed description of the uploaded attachment, explaining its relevance or content within the context of the ASN line request. |
| ErrorStatusCode | String | A short code representing any error that may have occurred during the attachment process for the ASN line request. |
| ErrorStatusMessage | String | Detailed message providing information about any errors encountered during the attachment process. |
| CreatedBy | String | The username of the individual who created the record in the ReceivingReceiptRequestslinestransactionAttachments table. |
| CreationDate | Datetime | Timestamp indicating when the record for the attachment was created in the system. |
| FileContents | String | The actual contents of the uploaded file, typically used for text-based files within the ASN line request. |
| ExpirationDate | Datetime | The date when the attachment associated with the ASN line request will no longer be valid or accessible. |
| LastUpdatedByUserName | String | Username of the individual who last updated the record, specifically for the user-related data. |
| CreatedByUserName | String | Username of the individual who created the record in the system, particularly for user-related information. |
| AsyncTrackerId | String | An identifier used internally to track the progress of file uploads, specifically for the Attachment UI components. |
| FileWebImage | String | An image preview or thumbnail associated with the file in the ReceivingReceiptRequestslinestransactionAttachments table. |
| DownloadInfo | String | A JSON-formatted string containing the necessary information for programmatically retrieving large file attachments. |
| PostProcessingAction | String | The name of the post-processing action that can be executed once an attachment is uploaded, such as validation or moving to another system. |
| CustomerId | Long | Unique identifier for the customer associated with the attachment in the ReceivingReceiptRequestslinestransactionAttachments table. |
| CustomerPartyName | String | The name of the customer party involved in the transaction related to the attachment. |
| DocumentNumber | String | The document number associated with the attachment, often used to link the attachment to a specific document or record. |
| ExternalSystemTransactionReference | String | A reference code used to link the attachment to an external system's transaction or reference ID. |
| Finder | String | Search key or identifier used to locate specific records or attachments within the ReceivingReceiptRequestslinestransactionAttachments table. |
| FromDate | Datetime | Start date that indicates the range of time from which the attachment data is applicable. |
| FromOrganizationCode | String | Code representing the organization from which the attachment originates. |
| FromOrganizationId | Long | Unique identifier for the organization from which the attachment is associated. |
| GroupId | Long | Group identifier used to categorize and group related attachments in the system. |
| HeaderInterfaceId | Long | Identifier for the header interface that links the attachment to its broader receiving or shipment context. |
| ItemId | Long | Identifier for the item associated with the attachment in the receiving receipt request. |
| ItemNumber | String | The number assigned to the item involved in the receiving receipt request attachment. |
| OrganizationCode | String | Code that represents the organization managing or owning the attachment. |
| OrganizationId | Long | Unique identifier for the organization in the system related to the attachment. |
| POHeaderId | Long | Identifier for the purchase order (PO) header associated with the attachment in the receiving receipt request. |
| ProcessingStatusCode | String | Status code representing the current processing state of the attachment (for example, pending, completed). |
| ReceiptAdviceHeaderId | Long | Identifier for the receipt advice header associated with the attachment. |
| RMANumber | String | Return Merchandise Authorization (RMA) number related to the attachment, often used in returns processing. |
| ShipmentHeaderId | Long | Unique identifier for the shipment header associated with the attachment for the ASN line request. |
| ShipmentNumber | String | The number identifying the specific shipment to which the attachment is associated. |
| SourceDocumentCode | String | Code representing the source document from which the attachment originated. |
| ToDate | Datetime | End date that indicates the time range through which the attachment data is applicable. |
| TransactionStatusCode | String | Code indicating the current status of the transaction related to the attachment (for example, processing, completed). |
| TransactionType | String | Type of transaction associated with the attachment, such as receipt or shipment. |
| TransferOrderHeaderId | Long | Header identifier for the transfer order related to the attachment, often used in inter-organization transfers. |
| VendorId | Long | Unique identifier for the vendor associated with the attachment. |
| VendorName | String | The name of the vendor related to the attachment in the ASN line request. |
| VendorNumber | String | Vendor's identification number, typically used to track vendor-specific transactions. |