PackingUnitsnestedPackingUnitsattachments
Manages file and document attachments associated with nested packing units for better tracking and documentation.
Columns
| Name | Type | Description |
| PackingUnitsPackingUnitId [KEY] | Long | Unique identifier for the packing unit in the PackingUnitsnestedPackingUnitsattachments table. It links this table to the PackingUnits table. |
| NestedpackingunitsPackingUnitId [KEY] | Long | Unique identifier for the nested packing unit in the PackingUnitsnestedPackingUnitsattachments table. It references a packing unit within another packing unit. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the attached document in the system, ensuring each attachment can be referenced individually. |
| LastUpdateDate | Datetime | Timestamp of the last update made to the PackingUnitsnestedPackingUnitsattachments record. It helps track changes over time. |
| LastUpdatedBy | String | The username or identifier of the person or system who last modified the record in the PackingUnitsnestedPackingUnitsattachments table. |
| DatatypeCode | String | A short code that represents the data type of the attachment. This could indicate the file type or data format. |
| FileName | String | The name of the file as stored in the system. It typically includes the file extension to indicate its format (for example, 'report.pdf'). |
| DmFolderPath | String | The location within the document management system where the attachment is stored, helping users find and access the file. |
| DmDocumentId | String | A unique identifier assigned to the document within the document management system. It allows the system to locate and retrieve the document. |
| DmVersionNumber | String | The version number of the attached document. This is crucial for version control to ensure the correct version is accessed or used. |
| Url | String | The web URL (Uniform Resource Locator) pointing to the attachment location. This field is populated only when the attachment type is URL-based. |
| CategoryName | String | Category under which the attachment is classified, which could refer to the type or purpose of the file (for example, 'Invoice', 'Shipping Label'). |
| UserName | String | Username associated with the record, typically indicating the person who is associated with the attachment entry or transaction. |
| Uri | String | Uniform Resource Identifier used to locate the attachment within a base URI. This attribute is not actively used by the Packing Units resource. |
| FileUrl | String | URL of the file attachment stored in the Oracle WebCenter Content server. This is used to reference files uploaded via the system. |
| UploadedText | String | Text content of the uploaded attachment. This could be used when the attachment is a text-based file or when metadata needs to be recorded. |
| UploadedFileContentType | String | MIME type of the uploaded file, indicating the file format (for example, 'application/pdf', 'image/jpeg'). |
| UploadedFileLength | Long | Size of the uploaded file, measured in bytes. It provides information on how large the file is, which is important for storage management. |
| UploadedFileName | String | The name of the file as uploaded to the system, which may be different from the file name on the user's device. |
| ContentRepositoryFileShared | Bool | Indicates whether the uploaded file is shared within the content repository. A 'true' value means the file is shared, while 'false' means it is not. |
| Title | String | Title or name given to the attachment. This could be used for easy identification, often serving as a brief description. |
| Description | String | Detailed description of the attachment. This may provide additional context on the content or purpose of the file. |
| ErrorStatusCode | String | Code representing the error status of the attachment if an error occurred during upload or processing. |
| ErrorStatusMessage | String | A textual message describing the error encountered during attachment processing, providing context to resolve the issue. |
| CreatedBy | String | The username or identifier of the person or system that initially created the PackingUnitsnestedPackingUnitsattachments record. |
| CreationDate | Datetime | Timestamp indicating when the record for the attachment was created in the system, often used for tracking the record's age. |
| FileContents | String | Text or binary data that constitutes the contents of the attachment, relevant for text-based attachments or small files. |
| ExpirationDate | Datetime | Date when the attachment will expire or become inaccessible. This could be used for time-sensitive documents or contracts. |
| LastUpdatedByUserName | String | Username of the individual or system that last updated the PackingUnitsnestedPackingUnitsattachments record, providing tracking for updates. |
| CreatedByUserName | String | Username of the individual or system that initially created the record for the attachment in the system. |
| AsyncTrackerId | String | Unique identifier used by the Attachment UI components to track the asynchronous file upload process, ensuring files are uploaded correctly. |
| FileWebImage | String | Image or thumbnail representation of the file. This is typically used for visual previews of the file in the user interface. |
| DownloadInfo | String | A JSON-formatted string that contains metadata and details needed to retrieve large file attachments programmatically. |
| PostProcessingAction | String | Defines any post-processing action that can be performed after the attachment is uploaded, such as validation or conversion. |
| Finder | String | Identifier for the attachment record's finder or search key. This may be used in custom querying or filtering to find specific attachments. |
| PackingUnitId | Long | Unique identifier of the packing unit to which the attachment is associated, linking this record to the relevant packing unit. |
| PPackingUnit | String | Identifier for a parent packing unit, if applicable, that further links this attachment to a higher-level packing unit in the hierarchy. |