CURR_QUOTE_TBL

index back

Currency Quotation table

Currency Quotation table

PeopleSoft Field Name Field Type Column Type Description
FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

Prompt Table: CURRENCY_CD_TBL

EFFDT Date(10) DATE Effective Date

Default: %date

EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: A

RATE_DECIMALS Number(1,0) SMALLINT NOT NULL Rate Decimal Positions

Default: 4

QUOTE_UNITS Number(4,0) SMALLINT NOT NULL Quote Units

Default: 1

RATE_DIRECT Character(1) VARCHAR2(1) NOT NULL Rate Quotation Basis
D=Direct
I=Indirect

Default: D

AUTO_RECIPROCATE Character(1) VARCHAR2(1) NOT NULL Auto Reciprocate

Y/N Table Edit

Default: Y

RATE_TRIANGULATE Character(1) VARCHAR2(1) NOT NULL Rate Triangulate

Y/N Table Edit

Default: N

REF_CUR Character(3) VARCHAR2(3) NOT NULL Reference Currency

Prompt Table: CURRENCY_CD_TBL

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: FT

XRATE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow Cross-Rate Override

Y/N Table Edit

Default: N

XRATE_RECALC Character(2) VARCHAR2(2) NOT NULL Cross-Rate Recalculate Option
FR=From Currency --> Ref Currency
RT=Ref Currency --> To Currency

Default: FR

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19