Latest revision |
Your text |
Line 1: |
Line 1: |
| == wikibot == | | == wikibot == |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- valign="top"
| |
− | | '''Table
| |
− | | Sales.CurrencyRate
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Currency exchange rates.
| |
− | |}
| |
− |
| |
− | === Columns ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description
| |
− |
| |
− | |- valign="top"
| |
− | | CurrencyRateID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Primary key for CurrencyRate records.
| |
− | |- valign="top"
| |
− | | CurrencyRateDate
| |
− | | datetime
| |
− | | not null
| |
− | |
| |
− | | Date and time the exchange rate was obtained.
| |
− | |- valign="top"
| |
− | | FromCurrencyCode
| |
− | | nchar(3)
| |
− | | not null
| |
− | |
| |
− | | Exchange rate was converted from this currency code.
| |
− | |- valign="top"
| |
− | | ToCurrencyCode
| |
− | | nchar(3)
| |
− | | not null
| |
− | |
| |
− | | Exchange rate was converted to this currency code.
| |
− | |- valign="top"
| |
− | | AverageRate
| |
− | | money
| |
− | | not null
| |
− | |
| |
− | | Average exchange rate for the day.
| |
− | |- valign="top"
| |
− | | EndOfDayRate
| |
− | | money
| |
− | | not null
| |
− | |
| |
− | | Final exchange rate for the day.
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (getdate())
| |
− | | Date and time the record was last updated.
| |
− | |}
| |
− |
| |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | PK_CurrencyRate_CurrencyRateID
| |
− | | CurrencyRateID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
| |
− | | Unique
| |
− | | CurrencyRateDate, FromCurrencyCode, ToCurrencyCode
| |
− | |}
| |
− |
| |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Sales.Currency_(table)|Sales.Currency]]
| |
− | | FromCurrencyCode
| |
− | | CurrencyCode
| |
− | |- valign="top"
| |
− | | [[Sales.Currency_(table)|Sales.Currency]]
| |
− | | ToCurrencyCode
| |
− | | CurrencyCode
| |
− | |}
| |
− |
| |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| |
− | | CurrencyRateID
| |
− | | CurrencyRateID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Sales_(schema)|Sales]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
Line 137: |
Line 5: |
| | '''Table | | | '''Table |
| | Sales.CurrencyRate | | | Sales.CurrencyRate |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Currency exchange rates.
| |
| |- | | |- |
| |} | | |} |
Line 150: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description / PK / Index | + | | '''PK |
| + | | '''Index |
| | | |
− | |- valign="top" | + | |- |
| | CurrencyRateID | | | CurrencyRateID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key for CurrencyRate records.<br />PK_CurrencyRate_CurrencyRateID | + | | PK_CurrencyRate_CurrencyRateID |
− | |- valign="top" | + | | |
| + | |- |
| | CurrencyRateDate | | | CurrencyRateDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | | | | |
− | | Date and time the exchange rate was obtained.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | + | | |
− | |- valign="top" | + | | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| + | |- |
| | FromCurrencyCode | | | FromCurrencyCode |
| | nchar(3) | | | nchar(3) |
| | not null | | | not null |
| | | | | |
− | | Exchange rate was converted from this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | + | | |
− | |- valign="top" | + | | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| + | |- |
| | ToCurrencyCode | | | ToCurrencyCode |
| | nchar(3) | | | nchar(3) |
| | not null | | | not null |
| | | | | |
− | | Exchange rate was converted to this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | + | | |
− | |- valign="top" | + | | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| + | |- |
| | AverageRate | | | AverageRate |
| | money | | | money |
| | not null | | | not null |
| | | | | |
− | | Average exchange rate for the day.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | EndOfDayRate | | | EndOfDayRate |
| | money | | | money |
| | not null | | | not null |
| | | | | |
− | | Final exchange rate for the day.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
− | | (GETDATE()) | + | | (getdate()) |
− | | Date and time the record was last updated.<br /> | + | | |
| + | | |
| |} | | |} |
| | | |
Line 225: |
Line 98: |
| | CurrencyRateID | | | CurrencyRateID |
| | CurrencyRateID | | | CurrencyRateID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Sales_(schema)|Sales]]
| |
− |
| |
| |} | | |} |