FUS_COA_STR_VW(SQL View) |
Index Back |
|---|
| SELECT STRUCTURE_CODE ,SEGMENT_CODE ,SEGMENT ,SEQUENCE_NUMBER ,MAX(VALUE_SET_CODE) ,MAX(MAXIMUM_LENGTH) FROM PS_FUS_COA_SEGINST GROUP BY STRUCTURE_CODE ,SEGMENT_CODE ,SEQUENCE_NUMBER ,SEGMENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STRUCTURE_CODE | Character(30) | VARCHAR2(30) NOT NULL | Used in Fusion Key Flexfields |
| 2 | SEGMENT_CODE | Character(30) | VARCHAR2(30) NOT NULL | SEGMENT_CODE |
| 3 | SEGMENT | Character(10) | VARCHAR2(10) NOT NULL | Fusion COA Segment |
| 4 | SEQUENCE_NUMBER | Number(3,0) | SMALLINT NOT NULL | SEQUENCE_NUMBER |
| 5 | VALUE_SET_CODE | Character(60) | VARCHAR2(60) NOT NULL | Fusion Value Set Code |
| 6 | MAXIMUM_LENGTH | Number(3,0) | SMALLINT NOT NULL | Maximum Length |