FO_JOBBRD_VT_VW

(SQL View)
 Index Back

SELECT A.FO_OI_VENDOR_ID , C.FO_VNDR_TRANS_ID FROM PS_FO_VENDOR A , PS_FO_VNDR_TRANS C WHERE A.FO_OI_VERSION = ( SELECT MAX (B.FO_OI_VERSION) FROM PS_FO_VENDOR B WHERE B.FO_OI_VENDOR_ID=A.FO_OI_VENDOR_ID) AND A.FO_OI_VENDOR_STS='10' AND A.FO_OI_VENDOR_ID=C.FO_OI_VENDOR_ID AND A.FO_OI_VERSION=C.FO_OI_VERSION AND C.FO_TRANSACT_ID='HC_UUID_41528361607072004'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_EXTRACTOR_ID Number(15,0) DECIMAL(15) NOT NULL Used to store the extractor in Source.
2 FO_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction