GM_PE_MY_VW

(SQL View)

SELECT 10 , DAYS_ELAPSED , BUSINESS_UNIT , DUE_DT FROM PS_GM_PROPOSAL WHERE PROPOSAL_FLG = 'S' AND CURRENT_VERSION = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MONTH_VALUE Number(2,0) SMALLINT NOT NULL Month

2 YEAR_VALUE Number(4,0) SMALLINT NOT NULL Year

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

4 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MONTH_VALUE	Number(2,0)	SMALLINT NOT NULL	Month
2	YEAR_VALUE	Number(4,0)	SMALLINT NOT NULL	Year
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.