EOEP_EXPTEST_VW(SQL View) |
Index Back |
|---|---|
Price Var ViewPrice variable expression test view |
| SELECT EOEP_VAR_NAME , DESCR , 'N' , 0.0 FROM PS_EOEP_PRICE_VAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEP_VAR_NAME | Character(15) | VARCHAR2(15) NOT NULL | Pricing Variable Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EOEP_USEDVAR_FLG | Character(1) | VARCHAR2(1) NOT NULL | enterprise pricer used variable flag |
| 4 | EOEP_NUM_VALUE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Numeric Value |