RO_LINE_COUNT

(SQL View)
Index Back

Line Count

Line Count

SELECT CAPTURE_ID ,COUNT(*) FROM PS_RO_LINE GROUP BY CAPTURE_ID

# 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_COUNT Number(5,0) INTEGER NOT NULL Line Count