ECBUSENTITY_VW (SQL View)	Index Back
EC Business Entity View

ECBUSENTITY_VW

(SQL View)

EC Business Entity View

select ec_ext_tp_id, descr from PS_ECEXTPARTNER where ec_related_tp_id <> ec_ext_tp_id

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description