RND_RULES_INV(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CE_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | source |
| 2 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 3 | ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down N=Natural Round U=Round Up |
| 4 | RND_WHOLE | Number(3,0) | SMALLINT NOT NULL | Round Whole |
| 5 | RND_DEC | Number(3,0) | SMALLINT NOT NULL | Round Decimal |
| 6 | RND_UP | Number(3,0) | SMALLINT NOT NULL | Round Up |
| 7 | RND_NAT | Number(3,0) | SMALLINT NOT NULL | Nat round |
| 8 | RND_DN | Number(3,0) | SMALLINT NOT NULL | Round Down |