RF_PO_IUT_VW (SQL View)	Index Back
Material Search Deep View View for Deep Search of Material based on Purchase Order and InterUnit Details

RF_PO_IUT_VW

(SQL View)

Material Search Deep View

View for Deep Search of Material based on Purchase Order and InterUnit Details

SELECT A.SYNCID , B.PO_ID , B.INTERUNIT_ID FROM PS_RF_MATERIAL_DTL A , PS_RF_MATRECSER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.MATERIAL_HDR = B.MATERIAL_HDR AND A.MATERIAL_LINE = B.MATERIAL_LINE AND A.INV_ITEM_ID = B.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL This field is used to store the interunit id associated with material that was ordered.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the interunit id associated with material that was ordered.