TP_PROFILE_IDPrompt Table: ECPROTRANS
ECTRANSIDPrompt Table: ECPROTRANS
ECTRANSINOUTSWI=Inbound
O=Outbound
ECTRANSMISSIONCDEDI=Transmit By Tradition EDI
FAX=Transmit By Fax
ECXMITDFLTS(SQL Table) |
Index Back |
|---|---|
EC Transmission Type AssignmenAssign Transmission Types (such as EDI, FAX, E-Mail) to a specific TPID Profile and Transaction |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TP_PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
EC Profile ID
Prompt Table: ECPROTRANS |
| 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: ECPROTRANS |
| 3 | 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 |
| 4 | ECTRANSMISSIONCD |
Character(4) | VARCHAR2(4) NOT NULL |
EC Transmission Format
EDI=Transmit By Tradition EDI FAX=Transmit By Fax |