EC_EXT_TP_IDECENTITYCDSETIDECCUSTVNDRVALI=Inbound
O=Outbound
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |