CS_DOC_PURSRVW2 (SQL View)	Index Back
InActive - Purchase Orders Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 prompt for Find existing docs

CS_DOC_PURSRVW2

(SQL View)

InActive - Purchase Orders

Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 prompt for Find existing docs

SELECT A.business_unit , A.po_id FROM PS_CS_DOC_Pur_KEYS A , PS_CS_DOC_HDR B WHERE A.CS_DOC_ID = B.CS_DOC_ID AND B.CLOSE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order