SI_TF_TEST_SRCH (SQL View)	Index Back
SI JPP Transf. Test Search Rec Supplier Integration - Search record of the SI JPP Transformation Test page. The search record allows only to select SI Transformation Setups with a source type 'Message' and source schema 'SI_JPP_JOB_REQ_DATA'.

SI_TF_TEST_SRCH

(SQL View)

SI JPP Transf. Test Search Rec

Supplier Integration - Search record of the SI JPP Transformation Test page. The search record allows only to select SI Transformation Setups with a source type 'Message' and source schema 'SI_JPP_JOB_REQ_DATA'.

SELECT SI_TRANSACTION , SI_SUPPLIER_ID , EFFDT , EFF_STATUS , SI_SOURCE_TYPE , SI_SOURCE_SCHEMA FROM PS_SI_TRANSF_SETUP WHERE SI_SOURCE_TYPE = 'M' AND SI_SOURCE_SCHEMA = 'ER_JPP_JOB_REQ_DATA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SI_TRANSACTION Character(30) VARCHAR2(30) NOT NULL Supplier Integration - Transaction ID

2 SI_SUPPLIER_ID Character(15) VARCHAR2(15) NOT NULL Supplier Integration - Supplier ID

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 SI_SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Supplier Integration - Source Schema Type
M=PeopleSoft Message
X=XML Document

6 SI_SOURCE_SCHEMA Character(30) VARCHAR2(30) NOT NULL Supplier Integration - Source Schema

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SI_TRANSACTION	Character(30)	VARCHAR2(30) NOT NULL	Supplier Integration - Transaction ID
2	SI_SUPPLIER_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Integration - Supplier ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	SI_SOURCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Supplier Integration - Source Schema Type M=PeopleSoft Message X=XML Document
6	SI_SOURCE_SCHEMA	Character(30)	VARCHAR2(30) NOT NULL	Supplier Integration - Source Schema