CURRENCY_CD_TBL

index back

Currency Codes

Currency Codes

  • Related language record: CURRCD_TBL_LANG
  • Parent record of CURRCD_TBL_LANG
  • PeopleSoft Field Name Field Type Column Type Description
    CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    EFFDT Date(10) DATE NOT NULL Effective Date

    Default: %date

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

    Default: A

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default: CURRENCY_CD_TBL.DESCR

    COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    CUR_SYMBOL Character(4) VARCHAR2(4) NOT NULL Currency Symbol
    DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
    SCALE_POSITIONS Number(1,0) SMALLINT NOT NULL Scale Positions
    SYNCID Number(10,0) DECIMAL(10) NOT NULL The 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.
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19