PurchaseOrderslinesattachments
Contains attached documents for individual purchase order lines, such as technical specs or regulatory certifications.
Columns
| Name | Type | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the purchase order header, linking the purchase order line attachment records to the corresponding purchase order. |
| LinesPOLineId [KEY] | Long | The unique identifier for the purchase order line, used to associate the attachment with a specific item or service on the purchase order. |
| AttachedDocumentId [KEY] | Long | The unique identifier assigned to the document that is attached to the purchase order line, enabling easy reference and access to the attachment. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated, indicating when any modifications were made to the attachment information. |
| LastUpdatedBy | String | The username of the individual who last updated the attachment record, ensuring accountability for any changes made to the attachment. |
| DatatypeCode | String | The code representing the data type of the attachment, indicating the format or type (for example, 'PDF,' 'JPEG') of the attached document. |
| FileName | String | The name of the file attached to the purchase order line, used to identify and locate the document in the system. |
| DmFolderPath | String | The folder path in the document management system (DMS) where the attachment is stored, allowing for proper organization and retrieval of the file. |
| DmDocumentId | String | The document ID in the document management system (DMS) from which the attachment is created, providing a reference to the original document. |
| DmVersionNumber | String | The version number of the document from which the attachment is created, helping track changes and updates to the attached file. |
| Url | String | The URL link to a web-based attachment, providing easy access to the file hosted online. |
| CategoryName | String | The category under which the attachment is classified, helping to organize and filter attachments based on their content or purpose. |
| UserName | String | The login credentials of the user who created the attachment, providing traceability of the user responsible for uploading the file. |
| Uri | String | The URI (Uniform Resource Identifier) for a Topology Manager type attachment, providing access to the attachment within the system. |
| FileUrl | String | The URL pointing to the location of the attachment file, used to directly retrieve the document from the storage system. |
| UploadedText | String | The text content of the attachment, if the attachment is a text-based file, enabling easy access to the document's contents without downloading. |
| UploadedFileContentType | String | The content type of the file, specifying its format. |
| UploadedFileLength | Long | The size of the attachment file in bytes, used to track the storage space required for the file. |
| UploadedFileName | String | The name to be assigned to a new attachment file, helping with file naming and retrieval. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared across the system or kept private, allowing for proper access control. |
| Title | String | The title or heading of the attachment, providing a brief description or label for the document. |
| Description | String | A detailed description of the attachment, providing further context for the content and purpose of the file. |
| ErrorStatusCode | String | The error code returned, if any, related to the attachment upload or processing, used for troubleshooting and resolving issues. |
| ErrorStatusMessage | String | The error message corresponding to the error code, providing detailed information about what went wrong during the attachment process. |
| CreatedBy | String | The username of the person who created the attachment record, ensuring traceability and accountability for the creation of the file. |
| CreationDate | Datetime | The date and time when the attachment record was created, marking the initial creation and entry of the attachment into the system. |
| FileContents | String | The actual content of the attachment, used for text-based attachments where the file content is stored directly in the record. |
| ExpirationDate | Datetime | The expiration date for the contents of the attachment, used for determining how long the file remains valid or accessible. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record, providing accountability for any changes made after the record was created. |
| CreatedByUserName | String | The username of the person who created the attachment record, ensuring proper traceability of the file's origin. |
| AsyncTrackerId | String | An attribute used by the Attachment UI components to assist in managing asynchronous file upload processes. |
| FileWebImage | String | The Base64 encoded image of the file, displayed in .png format, if the source file is an image that can be converted for display. |
| DownloadInfo | String | A JSON object represented as a string, containing information needed to programmatically retrieve the file attachment, used for automation or API interactions. |
| PostProcessingAction | String | The name of the action that can be taken once the attachment is uploaded, such as processing or validation steps. |
| Finder | String | The search function or query used to locate or filter specific attachment records based on defined criteria. |
| Intent | String | The purpose or intent behind the attachment, providing clarity on why the attachment is associated with the purchase order. |
| POHeaderId | Long | The unique identifier for the purchase order header, linking the attachment record to the overall purchase order. |
| SysEffectiveDate | String | The system effective date used to determine the active version of the attachment record, ensuring that the correct file is retrieved based on its effective period. |
| EffectiveDate | Date | The date from which the attachment is considered effective, marking when the attachment's data is valid and applicable. |