GNV_ADV_HDR_VW

(SQL View)
 Index Back

G-Invoicing Adv Header View

G-Invoicing Adv Header View

SELECT DISTINCT A.SETID , A.GNV_PERFORM_NBR , CASE WHEN A.GNV_PERFRM_REF_NBR<>' ' THEN 'Y' ELSE 'N' END , A.GNV_ORDER_NUM , A.GNV_PERFORM_TYPE , A.GNV_PERFRM_REF_NBR , A.GNV_GTC_NUM , A.GNV_TRANS_ID , A.GNV_REQUEST_ALC , A.GNV_SERVICE_ALC , A.GNV_TRANS_DTTM , A.GNV_ACCOUNT_PERIOD , A.GNV_PREPAREDBY_NAM , A.GNV_PREPARE_PHONE , A.GNV_PREPAREDB_MAIL , A.GNV_BUY_SELL_IND , A.GNV_PO_STATUS , A.BUSINESS_UNIT_PO , A.PO_ID , A.RECEIVER_ID , 'I' , 'N' , B.BUSINESS_UNIT , A.GNV_PERFM_DTTM FROM PS_PO_GNV_PER_HDR A , PS_BUS_UNIT_TBL_PM B WHERE A.GNV_PERFORM_TYPE='548' AND A.GNV_BUY_SELL_IND='S' AND EXISTS ( SELECT 'X' FROM PS_PO_GNV_PER_DTL C WHERE %Join (COMMON_KEYS, PO_GNV_PER_DTL C, PO_GNV_PER_HDR A) AND C.GNV_STATUS IN ('PND', 'STL') ) AND A.BUSINESS_UNIT_PO =B.BUSINESS_UNIT AND NOT EXISTS ( SELECT 'X' FROM PS_AP_GNV_ADV_HDR D WHERE %Join (COMMON_KEYS, AP_GNV_ADV_HDR D, PO_GNV_PER_HDR A) ) UNION ALL SELECT DISTINCT A.SETID , A.GNV_PERFORM_NBR , CASE WHEN A.GNV_PERFRM_REF_NBR<>' ' THEN 'Y' ELSE 'N' END , A.GNV_ORDER_NUM , A.GNV_PERFORM_TYPE , A.GNV_PERFRM_REF_NBR , A.GNV_GTC_NUM , A.GNV_TRANS_ID , A.GNV_REQUEST_ALC , A.GNV_SERVICE_ALC , A.GNV_TRANS_DTTM , A.GNV_ACCOUNT_PERIOD , A.GNV_PREPAREDBY_NAM , A.GNV_PREPARE_PHONE , A.GNV_PREPAREDB_MAIL , A.GNV_BUY_SELL_IND , A.GNV_PO_STATUS , A.BUSINESS_UNIT_PO , A.PO_ID , A.RECEIVER_ID , A.GNV_ADV_DEFAULT , A.GNV_IN_PROCESS , A.BUSINESS_UNIT , A.GNV_PERFM_DTTM FROM PS_AP_GNV_ADV_HDR A WHERE A.GNV_PERFORM_TYPE='548' AND A.GNV_BUY_SELL_IND='S' AND EXISTS ( SELECT 'X' FROM PS_AP_GNV_ADV_DTL B WHERE %Join (COMMON_KEYS, AP_GNV_ADV_DTL B, PO_GNV_PER_HDR A) AND B.GNV_STATUS IN ('PND', 'STL') )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 GNV_PERFORM_NBR Character(20) VARCHAR2(20) NOT NULL A number for a Performance transaction, assigned by G-Invoicing (GINV) at the time the transaction is recorded in GINV. MANINSRI 16/06/2021
3 GNV_ADV_ADJUSTMENT Character(1) VARCHAR2(1) NOT NULL Adjustment
N=No
Y=Yes
4 GNV_ORDER_NUM Character(20) VARCHAR2(20) NOT NULL G-INVOICING MANINSRI 15/06/2021
5 GNV_PERFORM_TYPE Character(3) VARCHAR2(3) NOT NULL Identifies the nature of the performance in the reported transaction. G-INVOICING MANINSRI 16/06/2021
014=Deferred Payment
035=Delivered/Performed
050=Received/Accepted
548=Advance
6 GNV_PERFRM_REF_NBR Character(20) VARCHAR2(20) NOT NULL A number that links a new Performance Transaction to an existing one. G-INVOICING MANINSRI
7 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
8 GNV_TRANS_ID Character(50) VARCHAR2(50) NOT NULL The identifier an agency provides for a transaction. G-INVOICING MANINSRI 16/06/2021
9 GNV_REQUEST_ALC Character(8) VARCHAR2(8) NOT NULL The identifier for the accounting office within an agency that reports disbursements and collections to Treasury for the BUYER. G-Invoicing MANINSRI 05/06/2021
10 GNV_SERVICE_ALC Character(8) VARCHAR2(8) NOT NULL The identifier for the accounting office within an agency that reports disbursements and collections to Treasury for the SELLER. G-Invoicing MANINSRI 05/06/2021
11 GNV_TRANS_DTTM Date(10) DATE The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021
12 GNV_ACCOUNT_PERIOD Number(6,0) INTEGER NOT NULL The fiscal period that the transaction is reflected in the General Ledger, if applicable. G-INVOICING MANINSRI 16/06/2021
13 GNV_PREPAREDBY_NAM Character(60) VARCHAR2(60) NOT NULL The full name of the user submitting the performance transaction. G-INVOICING MANINSRI
14 GNV_PREPARE_PHONE Character(20) VARCHAR2(20) NOT NULL A number assigned to a telephone line for a specific location that is used to call that location. G-Invoicing MANINSRI 06/06/2021
15 GNV_PREPAREDB_MAIL Character(60) VARCHAR2(60) NOT NULL The e-mail address of the user submitting the performance transaction. G-INVOICING MANINSRI 16/06/2021
16 GNV_BUY_SELL_IND Character(1) VARCHAR2(1) NOT NULL Designates whether the Performance transaction or Attachment originated from the Requesting or Servicing agency. G-INVOICING MANINSRI 16/06/2021
R=Buyer
S=Seller
17 GNV_PO_STATUS Character(1) VARCHAR2(1) NOT NULL Indicator that shows the following: � For Advances (�548�) whether an Advance has been created. � For Delivered/Performend (�035�) whether a receipt (ASN) has been created. G-INVOICING MANINSRI 16/06/2021
C=Complete
N=Not Started
P=Processing
18 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
19 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
20 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
21 GNV_ADV_DEFAULT Character(1) VARCHAR2(1) NOT NULL Defaults
C=Complete
I=Incomplete
22 GNV_IN_PROCESS Character(1) VARCHAR2(1) NOT NULL G-Invoicing Advance/Advance Adjustment Processing status.
C=Complete
N=Not Started
P=Processing
23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
24 GNV_PERFM_DTTM Date(10) DATE The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021