FO_VT_NODE (SQL View)	Index Back
Node to VT Reverse Lkup Node to Supplier-Transaction ID Reverse Lookup

FO_VT_NODE

(SQL View)

Node to VT Reverse Lkup

Node to Supplier-Transaction ID Reverse Lookup

SELECT A.MSGNODENAME , A.FO_VNDR_TRANS_ID , B.FO_OI_VENDOR_STS FROM PS_FO_VNDR_TRANS A , PS_FO_VENDOR B WHERE A.FO_OI_VERSION IN ( SELECT MAX(C.FO_OI_VERSION) FROM PS_FO_VENDOR C WHERE C.FO_OI_VENDOR_ID=A.FO_OI_VENDOR_ID) AND A.FO_OI_VENDOR_ID=B.FO_OI_VENDOR_ID AND A.FO_OI_VERSION=B.FO_OI_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

2 FO_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction

3 FO_OI_VENDOR_STS Character(3) VARCHAR2(3) NOT NULL Integration Vendor Status (Active/Inactive)
10=Active
20=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2	FO_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction
3	FO_OI_VENDOR_STS	Character(3)	VARCHAR2(3) NOT NULL	Integration Vendor Status (Active/Inactive) 10=Active 20=Inactive