PurchaseRequisitionslinesattachments
Attaches supporting files to requisition lines, such as product specs or vendor quotes, ensuring clear documentation.
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the attachment, linking the attachment to a specific requisition. Example: 1001 for Requisition ID 1001. |
| LinesRequisitionLineId [KEY] | Long | The identifier for the requisition line within the requisition, linking the attachment to a specific line item. Example: 2001 for Line 1. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attached document, used to track and reference the document in the system. Example: 3456 for the document ID. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated. This helps track the latest modification to the attachment. Example: '2023-01-15 09:00:00'. |
| LastUpdatedBy | String | The username or identifier of the user who last updated the attachment record. Example: 'JohnDoe' for the user making the last change. |
| DatatypeCode | String | An abbreviation representing the type of data contained in the attachment, such as 'PDF' or 'JPEG'. |
| FileName | String | The name of the attached file, reflecting the original file name. Example: 'Invoice_1001.pdf'. |
| DmFolderPath | String | The path of the folder from which the attachment was created, used to locate the source document within the document management system. Example: '/docs/invoices/'. |
| DmDocumentId | String | The unique identifier for the document in the document management system from which the attachment is derived. Example: 'DOC1234' for a specific document. |
| DmVersionNumber | String | The version number of the document from which the attachment was created. This helps track document revisions. Example: 'V1' for version 1. |
| Url | String | The URL of a web page-type attachment, pointing to a web-based document or resource. Example: 'http://example.com/attachment'. |
| CategoryName | String | The name of the attachment category, used for classification. Example: 'Invoice', 'Contract', 'Receipt'. |
| UserName | String | The login credentials of the user who created the attachment. Example: 'jdoe' for 'John Doe'. |
| Uri | String | The URI (Uniform Resource Identifier) for a topology manager-type attachment, pointing to its location in a network or system. Example: 'topo://attachment/4567'. |
| FileUrl | String | The URL of the file, providing access to the attached file for download or view. Example: 'http://example.com/file/attachment.pdf'. |
| UploadedText | String | The content of a text file attached to the requisition line. This is used when the attachment is a text-based document. Example: 'This is a contract agreement.' |
| UploadedFileContentType | String | The content type of the attached file, indicating its format. |
| UploadedFileLength | Long | The size of the attached file, measured in bytes. Example: 1048576 for a 1 MB file. |
| UploadedFileName | String | The name assigned to the uploaded file, which may differ from the original file name. Example: 'invoice_123.pdf'. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared across systems or repositories. True if shared, False if not. Example: True for shared files. |
| Title | String | The title of the attachment, providing a brief description of its content. Example: 'Purchase Order Agreement'. |
| Description | String | A more detailed description of the attachment, offering context for the content. Example: 'This document outlines the terms for purchase order 1001.' |
| ErrorStatusCode | String | The error code, if any, indicating a problem with the attachment. Example: 'FILE_ERR' for a file error. |
| ErrorStatusMessage | String | The error message, if any, detailing the issue with the attachment. Example: 'File format not supported'. |
| CreatedBy | String | The user who initially created the attachment record, typically the person who uploaded the file. Example: 'Jane Smith'. |
| CreationDate | Datetime | The date and time when the attachment was initially created. Example: '2023-01-10 08:30:00'. |
| FileContents | String | The contents of the attached file, usually for text-based attachments. Example: 'Details of the purchase order for 100 units.' |
| ExpirationDate | Datetime | The date when the attachment expires or is no longer valid. Example: '2023-02-01 00:00:00'. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record. Example: 'john.doe'. |
| CreatedByUserName | String | The username of the person who initially created the attachment. Example: 'janesmith'. |
| AsyncTrackerId | String | An identifier used to track the asynchronous upload process for the attachment. Example: 'upload12345'. |
| FileWebImage | String | A Base64-encoded image of the file displayed in .png format, if the file source is a convertible image. Example: 'iVBORw0KGgoAAAANSUhEU...'. |
| DownloadInfo | String | A JSON object as a string containing information used to programmatically retrieve a file attachment. Example: '{url |
| PostProcessingAction | String | The name of the action that can be performed after the attachment is uploaded, such as validation, conversion, or approval. Example: 'Approve Attachment'. |
| BindPreparerId | Long | The identifier for the preparer of the requisition line, linking the attachment to the preparer's data. Example: 5001 for 'John Doe'. |
| BindRequisitionHeaderId | Long | The identifier for the requisition header, linking the attachment to the parent requisition. Example: 2001 for 'Requisition 2001'. |
| Finder | String | A placeholder or reference for the search functionality, used to locate the attachment record. Example: 'Search Attachments'. |
| RequisitionHeaderId | Long | The identifier for the requisition header, used to link the attachment to the parent requisition header. Example: 3001 for 'Requisition Header 3001'. |
| CUReferenceNumber | Int | Maps the child aggregates (attachments) to their parent requisition or requisition line. Example: 1001 for 'Requisition Line 1'. |
| EffectiveDate | Date | The date from which the attachment is considered effective. Example: '2023-01-01', used to fetch resources that are valid from this date. |