• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

Currency Table (112)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

Currency MDO list item table. Currency list table

Fields

Name Description Type Null
Currency_id Primary key PK
name The list item String(239)
rank Rank order UShort ●
tooltip Tooltip or other description String(254) ●
deleted 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists UShort ●
rate Exchange rate Double
units Exchange unit scale (0.01, 0.1, 1, 10, 100 etc) Double
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
isoCode ISO currency code, see http://www.xe.com/iso4217.php|String(9)|●

Currency table relationship diagram

Indexes

Fields Types Description
Currency_id PK Clustered, Unique
name String(239) Unique

Relationships

Table Description
AmountClass Amount Class list for SuperOffice Sales Intelligence (Saint) - used to group sales by amounts, into bins (low --> high) called amount classes. More information regarding SuperOffice Sales Intelligence on http://techdoc.superoffice.com
associate Employees, resources and other users - except for External persons
country Country information
CurrencyGroupLink User group link table for Currency, for MDO item hiding
CurrencyHeadingLink Heading link table for Currency, for MDO headers
PriceList List of prices, cached from an ERP system
sale Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.
SaleHist Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.
target_assignment_info Linking associate, company or user group target and other information with target values

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top