MOC_GRP_PROD_VW (SQL View)	Index Back
Used by Mobile Order Capture This view joins the Product Item table with Product Group table and is used for Data Distribution on Mobile device.

MOC_GRP_PROD_VW

(SQL View)

Used by Mobile Order Capture

This view joins the Product Item table with Product Group table and is used for Data Distribution on Mobile device.

SELECT A.SETID , A.PRODUCT_ID , A.SYNCID , A.SYNCDTTM , B.PRODUCT_GROUP FROM PS_PROD_ITEM A , PS_PROD_PGRP_LNK B WHERE A.PRODUCT_ID = B.PRODUCT_ID AND A.SETID=B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

3 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

4 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

5 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
4	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
5	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group