AP_GINV_PO_VCHR

(SQL View)
 Index Back

G-Invoicing PO Voucher ID

G-Invoicing PO Voucher ID Mapping

SELECT DISTINCT B.BUSINESS_UNIT , B.VOUCHER_ID , A.BUSINESS_UNIT , A.PO_ID , A.GNV_GTC_NUM , A.GNV_ORDER_NUM FROM PS_PO_HDR_GNV A , PS_AP_GNV_ADV_DTL B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT_PO AND A.PO_ID=B.PO_ID UNION SELECT DISTINCT B.BUSINESS_UNIT , B.VOUCHER_ID , A.BUSINESS_UNIT , A.PO_ID , A.GNV_GTC_NUM , A.GNV_ORDER_NUM FROM PS_PO_HDR_GNV A , PS_VOUCHER B , PS_VOUCHER_LINE C WHERE B.BUSINESS_UNIT=C.BUSINESS_UNIT AND B.VOUCHER_ID=C.VOUCHER_ID AND A.BUSINESS_UNIT=C.BUSINESS_UNIT_PO AND A.PO_ID=C.PO_ID AND A.GNV_GTC_NUM<>' ' AND A.GNV_ORDER_NUM<>' ' AND NOT EXISTS ( SELECT 'X' FROM PS_AP_GNV_ADV_DTL D WHERE D.BUSINESS_UNIT=B.BUSINESS_UNIT AND D.VOUCHER_ID=B.VOUCHER_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 GNV_GTC_NUM Character(20) VARCHAR2(20) NOT NULL The unique agreement number that must be established between the Requesting Agency and Servicing Agency which will track each General Terms and Conditions (GT&C) agreement from the origination through the completion or termination. G-Invoicing MANINSRI 05/06/2021
6 GNV_ORDER_NUM Character(20) VARCHAR2(20) NOT NULL G-INVOICING MANINSRI 15/06/2021