| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 2 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
RATE_DECIMALS |
Number(1,0) |
SMALLINT NOT NULL |
Rate Decimal Positions
Default Value: 4
|
| 6 |
QUOTE_UNITS |
Number(4,0) |
SMALLINT NOT NULL |
Quote Units
Default Value: 1
|
| 7 |
RATE_DIRECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Quotation Basis
D=Direct
I=Indirect
Default Value: D
|
| 8 |
AUTO_RECIPROCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Reciprocate
Y/N Table Edit
Default Value: Y
|
| 9 |
RATE_TRIANGULATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Triangulate
Y/N Table Edit
Default Value: N
|
| 10 |
REF_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Reference Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
PRIMARY_VISUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
Primary Visual Rate
FR=From Currency --> Ref Currency
FT=From Currency --> To Currency
RT=Ref Currency --> To Currency
Default Value: FT
|
| 12 |
XRATE_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Cross-Rate Override
Y/N Table Edit
Default Value: N
|
| 13 |
XRATE_RECALC |
Character(2) |
VARCHAR2(2) NOT NULL |
Cross-Rate Recalculate Option
FR=From Currency --> Ref Currency
RT=Ref Currency --> To Currency
Default Value: FR
|