AP_GINV_EZ_VW (SQL View)	Index Back
EZ Invoice View EZ Invoice View

AP_GINV_EZ_VW

(SQL View)

EZ Invoice View

SELECT SETID ,GNV_EZ_NUM ,GNV_REF_EZ_NUM ,GNV_GTC_NUM ,GNV_BUY_SELL_IND ,GNV_EZ_TRANS_TYPE ,GNV_REQUEST_ALC ,GNV_SERVICE_ALC ,GNV_STATUS ,BUSINESS_UNIT_AP ,VOUCHER_ID ,BUSINESS_UNIT_PO ,PO_ID ,GNV_ITEM_CODE ,GNV_ITEM_DESCR ,GNV_ACCOUNT_PERIOD ,GNV_DOS ,GNV_DRN ,GNV_PERFM_DTTM ,GNV_PERFORM_AMT ,GINV_EZVCHR_STATUS ,GNV_TRANS_DTTM ,GNV_EZ_XFER_AMT ,GNV_XFER_DT FROM PS_AP_GINV_EZ_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 GNV_EZ_NUM Character(20) VARCHAR2(20) NOT NULL EZ Invoice EZ Number

3 GNV_REF_EZ_NUM Character(20) VARCHAR2(20) NOT NULL EZ Invoice Reference EZ number

4 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

5 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

6 GNV_EZ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL EZ Invoice Transaction Type
011=Invoice
201=Accepted
324=Reversed
598=Rejected

7 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

8 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

9 GNV_STATUS Character(3) VARCHAR2(3) NOT NULL Status Code The current status of the requested document. G-INVOICING MANINSRI 15/06/2021
CLZ=Closed
REC=Open
STL=Settled

10 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

11 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

12 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

13 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

14 GNV_ITEM_CODE Character(4) VARCHAR2(4) NOT NULL EZ Invoice Item Code

15 GNV_ITEM_DESCR Character(240) VARCHAR2(240) NOT NULL EZ Invoice Item Description

16 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

17 GNV_DOS Character(5) VARCHAR2(5) NOT NULL An identifier assigned to the agency which is disbursing funds from the Treasury General Account (TGA). G_INVOICING MANINSRI

18 GNV_DRN Character(8) VARCHAR2(8) NOT NULL Details a unique identifying number created by a system for a document, e.g. payment or collection document. G_INVOICING MANINSRI 17/06/2021

19 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

20 GNV_PERFORM_AMT Signed Number(33,2) DECIMAL(31,2) NOT NULL EZ Invoice Performance Amount

21 GINV_EZVCHR_STATUS Character(1) VARCHAR2(1) NOT NULL EZ Invoice Voucher Status
C=Complete
H=Hold
N=Not Started
P=Processing

22 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

23 GNV_EZ_XFER_AMT Signed Number(33,2) DECIMAL(31,2) NOT NULL EZ Invoice Transfer Amount

24 GNV_XFER_DT Character(10) VARCHAR2(10) NOT NULL The date that funds are transferred into or out of the TGA. (Equivalent to IPAC's Accomplished Date). G_INVOICING MANINSRI 17/06/2021

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	GNV_EZ_NUM	Character(20)	VARCHAR2(20) NOT NULL	EZ Invoice EZ Number
3	GNV_REF_EZ_NUM	Character(20)	VARCHAR2(20) NOT NULL	EZ Invoice Reference EZ number
4	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
5	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
6	GNV_EZ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	EZ Invoice Transaction Type 011=Invoice 201=Accepted 324=Reversed 598=Rejected
7	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
8	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
9	GNV_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status Code The current status of the requested document. G-INVOICING MANINSRI 15/06/2021 CLZ=Closed REC=Open STL=Settled
10	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
11	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
12	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
13	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
14	GNV_ITEM_CODE	Character(4)	VARCHAR2(4) NOT NULL	EZ Invoice Item Code
15	GNV_ITEM_DESCR	Character(240)	VARCHAR2(240) NOT NULL	EZ Invoice Item Description
16	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
17	GNV_DOS	Character(5)	VARCHAR2(5) NOT NULL	An identifier assigned to the agency which is disbursing funds from the Treasury General Account (TGA). G_INVOICING MANINSRI
18	GNV_DRN	Character(8)	VARCHAR2(8) NOT NULL	Details a unique identifying number created by a system for a document, e.g. payment or collection document. G_INVOICING MANINSRI 17/06/2021
19	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
20	GNV_PERFORM_AMT	Signed Number(33,2)	DECIMAL(31,2) NOT NULL	EZ Invoice Performance Amount
21	GINV_EZVCHR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EZ Invoice Voucher Status C=Complete H=Hold N=Not Started P=Processing
22	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
23	GNV_EZ_XFER_AMT	Signed Number(33,2)	DECIMAL(31,2) NOT NULL	EZ Invoice Transfer Amount
24	GNV_XFER_DT	Character(10)	VARCHAR2(10) NOT NULL	The date that funds are transferred into or out of the TGA. (Equivalent to IPAC's Accomplished Date). G_INVOICING MANINSRI 17/06/2021