COL_HEADINGFLD_NAMEPRCR_FLDCAN_NVW(SQL View) |
Index Back |
|---|---|
Procurement Numeric Field View |
| select col_heading, fld_name, col_heading, col_heading, col_heading, col_heading from PS_PRCR_FLDCAN_TBL where fld_type = 'N' |
| # | 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_NUM_SW1 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Numeric Switch 1 |
| 4 | DYN_NUM_SW2 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Numeric Switch 2 |
| 5 | DYN_NUM_SW3 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Numeric Switch 3 |
| 6 | DYN_NUM_SW4 | Character(20) | VARCHAR2(20) NOT NULL | Dynamic Numeric Switch 4 |