RECV_PUSHED_GNV (SQL Table)	Index Back
Pushed Performance Data Date Initials Reference# Description 02/28/2021 Nash G-Invoicing Created a new table that holds Pushed Performance Data after a successful PUSH.

RECV_PUSHED_GNV

(SQL Table)

Pushed Performance Data

Date Initials Reference# Description 02/28/2021 Nash G-Invoicing Created a new table that holds Pushed Performance Data after a successful PUSH.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number

3 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

4 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

5 GNV_ORDER_NUM Character(20) VARCHAR2(20) NOT NULL G-INVOICING MANINSRI 15/06/2021

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_QTY_TTL Signed Number(16,2) DECIMAL(14,2) NOT NULL The number of units pertaining to the type of performance being reported. G_INVOICING MANINSRI 17/06/2021

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
3	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
4	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
5	GNV_ORDER_NUM	Character(20)	VARCHAR2(20) NOT NULL	G-INVOICING MANINSRI 15/06/2021
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_QTY_TTL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	The number of units pertaining to the type of performance being reported. G_INVOICING MANINSRI 17/06/2021