NATURE_TXN2_TBL(SQL Table) |
Index Back |
|---|---|
Nature of Txn Code 2 |
| # | 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 | NATURE_TXN2_DF_OSP | Character(1) | VARCHAR2(1) NOT NULL |
Outright Sale/Purchase
Y/N Table Edit Default Value: N |
| 5 | NATURE_TXN2_DF_RTN | Character(1) | VARCHAR2(1) NOT NULL |
Return of Goods
Y/N Table Edit Default Value: N |
| 6 | NATURE_TXN2_DF_RRT | Character(1) | VARCHAR2(1) NOT NULL |
Replace Returned Goods
Y/N Table Edit Default Value: N |
| 7 | NATURE_TXN2_DF_RNT | Character(1) | VARCHAR2(1) NOT NULL |
Replace Goods not Returned
Y/N Table Edit Default Value: N |
| 8 | NATURE_TXN2_DF_FAI | Character(1) | VARCHAR2(1) NOT NULL |
Financial Adjustments (+)
Y/N Table Edit Default Value: N |
| 9 | NATURE_TXN2_DF_FAD | Character(1) | VARCHAR2(1) NOT NULL |
Financial Adjustments (-)
Y/N Table Edit Default Value: N |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |