HRS_TRNSF_MRCH

(SQL View)
 Index Back

SI Transformation Definition

Supplier Integration - Transformation Definition

SELECT A.SI_SUPPLIER_ID , A.SI_SOURCE_SCHEMA , A.SI_TARGET_SCHEMA FROM PS_SI_TRANSF_SETUP A WHERE A.SI_TRANSACTION = 'JOB_POSITION_POSTING' AND A.EFFDT = ( SELECT MAX(STS.EFFDT) FROM PS_SI_TRANSF_SETUP STS WHERE A.SI_SUPPLIER_ID = STS.SI_SUPPLIER_ID AND A.SI_TRANSACTION = STS.SI_TRANSACTION AND STS.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
2 SI_SOURCE_SCHEMA Character(30) VARCHAR2(30) NOT NULL Supplier Integration - Source Schema

Prompt Table: %EDITTABLE

3 SI_TARGET_SCHEMA Character(30) VARCHAR2(30) NOT NULL Supplier Integration - Target Schema

Prompt Table: %EDITTABLE2