CURRENCY_CD_TBL

Return to Index

Currency Codes

  • Related language record: CURRCD_TBL_LANG
  • Parent record of CURRCD_TBL_LANG
  • PeopleSoft Field NameField TypeDescription
    CURRENCY_CDVARCHAR2(3) NOT NULLCurrency Code
    EFFDTDATE NOT NULLEffective Date

    Default: %date

    EFF_STATUSVARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive

    Default: A

    DESCRVARCHAR2(30) NOT NULLDescription
    DESCRSHORTVARCHAR2(10) NOT NULLShort Description

    Default: CURRENCY_CD_TBL.DESCR

    COUNTRYVARCHAR2(3) NOT NULLCountry

    Prompt Table: COUNTRY_TBL

    CUR_SYMBOLVARCHAR2(4) NOT NULLCurrency Symbol
    DECIMAL_POSITIONSSMALLINT NOT NULLDecimal Positions
    SCALE_POSITIONSSMALLINT NOT NULLScale Positions
    SYNCIDDECIMAL(10) NOT NULLThe Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    LASTUPDDTTMDATESpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Author: PeopleTools 8.52

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 04 January 2014