CURRENCY_CD_TBL

index back

Currency Codes

Currency Codes

  • Related language record: CURRCD_TBL_LANG
  • Parent record of CURRCD_TBL_LANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code
    EFFDTDate(10)DATE NOT NULLEffective Date

    Default: %date

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

    Default: A

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLShort Description

    Default: CURRENCY_CD_TBL.DESCR

    COUNTRYCharacter(3)VARCHAR2(3) NOT NULLCountry

    Prompt Table: COUNTRY_TBL

    CUR_SYMBOLCharacter(4)VARCHAR2(4) NOT NULLCurrency Symbol
    DECIMAL_POSITIONSNumber(2,0)SMALLINT NOT NULLDecimal Positions
    SCALE_POSITIONSNumber(1,0)SMALLINT NOT NULLScale Positions
    SYNCIDNumber(10,0)DECIMAL(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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19