ECTRANSVALID_VW

Platform	View Text
Default	select distinct ebe.ec_ext_tp_id, eel.ecentitycd, eel.setid, eel.eccustvndrval, eep.tp_profile_id, eep.ecmapprofileid, eep.cvt_profile_id, ept.ectransid, ept.ectransinoutsw from ps_ecexttplink eel, ps_ecextpartner ebe, ps_ecextpartner eep, ps_ecprotrans ept where eel.ec_ext_tp_id = eep.ec_ext_tp_id and eep.tp_profile_id = ept.tp_profile_id and ebe.ec_related_tp_id = eep.ec_ext_tp_id

PeopleSoft Field Name	Description
EC_EXT_TP_ID	Electronic Commerce External Trading Partner ID. Used in EDI Manager. The External Trading Partners are the customers, vendors, etc. that will do business with the PeopleSoft enterprise. External TPID can be found out from the external businesses directly or from the VAN.
ECENTITYCD	PeopleSoft Entity Code
SETID	SetID
ECCUSTVNDRVAL	PS Customer/Vendor Number
TP_PROFILE_ID	EC Profile ID
ECMAPPROFILEID	EC Map Profile ID
CVT_PROFILE_ID	EC Convert Profile ID
ECTRANSID	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
ECTRANSINOUTSW	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010