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 | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |