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 | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APP_CODE |
|
2 | Character(15) | VARCHAR2(15) NOT NULL | Rounding ID | |
3 | 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 |