ECXMITPREF_VW

index back

EC Transmission Preferences


select distinct eel.ec_ext_tp_id, eel.ecentitycd, eel.setid, eel.eccustvndrval, eep.tp_profile_id, eep.ecmapprofileid, exd.ectransid, exd.ectransmissioncd, exd.ectransinoutsw from ps_ecexttplink eel, ps_ecextpartner eep, ps_ecxmitdflts exd where eel.ec_ext_tp_id = eep.ec_ext_tp_id and eep.tp_profile_id =exd.tp_profile_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
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)
ECTRANSMISSIONCD Character(4) VARCHAR2(4) NOT NULL EC Transmission Format
EDI=Transmit By Tradition EDI
FAX=Transmit By Fax
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