PurchaseOrdersattachments
Stores documents (for example, contracts, specifications) linked to a purchase order, enhancing detail for audits or approvals.
Columns
| Name | Type | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the purchase order header, linking the attachment record to the associated purchase order. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the document that is attached to the purchase order, providing a reference to the attached file or document. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated, ensuring that the latest changes are reflected in the system. |
| LastUpdatedBy | String | The name of the user who last updated the attachment record, ensuring accountability for changes made to the attachment. |
| DatatypeCode | String | A code indicating the data type of the attachment, such as 'PDF,' 'image,' or 'text,' providing context for handling the file. |
| FileName | String | The name of the attachment file, used for identification and organization of the attached document. |
| DmFolderPath | String | The folder path from which the attachment was created, providing context for the file’s storage location in the document management system. |
| DmDocumentId | String | The document ID from which the attachment was created, used to track the source document in the document management system. |
| DmVersionNumber | String | The version number of the document from which the attachment was created, ensuring that the correct version is referenced. |
| Url | String | The URL of a web page attachment, used when the attachment is a web-based document or link. |
| CategoryName | String | The category or classification of the attachment, helping to organize and sort attachments based on their purpose or content. |
| UserName | String | The login credentials of the user who created the attachment, ensuring accountability for the upload process. |
| Uri | String | The URI for Topology Manager type attachments, providing a unique identifier for the attachment in the system. |
| FileUrl | String | The URI of the file, allowing direct access to the attachment for download or viewing. |
| UploadedText | String | The text content of a new text attachment, used when the attachment is plain text rather than a file. |
| UploadedFileContentType | String | The content type of the uploaded attachment, indicating its format. |
| UploadedFileLength | Long | The size of the attachment file in bytes, providing information on the file's storage requirements. |
| UploadedFileName | String | The name assigned to the newly uploaded attachment file, used for identification and management within the system. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users or systems, allowing for collaborative access. |
| Title | String | The title of the attachment, typically used for quick identification of the attachment's purpose or content. |
| Description | String | A detailed description of the attachment, providing context and information about the file’s contents or significance. |
| ErrorStatusCode | String | The error code associated with the attachment, if any, providing insight into issues encountered during the attachment process. |
| ErrorStatusMessage | String | The error message associated with the attachment, if any, offering details about why the attachment failed or encountered an issue. |
| CreatedBy | String | The name of the user who created the attachment record, ensuring accountability for the upload process. |
| CreationDate | Datetime | The date and time when the attachment record was created, providing a historical record of when the file was added to the system. |
| FileContents | String | The contents of the attachment, used when the attachment is text-based or to hold metadata about the file. |
| ExpirationDate | Datetime | The expiration date of the attachment’s contents, indicating when the attachment should no longer be considered valid or active. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record, providing transparency regarding changes. |
| CreatedByUserName | String | The username of the person who originally created the attachment record, ensuring tracking of the file’s origin. |
| AsyncTrackerId | String | An attribute provided for the exclusive use by the Attachment UI components to assist in uploading files asynchronously. |
| FileWebImage | String | The Base64 encoded image of the file, displayed in PNG format if the source is a convertible image, providing a visual representation of the attachment. |
| DownloadInfo | String | A JSON object represented as a string, containing information necessary for programmatically retrieving the file attachment. |
| PostProcessingAction | String | The name of the action that can be performed after the attachment is uploaded, such as 'Process' or 'Notify.' |
| Finder | String | The search function or query used to locate or filter attachment records, helping to retrieve specific attachments based on defined criteria. |
| Intent | String | The intent of the attachment, providing context on how the attachment is to be used or processed (for example, 'Invoice,' 'PO Document'). |
| POHeaderId | Long | The purchase order header ID that links this attachment to a specific purchase order, ensuring that the attachment is correctly associated with the order. |
| SysEffectiveDate | String | The system effective date used to determine the active version of the attachment, ensuring that the correct version is retrieved based on its effective date. |
| EffectiveDate | Date | The date used to fetch attachment records that are effective as of this date, ensuring accurate data retrieval based on the active period. |