RO_LINE_REP_VW (SQL View)	Index Back
Line View This record is a view used for Line repersentation

RO_LINE_REP_VW

(SQL View)

Line View

This record is a view used for Line repersentation

SELECT LIN.CAPTURE_ID , LIN.LINE_NBR , SHR.BO_ID , SHR.PROFILE_CM_SEQ FROM PS_RO_LINE LIN , PS_RO_DEST DSS , PS_RO_BOID SHR WHERE LIN.CAPTURE_ID=DSS.CAPTURE_ID AND LIN.UID20F=DSS.UID20 AND DSS.CAPTURE_ID=SHR.CAPTURE_ID AND DSS.UID20F_SHIPC=SHR.UID20

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.

3 BO_ID_SHIPR Number(31,0) DECIMAL(31) NOT NULL Business Object ID

4 PROFILE_CM_SQ_SHPR Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
3	BO_ID_SHIPR	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
4	PROFILE_CM_SQ_SHPR	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence