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. |