![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1/Software Distribution Description and Planning Guide
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
This table stores the result of searching software inventory at a client.
| Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
|---|---|---|---|---|---|---|---|---|
| Data type | Size | Data type | Size | Data type | Size | |||
| dm_ppname | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Software name | -- |
| dm_filename | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Names of files constituting the software | 1 |
| dm_createdate | CHAR | 19 | char | 19 | CHAR | 19 | Date and time the software was created | 2 |
| dm_filesize | VARCHAR2 | 10 | varchar | 10 | VARCHAR | 10 | File size of the software | 3 |
| dm_company | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Company name of the software | -- |
| dm_language | CHAR | 2 | char | 2 | VARCHAR | 2 | Language identifier of the software | -- |
| dm_charid | CHAR | 2 | char | 2 | MCHAR | 2 | (Unused) | -- |
| dm_sversion | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Version of the software | -- |
| dm_productname | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Product name of the software | -- |
| dm_serchdate | CHAR | 19 | char | 19 | CHAR | 19 | Search date of the software | -- |
| dm_pflg1 | CHAR | 1 | char | 1 | MCHAR | 1 | Option flag 1 (record status):
|
-- |
| dm_pflg2 | CHAR | 1 | char | 1 | MCHAR | 1 | Option flag 2 | -- |
| dm_ppno | NUMBER | 10 | int | 4 | INTEGER | -- | Internal information of JP1/Software Distribution (program product number) | -- |
| dm_pathname | VARCHAR2 | 255 | varchar | 255 | MVARCHAR | 255 | Path to the software | -- |
| dm_fversion | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | File version | -- |
| dm_comment | VARCHAR2 | 50 | varchar | 50 | MVARCHAR | 50 | Comment | -- |
| dm_systemtime | CHAR | 19 | char | 19 | CHAR | 19 | Creation date (UTC) | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.