EC_EXT_TP_IDPrompt Table: ECEXTPARTNER
ECENTITYCDPrompt Table: ECENTITYCDS
SETIDPrompt Table: SETID_TBL
Prompt Table: %EDITTABLE
ECEXTTPLINK(SQL Table) |
Index Back |
|---|---|
EC External TP Link AssignmentAssign internal Customer or Vendor code to a specific TPID. |
| # | 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.
Prompt Table: ECEXTPARTNER |
| 2 | ECENTITYCD |
Character(8) | VARCHAR2(8) NOT NULL |
PeopleSoft Entity Code
Prompt Table: ECENTITYCDS |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | ECCUSTVNDRVAL | Character(15) | VARCHAR2(15) NOT NULL |
PS Customer/Vendor Number
Prompt Table: %EDITTABLE |