CURR_QUOTE_TBL

index back

Currency Quotation table

Currency Quotation table

PeopleSoft Field NameField TypeColumn TypeDescription
FROM_CURCharacter(3)VARCHAR2(3) NOT NULLFrom Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CURCharacter(3)VARCHAR2(3) NOT NULLTo Currency Code

Prompt Table: CURRENCY_CD_TBL

EFFDTDate(10)DATEEffective Date

Default: %date

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: A

RATE_DECIMALSNumber(1,0)SMALLINT NOT NULLRate Decimal Positions

Default: 4

QUOTE_UNITSNumber(4,0)SMALLINT NOT NULLQuote Units

Default: 1

RATE_DIRECTCharacter(1)VARCHAR2(1) NOT NULLRate Quotation Basis
D=Direct
I=Indirect

Default: D

AUTO_RECIPROCATECharacter(1)VARCHAR2(1) NOT NULLAuto Reciprocate

Y/N Table Edit

Default: Y

RATE_TRIANGULATECharacter(1)VARCHAR2(1) NOT NULLRate Triangulate

Y/N Table Edit

Default: N

REF_CURCharacter(3)VARCHAR2(3) NOT NULLReference Currency

Prompt Table: CURRENCY_CD_TBL

PRIMARY_VISUALCharacter(2)VARCHAR2(2) NOT NULLPrimary Visual Rate
FR=From Currency --> Ref Currency
FT=From Currency --> To Currency
RT=Ref Currency --> To Currency

Default: FT

XRATE_OVERRIDECharacter(1)VARCHAR2(1) NOT NULLAllow Cross-Rate Override

Y/N Table Edit

Default: N

XRATE_RECALCCharacter(2)VARCHAR2(2) NOT NULLCross-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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19