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 Name Field Type Column Type Description
EC_EXT_TP_ID Character(16) VARCHAR2(16) NOT NULL 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 Character(8) VARCHAR2(8) NOT NULL PeopleSoft Entity Code
SETID Character(5) VARCHAR2(5) NOT NULL SetID
ECCUSTVNDRVAL Character(15) VARCHAR2(15) NOT NULL PS Customer/Vendor Number
TP_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL EC Profile ID
ECMAPPROFILEID Character(10) VARCHAR2(10) NOT NULL EC Map Profile ID
CVT_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL EC Convert Profile ID
ECTRANSID Character(15) VARCHAR2(15) NOT NULL 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 Character(1) VARCHAR2(1) NOT NULL 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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19