EC_EXT_TP_IDPrompt Table: ECTPPROFILE
Prompt Table: ECMAPPROFILE
Prompt Table: ECCVTPROFILE
Prompt Table: ECEXTRELATED_VW
ECEXTPARTNER(SQL Table) |
Index Back |
|---|---|
EC External Trading Partner |
| # | 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 | TP_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
EC Profile ID
Prompt Table: ECTPPROFILE |
| 3 | ECMAPPROFILEID | Character(10) | VARCHAR2(10) NOT NULL |
EC Map Profile ID
Prompt Table: ECMAPPROFILE |
| 4 | CVT_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
EC Convert Profile ID
Prompt Table: ECCVTPROFILE |
| 5 | EC_RELATED_TP_ID | Character(16) | VARCHAR2(16) NOT NULL |
Parent Trading Partner ID
Prompt Table: ECEXTRELATED_VW |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ECMESSAGE | Long Character(400) | VARCHAR2(400) | Message Header/Trailer |
| 8 | ECMESSAGE_SW | Character(1) | VARCHAR2(1) NOT NULL | Message Switch |