LN_ECEXTP_VW (SQL View)	Index Back
EC External TP Link Assignment Assign internal Customer or Vendor code to a specific TPID.

LN_ECEXTP_VW

(SQL View)

EC External TP Link Assignment

Assign internal Customer or Vendor code to a specific TPID.

SELECT A.SETID, A.ECCUSTVNDRVAL, A.EC_EXT_TP_ID, B.DESCR FROM PS_ECEXTTPLINK A, PS_ECEXTPARTNER B WHERE A.EC_EXT_TP_ID=B.EC_EXT_TP_ID

Parent record: ECEXTPARTNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 LN_DEST_CHAR Character(15) VARCHAR2(15) NOT NULL Loan Dest Character

3 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

4 LN_ECEXTP_DESCR Character(30) VARCHAR2(30) NOT NULL Loan External Trading Partner

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	LN_DEST_CHAR	Character(15)	VARCHAR2(15) NOT NULL	Loan Dest Character
3	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
4	LN_ECEXTP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Loan External Trading Partner