ECTRANSVALID_VW

index back

EC Valid Transactions by TP


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 NameField TypeColumn TypeDescription
EC_EXT_TP_IDCharacter(16)VARCHAR2(16) NOT NULLElectronic 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.
ECENTITYCDCharacter(8)VARCHAR2(8) NOT NULLPeopleSoft Entity Code
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
ECCUSTVNDRVALCharacter(15)VARCHAR2(15) NOT NULLPS Customer/Vendor Number
TP_PROFILE_IDCharacter(10)VARCHAR2(10) NOT NULLEC Profile ID
ECMAPPROFILEIDCharacter(10)VARCHAR2(10) NOT NULLEC Map Profile ID
CVT_PROFILE_IDCharacter(10)VARCHAR2(10) NOT NULLEC Convert Profile ID
ECTRANSIDCharacter(15)VARCHAR2(15) NOT NULLElectronic 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)
ECTRANSINOUTSWCharacter(1)VARCHAR2(1) NOT NULLElectronic 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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19