SRM_PO_LATE_VW (SQL View)	Index Back
PO Overdue Schedules

SRM_PO_LATE_VW

(SQL View)

PO Overdue Schedules

SELECT DISTINCT BUYER_ID , VENDOR_SETID , VENDOR_ID , BUSINESS_UNIT_PO , PO_ID , DUE_DT FROM PS_RECV_PO_SHIP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

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

6 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	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
6	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.