RBF_ASSOC_RO_VW (SQL View)	Index Back
Associated RO view Associated RO view for Financial Account

RBF_ASSOC_RO_VW

(SQL View)

Associated RO view

Associated RO view for Financial Account

SELECT A.FIN_ACCOUNT_ID , A.CAPTURE_ID , B.CAPTURE_TYPE_CD , B.CAPTURE_DATE ,B.DESCR50 FROM PS_RBF_ASSOC_RO A , PS_RO_HEADER_VW B WHERE A.CAPTURE_ID = B.CAPTURE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

2 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

3 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

4 CAPTURE_DATE Date(10) DATE Order capture date used for orders and quotes

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
2	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
3	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order
4	CAPTURE_DATE	Date(10)	DATE	Order capture date used for orders and quotes
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50