Table of Contents

Table Gen_Currency_Directories

Entity

Entity: General.CurrencyDirectories

Contains a named set of currency exchange rates against a single currency for a given date. Multiple directories with different names can exist for single date. For example, buy and sell rates are recorded as separate directories. Entity: Gen_Currency_Directories

Owner Tables Hierarchy

Summary

Name Type Description
Currency_Directory_Id uniqueidentifier PK
Currency_Directory_Name nvarchar(64) The name of the currency directory, used to distinguish it from the other directories on the same date
Document_Id uniqueidentifier
Is_Default bit
Is_Released bit Readonly True if the document is not void and its state is released or greater. Deprecated
Is_Single_Execution bit Readonly Specifies whether the document is a single execution of its order document.
Is_Valid bit Shows if the current currency directory is valid to be used in documents
Row_Version timestamp
To_Currency_Id uniqueidentifier The destination currency for the conversions for this directory

Columns

Currency_Directory_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Currency_Directory_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Currency_Directory_Name

The name of the currency directory, used to distinguish it from the other directories on the same date

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Currency_Directory_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Document_Id

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Documents
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Document_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Is_Default

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Default - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Is_Released

True if the document is not void and its state is released or greater. Deprecated

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Released - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Is_Single_Execution

Specifies whether the document is a single execution of its order document.

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Single_Execution - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Is_Valid

Shows if the current currency directory is valid to be used in documents

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Is_Valid - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

To_Currency_Id

The destination currency for the conversions for this directory

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Currencies
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

To_Currency_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes
Suggest improvement to this page