ECBUSENTITY_VW - EC Business Entity View - PeopleTools Table Reference

ECBUSENTITY_VW	index back
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 Field Type Column Type Description

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.

DESCR Character(30) VARCHAR2(30) NOT NULL Description

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
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.
DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description