RO_LINE_COUNT(SQL View) |
Index Back |
---|---|
Line CountLine 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 |