ECTPALIAS_VW (SQL View)	Index Back
EC TP ID Alias View Defines what an external trading call a business unit

ECTPALIAS_VW

(SQL View)

EC TP ID Alias View

Defines what an external trading call a business unit

select ec_ext_tp_id, ec_int_tp_id, ec_alias_tp_id from PS_ECTPALIAS

# 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 EC_INT_TP_ID Character(16) VARCHAR2(16) NOT NULL EC Internal Trading Partner ID
Prompt Table: ECINTPARTNER

3 EC_ALIAS_TP_ID Character(16) VARCHAR2(16) NOT NULL Electronic Commerce Alias Trading Partner ID. An Alias can be used for the Internal Business Entities. Used in EDI Manager.

#	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	EC_INT_TP_ID	Character(16)	VARCHAR2(16) NOT NULL	EC Internal Trading Partner ID Prompt Table: ECINTPARTNER
3	EC_ALIAS_TP_ID	Character(16)	VARCHAR2(16) NOT NULL	Electronic Commerce Alias Trading Partner ID. An Alias can be used for the Internal Business Entities. Used in EDI Manager.