EOEP_APP_CDPrompt Table: EOEP_APP_CODE
EOEP_ROUND_IDEOEP_RANGE_ID1=Decimal Point
2=By Currency
Default Value: 2
EOEP_ROUND_RULE(SQL Table) |
Index Back |
|---|---|
Pricing Round RulePricing Round Rule definition by transaction |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEP_APP_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APP_CODE |
| 2 | EOEP_ROUND_ID |
Character(15) | VARCHAR2(15) NOT NULL | Rounding ID |
| 3 | EOEP_RANGE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Range ID |
| 4 | EOEP_MIN_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 5 | EOEP_MAX_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 6 | EOEP_ROUNDPOS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Position
1=Decimal Point 2=By Currency Default Value: 2 |
| 7 | DECIMAL_POS | Number(2,0) | SMALLINT NOT NULL | Decimal Position |