AP_GNV_SYSID_VW (SQL View)	Index Back
G-Invoicing System IDs G-Invoicing System IDs

AP_GNV_SYSID_VW

(SQL View)

G-Invoicing System IDs

SELECT GNV_SYSTEM_ID , PULL_PFM_LASTUPDDT , PULL_PFM_LASTUPDTM FROM PS_PO_GNV_DEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GNV_SYSTEM_ID Character(100) VARCHAR2(100) NOT NULL Identifies the system that the interfacing Partner ID represents for the request. The System ID is used to limit data access and permissions in G-Invoicing. G-INVOICING MANINSRI12/06/2021

2 LASTUPDDT_SINCE Date(10) DATE Last Update Date Since

3 LASTUPDTM_SINCE Time(15) TIMESTAMP Last Updated Time Since

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GNV_SYSTEM_ID	Character(100)	VARCHAR2(100) NOT NULL	Identifies the system that the interfacing Partner ID represents for the request. The System ID is used to limit data access and permissions in G-Invoicing. G-INVOICING MANINSRI12/06/2021
2	LASTUPDDT_SINCE	Date(10)	DATE	Last Update Date Since
3	LASTUPDTM_SINCE	Time(15)	TIMESTAMP	Last Updated Time Since