EC_EXT_TP_IDECENTITYCDSETIDECCUSTVNDRVALEDI=Transmit By Tradition EDI
FAX=Transmit By Fax
I=Inbound
O=Outbound
ECXMITPREF_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | ECENTITYCD |
Character(8) | VARCHAR2(8) NOT NULL | PeopleSoft Entity Code |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | ECCUSTVNDRVAL |
Character(15) | VARCHAR2(15) NOT NULL | PS Customer/Vendor Number |
| 5 | TP_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | EC Profile ID |
| 6 | ECMAPPROFILEID | Character(10) | VARCHAR2(10) NOT NULL | EC Map Profile ID |
| 7 | 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) |
| 8 | ECTRANSMISSIONCD | Character(4) | VARCHAR2(4) NOT NULL |
EC Transmission Format
EDI=Transmit By Tradition EDI FAX=Transmit By Fax |
| 9 | 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 |