This topic is contained in the PDXpert help file: select Contents from the application's Help menu.

ItemView & ItemMasterView reference

The ItemView contains all part and document records with standard item attributes. The ItemMasterView contains all columns of the ItemView plus all custom attributes.

A basic SQL statement is SELECT * FROM ItemView

The Class column is coded: the value 1 indicates that the item is a part, while the value 2 indicates that it's a document. For example:

SELECT ClassName = CASE Class WHEN 1 THEN 'Part' WHEN 2 THEN 'Document' ELSE 'Unknown' END FROM ItemView

All dates are displayed using SQL Server's default format. If you need a different format, such as ISO 8601, then a conversion is required. For example:

SELECT convert(varchar(23),CostDate,126) AS IsoCostDate FROM ItemView

Booleans ("checkbox values") are zero or non-zero integers. The value 0 indicates that the logical value is False; any non-zero value, such as 1, indicates that the logical value is True. Null values are possible. For example:

You can use the IsCanceled, Revision and PendingRevision values to obtain insight into the item's current release state.

Release state	IsCanceled	Revision	PendingRevision
Pending	false	null	not null
Released	false	not null	null
Released (with Pending)	false	not null	not null
Canceled	true	not null*	null
Canceled (with Pending)	true	not null*	not null

* In releases prior to 7.1, these values were null. The obsolete HasPending column can be derived as HasPending = CASE WHEN [PendingRevision] IS NULL THEN 0 ELSE 1 END

Column definitions

There may exist in the view one or more "housekeeping" columns that have been reserved for PDXpert's private use. These columns' names begin with the prefix HK (for instance, HK1). Housekeeping columns may be redefined or eliminated in a future PDXpert release. These columns will not be documented, and you should ignore them in your SQL queries. Do not create any custom attributes that use the HK prefix. You may want to create a user-defined view that excludes the housekeeping columns.

The column ordering may not be exactly as shown in this table, and may change in a future PDXpert release. Use the column name, not ordinal position, in your SQL queries.

Column name	Data type	Attribute name (note 1)
ItemId	GUID (item primary key)	unique record identifier; not visible within PDXpert client
Class	integer 1:Part or 2:Document	item Class
Owner	Organizations Name	item Owner
OwnerShort	Organizations Display name	item Owner
IsHomeItem (note 2)	Boolean	calculated; not visible within PDXpert client
Type	Document Types or Part Types Name	item Type
TypeShort	Document Types or Part Types Abbreviation	item Type
Number	string	item Number
RevID	GUID (revision primary key)	unique released (or canceled) record identifier; not visible within PDXpert client
IsCanceled	Boolean	released revision has been canceled not visible within PDXpert client
Revision	string	released (or canceled) item Revision
RevisionNote	string	released (or canceled) item Revision description
PendingRevID	GUID (revision primary key)	unique pending record identifier; not visible within PDXpert client
PendingRevision	string	item's pending Revision
PendingLifecycle	Item Lifecycle Phases Name	pending revision Lifecycle phase
PendingRevisionNote	string	item pending Revision description
ReleasedOn	date	released revision Released date
Description	string	item Document title or Part name
Lifecycle	Item Lifecycle Phases Name	released revision Lifecycle phase
Version	string	released revision Version
Trustee	Persons Name	item Trustee
DefaultUoM	Unit of Measures Name	part Default unit of measure
MakeBuy	Make/Buy Categories Name	part Make/buy
GlobalNumber	string	part Global number (GTIN, UPC, etc.)
Location	string	part Location
Handling	Handling/Storage Categories Name	part Handling/storage advisory
Recovery	Recovery Methods Name	part End of life recovery method
CostPerUnit	real number	part Unit cost per default unit value
CostCurrencyShort	Currencies Code	part Unit cost per default unit : Currency
CostDate	date	part Unit cost per default unit : As on
PackageQty	integer	part Standard packaging quantity value
PackageUOM	Unit of Measures Name	part Standard packaging quantity units
Certify	Boolean	part Part requires: Certification
Serialize	Boolean	part Part requires: Serialization
Complies	Boolean	part Meets regulatory requirements
Notes	string	item Notes
custom (note 3)	string	custom attribute text or numeric value
custom_Member (note 3)	collection member Name	custom attribute value's units, or other collection member

Notes:

1. Part attributes are undefined for document rows (that is, where Class is 2).
2. A True value represents a home part or document; a False value is a partner item. This value will never be NULL.
3. These columns are included in the ItemMasterView, and are not in the ItemView. All administrator-assigned custom attribute ("CA") names are displayed in value/unit columns; the name is used in the column header. All identically-named CAs are displayed in the same column, regardless of item type. Where a custom attribute name conflicts with an existing system-assigned attribute name (such as Number or Type) then the custom attribute name will be displayed with a leading underscore (_Number or _Type). See the help topic Contents > Collections reference > Custom attributes for naming guidelines. If a custom attribute name is longer than 120 characters, it will be truncated.
4. If an item has no pending revision, then the pending revision values (e.g., PendingRevID) will be null. Similarly, the revision-related values (e.g., RevID) will be null if the item has neither a released nor canceled revision.

1173

Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.