ECMAPIDPrompt Table: ECTRANS
ECMAPDEFN_OU_VW(SQL View) |
Index Back |
|---|---|
EC Outbound Map Defintion View |
| SELECT ECMAPID, ECTRANSID FROM PS_ECMAPDEFN WHERE ECTRANSINOUTSW = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECMAPID |
Character(10) | VARCHAR2(10) NOT NULL | EC Map ID |
| 2 | 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)
Prompt Table: ECTRANS |