COL_HEADINGFLD_NAMEDYN_CHAR_SW1PRCR_FLDCAN_CVW(SQL View) |
Index Back |
|---|---|
Procurement Char Field View |
| select col_heading, fld_name, col_heading, col_heading, col_heading, col_heading from PS_PRCR_FLDCAN_TBL where fld_type = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COL_HEADING |
Character(20) | VARCHAR2(20) NOT NULL | Field Heading |
| 2 | FLD_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 3 | DYN_CHAR_SW1 |
Character(20) | VARCHAR2(20) NOT NULL | Dynamic Character Switch 1 |
| 4 | DYN_CHAR_SW2 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Character Switch 2 |
| 5 | DYN_CHAR_SW3 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Character Switch 3 |
| 6 | DYN_CHAR_SW4 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Character Switch 4 |