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