PurchaseRequisitionsattachments
Maintains documents attached to purchase requisitions, such as quotes, justifications, or requirement definitions.
Columns
| Name | Type | SupportedFinders | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the attachment, linking the attachment to a specific requisition. | |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attached document, used to track and reference the document in the system. | |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated, reflecting the most recent modification to the attachment data. | |
| LastUpdatedBy | String | The username or identifier of the user who last modified the attachment record. | |
| DatatypeCode | String | An abbreviation that represents the type of data for the attachment (for example, PDF, DOCX, IMAGE). | |
| FileName | String | The name of the attached file, typically reflecting the original file name before upload. | |
| DmFolderPath | String | The path of the folder from which the document was attached, used to locate the source document within the document management system. | |
| DmDocumentId | String | The unique identifier for the document in the document management system from which the attachment is derived. | |
| DmVersionNumber | String | The version number of the document from which the attachment was created, helping to track document revisions. | |
| Url | String | The URL that points to a web-based attachment, typically used for web page or online content attachments. | |
| CategoryName | String | The name of the category assigned to the attachment, used for organizing and classifying attachments (for example, Invoice, Receipt). | |
| UserName | String | The username of the person who created the attachment record, identifying the individual responsible for the attachment. | |
| Uri | String | The URI (Uniform Resource Identifier) associated with a topology manager type attachment, pointing to its location. | |
| FileUrl | String | The URL used to access the file attachment, enabling users to download or view the file. | |
| UploadedText | String | The contents of a text file attachment, typically stored in plain text format. | |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. | |
| UploadedFileLength | Long | The size of the uploaded file, measured in bytes. | |
| UploadedFileName | String | The name assigned to the uploaded file, which may differ from the original file name. | |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users or systems (True/False). | |
| Title | String | The title of the attachment, often used for display purposes to describe the content of the attachment. | |
| Description | String | A description of the attachment, providing additional context or information about the file. | |
| ErrorStatusCode | String | The error code, if any, related to the attachment, indicating issues during upload or processing. | |
| ErrorStatusMessage | String | The error message, if any, describing the issue encountered during the attachment's processing. | |
| CreatedBy | String | The username or identifier of the user who created the attachment record in the system. | |
| CreationDate | Datetime | The date and time when the attachment record was created in the system. | |
| FileContents | String | The contents of the file as text, typically used for text-based attachments such as documents or notes. | |
| ExpirationDate | Datetime | The date when the attachment's contents are no longer valid or accessible, after which the attachment may be deleted or archived. | |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record. | |
| CreatedByUserName | String | The username of the person who initially created the attachment record. | |
| AsyncTrackerId | String | A unique identifier used to track the asynchronous upload process of files, ensuring proper tracking of upload progress. | |
| FileWebImage | String | The Base64-encoded image representation of the file, displayed in .png format, if the file is an image that can be rendered. | |
| DownloadInfo | String | A JSON object, represented as a string, containing all necessary information required to programmatically retrieve or download the attachment. | |
| PostProcessingAction | String | The name of the post-upload action that can be performed on the attachment, such as validation, approval, or conversion. | |
| BindPreparerId | Long | InternallyManagedRequisitionsFinder, ActiveRequisitionInPreferredBUFinder | The unique identifier used to bind the preparer’s data during operations on the attachment. |
| BindRequisitionHeaderId | Long | ViewAccessibleRequisitionDetailsFinder | The unique identifier used to bind the requisition header data during operations on the attachment. |
| Finder | String | A placeholder or reference for the search functionality within the system used to locate specific attachment records. | |
| RequisitionHeaderId | Long | PrimaryKey | The identifier for the requisition header linked to the attachment, used for connecting the attachment to the corresponding requisition. |
| CUReferenceNumber | Int | A reference number used to link child aggregates with their parent tables, ensuring data consistency and integrity. | |
| EffectiveDate | Date | The date from which the attachment's data is considered effective, used to filter records by their validity date. |