Exporter - Currencies

Field

Description

Min Sage Version

Data Type

Length

NUMBER

Currency number

10

Int32

2

CODE*

Currency code

10

String

3

SYMBOL

Currency symbol

10

String

3

NAME

Currency name

10

String

30

EMU_MEMBER

Is a member of the EMU

10

Boolean

2

BASE_CURRENCY

Is the base currency

10

Boolean

2

RATE

Exchange Rate

10

Double

8

MAJOR_CURRENCY_UNIT

Major currency unit

2008

String

20

MINOR_CURRENCY_UNIT

Minor currency unit

2008

String

20

RECORD_CREATE_DATE

Date and time when the record was created.

2009

Date

8

RECORD_MODIFY_DATE

Date and time when the record was modified.

2009

Date

8

RECORD_DELETED

Flag denoting if the record has been deleted or not.

2009

Boolean

2

 

* Denotes the primary key field used to distinguish unique records.