CURRENCY_CD_TBL (SQL Table)	Index Back
Currency Codes Currency Codes

CURRENCY_CD_TBL

(SQL Table)

Currency Codes

Related Language Record: CURRCD_TBL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: CURRENCY_CD_TBL.DESCR

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

7 CUR_SYMBOL Character(4) VARCHAR2(4) NOT NULL Currency Symbol

8 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

9 SCALE_POSITIONS Number(1,0) SMALLINT NOT NULL Scale Positions

10 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.

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: CURRENCY_CD_TBL.DESCR
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
7	CUR_SYMBOL	Character(4)	VARCHAR2(4) NOT NULL	Currency Symbol
8	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
9	SCALE_POSITIONS	Number(1,0)	SMALLINT NOT NULL	Scale Positions
10	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.
11	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.