PurchaseRequisitionsattachments
Maintains documents attached to purchase requisitions, such as quotes, justifications, or requirement definitions.
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. |
| 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 | The unique identifier used to bind the preparer’s data during operations on the attachment. |
| BindRequisitionHeaderId | Long | 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 | 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. |