NATURE_OF_TXN1NATURE_TXN2_USEEU=European Union
GB=United Kingdom
Prompt Table: NATURE_TXN2_USE
NATURE_OF_TXN2NATURE_TXN2_VW(SQL View) |
Index Back |
|---|---|
Nature of Transaction 2 View |
| SELECT DISTINCT NATURE_OF_TXN1 ,NATURE_TXN2_USE ,NATURE_OF_TXN2 ,DESCR FROM PS_NATURE_TXN2_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NATURE_OF_TXN1 |
Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 1 |
| 2 | NATURE_TXN2_USE |
Character(2) | VARCHAR2(2) NOT NULL |
Nature of transaction secon ddigit use
EU=European Union GB=United Kingdom Prompt Table: NATURE_TXN2_USE |
| 3 | NATURE_OF_TXN2 |
Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 2 |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |