DraftPurchaseOrderslinesattachments
Enables users to attach line-level documents (specifications, drawings) to a draft purchase order.
Columns
| Name | Type | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for a draft purchase order header, linking the attachment to the corresponding purchase order. |
| LinesPOLineId [KEY] | Long | The identifier for the specific line item in the purchase order that this attachment is related to. |
| AttachedDocumentId [KEY] | Long | A unique identifier for the document that is attached to the purchase order. This is a primary key assigned when the document is attached. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated in the system. |
| LastUpdatedBy | String | The user who last updated the attachment record, providing an audit trail for changes. |
| DatatypeCode | String | An abbreviation that identifies the type of data associated with the attachment (for example, image, PDF, document). |
| FileName | String | The name of the attached document file, which helps identify the document. |
| DmFolderPath | String | The folder path in the document management system where the attached document is stored. |
| DmDocumentId | String | A unique identifier for the attached document in the document management system. |
| DmVersionNumber | String | The version number of the attached document, allowing tracking of different revisions of the same document. |
| Url | String | The URI (Uniform Resource Identifier) that points to the location of the attached document. |
| CategoryName | String | The category assigned to the attached document, which helps classify the document (for example, contract, invoice, specification). |
| UserName | String | The login credentials of the user who created the attachment record in the system. |
| Uri | String | The URI (Uniform Resource Identifier) that provides a direct link to the attached document. |
| FileUrl | String | The URL (Uniform Resource Locator) that can be used to access and download the attached document. |
| UploadedText | String | The content or text extracted from the attached document, if applicable. |
| UploadedFileContentType | String | The content type of the attached document, indicating its format. |
| UploadedFileLength | Long | The length of the attached document, typically measured in bytes, to indicate file size. |
| UploadedFileName | String | The name of the file as uploaded, which might be different from the original file name if modified during upload. |
| ContentRepositoryFileShared | Bool | Indicates whether the attached document is shared (true) or not shared (false) in the content repository. |
| Title | String | The title of the attached document, providing a brief identifier or description of its content. |
| Description | String | A detailed description of the attached document, outlining its purpose or contents. |
| ErrorStatusCode | String | An error code, if any, that identifies issues encountered during the attachment process. |
| ErrorStatusMessage | String | The error message, if any, that provides more details on the issue encountered with the attachment. |
| CreatedBy | String | The user who created the attachment record, helping to track the origin of the document in the system. |
| CreationDate | Datetime | The date and time when the attachment record was created. |
| FileContents | String | The contents of the attached document, typically stored as text or Base64-encoded data. |
| ExpirationDate | Datetime | The expiration date of the attached document, indicating when the document or its contents should no longer be valid. |
| LastUpdatedByUserName | String | The user name of the person who last updated the attachment record. |
| CreatedByUserName | String | The user name of the person who initially created the attachment record. |
| AsyncTrackerId | String | An identifier used to track the asynchronous upload process of the document, particularly for large files. |
| FileWebImage | String | The Base64 encoded image of the file, typically displayed as a .png image if the source document is a convertible image format. |
| DownloadInfo | String | A JSON-formatted string containing necessary information to retrieve large file attachments programmatically. |
| PostProcessingAction | String | The name of the action that can be performed after the attachment is uploaded, such as processing or validation steps. |
| Finder | String | A search identifier used to locate specific attachment records in the system. |
| Intent | String | Describes the intended action for the attachment, such as creating, updating, or reviewing an attachment. |
| POHeaderId | Long | The purchase order header ID associated with this attachment, linking it to the corresponding purchase order. |
| SysEffectiveDate | String | The system’s effective date, indicating when the attachment record was created or last modified. |
| CUReferenceNumber | Int | An identifier used to link child aggregate records with their corresponding parent tables for consistency. |
| EffectiveDate | Date | The effective date of the attached document, used to determine when it becomes valid or applicable in relation to the purchase order. |