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

RF_CONT_NUM_VW

(SQL View)

Material Search Deep View

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

SELECT A.SYNCID , %Substring(B.EXTERNAL_KEY_2,1,25) FROM PS_RF_AGREEMENT A , PS_RF_INT_AGRMNT B WHERE A.SETID = B.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND B.INTGN_SOURCE = '001'

# 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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL This field is used to represent the contract number
Prompt Table: RF_CONT_PMT_VW

#	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	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	This field is used to represent the contract number Prompt Table: RF_CONT_PMT_VW