Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
description	CHAR	varchar		255			Description of the product
dev	LONG	int	151			DIRECT	Row version number for mobile distribution purposes
dom_is_service	LONG	int				DIRECT	Indicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service, default=0
domain	CHAR	varchar		40			Name of the domain for the part num. See object prt_domain
level_to_part	LONG	int				DIRECT	Relative installation hierarchy level to a part
mod_level	CHAR	varchar		10			Name of the part revision
mod_objid	LONG	int				DIRECT	Internal record number
model_num	CHAR	varchar		20			Marketing model number of the part; within family and line
objid	LONG	int	3			DIRECT	Internal record number
part_number	CHAR	varchar		30			Part number/name
partnum_objid	LONG	int				DIRECT	Internal record number
serial_no	CHAR	varchar		30			Installed part serial number
site_id	CHAR	varchar		80			Unique site number assigned according to auto-numbering definition
site_name	CHAR	varchar		80			Name of the site
site_objid	LONG	int				DIRECT	Site internal record number
warranty_date	CLK_TIME	datetime					The warranty date of site part

SQL:

(
select table_site_part.objid as objid,
table_site.objid as site_objid,
table_part_num.part_number as part_number,
table_mod_level.mod_level as mod_level,
table_part_num.domain as domain,
table_site_part.serial_no as serial_no,
table_site.name as site_name,
table_site.site_id as site_id,
table_site_part.level_to_part as level_to_part,
table_mod_level.objid as mod_objid,
table_part_num.model_num as model_num,
table_part_num.description as description,
table_part_num.dom_is_service as dom_is_service,
table_part_num.objid as partnum_objid,
table_site_part.dev as dev,
table_site_part.warranty_date as warranty_date
from table_site_part, table_site, table_part_num, table_mod_level, table_sit_prt_role
where table_mod_level.objid = table_site_part.site_part2part_info
AND table_part_num.objid = table_mod_level.part_info2part_num
AND table_site_part.objid = table_sit_prt_role.prt_role2site_part
AND table_site.objid = table_sit_prt_role.prt_role2site
UNION
select table_site_part.objid as objid,
table_site.objid as site_objid,
table_part_num.part_number as part_number,
table_mod_level.mod_level as mod_level,
table_part_num.domain as domain,
table_site_part.serial_no as serial_no,
table_site.name as site_name,
table_site.site_id as site_id,
table_site_part.level_to_part as level_to_part,
table_mod_level.objid as mod_objid,
table_part_num.model_num as model_num,
table_part_num.description as description,
table_part_num.dom_is_service as dom_is_service,
table_part_num.objid as partnum_objid,
table_site_part.dev as dev,
table_site_part.warranty_date as warranty_date
from table_site_part, table_site, table_part_num, table_mod_level, table_address
where table_mod_level.objid = table_site_part.site_part2part_info
AND table_site.objid = table_site_part.all_site_part2site
AND table_address.objid = table_site.cust_primaddr2address
AND table_part_num.objid = table_mod_level.part_info2part_num
)