PNLGRPNAMEMARKETGVT_NOA_CODEGVT_TS_CON_VW(SQL View) |
Index Back |
|---|---|
Transaction Summary NOAsView to fetch all NOA codes configured under Transaction Summary |
| SELECT PNLGRPNAME , MARKET ,GVT_NOA_CODE FROM PS_GVT_TS_CON_NOA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | GVT_NOA_CODE |
Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |